APPS.GR_INV_ITEM_PROPERTIES_PKG dependencies on GR_INV_ITEM_PROPERTIES

Line 1: PACKAGE BODY GR_INV_ITEM_PROPERTIES_PKG AS

1: PACKAGE BODY GR_INV_ITEM_PROPERTIES_PKG AS
2: /*$Header: GRHIIIPB.pls 120.1 2005/08/05 08:57:13 schandru noship $*/
3: PROCEDURE Insert_Row
4: (p_commit IN VARCHAR2,
5: p_called_by_form IN VARCHAR2,

Line 84: INSERT INTO gr_inv_item_properties

80:
81: IF FND_API.To_Boolean(l_key_exists) THEN
82: RAISE Item_Exists_Error;
83: END IF;
84: INSERT INTO gr_inv_item_properties
85: (organization_id,
86: inventory_item_id,
87: sequence_number,
88: property_id,

Line 272: select count(*) into l_count from gr_inv_item_properties where rowid = p_rowid;

268: IF l_return_status <> 'S' THEN
269: RAISE Foreign_Key_Error;
270: ELSE
271: -- Bug 4510201 Start
272: select count(*) into l_count from gr_inv_item_properties where rowid = p_rowid;
273: -- Bug 4510201 End
274: UPDATE gr_inv_item_properties
275: SET organization_id = p_organization_id,
276: inventory_item_id = p_inventory_item_id,

Line 274: UPDATE gr_inv_item_properties

270: ELSE
271: -- Bug 4510201 Start
272: select count(*) into l_count from gr_inv_item_properties where rowid = p_rowid;
273: -- Bug 4510201 End
274: UPDATE gr_inv_item_properties
275: SET organization_id = p_organization_id,
276: inventory_item_id = p_inventory_item_id,
277: sequence_number = p_sequence_number,
278: property_id = p_property_id,

Line 398: FROM gr_inv_item_properties

394:
395: CURSOR c_lock_item_properties
396: IS
397: SELECT *
398: FROM gr_inv_item_properties
399: WHERE rowid = p_rowid
400: FOR UPDATE NOWAIT;
401: LockItemPropRcd c_lock_item_properties%ROWTYPE;
402:

Line 542: DELETE FROM gr_inv_item_properties

538: IF l_return_status <> 'S' THEN
539: RAISE Check_Integrity_Error;
540: END IF;
541:
542: DELETE FROM gr_inv_item_properties
543: WHERE rowid = p_rowid;
544:
545: /* Check the commit flag and if set, then commit the work. */
546:

Line 647: DELETE FROM gr_inv_item_properties

643: RAISE Null_Delete_Option_Error;
644: ELSE
645: l_msg_token := p_organization_id || p_inventory_item_id;
646:
647: DELETE FROM gr_inv_item_properties
648: WHERE organization_id = p_organization_id
649: AND inventory_item_id = p_inventory_item_id;
650: END IF;
651: ELSIF p_delete_option = 'L' THEN

Line 658: DELETE FROM gr_inv_item_properties

654: RAISE Null_Delete_Option_Error;
655: ELSE
656: l_msg_token := p_label_code;
657:
658: DELETE FROM gr_inv_item_properties
659: WHERE label_code = p_label_code;
660: END IF;
661: ELSIF p_delete_option = 'B' THEN
662: IF (p_organization_id IS NULL AND p_inventory_item_id IS NULL) OR

Line 669: DELETE FROM gr_inv_item_properties

665: RAISE Null_Delete_Option_Error;
666: ELSE
667: l_msg_token := p_organization_id || ' ' || p_inventory_item_id ||' ' || p_label_code;
668:
669: DELETE FROM gr_inv_item_properties
670: WHERE organization_id = p_organization_id
671: AND inventory_item_id = p_inventory_item_id
672: AND label_code = p_label_code;
673: END IF;

Line 919: FROM gr_inv_item_properties ip

915:
916: CURSOR c_get_item_properties_rowid
917: IS
918: SELECT ip.rowid
919: FROM gr_inv_item_properties ip
920: WHERE ip.organization_id = p_organization_id
921: AND ip.inventory_item_id = p_inventory_item_id
922: AND ip.label_code = p_label_code
923: AND ip.property_id = p_property_id;

Line 956: END GR_INV_ITEM_PROPERTIES_PKG;

952: END IF;
953:
954: END Check_Primary_Key;
955:
956: END GR_INV_ITEM_PROPERTIES_PKG;