DBA Data[Home] [Help]

APPS.PA_INVOICE_DETAIL_PKG dependencies on PA_PLSQL_DATATYPES

Line 4: L_EXPENDITURE_ITEM_ID PA_PLSQL_DATATYPES.IdTabTyp;

1: PACKAGE BODY PA_INVOICE_DETAIL_PKG as
2: /* $Header: PAICIDTB.pls 120.5 2007/04/11 08:17:56 nayyadev ship $ */
3:
4: L_EXPENDITURE_ITEM_ID PA_PLSQL_DATATYPES.IdTabTyp;
5: L_LINE_NUM PA_PLSQL_DATATYPES.IdTabTyp;
6: L_PROJECT_ID PA_PLSQL_DATATYPES.IdTabTyp;
7: L_INVOICED_FLAG PA_PLSQL_DATATYPES.Char1TabTyp;
8: L_DENOM_CURRENCY_CODE PA_PLSQL_DATATYPES.Char30TabTyp;

Line 5: L_LINE_NUM PA_PLSQL_DATATYPES.IdTabTyp;

1: PACKAGE BODY PA_INVOICE_DETAIL_PKG as
2: /* $Header: PAICIDTB.pls 120.5 2007/04/11 08:17:56 nayyadev ship $ */
3:
4: L_EXPENDITURE_ITEM_ID PA_PLSQL_DATATYPES.IdTabTyp;
5: L_LINE_NUM PA_PLSQL_DATATYPES.IdTabTyp;
6: L_PROJECT_ID PA_PLSQL_DATATYPES.IdTabTyp;
7: L_INVOICED_FLAG PA_PLSQL_DATATYPES.Char1TabTyp;
8: L_DENOM_CURRENCY_CODE PA_PLSQL_DATATYPES.Char30TabTyp;
9: L_DENOM_BILL_AMOUNT PA_PLSQL_DATATYPES.NumTabTyp;

Line 6: L_PROJECT_ID PA_PLSQL_DATATYPES.IdTabTyp;

2: /* $Header: PAICIDTB.pls 120.5 2007/04/11 08:17:56 nayyadev ship $ */
3:
4: L_EXPENDITURE_ITEM_ID PA_PLSQL_DATATYPES.IdTabTyp;
5: L_LINE_NUM PA_PLSQL_DATATYPES.IdTabTyp;
6: L_PROJECT_ID PA_PLSQL_DATATYPES.IdTabTyp;
7: L_INVOICED_FLAG PA_PLSQL_DATATYPES.Char1TabTyp;
8: L_DENOM_CURRENCY_CODE PA_PLSQL_DATATYPES.Char30TabTyp;
9: L_DENOM_BILL_AMOUNT PA_PLSQL_DATATYPES.NumTabTyp;
10: L_ACCT_CURRENCY_CODE PA_PLSQL_DATATYPES.Char30TabTyp;

Line 7: L_INVOICED_FLAG PA_PLSQL_DATATYPES.Char1TabTyp;

3:
4: L_EXPENDITURE_ITEM_ID PA_PLSQL_DATATYPES.IdTabTyp;
5: L_LINE_NUM PA_PLSQL_DATATYPES.IdTabTyp;
6: L_PROJECT_ID PA_PLSQL_DATATYPES.IdTabTyp;
7: L_INVOICED_FLAG PA_PLSQL_DATATYPES.Char1TabTyp;
8: L_DENOM_CURRENCY_CODE PA_PLSQL_DATATYPES.Char30TabTyp;
9: L_DENOM_BILL_AMOUNT PA_PLSQL_DATATYPES.NumTabTyp;
10: L_ACCT_CURRENCY_CODE PA_PLSQL_DATATYPES.Char30TabTyp;
11: L_BILL_AMOUNT PA_PLSQL_DATATYPES.NumTabTyp;

Line 8: L_DENOM_CURRENCY_CODE PA_PLSQL_DATATYPES.Char30TabTyp;

4: L_EXPENDITURE_ITEM_ID PA_PLSQL_DATATYPES.IdTabTyp;
5: L_LINE_NUM PA_PLSQL_DATATYPES.IdTabTyp;
6: L_PROJECT_ID PA_PLSQL_DATATYPES.IdTabTyp;
7: L_INVOICED_FLAG PA_PLSQL_DATATYPES.Char1TabTyp;
8: L_DENOM_CURRENCY_CODE PA_PLSQL_DATATYPES.Char30TabTyp;
9: L_DENOM_BILL_AMOUNT PA_PLSQL_DATATYPES.NumTabTyp;
10: L_ACCT_CURRENCY_CODE PA_PLSQL_DATATYPES.Char30TabTyp;
11: L_BILL_AMOUNT PA_PLSQL_DATATYPES.NumTabTyp;
12: L_ACCT_RATE_TYPE PA_PLSQL_DATATYPES.Char30TabTyp;

Line 9: L_DENOM_BILL_AMOUNT PA_PLSQL_DATATYPES.NumTabTyp;

5: L_LINE_NUM PA_PLSQL_DATATYPES.IdTabTyp;
6: L_PROJECT_ID PA_PLSQL_DATATYPES.IdTabTyp;
7: L_INVOICED_FLAG PA_PLSQL_DATATYPES.Char1TabTyp;
8: L_DENOM_CURRENCY_CODE PA_PLSQL_DATATYPES.Char30TabTyp;
9: L_DENOM_BILL_AMOUNT PA_PLSQL_DATATYPES.NumTabTyp;
10: L_ACCT_CURRENCY_CODE PA_PLSQL_DATATYPES.Char30TabTyp;
11: L_BILL_AMOUNT PA_PLSQL_DATATYPES.NumTabTyp;
12: L_ACCT_RATE_TYPE PA_PLSQL_DATATYPES.Char30TabTyp;
13: L_ACCT_RATE_DATE PA_PLSQL_DATATYPES.Char30TabTyp;

Line 10: L_ACCT_CURRENCY_CODE PA_PLSQL_DATATYPES.Char30TabTyp;

6: L_PROJECT_ID PA_PLSQL_DATATYPES.IdTabTyp;
7: L_INVOICED_FLAG PA_PLSQL_DATATYPES.Char1TabTyp;
8: L_DENOM_CURRENCY_CODE PA_PLSQL_DATATYPES.Char30TabTyp;
9: L_DENOM_BILL_AMOUNT PA_PLSQL_DATATYPES.NumTabTyp;
10: L_ACCT_CURRENCY_CODE PA_PLSQL_DATATYPES.Char30TabTyp;
11: L_BILL_AMOUNT PA_PLSQL_DATATYPES.NumTabTyp;
12: L_ACCT_RATE_TYPE PA_PLSQL_DATATYPES.Char30TabTyp;
13: L_ACCT_RATE_DATE PA_PLSQL_DATATYPES.Char30TabTyp;
14: L_ACCT_EXCHANGE_RATE PA_PLSQL_DATATYPES.NumTabTyp;

Line 11: L_BILL_AMOUNT PA_PLSQL_DATATYPES.NumTabTyp;

7: L_INVOICED_FLAG PA_PLSQL_DATATYPES.Char1TabTyp;
8: L_DENOM_CURRENCY_CODE PA_PLSQL_DATATYPES.Char30TabTyp;
9: L_DENOM_BILL_AMOUNT PA_PLSQL_DATATYPES.NumTabTyp;
10: L_ACCT_CURRENCY_CODE PA_PLSQL_DATATYPES.Char30TabTyp;
11: L_BILL_AMOUNT PA_PLSQL_DATATYPES.NumTabTyp;
12: L_ACCT_RATE_TYPE PA_PLSQL_DATATYPES.Char30TabTyp;
13: L_ACCT_RATE_DATE PA_PLSQL_DATATYPES.Char30TabTyp;
14: L_ACCT_EXCHANGE_RATE PA_PLSQL_DATATYPES.NumTabTyp;
15: L_CC_PROJECT_ID PA_PLSQL_DATATYPES.IdTabTyp;

Line 12: L_ACCT_RATE_TYPE PA_PLSQL_DATATYPES.Char30TabTyp;

8: L_DENOM_CURRENCY_CODE PA_PLSQL_DATATYPES.Char30TabTyp;
9: L_DENOM_BILL_AMOUNT PA_PLSQL_DATATYPES.NumTabTyp;
10: L_ACCT_CURRENCY_CODE PA_PLSQL_DATATYPES.Char30TabTyp;
11: L_BILL_AMOUNT PA_PLSQL_DATATYPES.NumTabTyp;
12: L_ACCT_RATE_TYPE PA_PLSQL_DATATYPES.Char30TabTyp;
13: L_ACCT_RATE_DATE PA_PLSQL_DATATYPES.Char30TabTyp;
14: L_ACCT_EXCHANGE_RATE PA_PLSQL_DATATYPES.NumTabTyp;
15: L_CC_PROJECT_ID PA_PLSQL_DATATYPES.IdTabTyp;
16: L_CC_TAX_TASK_ID PA_PLSQL_DATATYPES.IdTabTyp;

Line 13: L_ACCT_RATE_DATE PA_PLSQL_DATATYPES.Char30TabTyp;

9: L_DENOM_BILL_AMOUNT PA_PLSQL_DATATYPES.NumTabTyp;
10: L_ACCT_CURRENCY_CODE PA_PLSQL_DATATYPES.Char30TabTyp;
11: L_BILL_AMOUNT PA_PLSQL_DATATYPES.NumTabTyp;
12: L_ACCT_RATE_TYPE PA_PLSQL_DATATYPES.Char30TabTyp;
13: L_ACCT_RATE_DATE PA_PLSQL_DATATYPES.Char30TabTyp;
14: L_ACCT_EXCHANGE_RATE PA_PLSQL_DATATYPES.NumTabTyp;
15: L_CC_PROJECT_ID PA_PLSQL_DATATYPES.IdTabTyp;
16: L_CC_TAX_TASK_ID PA_PLSQL_DATATYPES.IdTabTyp;
17: L_ORG_ID PA_PLSQL_DATATYPES.IdTabTyp;

Line 14: L_ACCT_EXCHANGE_RATE PA_PLSQL_DATATYPES.NumTabTyp;

10: L_ACCT_CURRENCY_CODE PA_PLSQL_DATATYPES.Char30TabTyp;
11: L_BILL_AMOUNT PA_PLSQL_DATATYPES.NumTabTyp;
12: L_ACCT_RATE_TYPE PA_PLSQL_DATATYPES.Char30TabTyp;
13: L_ACCT_RATE_DATE PA_PLSQL_DATATYPES.Char30TabTyp;
14: L_ACCT_EXCHANGE_RATE PA_PLSQL_DATATYPES.NumTabTyp;
15: L_CC_PROJECT_ID PA_PLSQL_DATATYPES.IdTabTyp;
16: L_CC_TAX_TASK_ID PA_PLSQL_DATATYPES.IdTabTyp;
17: L_ORG_ID PA_PLSQL_DATATYPES.IdTabTyp;
18: L_REV_CODE_COMBINATION_ID PA_PLSQL_DATATYPES.IdTabTyp;

Line 15: L_CC_PROJECT_ID PA_PLSQL_DATATYPES.IdTabTyp;

11: L_BILL_AMOUNT PA_PLSQL_DATATYPES.NumTabTyp;
12: L_ACCT_RATE_TYPE PA_PLSQL_DATATYPES.Char30TabTyp;
13: L_ACCT_RATE_DATE PA_PLSQL_DATATYPES.Char30TabTyp;
14: L_ACCT_EXCHANGE_RATE PA_PLSQL_DATATYPES.NumTabTyp;
15: L_CC_PROJECT_ID PA_PLSQL_DATATYPES.IdTabTyp;
16: L_CC_TAX_TASK_ID PA_PLSQL_DATATYPES.IdTabTyp;
17: L_ORG_ID PA_PLSQL_DATATYPES.IdTabTyp;
18: L_REV_CODE_COMBINATION_ID PA_PLSQL_DATATYPES.IdTabTyp;
19: L_DRAFT_INVOICE_NUM PA_PLSQL_DATATYPES.IdTabTyp;

Line 16: L_CC_TAX_TASK_ID PA_PLSQL_DATATYPES.IdTabTyp;

12: L_ACCT_RATE_TYPE PA_PLSQL_DATATYPES.Char30TabTyp;
13: L_ACCT_RATE_DATE PA_PLSQL_DATATYPES.Char30TabTyp;
14: L_ACCT_EXCHANGE_RATE PA_PLSQL_DATATYPES.NumTabTyp;
15: L_CC_PROJECT_ID PA_PLSQL_DATATYPES.IdTabTyp;
16: L_CC_TAX_TASK_ID PA_PLSQL_DATATYPES.IdTabTyp;
17: L_ORG_ID PA_PLSQL_DATATYPES.IdTabTyp;
18: L_REV_CODE_COMBINATION_ID PA_PLSQL_DATATYPES.IdTabTyp;
19: L_DRAFT_INVOICE_NUM PA_PLSQL_DATATYPES.IdTabTyp;
20: L_DRAFT_INVOICE_LINE_NUM PA_PLSQL_DATATYPES.IdTabTyp;

Line 17: L_ORG_ID PA_PLSQL_DATATYPES.IdTabTyp;

13: L_ACCT_RATE_DATE PA_PLSQL_DATATYPES.Char30TabTyp;
14: L_ACCT_EXCHANGE_RATE PA_PLSQL_DATATYPES.NumTabTyp;
15: L_CC_PROJECT_ID PA_PLSQL_DATATYPES.IdTabTyp;
16: L_CC_TAX_TASK_ID PA_PLSQL_DATATYPES.IdTabTyp;
17: L_ORG_ID PA_PLSQL_DATATYPES.IdTabTyp;
18: L_REV_CODE_COMBINATION_ID PA_PLSQL_DATATYPES.IdTabTyp;
19: L_DRAFT_INVOICE_NUM PA_PLSQL_DATATYPES.IdTabTyp;
20: L_DRAFT_INVOICE_LINE_NUM PA_PLSQL_DATATYPES.IdTabTyp;
21: L_OUTPUT_VAT_TAX_ID PA_PLSQL_DATATYPES.IdTabTyp;

Line 18: L_REV_CODE_COMBINATION_ID PA_PLSQL_DATATYPES.IdTabTyp;

14: L_ACCT_EXCHANGE_RATE PA_PLSQL_DATATYPES.NumTabTyp;
15: L_CC_PROJECT_ID PA_PLSQL_DATATYPES.IdTabTyp;
16: L_CC_TAX_TASK_ID PA_PLSQL_DATATYPES.IdTabTyp;
17: L_ORG_ID PA_PLSQL_DATATYPES.IdTabTyp;
18: L_REV_CODE_COMBINATION_ID PA_PLSQL_DATATYPES.IdTabTyp;
19: L_DRAFT_INVOICE_NUM PA_PLSQL_DATATYPES.IdTabTyp;
20: L_DRAFT_INVOICE_LINE_NUM PA_PLSQL_DATATYPES.IdTabTyp;
21: L_OUTPUT_VAT_TAX_ID PA_PLSQL_DATATYPES.IdTabTyp;
22: L_OUTPUT_TAX_CODE PA_PLSQL_DATATYPES.Char30TabTyp; --added by hsiu

Line 19: L_DRAFT_INVOICE_NUM PA_PLSQL_DATATYPES.IdTabTyp;

15: L_CC_PROJECT_ID PA_PLSQL_DATATYPES.IdTabTyp;
16: L_CC_TAX_TASK_ID PA_PLSQL_DATATYPES.IdTabTyp;
17: L_ORG_ID PA_PLSQL_DATATYPES.IdTabTyp;
18: L_REV_CODE_COMBINATION_ID PA_PLSQL_DATATYPES.IdTabTyp;
19: L_DRAFT_INVOICE_NUM PA_PLSQL_DATATYPES.IdTabTyp;
20: L_DRAFT_INVOICE_LINE_NUM PA_PLSQL_DATATYPES.IdTabTyp;
21: L_OUTPUT_VAT_TAX_ID PA_PLSQL_DATATYPES.IdTabTyp;
22: L_OUTPUT_TAX_CODE PA_PLSQL_DATATYPES.Char30TabTyp; --added by hsiu
23: L_OUTPUT_TAX_EXEMPT_FLAG PA_PLSQL_DATATYPES.Char1TabTyp;

Line 20: L_DRAFT_INVOICE_LINE_NUM PA_PLSQL_DATATYPES.IdTabTyp;

16: L_CC_TAX_TASK_ID PA_PLSQL_DATATYPES.IdTabTyp;
17: L_ORG_ID PA_PLSQL_DATATYPES.IdTabTyp;
18: L_REV_CODE_COMBINATION_ID PA_PLSQL_DATATYPES.IdTabTyp;
19: L_DRAFT_INVOICE_NUM PA_PLSQL_DATATYPES.IdTabTyp;
20: L_DRAFT_INVOICE_LINE_NUM PA_PLSQL_DATATYPES.IdTabTyp;
21: L_OUTPUT_VAT_TAX_ID PA_PLSQL_DATATYPES.IdTabTyp;
22: L_OUTPUT_TAX_CODE PA_PLSQL_DATATYPES.Char30TabTyp; --added by hsiu
23: L_OUTPUT_TAX_EXEMPT_FLAG PA_PLSQL_DATATYPES.Char1TabTyp;
24: L_OUTPUT_EXEMPT_REASON_CODE PA_PLSQL_DATATYPES.Char30TabTyp;

Line 21: L_OUTPUT_VAT_TAX_ID PA_PLSQL_DATATYPES.IdTabTyp;

17: L_ORG_ID PA_PLSQL_DATATYPES.IdTabTyp;
18: L_REV_CODE_COMBINATION_ID PA_PLSQL_DATATYPES.IdTabTyp;
19: L_DRAFT_INVOICE_NUM PA_PLSQL_DATATYPES.IdTabTyp;
20: L_DRAFT_INVOICE_LINE_NUM PA_PLSQL_DATATYPES.IdTabTyp;
21: L_OUTPUT_VAT_TAX_ID PA_PLSQL_DATATYPES.IdTabTyp;
22: L_OUTPUT_TAX_CODE PA_PLSQL_DATATYPES.Char30TabTyp; --added by hsiu
23: L_OUTPUT_TAX_EXEMPT_FLAG PA_PLSQL_DATATYPES.Char1TabTyp;
24: L_OUTPUT_EXEMPT_REASON_CODE PA_PLSQL_DATATYPES.Char30TabTyp;
25: L_OUTPUT_TAX_EXEMPT_NUMBER PA_PLSQL_DATATYPES.Char80TabTyp;

Line 22: L_OUTPUT_TAX_CODE PA_PLSQL_DATATYPES.Char30TabTyp; --added by hsiu

18: L_REV_CODE_COMBINATION_ID PA_PLSQL_DATATYPES.IdTabTyp;
19: L_DRAFT_INVOICE_NUM PA_PLSQL_DATATYPES.IdTabTyp;
20: L_DRAFT_INVOICE_LINE_NUM PA_PLSQL_DATATYPES.IdTabTyp;
21: L_OUTPUT_VAT_TAX_ID PA_PLSQL_DATATYPES.IdTabTyp;
22: L_OUTPUT_TAX_CODE PA_PLSQL_DATATYPES.Char30TabTyp; --added by hsiu
23: L_OUTPUT_TAX_EXEMPT_FLAG PA_PLSQL_DATATYPES.Char1TabTyp;
24: L_OUTPUT_EXEMPT_REASON_CODE PA_PLSQL_DATATYPES.Char30TabTyp;
25: L_OUTPUT_TAX_EXEMPT_NUMBER PA_PLSQL_DATATYPES.Char80TabTyp;
26: L_LINE_NUM_REVERSED PA_PLSQL_DATATYPES.IdTabTyp;

Line 23: L_OUTPUT_TAX_EXEMPT_FLAG PA_PLSQL_DATATYPES.Char1TabTyp;

19: L_DRAFT_INVOICE_NUM PA_PLSQL_DATATYPES.IdTabTyp;
20: L_DRAFT_INVOICE_LINE_NUM PA_PLSQL_DATATYPES.IdTabTyp;
21: L_OUTPUT_VAT_TAX_ID PA_PLSQL_DATATYPES.IdTabTyp;
22: L_OUTPUT_TAX_CODE PA_PLSQL_DATATYPES.Char30TabTyp; --added by hsiu
23: L_OUTPUT_TAX_EXEMPT_FLAG PA_PLSQL_DATATYPES.Char1TabTyp;
24: L_OUTPUT_EXEMPT_REASON_CODE PA_PLSQL_DATATYPES.Char30TabTyp;
25: L_OUTPUT_TAX_EXEMPT_NUMBER PA_PLSQL_DATATYPES.Char80TabTyp;
26: L_LINE_NUM_REVERSED PA_PLSQL_DATATYPES.IdTabTyp;
27: L_DETAIL_ID_REVERSED PA_PLSQL_DATATYPES.IdTabTyp;

Line 24: L_OUTPUT_EXEMPT_REASON_CODE PA_PLSQL_DATATYPES.Char30TabTyp;

20: L_DRAFT_INVOICE_LINE_NUM PA_PLSQL_DATATYPES.IdTabTyp;
21: L_OUTPUT_VAT_TAX_ID PA_PLSQL_DATATYPES.IdTabTyp;
22: L_OUTPUT_TAX_CODE PA_PLSQL_DATATYPES.Char30TabTyp; --added by hsiu
23: L_OUTPUT_TAX_EXEMPT_FLAG PA_PLSQL_DATATYPES.Char1TabTyp;
24: L_OUTPUT_EXEMPT_REASON_CODE PA_PLSQL_DATATYPES.Char30TabTyp;
25: L_OUTPUT_TAX_EXEMPT_NUMBER PA_PLSQL_DATATYPES.Char80TabTyp;
26: L_LINE_NUM_REVERSED PA_PLSQL_DATATYPES.IdTabTyp;
27: L_DETAIL_ID_REVERSED PA_PLSQL_DATATYPES.IdTabTyp;
28: L_DETAIL_ID PA_PLSQL_DATATYPES.IdTabTyp;

Line 25: L_OUTPUT_TAX_EXEMPT_NUMBER PA_PLSQL_DATATYPES.Char80TabTyp;

21: L_OUTPUT_VAT_TAX_ID PA_PLSQL_DATATYPES.IdTabTyp;
22: L_OUTPUT_TAX_CODE PA_PLSQL_DATATYPES.Char30TabTyp; --added by hsiu
23: L_OUTPUT_TAX_EXEMPT_FLAG PA_PLSQL_DATATYPES.Char1TabTyp;
24: L_OUTPUT_EXEMPT_REASON_CODE PA_PLSQL_DATATYPES.Char30TabTyp;
25: L_OUTPUT_TAX_EXEMPT_NUMBER PA_PLSQL_DATATYPES.Char80TabTyp;
26: L_LINE_NUM_REVERSED PA_PLSQL_DATATYPES.IdTabTyp;
27: L_DETAIL_ID_REVERSED PA_PLSQL_DATATYPES.IdTabTyp;
28: L_DETAIL_ID PA_PLSQL_DATATYPES.IdTabTyp;
29: L_REVERSED_FLAG PA_PLSQL_DATATYPES.Char1TabTyp;

Line 26: L_LINE_NUM_REVERSED PA_PLSQL_DATATYPES.IdTabTyp;

22: L_OUTPUT_TAX_CODE PA_PLSQL_DATATYPES.Char30TabTyp; --added by hsiu
23: L_OUTPUT_TAX_EXEMPT_FLAG PA_PLSQL_DATATYPES.Char1TabTyp;
24: L_OUTPUT_EXEMPT_REASON_CODE PA_PLSQL_DATATYPES.Char30TabTyp;
25: L_OUTPUT_TAX_EXEMPT_NUMBER PA_PLSQL_DATATYPES.Char80TabTyp;
26: L_LINE_NUM_REVERSED PA_PLSQL_DATATYPES.IdTabTyp;
27: L_DETAIL_ID_REVERSED PA_PLSQL_DATATYPES.IdTabTyp;
28: L_DETAIL_ID PA_PLSQL_DATATYPES.IdTabTyp;
29: L_REVERSED_FLAG PA_PLSQL_DATATYPES.Char1TabTyp;
30: L_MARKUP_CALC_BASE_CODE PA_PLSQL_DATATYPES.Char30TabTyp;

Line 27: L_DETAIL_ID_REVERSED PA_PLSQL_DATATYPES.IdTabTyp;

23: L_OUTPUT_TAX_EXEMPT_FLAG PA_PLSQL_DATATYPES.Char1TabTyp;
24: L_OUTPUT_EXEMPT_REASON_CODE PA_PLSQL_DATATYPES.Char30TabTyp;
25: L_OUTPUT_TAX_EXEMPT_NUMBER PA_PLSQL_DATATYPES.Char80TabTyp;
26: L_LINE_NUM_REVERSED PA_PLSQL_DATATYPES.IdTabTyp;
27: L_DETAIL_ID_REVERSED PA_PLSQL_DATATYPES.IdTabTyp;
28: L_DETAIL_ID PA_PLSQL_DATATYPES.IdTabTyp;
29: L_REVERSED_FLAG PA_PLSQL_DATATYPES.Char1TabTyp;
30: L_MARKUP_CALC_BASE_CODE PA_PLSQL_DATATYPES.Char30TabTyp;
31: L_IND_COMPILED_SET_ID PA_PLSQL_DATATYPES.IdTabTyp;

Line 28: L_DETAIL_ID PA_PLSQL_DATATYPES.IdTabTyp;

24: L_OUTPUT_EXEMPT_REASON_CODE PA_PLSQL_DATATYPES.Char30TabTyp;
25: L_OUTPUT_TAX_EXEMPT_NUMBER PA_PLSQL_DATATYPES.Char80TabTyp;
26: L_LINE_NUM_REVERSED PA_PLSQL_DATATYPES.IdTabTyp;
27: L_DETAIL_ID_REVERSED PA_PLSQL_DATATYPES.IdTabTyp;
28: L_DETAIL_ID PA_PLSQL_DATATYPES.IdTabTyp;
29: L_REVERSED_FLAG PA_PLSQL_DATATYPES.Char1TabTyp;
30: L_MARKUP_CALC_BASE_CODE PA_PLSQL_DATATYPES.Char30TabTyp;
31: L_IND_COMPILED_SET_ID PA_PLSQL_DATATYPES.IdTabTyp;
32: L_RULE_PERCENTAGE PA_PLSQL_DATATYPES.NumTabTyp;

Line 29: L_REVERSED_FLAG PA_PLSQL_DATATYPES.Char1TabTyp;

25: L_OUTPUT_TAX_EXEMPT_NUMBER PA_PLSQL_DATATYPES.Char80TabTyp;
26: L_LINE_NUM_REVERSED PA_PLSQL_DATATYPES.IdTabTyp;
27: L_DETAIL_ID_REVERSED PA_PLSQL_DATATYPES.IdTabTyp;
28: L_DETAIL_ID PA_PLSQL_DATATYPES.IdTabTyp;
29: L_REVERSED_FLAG PA_PLSQL_DATATYPES.Char1TabTyp;
30: L_MARKUP_CALC_BASE_CODE PA_PLSQL_DATATYPES.Char30TabTyp;
31: L_IND_COMPILED_SET_ID PA_PLSQL_DATATYPES.IdTabTyp;
32: L_RULE_PERCENTAGE PA_PLSQL_DATATYPES.NumTabTyp;
33: L_BILL_RATE PA_PLSQL_DATATYPES.NumTabTyp;

Line 30: L_MARKUP_CALC_BASE_CODE PA_PLSQL_DATATYPES.Char30TabTyp;

26: L_LINE_NUM_REVERSED PA_PLSQL_DATATYPES.IdTabTyp;
27: L_DETAIL_ID_REVERSED PA_PLSQL_DATATYPES.IdTabTyp;
28: L_DETAIL_ID PA_PLSQL_DATATYPES.IdTabTyp;
29: L_REVERSED_FLAG PA_PLSQL_DATATYPES.Char1TabTyp;
30: L_MARKUP_CALC_BASE_CODE PA_PLSQL_DATATYPES.Char30TabTyp;
31: L_IND_COMPILED_SET_ID PA_PLSQL_DATATYPES.IdTabTyp;
32: L_RULE_PERCENTAGE PA_PLSQL_DATATYPES.NumTabTyp;
33: L_BILL_RATE PA_PLSQL_DATATYPES.NumTabTyp;
34: L_BILL_MARKUP_PERCENTAGE PA_PLSQL_DATATYPES.NumTabTyp;

Line 31: L_IND_COMPILED_SET_ID PA_PLSQL_DATATYPES.IdTabTyp;

27: L_DETAIL_ID_REVERSED PA_PLSQL_DATATYPES.IdTabTyp;
28: L_DETAIL_ID PA_PLSQL_DATATYPES.IdTabTyp;
29: L_REVERSED_FLAG PA_PLSQL_DATATYPES.Char1TabTyp;
30: L_MARKUP_CALC_BASE_CODE PA_PLSQL_DATATYPES.Char30TabTyp;
31: L_IND_COMPILED_SET_ID PA_PLSQL_DATATYPES.IdTabTyp;
32: L_RULE_PERCENTAGE PA_PLSQL_DATATYPES.NumTabTyp;
33: L_BILL_RATE PA_PLSQL_DATATYPES.NumTabTyp;
34: L_BILL_MARKUP_PERCENTAGE PA_PLSQL_DATATYPES.NumTabTyp;
35: L_BASE_AMOUNT PA_PLSQL_DATATYPES.NumTabTyp;

Line 32: L_RULE_PERCENTAGE PA_PLSQL_DATATYPES.NumTabTyp;

28: L_DETAIL_ID PA_PLSQL_DATATYPES.IdTabTyp;
29: L_REVERSED_FLAG PA_PLSQL_DATATYPES.Char1TabTyp;
30: L_MARKUP_CALC_BASE_CODE PA_PLSQL_DATATYPES.Char30TabTyp;
31: L_IND_COMPILED_SET_ID PA_PLSQL_DATATYPES.IdTabTyp;
32: L_RULE_PERCENTAGE PA_PLSQL_DATATYPES.NumTabTyp;
33: L_BILL_RATE PA_PLSQL_DATATYPES.NumTabTyp;
34: L_BILL_MARKUP_PERCENTAGE PA_PLSQL_DATATYPES.NumTabTyp;
35: L_BASE_AMOUNT PA_PLSQL_DATATYPES.NumTabTyp;
36: L_SCHEDULE_LINE_PERCENTAGE PA_PLSQL_DATATYPES.NumTabTyp;

Line 33: L_BILL_RATE PA_PLSQL_DATATYPES.NumTabTyp;

29: L_REVERSED_FLAG PA_PLSQL_DATATYPES.Char1TabTyp;
30: L_MARKUP_CALC_BASE_CODE PA_PLSQL_DATATYPES.Char30TabTyp;
31: L_IND_COMPILED_SET_ID PA_PLSQL_DATATYPES.IdTabTyp;
32: L_RULE_PERCENTAGE PA_PLSQL_DATATYPES.NumTabTyp;
33: L_BILL_RATE PA_PLSQL_DATATYPES.NumTabTyp;
34: L_BILL_MARKUP_PERCENTAGE PA_PLSQL_DATATYPES.NumTabTyp;
35: L_BASE_AMOUNT PA_PLSQL_DATATYPES.NumTabTyp;
36: L_SCHEDULE_LINE_PERCENTAGE PA_PLSQL_DATATYPES.NumTabTyp;
37: L_ORIG_INV_NUM PA_PLSQL_DATATYPES.IdTabTyp;

Line 34: L_BILL_MARKUP_PERCENTAGE PA_PLSQL_DATATYPES.NumTabTyp;

30: L_MARKUP_CALC_BASE_CODE PA_PLSQL_DATATYPES.Char30TabTyp;
31: L_IND_COMPILED_SET_ID PA_PLSQL_DATATYPES.IdTabTyp;
32: L_RULE_PERCENTAGE PA_PLSQL_DATATYPES.NumTabTyp;
33: L_BILL_RATE PA_PLSQL_DATATYPES.NumTabTyp;
34: L_BILL_MARKUP_PERCENTAGE PA_PLSQL_DATATYPES.NumTabTyp;
35: L_BASE_AMOUNT PA_PLSQL_DATATYPES.NumTabTyp;
36: L_SCHEDULE_LINE_PERCENTAGE PA_PLSQL_DATATYPES.NumTabTyp;
37: L_ORIG_INV_NUM PA_PLSQL_DATATYPES.IdTabTyp;
38: L_ORIG_INV_LINE_NUM PA_PLSQL_DATATYPES.IdTabTyp;

Line 35: L_BASE_AMOUNT PA_PLSQL_DATATYPES.NumTabTyp;

31: L_IND_COMPILED_SET_ID PA_PLSQL_DATATYPES.IdTabTyp;
32: L_RULE_PERCENTAGE PA_PLSQL_DATATYPES.NumTabTyp;
33: L_BILL_RATE PA_PLSQL_DATATYPES.NumTabTyp;
34: L_BILL_MARKUP_PERCENTAGE PA_PLSQL_DATATYPES.NumTabTyp;
35: L_BASE_AMOUNT PA_PLSQL_DATATYPES.NumTabTyp;
36: L_SCHEDULE_LINE_PERCENTAGE PA_PLSQL_DATATYPES.NumTabTyp;
37: L_ORIG_INV_NUM PA_PLSQL_DATATYPES.IdTabTyp;
38: L_ORIG_INV_LINE_NUM PA_PLSQL_DATATYPES.IdTabTyp;
39: /* Added for cross proj*/

Line 36: L_SCHEDULE_LINE_PERCENTAGE PA_PLSQL_DATATYPES.NumTabTyp;

32: L_RULE_PERCENTAGE PA_PLSQL_DATATYPES.NumTabTyp;
33: L_BILL_RATE PA_PLSQL_DATATYPES.NumTabTyp;
34: L_BILL_MARKUP_PERCENTAGE PA_PLSQL_DATATYPES.NumTabTyp;
35: L_BASE_AMOUNT PA_PLSQL_DATATYPES.NumTabTyp;
36: L_SCHEDULE_LINE_PERCENTAGE PA_PLSQL_DATATYPES.NumTabTyp;
37: L_ORIG_INV_NUM PA_PLSQL_DATATYPES.IdTabTyp;
38: L_ORIG_INV_LINE_NUM PA_PLSQL_DATATYPES.IdTabTyp;
39: /* Added for cross proj*/
40: L_TP_AMT_TYPE_CODE PA_PLSQL_DATATYPES.Char30TabTyp;

Line 37: L_ORIG_INV_NUM PA_PLSQL_DATATYPES.IdTabTyp;

33: L_BILL_RATE PA_PLSQL_DATATYPES.NumTabTyp;
34: L_BILL_MARKUP_PERCENTAGE PA_PLSQL_DATATYPES.NumTabTyp;
35: L_BASE_AMOUNT PA_PLSQL_DATATYPES.NumTabTyp;
36: L_SCHEDULE_LINE_PERCENTAGE PA_PLSQL_DATATYPES.NumTabTyp;
37: L_ORIG_INV_NUM PA_PLSQL_DATATYPES.IdTabTyp;
38: L_ORIG_INV_LINE_NUM PA_PLSQL_DATATYPES.IdTabTyp;
39: /* Added for cross proj*/
40: L_TP_AMT_TYPE_CODE PA_PLSQL_DATATYPES.Char30TabTyp;
41: L_PROJECT_TP_RATE_TYPE PA_PLSQL_DATATYPES.Char30TabTyp;

Line 38: L_ORIG_INV_LINE_NUM PA_PLSQL_DATATYPES.IdTabTyp;

34: L_BILL_MARKUP_PERCENTAGE PA_PLSQL_DATATYPES.NumTabTyp;
35: L_BASE_AMOUNT PA_PLSQL_DATATYPES.NumTabTyp;
36: L_SCHEDULE_LINE_PERCENTAGE PA_PLSQL_DATATYPES.NumTabTyp;
37: L_ORIG_INV_NUM PA_PLSQL_DATATYPES.IdTabTyp;
38: L_ORIG_INV_LINE_NUM PA_PLSQL_DATATYPES.IdTabTyp;
39: /* Added for cross proj*/
40: L_TP_AMT_TYPE_CODE PA_PLSQL_DATATYPES.Char30TabTyp;
41: L_PROJECT_TP_RATE_TYPE PA_PLSQL_DATATYPES.Char30TabTyp;
42: L_PROJECT_TP_RATE_DATE PA_PLSQL_DATATYPES.Char30TabTyp;

Line 40: L_TP_AMT_TYPE_CODE PA_PLSQL_DATATYPES.Char30TabTyp;

36: L_SCHEDULE_LINE_PERCENTAGE PA_PLSQL_DATATYPES.NumTabTyp;
37: L_ORIG_INV_NUM PA_PLSQL_DATATYPES.IdTabTyp;
38: L_ORIG_INV_LINE_NUM PA_PLSQL_DATATYPES.IdTabTyp;
39: /* Added for cross proj*/
40: L_TP_AMT_TYPE_CODE PA_PLSQL_DATATYPES.Char30TabTyp;
41: L_PROJECT_TP_RATE_TYPE PA_PLSQL_DATATYPES.Char30TabTyp;
42: L_PROJECT_TP_RATE_DATE PA_PLSQL_DATATYPES.Char30TabTyp;
43: L_PROJECT_TP_EXCHANGE_RATE PA_PLSQL_DATATYPES.Char30TabTyp;
44: L_PROJECT_TRANSFER_PRICE PA_PLSQL_DATATYPES.Char30TabTyp;

Line 41: L_PROJECT_TP_RATE_TYPE PA_PLSQL_DATATYPES.Char30TabTyp;

37: L_ORIG_INV_NUM PA_PLSQL_DATATYPES.IdTabTyp;
38: L_ORIG_INV_LINE_NUM PA_PLSQL_DATATYPES.IdTabTyp;
39: /* Added for cross proj*/
40: L_TP_AMT_TYPE_CODE PA_PLSQL_DATATYPES.Char30TabTyp;
41: L_PROJECT_TP_RATE_TYPE PA_PLSQL_DATATYPES.Char30TabTyp;
42: L_PROJECT_TP_RATE_DATE PA_PLSQL_DATATYPES.Char30TabTyp;
43: L_PROJECT_TP_EXCHANGE_RATE PA_PLSQL_DATATYPES.Char30TabTyp;
44: L_PROJECT_TRANSFER_PRICE PA_PLSQL_DATATYPES.Char30TabTyp;
45: L_PROJFUNC_TP_RATE_TYPE PA_PLSQL_DATATYPES.Char30TabTyp;

Line 42: L_PROJECT_TP_RATE_DATE PA_PLSQL_DATATYPES.Char30TabTyp;

38: L_ORIG_INV_LINE_NUM PA_PLSQL_DATATYPES.IdTabTyp;
39: /* Added for cross proj*/
40: L_TP_AMT_TYPE_CODE PA_PLSQL_DATATYPES.Char30TabTyp;
41: L_PROJECT_TP_RATE_TYPE PA_PLSQL_DATATYPES.Char30TabTyp;
42: L_PROJECT_TP_RATE_DATE PA_PLSQL_DATATYPES.Char30TabTyp;
43: L_PROJECT_TP_EXCHANGE_RATE PA_PLSQL_DATATYPES.Char30TabTyp;
44: L_PROJECT_TRANSFER_PRICE PA_PLSQL_DATATYPES.Char30TabTyp;
45: L_PROJFUNC_TP_RATE_TYPE PA_PLSQL_DATATYPES.Char30TabTyp;
46: L_PROJFUNC_TP_RATE_DATE PA_PLSQL_DATATYPES.Char30TabTyp;

Line 43: L_PROJECT_TP_EXCHANGE_RATE PA_PLSQL_DATATYPES.Char30TabTyp;

39: /* Added for cross proj*/
40: L_TP_AMT_TYPE_CODE PA_PLSQL_DATATYPES.Char30TabTyp;
41: L_PROJECT_TP_RATE_TYPE PA_PLSQL_DATATYPES.Char30TabTyp;
42: L_PROJECT_TP_RATE_DATE PA_PLSQL_DATATYPES.Char30TabTyp;
43: L_PROJECT_TP_EXCHANGE_RATE PA_PLSQL_DATATYPES.Char30TabTyp;
44: L_PROJECT_TRANSFER_PRICE PA_PLSQL_DATATYPES.Char30TabTyp;
45: L_PROJFUNC_TP_RATE_TYPE PA_PLSQL_DATATYPES.Char30TabTyp;
46: L_PROJFUNC_TP_RATE_DATE PA_PLSQL_DATATYPES.Char30TabTyp;
47: L_PROJFUNC_TP_EXCHANGE_RATE PA_PLSQL_DATATYPES.Char30TabTyp;

Line 44: L_PROJECT_TRANSFER_PRICE PA_PLSQL_DATATYPES.Char30TabTyp;

40: L_TP_AMT_TYPE_CODE PA_PLSQL_DATATYPES.Char30TabTyp;
41: L_PROJECT_TP_RATE_TYPE PA_PLSQL_DATATYPES.Char30TabTyp;
42: L_PROJECT_TP_RATE_DATE PA_PLSQL_DATATYPES.Char30TabTyp;
43: L_PROJECT_TP_EXCHANGE_RATE PA_PLSQL_DATATYPES.Char30TabTyp;
44: L_PROJECT_TRANSFER_PRICE PA_PLSQL_DATATYPES.Char30TabTyp;
45: L_PROJFUNC_TP_RATE_TYPE PA_PLSQL_DATATYPES.Char30TabTyp;
46: L_PROJFUNC_TP_RATE_DATE PA_PLSQL_DATATYPES.Char30TabTyp;
47: L_PROJFUNC_TP_EXCHANGE_RATE PA_PLSQL_DATATYPES.Char30TabTyp;
48: L_PROJFUNC_TRANSFER_PRICE PA_PLSQL_DATATYPES.Char30TabTyp;

Line 45: L_PROJFUNC_TP_RATE_TYPE PA_PLSQL_DATATYPES.Char30TabTyp;

41: L_PROJECT_TP_RATE_TYPE PA_PLSQL_DATATYPES.Char30TabTyp;
42: L_PROJECT_TP_RATE_DATE PA_PLSQL_DATATYPES.Char30TabTyp;
43: L_PROJECT_TP_EXCHANGE_RATE PA_PLSQL_DATATYPES.Char30TabTyp;
44: L_PROJECT_TRANSFER_PRICE PA_PLSQL_DATATYPES.Char30TabTyp;
45: L_PROJFUNC_TP_RATE_TYPE PA_PLSQL_DATATYPES.Char30TabTyp;
46: L_PROJFUNC_TP_RATE_DATE PA_PLSQL_DATATYPES.Char30TabTyp;
47: L_PROJFUNC_TP_EXCHANGE_RATE PA_PLSQL_DATATYPES.Char30TabTyp;
48: L_PROJFUNC_TRANSFER_PRICE PA_PLSQL_DATATYPES.Char30TabTyp;
49:

Line 46: L_PROJFUNC_TP_RATE_DATE PA_PLSQL_DATATYPES.Char30TabTyp;

42: L_PROJECT_TP_RATE_DATE PA_PLSQL_DATATYPES.Char30TabTyp;
43: L_PROJECT_TP_EXCHANGE_RATE PA_PLSQL_DATATYPES.Char30TabTyp;
44: L_PROJECT_TRANSFER_PRICE PA_PLSQL_DATATYPES.Char30TabTyp;
45: L_PROJFUNC_TP_RATE_TYPE PA_PLSQL_DATATYPES.Char30TabTyp;
46: L_PROJFUNC_TP_RATE_DATE PA_PLSQL_DATATYPES.Char30TabTyp;
47: L_PROJFUNC_TP_EXCHANGE_RATE PA_PLSQL_DATATYPES.Char30TabTyp;
48: L_PROJFUNC_TRANSFER_PRICE PA_PLSQL_DATATYPES.Char30TabTyp;
49:
50: L_PROJECT_TP_CURRENCY_CODE PA_PLSQL_DATATYPES.Char15TabTyp;

Line 47: L_PROJFUNC_TP_EXCHANGE_RATE PA_PLSQL_DATATYPES.Char30TabTyp;

43: L_PROJECT_TP_EXCHANGE_RATE PA_PLSQL_DATATYPES.Char30TabTyp;
44: L_PROJECT_TRANSFER_PRICE PA_PLSQL_DATATYPES.Char30TabTyp;
45: L_PROJFUNC_TP_RATE_TYPE PA_PLSQL_DATATYPES.Char30TabTyp;
46: L_PROJFUNC_TP_RATE_DATE PA_PLSQL_DATATYPES.Char30TabTyp;
47: L_PROJFUNC_TP_EXCHANGE_RATE PA_PLSQL_DATATYPES.Char30TabTyp;
48: L_PROJFUNC_TRANSFER_PRICE PA_PLSQL_DATATYPES.Char30TabTyp;
49:
50: L_PROJECT_TP_CURRENCY_CODE PA_PLSQL_DATATYPES.Char15TabTyp;
51: L_PROJFUNC_TP_CURRENCY_CODE PA_PLSQL_DATATYPES.Char15TabTyp;

Line 48: L_PROJFUNC_TRANSFER_PRICE PA_PLSQL_DATATYPES.Char30TabTyp;

44: L_PROJECT_TRANSFER_PRICE PA_PLSQL_DATATYPES.Char30TabTyp;
45: L_PROJFUNC_TP_RATE_TYPE PA_PLSQL_DATATYPES.Char30TabTyp;
46: L_PROJFUNC_TP_RATE_DATE PA_PLSQL_DATATYPES.Char30TabTyp;
47: L_PROJFUNC_TP_EXCHANGE_RATE PA_PLSQL_DATATYPES.Char30TabTyp;
48: L_PROJFUNC_TRANSFER_PRICE PA_PLSQL_DATATYPES.Char30TabTyp;
49:
50: L_PROJECT_TP_CURRENCY_CODE PA_PLSQL_DATATYPES.Char15TabTyp;
51: L_PROJFUNC_TP_CURRENCY_CODE PA_PLSQL_DATATYPES.Char15TabTyp;
52: /* End for cross proj*/

Line 50: L_PROJECT_TP_CURRENCY_CODE PA_PLSQL_DATATYPES.Char15TabTyp;

46: L_PROJFUNC_TP_RATE_DATE PA_PLSQL_DATATYPES.Char30TabTyp;
47: L_PROJFUNC_TP_EXCHANGE_RATE PA_PLSQL_DATATYPES.Char30TabTyp;
48: L_PROJFUNC_TRANSFER_PRICE PA_PLSQL_DATATYPES.Char30TabTyp;
49:
50: L_PROJECT_TP_CURRENCY_CODE PA_PLSQL_DATATYPES.Char15TabTyp;
51: L_PROJFUNC_TP_CURRENCY_CODE PA_PLSQL_DATATYPES.Char15TabTyp;
52: /* End for cross proj*/
53:
54: /* CBGA and Project Jobs */

Line 51: L_PROJFUNC_TP_CURRENCY_CODE PA_PLSQL_DATATYPES.Char15TabTyp;

47: L_PROJFUNC_TP_EXCHANGE_RATE PA_PLSQL_DATATYPES.Char30TabTyp;
48: L_PROJFUNC_TRANSFER_PRICE PA_PLSQL_DATATYPES.Char30TabTyp;
49:
50: L_PROJECT_TP_CURRENCY_CODE PA_PLSQL_DATATYPES.Char15TabTyp;
51: L_PROJFUNC_TP_CURRENCY_CODE PA_PLSQL_DATATYPES.Char15TabTyp;
52: /* End for cross proj*/
53:
54: /* CBGA and Project Jobs */
55:

Line 56: L_TP_JOB_ID PA_PLSQL_DATATYPES.IdTabTyp;

52: /* End for cross proj*/
53:
54: /* CBGA and Project Jobs */
55:
56: L_TP_JOB_ID PA_PLSQL_DATATYPES.IdTabTyp;
57: L_PROV_PROJ_BILL_JOB_ID PA_PLSQL_DATATYPES.IdTabTyp;
58:
59: /* 1898341 P_rec_counter modified as in out parameter */
60: g1_debug_mode varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

Line 57: L_PROV_PROJ_BILL_JOB_ID PA_PLSQL_DATATYPES.IdTabTyp;

53:
54: /* CBGA and Project Jobs */
55:
56: L_TP_JOB_ID PA_PLSQL_DATATYPES.IdTabTyp;
57: L_PROV_PROJ_BILL_JOB_ID PA_PLSQL_DATATYPES.IdTabTyp;
58:
59: /* 1898341 P_rec_counter modified as in out parameter */
60: g1_debug_mode varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
61:

Line 353: P_mrc_reqd_flag IN PA_PLSQL_DATATYPES.Char1TabTyp)

349: END Insert_rows;
350:
351: PROCEDURE Update_rows
352: ( P_inv_rec_tab IN OUT NOCOPY inv_rec_tab,
353: P_mrc_reqd_flag IN PA_PLSQL_DATATYPES.Char1TabTyp)
354: IS
355: BEGIN
356:
357: IF g1_debug_mode = 'Y' THEN