APPS.GMD_FETCH_OPRN dependencies on GMD_RECIPE_FETCH_PUB

Line 14: X_oprn_act_out OUT NOCOPY gmd_recipe_fetch_pub.oprn_act_tbl,

10: x_return_status OUT NOCOPY VARCHAR2 ,
11: x_msg_count OUT NOCOPY NUMBER ,
12: x_msg_data OUT NOCOPY VARCHAR2 ,
13: x_return_code OUT NOCOPY NUMBER ,
14: X_oprn_act_out OUT NOCOPY gmd_recipe_fetch_pub.oprn_act_tbl,
15: X_oprn_resc_rec OUT NOCOPY gmd_recipe_fetch_pub.oprn_resc_tbl,
16: X_oprn_resc_proc_param_tbl OUT NOCOPY gmd_recipe_fetch_pub.recp_resc_proc_param_tbl
17: ) IS
18:

Line 15: X_oprn_resc_rec OUT NOCOPY gmd_recipe_fetch_pub.oprn_resc_tbl,

11: x_msg_count OUT NOCOPY NUMBER ,
12: x_msg_data OUT NOCOPY VARCHAR2 ,
13: x_return_code OUT NOCOPY NUMBER ,
14: X_oprn_act_out OUT NOCOPY gmd_recipe_fetch_pub.oprn_act_tbl,
15: X_oprn_resc_rec OUT NOCOPY gmd_recipe_fetch_pub.oprn_resc_tbl,
16: X_oprn_resc_proc_param_tbl OUT NOCOPY gmd_recipe_fetch_pub.recp_resc_proc_param_tbl
17: ) IS
18:
19: CURSOR Cur_validate_record IS

Line 16: X_oprn_resc_proc_param_tbl OUT NOCOPY gmd_recipe_fetch_pub.recp_resc_proc_param_tbl

12: x_msg_data OUT NOCOPY VARCHAR2 ,
13: x_return_code OUT NOCOPY NUMBER ,
14: X_oprn_act_out OUT NOCOPY gmd_recipe_fetch_pub.oprn_act_tbl,
15: X_oprn_resc_rec OUT NOCOPY gmd_recipe_fetch_pub.oprn_resc_tbl,
16: X_oprn_resc_proc_param_tbl OUT NOCOPY gmd_recipe_fetch_pub.recp_resc_proc_param_tbl
17: ) IS
18:
19: CURSOR Cur_validate_record IS
20: SELECT 1

Line 104: x_oprn_act_out OUT NOCOPY gmd_recipe_fetch_pub.oprn_act_tbl

100: x_return_status OUT NOCOPY VARCHAR2 ,
101: x_msg_count OUT NOCOPY NUMBER ,
102: x_msg_data OUT NOCOPY VARCHAR2 ,
103: x_return_code OUT NOCOPY NUMBER ,
104: x_oprn_act_out OUT NOCOPY gmd_recipe_fetch_pub.oprn_act_tbl
105: ) IS
106: /* local Variables */
107: l_api_name VARCHAR2(30) := 'get_oprn_act';
108: l_api_version NUMBER := 1.0;

Line 236: X_oprn_resc_rec OUT NOCOPY gmd_recipe_fetch_pub.oprn_resc_tbl,

232: x_return_status OUT NOCOPY VARCHAR2 ,
233: x_msg_count OUT NOCOPY NUMBER ,
234: x_msg_data OUT NOCOPY VARCHAR2 ,
235: x_return_code OUT NOCOPY NUMBER ,
236: X_oprn_resc_rec OUT NOCOPY gmd_recipe_fetch_pub.oprn_resc_tbl,
237: X_oprn_resc_proc_param_tbl OUT NOCOPY gmd_recipe_fetch_pub.recp_resc_proc_param_tbl
238: ) IS
239:
240: /* local Variables */

Line 237: X_oprn_resc_proc_param_tbl OUT NOCOPY gmd_recipe_fetch_pub.recp_resc_proc_param_tbl

233: x_msg_count OUT NOCOPY NUMBER ,
234: x_msg_data OUT NOCOPY VARCHAR2 ,
235: x_return_code OUT NOCOPY NUMBER ,
236: X_oprn_resc_rec OUT NOCOPY gmd_recipe_fetch_pub.oprn_resc_tbl,
237: X_oprn_resc_proc_param_tbl OUT NOCOPY gmd_recipe_fetch_pub.recp_resc_proc_param_tbl
238: ) IS
239:
240: /* local Variables */
241: l_api_name CONSTANT VARCHAR2(30) := 'get_oprn_resc';

Line 243: l_resc_param_tbl gmd_recipe_fetch_pub.recp_resc_proc_param_tbl;

239:
240: /* local Variables */
241: l_api_name CONSTANT VARCHAR2(30) := 'get_oprn_resc';
242: l_api_version CONSTANT NUMBER := 1.0;
243: l_resc_param_tbl gmd_recipe_fetch_pub.recp_resc_proc_param_tbl;
244: X_row NUMBER DEFAULT 0;
245: i NUMBER := 0;
246:
247: /* BUG#2621411 RajaSekhar Added capacity_tolerance field */

Line 412: X_oprn_resc_proc_param_tbl OUT NOCOPY gmd_recipe_fetch_pub.recp_resc_proc_param_tbl

408: p_resources IN VARCHAR2 ,
409: x_return_status OUT NOCOPY VARCHAR2 ,
410: x_msg_count OUT NOCOPY NUMBER ,
411: x_msg_data OUT NOCOPY VARCHAR2 ,
412: X_oprn_resc_proc_param_tbl OUT NOCOPY gmd_recipe_fetch_pub.recp_resc_proc_param_tbl
413: ) IS
414:
415: /* Parameters at the oprn resource level */
416: CURSOR Cur_get_oprn_rsrc IS