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_TRX_PROC_PVT dependencies on CN_SCA_PROCESS_BATCHES

Line 70: l_org_id cn_sca_process_batches.org_id%TYPE;

66: ,x_start_date DATE
67: ,x_end_date DATE
68: ,x_request_id IN OUT NOCOPY NUMBER) IS
69:
70: l_org_id cn_sca_process_batches.org_id%TYPE;
71:
72: BEGIN
73:
74: debugmsg('Conc_Submit : x_process = '|| x_process);

Line 81: FROM cn_sca_process_batches

77: debugmsg('Conc_Submit : x_physical_batch_id = '|| x_physical_batch_id);
78:
79: SELECT org_id
80: INTO l_org_id
81: FROM cn_sca_process_batches
82: WHERE sca_process_batch_id = x_physical_batch_id;
83:
84: fnd_request.set_org_id( l_org_id );
85:

Line 166: FROM cn_sca_process_batches

162: -- Get individual physical batch id's for the entire logical batch
163: CURSOR physical_batches IS
164:
165: SELECT distinct sca_process_batch_id
166: FROM cn_sca_process_batches
167: WHERE logical_batch_id = x_logical_batch_id;
168:
169: physical_rec physical_batches%ROWTYPE;
170:

Line 327: l_sca_process_batch_id cn_sca_process_batches.sca_process_batch_id%TYPE;

323: l_sql_stmt_id VARCHAR2(10000);
324: l_sql_stmt_divider VARCHAR2(10000);
325: l_sql_stmt_resource VARCHAR2(10000);
326: l_no_trx BOOLEAN;
327: l_sca_process_batch_id cn_sca_process_batches.sca_process_batch_id%TYPE;
328:
329: TYPE rc IS REF CURSOR;
330: TYPE divider_type IS TABLE OF NUMBER;
331:

Line 341: l_id cn_sca_process_batches.start_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;
340: l_invoice_number cn_comm_lines_api.invoice_number%TYPE;
341: l_id cn_sca_process_batches.start_id%TYPE;
342:
343: l_logical_batch_size NUMBER;
344: l_worker_num NUMBER;
345: l_physical_batch_size NUMBER;

Line 349: l_start_id cn_sca_process_batches.start_id%TYPE;

345: l_physical_batch_size NUMBER;
346: l_divider_size NUMBER;
347: divider divider_type := divider_type();
348: loop_count NUMBER;
349: l_start_id cn_sca_process_batches.start_id%TYPE;
350: l_end_id cn_sca_process_batches.end_id%TYPE;
351:
352: l_user_id NUMBER(15) := fnd_global.user_id;
353: l_login_id NUMBER(15) := fnd_global.login_id;

Line 350: l_end_id cn_sca_process_batches.end_id%TYPE;

346: l_divider_size NUMBER;
347: divider divider_type := divider_type();
348: loop_count NUMBER;
349: l_start_id cn_sca_process_batches.start_id%TYPE;
350: l_end_id cn_sca_process_batches.end_id%TYPE;
351:
352: l_user_id NUMBER(15) := fnd_global.user_id;
353: l_login_id NUMBER(15) := fnd_global.login_id;
354:

Line 705: debugmsg(batch_type || ': Assign : Insert into CN_SCA_PROCESS_BATCHES ');

701: end if;
702:
703: loop_count := 1;
704:
705: debugmsg(batch_type || ': Assign : Insert into CN_SCA_PROCESS_BATCHES ');
706:
707: if (l_physical_batch_size >= 2) then
708:
709: LOOP

Line 720: SELECT cn_sca_process_batches_s.NEXTVAL

716:
717: if ((loop_count mod 2) = 0) then
718: l_end_id := l_id;
719:
720: SELECT cn_sca_process_batches_s.NEXTVAL
721: INTO l_sca_process_batch_id
722: FROM sys.dual;
723:
724: insert into CN_SCA_PROCESS_BATCHES

Line 724: insert into CN_SCA_PROCESS_BATCHES

720: SELECT cn_sca_process_batches_s.NEXTVAL
721: INTO l_sca_process_batch_id
722: FROM sys.dual;
723:
724: insert into CN_SCA_PROCESS_BATCHES
725: ( sca_process_batch_id,
726: start_id,
727: end_id,
728: type,

Line 774: SELECT cn_sca_process_batches_s.NEXTVAL

770:
771: if (loop_count > l_worker_num and l_physical_batch_size = 1) then
772: l_end_id := l_id;
773:
774: SELECT cn_sca_process_batches_s.NEXTVAL
775: INTO l_sca_process_batch_id
776: FROM sys.dual;
777:
778: insert into CN_SCA_PROCESS_BATCHES

Line 778: insert into CN_SCA_PROCESS_BATCHES

774: SELECT cn_sca_process_batches_s.NEXTVAL
775: INTO l_sca_process_batch_id
776: FROM sys.dual;
777:
778: insert into CN_SCA_PROCESS_BATCHES
779: ( sca_process_batch_id,
780: start_id,
781: end_id,
782: type,

Line 814: SELECT cn_sca_process_batches_s.NEXTVAL

810:
811:
812: if (loop_count < l_worker_num or (loop_count = l_worker_num and l_physical_batch_size < 1)) then
813:
814: SELECT cn_sca_process_batches_s.NEXTVAL
815: INTO l_sca_process_batch_id
816: FROM sys.dual;
817:
818: insert into CN_SCA_PROCESS_BATCHES

Line 818: insert into CN_SCA_PROCESS_BATCHES

814: SELECT cn_sca_process_batches_s.NEXTVAL
815: INTO l_sca_process_batch_id
816: FROM sys.dual;
817:
818: insert into CN_SCA_PROCESS_BATCHES
819: ( sca_process_batch_id,
820: start_id,
821: end_id,
822: type,

Line 874: l_start_id cn_sca_process_batches.start_id%TYPE;

870: p_start_date DATE,
871: p_end_date DATE,
872: p_physical_batch_id NUMBER) IS
873:
874: l_start_id cn_sca_process_batches.start_id%TYPE;
875: l_end_id cn_sca_process_batches.end_id%TYPE;
876: l_adjusted_by VARCHAR2(30);
877: conc_status BOOLEAN;
878:

Line 875: l_end_id cn_sca_process_batches.end_id%TYPE;

871: p_end_date DATE,
872: p_physical_batch_id NUMBER) IS
873:
874: l_start_id cn_sca_process_batches.start_id%TYPE;
875: l_end_id cn_sca_process_batches.end_id%TYPE;
876: l_adjusted_by VARCHAR2(30);
877: conc_status BOOLEAN;
878:
879: CURSOR sca_lines_cur (start_id VARCHAR2, end_id VARCHAR2) IS

Line 895: from cn_sca_process_batches

891: BEGIN
892:
893: select start_id, end_id into
894: l_start_id, l_end_id
895: from cn_sca_process_batches
896: where sca_process_batch_id = p_physical_batch_id;
897:
898: debugmsg('Populate results back to API: Creating Transactions ');
899: debugmsg('Populate results back to API: Start ID = ' || l_start_id);

Line 1326: l_start_id cn_sca_process_batches.start_id%TYPE;

1322: sca_lines sca_lines_tbl;
1323: sca_no_rule_lines sca_no_rule_lines_tbl;
1324: sca_not_allocate_lines sca_not_allocate_lines_tbl;
1325:
1326: l_start_id cn_sca_process_batches.start_id%TYPE;
1327: l_end_id cn_sca_process_batches.end_id%TYPE;
1328:
1329: l_adjusted_by VARCHAR2(30);
1330: conc_status BOOLEAN;

Line 1327: l_end_id cn_sca_process_batches.end_id%TYPE;

1323: sca_no_rule_lines sca_no_rule_lines_tbl;
1324: sca_not_allocate_lines sca_not_allocate_lines_tbl;
1325:
1326: l_start_id cn_sca_process_batches.start_id%TYPE;
1327: l_end_id cn_sca_process_batches.end_id%TYPE;
1328:
1329: l_adjusted_by VARCHAR2(30);
1330: conc_status BOOLEAN;
1331:

Line 1338: from cn_sca_process_batches

1334: l_adjusted_by := get_adjusted_by;
1335:
1336: select start_id, end_id into
1337: l_start_id, l_end_id
1338: from cn_sca_process_batches
1339: where sca_process_batch_id = p_physical_batch_id;
1340:
1341: debugmsg('Populate results back to API: Negating Transactions ');
1342: debugmsg('Populate results back to API: Start ID = ' || l_start_id);

Line 2621: l_batch_type cn_sca_process_batches.type%TYPE;

2617: p_start_date DATE,
2618: p_end_date DATE,
2619: p_physical_batch_id NUMBER) IS
2620:
2621: l_batch_type cn_sca_process_batches.type%TYPE;
2622: l_start_id cn_sca_process_batches.start_id%TYPE;
2623: l_end_id cn_sca_process_batches.end_id%TYPE;
2624:
2625: conc_status boolean;

Line 2622: l_start_id cn_sca_process_batches.start_id%TYPE;

2618: p_end_date DATE,
2619: p_physical_batch_id NUMBER) IS
2620:
2621: l_batch_type cn_sca_process_batches.type%TYPE;
2622: l_start_id cn_sca_process_batches.start_id%TYPE;
2623: l_end_id cn_sca_process_batches.end_id%TYPE;
2624:
2625: conc_status boolean;
2626:

Line 2623: l_end_id cn_sca_process_batches.end_id%TYPE;

2619: p_physical_batch_id NUMBER) IS
2620:
2621: l_batch_type cn_sca_process_batches.type%TYPE;
2622: l_start_id cn_sca_process_batches.start_id%TYPE;
2623: l_end_id cn_sca_process_batches.end_id%TYPE;
2624:
2625: conc_status boolean;
2626:
2627: cursor api_adjust_lines_inv_cur (l_start_id VARCHAR2, l_end_id VARCHAR2) IS

Line 2846: from cn_sca_process_batches

2842: l_adjusted_by := get_adjusted_by;
2843:
2844: select start_id, end_id, type into
2845: l_start_id, l_end_id, l_batch_type
2846: from cn_sca_process_batches
2847: where sca_process_batch_id = p_physical_batch_id;
2848:
2849: debugmsg('Check_comm_lines_api_adjusted : Check if the transactions are eligible for SCA');
2850:

Line 3419: l_batch_type cn_sca_process_batches.type%TYPE;

3415:
3416: l_sql_stmt VARCHAR2(1000);
3417: l_trx_type VARCHAR2(10);
3418:
3419: l_batch_type cn_sca_process_batches.type%TYPE;
3420: l_start_id cn_sca_process_batches.start_id%TYPE;
3421: l_end_id cn_sca_process_batches.end_id%TYPE;
3422: l_source_id cn_sca_headers_interface.source_id%TYPE;
3423:

Line 3420: l_start_id cn_sca_process_batches.start_id%TYPE;

3416: l_sql_stmt VARCHAR2(1000);
3417: l_trx_type VARCHAR2(10);
3418:
3419: l_batch_type cn_sca_process_batches.type%TYPE;
3420: l_start_id cn_sca_process_batches.start_id%TYPE;
3421: l_end_id cn_sca_process_batches.end_id%TYPE;
3422: l_source_id cn_sca_headers_interface.source_id%TYPE;
3423:
3424: l_adjusted_by VARCHAR2(30);

Line 3421: l_end_id cn_sca_process_batches.end_id%TYPE;

3417: l_trx_type VARCHAR2(10);
3418:
3419: l_batch_type cn_sca_process_batches.type%TYPE;
3420: l_start_id cn_sca_process_batches.start_id%TYPE;
3421: l_end_id cn_sca_process_batches.end_id%TYPE;
3422: l_source_id cn_sca_headers_interface.source_id%TYPE;
3423:
3424: l_adjusted_by VARCHAR2(30);
3425: conc_status boolean;

Line 3433: from cn_sca_process_batches

3429: l_adjusted_by := get_adjusted_by;
3430:
3431: select start_id, end_id, type into
3432: l_start_id, l_end_id, l_batch_type
3433: from cn_sca_process_batches
3434: where sca_process_batch_id = p_physical_batch_id;
3435:
3436: if (l_batch_type = 'SCA_ORD') then
3437: