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 CN_CALC_SUBMISSION_BATCHES_ALL

Line 228: FROM cn_calc_submission_batches_all

224: PROCEDURE flood_rev_classes IS
225: CURSOR periods IS
226: SELECT start_date
227: , end_date
228: FROM cn_calc_submission_batches_all
229: WHERE logical_batch_id = g_logical_batch_id;
230:
231: x_dim_hierarchy NUMBER;
232:

Line 606: FROM cn_calc_submission_batches_all

602: g_logical_batch_id := p_logical_batch_id;
603:
604: SELECT org_id
605: INTO g_org_id
606: FROM cn_calc_submission_batches_all
607: WHERE logical_batch_id = p_logical_batch_id;
608:
609: IF p_entire_hierarchy = 'Y' THEN
610: l_srp_rec.salesrep_id := p_salesrep_id;

Line 830: UPDATE cn_calc_submission_batches_all

826: SELECT cn_process_batches_s2.NEXTVAL
827: INTO g_logical_batch_id
828: FROM DUAL;
829:
830: UPDATE cn_calc_submission_batches_all
831: SET logical_batch_id = g_logical_batch_id
832: WHERE calc_sub_batch_id = p_calc_sub_batch_id
833: RETURNING org_id
834: INTO g_org_id;

Line 865: FROM cn_calc_submission_batches_all

861: SELECT start_date
862: , end_date
863: , salesrep_option
864: , org_id
865: FROM cn_calc_submission_batches_all
866: WHERE calc_sub_batch_id = p_calc_sub_batch_id;
867:
868: CURSOR l_affected_all_csr IS
869: SELECT 'Y'

Line 1148: FROM cn_calc_submission_batches_all

1144: , intelligent_flag
1145: , NVL(hierarchy_flag, 'N')
1146: , salesrep_option
1147: , org_id
1148: FROM cn_calc_submission_batches_all
1149: WHERE calc_sub_batch_id = p_calc_sub_batch_id;
1150: BEGIN
1151: l_counter := 0;
1152:

Line 1595: FROM cn_calc_submission_batches_all

1591: , calc_type
1592: , start_date
1593: , end_date
1594: , org_id
1595: FROM cn_calc_submission_batches_all
1596: WHERE calc_sub_batch_id = p_calc_sub_batch_id;
1597:
1598: l_batch_rec l_calc_batch_csr%ROWTYPE;
1599: l_status cn_calc_submission_batches.status%TYPE;

Line 1627: UPDATE cn_calc_submission_batches_all

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
1628: SET process_audit_id = x_process_audit_id
1629: WHERE calc_sub_batch_id = p_calc_sub_batch_id;
1630:
1631: IF (

Line 1661: FROM cn_calc_submission_batches_all

1657:
1658: -- clku, bug 2783261, check if the status is complete before calling main
1659: SELECT status
1660: INTO l_status
1661: FROM cn_calc_submission_batches_all
1662: WHERE logical_batch_id = g_logical_batch_id;
1663:
1664: IF l_status <> 'COMPLETE' THEN
1665: cn_global_var.initialize_instance_info(l_batch_rec.org_id);

Line 1830: FROM cn_calc_submission_batches_all

1826: , salesrep_option
1827: , start_date
1828: , end_date
1829: , org_id
1830: FROM cn_calc_submission_batches_all
1831: WHERE logical_batch_id = g_logical_batch_id;
1832:
1833: l_batch_info batch_info%ROWTYPE;
1834:

Line 1837: FROM cn_calc_submission_batches_all

1833: l_batch_info batch_info%ROWTYPE;
1834:
1835: CURSOR pre_batch_info IS
1836: SELECT MAX(logical_batch_id)
1837: FROM cn_calc_submission_batches_all
1838: WHERE logical_batch_id >(g_logical_batch_id - 1000)
1839: AND logical_batch_id < g_logical_batch_id
1840: AND salesrep_option = 'ALL_REPS'
1841: AND calc_type = 'COMMISSION'

Line 2625: FROM cn_calc_submission_batches_all

2621: COMMIT;
2622:
2623: SELECT intelligent_flag, start_date, end_date
2624: INTO l_intelligent_flag, l_start_date, l_end_date
2625: FROM cn_calc_submission_batches_all
2626: WHERE logical_batch_id = g_logical_batch_id;
2627:
2628: OPEN parent_request;
2629: FETCH parent_request INTO l_parent_request_id;

Line 3113: UPDATE cn_calc_submission_batches_all

3109: );
3110: fnd_file.put_line(fnd_file.LOG, 'Beginning of calculate_batch...');
3111: cn_message_pkg.DEBUG('Beginning of calculate_batch...');
3112:
3113: UPDATE cn_calc_submission_batches_all
3114: SET process_audit_id = l_process_audit_id
3115: WHERE calc_sub_batch_id = p_calc_sub_batch_id;
3116:
3117: COMMIT;

Line 3206: FROM cn_calc_submission_batches_all

3202: CURSOR l_batch_name_csr IS
3203: SELECT 1
3204: FROM DUAL
3205: WHERE EXISTS(SELECT 1
3206: FROM cn_calc_submission_batches_all
3207: WHERE NAME = p_batch_name AND org_id = l_org_id);
3208:
3209: l_incomplete_plan BOOLEAN := FALSE;
3210: BEGIN

Line 3915: FROM cn_calc_submission_batches_all

3911: SELECT calc_type
3912: , org_id
3913: INTO g_calc_type
3914: , g_org_id
3915: FROM cn_calc_submission_batches_all
3916: WHERE logical_batch_id = g_logical_batch_id;
3917:
3918: -- Accept the current parent id and get the id for this batch if
3919: -- this is a concurrent request and it wasn't submitted from the

Line 3953: UPDATE cn_calc_submission_batches_all

3949:
3950: -- Only pass the new one if running concurrently
3951: l_paid := NVL(l_process_audit_id, p_parent_proc_audit_id);
3952:
3953: UPDATE cn_calc_submission_batches_all
3954: SET --ledger_je_batch_id = l_ledger_je_batch_id,
3955: process_audit_id = l_paid
3956: WHERE logical_batch_id = g_logical_batch_id;
3957:

Line 4086: UPDATE cn_calc_submission_batches_all

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
4087: SET process_audit_id = x_process_audit_id
4088: WHERE logical_batch_id = p_logical_batch_id;
4089: END IF;
4090:

Line 4423: FROM cn_srp_plan_assigns_all spa, cn_calc_submission_batches_all bat

4419: -- cursors to select salesrep with active comp plan within the calc_submission
4420: -- start_date and end_date
4421: CURSOR l_all_reps_csr IS
4422: SELECT DISTINCT spa.salesrep_id
4423: FROM cn_srp_plan_assigns_all spa, cn_calc_submission_batches_all bat
4424: WHERE bat.calc_sub_batch_id = p_calc_sub_batch_id
4425: AND spa.org_id = bat.org_id
4426: AND spa.start_date <= bat.end_date
4427: AND (spa.end_date IS NULL OR spa.end_date >= bat.start_date)

Line 4471: , cn_calc_submission_batches_all bat

4467: AND (
4468: EXISTS(
4469: SELECT 1
4470: FROM cn_srp_plan_assigns_all spa
4471: , cn_calc_submission_batches_all bat
4472: ,
4473: --code added for forwardport bug 6600074
4474: cn_comp_plans PLAN
4475: , cn_quota_assigns a

Line 4507: FROM cn_period_statuses_all period, cn_calc_submission_batches_all bat

4503: CURSOR l_period_int_periods_csr(p_salesrep_id NUMBER, p_interval_type_id NUMBER) IS
4504: SELECT period.period_id
4505: , period.start_date
4506: , period.end_date
4507: FROM cn_period_statuses_all period, cn_calc_submission_batches_all bat
4508: WHERE bat.calc_sub_batch_id = p_calc_sub_batch_id
4509: AND period.org_id = bat.org_id
4510: AND (period.period_set_id, period.period_type_id) = (SELECT period_set_id
4511: , period_type_id

Line 4579: FROM cn_period_statuses_all period, cn_calc_submission_batches_all bat

4575:
4576: CURSOR l_quarter_int_periods_csr(l_salesrep_id NUMBER) IS
4577: SELECT MIN(period.period_id) min_period_id
4578: , MAX(period.period_id) max_period_id
4579: FROM cn_period_statuses_all period, cn_calc_submission_batches_all bat
4580: WHERE bat.calc_sub_batch_id = p_calc_sub_batch_id
4581: AND period.org_id = bat.org_id
4582: AND period.end_date BETWEEN bat.start_date AND bat.end_date
4583: AND (period.period_set_id, period.period_type_id) =

Line 4593: FROM cn_period_statuses_all period, cn_calc_submission_batches_all bat

4589:
4590: CURSOR l_year_int_periods_csr(l_salesrep_id NUMBER) IS
4591: SELECT MIN(period.period_id) min_period_id
4592: , MAX(period.period_id) max_period_id
4593: FROM cn_period_statuses_all period, cn_calc_submission_batches_all bat
4594: WHERE bat.calc_sub_batch_id = p_calc_sub_batch_id
4595: AND period.org_id = bat.org_id
4596: AND period.end_date BETWEEN bat.start_date AND bat.end_date
4597: AND (period.period_set_id, period.period_type_id) =

Line 4626: FROM cn_calc_submission_batches_all

4622: , interval_type_id
4623: , start_date
4624: , end_date
4625: , org_id
4626: FROM cn_calc_submission_batches_all
4627: WHERE calc_sub_batch_id = p_calc_sub_batch_id;
4628: BEGIN
4629: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4630: fnd_log.STRING(