DBA Data[Home] [Help]

APPS.ARP_CMREQ_WF dependencies on AR_NOTES

Line 3318: l_note_text ar_notes.text%type;

3314: l_customer_trx_id number;
3315: l_note_id number;
3316: l_reason_code varchar2(45);
3317: l_total_credit_to_invoice number;
3318: l_note_text ar_notes.text%type;
3319: /* Bug 3206020 Changed comments width from 240 to 1760 */
3320: l_comments varchar2(1760);
3321: l_reason_meaning varchar2(100);
3322:

Line 3325: l_note_text1 ar_notes.text%type;

3321: l_reason_meaning varchar2(100);
3322:
3323: /* Bug 7367350 inserting internal notes */
3324: l_internal_comment VARCHAR2(1760) DEFAULT NULL;
3325: l_note_text1 ar_notes.text%type;
3326: l_comment_type VARCHAR2(20);
3327:
3328: begin
3329: -- SetOrgContext (p_item_key);

Line 3478: l_note_text ar_notes.text%type;

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

Line 3583: l_note_text ar_notes.text%type;

3579: l_document_id number;
3580: l_customer_trx_id number;
3581: l_manager_user_name varchar2(100);
3582: l_note_id number;
3583: l_note_text ar_notes.text%type;
3584: l_notes wf_item_attribute_values.text_value%TYPE; /*5119049 */
3585:
3586: begin
3587: -- SetOrgContext (p_item_key);

Line 3683: l_note_text ar_notes.text%type;

3679: l_customer_trx_id number;
3680: l_receivable_role varchar2(100);
3681: l_role_display_name varchar2(240);
3682: l_note_id number;
3683: l_note_text ar_notes.text%type;
3684: l_notes wf_item_attribute_values.text_value%TYPE; /*5119049 */
3685:
3686: begin
3687: -- SetOrgContext (p_item_key);

Line 3784: l_note_text ar_notes.text%type;

3780: l_customer_trx_id number;
3781: l_receivable_role varchar2(100);
3782: l_role_display_name varchar2(240);
3783: l_note_id number;
3784: l_note_text ar_notes.text%type;
3785: l_notes wf_item_attribute_values.text_value%TYPE; /*5119049 */
3786:
3787: /* bug 1908252 */
3788: l_last_updated_by number;

Line 3910: l_note_text ar_notes.text%type;

3906: l_document_id number;
3907: l_customer_trx_id number;
3908: l_approver_display_name varchar2(100);
3909: l_note_id number;
3910: l_note_text ar_notes.text%type;
3911: l_notes wf_item_attribute_values.text_value%TYPE; /*5119049 */
3912:
3913: begin
3914: -- SetOrgContext (p_item_key);

Line 4008: l_note_text ar_notes.text%type;

4004: l_document_id number;
4005: l_customer_trx_id number;
4006: l_approver_display_name varchar2(100);
4007: l_note_id number;
4008: l_note_text ar_notes.text%type;
4009: l_notes wf_item_attribute_values.text_value%TYPE; /*5119049 */
4010:
4011: begin
4012: -- SetOrgContext (p_item_key);

Line 4107: l_note_text ar_notes.text%type;

4103: l_document_id number;
4104: l_customer_trx_id number;
4105: l_approver_display_name varchar2(100);
4106: l_note_id number;
4107: l_note_text ar_notes.text%type;
4108: l_notes wf_item_attribute_values.text_value%TYPE; /*5119049 */
4109:
4110: /* bug 1908252 */
4111: l_last_updated_by number;

Line 4232: l_note_text ar_notes.text%type;

4228: l_document_id number;
4229: l_credit_memo_number varchar2(20);
4230: l_customer_trx_id number;
4231: l_note_id number;
4232: l_note_text ar_notes.text%type;
4233: l_notes wf_item_attribute_values.text_value%TYPE; /*5119049 */
4234:
4235: begin
4236: SetOrgContext (p_item_key);