APPS.GR_LABELS_B_PKG dependencies on GR_LABELS_B

Line 1: PACKAGE BODY GR_LABELS_B_PKG AS

1: PACKAGE BODY GR_LABELS_B_PKG AS
2: /*$Header: GRHILABB.pls 115.16 2002/10/28 15:03:21 methomas ship $*/
3: PROCEDURE Insert_Row
4: (p_commit IN VARCHAR2,
5: p_called_by_form IN VARCHAR2,

Line 162: INSERT INTO gr_labels_b

158: RAISE Label_Exists_Error;
159: END IF;
160: /*B1319565 Added for Technical Parameters */
161: /*B1979042 Added column rollup_disclosure code*/
162: INSERT INTO gr_labels_b
163: (label_code,
164: safety_category_code,
165: label_class_code,
166: data_position_indicator,

Line 497: UPDATE gr_labels_b

493: RAISE Foreign_Key_Error;
494: ELSE
495: /*B1319565 Added for Technical Parameters */
496: /*B1979042 Added column p_rollup_disclosure code*/
497: UPDATE gr_labels_b
498: SET label_code = p_label_code,
499: safety_category_code = p_safety_category_code,
500: label_class_code = p_label_class_code,
501: data_position_indicator = p_data_position_indicator,

Line 693: FROM gr_labels_b

689:
690: CURSOR c_lock_label
691: IS
692: SELECT *
693: FROM gr_labels_b
694: WHERE rowid = p_rowid
695: FOR UPDATE NOWAIT;
696: LockLabelRcd c_lock_label%ROWTYPE;
697:

Line 914: DELETE FROM gr_labels_b

910: IF l_return_status <> 'S' THEN
911: RAISE Check_Integrity_Error;
912: END IF;
913:
914: DELETE FROM gr_labels_b
915: WHERE rowid = p_rowid;
916:
917: /* Check the commit flag and if set, then commit the work. */
918:

Line 1499: FROM gr_labels_b lab

1495:
1496: CURSOR c_get_label_rowid
1497: IS
1498: SELECT lab.rowid
1499: FROM gr_labels_b lab
1500: WHERE lab.label_code = p_label_code;
1501: LabelRecord c_get_label_rowid%ROWTYPE;
1502:
1503: BEGIN

Line 1532: END GR_LABELS_B_PKG;

1528: END IF;
1529:
1530: END Check_Primary_Key;
1531:
1532: END GR_LABELS_B_PKG;