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.CN_PAYRUN_PVT dependencies on CN_REPOSITORIES

Line 389: CURSOR cn_repositories_cur IS

385: l_element_name pay_element_types_f.element_name%type;
386:
387: l_mask varchar2(100) ;
388:
389: CURSOR cn_repositories_cur IS
390: SELECT glsob.set_of_books_id set_of_books_id,
391: glsob.currency_code currency_code
392: FROM gl_sets_of_books glsob,
393: cn_repositories cnr,

Line 393: cn_repositories cnr,

389: CURSOR cn_repositories_cur IS
390: SELECT glsob.set_of_books_id set_of_books_id,
391: glsob.currency_code currency_code
392: FROM gl_sets_of_books glsob,
393: cn_repositories cnr,
394: cn_payruns cnp
395: WHERE cnr.set_of_books_id = glsob.set_of_books_id
396: AND cnr.org_id = cnp.org_id
397: AND cnp.payrun_id = p_payrun_id;

Line 399: l_repositories_rec cn_repositories_cur%ROWTYPE;

395: WHERE cnr.set_of_books_id = glsob.set_of_books_id
396: AND cnr.org_id = cnp.org_id
397: AND cnp.payrun_id = p_payrun_id;
398:
399: l_repositories_rec cn_repositories_cur%ROWTYPE;
400:
401: --Bug 3995491(11.5.8 bug 3925653, 11.5.10 bug 3995477) by jjhuang on 11/5/04.
402: l_action_if_exists hr_lookups.lookup_code%TYPE;
403:

Line 421: -- get cn_repositories

417: --Bug 3995491(11.5.8 bug 3925653, 11.5.10 bug 3995477) by jjhuang on 11/5/04.
418: l_action_if_exists := fnd_profile.value('CN_PAYROLL_ACTION_IF_ENTRY_EXISTS');
419:
420: --
421: -- get cn_repositories
422: --
423:
424: OPEN cn_repositories_cur;
425: FETCH cn_repositories_cur INTO l_repositories_rec;

Line 424: OPEN cn_repositories_cur;

420: --
421: -- get cn_repositories
422: --
423:
424: OPEN cn_repositories_cur;
425: FETCH cn_repositories_cur INTO l_repositories_rec;
426: CLOSE cn_repositories_cur;
427:
428: --

Line 425: FETCH cn_repositories_cur INTO l_repositories_rec;

421: -- get cn_repositories
422: --
423:
424: OPEN cn_repositories_cur;
425: FETCH cn_repositories_cur INTO l_repositories_rec;
426: CLOSE cn_repositories_cur;
427:
428: --
429: -- Get currency Mask

Line 426: CLOSE cn_repositories_cur;

422: --
423:
424: OPEN cn_repositories_cur;
425: FETCH cn_repositories_cur INTO l_repositories_rec;
426: CLOSE cn_repositories_cur;
427:
428: --
429: -- Get currency Mask
430: --

Line 1526: cn_repositories cnr,

1522:
1523: CURSOR get_functional_currency IS
1524: SELECT currency_code
1525: FROM gl_sets_of_books glsob,
1526: cn_repositories cnr,
1527: cn_payruns cnp
1528: WHERE cnr.set_of_books_id = glsob.set_of_books_id
1529: AND cnr.org_id = cnp.org_id
1530: AND cnp.payrun_id= p_payrun_id;

Line 1718: l_payables_flag cn_repositories.payables_flag%TYPE;

1714: AND payment_transaction_id = NVL(p_pmt_tran_id, payment_transaction_id) -- Bug 3866089 (the same as 11.5.8 bug 3841926, 11.5.10 3866116) by jjhuang on 11/1/04
1715: AND hold_flag = 'N' ;
1716:
1717: l_user fnd_user.user_name%TYPE;
1718: l_payables_flag cn_repositories.payables_flag%TYPE;
1719:
1720: BEGIN
1721:
1722: --

Line 1729: FROM cn_repositories cr,cn_payruns cp

1725: x_loading_status := p_loading_status ;
1726: --chaged
1727: SELECT Nvl(payables_flag, 'N')
1728: INTO l_payables_flag
1729: FROM cn_repositories cr,cn_payruns cp
1730: where cp.payrun_id = p_payrun_id
1731: and cp.org_id=cr.org_id;
1732:
1733: IF l_payables_flag = 'Y' THEN

Line 2571: p_source_object_code => 'CN_REPOSITORIES',

2567: x_return_status => x_return_status,
2568: x_msg_count => x_msg_count,
2569: x_msg_data => x_msg_data,
2570: p_source_object_id => l_org_id,
2571: p_source_object_code => 'CN_REPOSITORIES',
2572: p_notes => l_note_msg,
2573: p_notes_detail => l_note_msg,
2574: p_note_type => 'CN_SYSGEN', -- for system generated
2575: x_jtf_note_id => l_note_id -- returned

Line 2826: l_payables_flag cn_repositories.payables_flag%TYPE;

2822: l_credit_type_id NUMBER := -1000;
2823:
2824: -- for payroll integration
2825: l_element_type_id NUMBER;
2826: l_payables_flag cn_repositories.payables_flag%TYPE;
2827: l_payroll_flag cn_repositories.payroll_flag%TYPE;
2828: l_payables_ccid_level cn_repositories.payables_ccid_level%TYPE;
2829:
2830: l_pmt_trx_rec cn_pmt_trans_pkg.pmt_trans_rec_type;

Line 2827: l_payroll_flag cn_repositories.payroll_flag%TYPE;

2823:
2824: -- for payroll integration
2825: l_element_type_id NUMBER;
2826: l_payables_flag cn_repositories.payables_flag%TYPE;
2827: l_payroll_flag cn_repositories.payroll_flag%TYPE;
2828: l_payables_ccid_level cn_repositories.payables_ccid_level%TYPE;
2829:
2830: l_pmt_trx_rec cn_pmt_trans_pkg.pmt_trans_rec_type;
2831: l_batch_rec cn_prepostbatches.posting_batch_rec_type;

Line 2828: l_payables_ccid_level cn_repositories.payables_ccid_level%TYPE;

2824: -- for payroll integration
2825: l_element_type_id NUMBER;
2826: l_payables_flag cn_repositories.payables_flag%TYPE;
2827: l_payroll_flag cn_repositories.payroll_flag%TYPE;
2828: l_payables_ccid_level cn_repositories.payables_ccid_level%TYPE;
2829:
2830: l_pmt_trx_rec cn_pmt_trans_pkg.pmt_trans_rec_type;
2831: l_batch_rec cn_prepostbatches.posting_batch_rec_type;
2832:

Line 2888: FROM cn_repositories

2884:
2885: -- for payroll integration
2886: CURSOR get_apps(p_org_id cn_payruns.org_id%TYPE) IS
2887: SELECT payables_flag, payroll_flag, payables_ccid_level
2888: FROM cn_repositories
2889: --R12
2890: WHERE org_id = p_org_id;
2891:
2892: