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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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*/
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;
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;
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;
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;
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;
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;
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;
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;
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:
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;
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;
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*/
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 */
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:
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');
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:
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