APPS.GR_ITEM_PROPERTIES_PKG dependencies on GR_ITEM_PROPERTIES

Line 1: PACKAGE BODY GR_ITEM_PROPERTIES_PKG AS

1: PACKAGE BODY GR_ITEM_PROPERTIES_PKG AS
2: /*$Header: GRHIIPB.pls 115.7 2002/10/24 21:27:57 gkelly ship $*/
3: PROCEDURE Insert_Row
4: (p_commit IN VARCHAR2,
5: p_called_by_form IN VARCHAR2,

Line 85: INSERT INTO gr_item_properties

81: IF FND_API.To_Boolean(l_key_exists) THEN
82: RAISE Item_Exists_Error;
83: END IF;
84: /*B1319565 Added for Technical Parameters */
85: INSERT INTO gr_item_properties
86: (item_code,
87: sequence_number,
88: property_id,
89: label_code,

Line 270: UPDATE gr_item_properties

266: IF l_return_status <> 'S' THEN
267: RAISE Foreign_Key_Error;
268: ELSE
269: /*B1319565 Added for Technical Parameters */
270: UPDATE gr_item_properties
271: SET item_code = p_item_code,
272: sequence_number = p_sequence_number,
273: property_id = p_property_id,
274: label_code = p_label_code,

Line 389: FROM gr_item_properties

385:
386: CURSOR c_lock_item_properties
387: IS
388: SELECT *
389: FROM gr_item_properties
390: WHERE rowid = p_rowid
391: FOR UPDATE NOWAIT;
392: LockItemPropRcd c_lock_item_properties%ROWTYPE;
393:

Line 534: DELETE FROM gr_item_properties

530: IF l_return_status <> 'S' THEN
531: RAISE Check_Integrity_Error;
532: END IF;
533:
534: DELETE FROM gr_item_properties
535: WHERE rowid = p_rowid;
536:
537: /* Check the commit flag and if set, then commit the work. */
538:

Line 638: DELETE FROM gr_item_properties

634: RAISE Null_Delete_Option_Error;
635: ELSE
636: l_msg_token := p_item_code;
637:
638: DELETE FROM gr_item_properties
639: WHERE item_code = p_item_code;
640: END IF;
641: ELSIF p_delete_option = 'L' THEN
642: IF p_label_code IS NULL THEN

Line 648: DELETE FROM gr_item_properties

644: RAISE Null_Delete_Option_Error;
645: ELSE
646: l_msg_token := p_label_code;
647:
648: DELETE FROM gr_item_properties
649: WHERE label_code = p_label_code;
650: END IF;
651: ELSIF p_delete_option = 'B' THEN
652: IF p_item_code IS NULL OR

Line 659: DELETE FROM gr_item_properties

655: RAISE Null_Delete_Option_Error;
656: ELSE
657: l_msg_token := p_item_code ||' ' || p_label_code;
658:
659: DELETE FROM gr_item_properties
660: WHERE item_code = p_item_code
661: AND label_code = p_label_code;
662: END IF;
663: END IF;

Line 897: FROM gr_item_properties ip

893:
894: CURSOR c_get_item_properties_rowid
895: IS
896: SELECT ip.rowid
897: FROM gr_item_properties ip
898: WHERE ip.item_code = p_item_code
899: AND ip.label_code = p_label_code
900: AND ip.property_id = p_property_id;
901: ItemPropertyRecord c_get_item_properties_rowid%ROWTYPE;

Line 933: END GR_ITEM_PROPERTIES_PKG;

929: END IF;
930:
931: END Check_Primary_Key;
932:
933: END GR_ITEM_PROPERTIES_PKG;