APPS.GR_RISK_COMBINATIONS_PKG dependencies on GR_RISK_COMBINATIONS

Line 1: PACKAGE BODY GR_RISK_COMBINATIONS_PKG AS

1: PACKAGE BODY GR_RISK_COMBINATIONS_PKG AS
2: /*$Header: GRHIRCB.pls 115.4 2002/10/28 16:15:39 gkelly ship $*/
3: PROCEDURE Insert_Row
4: (p_commit IN VARCHAR2,
5: p_called_by_form IN VARCHAR2,

Line 78: INSERT INTO gr_risk_combinations

74: IF FND_API.To_Boolean(l_key_exists) THEN
75: RAISE Item_Exists_Error;
76: END IF;
77:
78: INSERT INTO gr_risk_combinations
79: (combination_sequence_number,
80: risk_phrase_code,
81: combination_group_number,
82: risk_phrase_code_combo,

Line 90: (gr_risk_combinations_s.nextval,

86: last_updated_by,
87: last_update_date,
88: last_update_login)
89: VALUES
90: (gr_risk_combinations_s.nextval,
91: p_risk_phrase_code,
92: p_combination_group_number,
93: p_risk_phrase_code_combo,
94: p_display_order,

Line 103: SELECT gr_risk_combinations_s.currval

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

Line 248: UPDATE gr_risk_combinations

244:
245: IF l_return_status <> 'S' THEN
246: RAISE Foreign_Key_Error;
247: ELSE
248: UPDATE gr_risk_combinations
249: SET combination_sequence_number = p_combination_sequence,
250: risk_phrase_code = p_risk_phrase_code,
251: combination_group_number = p_combination_group_number,
252: risk_phrase_code_combo = p_risk_phrase_code_combo,

Line 360: FROM gr_risk_combinations

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

Line 495: DELETE FROM gr_risk_combinations

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

Line 580: DELETE FROM gr_risk_combinations

576: x_oracle_error := 0;
577: x_msg_data := NULL;
578: l_msg_token := p_risk_phrase_code;
579:
580: DELETE FROM gr_risk_combinations
581: WHERE risk_phrase_code = p_risk_phrase_code;
582:
583: IF FND_API.To_Boolean(p_commit) THEN
584: COMMIT WORK;

Line 780: FROM gr_risk_combinations rc

776:
777: CURSOR c_get_combo_rowid
778: IS
779: SELECT rc.rowid
780: FROM gr_risk_combinations rc
781: WHERE rc.combination_sequence_number = p_combination_sequence;
782: ComboRecord c_get_combo_rowid%ROWTYPE;
783:
784: BEGIN

Line 812: END GR_RISK_COMBINATIONS_PKG;

808: END IF;
809:
810: END Check_Primary_Key;
811:
812: END GR_RISK_COMBINATIONS_PKG;