APPS.AR_AME_CMWF_API dependencies on AR_NOTES

Line 529: l_note_text ar_notes.text%type;

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

Line 3909: l_note_text ar_notes.text%type;

3905: l_customer_trx_id NUMBER;
3906: l_note_id NUMBER;
3907: l_reason_code VARCHAR2(45);
3908: l_total_credit_to_invoice NUMBER;
3909: l_note_text ar_notes.text%type;
3910: /*Bug3206020 Changed comments size from 240 to 1760. */
3911: l_comments VARCHAR2(1760);
3912: l_reason_meaning VARCHAR2(100);
3913:

Line 3916: l_note_text1 ar_notes.text%type;

3912: l_reason_meaning VARCHAR2(100);
3913:
3914: /*7367350*/
3915: l_internal_comment VARCHAR2(1760) DEFAULT NULL;
3916: l_note_text1 ar_notes.text%type;
3917: l_comment_type VARCHAR2(20);
3918:
3919: BEGIN
3920:

Line 4084: l_note_text ar_notes.text%type;

4080: l_document_id NUMBER;
4081: l_customer_trx_id NUMBER;
4082: l_approver_display_name wf_users.display_name%TYPE;
4083: l_note_id NUMBER;
4084: l_note_text ar_notes.text%type;
4085: l_notes wf_item_attribute_values.text_value%TYPE; /*5119049 */
4086:
4087: BEGIN
4088:

Line 4189: l_note_text ar_notes.text%type;

4185: l_document_id NUMBER;
4186: l_customer_trx_id NUMBER;
4187: l_manager_user_name VARCHAR2(100);
4188: l_note_id NUMBER;
4189: l_note_text ar_notes.text%type;
4190: l_notes wf_item_attribute_values.text_value%TYPE; /*5119049 */
4191:
4192: BEGIN
4193:

Line 4296: l_note_text ar_notes.text%type;

4292: l_customer_trx_id NUMBER;
4293: l_receivable_role VARCHAR2(100);
4294: l_role_display_name wf_users.display_name%TYPE;
4295: l_note_id NUMBER;
4296: l_note_text ar_notes.text%type;
4297: l_notes wf_item_attribute_values.text_value%TYPE; /*5119049 */
4298:
4299: BEGIN
4300:

Line 4404: l_note_text ar_notes.text%type;

4400: l_customer_trx_id NUMBER;
4401: l_receivable_role VARCHAR2(100);
4402: l_role_display_name wf_users.display_name%TYPE;
4403: l_note_id NUMBER;
4404: l_note_text ar_notes.text%type;
4405: l_notes wf_item_attribute_values.text_value%TYPE; /*5119049 */
4406:
4407: l_last_updated_by NUMBER;
4408: l_last_update_login NUMBER;

Line 4535: l_note_text ar_notes.text%type;

4531: l_document_id NUMBER;
4532: l_customer_trx_id NUMBER;
4533: l_approver_display_name wf_users.display_name%TYPE;
4534: l_note_id NUMBER;
4535: l_note_text ar_notes.text%type;
4536: l_notes wf_item_attribute_values.text_value%TYPE; /*5119049 */
4537: BEGIN
4538:
4539: ----------------------------------------------------------

Line 4640: l_note_text ar_notes.text%type;

4636: l_document_id NUMBER;
4637: l_customer_trx_id NUMBER;
4638: l_approver_display_name wf_users.display_name%TYPE;
4639: l_note_id NUMBER;
4640: l_note_text ar_notes.text%type;
4641: l_notes wf_item_attribute_values.text_value%TYPE; /*5119049 */
4642:
4643: l_approver_id NUMBER;
4644: l_transaction_type VARCHAR2(30);

Line 4785: l_note_text ar_notes.text%type;

4781: l_document_id NUMBER;
4782: l_customer_trx_id NUMBER;
4783: l_approver_display_name wf_users.display_name%TYPE;
4784: l_note_id NUMBER;
4785: l_note_text ar_notes.text%type;
4786: l_notes wf_item_attribute_values.text_value%TYPE; /*5119049 */
4787:
4788: --Bug 1908252
4789: l_last_updated_by NUMBER;

Line 4951: l_note_text ar_notes.text%type;

4947: l_document_id NUMBER;
4948: l_credit_memo_number VARCHAR2(20);
4949: l_customer_trx_id NUMBER;
4950: l_note_id NUMBER;
4951: l_note_text ar_notes.text%type;
4952: l_notes wf_item_attribute_values.text_value%TYPE; /*5119049 */
4953:
4954: BEGIN
4955: