APPS.JAI_RGM_LKPS_PKG dependencies on JAI_RGM_LOOKUPS

Line 39: from jai_rgm_lookups

35:
36: CURSOR cur_creation_date
37: IS
38: select creation_date, last_update_date
39: from jai_rgm_lookups
40: where regime_code = x_regime_code
41: and attribute_type_code = x_attribute_type_code
42: and attribute_code = x_attribute_code
43: and nvl(attribute_value, 0) = nvl(ltrim(rtrim(x_attribute_value)), 0) ;

Line 109: CURSOR C_LOOKUP_ID IS SELECT JAI_RGM_LOOKUPS_S.nextval FROM dual;

105: X_Last_Update_Date DATE,
106: X_Last_Updated_By NUMBER,
107: X_Created_by NUMBER,
108: X_Last_Update_Login NUMBER) IS
109: CURSOR C_LOOKUP_ID IS SELECT JAI_RGM_LOOKUPS_S.nextval FROM dual;
110: X_lookup_id NUMBER ;
111: BEGIN
112:
113: OPEN C_LOOKUP_ID;

Line 117: INSERT INTO JAI_RGM_LOOKUPS(

113: OPEN C_LOOKUP_ID;
114: FETCH C_LOOKUP_ID INTO X_lookup_id;
115: CLOSE C_LOOKUP_ID;
116:
117: INSERT INTO JAI_RGM_LOOKUPS(
118: lookup_id ,
119: regime_code ,
120: attribute_type_code ,
121: attribute_code ,

Line 164: UPDATE JAI_RGM_LOOKUPS

160: X_last_updated_by NUMBER,
161: X_last_update_login NUMBER)
162: IS
163: BEGIN
164: UPDATE JAI_RGM_LOOKUPS
165: SET
166: regime_code = x_regime_code ,
167: attribute_type_code = x_attribute_type_code ,
168: attribute_code = x_attribute_code ,