DBA Data[Home] [Help]

APPS.PON_EMD_AR_INTEGRATION_GRP dependencies on AR_MEMO_LINES

Line 4611: l_memo_line_name ar_memo_lines.NAME%TYPE;

4607: l_cr_auto_trx_numbering_flag ra_batch_sources.AUTO_TRX_NUMBERING_FLAG%TYPE;
4608: l_cr_batch_source_type ra_batch_sources.BATCH_SOURCE_TYPE%TYPE;
4609: l_cr_allow_dup_trx_num_flag ra_batch_sources.ALLOW_DUPLICATE_TRX_NUM_FLAG%TYPE;
4610:
4611: l_memo_line_name ar_memo_lines.NAME%TYPE;
4612: l_memo_line_type ar_memo_lines.line_type%TYPE;
4613: l_memo_line_start_date ar_memo_lines.start_date%TYPE;
4614: l_memo_line_end_date ar_memo_lines.end_date%TYPE;
4615: l_memo_line_rev_acc ar_memo_lines.gl_id_rev%TYPE;

Line 4612: l_memo_line_type ar_memo_lines.line_type%TYPE;

4608: l_cr_batch_source_type ra_batch_sources.BATCH_SOURCE_TYPE%TYPE;
4609: l_cr_allow_dup_trx_num_flag ra_batch_sources.ALLOW_DUPLICATE_TRX_NUM_FLAG%TYPE;
4610:
4611: l_memo_line_name ar_memo_lines.NAME%TYPE;
4612: l_memo_line_type ar_memo_lines.line_type%TYPE;
4613: l_memo_line_start_date ar_memo_lines.start_date%TYPE;
4614: l_memo_line_end_date ar_memo_lines.end_date%TYPE;
4615: l_memo_line_rev_acc ar_memo_lines.gl_id_rev%TYPE;
4616:

Line 4613: l_memo_line_start_date ar_memo_lines.start_date%TYPE;

4609: l_cr_allow_dup_trx_num_flag ra_batch_sources.ALLOW_DUPLICATE_TRX_NUM_FLAG%TYPE;
4610:
4611: l_memo_line_name ar_memo_lines.NAME%TYPE;
4612: l_memo_line_type ar_memo_lines.line_type%TYPE;
4613: l_memo_line_start_date ar_memo_lines.start_date%TYPE;
4614: l_memo_line_end_date ar_memo_lines.end_date%TYPE;
4615: l_memo_line_rev_acc ar_memo_lines.gl_id_rev%TYPE;
4616:
4617: l_term_name ra_terms_vl.NAME%TYPE;

Line 4614: l_memo_line_end_date ar_memo_lines.end_date%TYPE;

4610:
4611: l_memo_line_name ar_memo_lines.NAME%TYPE;
4612: l_memo_line_type ar_memo_lines.line_type%TYPE;
4613: l_memo_line_start_date ar_memo_lines.start_date%TYPE;
4614: l_memo_line_end_date ar_memo_lines.end_date%TYPE;
4615: l_memo_line_rev_acc ar_memo_lines.gl_id_rev%TYPE;
4616:
4617: l_term_name ra_terms_vl.NAME%TYPE;
4618: l_term_start_date ra_terms_vl.START_DATE_ACTIVE%TYPE;

Line 4615: l_memo_line_rev_acc ar_memo_lines.gl_id_rev%TYPE;

4611: l_memo_line_name ar_memo_lines.NAME%TYPE;
4612: l_memo_line_type ar_memo_lines.line_type%TYPE;
4613: l_memo_line_start_date ar_memo_lines.start_date%TYPE;
4614: l_memo_line_end_date ar_memo_lines.end_date%TYPE;
4615: l_memo_line_rev_acc ar_memo_lines.gl_id_rev%TYPE;
4616:
4617: l_term_name ra_terms_vl.NAME%TYPE;
4618: l_term_start_date ra_terms_vl.START_DATE_ACTIVE%TYPE;
4619: l_term_end_Date ra_terms_vl.END_DATE_ACTIVE%TYPE;

Line 5013: FROM AR_MEMO_LINES_VL

5009: l_memo_line_type,
5010: l_memo_line_start_date,
5011: l_memo_line_end_date,
5012: l_memo_line_rev_acc
5013: FROM AR_MEMO_LINES_VL
5014: WHERE ORG_ID = p_org_id
5015: AND MEMO_LINE_ID = p_memo_line_id;
5016: EXCEPTION
5017: WHEN No_Data_Found THEN

Line 5062: FROM AR_MEMO_LINES_VL

5058: l_memo_line_type,
5059: l_memo_line_start_date,
5060: l_memo_line_end_date,
5061: l_memo_line_rev_acc
5062: FROM AR_MEMO_LINES_VL
5063: WHERE ORG_ID = p_org_id
5064: AND MEMO_LINE_ID = p_memo_line_invoice_id;
5065: EXCEPTION
5066: WHEN No_Data_Found THEN

Line 5555: l_memo_desc ar_memo_lines_all_tl.description%TYPE;

5551: l_deposit_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%TYPE;
5552: l_emd_transactions_info pon_emd_trx_rec;
5553: l_customer_trx_id ra_customer_trx.customer_trx_id%TYPE;
5554: l_trx_number ra_customer_trx.trx_number%TYPE;
5555: l_memo_desc ar_memo_lines_all_tl.description%TYPE;
5556: l_memo_name ar_memo_lines_all_tl.name%TYPE; -- bug 8628651
5557: l_term_name VARCHAR2(25);
5558:
5559: CURSOR int_errors(x_interface_line_id NUMBER, x_org_id number) IS

Line 5556: l_memo_name ar_memo_lines_all_tl.name%TYPE; -- bug 8628651

5552: l_emd_transactions_info pon_emd_trx_rec;
5553: l_customer_trx_id ra_customer_trx.customer_trx_id%TYPE;
5554: l_trx_number ra_customer_trx.trx_number%TYPE;
5555: l_memo_desc ar_memo_lines_all_tl.description%TYPE;
5556: l_memo_name ar_memo_lines_all_tl.name%TYPE; -- bug 8628651
5557: l_term_name VARCHAR2(25);
5558:
5559: CURSOR int_errors(x_interface_line_id NUMBER, x_org_id number) IS
5560: SELECT message_text,invalid_value

Line 5619: FROM AR_MEMO_LINES_VL

5615: SELECT NAME,
5616: DESCRIPTION
5617: INTO l_memo_name,
5618: l_memo_desc
5619: FROM AR_MEMO_LINES_VL
5620: WHERE ORG_ID = p_in_rec.org_id
5621: AND MEMO_LINE_ID = p_in_rec.memo_line_id;
5622: EXCEPTION
5623: WHEN No_Data_Found THEN