eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_PAYMENT_GL_ACCOUNTS_PKG dependencies on PAY_PAYMENT_GL_ACCOUNTS_F

Line 18: cursor C is select ROWID from PAY_PAYMENT_GL_ACCOUNTS_F

14: P_ORG_PAYMENT_METHOD_ID in NUMBER,
15: P_DEFAULT_GL_ACCOUNT in VARCHAR2
16: ) is
17: --
18: cursor C is select ROWID from PAY_PAYMENT_GL_ACCOUNTS_F
19: where PAY_GL_ACCOUNT_ID = P_PAY_GL_ACCOUNT_ID
20: ;
21: --
22: l_def_gl_acct_id pay_payment_gl_accounts_f.pay_gl_account_id%type;

Line 22: l_def_gl_acct_id pay_payment_gl_accounts_f.pay_gl_account_id%type;

18: cursor C is select ROWID from PAY_PAYMENT_GL_ACCOUNTS_F
19: where PAY_GL_ACCOUNT_ID = P_PAY_GL_ACCOUNT_ID
20: ;
21: --
22: l_def_gl_acct_id pay_payment_gl_accounts_f.pay_gl_account_id%type;
23: l_external_account_id pay_org_payment_methods_f.external_account_id%type;
24: l_org_payment_method_id pay_org_payment_methods_f.org_payment_method_id%type;
25: l_effective_start_date date;
26: l_effective_end_date date;

Line 97: update pay_payment_gl_accounts_f

93: (p_gl_account_id => p_gl_error_ac_id
94: );
95: --
96:
97: update pay_payment_gl_accounts_f
98: set
99: set_of_books_id = p_set_of_books_id,
100: gl_cash_ac_id = p_gl_cash_ac_id,
101: gl_cash_clearing_ac_id = p_gl_cash_clearing_ac_id,

Line 188: l_opm_gl_acct_id pay_payment_gl_accounts_f.pay_gl_account_id%type;

184: l_ovn number;
185: l_ovn_seq number;
186: l_esd_out date;
187: l_eed_out date;
188: l_opm_gl_acct_id pay_payment_gl_accounts_f.pay_gl_account_id%type;
189: l_def_gl_acct_id pay_payment_gl_accounts_f.pay_gl_account_id%type;
190: l_pay_gl_account_id pay_payment_gl_accounts_f.pay_gl_account_id%type;
191: l_def_gl_set_of_books_id pay_payment_gl_accounts_f.set_of_books_id%type;
192: l_def_gl_cash_ac_id pay_payment_gl_accounts_f.gl_cash_ac_id%type;

Line 189: l_def_gl_acct_id pay_payment_gl_accounts_f.pay_gl_account_id%type;

185: l_ovn_seq number;
186: l_esd_out date;
187: l_eed_out date;
188: l_opm_gl_acct_id pay_payment_gl_accounts_f.pay_gl_account_id%type;
189: l_def_gl_acct_id pay_payment_gl_accounts_f.pay_gl_account_id%type;
190: l_pay_gl_account_id pay_payment_gl_accounts_f.pay_gl_account_id%type;
191: l_def_gl_set_of_books_id pay_payment_gl_accounts_f.set_of_books_id%type;
192: l_def_gl_cash_ac_id pay_payment_gl_accounts_f.gl_cash_ac_id%type;
193: l_def_gl_cash_clearing_ac_id pay_payment_gl_accounts_f.gl_cash_clearing_ac_id%type;

Line 190: l_pay_gl_account_id pay_payment_gl_accounts_f.pay_gl_account_id%type;

186: l_esd_out date;
187: l_eed_out date;
188: l_opm_gl_acct_id pay_payment_gl_accounts_f.pay_gl_account_id%type;
189: l_def_gl_acct_id pay_payment_gl_accounts_f.pay_gl_account_id%type;
190: l_pay_gl_account_id pay_payment_gl_accounts_f.pay_gl_account_id%type;
191: l_def_gl_set_of_books_id pay_payment_gl_accounts_f.set_of_books_id%type;
192: l_def_gl_cash_ac_id pay_payment_gl_accounts_f.gl_cash_ac_id%type;
193: l_def_gl_cash_clearing_ac_id pay_payment_gl_accounts_f.gl_cash_clearing_ac_id%type;
194: l_def_gl_control_ac_id pay_payment_gl_accounts_f.gl_control_ac_id%type;

Line 191: l_def_gl_set_of_books_id pay_payment_gl_accounts_f.set_of_books_id%type;

187: l_eed_out date;
188: l_opm_gl_acct_id pay_payment_gl_accounts_f.pay_gl_account_id%type;
189: l_def_gl_acct_id pay_payment_gl_accounts_f.pay_gl_account_id%type;
190: l_pay_gl_account_id pay_payment_gl_accounts_f.pay_gl_account_id%type;
191: l_def_gl_set_of_books_id pay_payment_gl_accounts_f.set_of_books_id%type;
192: l_def_gl_cash_ac_id pay_payment_gl_accounts_f.gl_cash_ac_id%type;
193: l_def_gl_cash_clearing_ac_id pay_payment_gl_accounts_f.gl_cash_clearing_ac_id%type;
194: l_def_gl_control_ac_id pay_payment_gl_accounts_f.gl_control_ac_id%type;
195: l_def_gl_error_ac_id pay_payment_gl_accounts_f.gl_error_ac_id%type;

Line 192: l_def_gl_cash_ac_id pay_payment_gl_accounts_f.gl_cash_ac_id%type;

188: l_opm_gl_acct_id pay_payment_gl_accounts_f.pay_gl_account_id%type;
189: l_def_gl_acct_id pay_payment_gl_accounts_f.pay_gl_account_id%type;
190: l_pay_gl_account_id pay_payment_gl_accounts_f.pay_gl_account_id%type;
191: l_def_gl_set_of_books_id pay_payment_gl_accounts_f.set_of_books_id%type;
192: l_def_gl_cash_ac_id pay_payment_gl_accounts_f.gl_cash_ac_id%type;
193: l_def_gl_cash_clearing_ac_id pay_payment_gl_accounts_f.gl_cash_clearing_ac_id%type;
194: l_def_gl_control_ac_id pay_payment_gl_accounts_f.gl_control_ac_id%type;
195: l_def_gl_error_ac_id pay_payment_gl_accounts_f.gl_error_ac_id%type;
196: l_seq_id pay_payment_gl_accounts_f.pay_gl_account_id%type;

Line 193: l_def_gl_cash_clearing_ac_id pay_payment_gl_accounts_f.gl_cash_clearing_ac_id%type;

189: l_def_gl_acct_id pay_payment_gl_accounts_f.pay_gl_account_id%type;
190: l_pay_gl_account_id pay_payment_gl_accounts_f.pay_gl_account_id%type;
191: l_def_gl_set_of_books_id pay_payment_gl_accounts_f.set_of_books_id%type;
192: l_def_gl_cash_ac_id pay_payment_gl_accounts_f.gl_cash_ac_id%type;
193: l_def_gl_cash_clearing_ac_id pay_payment_gl_accounts_f.gl_cash_clearing_ac_id%type;
194: l_def_gl_control_ac_id pay_payment_gl_accounts_f.gl_control_ac_id%type;
195: l_def_gl_error_ac_id pay_payment_gl_accounts_f.gl_error_ac_id%type;
196: l_seq_id pay_payment_gl_accounts_f.pay_gl_account_id%type;
197: l_proc varchar2(100) := 'PAY_PAYMENT_GL_ACCOUNTS_PKG.UPDATE_ROW';

Line 194: l_def_gl_control_ac_id pay_payment_gl_accounts_f.gl_control_ac_id%type;

190: l_pay_gl_account_id pay_payment_gl_accounts_f.pay_gl_account_id%type;
191: l_def_gl_set_of_books_id pay_payment_gl_accounts_f.set_of_books_id%type;
192: l_def_gl_cash_ac_id pay_payment_gl_accounts_f.gl_cash_ac_id%type;
193: l_def_gl_cash_clearing_ac_id pay_payment_gl_accounts_f.gl_cash_clearing_ac_id%type;
194: l_def_gl_control_ac_id pay_payment_gl_accounts_f.gl_control_ac_id%type;
195: l_def_gl_error_ac_id pay_payment_gl_accounts_f.gl_error_ac_id%type;
196: l_seq_id pay_payment_gl_accounts_f.pay_gl_account_id%type;
197: l_proc varchar2(100) := 'PAY_PAYMENT_GL_ACCOUNTS_PKG.UPDATE_ROW';
198: --

Line 195: l_def_gl_error_ac_id pay_payment_gl_accounts_f.gl_error_ac_id%type;

191: l_def_gl_set_of_books_id pay_payment_gl_accounts_f.set_of_books_id%type;
192: l_def_gl_cash_ac_id pay_payment_gl_accounts_f.gl_cash_ac_id%type;
193: l_def_gl_cash_clearing_ac_id pay_payment_gl_accounts_f.gl_cash_clearing_ac_id%type;
194: l_def_gl_control_ac_id pay_payment_gl_accounts_f.gl_control_ac_id%type;
195: l_def_gl_error_ac_id pay_payment_gl_accounts_f.gl_error_ac_id%type;
196: l_seq_id pay_payment_gl_accounts_f.pay_gl_account_id%type;
197: l_proc varchar2(100) := 'PAY_PAYMENT_GL_ACCOUNTS_PKG.UPDATE_ROW';
198: --
199: cursor csr_ovn (p_gl_acct_id number, p_effective_date date) is

Line 196: l_seq_id pay_payment_gl_accounts_f.pay_gl_account_id%type;

192: l_def_gl_cash_ac_id pay_payment_gl_accounts_f.gl_cash_ac_id%type;
193: l_def_gl_cash_clearing_ac_id pay_payment_gl_accounts_f.gl_cash_clearing_ac_id%type;
194: l_def_gl_control_ac_id pay_payment_gl_accounts_f.gl_control_ac_id%type;
195: l_def_gl_error_ac_id pay_payment_gl_accounts_f.gl_error_ac_id%type;
196: l_seq_id pay_payment_gl_accounts_f.pay_gl_account_id%type;
197: l_proc varchar2(100) := 'PAY_PAYMENT_GL_ACCOUNTS_PKG.UPDATE_ROW';
198: --
199: cursor csr_ovn (p_gl_acct_id number, p_effective_date date) is
200: select object_version_number

Line 201: from pay_payment_gl_accounts_f

197: l_proc varchar2(100) := 'PAY_PAYMENT_GL_ACCOUNTS_PKG.UPDATE_ROW';
198: --
199: cursor csr_ovn (p_gl_acct_id number, p_effective_date date) is
200: select object_version_number
201: from pay_payment_gl_accounts_f
202: where pay_gl_account_id = p_gl_acct_id
203: and p_effective_date between
204: effective_start_date and effective_end_date;
205: --

Line 208: from pay_payment_gl_accounts_f

204: effective_start_date and effective_end_date;
205: --
206: cursor csr_def_gl_accounts (p_ext_gl_id number, p_effective_date date) is
207: select gl_cash_ac_id, gl_cash_clearing_ac_id, gl_control_ac_id, gl_error_ac_id, set_of_books_id
208: from pay_payment_gl_accounts_f
209: where external_account_id = p_ext_gl_id
210: and p_effective_date between effective_start_date and effective_end_date;
211: --
212: cursor csr_next_seq is

Line 294: update pay_payment_gl_accounts_f

290: (p_gl_account_id => p_gl_error_ac_id
291: );
292: --
293:
294: update pay_payment_gl_accounts_f
295: set
296: set_of_books_id = p_set_of_books_id,
297: gl_cash_ac_id = p_gl_cash_ac_id,
298: gl_cash_clearing_ac_id = p_gl_cash_clearing_ac_id,

Line 437: insert into PAY_PAYMENT_GL_ACCOUNTS_F

433: end if;
434:
435: hr_utility.set_location(l_proc, 142);
436:
437: insert into PAY_PAYMENT_GL_ACCOUNTS_F
438: (
439: PAY_GL_ACCOUNT_ID,
440: EFFECTIVE_START_DATE,
441: EFFECTIVE_END_DATE,

Line 525: from pay_payment_gl_accounts_f

521: is
522: --
523: cursor csr_opm_gl_rows is
524: select pay_gl_account_id, object_version_number
525: from pay_payment_gl_accounts_f
526: where org_payment_method_id = p_org_payment_method_id
527: and p_effective_date between effective_start_date and effective_end_date ;
528: --
529: l_pay_gl_account_id pay_payment_gl_accounts_f.pay_gl_account_id%type;

Line 529: l_pay_gl_account_id pay_payment_gl_accounts_f.pay_gl_account_id%type;

525: from pay_payment_gl_accounts_f
526: where org_payment_method_id = p_org_payment_method_id
527: and p_effective_date between effective_start_date and effective_end_date ;
528: --
529: l_pay_gl_account_id pay_payment_gl_accounts_f.pay_gl_account_id%type;
530: l_ovn pay_payment_gl_accounts_f.object_version_number%type;
531: l_esd_out date;
532: l_eed_out date;
533: l_proc varchar2(100) := 'PAY_PAYMENT_GL_ACCOUNTS_PKG.DELETE_ROW';

Line 530: l_ovn pay_payment_gl_accounts_f.object_version_number%type;

526: where org_payment_method_id = p_org_payment_method_id
527: and p_effective_date between effective_start_date and effective_end_date ;
528: --
529: l_pay_gl_account_id pay_payment_gl_accounts_f.pay_gl_account_id%type;
530: l_ovn pay_payment_gl_accounts_f.object_version_number%type;
531: l_esd_out date;
532: l_eed_out date;
533: l_proc varchar2(100) := 'PAY_PAYMENT_GL_ACCOUNTS_PKG.DELETE_ROW';
534: --

Line 572: from pay_payment_gl_accounts_f pga

568: RETURN NUMBER is
569: --
570: cursor csr_default_gl_accounts is
571: select pga.pay_gl_account_id
572: from pay_payment_gl_accounts_f pga
573: where pga.external_account_id = p_external_account_id;
574: --
575: l_def_gl_acct_id pay_payment_gl_accounts_f.pay_gl_account_id%type;
576: l_proc varchar2(100) := 'PAY_PAYMENT_GL_ACCOUNTS_PKG.DEFAULT_GL_ACCOUNTS';

Line 575: l_def_gl_acct_id pay_payment_gl_accounts_f.pay_gl_account_id%type;

571: select pga.pay_gl_account_id
572: from pay_payment_gl_accounts_f pga
573: where pga.external_account_id = p_external_account_id;
574: --
575: l_def_gl_acct_id pay_payment_gl_accounts_f.pay_gl_account_id%type;
576: l_proc varchar2(100) := 'PAY_PAYMENT_GL_ACCOUNTS_PKG.DEFAULT_GL_ACCOUNTS';
577: --
578: BEGIN
579: --

Line 619: from pay_payment_gl_accounts_f pga

615: RETURN NUMBER is
616: --
617: cursor csr_opm_gl_accounts is
618: select distinct pga.pay_gl_account_id
619: from pay_payment_gl_accounts_f pga
620: where pga.org_payment_method_id = p_org_payment_method_id;
621: --
622: l_opm_gl_acct_id pay_payment_gl_accounts_f.pay_gl_account_id%type;
623: l_proc varchar2(100) := 'PAY_PAYMENT_GL_ACCOUNTS_PKG.OPM_GL_ACCOUNTS';

Line 622: l_opm_gl_acct_id pay_payment_gl_accounts_f.pay_gl_account_id%type;

618: select distinct pga.pay_gl_account_id
619: from pay_payment_gl_accounts_f pga
620: where pga.org_payment_method_id = p_org_payment_method_id;
621: --
622: l_opm_gl_acct_id pay_payment_gl_accounts_f.pay_gl_account_id%type;
623: l_proc varchar2(100) := 'PAY_PAYMENT_GL_ACCOUNTS_PKG.OPM_GL_ACCOUNTS';
624: --
625: BEGIN
626: --

Line 673: from pay_payment_gl_accounts_f

669: ) is
670: --
671: cursor csr_gl_accounts is
672: select gl_cash_ac_id, gl_cash_clearing_ac_id, gl_control_ac_id, gl_error_ac_id, set_of_books_id
673: from pay_payment_gl_accounts_f
674: where pay_gl_account_id = p_pay_gl_account_id
675: and p_effective_date between effective_start_date and effective_end_date;
676: --
677: cursor csr_set_of_books_name is