DBA Data[Home] [Help]

APPS.GMD_PROCESS_INSTR_UTILS dependencies on GMD_PROCESS_INSTR_UTILS

Line 1: PACKAGE BODY GMD_PROCESS_INSTR_UTILS AS

1: PACKAGE BODY GMD_PROCESS_INSTR_UTILS AS
2: /* $Header: GMDPIUTB.pls 120.9 2006/07/12 18:08:07 txdaniel noship $ */
3:
4: /* Cursor Definitions */
5:

Line 1197: IF gmd_process_instr_utils.p_recipe_instr_process_id IS NOT NULL THEN

1193: l_return_status VARCHAR2(10);
1194:
1195: BEGIN
1196: p_return_status := 'S';
1197: IF gmd_process_instr_utils.p_recipe_instr_process_id IS NOT NULL THEN
1198: gmo_instruction_pvt.send_defn_ackn
1199: ( p_instruction_process_id => gmd_process_instr_utils.p_recipe_instr_process_id,
1200: p_entity_name => l_entity_name,
1201: p_source_entity_key => l_src_entity_key,

Line 1199: ( p_instruction_process_id => gmd_process_instr_utils.p_recipe_instr_process_id,

1195: BEGIN
1196: p_return_status := 'S';
1197: IF gmd_process_instr_utils.p_recipe_instr_process_id IS NOT NULL THEN
1198: gmo_instruction_pvt.send_defn_ackn
1199: ( p_instruction_process_id => gmd_process_instr_utils.p_recipe_instr_process_id,
1200: p_entity_name => l_entity_name,
1201: p_source_entity_key => l_src_entity_key,
1202: p_target_entity_key => l_target_entity_key,
1203: x_return_status => l_return_status,

Line 1210: IF gmd_process_instr_utils.p_formula_instr_process_id IS NOT NULL THEN

1206: IF l_return_status <> 'S' THEN
1207: p_return_status := 'E';
1208: END IF;
1209: END IF;
1210: IF gmd_process_instr_utils.p_formula_instr_process_id IS NOT NULL THEN
1211: gmo_instruction_pvt.send_defn_ackn
1212: ( p_instruction_process_id => gmd_process_instr_utils.p_formula_instr_process_id,
1213: p_entity_name => l_entity_name,
1214: p_source_entity_key => l_src_entity_key,

Line 1212: ( p_instruction_process_id => gmd_process_instr_utils.p_formula_instr_process_id,

1208: END IF;
1209: END IF;
1210: IF gmd_process_instr_utils.p_formula_instr_process_id IS NOT NULL THEN
1211: gmo_instruction_pvt.send_defn_ackn
1212: ( p_instruction_process_id => gmd_process_instr_utils.p_formula_instr_process_id,
1213: p_entity_name => l_entity_name,
1214: p_source_entity_key => l_src_entity_key,
1215: p_target_entity_key => l_target_entity_key,
1216: x_return_status => l_return_status,

Line 1223: IF gmd_process_instr_utils.p_routing_instr_process_id IS NOT NULL THEN

1219: IF l_return_status <> 'S' THEN
1220: p_return_status := 'E';
1221: END IF;
1222: END IF;
1223: IF gmd_process_instr_utils.p_routing_instr_process_id IS NOT NULL THEN
1224: gmo_instruction_pvt.send_defn_ackn
1225: ( p_instruction_process_id => gmd_process_instr_utils.p_routing_instr_process_id,
1226: p_entity_name => l_entity_name,
1227: p_source_entity_key => l_src_entity_key,

Line 1225: ( p_instruction_process_id => gmd_process_instr_utils.p_routing_instr_process_id,

1221: END IF;
1222: END IF;
1223: IF gmd_process_instr_utils.p_routing_instr_process_id IS NOT NULL THEN
1224: gmo_instruction_pvt.send_defn_ackn
1225: ( p_instruction_process_id => gmd_process_instr_utils.p_routing_instr_process_id,
1226: p_entity_name => l_entity_name,
1227: p_source_entity_key => l_src_entity_key,
1228: p_target_entity_key => l_target_entity_key,
1229: x_return_status => l_return_status,

Line 1236: IF gmd_process_instr_utils.p_setp_instr_process_id IS NOT NULL THEN

1232: IF l_return_status <> 'S' THEN
1233: p_return_status := 'E';
1234: END IF;
1235: END IF;
1236: IF gmd_process_instr_utils.p_setp_instr_process_id IS NOT NULL THEN
1237: gmo_instruction_pvt.send_defn_ackn
1238: ( p_instruction_process_id => gmd_process_instr_utils.p_setp_instr_process_id,
1239: p_entity_name => l_entity_name,
1240: p_source_entity_key => l_src_entity_key,

Line 1238: ( p_instruction_process_id => gmd_process_instr_utils.p_setp_instr_process_id,

1234: END IF;
1235: END IF;
1236: IF gmd_process_instr_utils.p_setp_instr_process_id IS NOT NULL THEN
1237: gmo_instruction_pvt.send_defn_ackn
1238: ( p_instruction_process_id => gmd_process_instr_utils.p_setp_instr_process_id,
1239: p_entity_name => l_entity_name,
1240: p_source_entity_key => l_src_entity_key,
1241: p_target_entity_key => l_target_entity_key,
1242: x_return_status => l_return_status,

Line 1301: GMD_PROCESS_INSTR_UTILS.SEND_PI_ACKN(

1297: CLOSE Cur_get_rcp_hdr;
1298:
1299: IF ( p_recipe_instr_process_id IS NOT NULL AND
1300: ( rec_from_recipe.recipe_id <> rec_to_recipe.recipe_id )) THEN
1301: GMD_PROCESS_INSTR_UTILS.SEND_PI_ACKN(
1302: p_entity_name => 'RECIPE' ,
1303: p_INSTRUCTION_PROCESS_ID => p_recipe_instr_process_id ,
1304: p_old_entity_id => rec_from_recipe.recipe_id ,
1305: p_new_entity_id => rec_to_recipe.recipe_id ,

Line 1316: GMD_PROCESS_INSTR_UTILS.SEND_PI_ACKN(

1312: p_recipe_instr_process_id := NULL;
1313: END IF;
1314: IF ( p_formula_instr_process_id IS NOT NULL AND
1315: ( rec_from_recipe.formula_id <> rec_to_recipe.formula_id )) THEN
1316: GMD_PROCESS_INSTR_UTILS.SEND_PI_ACKN(
1317: p_entity_name => 'FORMULA' ,
1318: p_INSTRUCTION_PROCESS_ID => p_formula_instr_process_id ,
1319: p_old_entity_id => rec_from_recipe.formula_id ,
1320: p_new_entity_id => rec_to_recipe.formula_id ,

Line 1333: GMD_PROCESS_INSTR_UTILS.SEND_PI_ACKN(

1329: END IF;
1330:
1331: IF ( p_routing_instr_process_id IS NOT NULL AND
1332: ( rec_from_recipe.routing_id <> rec_to_recipe.routing_id )) THEN
1333: GMD_PROCESS_INSTR_UTILS.SEND_PI_ACKN(
1334: p_entity_name => 'ROUTING' ,
1335: p_INSTRUCTION_PROCESS_ID => p_routing_instr_process_id ,
1336: p_old_entity_id => rec_from_recipe.routing_id ,
1337: p_new_entity_id => rec_to_recipe.routing_id ,

Line 1354: END GMD_PROCESS_INSTR_UTILS;

1350: WHEN OTHERS THEN
1351: p_return_status := 'U';
1352: END DESG_SEND_VER_PI_ACKN;
1353:
1354: END GMD_PROCESS_INSTR_UTILS;