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_PROC_BATCHES_PKG dependencies on FND_GLOBAL

Line 154: g_created_by NUMBER := fnd_global.user_id;

150: g_calculation CONSTANT VARCHAR2(30) := 'CALCULATION';
151: g_rollup CONSTANT VARCHAR2(30) := 'ROLLUP';
152: g_population CONSTANT VARCHAR2(30) := 'POPULATION';
153: g_creation_date DATE := SYSDATE;
154: g_created_by NUMBER := fnd_global.user_id;
155: g_calc_type VARCHAR2(30);
156: /* ----------------------------------------------------------------------------
157: | Pragmas |
158: ----------------------------------------------------------------------------*/

Line 245: l_user_id NUMBER(15) := fnd_global.user_id;

241: (start_date < l_start_date AND(end_date IS NULL OR l_start_date <= end_date))
242: OR (start_date BETWEEN l_start_date AND l_end_date)
243: );
244:
245: l_user_id NUMBER(15) := fnd_global.user_id;
246: l_resp_id NUMBER(15) := fnd_global.resp_id;
247: l_login_id NUMBER(15) := fnd_global.login_id;
248: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
249: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;

Line 246: l_resp_id NUMBER(15) := fnd_global.resp_id;

242: OR (start_date BETWEEN l_start_date AND l_end_date)
243: );
244:
245: l_user_id NUMBER(15) := fnd_global.user_id;
246: l_resp_id NUMBER(15) := fnd_global.resp_id;
247: l_login_id NUMBER(15) := fnd_global.login_id;
248: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
249: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
250: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;

Line 247: l_login_id NUMBER(15) := fnd_global.login_id;

243: );
244:
245: l_user_id NUMBER(15) := fnd_global.user_id;
246: l_resp_id NUMBER(15) := fnd_global.resp_id;
247: l_login_id NUMBER(15) := fnd_global.login_id;
248: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
249: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
250: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;
251: BEGIN

Line 248: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;

244:
245: l_user_id NUMBER(15) := fnd_global.user_id;
246: l_resp_id NUMBER(15) := fnd_global.resp_id;
247: l_login_id NUMBER(15) := fnd_global.login_id;
248: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
249: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
250: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;
251: BEGIN
252: FOR per IN periods LOOP

Line 249: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;

245: l_user_id NUMBER(15) := fnd_global.user_id;
246: l_resp_id NUMBER(15) := fnd_global.resp_id;
247: l_login_id NUMBER(15) := fnd_global.login_id;
248: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
249: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
250: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;
251: BEGIN
252: FOR per IN periods LOOP
253: FOR dim IN l_dim_hierarchy_csr(per.start_date, per.end_date) LOOP

Line 250: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;

246: l_resp_id NUMBER(15) := fnd_global.resp_id;
247: l_login_id NUMBER(15) := fnd_global.login_id;
248: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
249: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
250: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;
251: BEGIN
252: FOR per IN periods LOOP
253: FOR dim IN l_dim_hierarchy_csr(per.start_date, per.end_date) LOOP
254: x_dim_hierarchy := dim.dim_hierarchy_id;

Line 589: l_user_id NUMBER(15) := fnd_global.user_id;

585: -- The cursor Impacted_Reps looks up the rollup hierarchy of the
586: -- salesrep being calculated
587: -- will call Ram's API to get impacted salesreps
588: l_process_batch_id NUMBER;
589: l_user_id NUMBER(15) := fnd_global.user_id;
590: l_resp_id NUMBER(15) := fnd_global.resp_id;
591: l_login_id NUMBER(15) := fnd_global.login_id;
592: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
593: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;

Line 590: l_resp_id NUMBER(15) := fnd_global.resp_id;

586: -- salesrep being calculated
587: -- will call Ram's API to get impacted salesreps
588: l_process_batch_id NUMBER;
589: l_user_id NUMBER(15) := fnd_global.user_id;
590: l_resp_id NUMBER(15) := fnd_global.resp_id;
591: l_login_id NUMBER(15) := fnd_global.login_id;
592: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
593: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
594: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;

Line 591: l_login_id NUMBER(15) := fnd_global.login_id;

587: -- will call Ram's API to get impacted salesreps
588: l_process_batch_id NUMBER;
589: l_user_id NUMBER(15) := fnd_global.user_id;
590: l_resp_id NUMBER(15) := fnd_global.resp_id;
591: l_login_id NUMBER(15) := fnd_global.login_id;
592: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
593: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
594: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;
595: l_srp_rec cn_rollup_pvt.srp_rec_type;

Line 592: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;

588: l_process_batch_id NUMBER;
589: l_user_id NUMBER(15) := fnd_global.user_id;
590: l_resp_id NUMBER(15) := fnd_global.resp_id;
591: l_login_id NUMBER(15) := fnd_global.login_id;
592: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
593: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
594: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;
595: l_srp_rec cn_rollup_pvt.srp_rec_type;
596: l_descendant_tbl cn_rollup_pvt.srp_tbl_type;

Line 593: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;

589: l_user_id NUMBER(15) := fnd_global.user_id;
590: l_resp_id NUMBER(15) := fnd_global.resp_id;
591: l_login_id NUMBER(15) := fnd_global.login_id;
592: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
593: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
594: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;
595: l_srp_rec cn_rollup_pvt.srp_rec_type;
596: l_descendant_tbl cn_rollup_pvt.srp_tbl_type;
597: l_counter NUMBER;

Line 594: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;

590: l_resp_id NUMBER(15) := fnd_global.resp_id;
591: l_login_id NUMBER(15) := fnd_global.login_id;
592: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
593: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
594: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;
595: l_srp_rec cn_rollup_pvt.srp_rec_type;
596: l_descendant_tbl cn_rollup_pvt.srp_tbl_type;
597: l_counter NUMBER;
598: l_msg_count NUMBER;

Line 850: l_created_by NUMBER := fnd_global.user_id;

846: l_end_date_orig DATE;
847: l_start_date_adj DATE;
848: l_end_date_adj DATE;
849: l_creation_date DATE := SYSDATE;
850: l_created_by NUMBER := fnd_global.user_id;
851: l_affected_all_reps VARCHAR2(1) := 'N';
852: l_invalid_plans_cnt PLS_INTEGER := 0;
853: l_validated_plans_cnt PLS_INTEGER := 0;
854: l_comp_plan_rec cn_comp_plan_pvt.comp_plan_rec_type;

Line 1623: , x_request_id => fnd_global.conc_request_id

1619: cn_message_pkg.begin_batch(
1620: x_process_type => 'CALCULATION'
1621: , x_parent_proc_audit_id => NULL
1622: , x_process_audit_id => x_process_audit_id
1623: , x_request_id => fnd_global.conc_request_id
1624: , p_org_id => l_batch_rec.org_id
1625: );
1626:
1627: UPDATE cn_calc_submission_batches_all

Line 1757: l_user_id NUMBER(15) := fnd_global.user_id;

1753: -- Unlockable batches will remain for the requred number of retries
1754: -- Called just before program completes to purge the table of any remaining
1755: -- unprocessed records that were not procesed during retries.
1756: PROCEDURE void_batches(x_physical_batch_id VARCHAR2) IS
1757: l_user_id NUMBER(15) := fnd_global.user_id;
1758: l_resp_id NUMBER(15) := fnd_global.resp_id;
1759: l_login_id NUMBER(15) := fnd_global.login_id;
1760: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
1761: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;

Line 1758: l_resp_id NUMBER(15) := fnd_global.resp_id;

1754: -- Called just before program completes to purge the table of any remaining
1755: -- unprocessed records that were not procesed during retries.
1756: PROCEDURE void_batches(x_physical_batch_id VARCHAR2) IS
1757: l_user_id NUMBER(15) := fnd_global.user_id;
1758: l_resp_id NUMBER(15) := fnd_global.resp_id;
1759: l_login_id NUMBER(15) := fnd_global.login_id;
1760: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
1761: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
1762: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;

Line 1759: l_login_id NUMBER(15) := fnd_global.login_id;

1755: -- unprocessed records that were not procesed during retries.
1756: PROCEDURE void_batches(x_physical_batch_id VARCHAR2) IS
1757: l_user_id NUMBER(15) := fnd_global.user_id;
1758: l_resp_id NUMBER(15) := fnd_global.resp_id;
1759: l_login_id NUMBER(15) := fnd_global.login_id;
1760: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
1761: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
1762: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;
1763: BEGIN

Line 1760: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;

1756: PROCEDURE void_batches(x_physical_batch_id VARCHAR2) IS
1757: l_user_id NUMBER(15) := fnd_global.user_id;
1758: l_resp_id NUMBER(15) := fnd_global.resp_id;
1759: l_login_id NUMBER(15) := fnd_global.login_id;
1760: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
1761: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
1762: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;
1763: BEGIN
1764: IF x_physical_batch_id IS NULL THEN

Line 1761: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;

1757: l_user_id NUMBER(15) := fnd_global.user_id;
1758: l_resp_id NUMBER(15) := fnd_global.resp_id;
1759: l_login_id NUMBER(15) := fnd_global.login_id;
1760: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
1761: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
1762: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;
1763: BEGIN
1764: IF x_physical_batch_id IS NULL THEN
1765: UPDATE cn_process_batches_all

Line 1762: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;

1758: l_resp_id NUMBER(15) := fnd_global.resp_id;
1759: l_login_id NUMBER(15) := fnd_global.login_id;
1760: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
1761: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
1762: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;
1763: BEGIN
1764: IF x_physical_batch_id IS NULL THEN
1765: UPDATE cn_process_batches_all
1766: SET status_code = 'VOID'

Line 1812: l_user_id NUMBER(15) := fnd_global.user_id;

1808: bids_tbl num_tbl_type;
1809: x_physical_batch_id NUMBER;
1810: l_trx_count NUMBER := 0;
1811: l_srp_count NUMBER := 0;
1812: l_user_id NUMBER(15) := fnd_global.user_id;
1813: l_resp_id NUMBER(15) := fnd_global.resp_id;
1814: l_login_id NUMBER(15) := fnd_global.login_id;
1815: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
1816: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;

Line 1813: l_resp_id NUMBER(15) := fnd_global.resp_id;

1809: x_physical_batch_id NUMBER;
1810: l_trx_count NUMBER := 0;
1811: l_srp_count NUMBER := 0;
1812: l_user_id NUMBER(15) := fnd_global.user_id;
1813: l_resp_id NUMBER(15) := fnd_global.resp_id;
1814: l_login_id NUMBER(15) := fnd_global.login_id;
1815: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
1816: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
1817: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;

Line 1814: l_login_id NUMBER(15) := fnd_global.login_id;

1810: l_trx_count NUMBER := 0;
1811: l_srp_count NUMBER := 0;
1812: l_user_id NUMBER(15) := fnd_global.user_id;
1813: l_resp_id NUMBER(15) := fnd_global.resp_id;
1814: l_login_id NUMBER(15) := fnd_global.login_id;
1815: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
1816: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
1817: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;
1818: l_pre_logical_batch_id NUMBER;

Line 1815: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;

1811: l_srp_count NUMBER := 0;
1812: l_user_id NUMBER(15) := fnd_global.user_id;
1813: l_resp_id NUMBER(15) := fnd_global.resp_id;
1814: l_login_id NUMBER(15) := fnd_global.login_id;
1815: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
1816: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
1817: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;
1818: l_pre_logical_batch_id NUMBER;
1819: l_srp_batch_size_flag VARCHAR2(1);

Line 1816: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;

1812: l_user_id NUMBER(15) := fnd_global.user_id;
1813: l_resp_id NUMBER(15) := fnd_global.resp_id;
1814: l_login_id NUMBER(15) := fnd_global.login_id;
1815: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
1816: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
1817: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;
1818: l_pre_logical_batch_id NUMBER;
1819: l_srp_batch_size_flag VARCHAR2(1);
1820:

Line 1817: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;

1813: l_resp_id NUMBER(15) := fnd_global.resp_id;
1814: l_login_id NUMBER(15) := fnd_global.login_id;
1815: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
1816: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
1817: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;
1818: l_pre_logical_batch_id NUMBER;
1819: l_srp_batch_size_flag VARCHAR2(1);
1820:
1821: CURSOR batch_info IS

Line 2074: l_user_id NUMBER(15) := fnd_global.user_id;

2070: RAISE;
2071: END assign;
2072:
2073: PROCEDURE update_error(x_physical_batch_id NUMBER) IS
2074: l_user_id NUMBER(15) := fnd_global.user_id;
2075: l_resp_id NUMBER(15) := fnd_global.resp_id;
2076: l_login_id NUMBER(15) := fnd_global.login_id;
2077: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
2078: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;

Line 2075: l_resp_id NUMBER(15) := fnd_global.resp_id;

2071: END assign;
2072:
2073: PROCEDURE update_error(x_physical_batch_id NUMBER) IS
2074: l_user_id NUMBER(15) := fnd_global.user_id;
2075: l_resp_id NUMBER(15) := fnd_global.resp_id;
2076: l_login_id NUMBER(15) := fnd_global.login_id;
2077: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
2078: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
2079: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;

Line 2076: l_login_id NUMBER(15) := fnd_global.login_id;

2072:
2073: PROCEDURE update_error(x_physical_batch_id NUMBER) IS
2074: l_user_id NUMBER(15) := fnd_global.user_id;
2075: l_resp_id NUMBER(15) := fnd_global.resp_id;
2076: l_login_id NUMBER(15) := fnd_global.login_id;
2077: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
2078: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
2079: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;
2080: BEGIN

Line 2077: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;

2073: PROCEDURE update_error(x_physical_batch_id NUMBER) IS
2074: l_user_id NUMBER(15) := fnd_global.user_id;
2075: l_resp_id NUMBER(15) := fnd_global.resp_id;
2076: l_login_id NUMBER(15) := fnd_global.login_id;
2077: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
2078: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
2079: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;
2080: BEGIN
2081: -- Giving the batch an 'ERROR' status prevents subsequent

Line 2078: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;

2074: l_user_id NUMBER(15) := fnd_global.user_id;
2075: l_resp_id NUMBER(15) := fnd_global.resp_id;
2076: l_login_id NUMBER(15) := fnd_global.login_id;
2077: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
2078: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
2079: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;
2080: BEGIN
2081: -- Giving the batch an 'ERROR' status prevents subsequent
2082: -- physical processes picking it up.

Line 2079: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;

2075: l_resp_id NUMBER(15) := fnd_global.resp_id;
2076: l_login_id NUMBER(15) := fnd_global.login_id;
2077: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
2078: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
2079: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;
2080: BEGIN
2081: -- Giving the batch an 'ERROR' status prevents subsequent
2082: -- physical processes picking it up.
2083: UPDATE cn_process_batches_all

Line 2181: l_user_id NUMBER(15) := fnd_global.user_id;

2177: l_call_status BOOLEAN;
2178: l_next_process VARCHAR2(30);
2179: l_dummy VARCHAR2(2000);
2180: unfinished BOOLEAN := TRUE;
2181: l_user_id NUMBER(15) := fnd_global.user_id;
2182: l_resp_id NUMBER(15) := fnd_global.resp_id;
2183: l_login_id NUMBER(15) := fnd_global.login_id;
2184: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
2185: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;

Line 2182: l_resp_id NUMBER(15) := fnd_global.resp_id;

2178: l_next_process VARCHAR2(30);
2179: l_dummy VARCHAR2(2000);
2180: unfinished BOOLEAN := TRUE;
2181: l_user_id NUMBER(15) := fnd_global.user_id;
2182: l_resp_id NUMBER(15) := fnd_global.resp_id;
2183: l_login_id NUMBER(15) := fnd_global.login_id;
2184: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
2185: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
2186: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;

Line 2183: l_login_id NUMBER(15) := fnd_global.login_id;

2179: l_dummy VARCHAR2(2000);
2180: unfinished BOOLEAN := TRUE;
2181: l_user_id NUMBER(15) := fnd_global.user_id;
2182: l_resp_id NUMBER(15) := fnd_global.resp_id;
2183: l_login_id NUMBER(15) := fnd_global.login_id;
2184: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
2185: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
2186: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;
2187: debug_v NUMBER;

Line 2184: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;

2180: unfinished BOOLEAN := TRUE;
2181: l_user_id NUMBER(15) := fnd_global.user_id;
2182: l_resp_id NUMBER(15) := fnd_global.resp_id;
2183: l_login_id NUMBER(15) := fnd_global.login_id;
2184: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
2185: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
2186: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;
2187: debug_v NUMBER;
2188: l_sleep_time NUMBER := 180;

Line 2185: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;

2181: l_user_id NUMBER(15) := fnd_global.user_id;
2182: l_resp_id NUMBER(15) := fnd_global.resp_id;
2183: l_login_id NUMBER(15) := fnd_global.login_id;
2184: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
2185: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
2186: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;
2187: debug_v NUMBER;
2188: l_sleep_time NUMBER := 180;
2189: l_sleep_time_char VARCHAR2(30);

Line 2186: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;

2182: l_resp_id NUMBER(15) := fnd_global.resp_id;
2183: l_login_id NUMBER(15) := fnd_global.login_id;
2184: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
2185: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
2186: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;
2187: debug_v NUMBER;
2188: l_sleep_time NUMBER := 180;
2189: l_sleep_time_char VARCHAR2(30);
2190: l_failed_request_id NUMBER;

Line 2560: l_user_id NUMBER(15) := fnd_global.user_id;

2556: l_dummy1 VARCHAR2(2000);
2557: l_dummy2 VARCHAR2(500);
2558: l_dummy3 VARCHAR2(500);
2559: unfinished BOOLEAN := TRUE;
2560: l_user_id NUMBER(15) := fnd_global.user_id;
2561: l_resp_id NUMBER(15) := fnd_global.resp_id;
2562: l_login_id NUMBER(15) := fnd_global.login_id;
2563: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
2564: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;

Line 2561: l_resp_id NUMBER(15) := fnd_global.resp_id;

2557: l_dummy2 VARCHAR2(500);
2558: l_dummy3 VARCHAR2(500);
2559: unfinished BOOLEAN := TRUE;
2560: l_user_id NUMBER(15) := fnd_global.user_id;
2561: l_resp_id NUMBER(15) := fnd_global.resp_id;
2562: l_login_id NUMBER(15) := fnd_global.login_id;
2563: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
2564: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
2565: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;

Line 2562: l_login_id NUMBER(15) := fnd_global.login_id;

2558: l_dummy3 VARCHAR2(500);
2559: unfinished BOOLEAN := TRUE;
2560: l_user_id NUMBER(15) := fnd_global.user_id;
2561: l_resp_id NUMBER(15) := fnd_global.resp_id;
2562: l_login_id NUMBER(15) := fnd_global.login_id;
2563: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
2564: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
2565: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;
2566: l_sleep_time_char VARCHAR2(30);

Line 2563: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;

2559: unfinished BOOLEAN := TRUE;
2560: l_user_id NUMBER(15) := fnd_global.user_id;
2561: l_resp_id NUMBER(15) := fnd_global.resp_id;
2562: l_login_id NUMBER(15) := fnd_global.login_id;
2563: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
2564: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
2565: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;
2566: l_sleep_time_char VARCHAR2(30);
2567: l_sleep_time NUMBER := 180;

Line 2564: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;

2560: l_user_id NUMBER(15) := fnd_global.user_id;
2561: l_resp_id NUMBER(15) := fnd_global.resp_id;
2562: l_login_id NUMBER(15) := fnd_global.login_id;
2563: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
2564: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
2565: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;
2566: l_sleep_time_char VARCHAR2(30);
2567: l_sleep_time NUMBER := 180;
2568: l_failed_request_id NUMBER;

Line 2565: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;

2561: l_resp_id NUMBER(15) := fnd_global.resp_id;
2562: l_login_id NUMBER(15) := fnd_global.login_id;
2563: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
2564: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
2565: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;
2566: l_sleep_time_char VARCHAR2(30);
2567: l_sleep_time NUMBER := 180;
2568: l_failed_request_id NUMBER;
2569: g_first_run VARCHAR2(1) := 'Y';

Line 3107: , x_request_id => fnd_global.conc_request_id

3103: cn_message_pkg.begin_batch(
3104: x_process_type => 'CALCULATION'
3105: , x_parent_proc_audit_id => l_process_audit_id
3106: , x_process_audit_id => l_process_audit_id
3107: , x_request_id => fnd_global.conc_request_id
3108: , p_org_id => l_org_id
3109: );
3110: fnd_file.put_line(fnd_file.LOG, 'Beginning of calculate_batch...');
3111: cn_message_pkg.DEBUG('Beginning of calculate_batch...');

Line 3506: l_request_id := fnd_global.conc_request_id;

3502: INTO l_org_id
3503: FROM cn_process_batches_all
3504: WHERE physical_batch_id = p_physical_batch_id AND ROWNUM = 1;
3505:
3506: l_request_id := fnd_global.conc_request_id;
3507:
3508: IF l_request_id <> -1 THEN
3509: cn_message_pkg.begin_batch(
3510: x_process_type => 'CALCULATION'

Line 3513: , x_request_id => fnd_global.conc_request_id

3509: cn_message_pkg.begin_batch(
3510: x_process_type => 'CALCULATION'
3511: , x_parent_proc_audit_id => p_parent_proc_audit_id
3512: , x_process_audit_id => l_process_audit_id
3513: , x_request_id => fnd_global.conc_request_id
3514: , p_org_id => l_org_id
3515: );
3516: END IF;
3517:

Line 3907: l_request_id := fnd_global.conc_request_id;

3903: l_msg_data VARCHAR2(2000);
3904: l_ledger_je_batch cn_calc_subledger_pvt.je_batch_rec_type;
3905: l_ledger_je_batch_id NUMBER(15);
3906: BEGIN
3907: l_request_id := fnd_global.conc_request_id;
3908: g_logical_process := p_process_name;
3909: g_logical_batch_id := p_logical_batch_id;
3910:
3911: SELECT calc_type

Line 3928: , x_request_id => fnd_global.conc_request_id

3924: cn_message_pkg.begin_batch(
3925: x_process_type => 'CALCULATION'
3926: , x_parent_proc_audit_id => p_parent_proc_audit_id
3927: , x_process_audit_id => l_process_audit_id
3928: , x_request_id => fnd_global.conc_request_id
3929: , p_org_id => g_org_id
3930: );
3931: END IF;
3932:

Line 4082: , x_request_id => fnd_global.conc_request_id

4078: cn_message_pkg.begin_batch(
4079: x_process_type => 'CALCULATION'
4080: , x_parent_proc_audit_id => NULL
4081: , x_process_audit_id => x_process_audit_id
4082: , x_request_id => fnd_global.conc_request_id
4083: , p_org_id => g_org_id
4084: );
4085:
4086: UPDATE cn_calc_submission_batches_all

Line 4122: IF (p_concurrent_flag = 'N' OR(p_concurrent_flag = 'Y' AND fnd_global.conc_program_id <> -1)) THEN

4118: , 'Before calling procedure processor.'
4119: );
4120: END IF;
4121:
4122: IF (p_concurrent_flag = 'N' OR(p_concurrent_flag = 'Y' AND fnd_global.conc_program_id <> -1)) THEN
4123: cn_message_pkg.DEBUG('Start processing transactions (non concurrent calculation)');
4124: cn_proc_batches_pkg.processor(
4125: l_dummy
4126: , l_temp