APPS.GMD_SUBSTITUTION_PVT dependencies on GMD_FORMULA_SUBSTITUTION

Line 7: FROM gmd_item_substitution_hdr_b i, gmd_formula_substitution f

3:
4: -- common cursors
5: CURSOR Cur_get_substitution(vSubstitution_id NUMBER) IS
6: SELECT i.original_inventory_item_id, i.start_date, i.substitution_status, f.formula_id
7: FROM gmd_item_substitution_hdr_b i, gmd_formula_substitution f
8: WHERE i.substitution_id = vSubstitution_id
9: AND i.substitution_id = f.substitution_id;
10:
11: CURSOR Cur_check_substitute (V_formula_id NUMBER

Line 15: FROM gmd_item_substitution_hdr_b i, gmd_formula_substitution f

11: CURSOR Cur_check_substitute (V_formula_id NUMBER
12: , V_item_id NUMBER
13: , p_substitution_id NUMBER) IS
14: SELECT MIN(i.start_date)
15: FROM gmd_item_substitution_hdr_b i, gmd_formula_substitution f
16: WHERE f.formula_id = V_formula_id
17: AND i.original_inventory_item_id = V_item_id
18: AND i.substitution_id <> p_substitution_id
19: AND i.substitution_id = f.substitution_id

Line 290: ( p_substitution_id IN gmd_formula_substitution.substitution_id%TYPE

286: /* History : */
287: /* Rajender Nalla 09-OCT-06 Initial implementation. */
288: /* =============================================================== */
289: PROCEDURE Create_formula_association
290: ( p_substitution_id IN gmd_formula_substitution.substitution_id%TYPE
291: , p_formula_substitution_tbl IN gmd_substitution_pub.gmd_formula_substitution_tab
292: , x_message_count OUT NOCOPY NUMBER
293: , x_message_list OUT NOCOPY VARCHAR2
294: , x_return_status OUT NOCOPY VARCHAR2

Line 291: , p_formula_substitution_tbl IN gmd_substitution_pub.gmd_formula_substitution_tab

287: /* Rajender Nalla 09-OCT-06 Initial implementation. */
288: /* =============================================================== */
289: PROCEDURE Create_formula_association
290: ( p_substitution_id IN gmd_formula_substitution.substitution_id%TYPE
291: , p_formula_substitution_tbl IN gmd_substitution_pub.gmd_formula_substitution_tab
292: , x_message_count OUT NOCOPY NUMBER
293: , x_message_list OUT NOCOPY VARCHAR2
294: , x_return_status OUT NOCOPY VARCHAR2
295: ) IS

Line 331: select gmd_formula_substitution_s.nextval

327: END IF;
328:
329: FOR i in 1 .. p_formula_substitution_tbl.count LOOP
330: -- get the formula substitution id
331: select gmd_formula_substitution_s.nextval
332: into l_formula_substitution_id
333: from dual;
334:
335: -- Call the table handler for insert of formula substitution

Line 336: GMD_FORMULA_SUBSTITUTION_PKG.insert_row

332: into l_formula_substitution_id
333: from dual;
334:
335: -- Call the table handler for insert of formula substitution
336: GMD_FORMULA_SUBSTITUTION_PKG.insert_row
337: (
338: X_ROWID => l_row_id
339: , X_FORMULA_SUBSTITUTION_ID => l_formula_substitution_id
340: , X_SUBSTITUTION_ID => p_substitution_id

Line 657: From gmd_item_substitution_hdr_b i, gmd_formula_substitution f

653: l_substitution_id NUMBER;
654:
655: CURSOR get_fm_and_orig_item(vformula_substitution_id NUMBER) IS
656: Select formula_id, original_inventory_item_id, i.substitution_id
657: From gmd_item_substitution_hdr_b i, gmd_formula_substitution f
658: Where f.formula_substitution_id = vformula_substitution_id
659: AND i.substitution_id = f.substitution_id;
660:
661: CURSOR Cur_get_sub_end_date(vformula_id NUMBER,

Line 666: gmd_formula_substitution y

662: vOriginal_item_id NUMBER,
663: vSubstitution_id NUMBER) IS
664: SELECT MIN(z.start_date)
665: FROM gmd_item_substitution_hdr_b z,
666: gmd_formula_substitution y
667: WHERE y.substitution_id <> vSubstitution_id
668: AND z.substitution_id = y.substitution_id
669: AND z.original_inventory_item_id = vOriginal_item_id
670: AND y.formula_id = vformula_id

Line 683: GMD_FORMULA_SUBSTITUTION_PKG.DELETE_ROW

679: , l_substitution_id;
680: CLOSE get_fm_and_orig_item;
681:
682: -- Call the table handler for delete of formula substitution association
683: GMD_FORMULA_SUBSTITUTION_PKG.DELETE_ROW
684: (
685: X_FORMULA_SUBSTITUTION_ID => p_formula_substitution_id
686: );
687:

Line 748: l_formula_substitution_tbl gmd_substitution_pub.gmd_formula_substitution_tab;

744:
745: -- local record structure
746: l_substitution_hdr_rec gmd_substitution_pub.gmd_substitution_hdr_rec_type;
747: l_substitution_dtl_rec gmd_substitution_pub.gmd_substitution_dtl_rec_type;
748: l_formula_substitution_tbl gmd_substitution_pub.gmd_formula_substitution_tab;
749:
750: -- local variables
751: l_substitution_id NUMBER;
752: l_substitution_line_id NUMBER;

Line 841: FROM gmd_formula_substitution

837: , created_by
838: , last_update_date
839: , last_updated_by
840: , last_update_login
841: FROM gmd_formula_substitution
842: WHERE substitution_id = vSubstitution_id;
843:
844: -- Exception declaration
845: substitution_creation_failure EXCEPTION;