Hello,

As a fresh SQL user, I'm having trouble implementing a certain functionality in IFSAPP 10. I'm trying to add a PL/SQL block to the user menu (On customer order lines) that will add a record in a table I've created. Currently, I'm using a simple code that works by adding a record with the appropriate key, but I'm struggling to allow the user to input additional data such as comments or planned date. I've also written a version of the code that requires entering all the data manually. Unfortunately, I can't seem to integrate them. In the reports I've created, I use '&' to allow for manual input of values. While running report user gets pop-up window with required fields. However, this method doesn't seem to work here.

DECLARE
    now_            DATE            := TRUNC(SYSDATE);
--    planned_        DATE            := TRUNC(&Data_wykonania);
    user_id_        VARCHAR2(30)    := NULL;
    note_           VARCHAR2(32000) := '&Additional_Data'; -- Prompt user for additional data
    p0_             VARCHAR2(32000) := NULL;
    p1_             VARCHAR2(32000) := NULL;
    p2_             VARCHAR2(32000) := NULL;
    p3_             VARCHAR2(32000) := NULL;
    p4_             VARCHAR2(32000) := 'DO';

BEGIN
    -- Get user_id
    SELECT ifsapp.FND_SESSION_API.Get_Fnd_User() INTO user_id_ FROM dual;

    IFSAPP.Client_Sys.Add_To_Attr('CF$_ORDER_NO',        &ORDER_NO,      p3_);
    IFSAPP.Client_Sys.Add_To_Attr('CF$_LINE_NO',        &LINE_NO,       p3_);
    IFSAPP.Client_Sys.Add_To_Attr('CF$_REL_NO',            &REL_NO,        p3_);
    IFSAPP.Client_Sys.Add_To_Attr('CF$_LINE_ITEM_NO',    &LINE_ITEM_NO,  p3_);
    IFSAPP.Client_Sys.Add_To_Attr('CF$_CREATED_BY',        user_id_,       p3_);
    IFSAPP.Client_Sys.Add_To_Attr('CF$_DATE_CREATED',    now_,           p3_);
    IFSAPP.Client_Sys.Add_To_Attr('CF$_NOTE',            note_,            p3_);
--    IFSAPP.Client_Sys.Add_To_Attr('CF$_PLANNED_DUE_DATE',planned_,        p3_);

    -- Insert data
    IFSAPP.OPOZNIENIA_POZAPRODUKCYJNE_CLP.NEW__(p0_, p1_, p2_, p3_, p4_);
END;

We generally need to track additional delays on orders resulting from tasks performed by external companies on our products. We also want to have them all in one place. In addition to the current issue, I will add a column that will show the latest date delaying the departure of our product on customer order lines for the logistics department.

To summarize, I want the code to gather additional data from user, similar to when testing in the editor and simultaneously, to fetch data from the line with order_no, line_no etc.