DBA Data[Home] [Help]

APPS.GMD_PROCESS_INSTR_UTILS dependencies on GMD_RECIPE_FETCH_PUB

Line 68: l_rout_dets GMD_RECIPE_FETCH_PUB.routing_step_tbl;

64:
65: l_instruction_type VARCHAR2(10);
66: l_proc_instr_id NUMBER;
67:
68: l_rout_dets GMD_RECIPE_FETCH_PUB.routing_step_tbl;
69: l_rout_id FM_ROUT_HDR.ROUTING_ID%TYPE;
70: l_form_id FM_FORM_MST.FORMULA_ID%TYPE;
71: l_oprn_id NUMBER;
72: l_oprn_no VARCHAR2(200);

Line 232: l_old_rout_dets GMD_RECIPE_FETCH_PUB.routing_step_tbl;

228: l_target_entity_key GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
229: l_instruction_type VARCHAR2(10);
230: l_proc_instr_id NUMBER;
231:
232: l_old_rout_dets GMD_RECIPE_FETCH_PUB.routing_step_tbl;
233: l_new_rout_dets GMD_RECIPE_FETCH_PUB.routing_step_tbl;
234: l_old_rout_id FM_ROUT_HDR.ROUTING_ID%TYPE;
235: l_new_rout_id FM_ROUT_HDR.ROUTING_ID%TYPE;
236: l_old_form_id FM_FORM_MST.FORMULA_ID%TYPE;

Line 233: l_new_rout_dets GMD_RECIPE_FETCH_PUB.routing_step_tbl;

229: l_instruction_type VARCHAR2(10);
230: l_proc_instr_id NUMBER;
231:
232: l_old_rout_dets GMD_RECIPE_FETCH_PUB.routing_step_tbl;
233: l_new_rout_dets GMD_RECIPE_FETCH_PUB.routing_step_tbl;
234: l_old_rout_id FM_ROUT_HDR.ROUTING_ID%TYPE;
235: l_new_rout_id FM_ROUT_HDR.ROUTING_ID%TYPE;
236: l_old_form_id FM_FORM_MST.FORMULA_ID%TYPE;
237: l_new_form_id FM_FORM_MST.FORMULA_ID%TYPE;

Line 272: GMD_RECIPE_FETCH_PUB.get_routing_step_details(

268:
269: /* Set the Source entity name and key for Recipe*/
270: i := 1;
271: IF l_old_rout_id = l_new_rout_id THEN
272: GMD_RECIPE_FETCH_PUB.get_routing_step_details(
273: p_api_version => 1.0 ,
274: p_init_msg_list => 'F' ,
275: p_routing_id => l_old_rout_id ,
276: x_return_status => l_status ,

Line 324: GMD_RECIPE_FETCH_PUB.get_routing_step_details(

320: /* Set the Target entity name and key for Recipe*/
321:
322: i := 1;
323: IF l_old_rout_id = l_new_rout_id THEN
324: GMD_RECIPE_FETCH_PUB.get_routing_step_details(
325: p_api_version => 1.0 ,
326: p_init_msg_list => 'F' ,
327: p_routing_id => l_new_rout_id ,
328: x_return_status => l_status ,

Line 549: l_rout_dets GMD_RECIPE_FETCH_PUB.routing_step_tbl;

545: x_msg_data OUT NOCOPY VARCHAR2 ) IS
546:
547: l_rout_id FM_ROUT_HDR.ROUTING_ID%TYPE;
548: l_form_id FM_FORM_MST.FORMULA_ID%TYPE;
549: l_rout_dets GMD_RECIPE_FETCH_PUB.routing_step_tbl;
550:
551: l_parent_entity_name GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
552: l_parent_entity_key GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
553: l_child_entity_name GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;

Line 583: GMD_RECIPE_FETCH_PUB.get_routing_step_details(

579: i := 1;
580:
581: /* Copy routing level PI's to the recipe */
582: IF l_rout_id IS NOT NULL THEN
583: GMD_RECIPE_FETCH_PUB.get_routing_step_details(
584: p_api_version => 1.0 ,
585: p_init_msg_list => 'F' ,
586: p_routing_id => l_rout_id ,
587: x_return_status => l_status ,

Line 856: l_old_rout_dets GMD_RECIPE_FETCH_PUB.routing_step_tbl;

852: l_target_entity_name GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
853: l_source_entity_key GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
854: l_target_entity_key GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
855:
856: l_old_rout_dets GMD_RECIPE_FETCH_PUB.routing_step_tbl;
857: l_new_rout_dets GMD_RECIPE_FETCH_PUB.routing_step_tbl;
858: l_old_rout_id FM_ROUT_HDR.ROUTING_ID%TYPE;
859: l_new_rout_id FM_ROUT_HDR.ROUTING_ID%TYPE;
860: l_old_form_id FM_FORM_MST.FORMULA_ID%TYPE;

Line 857: l_new_rout_dets GMD_RECIPE_FETCH_PUB.routing_step_tbl;

853: l_source_entity_key GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
854: l_target_entity_key GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
855:
856: l_old_rout_dets GMD_RECIPE_FETCH_PUB.routing_step_tbl;
857: l_new_rout_dets GMD_RECIPE_FETCH_PUB.routing_step_tbl;
858: l_old_rout_id FM_ROUT_HDR.ROUTING_ID%TYPE;
859: l_new_rout_id FM_ROUT_HDR.ROUTING_ID%TYPE;
860: l_old_form_id FM_FORM_MST.FORMULA_ID%TYPE;
861: l_new_form_id FM_FORM_MST.FORMULA_ID%TYPE;

Line 892: GMD_RECIPE_FETCH_PUB.get_routing_step_details(

888:
889: /* Set the Source entity name and key for Recipe*/
890: i := 1;
891: IF l_old_rout_id = l_new_rout_id THEN
892: GMD_RECIPE_FETCH_PUB.get_routing_step_details(
893: p_api_version => 1.0 ,
894: p_init_msg_list => 'F' ,
895: p_routing_id => l_old_rout_id ,
896: x_return_status => l_status ,

Line 944: GMD_RECIPE_FETCH_PUB.get_routing_step_details(

940: /* Set the Target entity name and key for Recipe*/
941:
942: i := 1;
943: IF l_old_rout_id = l_new_rout_id THEN
944: GMD_RECIPE_FETCH_PUB.get_routing_step_details(
945: p_api_version => 1.0 ,
946: p_init_msg_list => 'F' ,
947: p_routing_id => l_new_rout_id ,
948: x_return_status => l_status ,