APPS.GR_LABEL_PROPERTIES_PKG dependencies on GR_LABEL_PROPERTIES

Line 1: PACKAGE BODY GR_LABEL_PROPERTIES_PKG AS

1: PACKAGE BODY GR_LABEL_PROPERTIES_PKG AS
2: /*$Header: GRHILPB.pls 120.1 2010/11/19 15:29:15 plowe ship $*/
3: PROCEDURE Insert_Row
4: (p_commit IN VARCHAR2,
5: p_called_by_form IN VARCHAR2,

Line 78: INSERT INTO gr_label_properties

74: IF FND_API.To_Boolean(l_key_exists) THEN
75: RAISE Item_Exists_Error;
76: END IF;
77:
78: INSERT INTO gr_label_properties
79: (sequence_number,
80: property_id,
81: label_code,
82: rollup_type,

Line 90: (gr_label_properties_s.nextval,

86: last_updated_by,
87: last_update_date,
88: last_update_login)
89: VALUES
90: (gr_label_properties_s.nextval,
91: p_property_id,
92: p_label_code,
93: P_rollup_type,
94: p_property_required,

Line 103: SELECT gr_label_properties_s.currval

99: p_last_update_login);
100:
101: /* Get the assigned sequence number */
102:
103: SELECT gr_label_properties_s.currval
104: INTO l_current_seq
105: FROM dual;
106:
107: /* Now get the row id of the inserted record */

Line 254: UPDATE gr_label_properties

250:
251: IF l_return_status <> 'S' THEN
252: RAISE Foreign_Key_Error;
253: ELSE
254: UPDATE gr_label_properties
255: SET property_id = p_property_id,
256: label_code = p_label_code,
257: rollup_type = P_rollup_type,
258: property_required = p_property_required,

Line 366: FROM gr_label_properties

362:
363: CURSOR c_lock_label_properties
364: IS
365: SELECT *
366: FROM gr_label_properties
367: WHERE rowid = p_rowid
368: FOR UPDATE NOWAIT;
369: LockLabelRcd c_lock_label_properties%ROWTYPE;
370:

Line 505: DELETE FROM gr_label_properties

501: IF l_return_status <> 'S' THEN
502: RAISE Check_Integrity_Error;
503: END IF;
504:
505: DELETE FROM gr_label_properties
506: WHERE rowid = p_rowid;
507:
508: /* Check the commit flag and if set, then commit the work. */
509:

Line 607: DELETE FROM gr_label_properties

603: RAISE Null_Delete_Option_Error;
604: ELSE
605: l_msg_token := p_label_code;
606:
607: DELETE FROM gr_label_properties
608: WHERE label_code = p_label_code;
609: END IF;
610: ELSIF p_delete_option = 'P' THEN
611: IF p_property_id IS NULL THEN

Line 617: DELETE FROM gr_label_properties

613: RAISE Null_Delete_Option_Error;
614: ELSE
615: l_msg_token := p_property_id;
616:
617: DELETE FROM gr_label_properties
618: WHERE property_id = p_property_id;
619: END IF;
620: ELSE
621: l_msg_token := 'Invalid Delete Option';

Line 838: FROM gr_label_properties lp

834:
835: CURSOR c_get_label_properties_rowid
836: IS
837: SELECT lp.rowid
838: FROM gr_label_properties lp
839: WHERE lp.sequence_number = p_sequence_number
840: AND lp.property_id = p_property_id
841: AND lp.label_code = p_label_code;
842: LabelTLRecord c_get_label_properties_rowid%ROWTYPE;

Line 874: END GR_LABEL_PROPERTIES_PKG;

870: END IF;
871:
872: END Check_Primary_Key;
873:
874: END GR_LABEL_PROPERTIES_PKG;