APPS.GR_EIN_RISKS_PKG dependencies on GR_EIN_RISKS

Line 1: PACKAGE BODY GR_EIN_RISKS_PKG AS

1: PACKAGE BODY GR_EIN_RISKS_PKG AS
2: /*$Header: GRHIEIRB.pls 115.3 2002/10/29 16:43:45 mgrosser noship $*/
3: PROCEDURE Insert_Row
4: (p_commit IN VARCHAR2,
5: p_called_by_form IN VARCHAR2,

Line 73: INSERT INTO gr_ein_risks

69: IF FND_API.To_Boolean(l_key_exists) THEN
70: RAISE Item_Exists_Error;
71: END IF;
72:
73: INSERT INTO gr_ein_risks
74: (european_index_number,
75: risk_phrase_code,
76: created_by,
77: creation_date,

Line 228: UPDATE gr_ein_risks

224:
225: IF l_return_status <> 'S' THEN
226: RAISE Foreign_Key_Error;
227: ELSE
228: UPDATE gr_ein_risks
229: SET european_index_number = p_european_index_number,
230: risk_phrase_code = p_risk_phrase_code,
231: created_by = p_created_by,
232: creation_date = p_creation_date,

Line 335: FROM gr_ein_risks

331:
332: CURSOR c_lock_ein_risk
333: IS
334: SELECT last_update_date
335: FROM gr_ein_risks
336: WHERE rowid = p_rowid
337: FOR UPDATE NOWAIT;
338: LockEinRcd c_lock_ein_risk%ROWTYPE;
339: BEGIN

Line 466: DELETE FROM gr_ein_risks

462: IF l_return_status <> 'S' THEN
463: RAISE Check_Integrity_Error;
464: END IF;
465:
466: DELETE FROM gr_ein_risks
467: WHERE rowid = p_rowid;
468:
469: /* Check the commit flag and if set, then commit the work. */
470:

Line 551: DELETE FROM gr_ein_risks

547: x_oracle_error := 0;
548: x_msg_data := NULL;
549: l_msg_token := p_european_index_number;
550:
551: DELETE FROM gr_ein_risks
552: WHERE european_index_number = p_european_index_number;
553:
554: IF FND_API.To_Boolean(p_commit) THEN
555: COMMIT WORK;

Line 738: FROM gr_ein_risks eir

734:
735: CURSOR c_get_eir_rowid
736: IS
737: SELECT eir.rowid
738: FROM gr_ein_risks eir
739: WHERE eir.european_index_number = p_european_index_number
740: AND eir.risk_phrase_code = p_risk_phrase_code;
741: EirRecord c_get_eir_rowid%ROWTYPE;
742:

Line 771: END GR_EIN_RISKS_PKG;

767: END IF;
768:
769: END Check_Primary_Key;
770:
771: END GR_EIN_RISKS_PKG;