eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PON_EMD_AR_INTEGRATION_GRP dependencies on RA_BATCH_SOURCES

Line 152: l_batch_source_id ra_batch_sources.batch_source_id%TYPE := NULL;

148: X_new_trx_number ra_customer_trx.trx_number%TYPE := NULL;
149: X_new_customer_trx_id ra_customer_trx.customer_trx_id%TYPE := NULL;
150: X_new_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%TYPE := NULL;
151: X_new_rowid VARCHAR2(18) := NULL;
152: l_batch_source_id ra_batch_sources.batch_source_id%TYPE := NULL;
153: l_batch_source_name ra_batch_sources.NAME%TYPE := NULL;
154: l_cust_trx_type_id ra_cust_trx_types.cust_trx_type_id%TYPE := NULL;
155: l_cust_trx_type_name ra_cust_trx_types.NAME%TYPE := NULL;
156:

Line 153: l_batch_source_name ra_batch_sources.NAME%TYPE := NULL;

149: X_new_customer_trx_id ra_customer_trx.customer_trx_id%TYPE := NULL;
150: X_new_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%TYPE := NULL;
151: X_new_rowid VARCHAR2(18) := NULL;
152: l_batch_source_id ra_batch_sources.batch_source_id%TYPE := NULL;
153: l_batch_source_name ra_batch_sources.NAME%TYPE := NULL;
154: l_cust_trx_type_id ra_cust_trx_types.cust_trx_type_id%TYPE := NULL;
155: l_cust_trx_type_name ra_cust_trx_types.NAME%TYPE := NULL;
156:
157: x_msg_data VARCHAR2(1000);

Line 1035: l_batch_source_name ra_batch_sources.NAME%TYPE DEFAULT NULL;

1031: l_cm_line_tbl arw_cmreq_cover.Cm_Line_Tbl_Type_Cover := ar_credit_memo_api_pub.cm_line_tbl_type_cover ;
1032: l_skip_workflow_flag VARCHAR2(1) DEFAULT 'N';
1033: l_credit_method_installments ra_customer_trx.credit_method_for_installments%type DEFAULT NULL;
1034: l_credit_method_rules ra_customer_trx.credit_method_for_rules%type DEFAULT NULL;
1035: l_batch_source_name ra_batch_sources.NAME%TYPE DEFAULT NULL;
1036: l_org_id NUMBER DEFAULT NULL;
1037: x_request_id ra_cm_requests.request_id%type;
1038: l_attribute_rec arw_cmreq_cover.pq_attribute_rec_type DEFAULT ar_credit_memo_api_pub.attribute_rec_const;
1039: l_interface_attribute_rec arw_cmreq_cover.pq_interface_rec_type DEFAULT ar_credit_memo_api_pub.interface_rec_const;

Line 1109: FROM ra_batch_sources_all

1105:
1106: BEGIN
1107: SELECT name
1108: INTO l_batch_source_name
1109: FROM ra_batch_sources_all
1110: WHERE batch_source_id = p_in_rec.batch_source_id
1111: AND org_id = l_org_id
1112: AND Trunc(SYSDATE) BETWEEN start_date AND Nvl(end_date,Trunc(SYSDATE+1));
1113: EXCEPTION

Line 4597: l_batch_source_name ra_batch_sources.NAME%TYPE;

4593: l_deposit_trx_name ra_cust_trx_types.name%TYPE;
4594: l_cm_trx_name ra_cust_trx_types.NAME%TYPE;
4595: l_invoice_trx_name ra_cust_trx_types.NAME%TYPE;
4596:
4597: l_batch_source_name ra_batch_sources.NAME%TYPE;
4598: l_batch_source_status ra_batch_sources.STATUS%TYPE;
4599: l_auto_batch_numbering_flag ra_batch_sources.AUTO_BATCH_NUMBERING_FLAG%TYPE;
4600: l_auto_trx_numbering_flag ra_batch_sources.AUTO_TRX_NUMBERING_FLAG%TYPE;
4601: l_batch_source_type ra_batch_sources.BATCH_SOURCE_TYPE%TYPE;

Line 4598: l_batch_source_status ra_batch_sources.STATUS%TYPE;

4594: l_cm_trx_name ra_cust_trx_types.NAME%TYPE;
4595: l_invoice_trx_name ra_cust_trx_types.NAME%TYPE;
4596:
4597: l_batch_source_name ra_batch_sources.NAME%TYPE;
4598: l_batch_source_status ra_batch_sources.STATUS%TYPE;
4599: l_auto_batch_numbering_flag ra_batch_sources.AUTO_BATCH_NUMBERING_FLAG%TYPE;
4600: l_auto_trx_numbering_flag ra_batch_sources.AUTO_TRX_NUMBERING_FLAG%TYPE;
4601: l_batch_source_type ra_batch_sources.BATCH_SOURCE_TYPE%TYPE;
4602: l_allow_dup_trx_num_flag ra_batch_sources.ALLOW_DUPLICATE_TRX_NUM_FLAG%TYPE;

Line 4599: l_auto_batch_numbering_flag ra_batch_sources.AUTO_BATCH_NUMBERING_FLAG%TYPE;

4595: l_invoice_trx_name ra_cust_trx_types.NAME%TYPE;
4596:
4597: l_batch_source_name ra_batch_sources.NAME%TYPE;
4598: l_batch_source_status ra_batch_sources.STATUS%TYPE;
4599: l_auto_batch_numbering_flag ra_batch_sources.AUTO_BATCH_NUMBERING_FLAG%TYPE;
4600: l_auto_trx_numbering_flag ra_batch_sources.AUTO_TRX_NUMBERING_FLAG%TYPE;
4601: l_batch_source_type ra_batch_sources.BATCH_SOURCE_TYPE%TYPE;
4602: l_allow_dup_trx_num_flag ra_batch_sources.ALLOW_DUPLICATE_TRX_NUM_FLAG%TYPE;
4603: l_credit_memo_batch_source_id ra_batch_sources.CREDIT_MEMO_BATCH_SOURCE_ID%TYPE;

Line 4600: l_auto_trx_numbering_flag ra_batch_sources.AUTO_TRX_NUMBERING_FLAG%TYPE;

4596:
4597: l_batch_source_name ra_batch_sources.NAME%TYPE;
4598: l_batch_source_status ra_batch_sources.STATUS%TYPE;
4599: l_auto_batch_numbering_flag ra_batch_sources.AUTO_BATCH_NUMBERING_FLAG%TYPE;
4600: l_auto_trx_numbering_flag ra_batch_sources.AUTO_TRX_NUMBERING_FLAG%TYPE;
4601: l_batch_source_type ra_batch_sources.BATCH_SOURCE_TYPE%TYPE;
4602: l_allow_dup_trx_num_flag ra_batch_sources.ALLOW_DUPLICATE_TRX_NUM_FLAG%TYPE;
4603: l_credit_memo_batch_source_id ra_batch_sources.CREDIT_MEMO_BATCH_SOURCE_ID%TYPE;
4604: l_credit_batch_source_name ra_batch_sources.NAME%TYPE;

Line 4601: l_batch_source_type ra_batch_sources.BATCH_SOURCE_TYPE%TYPE;

4597: l_batch_source_name ra_batch_sources.NAME%TYPE;
4598: l_batch_source_status ra_batch_sources.STATUS%TYPE;
4599: l_auto_batch_numbering_flag ra_batch_sources.AUTO_BATCH_NUMBERING_FLAG%TYPE;
4600: l_auto_trx_numbering_flag ra_batch_sources.AUTO_TRX_NUMBERING_FLAG%TYPE;
4601: l_batch_source_type ra_batch_sources.BATCH_SOURCE_TYPE%TYPE;
4602: l_allow_dup_trx_num_flag ra_batch_sources.ALLOW_DUPLICATE_TRX_NUM_FLAG%TYPE;
4603: l_credit_memo_batch_source_id ra_batch_sources.CREDIT_MEMO_BATCH_SOURCE_ID%TYPE;
4604: l_credit_batch_source_name ra_batch_sources.NAME%TYPE;
4605: l_cr_batch_source_status ra_batch_sources.STATUS%TYPE;

Line 4602: l_allow_dup_trx_num_flag ra_batch_sources.ALLOW_DUPLICATE_TRX_NUM_FLAG%TYPE;

4598: l_batch_source_status ra_batch_sources.STATUS%TYPE;
4599: l_auto_batch_numbering_flag ra_batch_sources.AUTO_BATCH_NUMBERING_FLAG%TYPE;
4600: l_auto_trx_numbering_flag ra_batch_sources.AUTO_TRX_NUMBERING_FLAG%TYPE;
4601: l_batch_source_type ra_batch_sources.BATCH_SOURCE_TYPE%TYPE;
4602: l_allow_dup_trx_num_flag ra_batch_sources.ALLOW_DUPLICATE_TRX_NUM_FLAG%TYPE;
4603: l_credit_memo_batch_source_id ra_batch_sources.CREDIT_MEMO_BATCH_SOURCE_ID%TYPE;
4604: l_credit_batch_source_name ra_batch_sources.NAME%TYPE;
4605: l_cr_batch_source_status ra_batch_sources.STATUS%TYPE;
4606: l_cr_auto_batch_numbering_flag ra_batch_sources.AUTO_BATCH_NUMBERING_FLAG%TYPE;

Line 4603: l_credit_memo_batch_source_id ra_batch_sources.CREDIT_MEMO_BATCH_SOURCE_ID%TYPE;

4599: l_auto_batch_numbering_flag ra_batch_sources.AUTO_BATCH_NUMBERING_FLAG%TYPE;
4600: l_auto_trx_numbering_flag ra_batch_sources.AUTO_TRX_NUMBERING_FLAG%TYPE;
4601: l_batch_source_type ra_batch_sources.BATCH_SOURCE_TYPE%TYPE;
4602: l_allow_dup_trx_num_flag ra_batch_sources.ALLOW_DUPLICATE_TRX_NUM_FLAG%TYPE;
4603: l_credit_memo_batch_source_id ra_batch_sources.CREDIT_MEMO_BATCH_SOURCE_ID%TYPE;
4604: l_credit_batch_source_name ra_batch_sources.NAME%TYPE;
4605: l_cr_batch_source_status ra_batch_sources.STATUS%TYPE;
4606: l_cr_auto_batch_numbering_flag ra_batch_sources.AUTO_BATCH_NUMBERING_FLAG%TYPE;
4607: l_cr_auto_trx_numbering_flag ra_batch_sources.AUTO_TRX_NUMBERING_FLAG%TYPE;

Line 4604: l_credit_batch_source_name ra_batch_sources.NAME%TYPE;

4600: l_auto_trx_numbering_flag ra_batch_sources.AUTO_TRX_NUMBERING_FLAG%TYPE;
4601: l_batch_source_type ra_batch_sources.BATCH_SOURCE_TYPE%TYPE;
4602: l_allow_dup_trx_num_flag ra_batch_sources.ALLOW_DUPLICATE_TRX_NUM_FLAG%TYPE;
4603: l_credit_memo_batch_source_id ra_batch_sources.CREDIT_MEMO_BATCH_SOURCE_ID%TYPE;
4604: l_credit_batch_source_name ra_batch_sources.NAME%TYPE;
4605: l_cr_batch_source_status ra_batch_sources.STATUS%TYPE;
4606: l_cr_auto_batch_numbering_flag ra_batch_sources.AUTO_BATCH_NUMBERING_FLAG%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;

Line 4605: l_cr_batch_source_status ra_batch_sources.STATUS%TYPE;

4601: l_batch_source_type ra_batch_sources.BATCH_SOURCE_TYPE%TYPE;
4602: l_allow_dup_trx_num_flag ra_batch_sources.ALLOW_DUPLICATE_TRX_NUM_FLAG%TYPE;
4603: l_credit_memo_batch_source_id ra_batch_sources.CREDIT_MEMO_BATCH_SOURCE_ID%TYPE;
4604: l_credit_batch_source_name ra_batch_sources.NAME%TYPE;
4605: l_cr_batch_source_status ra_batch_sources.STATUS%TYPE;
4606: l_cr_auto_batch_numbering_flag ra_batch_sources.AUTO_BATCH_NUMBERING_FLAG%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;

Line 4606: l_cr_auto_batch_numbering_flag ra_batch_sources.AUTO_BATCH_NUMBERING_FLAG%TYPE;

4602: l_allow_dup_trx_num_flag ra_batch_sources.ALLOW_DUPLICATE_TRX_NUM_FLAG%TYPE;
4603: l_credit_memo_batch_source_id ra_batch_sources.CREDIT_MEMO_BATCH_SOURCE_ID%TYPE;
4604: l_credit_batch_source_name ra_batch_sources.NAME%TYPE;
4605: l_cr_batch_source_status ra_batch_sources.STATUS%TYPE;
4606: l_cr_auto_batch_numbering_flag ra_batch_sources.AUTO_BATCH_NUMBERING_FLAG%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:

Line 4607: l_cr_auto_trx_numbering_flag ra_batch_sources.AUTO_TRX_NUMBERING_FLAG%TYPE;

4603: l_credit_memo_batch_source_id ra_batch_sources.CREDIT_MEMO_BATCH_SOURCE_ID%TYPE;
4604: l_credit_batch_source_name ra_batch_sources.NAME%TYPE;
4605: l_cr_batch_source_status ra_batch_sources.STATUS%TYPE;
4606: l_cr_auto_batch_numbering_flag ra_batch_sources.AUTO_BATCH_NUMBERING_FLAG%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;

Line 4608: l_cr_batch_source_type ra_batch_sources.BATCH_SOURCE_TYPE%TYPE;

4604: l_credit_batch_source_name ra_batch_sources.NAME%TYPE;
4605: l_cr_batch_source_status ra_batch_sources.STATUS%TYPE;
4606: l_cr_auto_batch_numbering_flag ra_batch_sources.AUTO_BATCH_NUMBERING_FLAG%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;

Line 4609: l_cr_allow_dup_trx_num_flag ra_batch_sources.ALLOW_DUPLICATE_TRX_NUM_FLAG%TYPE;

4605: l_cr_batch_source_status ra_batch_sources.STATUS%TYPE;
4606: l_cr_auto_batch_numbering_flag ra_batch_sources.AUTO_BATCH_NUMBERING_FLAG%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;

Line 4904: FROM RA_BATCH_SOURCES_ALL

4900: l_auto_trx_numbering_flag,
4901: l_batch_source_type,
4902: l_allow_dup_trx_num_flag,
4903: l_credit_memo_batch_source_id
4904: FROM RA_BATCH_SOURCES_ALL
4905: WHERE BATCH_SOURCE_ID = l_ra_batch_source_id
4906: AND ORG_ID = p_org_id;
4907: EXCEPTION
4908: WHEN No_Data_Found THEN

Line 4961: FROM RA_BATCH_SOURCES_ALL

4957: l_cr_auto_batch_numbering_flag,
4958: l_cr_auto_trx_numbering_flag,
4959: l_cr_batch_source_type,
4960: l_cr_allow_dup_trx_num_flag
4961: FROM RA_BATCH_SOURCES_ALL
4962: WHERE BATCH_SOURCE_ID = l_credit_memo_batch_source_id
4963: AND ORG_ID = p_org_id;
4964: EXCEPTION
4965: WHEN No_Data_Found THEN

Line 5536: l_batch_source_name ra_batch_sources.NAME%TYPE := NULL;

5532: p_in_emd_trx IN pon_emd_trx_info_Tbl_Type,
5533: x_return_status OUT NOCOPY VARCHAR2)
5534: IS
5535:
5536: l_batch_source_name ra_batch_sources.NAME%TYPE := NULL;
5537: l_conc_req_id NUMBER;
5538: l_interface_line_id NUMBER;
5539: call_status BOOLEAN;
5540: request_phase VARCHAR2(80);

Line 5601: FROM ra_batch_sources_all

5597:
5598: BEGIN
5599: SELECT name
5600: INTO l_batch_source_name
5601: FROM ra_batch_sources_all
5602: WHERE batch_source_id = p_in_rec.batch_source_id
5603: AND org_id = p_in_rec.org_id
5604: AND Trunc(SYSDATE) BETWEEN start_date AND Nvl(end_date,Trunc(SYSDATE+1));
5605: EXCEPTION