DBA Data[Home] [Help]

APPS.JAI_PA_PREF_PKG dependencies on JAI_PA_SETUP_PREFERENCES_S

Line 99: , x_setup_preference_id in out nocopy jai_pa_setup_preferences.setup_preference_id%type

95: procedure insert_row
96: (
97: x_setup_preference_rec in jai_pa_setup_preferences%rowtype
98: , x_rowid in out nocopy rowid
99: , x_setup_preference_id in out nocopy jai_pa_setup_preferences.setup_preference_id%type
100: )
101: is
102: cursor c_get_setup_prefrence_id
103: is

Line 104: select jai_pa_setup_preferences_s.nextval

100: )
101: is
102: cursor c_get_setup_prefrence_id
103: is
104: select jai_pa_setup_preferences_s.nextval
105: from dual;
106:
107: begin
108: if x_setup_preference_id is null then

Line 169: procedure delete_row (x_setup_preference_id in jai_pa_setup_preferences.setup_preference_id%type)

165: end if;
166:
167: end update_row;
168:
169: procedure delete_row (x_setup_preference_id in jai_pa_setup_preferences.setup_preference_id%type)
170: is
171: begin
172: delete jai_pa_setup_preferences
173: where setup_preference_id = x_setup_preference_id;