APPS.GMD_SUBSTITUTION_PUB dependencies on GMD_ITEM_SUBSTITUTION_HDR

Line 8: FROM gmd_item_substitution_hdr_b

4: -- Common cursors used
5: CURSOR get_substitution_id(vSubstitution_name VARCHAR2
6: ,vSubstitution_version NUMBER) IS
7: SELECT substitution_id
8: FROM gmd_item_substitution_hdr_b
9: WHERE substitution_name = vSubstitution_name
10: AND substitution_version = vSubstitution_version;
11:
12: CURSOR validate_formula_item(vFormula_id NUMBER,

Line 54: FROM gmd_item_substitution_hdr_b

50: FUNCTION is_update_allowed(p_substitution_id IN NUMBER)
51: RETURN BOOLEAN IS
52: CURSOR get_subs_info(vSubstitution_id NUMBER) IS
53: SELECT substitution_status
54: FROM gmd_item_substitution_hdr_b
55: WHERE substitution_id = p_substitution_id;
56:
57: l_status_code GMD_STATUS.Status_Code%TYPE;
58: l_delete_mark NUMBER := 0;

Line 125: FROM gmd_item_substitution_hdr_b

121: ,vPreference NUMBER
122: ,vStart_date DATE
123: ,vEnd_date DATE) IS
124: SELECT 1
125: FROM gmd_item_substitution_hdr_b
126: WHERE substitution_id <> vSubstitution_id
127: AND original_inventory_item_id = vOriginal_item_id
128: AND preference = vPreference
129: AND vStart_date >= start_date

Line 216: select gmd_item_substitution_hdr_s.nextval

212: RAISE substitution_creation_failure;
213: END IF;
214:
215: -- get the substitution_id from sequence
216: select gmd_item_substitution_hdr_s.nextval
217: into l_substitution_id
218: from dual;
219:
220: -- substitution_description

Line 693: FROM gmd_item_substitution_hdr_b

689: RETURN NUMBER IS
690: l_item_id NUMBER := 0;
691: BEGIN
692: SELECT original_inventory_item_id INTO l_item_id
693: FROM gmd_item_substitution_hdr_b
694: Where substitution_id = vSubstitution_id;
695:
696: RETURN l_item_id;
697: END get_original_item_id;

Line 919: From gmd_item_substitution_hdr

915:
916: -- Cursor definition
917: CURSOR get_old_substitution_rec(vSubstitution_id NUMBER) IS
918: Select *
919: From gmd_item_substitution_hdr
920: Where substitution_id = vSubstitution_id;
921:
922: -- local variables
923: l_substitution_id NUMBER;

Line 928: l_substitution_hdr_rec gmd_item_substitution_hdr%ROWTYPE;

924: l_owner_orgn_id NUMBER;
925: l_api_name CONSTANT VARCHAR2(30) := 'Update_substitution_header';
926:
927: -- get a record type
928: l_substitution_hdr_rec gmd_item_substitution_hdr%ROWTYPE;
929:
930: -- Exception declaration
931: substitution_update_failure EXCEPTION;
932: invalid_version EXCEPTION;

Line 1217: From gmd_item_substitution_hdr_b

1213: Where substitution_id = vSubstitution_id;
1214:
1215: CURSOR get_substitution_hdr_dtl(vSubstitution_id NUMBER) IS
1216: Select original_inventory_item_id, replacement_uom_type
1217: From gmd_item_substitution_hdr_b
1218: Where substitution_id = vSubstitution_id;
1219:
1220:
1221: -- local variables