APPS.GMD_VAL_DATA_PUB dependencies on GMD_VALIDITY_RULES

Line 32: X_recipe_validity_out OUT NOCOPY GMD_VALIDITY_RULES.recipe_validity_tbl)

28: x_return_status OUT NOCOPY VARCHAR2 ,
29: x_msg_count OUT NOCOPY NUMBER ,
30: x_msg_data OUT NOCOPY VARCHAR2 ,
31: x_return_code OUT NOCOPY NUMBER ,
32: X_recipe_validity_out OUT NOCOPY GMD_VALIDITY_RULES.recipe_validity_tbl)
33: IS
34:
35:
36: /* local Variable*/

Line 45: l_recipe_validity_tab GMD_VALIDITY_RULES.recipe_validity_tbl;

41: l_return_status varchar2(1);
42: l_msg_count number;
43: l_msg_data varchar2(240);
44: l_return_code number;
45: l_recipe_validity_tab GMD_VALIDITY_RULES.recipe_validity_tbl;
46: j number default 0;
47:
48:
49: BEGIN

Line 52: GMD_VALIDITY_RULES.get_validity_rules(p_api_version,p_init_msg_list,p_recipe_no,p_recipe_version ,

48:
49: BEGIN
50: IF p_object_type = 'P' then
51:
52: GMD_VALIDITY_RULES.get_validity_rules(p_api_version,p_init_msg_list,p_recipe_no,p_recipe_version ,
53: p_recipe_id,p_total_input, p_total_output,p_formula_id,p_item_id,p_revision,
54: p_item_no,p_product_qty,p_uom,null,p_orgn_code,p_organization_id, p_least_cost_validity, p_start_date,
55: p_end_date,p_status_type,p_validity_rule_id, x_return_status,x_msg_count, x_msg_data,
56: x_return_code, X_recipe_validity_out);

Line 59: GMD_VALIDITY_RULES.get_validity_rules(p_api_version,p_init_msg_list,p_recipe_no,p_recipe_version ,

55: p_end_date,p_status_type,p_validity_rule_id, x_return_status,x_msg_count, x_msg_data,
56: x_return_code, X_recipe_validity_out);
57:
58: Elsif p_object_type = 'F' then
59: GMD_VALIDITY_RULES.get_validity_rules(p_api_version,p_init_msg_list,p_recipe_no,p_recipe_version ,
60: p_recipe_id,p_total_input, p_total_output,p_formula_id,p_item_id,p_revision,
61: p_item_no,p_product_qty,p_uom,1,p_orgn_code,p_organization_id, p_least_cost_validity, p_start_date,
62: p_end_date,p_status_type,p_validity_rule_id, x_return_status,x_msg_count, x_msg_data,
63: x_return_code, X_recipe_validity_out);

Line 69: GMD_VALIDITY_RULES.get_validity_rules(p_api_version,p_init_msg_list,p_recipe_no,p_recipe_version ,

65:
66:
67:
68: Elsif p_object_type = 'L' then
69: GMD_VALIDITY_RULES.get_validity_rules(p_api_version,p_init_msg_list,p_recipe_no,p_recipe_version ,
70: p_recipe_id,p_total_input, p_total_output,p_formula_id,p_item_id,p_revision,
71: p_item_no,p_product_qty,p_uom,null,p_orgn_code, p_organization_id, p_least_cost_validity, p_start_date,
72: p_end_date,p_status_type,p_validity_rule_id, x_return_status,x_msg_count, x_msg_data,
73: x_return_code, X_recipe_validity_out);

Line 75: GMD_VALIDITY_RULES.get_validity_rules(p_api_version,p_init_msg_list,p_recipe_no,p_recipe_version ,

71: p_item_no,p_product_qty,p_uom,null,p_orgn_code, p_organization_id, p_least_cost_validity, p_start_date,
72: p_end_date,p_status_type,p_validity_rule_id, x_return_status,x_msg_count, x_msg_data,
73: x_return_code, X_recipe_validity_out);
74:
75: GMD_VALIDITY_RULES.get_validity_rules(p_api_version,p_init_msg_list,p_recipe_no,p_recipe_version ,
76: p_recipe_id,p_total_input, p_total_output,p_formula_id,p_item_id,p_revision,
77: p_item_no,p_product_qty,p_uom,NULL,p_orgn_code,p_organization_id, p_least_cost_validity, p_start_date,
78: p_end_date,'400',p_validity_rule_id, x_return_status,x_msg_count, x_msg_data,
79: x_return_code, l_recipe_validity_tab);

Line 87: GMD_VALIDITY_RULES.get_validity_rules(p_api_version,p_init_msg_list,p_recipe_no,p_recipe_version ,

83: x_recipe_validity_out(j+i) := l_recipe_validity_tab(i);
84: END LOOP;
85:
86:
87: GMD_VALIDITY_RULES.get_validity_rules(p_api_version,p_init_msg_list,p_recipe_no,p_recipe_version ,
88: p_recipe_id,p_total_input, p_total_output,p_formula_id,p_item_id,p_revision,
89: p_item_no,p_product_qty,p_uom,NULL,p_orgn_code, p_organization_id, p_least_cost_validity, p_start_date,
90: p_end_date,'500',p_validity_rule_id, x_return_status,x_msg_count, x_msg_data,
91: x_return_code, l_recipe_validity_tab);

Line 99: GMD_VALIDITY_RULES.get_validity_rules(p_api_version,p_init_msg_list,p_recipe_no,p_recipe_version ,

95: x_recipe_validity_out(j+i) := l_recipe_validity_tab(i);
96: END LOOP;
97:
98:
99: GMD_VALIDITY_RULES.get_validity_rules(p_api_version,p_init_msg_list,p_recipe_no,p_recipe_version ,
100: p_recipe_id,p_total_input, p_total_output,p_formula_id,p_item_id,p_revision,
101: p_item_no,p_product_qty,p_uom,null,p_orgn_code,p_organization_id, p_least_cost_validity, p_start_date,
102: p_end_date,'600',p_validity_rule_id, x_return_status,x_msg_count, x_msg_data,
103: x_return_code, l_recipe_validity_tab);

Line 176: GMD_VALIDITY_RULES.get_all_validity_rules(p_api_version,p_init_msg_list, p_recipe_id,p_item_id,p_revision,p_least_cost_validity,

172: ELSIF p_object_type = 'G' then
173: -- BEGIN BUG#2436355 RajaSekhar
174: -- Added call to newly created procedure which gets all validity rules for the
175: -- recipe_id/item_id
176: GMD_VALIDITY_RULES.get_all_validity_rules(p_api_version,p_init_msg_list, p_recipe_id,p_item_id,p_revision,p_least_cost_validity,
177: x_return_status,x_msg_count, x_msg_data, x_return_code,
178: X_recipe_validity_out);
179: -- Code which calls get_validity_rules multiple times with different statuses is removed.
180: -- END BUG#2436355