DBA Data[Home] [Help]

APPS.GMD_EBI_RECIPE_PUB dependencies on GMD_EBI_FORMULA_OBJ

Line 62: p_formula_obj IN gmd_ebi_formula_obj

58:
59: /* ======================================================================== */
60:
61: PROCEDURE assign_items_to_org(
62: p_formula_obj IN gmd_ebi_formula_obj
63: ,x_return_status OUT NOCOPY VARCHAR2
64: ,x_msg_data OUT NOCOPY VARCHAR2
65: )
66: IS

Line 123: p_formula_obj IN gmd_ebi_formula_obj

119:
120: /* ======================================================================== */
121:
122: PROCEDURE update_org_ids(
123: p_formula_obj IN gmd_ebi_formula_obj
124: ,x_formula_obj OUT NOCOPY gmd_ebi_formula_obj
125: ,x_msg_count OUT NOCOPY NUMBER
126: ,x_return_status OUT NOCOPY VARCHAR2
127: ,x_msg_data OUT NOCOPY VARCHAR2

Line 124: ,x_formula_obj OUT NOCOPY gmd_ebi_formula_obj

120: /* ======================================================================== */
121:
122: PROCEDURE update_org_ids(
123: p_formula_obj IN gmd_ebi_formula_obj
124: ,x_formula_obj OUT NOCOPY gmd_ebi_formula_obj
125: ,x_msg_count OUT NOCOPY NUMBER
126: ,x_return_status OUT NOCOPY VARCHAR2
127: ,x_msg_data OUT NOCOPY VARCHAR2
128: )

Line 131: l_formula_obj gmd_ebi_formula_obj;

127: ,x_msg_data OUT NOCOPY VARCHAR2
128: )
129: IS
130: l_org_id NUMBER;
131: l_formula_obj gmd_ebi_formula_obj;
132: BEGIN
133: x_return_status := FND_API.G_RET_STS_SUCCESS;
134: l_formula_obj := p_formula_obj;
135: IF l_formula_obj IS NOT NULL THEN

Line 158: p_formula_obj IN gmd_ebi_formula_obj

154: );
155: END;
156:
157: PROCEDURE update_item_ids(
158: p_formula_obj IN gmd_ebi_formula_obj
159: ,x_formula_obj OUT NOCOPY gmd_ebi_formula_obj
160: ,x_return_status OUT NOCOPY VARCHAR2
161: ,x_msg_data OUT NOCOPY VARCHAR2
162: )

Line 159: ,x_formula_obj OUT NOCOPY gmd_ebi_formula_obj

155: END;
156:
157: PROCEDURE update_item_ids(
158: p_formula_obj IN gmd_ebi_formula_obj
159: ,x_formula_obj OUT NOCOPY gmd_ebi_formula_obj
160: ,x_return_status OUT NOCOPY VARCHAR2
161: ,x_msg_data OUT NOCOPY VARCHAR2
162: )
163: IS

Line 165: l_formula_obj gmd_ebi_formula_obj;

161: ,x_msg_data OUT NOCOPY VARCHAR2
162: )
163: IS
164: l_item_id NUMBER;
165: l_formula_obj gmd_ebi_formula_obj;
166:
167: BEGIN
168: x_return_status := FND_API.G_RET_STS_SUCCESS;
169: l_formula_obj := p_formula_obj;

Line 205: p_input IN gmd_ebi_formula_obj

201:
202: /* ======================================================================== */
203:
204: PROCEDURE populate_output(
205: p_input IN gmd_ebi_formula_obj
206: ,p_line_delete_tbl IN gmd_ebi_formula_line_del_tbl
207: ,status_flag IN VARCHAR2
208: ,x_output OUT NOCOPY gmd_ebi_formula_output_obj
209: ,x_return_status OUT NOCOPY VARCHAR2

Line 1492: p_formula_obj IN gmd_ebi_formula_obj

1488:
1489: /* ======================================================================== */
1490:
1491: PROCEDURE sync_formula(
1492: p_formula_obj IN gmd_ebi_formula_obj
1493: ,x_line_delete_tbl OUT NOCOPY gmd_ebi_formula_line_del_tbl
1494: ,x_return_status OUT NOCOPY VARCHAR2
1495: ,x_msg_count OUT NOCOPY NUMBER
1496: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1982: l_formula_obj gmd_ebi_formula_obj;

1978: l_status VARCHAR2(10);
1979: l_ret_msg VARCHAR2(32000);
1980: l_error VARCHAR2(32000);
1981: l_msg_count NUMBER;
1982: l_formula_obj gmd_ebi_formula_obj;
1983: l_formula_obj_updated gmd_ebi_formula_obj;
1984: l_output gmd_ebi_formula_output_obj;
1985: l_formula_obj_inp gmd_ebi_formula_obj;
1986: l_recipe_out_tbl gmd_ebi_recipe_output_tbl := gmd_ebi_recipe_output_tbl();

Line 1983: l_formula_obj_updated gmd_ebi_formula_obj;

1979: l_ret_msg VARCHAR2(32000);
1980: l_error VARCHAR2(32000);
1981: l_msg_count NUMBER;
1982: l_formula_obj gmd_ebi_formula_obj;
1983: l_formula_obj_updated gmd_ebi_formula_obj;
1984: l_output gmd_ebi_formula_output_obj;
1985: l_formula_obj_inp gmd_ebi_formula_obj;
1986: l_recipe_out_tbl gmd_ebi_recipe_output_tbl := gmd_ebi_recipe_output_tbl();
1987: l_recipe_out_obj gmd_ebi_recipe_output_obj;

Line 1985: l_formula_obj_inp gmd_ebi_formula_obj;

1981: l_msg_count NUMBER;
1982: l_formula_obj gmd_ebi_formula_obj;
1983: l_formula_obj_updated gmd_ebi_formula_obj;
1984: l_output gmd_ebi_formula_output_obj;
1985: l_formula_obj_inp gmd_ebi_formula_obj;
1986: l_recipe_out_tbl gmd_ebi_recipe_output_tbl := gmd_ebi_recipe_output_tbl();
1987: l_recipe_out_obj gmd_ebi_recipe_output_obj;
1988: l_recipe_out_Ctr NUMBER := 1;
1989: l_create_attachment VARCHAR2(1);