APPS.GMD_SUBSTITUTION_PUB dependencies on GMD_ITEM_SUBSTITUTION_DTL

Line 401: select gmd_item_substitution_dtl_s.nextval

397: END IF;
398:
399: /* Required fields at detail level */
400: -- set the primary key
401: select gmd_item_substitution_dtl_s.nextval
402: into l_substitution_line_id
403: from dual;
404:
405: -- substitute item_id

Line 1207: From gmd_item_substitution_dtl

1203: , x_return_status OUT NOCOPY VARCHAR2
1204: ) IS
1205: CURSOR get_subsdtl_rec_using_line_id(vSubstitution_line_id NUMBER) IS
1206: Select *
1207: From gmd_item_substitution_dtl
1208: Where substitution_line_id = vSubstitution_line_id;
1209:
1210: CURSOR get_subsdtl_rec_using_hdr_id(vSubstitution_id NUMBER) IS
1211: Select *

Line 1212: From gmd_item_substitution_dtl

1208: Where substitution_line_id = vSubstitution_line_id;
1209:
1210: CURSOR get_subsdtl_rec_using_hdr_id(vSubstitution_id NUMBER) IS
1211: Select *
1212: From gmd_item_substitution_dtl
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

Line 1233: l_substitution_dtl_rec gmd_item_substitution_dtl%ROWTYPE;

1229: l_substitute_item_no VARCHAR2(1000);
1230: l_replacement_uom_type NUMBER;
1231: l_dummy NUMBER := 0;
1232:
1233: l_substitution_dtl_rec gmd_item_substitution_dtl%ROWTYPE;
1234:
1235: -- Exception declaration
1236: substitution_update_failure EXCEPTION;
1237: invalid_version EXCEPTION;