APPS.CN_SCA_TRX_PROC_PVT dependencies on CN_SCA_LINES_OUTPUT

Line 335: l_lines_output_id cn_sca_lines_output.sca_lines_output_id%TYPE;

331:
332: query_cur rc;
333: i NUMBER;
334: l_header_rec cn_comm_lines_api%ROWTYPE;
335: l_lines_output_id cn_sca_lines_output.sca_lines_output_id%TYPE;
336: l_header_interface_id cn_sca_headers_interface.sca_headers_interface_id%TYPE;
337: l_comm_lines_api_id cn_comm_lines_api.comm_lines_api_id%TYPE;
338: l_source_id cn_sca_headers_interface.source_id%TYPE;
339: l_order_number cn_comm_lines_api.order_number%TYPE;

Line 472: 'select count(1) from cn_sca_headers_interface CSHI, cn_sca_lines_output CSLO ';

468: if (batch_type = 'CSLO') then
469:
470: l_sql_stmt_count :=
471:
472: 'select count(1) from cn_sca_headers_interface CSHI, cn_sca_lines_output CSLO ';
473:
474: l_sql_stmt :=
475:
476: 'where trunc(CSHI.processed_date) between trunc(:p_start_date) and trunc(:p_end_date) ' ||

Line 665: l_sql_stmt_id := 'select CSLO.sca_lines_output_id from cn_sca_headers_interface CSHI, cn_sca_lines_output CSLO ';

661: end if;
662:
663: if (batch_type = 'CSLO') then
664:
665: l_sql_stmt_id := 'select CSLO.sca_lines_output_id from cn_sca_headers_interface CSHI, cn_sca_lines_output CSLO ';
666: l_sql_stmt_id := l_sql_stmt_id || l_sql_stmt;
667:
668: l_sql_stmt_id :=
669:

Line 881: select CSLO.sca_lines_output_id from cn_sca_headers_interface CSHI, cn_sca_lines_output CSLO

877: conc_status BOOLEAN;
878:
879: CURSOR sca_lines_cur (start_id VARCHAR2, end_id VARCHAR2) IS
880:
881: select CSLO.sca_lines_output_id from cn_sca_headers_interface CSHI, cn_sca_lines_output CSLO
882: where CSLO.sca_headers_interface_id = CSHI.sca_headers_interface_id
883: and trunc(CSHI.processed_date) between trunc(p_start_date) and trunc(p_end_date)
884: and CSHI.process_status <> 'SCA_UNPROCESSED'
885: and CSHI.transaction_status = 'SCA_UNPROCESSED'

Line 888: TYPE sca_lines_tbl IS TABLE OF cn_sca_lines_output.sca_lines_output_id%TYPE;

884: and CSHI.process_status <> 'SCA_UNPROCESSED'
885: and CSHI.transaction_status = 'SCA_UNPROCESSED'
886: and CSLO.sca_lines_output_id between start_id and end_id;
887:
888: TYPE sca_lines_tbl IS TABLE OF cn_sca_lines_output.sca_lines_output_id%TYPE;
889: sca_lines sca_lines_tbl;
890:
891: BEGIN
892:

Line 1261: cn_sca_lines_output CSLO, cn_salesreps CS, cn_comm_lines_api CCLA, cn_sca_headers_interface CSHI

1257: CCLA.SPLIT_PCT,
1258: CCLA.SPLIT_status,
1259: ccla.org_id
1260: from
1261: cn_sca_lines_output CSLO, cn_salesreps CS, cn_comm_lines_api CCLA, cn_sca_headers_interface CSHI
1262: where CS.resource_id = CSLO.resource_id -- added org_id join, since one resource can belong to more than one org
1263: and cslo.org_id = cs.org_id
1264: and ccla.org_id = cslo.org_id
1265: and CCLA.comm_lines_api_id = CSLO.source_trx_id

Line 3319: DELETE FROM cn_sca_lines_output

3315: WHERE sca_headers_interface_id = sca_rollback_headers(j);
3316:
3317: FORALL j IN 1..sca_rollback_headers.COUNT
3318:
3319: DELETE FROM cn_sca_lines_output
3320: WHERE sca_headers_interface_id = sca_rollback_headers(j);
3321:
3322: FORALL j IN 1..sca_rollback_headers.COUNT
3323:

Line 3872: DELETE FROM cn_sca_lines_output

3868: debugmsg('Allocation Transfer : Rerun : Deleting all headers and lines for previous SCA');
3869:
3870: FORALL j IN 1..sca_headers_rollback.COUNT
3871:
3872: DELETE FROM cn_sca_lines_output
3873: where sca_headers_interface_id = sca_headers_rollback(j);
3874:
3875: FORALL j IN 1..sca_headers_rollback.COUNT
3876: