DBA Data[Home] [Help]

APPS.AR_AME_CMWF_API dependencies on AR_NOTES

Line 531: l_note_text ar_notes.text%type;

527:
528: l_document_id NUMBER;
529: l_customer_trx_id NUMBER;
530: l_note_id NUMBER;
531: l_note_text ar_notes.text%type;
532: l_responder_user_id wf_users.orig_system_id%TYPE;
533: l_responder_user_name wf_users.name%TYPE;
534: l_responder_display_name wf_users.display_name%TYPE;
535:

Line 4009: l_note_text ar_notes.text%type;

4005: l_customer_trx_id NUMBER;
4006: l_note_id NUMBER;
4007: l_reason_code VARCHAR2(45);
4008: l_total_credit_to_invoice NUMBER;
4009: l_note_text ar_notes.text%type;
4010: /*Bug3206020 Changed comments size from 240 to 1760. */
4011: l_comments VARCHAR2(1760);
4012: l_reason_meaning VARCHAR2(100);
4013:

Line 4016: l_note_text1 ar_notes.text%type;

4012: l_reason_meaning VARCHAR2(100);
4013:
4014: /*7367350*/
4015: l_internal_comment VARCHAR2(1760) DEFAULT NULL;
4016: l_note_text1 ar_notes.text%type;
4017: l_comment_type VARCHAR2(20);
4018:
4019: BEGIN
4020:

Line 4184: l_note_text ar_notes.text%type;

4180: l_document_id NUMBER;
4181: l_customer_trx_id NUMBER;
4182: l_approver_display_name wf_users.display_name%TYPE;
4183: l_note_id NUMBER;
4184: l_note_text ar_notes.text%type;
4185: l_notes wf_item_attribute_values.text_value%TYPE; /*5119049 */
4186:
4187: BEGIN
4188:

Line 4289: l_note_text ar_notes.text%type;

4285: l_document_id NUMBER;
4286: l_customer_trx_id NUMBER;
4287: l_manager_user_name VARCHAR2(100);
4288: l_note_id NUMBER;
4289: l_note_text ar_notes.text%type;
4290: l_notes wf_item_attribute_values.text_value%TYPE; /*5119049 */
4291:
4292: BEGIN
4293:

Line 4396: l_note_text ar_notes.text%type;

4392: l_customer_trx_id NUMBER;
4393: l_receivable_role VARCHAR2(100);
4394: l_role_display_name wf_users.display_name%TYPE;
4395: l_note_id NUMBER;
4396: l_note_text ar_notes.text%type;
4397: l_notes wf_item_attribute_values.text_value%TYPE; /*5119049 */
4398:
4399: BEGIN
4400:

Line 4504: l_note_text ar_notes.text%type;

4500: l_customer_trx_id NUMBER;
4501: l_receivable_role VARCHAR2(100);
4502: l_role_display_name wf_users.display_name%TYPE;
4503: l_note_id NUMBER;
4504: l_note_text ar_notes.text%type;
4505: l_notes wf_item_attribute_values.text_value%TYPE; /*5119049 */
4506:
4507: l_last_updated_by NUMBER;
4508: l_last_update_login NUMBER;

Line 4635: l_note_text ar_notes.text%type;

4631: l_document_id NUMBER;
4632: l_customer_trx_id NUMBER;
4633: l_approver_display_name wf_users.display_name%TYPE;
4634: l_note_id NUMBER;
4635: l_note_text ar_notes.text%type;
4636: l_notes wf_item_attribute_values.text_value%TYPE; /*5119049 */
4637: BEGIN
4638:
4639: ----------------------------------------------------------

Line 4740: l_note_text ar_notes.text%type;

4736: l_document_id NUMBER;
4737: l_customer_trx_id NUMBER;
4738: l_approver_display_name wf_users.display_name%TYPE;
4739: l_note_id NUMBER;
4740: l_note_text ar_notes.text%type;
4741: l_notes wf_item_attribute_values.text_value%TYPE; /*5119049 */
4742:
4743: l_approver_id NUMBER;
4744: l_transaction_type VARCHAR2(30);

Line 4885: l_note_text ar_notes.text%type;

4881: l_document_id NUMBER;
4882: l_customer_trx_id NUMBER;
4883: l_approver_display_name wf_users.display_name%TYPE;
4884: l_note_id NUMBER;
4885: l_note_text ar_notes.text%type;
4886: l_notes wf_item_attribute_values.text_value%TYPE; /*5119049 */
4887:
4888: --Bug 1908252
4889: l_last_updated_by NUMBER;

Line 5051: l_note_text ar_notes.text%type;

5047: l_document_id NUMBER;
5048: l_credit_memo_number VARCHAR2(20);
5049: l_customer_trx_id NUMBER;
5050: l_note_id NUMBER;
5051: l_note_text ar_notes.text%type;
5052: l_notes wf_item_attribute_values.text_value%TYPE; /*5119049 */
5053:
5054: BEGIN
5055: