DBA Data[Home] [Help]

APPS.CN_COMP_PLAN_PUB dependencies on JTF_USR_HKS

Line 747: l_oai_array jtf_usr_hks.oai_data_array_type;

743: l_end_date cn_periods.start_date%TYPE;
744: l_status_code cn_comp_plans.status_code%TYPE;
745: l_new_cp_flag VARCHAR2 (1) := 'N';
746: l_p_comp_plan_rec comp_plan_rec_type;
747: l_oai_array jtf_usr_hks.oai_data_array_type;
748: l_bind_data_id NUMBER;
749: l_loading_status VARCHAR2 (30);
750: l_note_msg VARCHAR2 (240);
751: l_note_id NUMBER;

Line 790: IF jtf_usr_hks.ok_to_execute ('CN_COMP_PLAN_PUB',

786: -- Validating the MOAC Org Id
787: mo_global.validate_orgid_pub_api(org_id => l_p_comp_plan_rec.ORG_ID,status => l_status);
788:
789: --dbms_output.put_line('Going into pre processing ');
790: IF jtf_usr_hks.ok_to_execute ('CN_COMP_PLAN_PUB',
791: 'CREATE_COMP_PLAN',
792: 'B',
793: 'C'
794: )

Line 817: IF jtf_usr_hks.ok_to_execute ('CN_COMP_PLAN_PUB',

813: RAISE fnd_api.g_exc_unexpected_error;
814: END IF;
815: END IF;
816:
817: IF jtf_usr_hks.ok_to_execute ('CN_COMP_PLAN_PUB',
818: 'CREATE_COMP_PLAN',
819: 'B',
820: 'V'
821: )

Line 1067: IF jtf_usr_hks.ok_to_execute ('CN_COMP_PLAN_PUB',

1063: NULL;
1064:
1065: /* Post processing */
1066: -- dbms_output.put_line('calling post processing API');
1067: IF jtf_usr_hks.ok_to_execute ('CN_COMP_PLAN_PUB',
1068: 'CREATE_COMP_PLAN',
1069: 'A',
1070: 'V'
1071: )

Line 1094: IF jtf_usr_hks.ok_to_execute ('CN_COMP_PLAN_PUB',

1090: RAISE fnd_api.g_exc_unexpected_error;
1091: END IF;
1092: END IF;
1093:
1094: IF jtf_usr_hks.ok_to_execute ('CN_COMP_PLAN_PUB',
1095: 'CREATE_COMP_PLAN',
1096: 'A',
1097: 'C'
1098: )

Line 1124: IF jtf_usr_hks.ok_to_execute ('CN_COMP_PLAN_PUB',

1120:
1121: --dbms_output.put_line(' Executed for post processing API');
1122:
1123: /* Following code is for message generation */
1124: IF jtf_usr_hks.ok_to_execute ('CN_COMP_PLAN_PUB',
1125: 'CREATE_COMP_PLAN',
1126: 'M',
1127: 'M'
1128: )

Line 1136: l_bind_data_id := jtf_usr_hks.get_bind_data_id;

1132: )
1133: THEN
1134: -- XMLGEN.clearBindValues;
1135: -- XMLGEN.setBindValue('COMP_PLAN_NAME', l_cp_rec.name);
1136: l_bind_data_id := jtf_usr_hks.get_bind_data_id;
1137: jtf_usr_hks.load_bind_data (l_bind_data_id,
1138: 'COMP_PLAN_NAME',
1139: l_cp_rec.NAME,
1140: 'S',

Line 1137: jtf_usr_hks.load_bind_data (l_bind_data_id,

1133: THEN
1134: -- XMLGEN.clearBindValues;
1135: -- XMLGEN.setBindValue('COMP_PLAN_NAME', l_cp_rec.name);
1136: l_bind_data_id := jtf_usr_hks.get_bind_data_id;
1137: jtf_usr_hks.load_bind_data (l_bind_data_id,
1138: 'COMP_PLAN_NAME',
1139: l_cp_rec.NAME,
1140: 'S',
1141: 'T'

Line 1143: jtf_usr_hks.generate_message (p_prod_code => 'CN',

1139: l_cp_rec.NAME,
1140: 'S',
1141: 'T'
1142: );
1143: jtf_usr_hks.generate_message (p_prod_code => 'CN',
1144: p_bus_obj_code => 'CP',
1145: p_bus_obj_name => 'COMP_PLAN',
1146: p_action_code => 'I',
1147: /* I - Insert */