APPS.PAY_ES_ONLINE_SOE dependencies on PAY_BALANCE_PKG

Line 120: l_defined_balance_lst pay_balance_pkg.t_balance_value_tab;

116: l_meaning_uom VARCHAR2(100);
117: l_currency_code VARCHAR2(100);
118: balCount NUMBER;
119: --
120: l_defined_balance_lst pay_balance_pkg.t_balance_value_tab;
121: l_context_lst pay_balance_pkg.t_context_tab;
122: l_output_table pay_balance_pkg.t_detailed_bal_out_tab;
123: --
124: i NUMBER;

Line 121: l_context_lst pay_balance_pkg.t_context_tab;

117: l_currency_code VARCHAR2(100);
118: balCount NUMBER;
119: --
120: l_defined_balance_lst pay_balance_pkg.t_balance_value_tab;
121: l_context_lst pay_balance_pkg.t_context_tab;
122: l_output_table pay_balance_pkg.t_detailed_bal_out_tab;
123: --
124: i NUMBER;
125: --

Line 122: l_output_table pay_balance_pkg.t_detailed_bal_out_tab;

118: balCount NUMBER;
119: --
120: l_defined_balance_lst pay_balance_pkg.t_balance_value_tab;
121: l_context_lst pay_balance_pkg.t_context_tab;
122: l_output_table pay_balance_pkg.t_detailed_bal_out_tab;
123: --
124: i NUMBER;
125: --
126: CURSOR getAction IS

Line 212: 'Y', pay_balance_pkg.find_context('SOURCE_ID'

208: select distinct
209: aa.tax_unit_id tax_unit_id
210: , rr.jurisdiction_code jurisdiction_code
211: , decode(l_si_needed_chr,
212: 'Y', pay_balance_pkg.find_context('SOURCE_ID'
213: ,rr.run_result_id)
214: ,null) source_id
215: , decode(l_st_needed_chr,
216: 'Y', pay_balance_pkg.find_context('SOURCE_TEXT'

Line 216: 'Y', pay_balance_pkg.find_context('SOURCE_TEXT'

212: 'Y', pay_balance_pkg.find_context('SOURCE_ID'
213: ,rr.run_result_id)
214: ,null) source_id
215: , decode(l_st_needed_chr,
216: 'Y', pay_balance_pkg.find_context('SOURCE_TEXT'
217: ,rr.run_result_id)
218: ,null) source_text
219: , decode(l_sn_needed_chr,
220: 'Y', pay_balance_pkg.find_context('SOURCE_NUMBER'

Line 220: 'Y', pay_balance_pkg.find_context('SOURCE_NUMBER'

216: 'Y', pay_balance_pkg.find_context('SOURCE_TEXT'
217: ,rr.run_result_id)
218: ,null) source_text
219: , decode(l_sn_needed_chr,
220: 'Y', pay_balance_pkg.find_context('SOURCE_NUMBER'
221: ,rr.run_result_id)
222: ,null) source_number
223: , decode(l_st2_needed_chr,
224: 'Y', pay_balance_pkg.find_context('SOURCE_TEXT2'

Line 224: 'Y', pay_balance_pkg.find_context('SOURCE_TEXT2'

220: 'Y', pay_balance_pkg.find_context('SOURCE_NUMBER'
221: ,rr.run_result_id)
222: ,null) source_number
223: , decode(l_st2_needed_chr,
224: 'Y', pay_balance_pkg.find_context('SOURCE_TEXT2'
225: ,rr.run_result_id)
226: ,null) source_text2
227: from pay_assignment_actions aa,
228: pay_payroll_actions pa,

Line 272: pay_balance_pkg.get_period_type_start

268: db.defined_balance_id;
269: l_balance_type_lst(db.defined_balance_id).meaning_uom:=
270: db.meaning;
271: --
272: pay_balance_pkg.get_period_type_start
273: (p_period_type => db.period_type
274: ,p_effective_date => l_effective_date
275: ,p_payroll_id => l_payroll_id
276: ,p_start_date => l_temp_date);

Line 345: pay_balance_pkg.get_value (p_assignment_action_id => p_assignment_action_id

341: l_context_lst(i).SOURCE_TEXT2 := ctx.SOURCE_TEXT2;
342: end loop;
343: end if;
344: --
345: pay_balance_pkg.get_value (p_assignment_action_id => p_assignment_action_id
346: ,p_defined_balance_lst => l_defined_balance_lst
347: ,p_context_lst => l_context_lst
348: ,p_output_table => l_output_table);
349: --