APPS.GR_GENERIC_ITEMS_B_PKG dependencies on GR_GENERIC_ITEMS_B

Line 1: PACKAGE BODY GR_GENERIC_ITEMS_B_PKG AS

1: PACKAGE BODY GR_GENERIC_ITEMS_B_PKG AS
2: /*$Header: GRHIGIBB.pls 115.7 2003/01/28 19:15:42 mgrosser ship $*/
3:
4: /* Melanie Grosser 23-Jan-2003 BUG 2761024
5: Modified Procedure Insert_Row to check to see if the inventory

Line 176: INSERT INTO gr_generic_items_b

172: RAISE Already_Linked_Error;
173: END IF;
174: /* Melanie Grosser 23-Jan-2003 BUG 2761024 - End of changes */
175:
176: INSERT INTO gr_generic_items_b
177: (item_code,
178: item_no,
179: default_document_name_flag,
180: document_rebuild_indicator,

Line 502: UPDATE gr_generic_items_b

498:
499: IF l_return_status <> 'S' THEN
500: RAISE Foreign_Key_Error;
501: ELSE
502: UPDATE gr_generic_items_b
503: SET item_code = p_item_code,
504: item_no = p_item_no,
505: default_document_name_flag = p_default_document_name_flag,
506: document_rebuild_indicator = p_document_rebuild_indicator,

Line 673: FROM gr_generic_items_b

669:
670: CURSOR c_lock_generic
671: IS
672: SELECT last_update_date
673: FROM gr_generic_items_b
674: WHERE rowid = p_rowid
675: FOR UPDATE NOWAIT;
676: LockGenericRcd c_lock_generic%ROWTYPE;
677:

Line 882: DELETE FROM gr_generic_items_b

878: IF l_return_status <> 'S' THEN
879: RAISE Check_Integrity_Error;
880: END IF;
881:
882: DELETE FROM gr_generic_items_b
883: WHERE rowid = p_rowid;
884:
885: /* Check the commit flag and if set, then commit the work. */
886:

Line 984: DELETE FROM gr_generic_items_b

980: RAISE Null_Delete_Option_Error;
981: ELSE
982: l_msg_token := p_item_code;
983:
984: DELETE FROM gr_generic_items_b
985: WHERE item_code = p_item_code;
986: END IF;
987: ELSIF p_delete_option = 'L' THEN
988: IF p_item_no IS NULL THEN

Line 994: DELETE FROM gr_generic_items_b

990: RAISE Null_Delete_Option_Error;
991: ELSE
992: l_msg_token := p_item_no;
993:
994: DELETE FROM gr_generic_items_b
995: WHERE item_no = p_item_no;
996: END IF;
997: END IF;
998:

Line 1309: FROM gr_generic_items_b gi

1305:
1306: CURSOR c_get_generic_rowid
1307: IS
1308: SELECT gi.rowid
1309: FROM gr_generic_items_b gi
1310: WHERE gi.item_code = p_item_code
1311: AND gi.item_no = p_item_no;
1312: GenericRecord c_get_generic_rowid%ROWTYPE;
1313:

Line 1379: FROM gr_generic_items_b

1375:
1376: /* Cursors */
1377: CURSOR c_check_master_item_assoc IS
1378: SELECT rowid
1379: FROM gr_generic_items_b
1380: WHERE item_code <> p_item_code
1381: AND item_no = p_item_no;
1382: MasterItemAssoc c_check_master_item_assoc%ROWTYPE;
1383:

Line 1411: END GR_GENERIC_ITEMS_B_PKG;

1407: END IF;
1408:
1409: END Check_Master_Item_Assoc;
1410:
1411: END GR_GENERIC_ITEMS_B_PKG;