APPS.GR_SAFETY_COMBINATIONS_PKG dependencies on GR_SAFETY_COMBINATIONS

Line 1: PACKAGE BODY GR_SAFETY_COMBINATIONS_PKG AS

1: PACKAGE BODY GR_SAFETY_COMBINATIONS_PKG AS
2: /*$Header: GRHISCB.pls 115.4 2002/10/28 16:49:37 gkelly ship $*/
3: PROCEDURE Insert_Row
4: (p_commit IN VARCHAR2,
5: p_called_by_form IN VARCHAR2,

Line 77: INSERT INTO gr_safety_combinations

73: IF FND_API.To_Boolean(l_key_exists) THEN
74: RAISE Item_Exists_Error;
75: END IF;
76:
77: INSERT INTO gr_safety_combinations
78: (combination_sequence_number,
79: safety_phrase_code,
80: combination_group_number,
81: safety_phrase_code_combo,

Line 89: (gr_safety_combinations_s.nextval,

85: last_updated_by,
86: last_update_date,
87: last_update_login)
88: VALUES
89: (gr_safety_combinations_s.nextval,
90: p_safety_phrase_code,
91: p_combination_group_number,
92: p_safety_phrase_code_combo,
93: p_display_order,

Line 102: SELECT gr_safety_combinations_s.currval

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

Line 248: UPDATE gr_safety_combinations

244:
245: IF l_return_status <> 'S' THEN
246: RAISE Foreign_Key_Error;
247: ELSE
248: UPDATE gr_safety_combinations
249: SET combination_sequence_number = p_combination_sequence,
250: safety_phrase_code = p_safety_phrase_code,
251: combination_group_number = p_combination_group_number,
252: safety_phrase_code_combo = p_safety_phrase_code_combo,

Line 360: FROM gr_safety_combinations

356:
357: CURSOR c_lock_combinations
358: IS
359: SELECT *
360: FROM gr_safety_combinations
361: WHERE rowid = p_rowid
362: FOR UPDATE NOWAIT;
363: LockComboRcd c_lock_combinations%ROWTYPE;
364:

Line 496: DELETE FROM gr_safety_combinations

492: IF l_return_status <> 'S' THEN
493: RAISE Check_Integrity_Error;
494: END IF;
495:
496: DELETE FROM gr_safety_combinations
497: WHERE rowid = p_rowid;
498:
499: /* Check the commit flag and if set, then commit the work. */
500:

Line 582: DELETE FROM gr_safety_combinations

578: x_oracle_error := 0;
579: x_msg_data := NULL;
580: l_msg_token := p_safety_phrase_code;
581:
582: DELETE FROM gr_safety_combinations
583: WHERE safety_phrase_code = p_safety_phrase_code;
584:
585: IF FND_API.To_Boolean(p_commit) THEN
586: COMMIT WORK;

Line 789: FROM gr_safety_combinations sc

785:
786: CURSOR c_get_combo_rowid
787: IS
788: SELECT sc.rowid
789: FROM gr_safety_combinations sc
790: WHERE sc.combination_sequence_number = p_combination_sequence;
791: ComboRecord c_get_combo_rowid%ROWTYPE;
792:
793: BEGIN

Line 821: END GR_SAFETY_COMBINATIONS_PKG;

817: END IF;
818:
819: END Check_Primary_Key;
820:
821: END GR_SAFETY_COMBINATIONS_PKG;