APPS.GMD_SUBSTITUTION_PVT dependencies on DUAL

Line 333: from dual;

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
336: GMD_FORMULA_SUBSTITUTION_PKG.insert_row
337: (

Line 870: /* call individual private APIs */

866:
867: /* Rollback changes */
868: ROLLBACK;
869:
870: /* call individual private APIs */
871: -- Insert substitution header
872: -- Get the substitution_id
873: select gmd_item_substitution_hdr_s.nextval
874: into l_substitution_id

Line 875: from dual;

871: -- Insert substitution header
872: -- Get the substitution_id
873: select gmd_item_substitution_hdr_s.nextval
874: into l_substitution_id
875: from dual;
876:
877: -- Get the substitution max version
878: OPEN get_max_vers_plus_one(l_substitution_hdr_rec.substitution_name);
879: FETCH get_max_vers_plus_one INTO l_substitution_hdr_rec.substitution_version;

Line 903: from dual;

899: -- Insert substitution detail
900: -- set the primary key
901: select gmd_item_substitution_dtl_s.nextval
902: into l_substitution_line_id
903: from dual;
904:
905: Create_substitution_detail
906: ( p_substitution_line_id => l_substitution_line_id
907: , p_substitution_id => l_substitution_id