APPS.JAI_RGM_DEFS_PKG dependencies on JAI_RGM_DEFINITIONS

Line 33: from JAI_RGM_DEFINITIONS

29: DECLARE
30:
31: CURSOR cur_creation_date IS
32: select creation_date, last_update_date
33: from JAI_RGM_DEFINITIONS
34: where regime_code = x_regime_code ;
35:
36: BEGIN
37: /* Check if the row exists in the database. If it does, retrieves the creation date for update_row. */

Line 88: CURSOR C_REGIME_ID IS SELECT JAI_RGM_DEFINITIONS_S.nextval FROM dual;

84: X_last_updated_by NUMBER,
85: X_creation_date DATE ,
86: X_created_by NUMBER,
87: X_last_update_login NUMBER) IS
88: CURSOR C_REGIME_ID IS SELECT JAI_RGM_DEFINITIONS_S.nextval FROM dual;
89: X_regime_id NUMBER ;
90: BEGIN
91: OPEN C_REGIME_ID;
92: FETCH C_REGIME_ID INTO X_regime_id;

Line 95: INSERT INTO JAI_RGM_DEFINITIONS(

91: OPEN C_REGIME_ID;
92: FETCH C_REGIME_ID INTO X_regime_id;
93: CLOSE C_REGIME_ID;
94:
95: INSERT INTO JAI_RGM_DEFINITIONS(
96: regime_id ,
97: regime_code ,
98: description ,
99: creation_date ,

Line 127: UPDATE JAI_RGM_DEFINITIONS

123: X_last_updated_by NUMBER,
124: X_last_update_login NUMBER)
125: IS
126: BEGIN
127: UPDATE JAI_RGM_DEFINITIONS
128: SET
129: regime_code = x_regime_code ,
130: description = x_description ,
131: creation_date = x_creation_date ,