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_SUB_VALIDATIONS_ALL

Line 879: FROM cn_calc_sub_validations_all

875: AND revert_state <> 'NCALC';
876:
877: CURSOR l_invalid_plans IS
878: SELECT comp_plan_id
879: FROM cn_calc_sub_validations_all
880: WHERE calc_sub_batch_id = p_calc_sub_batch_id;
881:
882: CURSOR plan_status(p_comp_plan_id NUMBER) IS
883: SELECT status_code

Line 901: DELETE FROM cn_calc_sub_validations_all

897: , l_calc_to_period_id
898: , l_org_id
899: );
900:
901: DELETE FROM cn_calc_sub_validations_all
902: WHERE calc_sub_batch_id = p_calc_sub_batch_id;
903:
904: -- Get validation result if SALESREP_OPTION = 'ALL_REPS'
905: IF (l_salesrep_option = 'ALL_REPS') THEN

Line 906: INSERT INTO cn_calc_sub_validations_all

902: WHERE calc_sub_batch_id = p_calc_sub_batch_id;
903:
904: -- Get validation result if SALESREP_OPTION = 'ALL_REPS'
905: IF (l_salesrep_option = 'ALL_REPS') THEN
906: INSERT INTO cn_calc_sub_validations_all
907: (
908: org_id
909: , calc_sub_batch_id
910: , comp_plan_id

Line 944: INSERT INTO cn_calc_sub_validations_all

940: NULL; --return true;
941: END IF;
942: -- Get validation result if SALESREP_OPTION = 'USER_SPECIFY'
943: ELSIF(l_salesrep_option = 'USER_SPECIFY') THEN
944: INSERT INTO cn_calc_sub_validations_all
945: (
946: org_id
947: , calc_sub_batch_id
948: , comp_plan_id

Line 990: INSERT INTO cn_calc_sub_validations_all

986: FETCH l_affected_all_csr INTO l_affected_all_reps;
987: CLOSE l_affected_all_csr;
988:
989: IF (l_affected_all_reps = 'Y') THEN
990: INSERT INTO cn_calc_sub_validations_all
991: (
992: org_id
993: , calc_sub_batch_id
994: , comp_plan_id

Line 1027: INSERT INTO cn_calc_sub_validations_all

1023: IF (SQL%FOUND) THEN
1024: NULL; --return true;
1025: END IF;
1026: ELSE
1027: INSERT INTO cn_calc_sub_validations_all
1028: (
1029: org_id
1030: , calc_sub_batch_id
1031: , comp_plan_id

Line 1095: DELETE FROM cn_calc_sub_validations_all

1091: FETCH plan_status INTO l_status_code;
1092: CLOSE plan_status;
1093:
1094: IF (l_status_code = 'COMPLETE') THEN
1095: DELETE FROM cn_calc_sub_validations_all
1096: WHERE calc_sub_batch_id = p_calc_sub_batch_id
1097: AND comp_plan_id = invalid_plan.comp_plan_id;
1098:
1099: l_validated_plans_cnt := l_validated_plans_cnt + 1;