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 1087: IF jtf_usr_hks.ok_to_execute ('CN_COMP_PLAN_PUB',

1083: NULL;
1084:
1085: /* Post processing */
1086: -- dbms_output.put_line('calling post processing API');
1087: IF jtf_usr_hks.ok_to_execute ('CN_COMP_PLAN_PUB',
1088: 'CREATE_COMP_PLAN',
1089: 'A',
1090: 'V'
1091: )

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

1110: RAISE fnd_api.g_exc_unexpected_error;
1111: END IF;
1112: END IF;
1113:
1114: IF jtf_usr_hks.ok_to_execute ('CN_COMP_PLAN_PUB',
1115: 'CREATE_COMP_PLAN',
1116: 'A',
1117: 'C'
1118: )

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

1140:
1141: --dbms_output.put_line(' Executed for post processing API');
1142:
1143: /* Following code is for message generation */
1144: IF jtf_usr_hks.ok_to_execute ('CN_COMP_PLAN_PUB',
1145: 'CREATE_COMP_PLAN',
1146: 'M',
1147: 'M'
1148: )

Line 1156: l_bind_data_id := jtf_usr_hks.get_bind_data_id;

1152: )
1153: THEN
1154: -- XMLGEN.clearBindValues;
1155: -- XMLGEN.setBindValue('COMP_PLAN_NAME', l_cp_rec.name);
1156: l_bind_data_id := jtf_usr_hks.get_bind_data_id;
1157: jtf_usr_hks.load_bind_data (l_bind_data_id,
1158: 'COMP_PLAN_NAME',
1159: l_cp_rec.NAME,
1160: 'S',

Line 1157: jtf_usr_hks.load_bind_data (l_bind_data_id,

1153: THEN
1154: -- XMLGEN.clearBindValues;
1155: -- XMLGEN.setBindValue('COMP_PLAN_NAME', l_cp_rec.name);
1156: l_bind_data_id := jtf_usr_hks.get_bind_data_id;
1157: jtf_usr_hks.load_bind_data (l_bind_data_id,
1158: 'COMP_PLAN_NAME',
1159: l_cp_rec.NAME,
1160: 'S',
1161: 'T'

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

1159: l_cp_rec.NAME,
1160: 'S',
1161: 'T'
1162: );
1163: jtf_usr_hks.generate_message (p_prod_code => 'CN',
1164: p_bus_obj_code => 'CP',
1165: p_bus_obj_name => 'COMP_PLAN',
1166: p_action_code => 'I',
1167: /* I - Insert */