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.GMD_PROCESS_INSTR_UTILS dependencies on GMO_DATATYPES_GRP

Line 61: x_name_array OUT NOCOPY GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255,

57:
58: PROCEDURE Build_Array (
59: p_entity_name IN VARCHAR2 ,
60: p_entity_id IN NUMBER ,
61: x_name_array OUT NOCOPY GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255,
62: x_key_array OUT NOCOPY GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255,
63: x_return_status OUT NOCOPY VARCHAR2) IS
64:
65: l_instruction_type VARCHAR2(10);

Line 62: x_key_array OUT NOCOPY GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255,

58: PROCEDURE Build_Array (
59: p_entity_name IN VARCHAR2 ,
60: p_entity_id IN NUMBER ,
61: x_name_array OUT NOCOPY GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255,
62: x_key_array OUT NOCOPY GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255,
63: x_return_status OUT NOCOPY VARCHAR2) IS
64:
65: l_instruction_type VARCHAR2(10);
66: l_proc_instr_id NUMBER;

Line 168: p_source_name_array IN GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255,

164: -- B5305793 - Added this procedure to fix the issue reported.
165: --------------------------------------------------------------------*/
166:
167: PROCEDURE Copy_Process_Instructions (
168: p_source_name_array IN GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255,
169: p_source_key_array IN GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255,
170: p_target_name_array IN GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255,
171: p_target_key_array IN GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255,
172: x_return_status OUT NOCOPY VARCHAR2) IS

Line 169: p_source_key_array IN GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255,

165: --------------------------------------------------------------------*/
166:
167: PROCEDURE Copy_Process_Instructions (
168: p_source_name_array IN GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255,
169: p_source_key_array IN GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255,
170: p_target_name_array IN GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255,
171: p_target_key_array IN GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255,
172: x_return_status OUT NOCOPY VARCHAR2) IS
173: l_proc_instr_id NUMBER(15);

Line 170: p_target_name_array IN GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255,

166:
167: PROCEDURE Copy_Process_Instructions (
168: p_source_name_array IN GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255,
169: p_source_key_array IN GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255,
170: p_target_name_array IN GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255,
171: p_target_key_array IN GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255,
172: x_return_status OUT NOCOPY VARCHAR2) IS
173: l_proc_instr_id NUMBER(15);
174: l_msg_count NUMBER(5);

Line 171: p_target_key_array IN GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255,

167: PROCEDURE Copy_Process_Instructions (
168: p_source_name_array IN GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255,
169: p_source_key_array IN GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255,
170: p_target_name_array IN GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255,
171: p_target_key_array IN GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255,
172: x_return_status OUT NOCOPY VARCHAR2) IS
173: l_proc_instr_id NUMBER(15);
174: l_msg_count NUMBER(5);
175: l_msg_data VARCHAR2(2000);

Line 225: l_source_entity_name GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;

221: x_return_status OUT NOCOPY VARCHAR2 ,
222: x_msg_count OUT NOCOPY NUMBER ,
223: x_msg_data OUT NOCOPY VARCHAR2 ) IS
224:
225: l_source_entity_name GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
226: l_source_entity_key GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
227: l_target_entity_name GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
228: l_target_entity_key GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
229: l_instruction_type VARCHAR2(10);

Line 226: l_source_entity_key GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;

222: x_msg_count OUT NOCOPY NUMBER ,
223: x_msg_data OUT NOCOPY VARCHAR2 ) IS
224:
225: l_source_entity_name GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
226: l_source_entity_key GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
227: l_target_entity_name GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
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;

Line 227: l_target_entity_name GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;

223: x_msg_data OUT NOCOPY VARCHAR2 ) IS
224:
225: l_source_entity_name GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
226: l_source_entity_key GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
227: l_target_entity_name GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
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:

Line 228: l_target_entity_key GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;

224:
225: l_source_entity_name GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
226: l_source_entity_key GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
227: l_target_entity_name GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
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;

Line 551: l_parent_entity_name GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;

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;
554: l_child_entity_key GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
555: l_instruction_type VARCHAR2(10);

Line 552: l_parent_entity_key GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;

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;
554: l_child_entity_key GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
555: l_instruction_type VARCHAR2(10);
556: l_proc_instr_id NUMBER;

Line 553: l_child_entity_name GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;

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;
554: l_child_entity_key GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
555: l_instruction_type VARCHAR2(10);
556: l_proc_instr_id NUMBER;
557:

Line 554: l_child_entity_key GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;

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;
554: l_child_entity_key GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
555: l_instruction_type VARCHAR2(10);
556: l_proc_instr_id NUMBER;
557:
558:

Line 746: l_parent_entity_name GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;

742: FROM fm_rout_dtl r
743: WHERE r.routingstep_id = v_routingstep_id;
744:
745:
746: l_parent_entity_name GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
747: l_parent_entity_key GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
748: l_child_entity_name GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
749: l_child_entity_key GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
750:

Line 747: l_parent_entity_key GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;

743: WHERE r.routingstep_id = v_routingstep_id;
744:
745:
746: l_parent_entity_name GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
747: l_parent_entity_key GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
748: l_child_entity_name GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
749: l_child_entity_key GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
750:
751: l_instruction_type VARCHAR2(10);

Line 748: l_child_entity_name GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;

744:
745:
746: l_parent_entity_name GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
747: l_parent_entity_key GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
748: l_child_entity_name GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
749: l_child_entity_key GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
750:
751: l_instruction_type VARCHAR2(10);
752: l_return_status VARCHAR2(10);

Line 749: l_child_entity_key GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;

745:
746: l_parent_entity_name GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
747: l_parent_entity_key GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
748: l_child_entity_name GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
749: l_child_entity_key GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
750:
751: l_instruction_type VARCHAR2(10);
752: l_return_status VARCHAR2(10);
753: l_msg_count NUMBER;

Line 851: l_entity_name GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;

847: X_RETURN_STATUS OUT NOCOPY VARCHAR2 ,
848: X_MSG_COUNT OUT NOCOPY NUMBER ,
849: X_MSG_DATA OUT NOCOPY VARCHAR2 ) IS
850:
851: l_entity_name GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
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:

Line 852: l_target_entity_name GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;

848: X_MSG_COUNT OUT NOCOPY NUMBER ,
849: X_MSG_DATA OUT NOCOPY VARCHAR2 ) IS
850:
851: l_entity_name GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
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;

Line 853: l_source_entity_key GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;

849: X_MSG_DATA OUT NOCOPY VARCHAR2 ) IS
850:
851: l_entity_name GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
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;

Line 854: l_target_entity_key GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;

850:
851: l_entity_name GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
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;

Line 1188: l_entity_name GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;

1184: --
1185: -- HISTORY
1186: -- kkillams 20-SEP-2005 Created for GMD-GMO Integration Build
1187: -------------------------------------------------------------------*/
1188: l_entity_name GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
1189: l_src_entity_key GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
1190: l_target_entity_key GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
1191: l_msg_count NUMBER;
1192: l_msg_data VARCHAR2(2000);

Line 1189: l_src_entity_key GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;

1185: -- HISTORY
1186: -- kkillams 20-SEP-2005 Created for GMD-GMO Integration Build
1187: -------------------------------------------------------------------*/
1188: l_entity_name GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
1189: l_src_entity_key GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
1190: l_target_entity_key GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
1191: l_msg_count NUMBER;
1192: l_msg_data VARCHAR2(2000);
1193: l_return_status VARCHAR2(10);

Line 1190: l_target_entity_key GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;

1186: -- kkillams 20-SEP-2005 Created for GMD-GMO Integration Build
1187: -------------------------------------------------------------------*/
1188: l_entity_name GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
1189: l_src_entity_key GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
1190: l_target_entity_key GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
1191: l_msg_count NUMBER;
1192: l_msg_data VARCHAR2(2000);
1193: l_return_status VARCHAR2(10);
1194:

Line 1282: l_entity_name GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;

1278:
1279: rec_from_recipe Cur_get_rcp_hdr%ROWTYPE;
1280: rec_to_recipe Cur_get_rcp_hdr%ROWTYPE;
1281:
1282: l_entity_name GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
1283: l_src_entity_key GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
1284: l_target_entity_key GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
1285: l_msg_count NUMBER;
1286: l_msg_data VARCHAR2(2000);

Line 1283: l_src_entity_key GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;

1279: rec_from_recipe Cur_get_rcp_hdr%ROWTYPE;
1280: rec_to_recipe Cur_get_rcp_hdr%ROWTYPE;
1281:
1282: l_entity_name GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
1283: l_src_entity_key GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
1284: l_target_entity_key GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
1285: l_msg_count NUMBER;
1286: l_msg_data VARCHAR2(2000);
1287: l_return_status VARCHAR2(10);

Line 1284: l_target_entity_key GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;

1280: rec_to_recipe Cur_get_rcp_hdr%ROWTYPE;
1281:
1282: l_entity_name GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
1283: l_src_entity_key GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
1284: l_target_entity_key GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
1285: l_msg_count NUMBER;
1286: l_msg_data VARCHAR2(2000);
1287: l_return_status VARCHAR2(10);
1288: