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.PA_MC_INVOICE_DETAIL_PKG dependencies on PA_PLSQL_DATATYPES

Line 4: L_PROJECT_ID PA_PLSQL_DATATYPES.IdTabTyp;

1: PACKAGE BODY PA_MC_INVOICE_DETAIL_PKG as
2: /* $Header: PAMCIDTB.pls 120.3 2005/08/26 11:26:18 skannoji noship $*/
3:
4: L_PROJECT_ID PA_PLSQL_DATATYPES.IdTabTyp;
5: L_INVOICED_FLAG PA_PLSQL_DATATYPES.Char1TabTyp;
6: L_ACCT_CURRENCY_CODE PA_PLSQL_DATATYPES.Char30TabTyp;
7: L_BILL_AMOUNT PA_PLSQL_DATATYPES.NumTabTyp;
8: L_ACCT_RATE_TYPE PA_PLSQL_DATATYPES.Char30TabTyp;

Line 5: L_INVOICED_FLAG PA_PLSQL_DATATYPES.Char1TabTyp;

1: PACKAGE BODY PA_MC_INVOICE_DETAIL_PKG as
2: /* $Header: PAMCIDTB.pls 120.3 2005/08/26 11:26:18 skannoji noship $*/
3:
4: L_PROJECT_ID PA_PLSQL_DATATYPES.IdTabTyp;
5: L_INVOICED_FLAG PA_PLSQL_DATATYPES.Char1TabTyp;
6: L_ACCT_CURRENCY_CODE PA_PLSQL_DATATYPES.Char30TabTyp;
7: L_BILL_AMOUNT PA_PLSQL_DATATYPES.NumTabTyp;
8: L_ACCT_RATE_TYPE PA_PLSQL_DATATYPES.Char30TabTyp;
9: L_ACCT_RATE_DATE PA_PLSQL_DATATYPES.Char30TabTyp;

Line 6: L_ACCT_CURRENCY_CODE PA_PLSQL_DATATYPES.Char30TabTyp;

2: /* $Header: PAMCIDTB.pls 120.3 2005/08/26 11:26:18 skannoji noship $*/
3:
4: L_PROJECT_ID PA_PLSQL_DATATYPES.IdTabTyp;
5: L_INVOICED_FLAG PA_PLSQL_DATATYPES.Char1TabTyp;
6: L_ACCT_CURRENCY_CODE PA_PLSQL_DATATYPES.Char30TabTyp;
7: L_BILL_AMOUNT PA_PLSQL_DATATYPES.NumTabTyp;
8: L_ACCT_RATE_TYPE PA_PLSQL_DATATYPES.Char30TabTyp;
9: L_ACCT_RATE_DATE PA_PLSQL_DATATYPES.Char30TabTyp;
10: L_ACCT_EXCHANGE_RATE PA_PLSQL_DATATYPES.NumTabTyp;

Line 7: L_BILL_AMOUNT PA_PLSQL_DATATYPES.NumTabTyp;

3:
4: L_PROJECT_ID PA_PLSQL_DATATYPES.IdTabTyp;
5: L_INVOICED_FLAG PA_PLSQL_DATATYPES.Char1TabTyp;
6: L_ACCT_CURRENCY_CODE PA_PLSQL_DATATYPES.Char30TabTyp;
7: L_BILL_AMOUNT PA_PLSQL_DATATYPES.NumTabTyp;
8: L_ACCT_RATE_TYPE PA_PLSQL_DATATYPES.Char30TabTyp;
9: L_ACCT_RATE_DATE PA_PLSQL_DATATYPES.Char30TabTyp;
10: L_ACCT_EXCHANGE_RATE PA_PLSQL_DATATYPES.NumTabTyp;
11: L_DRAFT_INV_DET_ID PA_PLSQL_DATATYPES.IdTabTyp;

Line 8: L_ACCT_RATE_TYPE PA_PLSQL_DATATYPES.Char30TabTyp;

4: L_PROJECT_ID PA_PLSQL_DATATYPES.IdTabTyp;
5: L_INVOICED_FLAG PA_PLSQL_DATATYPES.Char1TabTyp;
6: L_ACCT_CURRENCY_CODE PA_PLSQL_DATATYPES.Char30TabTyp;
7: L_BILL_AMOUNT PA_PLSQL_DATATYPES.NumTabTyp;
8: L_ACCT_RATE_TYPE PA_PLSQL_DATATYPES.Char30TabTyp;
9: L_ACCT_RATE_DATE PA_PLSQL_DATATYPES.Char30TabTyp;
10: L_ACCT_EXCHANGE_RATE PA_PLSQL_DATATYPES.NumTabTyp;
11: L_DRAFT_INV_DET_ID PA_PLSQL_DATATYPES.IdTabTyp;
12: L_PROG_APP_ID PA_PLSQL_DATATYPES.IdTabTyp;

Line 9: L_ACCT_RATE_DATE PA_PLSQL_DATATYPES.Char30TabTyp;

5: L_INVOICED_FLAG PA_PLSQL_DATATYPES.Char1TabTyp;
6: L_ACCT_CURRENCY_CODE PA_PLSQL_DATATYPES.Char30TabTyp;
7: L_BILL_AMOUNT PA_PLSQL_DATATYPES.NumTabTyp;
8: L_ACCT_RATE_TYPE PA_PLSQL_DATATYPES.Char30TabTyp;
9: L_ACCT_RATE_DATE PA_PLSQL_DATATYPES.Char30TabTyp;
10: L_ACCT_EXCHANGE_RATE PA_PLSQL_DATATYPES.NumTabTyp;
11: L_DRAFT_INV_DET_ID PA_PLSQL_DATATYPES.IdTabTyp;
12: L_PROG_APP_ID PA_PLSQL_DATATYPES.IdTabTyp;
13: L_PROG_ID PA_PLSQL_DATATYPES.IdTabTyp;

Line 10: L_ACCT_EXCHANGE_RATE PA_PLSQL_DATATYPES.NumTabTyp;

6: L_ACCT_CURRENCY_CODE PA_PLSQL_DATATYPES.Char30TabTyp;
7: L_BILL_AMOUNT PA_PLSQL_DATATYPES.NumTabTyp;
8: L_ACCT_RATE_TYPE PA_PLSQL_DATATYPES.Char30TabTyp;
9: L_ACCT_RATE_DATE PA_PLSQL_DATATYPES.Char30TabTyp;
10: L_ACCT_EXCHANGE_RATE PA_PLSQL_DATATYPES.NumTabTyp;
11: L_DRAFT_INV_DET_ID PA_PLSQL_DATATYPES.IdTabTyp;
12: L_PROG_APP_ID PA_PLSQL_DATATYPES.IdTabTyp;
13: L_PROG_ID PA_PLSQL_DATATYPES.IdTabTyp;
14: L_PROG_UPDATE_DATE PA_PLSQL_DATATYPES.Char30TabTyp;

Line 11: L_DRAFT_INV_DET_ID PA_PLSQL_DATATYPES.IdTabTyp;

7: L_BILL_AMOUNT PA_PLSQL_DATATYPES.NumTabTyp;
8: L_ACCT_RATE_TYPE PA_PLSQL_DATATYPES.Char30TabTyp;
9: L_ACCT_RATE_DATE PA_PLSQL_DATATYPES.Char30TabTyp;
10: L_ACCT_EXCHANGE_RATE PA_PLSQL_DATATYPES.NumTabTyp;
11: L_DRAFT_INV_DET_ID PA_PLSQL_DATATYPES.IdTabTyp;
12: L_PROG_APP_ID PA_PLSQL_DATATYPES.IdTabTyp;
13: L_PROG_ID PA_PLSQL_DATATYPES.IdTabTyp;
14: L_PROG_UPDATE_DATE PA_PLSQL_DATATYPES.Char30TabTyp;
15: L_SETS_OF_BOOKS_ID PA_PLSQL_DATATYPES.IdTabTyp;

Line 12: L_PROG_APP_ID PA_PLSQL_DATATYPES.IdTabTyp;

8: L_ACCT_RATE_TYPE PA_PLSQL_DATATYPES.Char30TabTyp;
9: L_ACCT_RATE_DATE PA_PLSQL_DATATYPES.Char30TabTyp;
10: L_ACCT_EXCHANGE_RATE PA_PLSQL_DATATYPES.NumTabTyp;
11: L_DRAFT_INV_DET_ID PA_PLSQL_DATATYPES.IdTabTyp;
12: L_PROG_APP_ID PA_PLSQL_DATATYPES.IdTabTyp;
13: L_PROG_ID PA_PLSQL_DATATYPES.IdTabTyp;
14: L_PROG_UPDATE_DATE PA_PLSQL_DATATYPES.Char30TabTyp;
15: L_SETS_OF_BOOKS_ID PA_PLSQL_DATATYPES.IdTabTyp;
16:

Line 13: L_PROG_ID PA_PLSQL_DATATYPES.IdTabTyp;

9: L_ACCT_RATE_DATE PA_PLSQL_DATATYPES.Char30TabTyp;
10: L_ACCT_EXCHANGE_RATE PA_PLSQL_DATATYPES.NumTabTyp;
11: L_DRAFT_INV_DET_ID PA_PLSQL_DATATYPES.IdTabTyp;
12: L_PROG_APP_ID PA_PLSQL_DATATYPES.IdTabTyp;
13: L_PROG_ID PA_PLSQL_DATATYPES.IdTabTyp;
14: L_PROG_UPDATE_DATE PA_PLSQL_DATATYPES.Char30TabTyp;
15: L_SETS_OF_BOOKS_ID PA_PLSQL_DATATYPES.IdTabTyp;
16:
17:

Line 14: L_PROG_UPDATE_DATE PA_PLSQL_DATATYPES.Char30TabTyp;

10: L_ACCT_EXCHANGE_RATE PA_PLSQL_DATATYPES.NumTabTyp;
11: L_DRAFT_INV_DET_ID PA_PLSQL_DATATYPES.IdTabTyp;
12: L_PROG_APP_ID PA_PLSQL_DATATYPES.IdTabTyp;
13: L_PROG_ID PA_PLSQL_DATATYPES.IdTabTyp;
14: L_PROG_UPDATE_DATE PA_PLSQL_DATATYPES.Char30TabTyp;
15: L_SETS_OF_BOOKS_ID PA_PLSQL_DATATYPES.IdTabTyp;
16:
17:
18: g1_debug_mode varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

Line 15: L_SETS_OF_BOOKS_ID PA_PLSQL_DATATYPES.IdTabTyp;

11: L_DRAFT_INV_DET_ID PA_PLSQL_DATATYPES.IdTabTyp;
12: L_PROG_APP_ID PA_PLSQL_DATATYPES.IdTabTyp;
13: L_PROG_ID PA_PLSQL_DATATYPES.IdTabTyp;
14: L_PROG_UPDATE_DATE PA_PLSQL_DATATYPES.Char30TabTyp;
15: L_SETS_OF_BOOKS_ID PA_PLSQL_DATATYPES.IdTabTyp;
16:
17:
18: g1_debug_mode varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
19:

Line 37: P_Draft_inv_det_id OUT NOCOPY PA_PLSQL_DATATYPES.numtabtyp)

33: END get_orig_exchg_rate;
34:
35: PROCEDURE download ( P_inv_rec_tab IN PA_INVOICE_DETAIL_PKG.inv_rec_tab,
36: P_record_cnt IN number,
37: P_Draft_inv_det_id OUT NOCOPY PA_PLSQL_DATATYPES.numtabtyp)
38: IS
39: BEGIN
40: FOR I in 1..P_record_cnt
41: LOOP

Line 47: P_trx_date IN PA_PLSQL_DATATYPES.DateTabTyp,

43: END LOOP;
44: END download;
45:
46: PROCEDURE compute_mrc (P_inv_rec_tab IN PA_INVOICE_DETAIL_PKG.inv_rec_tab,
47: P_trx_date IN PA_PLSQL_DATATYPES.DateTabTyp,
48: P_rec_counter IN NUMBER,
49: P_mrc_reqd_flag IN PA_PLSQL_DATATYPES.Char1TabTyp,
50: P_tot_record OUT NOCOPY NUMBER ) --File.Sql.39 bug 4440895
51: IS

Line 49: P_mrc_reqd_flag IN PA_PLSQL_DATATYPES.Char1TabTyp,

45:
46: PROCEDURE compute_mrc (P_inv_rec_tab IN PA_INVOICE_DETAIL_PKG.inv_rec_tab,
47: P_trx_date IN PA_PLSQL_DATATYPES.DateTabTyp,
48: P_rec_counter IN NUMBER,
49: P_mrc_reqd_flag IN PA_PLSQL_DATATYPES.Char1TabTyp,
50: P_tot_record OUT NOCOPY NUMBER ) --File.Sql.39 bug 4440895
51: IS
52: orig_ref VARCHAR2(30);
53: adj_item NUMBER;

Line 261: l_mrc_reqd_flag PA_PLSQL_DATATYPES.Char1TabTyp;

257: PROCEDURE Insert_rows
258: ( P_inv_rec_tab IN PA_INVOICE_DETAIL_PKG.inv_rec_tab)
259: IS
260: l_tot_count NUMBER;
261: l_mrc_reqd_flag PA_PLSQL_DATATYPES.Char1TabTyp;
262: c number;
263: l_trx_date PA_PLSQL_DATATYPES.DateTabTyp;
264: BEGIN
265: c := 0;

Line 263: l_trx_date PA_PLSQL_DATATYPES.DateTabTyp;

259: IS
260: l_tot_count NUMBER;
261: l_mrc_reqd_flag PA_PLSQL_DATATYPES.Char1TabTyp;
262: c number;
263: l_trx_date PA_PLSQL_DATATYPES.DateTabTyp;
264: BEGIN
265: c := 0;
266: IF g1_debug_mode = 'Y' THEN
267: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'In MRC Insert...');

Line 361: P_trx_date IN PA_PLSQL_DATATYPES.DateTabTyp)

357: /* This procedure is called from MRC upgrade. In this case, transaction
358: date is suuplied as parameter */
359: PROCEDURE Insert_rows
360: ( P_inv_rec_tab IN PA_INVOICE_DETAIL_PKG.inv_rec_tab,
361: P_trx_date IN PA_PLSQL_DATATYPES.DateTabTyp)
362: IS
363: l_tot_count NUMBER;
364: l_mrc_reqd_flag PA_PLSQL_DATATYPES.Char1TabTyp;
365: c number;

Line 364: l_mrc_reqd_flag PA_PLSQL_DATATYPES.Char1TabTyp;

360: ( P_inv_rec_tab IN PA_INVOICE_DETAIL_PKG.inv_rec_tab,
361: P_trx_date IN PA_PLSQL_DATATYPES.DateTabTyp)
362: IS
363: l_tot_count NUMBER;
364: l_mrc_reqd_flag PA_PLSQL_DATATYPES.Char1TabTyp;
365: c number;
366: BEGIN
367: c := 0;
368: IF g1_debug_mode = 'Y' THEN

Line 448: P_mrc_reqd_flag IN PA_PLSQL_DATATYPES.Char1TabTyp)

444: END Insert_rows;
445:
446: PROCEDURE Update_rows
447: ( P_inv_rec_tab IN PA_INVOICE_DETAIL_PKG.inv_rec_tab,
448: P_mrc_reqd_flag IN PA_PLSQL_DATATYPES.Char1TabTyp)
449: IS
450: l_tot_count NUMBER;
451: l_trx_date PA_PLSQL_DATATYPES.DateTabTyp;
452: BEGIN

Line 451: l_trx_date PA_PLSQL_DATATYPES.DateTabTyp;

447: ( P_inv_rec_tab IN PA_INVOICE_DETAIL_PKG.inv_rec_tab,
448: P_mrc_reqd_flag IN PA_PLSQL_DATATYPES.Char1TabTyp)
449: IS
450: l_tot_count NUMBER;
451: l_trx_date PA_PLSQL_DATATYPES.DateTabTyp;
452: BEGIN
453:
454: IF g1_debug_mode = 'Y' THEN
455: PA_IC_INV_UTILS.log_message('Update_rows: ' || 'In MRC Update...');

Line 475: l_draft_line_id PA_PLSQL_DATATYPES.numtabtyp;

471:
472: PROCEDURE Delete_rows
473: ( P_inv_rec_tab IN PA_INVOICE_DETAIL_PKG.inv_rec_tab)
474: IS
475: l_draft_line_id PA_PLSQL_DATATYPES.numtabtyp;
476: BEGIN
477:
478: IF g1_debug_mode = 'Y' THEN
479: PA_IC_INV_UTILS.log_message('Delete_rows: ' || 'In MRC Delete...');