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.CN_SCA_INTERFACE_MAP_PVT dependencies on CN_SCA_HEADERS_INTERFACE

Line 545: -- Variables for CN_SCA_HEADERS_INTERFACE.SCA_TRX_TYPE

541: -- For Compiled Dynamic Generated Mapping Package Status
542: ------++
543: -- l_compile_status VARCHAR2(20);
544: ------++
545: -- Variables for CN_SCA_HEADERS_INTERFACE.SCA_TRX_TYPE
546: ------++
547: l_trx_type cn_sca_headers_interface.source_type%TYPE;
548: ------++
549: -- FOR CN_SCA_HEADERS_INTERFACE.TRANSACTION_SOURCE

Line 547: l_trx_type cn_sca_headers_interface.source_type%TYPE;

543: -- l_compile_status VARCHAR2(20);
544: ------++
545: -- Variables for CN_SCA_HEADERS_INTERFACE.SCA_TRX_TYPE
546: ------++
547: l_trx_type cn_sca_headers_interface.source_type%TYPE;
548: ------++
549: -- FOR CN_SCA_HEADERS_INTERFACE.TRANSACTION_SOURCE
550: ------++
551: l_trx_source VARCHAR2(10) := '''CN''';

Line 549: -- FOR CN_SCA_HEADERS_INTERFACE.TRANSACTION_SOURCE

545: -- Variables for CN_SCA_HEADERS_INTERFACE.SCA_TRX_TYPE
546: ------++
547: l_trx_type cn_sca_headers_interface.source_type%TYPE;
548: ------++
549: -- FOR CN_SCA_HEADERS_INTERFACE.TRANSACTION_SOURCE
550: ------++
551: l_trx_source VARCHAR2(10) := '''CN''';
552: ------++
553: -- List of arguments for MAP API.

Line 1762: cn_utils.appendcr(l_body_code,' l_trx_type cn_sca_headers_interface.source_type%TYPE;');

1758: cn_utils.appendcr(l_body_code,'-- To store values for start_id and end_id of CN_SCA_PROCESS_BATCHES');
1759: cn_utils.appendcr(l_body_code,'------+');
1760: cn_utils.appendcr(l_body_code,' l_start_id cn_sca_process_batches.start_id%TYPE;');
1761: cn_utils.appendcr(l_body_code,' l_end_id cn_sca_process_batches.end_id%TYPE;');
1762: cn_utils.appendcr(l_body_code,' l_trx_type cn_sca_headers_interface.source_type%TYPE;');
1763:
1764: cn_utils.appendcr(l_body_code,' l_return_status VARCHAR2(50);');
1765: cn_utils.appendcr(l_body_code,' l_msg_count NUMBER;');
1766: cn_utils.appendcr(l_body_code,' l_msg_data VARCHAR2(2000);');

Line 1783: cn_utils.appendcr(l_body_code,' -- Variable Declarations To Hold Values Of Rows Inserted into CN_SCA_HEADERS_INTERFACE,');

1779: cn_utils.appendcr(l_body_code,' l_inv_dist_recs NUMBER := 0;');
1780: cn_utils.appendcr(l_body_code,' l_ord_rev_recs NUMBER := 0;');
1781: cn_utils.appendcr(l_body_code,' l_inv_rev_recs NUMBER := 0;');
1782: cn_utils.appendcr(l_body_code,' -----+');
1783: cn_utils.appendcr(l_body_code,' -- Variable Declarations To Hold Values Of Rows Inserted into CN_SCA_HEADERS_INTERFACE,');
1784: cn_utils.appendcr(l_body_code,' -- CN_SCA_LINES_INTERFACE And Rows Updated Into CN_COMM_LINES_API For Each ORDER and/or INVOICE');
1785: cn_utils.appendcr(l_body_code,' -----+');
1786:
1787: cn_utils.appendcr(l_body_code,' l_ord_ccla_recs NUMBER := 0;');

Line 1831: cn_utils.appendcr(l_body_code,' cn_sca_headers_interface cshi');

1827: cn_utils.appendcr(l_body_code,' ccla.comm_lines_api_id,');
1828: cn_utils.appendcr(l_body_code,' ccla.object_version_number');
1829: cn_utils.appendcr(l_body_code,' FROM cn_comm_lines_api ccla,');
1830: cn_utils.appendcr(l_body_code,' jtf_rs_salesreps jrs,');
1831: cn_utils.appendcr(l_body_code,' cn_sca_headers_interface cshi');
1832: cn_utils.appendcr(l_body_code,' WHERE (ccla.salesrep_id = jrs.salesrep_id)');
1833: cn_utils.appendcr(l_body_code,' AND (ccla.load_status = ''UNLOADED'')');
1834: cn_utils.appendcr(l_body_code,' AND (order_number IS NOT NULL)');
1835: cn_utils.appendcr(l_body_code,' AND (ccla.org_id = p_org_id)');

Line 1908: cn_utils.appendcr(l_body_code,' cn_sca_headers_interface cshi');

1904: cn_utils.appendcr(l_body_code,' ccla.comm_lines_api_id,');
1905: cn_utils.appendcr(l_body_code,' ccla.object_version_number');
1906: cn_utils.appendcr(l_body_code,' FROM cn_comm_lines_api ccla,');
1907: cn_utils.appendcr(l_body_code,' jtf_rs_salesreps jrs,');
1908: cn_utils.appendcr(l_body_code,' cn_sca_headers_interface cshi');
1909: cn_utils.appendcr(l_body_code,' WHERE (ccla.salesrep_id = jrs.salesrep_id)');
1910: cn_utils.appendcr(l_body_code,' AND (ccla.load_status = ''UNLOADED'')');
1911: cn_utils.appendcr(l_body_code,' AND (invoice_number IS NOT NULL)');
1912: cn_utils.appendcr(l_body_code,' AND (ccla.org_id = p_org_id)');

Line 1983: cn_utils.appendcr(l_body_code,' TABLE OF cn_sca_headers_interface.sca_headers_interface_id%TYPE');

1979: cn_utils.appendcr(l_body_code,' api_id ccla_id_tbl);');
1980: cn_utils.appendcr(l_body_code,' sca_head_inv_var sca_head_inv_rec;');
1981:
1982: cn_utils.appendcr(l_body_code,' TYPE cshi_id_tbl IS');
1983: cn_utils.appendcr(l_body_code,' TABLE OF cn_sca_headers_interface.sca_headers_interface_id%TYPE');
1984: cn_utils.appendcr(l_body_code,' INDEX BY BINARY_INTEGER;');
1985:
1986: cn_utils.appendcr(l_body_code,' TYPE jrs_rs_id_tbl IS');
1987: cn_utils.appendcr(l_body_code,' TABLE OF jtf_rs_salesreps.resource_id%TYPE');

Line 2168: cn_utils.appendcr(l_body_code,' INSERT INTO cn_sca_headers_interface');

2164: cn_utils.appendcr(l_body_code,' l_ord_cshi_recs := sca_head_ord_var.api_id.COUNT;');
2165:
2166: cn_utils.appendcr(l_body_code,' l_upd_ccla := ''Y'';');
2167: cn_utils.appendcr(l_body_code,' FORALL i IN sca_head_ord_var.ord_num.FIRST..sca_head_ord_var.ord_num.LAST');
2168: cn_utils.appendcr(l_body_code,' INSERT INTO cn_sca_headers_interface');
2169: cn_utils.appendcr(l_body_code,' (sca_headers_interface_id, transaction_source, source_type,');
2170: cn_utils.appendcr(l_body_code,' source_id, source_line_id, transaction_amount,');
2171: cn_utils.appendcr(l_body_code,' object_version_number, processed_date, process_status, transaction_status,');
2172: cn_utils.appendcr(l_body_code,' created_by, creation_Date, org_id,');

Line 2178: cn_utils.appendcr(l_body_code,' cn_sca_headers_interface_s.NEXTVAL, ''CN'' ,''ORD'',');

2174: split_long_sql(l_body_code,l_src_column_name(l_loop_cntr3),'SELECT');
2175: cn_utils.appendcr(l_body_code,')');
2176:
2177: cn_utils.appendcr(l_body_code,' SELECT');
2178: cn_utils.appendcr(l_body_code,' cn_sca_headers_interface_s.NEXTVAL, ''CN'' ,''ORD'',');
2179: cn_utils.appendcr(l_body_code,' order_number, line_number, sca_head_ord_var.amt_sum(i),');
2180: cn_utils.appendcr(l_body_code,' object_version_number, processed_date, ''SCA_UNPROCESSED'' ,''SCA_UNPROCESSED'' ,');
2181: cn_utils.appendcr(l_body_code,' '||l_login_id||', SYSDATE, org_id,');
2182:

Line 2258: cn_utils.appendcr(l_body_code,' INSERT INTO cn_sca_headers_interface');

2254: cn_utils.appendcr(l_body_code,' l_inv_cshi_recs := sca_head_inv_var.api_id.COUNT;');
2255:
2256: cn_utils.appendcr(l_body_code,' l_upd_ccla := ''Y'';');
2257: cn_utils.appendcr(l_body_code,' FORALL i IN sca_head_inv_var.inv_num.FIRST..sca_head_inv_var.inv_num.LAST');
2258: cn_utils.appendcr(l_body_code,' INSERT INTO cn_sca_headers_interface');
2259: cn_utils.appendcr(l_body_code,' (sca_headers_interface_id, transaction_source, source_type,');
2260: cn_utils.appendcr(l_body_code,' source_id, source_line_id, transaction_amount,');
2261: cn_utils.appendcr(l_body_code,' object_version_number, processed_date, process_status, transaction_status,');
2262: cn_utils.appendcr(l_body_code,' created_by, creation_Date, org_id,');

Line 2268: cn_utils.appendcr(l_body_code,' cn_sca_headers_interface_s.NEXTVAL, ''CN'' ,''INV'',');

2264: split_long_sql(l_body_code,l_src_column_name(l_loop_cntr3),'SELECT');
2265: cn_utils.appendcr(l_body_code,')');
2266:
2267: cn_utils.appendcr(l_body_code,' SELECT');
2268: cn_utils.appendcr(l_body_code,' cn_sca_headers_interface_s.NEXTVAL, ''CN'' ,''INV'',');
2269: cn_utils.appendcr(l_body_code,' invoice_number, line_number, sca_head_inv_var.amt_sum(i),');
2270: cn_utils.appendcr(l_body_code,' object_version_number, processed_date, ''SCA_UNPROCESSED'' ,''SCA_UNPROCESSED'' ,');
2271: cn_utils.appendcr(l_body_code,' '||l_login_id||', SYSDATE, org_id,');
2272:

Line 2358: cn_utils.appendcr(l_body_code,' debugmsg(''CN_SCA_HEADERS_INTERFACE*| ORDER*****************|''||nvl(l_ord_cshi_recs,0));');

2354:
2355: cn_utils.appendcr(l_body_code,' debugmsg(''-------------------------|-----------------------|---------------'');');
2356: cn_utils.appendcr(l_body_code,' debugmsg(''RECORDS INSERTED INTO****|***TRANSACTION TYPE****|****#OF RECORDS'');');
2357: cn_utils.appendcr(l_body_code,' debugmsg(''-------------------------|-----------------------|---------------'');');
2358: cn_utils.appendcr(l_body_code,' debugmsg(''CN_SCA_HEADERS_INTERFACE*| ORDER*****************|''||nvl(l_ord_cshi_recs,0));');
2359: cn_utils.appendcr(l_body_code,' debugmsg(''CN_SCA_LINES_INTERFACE***| ORDER*****************|''||nvl(l_ord_csli_recs,0));');
2360: cn_utils.appendcr(l_body_code,' debugmsg(''CN_SCA_HEADERS_INTERFACE*| INVOICE***************|''||nvl(l_inv_cshi_recs,0));');
2361: cn_utils.appendcr(l_body_code,' debugmsg(''CN_SCA_LINES_INTERFACE***| INVOICE***************|''||nvl(l_inv_csli_recs,0));');
2362: cn_utils.appendcr(l_body_code,' debugmsg(''-------------------------|-----------------------|---------------'');');

Line 2360: cn_utils.appendcr(l_body_code,' debugmsg(''CN_SCA_HEADERS_INTERFACE*| INVOICE***************|''||nvl(l_inv_cshi_recs,0));');

2356: cn_utils.appendcr(l_body_code,' debugmsg(''RECORDS INSERTED INTO****|***TRANSACTION TYPE****|****#OF RECORDS'');');
2357: cn_utils.appendcr(l_body_code,' debugmsg(''-------------------------|-----------------------|---------------'');');
2358: cn_utils.appendcr(l_body_code,' debugmsg(''CN_SCA_HEADERS_INTERFACE*| ORDER*****************|''||nvl(l_ord_cshi_recs,0));');
2359: cn_utils.appendcr(l_body_code,' debugmsg(''CN_SCA_LINES_INTERFACE***| ORDER*****************|''||nvl(l_ord_csli_recs,0));');
2360: cn_utils.appendcr(l_body_code,' debugmsg(''CN_SCA_HEADERS_INTERFACE*| INVOICE***************|''||nvl(l_inv_cshi_recs,0));');
2361: cn_utils.appendcr(l_body_code,' debugmsg(''CN_SCA_LINES_INTERFACE***| INVOICE***************|''||nvl(l_inv_csli_recs,0));');
2362: cn_utils.appendcr(l_body_code,' debugmsg(''-------------------------|-----------------------|---------------'');');
2363:
2364: cn_utils.appendcr(l_body_code,' debugmsg(''RECORDS UPDATED IN CN_COMM_LINES_INTERFACE WITH SCA_PENDING STATUS'');');