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 470: 'select count(1) from cn_sca_headers_interface CSHI, cn_sca_lines_output CSLO ';

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

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

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

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

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

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

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

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

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

Line 3315: DELETE FROM cn_sca_lines_output

3311: WHERE sca_headers_interface_id = sca_rollback_headers(j);
3312:
3313: FORALL j IN 1..sca_rollback_headers.COUNT
3314:
3315: DELETE FROM cn_sca_lines_output
3316: WHERE sca_headers_interface_id = sca_rollback_headers(j);
3317:
3318: FORALL j IN 1..sca_rollback_headers.COUNT
3319:

Line 3866: DELETE FROM cn_sca_lines_output

3862: debugmsg('Allocation Transfer : Rerun : Deleting all headers and lines for previous SCA');
3863:
3864: FORALL j IN 1..sca_headers_rollback.COUNT
3865:
3866: DELETE FROM cn_sca_lines_output
3867: where sca_headers_interface_id = sca_headers_rollback(j);
3868:
3869: FORALL j IN 1..sca_headers_rollback.COUNT
3870: