12: x_return_status OUT NOCOPY VARCHAR2 ,
13: x_msg_count OUT NOCOPY NUMBER ,
14: x_msg_data OUT NOCOPY VARCHAR2 ,
15: x_return_code OUT NOCOPY NUMBER ,
16: x_recipe_rout_tbl OUT NOCOPY gmd_recipe_fetch_pub.recipe_rout_tbl ,
17: x_recipe_rout_matl_tbl OUT NOCOPY gmd_recipe_fetch_pub.recipe_rout_matl_tbl ,
18: x_recipe_step_out OUT NOCOPY gmd_recipe_fetch_pub.recipe_step_tbl ,
19: x_routing_depd_tbl OUT NOCOPY gmd_recipe_fetch_pub.routing_depd_tbl ,
20: x_oprn_act_out OUT NOCOPY gmd_recipe_fetch_pub.oprn_act_tbl ,
13: x_msg_count OUT NOCOPY NUMBER ,
14: x_msg_data OUT NOCOPY VARCHAR2 ,
15: x_return_code OUT NOCOPY NUMBER ,
16: x_recipe_rout_tbl OUT NOCOPY gmd_recipe_fetch_pub.recipe_rout_tbl ,
17: x_recipe_rout_matl_tbl OUT NOCOPY gmd_recipe_fetch_pub.recipe_rout_matl_tbl ,
18: x_recipe_step_out OUT NOCOPY gmd_recipe_fetch_pub.recipe_step_tbl ,
19: x_routing_depd_tbl OUT NOCOPY gmd_recipe_fetch_pub.routing_depd_tbl ,
20: x_oprn_act_out OUT NOCOPY gmd_recipe_fetch_pub.oprn_act_tbl ,
21: x_oprn_resc_rec OUT NOCOPY gmd_recipe_fetch_pub.oprn_resc_tbl ,
14: x_msg_data OUT NOCOPY VARCHAR2 ,
15: x_return_code OUT NOCOPY NUMBER ,
16: x_recipe_rout_tbl OUT NOCOPY gmd_recipe_fetch_pub.recipe_rout_tbl ,
17: x_recipe_rout_matl_tbl OUT NOCOPY gmd_recipe_fetch_pub.recipe_rout_matl_tbl ,
18: x_recipe_step_out OUT NOCOPY gmd_recipe_fetch_pub.recipe_step_tbl ,
19: x_routing_depd_tbl OUT NOCOPY gmd_recipe_fetch_pub.routing_depd_tbl ,
20: x_oprn_act_out OUT NOCOPY gmd_recipe_fetch_pub.oprn_act_tbl ,
21: x_oprn_resc_rec OUT NOCOPY gmd_recipe_fetch_pub.oprn_resc_tbl ,
22: x_formula_header_rec OUT NOCOPY fm_form_mst%ROWTYPE ,
15: x_return_code OUT NOCOPY NUMBER ,
16: x_recipe_rout_tbl OUT NOCOPY gmd_recipe_fetch_pub.recipe_rout_tbl ,
17: x_recipe_rout_matl_tbl OUT NOCOPY gmd_recipe_fetch_pub.recipe_rout_matl_tbl ,
18: x_recipe_step_out OUT NOCOPY gmd_recipe_fetch_pub.recipe_step_tbl ,
19: x_routing_depd_tbl OUT NOCOPY gmd_recipe_fetch_pub.routing_depd_tbl ,
20: x_oprn_act_out OUT NOCOPY gmd_recipe_fetch_pub.oprn_act_tbl ,
21: x_oprn_resc_rec OUT NOCOPY gmd_recipe_fetch_pub.oprn_resc_tbl ,
22: x_formula_header_rec OUT NOCOPY fm_form_mst%ROWTYPE ,
23: x_formula_dtl_tbl OUT NOCOPY gmdfmval_pub.formula_detail_tbl ,
16: x_recipe_rout_tbl OUT NOCOPY gmd_recipe_fetch_pub.recipe_rout_tbl ,
17: x_recipe_rout_matl_tbl OUT NOCOPY gmd_recipe_fetch_pub.recipe_rout_matl_tbl ,
18: x_recipe_step_out OUT NOCOPY gmd_recipe_fetch_pub.recipe_step_tbl ,
19: x_routing_depd_tbl OUT NOCOPY gmd_recipe_fetch_pub.routing_depd_tbl ,
20: x_oprn_act_out OUT NOCOPY gmd_recipe_fetch_pub.oprn_act_tbl ,
21: x_oprn_resc_rec OUT NOCOPY gmd_recipe_fetch_pub.oprn_resc_tbl ,
22: x_formula_header_rec OUT NOCOPY fm_form_mst%ROWTYPE ,
23: x_formula_dtl_tbl OUT NOCOPY gmdfmval_pub.formula_detail_tbl ,
24: x_recp_resc_proc_param_tbl OUT NOCOPY gmd_recipe_fetch_pub.recp_resc_proc_param_tbl
17: x_recipe_rout_matl_tbl OUT NOCOPY gmd_recipe_fetch_pub.recipe_rout_matl_tbl ,
18: x_recipe_step_out OUT NOCOPY gmd_recipe_fetch_pub.recipe_step_tbl ,
19: x_routing_depd_tbl OUT NOCOPY gmd_recipe_fetch_pub.routing_depd_tbl ,
20: x_oprn_act_out OUT NOCOPY gmd_recipe_fetch_pub.oprn_act_tbl ,
21: x_oprn_resc_rec OUT NOCOPY gmd_recipe_fetch_pub.oprn_resc_tbl ,
22: x_formula_header_rec OUT NOCOPY fm_form_mst%ROWTYPE ,
23: x_formula_dtl_tbl OUT NOCOPY gmdfmval_pub.formula_detail_tbl ,
24: x_recp_resc_proc_param_tbl OUT NOCOPY gmd_recipe_fetch_pub.recp_resc_proc_param_tbl
25: )
20: x_oprn_act_out OUT NOCOPY gmd_recipe_fetch_pub.oprn_act_tbl ,
21: x_oprn_resc_rec OUT NOCOPY gmd_recipe_fetch_pub.oprn_resc_tbl ,
22: x_formula_header_rec OUT NOCOPY fm_form_mst%ROWTYPE ,
23: x_formula_dtl_tbl OUT NOCOPY gmdfmval_pub.formula_detail_tbl ,
24: x_recp_resc_proc_param_tbl OUT NOCOPY gmd_recipe_fetch_pub.recp_resc_proc_param_tbl
25: )
26: IS
27:
28:
57: IF x_return_status <>p_return_status THEN
58: x_return_code := 3;
59: -- x_return_status := 3;
60: Else
61: gmd_recipe_fetch_pub.get_rout_hdr(p_api_version,p_init_msg_list, p_recipe_id,
62: x_return_status, x_msg_count, x_msg_data,
63: x_return_code, x_recipe_rout_tbl);
64:
65: IF x_return_status <>p_return_status THEN
65: IF x_return_status <>p_return_status THEN
66: x_return_code := 4 ;
67: -- x_return_status := 4;
68: ELSE
69: gmd_recipe_fetch_pub.get_step_depd_details( p_api_version,p_init_msg_list, p_recipe_id,
70: x_return_status, x_msg_count, x_msg_data,
71: x_return_code, x_routing_depd_tbl);
72:
73: IF x_return_status = 'U' THEN
72:
73: IF x_return_status = 'U' THEN
74: x_return_code := 8 ;
75: ELSE
76: gmd_recipe_fetch_pub.get_rout_material( p_api_version,p_init_msg_list, p_recipe_id, x_return_status, x_msg_count, x_msg_data,
77: x_return_code, x_recipe_rout_matl_tbl);
78:
79:
80: gmd_recipe_fetch_pub.get_recipe_step_details(p_api_version,p_init_msg_list, p_recipe_id,p_organization_id,
76: gmd_recipe_fetch_pub.get_rout_material( p_api_version,p_init_msg_list, p_recipe_id, x_return_status, x_msg_count, x_msg_data,
77: x_return_code, x_recipe_rout_matl_tbl);
78:
79:
80: gmd_recipe_fetch_pub.get_recipe_step_details(p_api_version,p_init_msg_list, p_recipe_id,p_organization_id,
81: x_return_status, x_msg_count, x_msg_data,
82: x_return_code, x_recipe_step_out);
83: IF x_return_status <>p_return_status THEN
84: x_return_code := 5;
83: IF x_return_status <>p_return_status THEN
84: x_return_code := 5;
85: -- x_return_status := 5;
86: ELSE
87: gmd_recipe_fetch_pub.get_oprn_act_detl(p_api_version,p_init_msg_list, p_recipe_id,p_organization_id,
88: x_return_status, x_msg_count, x_msg_data,
89: x_return_code, x_oprn_act_out);
90: IF x_return_status <>p_return_status THEN
91: x_return_code := 6;
90: IF x_return_status <>p_return_status THEN
91: x_return_code := 6;
92: -- x_return_status := 6;
93: ELSE
94: gmd_recipe_fetch_pub.get_oprn_resc_detl( p_api_version,p_init_msg_list, p_recipe_id,p_organization_id,
95: x_return_status, x_msg_count, x_msg_data,
96: x_return_code, x_oprn_resc_rec);
97: IF x_return_status <>p_return_status THEN
98:
98:
99: x_return_code := 7;
100: -- x_return_status := 7;
101: ELSE
102: gmd_recipe_fetch_pub.get_recipe_process_param_detl(p_api_version => p_api_version,
103: p_init_msg_list => p_init_msg_list,
104: p_recipe_id => p_recipe_id,
105: p_organization_id => p_organization_id,
106: x_return_status => x_return_status,