APPS.JAI_PA_PREF_PKG dependencies on JAI_PA_SETUP_PREFERENCES

Line 27: lr_setup_preference_rec jai_pa_setup_preferences%rowtype;

23: ) IS
24: lx_rowid rowid := null;
25: ln_user_id NUMBER := fnd_load_util.owner_id(x_owner);
26: vf_ludate DATE := to_date(x_last_update_date, 'DD-MM-YYYY HH:MI:SS');
27: lr_setup_preference_rec jai_pa_setup_preferences%rowtype;
28:
29: BEGIN
30: -- validate input parameters
31: IF(x_distribution_rule is NULL or x_context_id is null or x_last_update_date is null ) then

Line 42: from jai_pa_setup_preferences

38: DECLARE
39:
40: CURSOR cur_get_rec IS
41: select *
42: from jai_pa_setup_preferences
43: where distribution_rule = x_distribution_rule
44: and context_id = x_context_id;
45:
46: BEGIN

Line 97: x_setup_preference_rec in jai_pa_setup_preferences%rowtype

93: END load_row;
94:
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

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 114: insert into jai_pa_setup_preferences

110: FETCH c_get_setup_prefrence_id INTO x_setup_preference_id;
111: CLOSE c_get_setup_prefrence_id;
112: end if;
113:
114: insert into jai_pa_setup_preferences
115: (
116: setup_preference_id
117: ,distribution_rule
118: ,context_id

Line 142: ( x_setup_preference_rec in jai_pa_setup_preferences%rowtype

138:
139: end insert_row;
140:
141: procedure update_row
142: ( x_setup_preference_rec in jai_pa_setup_preferences%rowtype
143: )
144: is
145: begin
146:

Line 147: update jai_pa_setup_preferences

143: )
144: is
145: begin
146:
147: update jai_pa_setup_preferences
148: set
149: distribution_rule = x_setup_preference_rec.distribution_rule
150: ,context_id = x_setup_preference_rec.context_id
151: ,preference = x_setup_preference_rec.preference

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;

Line 172: delete jai_pa_setup_preferences

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;
174: end delete_row;
175:
176: end jai_pa_pref_pkg ;