DBA Data[Home] [Help]

APPS.GMD_RECIPE_DATA_PUB dependencies on GMD_RECIPE_FETCH_PUB

Line 16: x_recipe_rout_tbl OUT NOCOPY gmd_recipe_fetch_pub.recipe_rout_tbl ,

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 ,

Line 17: x_recipe_rout_matl_tbl OUT NOCOPY gmd_recipe_fetch_pub.recipe_rout_matl_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 ,

Line 18: x_recipe_step_out OUT NOCOPY gmd_recipe_fetch_pub.recipe_step_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 ,

Line 19: x_routing_depd_tbl OUT NOCOPY gmd_recipe_fetch_pub.routing_depd_tbl ,

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 ,

Line 20: x_oprn_act_out OUT NOCOPY gmd_recipe_fetch_pub.oprn_act_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

Line 21: x_oprn_resc_rec OUT NOCOPY gmd_recipe_fetch_pub.oprn_resc_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: )

Line 24: x_recp_resc_proc_param_tbl OUT NOCOPY gmd_recipe_fetch_pub.recp_resc_proc_param_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: )
26: IS
27:
28:

Line 61: gmd_recipe_fetch_pub.get_rout_hdr(p_api_version,p_init_msg_list, p_recipe_id,

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

Line 69: gmd_recipe_fetch_pub.get_step_depd_details( p_api_version,p_init_msg_list, p_recipe_id,

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

Line 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,

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,

Line 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;

Line 87: gmd_recipe_fetch_pub.get_oprn_act_detl(p_api_version,p_init_msg_list, p_recipe_id,p_organization_id,

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;

Line 94: gmd_recipe_fetch_pub.get_oprn_resc_detl( p_api_version,p_init_msg_list, p_recipe_id,p_organization_id,

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:

Line 102: gmd_recipe_fetch_pub.get_recipe_process_param_detl(p_api_version => p_api_version,

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,