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 703: debugmsg(batch_type || ': Assign : Insert into CN_SCA_PROCESS_BATCHES ');

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

Line 718: SELECT cn_sca_process_batches_s.NEXTVAL

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

Line 722: insert into CN_SCA_PROCESS_BATCHES

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

Line 772: SELECT cn_sca_process_batches_s.NEXTVAL

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

Line 776: insert into CN_SCA_PROCESS_BATCHES

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

Line 812: SELECT cn_sca_process_batches_s.NEXTVAL

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

Line 816: insert into CN_SCA_PROCESS_BATCHES

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

Line 872: l_start_id cn_sca_process_batches.start_id%TYPE;

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

Line 873: l_end_id cn_sca_process_batches.end_id%TYPE;

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

Line 893: from cn_sca_process_batches

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

Line 1324: l_start_id cn_sca_process_batches.start_id%TYPE;

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

Line 1325: l_end_id cn_sca_process_batches.end_id%TYPE;

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

Line 1336: from cn_sca_process_batches

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

Line 2619: l_batch_type cn_sca_process_batches.type%TYPE;

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

Line 2620: l_start_id cn_sca_process_batches.start_id%TYPE;

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

Line 2621: l_end_id cn_sca_process_batches.end_id%TYPE;

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

Line 2844: from cn_sca_process_batches

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

Line 3415: l_batch_type cn_sca_process_batches.type%TYPE;

3411:
3412: l_sql_stmt VARCHAR2(1000);
3413: l_trx_type VARCHAR2(10);
3414:
3415: l_batch_type cn_sca_process_batches.type%TYPE;
3416: l_start_id cn_sca_process_batches.start_id%TYPE;
3417: l_end_id cn_sca_process_batches.end_id%TYPE;
3418: l_source_id cn_sca_headers_interface.source_id%TYPE;
3419:

Line 3416: l_start_id cn_sca_process_batches.start_id%TYPE;

3412: l_sql_stmt VARCHAR2(1000);
3413: l_trx_type VARCHAR2(10);
3414:
3415: l_batch_type cn_sca_process_batches.type%TYPE;
3416: l_start_id cn_sca_process_batches.start_id%TYPE;
3417: l_end_id cn_sca_process_batches.end_id%TYPE;
3418: l_source_id cn_sca_headers_interface.source_id%TYPE;
3419:
3420: l_adjusted_by VARCHAR2(30);

Line 3417: l_end_id cn_sca_process_batches.end_id%TYPE;

3413: l_trx_type VARCHAR2(10);
3414:
3415: l_batch_type cn_sca_process_batches.type%TYPE;
3416: l_start_id cn_sca_process_batches.start_id%TYPE;
3417: l_end_id cn_sca_process_batches.end_id%TYPE;
3418: l_source_id cn_sca_headers_interface.source_id%TYPE;
3419:
3420: l_adjusted_by VARCHAR2(30);
3421: conc_status boolean;

Line 3429: from cn_sca_process_batches

3425: l_adjusted_by := get_adjusted_by;
3426:
3427: select start_id, end_id, type into
3428: l_start_id, l_end_id, l_batch_type
3429: from cn_sca_process_batches
3430: where sca_process_batch_id = p_physical_batch_id;
3431:
3432: if (l_batch_type = 'SCA_ORD') then
3433: