DBA Data[Home] [Help]

APPS.ARP_CMREQ_WF dependencies on AR_NOTES

Line 3211: l_note_text ar_notes.text%type;

3207: l_customer_trx_id number;
3208: l_note_id number;
3209: l_reason_code varchar2(45);
3210: l_total_credit_to_invoice number;
3211: l_note_text ar_notes.text%type;
3212: /* Bug 3206020 Changed comments width from 240 to 1760 */
3213: l_comments varchar2(1760);
3214: l_reason_meaning varchar2(100);
3215:

Line 3218: l_note_text1 ar_notes.text%type;

3214: l_reason_meaning varchar2(100);
3215:
3216: /* Bug 7367350 inserting internal notes */
3217: l_internal_comment VARCHAR2(1760) DEFAULT NULL;
3218: l_note_text1 ar_notes.text%type;
3219: l_comment_type VARCHAR2(20);
3220:
3221: begin
3222: -- SetOrgContext (p_item_key);

Line 3371: l_note_text ar_notes.text%type;

3367: l_document_id number;
3368: l_customer_trx_id number;
3369: l_approver_display_name varchar2(100);
3370: l_note_id number;
3371: l_note_text ar_notes.text%type;
3372: l_notes wf_item_attribute_values.text_value%TYPE; /*5119049 */
3373:
3374: begin
3375: -- SetOrgContext (p_item_key);

Line 3476: l_note_text ar_notes.text%type;

3472: l_document_id number;
3473: l_customer_trx_id number;
3474: l_manager_user_name varchar2(100);
3475: l_note_id number;
3476: l_note_text ar_notes.text%type;
3477: l_notes wf_item_attribute_values.text_value%TYPE; /*5119049 */
3478:
3479: begin
3480: -- SetOrgContext (p_item_key);

Line 3576: l_note_text ar_notes.text%type;

3572: l_customer_trx_id number;
3573: l_receivable_role varchar2(100);
3574: l_role_display_name varchar2(240);
3575: l_note_id number;
3576: l_note_text ar_notes.text%type;
3577: l_notes wf_item_attribute_values.text_value%TYPE; /*5119049 */
3578:
3579: begin
3580: -- SetOrgContext (p_item_key);

Line 3677: l_note_text ar_notes.text%type;

3673: l_customer_trx_id number;
3674: l_receivable_role varchar2(100);
3675: l_role_display_name varchar2(240);
3676: l_note_id number;
3677: l_note_text ar_notes.text%type;
3678: l_notes wf_item_attribute_values.text_value%TYPE; /*5119049 */
3679:
3680: /* bug 1908252 */
3681: l_last_updated_by number;

Line 3803: l_note_text ar_notes.text%type;

3799: l_document_id number;
3800: l_customer_trx_id number;
3801: l_approver_display_name varchar2(100);
3802: l_note_id number;
3803: l_note_text ar_notes.text%type;
3804: l_notes wf_item_attribute_values.text_value%TYPE; /*5119049 */
3805:
3806: begin
3807: -- SetOrgContext (p_item_key);

Line 3901: l_note_text ar_notes.text%type;

3897: l_document_id number;
3898: l_customer_trx_id number;
3899: l_approver_display_name varchar2(100);
3900: l_note_id number;
3901: l_note_text ar_notes.text%type;
3902: l_notes wf_item_attribute_values.text_value%TYPE; /*5119049 */
3903:
3904: begin
3905: -- SetOrgContext (p_item_key);

Line 4000: l_note_text ar_notes.text%type;

3996: l_document_id number;
3997: l_customer_trx_id number;
3998: l_approver_display_name varchar2(100);
3999: l_note_id number;
4000: l_note_text ar_notes.text%type;
4001: l_notes wf_item_attribute_values.text_value%TYPE; /*5119049 */
4002:
4003: /* bug 1908252 */
4004: l_last_updated_by number;

Line 4125: l_note_text ar_notes.text%type;

4121: l_document_id number;
4122: l_credit_memo_number varchar2(20);
4123: l_customer_trx_id number;
4124: l_note_id number;
4125: l_note_text ar_notes.text%type;
4126: l_notes wf_item_attribute_values.text_value%TYPE; /*5119049 */
4127:
4128: begin
4129: SetOrgContext (p_item_key);