45: P_Delete_tab PA_INVOICE_DETAIL_PKG.inv_rec_tab;
46: P_Update_tab PA_INVOICE_DETAIL_PKG.inv_rec_tab;
47:
48: --EI Table for marking status as IC Processed.
49: P_Ei_table PA_PLSQL_DATATYPES.IdTabTyp;
50: I_Ei_count number;
51:
52: --storing Line num
53: I_Line_num Number;
53: I_Line_num Number;
54:
55: --Table parameter of Transfer Price
56:
57: I_DENOM_CURRENCY_CODE PA_PLSQL_DATATYPES.Char15TabTyp;
58: I_DENOM_BILL_AMOUNT PA_PLSQL_DATATYPES.Char30TabTyp;
59: I_ACCT_CURRENCY_CODE PA_PLSQL_DATATYPES.Char15TabTyp;
60: I_BILL_AMOUNT PA_PLSQL_DATATYPES.Char30TabTyp;
61: I_ACCT_RATE_TYPE PA_PLSQL_DATATYPES.Char30TabTyp;
54:
55: --Table parameter of Transfer Price
56:
57: I_DENOM_CURRENCY_CODE PA_PLSQL_DATATYPES.Char15TabTyp;
58: I_DENOM_BILL_AMOUNT PA_PLSQL_DATATYPES.Char30TabTyp;
59: I_ACCT_CURRENCY_CODE PA_PLSQL_DATATYPES.Char15TabTyp;
60: I_BILL_AMOUNT PA_PLSQL_DATATYPES.Char30TabTyp;
61: I_ACCT_RATE_TYPE PA_PLSQL_DATATYPES.Char30TabTyp;
62: I_ACCT_RATE_DATE PA_PLSQL_DATATYPES.Char30TabTyp;
55: --Table parameter of Transfer Price
56:
57: I_DENOM_CURRENCY_CODE PA_PLSQL_DATATYPES.Char15TabTyp;
58: I_DENOM_BILL_AMOUNT PA_PLSQL_DATATYPES.Char30TabTyp;
59: I_ACCT_CURRENCY_CODE PA_PLSQL_DATATYPES.Char15TabTyp;
60: I_BILL_AMOUNT PA_PLSQL_DATATYPES.Char30TabTyp;
61: I_ACCT_RATE_TYPE PA_PLSQL_DATATYPES.Char30TabTyp;
62: I_ACCT_RATE_DATE PA_PLSQL_DATATYPES.Char30TabTyp;
63: I_ACCT_EXCHANGE_RATE PA_PLSQL_DATATYPES.Char30TabTyp;
56:
57: I_DENOM_CURRENCY_CODE PA_PLSQL_DATATYPES.Char15TabTyp;
58: I_DENOM_BILL_AMOUNT PA_PLSQL_DATATYPES.Char30TabTyp;
59: I_ACCT_CURRENCY_CODE PA_PLSQL_DATATYPES.Char15TabTyp;
60: I_BILL_AMOUNT PA_PLSQL_DATATYPES.Char30TabTyp;
61: I_ACCT_RATE_TYPE PA_PLSQL_DATATYPES.Char30TabTyp;
62: I_ACCT_RATE_DATE PA_PLSQL_DATATYPES.Char30TabTyp;
63: I_ACCT_EXCHANGE_RATE PA_PLSQL_DATATYPES.Char30TabTyp;
64: I_REV_CODE_COMBINATION_ID PA_PLSQL_DATATYPES.IdTabTyp;
57: I_DENOM_CURRENCY_CODE PA_PLSQL_DATATYPES.Char15TabTyp;
58: I_DENOM_BILL_AMOUNT PA_PLSQL_DATATYPES.Char30TabTyp;
59: I_ACCT_CURRENCY_CODE PA_PLSQL_DATATYPES.Char15TabTyp;
60: I_BILL_AMOUNT PA_PLSQL_DATATYPES.Char30TabTyp;
61: I_ACCT_RATE_TYPE PA_PLSQL_DATATYPES.Char30TabTyp;
62: I_ACCT_RATE_DATE PA_PLSQL_DATATYPES.Char30TabTyp;
63: I_ACCT_EXCHANGE_RATE PA_PLSQL_DATATYPES.Char30TabTyp;
64: I_REV_CODE_COMBINATION_ID PA_PLSQL_DATATYPES.IdTabTyp;
65: I_OUTPUT_VAT_TAX_ID PA_PLSQL_DATATYPES.IdTabTyp;
58: I_DENOM_BILL_AMOUNT PA_PLSQL_DATATYPES.Char30TabTyp;
59: I_ACCT_CURRENCY_CODE PA_PLSQL_DATATYPES.Char15TabTyp;
60: I_BILL_AMOUNT PA_PLSQL_DATATYPES.Char30TabTyp;
61: I_ACCT_RATE_TYPE PA_PLSQL_DATATYPES.Char30TabTyp;
62: I_ACCT_RATE_DATE PA_PLSQL_DATATYPES.Char30TabTyp;
63: I_ACCT_EXCHANGE_RATE PA_PLSQL_DATATYPES.Char30TabTyp;
64: I_REV_CODE_COMBINATION_ID PA_PLSQL_DATATYPES.IdTabTyp;
65: I_OUTPUT_VAT_TAX_ID PA_PLSQL_DATATYPES.IdTabTyp;
66: I_OUTPUT_TAX_CODE PA_PLSQL_DATATYPES.Char30TabTyp;
59: I_ACCT_CURRENCY_CODE PA_PLSQL_DATATYPES.Char15TabTyp;
60: I_BILL_AMOUNT PA_PLSQL_DATATYPES.Char30TabTyp;
61: I_ACCT_RATE_TYPE PA_PLSQL_DATATYPES.Char30TabTyp;
62: I_ACCT_RATE_DATE PA_PLSQL_DATATYPES.Char30TabTyp;
63: I_ACCT_EXCHANGE_RATE PA_PLSQL_DATATYPES.Char30TabTyp;
64: I_REV_CODE_COMBINATION_ID PA_PLSQL_DATATYPES.IdTabTyp;
65: I_OUTPUT_VAT_TAX_ID PA_PLSQL_DATATYPES.IdTabTyp;
66: I_OUTPUT_TAX_CODE PA_PLSQL_DATATYPES.Char30TabTyp;
67: I_OUTPUT_TAX_EXEMPT_FLAG PA_PLSQL_DATATYPES.Char1TabTyp;
60: I_BILL_AMOUNT PA_PLSQL_DATATYPES.Char30TabTyp;
61: I_ACCT_RATE_TYPE PA_PLSQL_DATATYPES.Char30TabTyp;
62: I_ACCT_RATE_DATE PA_PLSQL_DATATYPES.Char30TabTyp;
63: I_ACCT_EXCHANGE_RATE PA_PLSQL_DATATYPES.Char30TabTyp;
64: I_REV_CODE_COMBINATION_ID PA_PLSQL_DATATYPES.IdTabTyp;
65: I_OUTPUT_VAT_TAX_ID PA_PLSQL_DATATYPES.IdTabTyp;
66: I_OUTPUT_TAX_CODE PA_PLSQL_DATATYPES.Char30TabTyp;
67: I_OUTPUT_TAX_EXEMPT_FLAG PA_PLSQL_DATATYPES.Char1TabTyp;
68: I_TAX_EXEMPT_REASON_CODE PA_PLSQL_DATATYPES.Char80TabTyp;
61: I_ACCT_RATE_TYPE PA_PLSQL_DATATYPES.Char30TabTyp;
62: I_ACCT_RATE_DATE PA_PLSQL_DATATYPES.Char30TabTyp;
63: I_ACCT_EXCHANGE_RATE PA_PLSQL_DATATYPES.Char30TabTyp;
64: I_REV_CODE_COMBINATION_ID PA_PLSQL_DATATYPES.IdTabTyp;
65: I_OUTPUT_VAT_TAX_ID PA_PLSQL_DATATYPES.IdTabTyp;
66: I_OUTPUT_TAX_CODE PA_PLSQL_DATATYPES.Char30TabTyp;
67: I_OUTPUT_TAX_EXEMPT_FLAG PA_PLSQL_DATATYPES.Char1TabTyp;
68: I_TAX_EXEMPT_REASON_CODE PA_PLSQL_DATATYPES.Char80TabTyp;
69: I_OUTPUT_TAX_EXEMPT_NUMBER PA_PLSQL_DATATYPES.Char30TabTyp;
62: I_ACCT_RATE_DATE PA_PLSQL_DATATYPES.Char30TabTyp;
63: I_ACCT_EXCHANGE_RATE PA_PLSQL_DATATYPES.Char30TabTyp;
64: I_REV_CODE_COMBINATION_ID PA_PLSQL_DATATYPES.IdTabTyp;
65: I_OUTPUT_VAT_TAX_ID PA_PLSQL_DATATYPES.IdTabTyp;
66: I_OUTPUT_TAX_CODE PA_PLSQL_DATATYPES.Char30TabTyp;
67: I_OUTPUT_TAX_EXEMPT_FLAG PA_PLSQL_DATATYPES.Char1TabTyp;
68: I_TAX_EXEMPT_REASON_CODE PA_PLSQL_DATATYPES.Char80TabTyp;
69: I_OUTPUT_TAX_EXEMPT_NUMBER PA_PLSQL_DATATYPES.Char30TabTyp;
70: I_PROJACCT_CURRENCY_CODE PA_PLSQL_DATATYPES.Char30TabTyp;
63: I_ACCT_EXCHANGE_RATE PA_PLSQL_DATATYPES.Char30TabTyp;
64: I_REV_CODE_COMBINATION_ID PA_PLSQL_DATATYPES.IdTabTyp;
65: I_OUTPUT_VAT_TAX_ID PA_PLSQL_DATATYPES.IdTabTyp;
66: I_OUTPUT_TAX_CODE PA_PLSQL_DATATYPES.Char30TabTyp;
67: I_OUTPUT_TAX_EXEMPT_FLAG PA_PLSQL_DATATYPES.Char1TabTyp;
68: I_TAX_EXEMPT_REASON_CODE PA_PLSQL_DATATYPES.Char80TabTyp;
69: I_OUTPUT_TAX_EXEMPT_NUMBER PA_PLSQL_DATATYPES.Char30TabTyp;
70: I_PROJACCT_CURRENCY_CODE PA_PLSQL_DATATYPES.Char30TabTyp;
71: I_MARKUP_CALC_BASE_CODE PA_PLSQL_DATATYPES.Char1TabTyp;
64: I_REV_CODE_COMBINATION_ID PA_PLSQL_DATATYPES.IdTabTyp;
65: I_OUTPUT_VAT_TAX_ID PA_PLSQL_DATATYPES.IdTabTyp;
66: I_OUTPUT_TAX_CODE PA_PLSQL_DATATYPES.Char30TabTyp;
67: I_OUTPUT_TAX_EXEMPT_FLAG PA_PLSQL_DATATYPES.Char1TabTyp;
68: I_TAX_EXEMPT_REASON_CODE PA_PLSQL_DATATYPES.Char80TabTyp;
69: I_OUTPUT_TAX_EXEMPT_NUMBER PA_PLSQL_DATATYPES.Char30TabTyp;
70: I_PROJACCT_CURRENCY_CODE PA_PLSQL_DATATYPES.Char30TabTyp;
71: I_MARKUP_CALC_BASE_CODE PA_PLSQL_DATATYPES.Char1TabTyp;
72: I_IND_COMPILED_SET_ID PA_PLSQL_DATATYPES.IdTabTyp;
65: I_OUTPUT_VAT_TAX_ID PA_PLSQL_DATATYPES.IdTabTyp;
66: I_OUTPUT_TAX_CODE PA_PLSQL_DATATYPES.Char30TabTyp;
67: I_OUTPUT_TAX_EXEMPT_FLAG PA_PLSQL_DATATYPES.Char1TabTyp;
68: I_TAX_EXEMPT_REASON_CODE PA_PLSQL_DATATYPES.Char80TabTyp;
69: I_OUTPUT_TAX_EXEMPT_NUMBER PA_PLSQL_DATATYPES.Char30TabTyp;
70: I_PROJACCT_CURRENCY_CODE PA_PLSQL_DATATYPES.Char30TabTyp;
71: I_MARKUP_CALC_BASE_CODE PA_PLSQL_DATATYPES.Char1TabTyp;
72: I_IND_COMPILED_SET_ID PA_PLSQL_DATATYPES.IdTabTyp;
73: I_RULE_PERCENTAGE PA_PLSQL_DATATYPES.Char30TabTyp;
66: I_OUTPUT_TAX_CODE PA_PLSQL_DATATYPES.Char30TabTyp;
67: I_OUTPUT_TAX_EXEMPT_FLAG PA_PLSQL_DATATYPES.Char1TabTyp;
68: I_TAX_EXEMPT_REASON_CODE PA_PLSQL_DATATYPES.Char80TabTyp;
69: I_OUTPUT_TAX_EXEMPT_NUMBER PA_PLSQL_DATATYPES.Char30TabTyp;
70: I_PROJACCT_CURRENCY_CODE PA_PLSQL_DATATYPES.Char30TabTyp;
71: I_MARKUP_CALC_BASE_CODE PA_PLSQL_DATATYPES.Char1TabTyp;
72: I_IND_COMPILED_SET_ID PA_PLSQL_DATATYPES.IdTabTyp;
73: I_RULE_PERCENTAGE PA_PLSQL_DATATYPES.Char30TabTyp;
74: I_BILL_RATE PA_PLSQL_DATATYPES.Char30TabTyp;
67: I_OUTPUT_TAX_EXEMPT_FLAG PA_PLSQL_DATATYPES.Char1TabTyp;
68: I_TAX_EXEMPT_REASON_CODE PA_PLSQL_DATATYPES.Char80TabTyp;
69: I_OUTPUT_TAX_EXEMPT_NUMBER PA_PLSQL_DATATYPES.Char30TabTyp;
70: I_PROJACCT_CURRENCY_CODE PA_PLSQL_DATATYPES.Char30TabTyp;
71: I_MARKUP_CALC_BASE_CODE PA_PLSQL_DATATYPES.Char1TabTyp;
72: I_IND_COMPILED_SET_ID PA_PLSQL_DATATYPES.IdTabTyp;
73: I_RULE_PERCENTAGE PA_PLSQL_DATATYPES.Char30TabTyp;
74: I_BILL_RATE PA_PLSQL_DATATYPES.Char30TabTyp;
75: I_BILL_MARKUP_PERCENTAGE PA_PLSQL_DATATYPES.Char30TabTyp;
68: I_TAX_EXEMPT_REASON_CODE PA_PLSQL_DATATYPES.Char80TabTyp;
69: I_OUTPUT_TAX_EXEMPT_NUMBER PA_PLSQL_DATATYPES.Char30TabTyp;
70: I_PROJACCT_CURRENCY_CODE PA_PLSQL_DATATYPES.Char30TabTyp;
71: I_MARKUP_CALC_BASE_CODE PA_PLSQL_DATATYPES.Char1TabTyp;
72: I_IND_COMPILED_SET_ID PA_PLSQL_DATATYPES.IdTabTyp;
73: I_RULE_PERCENTAGE PA_PLSQL_DATATYPES.Char30TabTyp;
74: I_BILL_RATE PA_PLSQL_DATATYPES.Char30TabTyp;
75: I_BILL_MARKUP_PERCENTAGE PA_PLSQL_DATATYPES.Char30TabTyp;
76: I_BASE_AMOUNT PA_PLSQL_DATATYPES.Char30TabTyp;
69: I_OUTPUT_TAX_EXEMPT_NUMBER PA_PLSQL_DATATYPES.Char30TabTyp;
70: I_PROJACCT_CURRENCY_CODE PA_PLSQL_DATATYPES.Char30TabTyp;
71: I_MARKUP_CALC_BASE_CODE PA_PLSQL_DATATYPES.Char1TabTyp;
72: I_IND_COMPILED_SET_ID PA_PLSQL_DATATYPES.IdTabTyp;
73: I_RULE_PERCENTAGE PA_PLSQL_DATATYPES.Char30TabTyp;
74: I_BILL_RATE PA_PLSQL_DATATYPES.Char30TabTyp;
75: I_BILL_MARKUP_PERCENTAGE PA_PLSQL_DATATYPES.Char30TabTyp;
76: I_BASE_AMOUNT PA_PLSQL_DATATYPES.Char30TabTyp;
77: I_SCHEDULE_LINE_PERCENTAGE PA_PLSQL_DATATYPES.Char30TabTyp;
70: I_PROJACCT_CURRENCY_CODE PA_PLSQL_DATATYPES.Char30TabTyp;
71: I_MARKUP_CALC_BASE_CODE PA_PLSQL_DATATYPES.Char1TabTyp;
72: I_IND_COMPILED_SET_ID PA_PLSQL_DATATYPES.IdTabTyp;
73: I_RULE_PERCENTAGE PA_PLSQL_DATATYPES.Char30TabTyp;
74: I_BILL_RATE PA_PLSQL_DATATYPES.Char30TabTyp;
75: I_BILL_MARKUP_PERCENTAGE PA_PLSQL_DATATYPES.Char30TabTyp;
76: I_BASE_AMOUNT PA_PLSQL_DATATYPES.Char30TabTyp;
77: I_SCHEDULE_LINE_PERCENTAGE PA_PLSQL_DATATYPES.Char30TabTyp;
78: I_MRC_REQD_FLAG PA_PLSQL_DATATYPES.Char1TabTyp;
71: I_MARKUP_CALC_BASE_CODE PA_PLSQL_DATATYPES.Char1TabTyp;
72: I_IND_COMPILED_SET_ID PA_PLSQL_DATATYPES.IdTabTyp;
73: I_RULE_PERCENTAGE PA_PLSQL_DATATYPES.Char30TabTyp;
74: I_BILL_RATE PA_PLSQL_DATATYPES.Char30TabTyp;
75: I_BILL_MARKUP_PERCENTAGE PA_PLSQL_DATATYPES.Char30TabTyp;
76: I_BASE_AMOUNT PA_PLSQL_DATATYPES.Char30TabTyp;
77: I_SCHEDULE_LINE_PERCENTAGE PA_PLSQL_DATATYPES.Char30TabTyp;
78: I_MRC_REQD_FLAG PA_PLSQL_DATATYPES.Char1TabTyp;
79:
72: I_IND_COMPILED_SET_ID PA_PLSQL_DATATYPES.IdTabTyp;
73: I_RULE_PERCENTAGE PA_PLSQL_DATATYPES.Char30TabTyp;
74: I_BILL_RATE PA_PLSQL_DATATYPES.Char30TabTyp;
75: I_BILL_MARKUP_PERCENTAGE PA_PLSQL_DATATYPES.Char30TabTyp;
76: I_BASE_AMOUNT PA_PLSQL_DATATYPES.Char30TabTyp;
77: I_SCHEDULE_LINE_PERCENTAGE PA_PLSQL_DATATYPES.Char30TabTyp;
78: I_MRC_REQD_FLAG PA_PLSQL_DATATYPES.Char1TabTyp;
79:
80: -- Provider reclass enabled or not
73: I_RULE_PERCENTAGE PA_PLSQL_DATATYPES.Char30TabTyp;
74: I_BILL_RATE PA_PLSQL_DATATYPES.Char30TabTyp;
75: I_BILL_MARKUP_PERCENTAGE PA_PLSQL_DATATYPES.Char30TabTyp;
76: I_BASE_AMOUNT PA_PLSQL_DATATYPES.Char30TabTyp;
77: I_SCHEDULE_LINE_PERCENTAGE PA_PLSQL_DATATYPES.Char30TabTyp;
78: I_MRC_REQD_FLAG PA_PLSQL_DATATYPES.Char1TabTyp;
79:
80: -- Provider reclass enabled or not
81: I_PRV_ENABLED PA_PLSQL_DATATYPES.Char1TabTyp;
74: I_BILL_RATE PA_PLSQL_DATATYPES.Char30TabTyp;
75: I_BILL_MARKUP_PERCENTAGE PA_PLSQL_DATATYPES.Char30TabTyp;
76: I_BASE_AMOUNT PA_PLSQL_DATATYPES.Char30TabTyp;
77: I_SCHEDULE_LINE_PERCENTAGE PA_PLSQL_DATATYPES.Char30TabTyp;
78: I_MRC_REQD_FLAG PA_PLSQL_DATATYPES.Char1TabTyp;
79:
80: -- Provider reclass enabled or not
81: I_PRV_ENABLED PA_PLSQL_DATATYPES.Char1TabTyp;
82: I_EXP_ITEM_USED PA_PLSQL_DATATYPES.Char1TabTyp;
77: I_SCHEDULE_LINE_PERCENTAGE PA_PLSQL_DATATYPES.Char30TabTyp;
78: I_MRC_REQD_FLAG PA_PLSQL_DATATYPES.Char1TabTyp;
79:
80: -- Provider reclass enabled or not
81: I_PRV_ENABLED PA_PLSQL_DATATYPES.Char1TabTyp;
82: I_EXP_ITEM_USED PA_PLSQL_DATATYPES.Char1TabTyp;
83:
84: /* Added for cross proj*/
85: I_TP_AMT_TYPE_CODE PA_PLSQL_DATATYPES.Char30TabTyp;
78: I_MRC_REQD_FLAG PA_PLSQL_DATATYPES.Char1TabTyp;
79:
80: -- Provider reclass enabled or not
81: I_PRV_ENABLED PA_PLSQL_DATATYPES.Char1TabTyp;
82: I_EXP_ITEM_USED PA_PLSQL_DATATYPES.Char1TabTyp;
83:
84: /* Added for cross proj*/
85: I_TP_AMT_TYPE_CODE PA_PLSQL_DATATYPES.Char30TabTyp;
86: I_PROJECT_TP_RATE_TYPE PA_PLSQL_DATATYPES.char30tabtyp;
81: I_PRV_ENABLED PA_PLSQL_DATATYPES.Char1TabTyp;
82: I_EXP_ITEM_USED PA_PLSQL_DATATYPES.Char1TabTyp;
83:
84: /* Added for cross proj*/
85: I_TP_AMT_TYPE_CODE PA_PLSQL_DATATYPES.Char30TabTyp;
86: I_PROJECT_TP_RATE_TYPE PA_PLSQL_DATATYPES.char30tabtyp;
87: I_PROJECT_TP_RATE_DATE PA_PLSQL_DATATYPES.char30tabtyp;
88: I_PROJECT_TP_EXCHANGE_RATE PA_PLSQL_DATATYPES.char30tabtyp;
89: I_PROJECT_TRANSFER_PRICE PA_PLSQL_DATATYPES.char30tabtyp;
82: I_EXP_ITEM_USED PA_PLSQL_DATATYPES.Char1TabTyp;
83:
84: /* Added for cross proj*/
85: I_TP_AMT_TYPE_CODE PA_PLSQL_DATATYPES.Char30TabTyp;
86: I_PROJECT_TP_RATE_TYPE PA_PLSQL_DATATYPES.char30tabtyp;
87: I_PROJECT_TP_RATE_DATE PA_PLSQL_DATATYPES.char30tabtyp;
88: I_PROJECT_TP_EXCHANGE_RATE PA_PLSQL_DATATYPES.char30tabtyp;
89: I_PROJECT_TRANSFER_PRICE PA_PLSQL_DATATYPES.char30tabtyp;
90: I_PROJFUNC_TP_RATE_TYPE PA_PLSQL_DATATYPES.char30tabtyp;
83:
84: /* Added for cross proj*/
85: I_TP_AMT_TYPE_CODE PA_PLSQL_DATATYPES.Char30TabTyp;
86: I_PROJECT_TP_RATE_TYPE PA_PLSQL_DATATYPES.char30tabtyp;
87: I_PROJECT_TP_RATE_DATE PA_PLSQL_DATATYPES.char30tabtyp;
88: I_PROJECT_TP_EXCHANGE_RATE PA_PLSQL_DATATYPES.char30tabtyp;
89: I_PROJECT_TRANSFER_PRICE PA_PLSQL_DATATYPES.char30tabtyp;
90: I_PROJFUNC_TP_RATE_TYPE PA_PLSQL_DATATYPES.char30tabtyp;
91: I_PROJFUNC_TP_RATE_DATE PA_PLSQL_DATATYPES.char30tabtyp;
84: /* Added for cross proj*/
85: I_TP_AMT_TYPE_CODE PA_PLSQL_DATATYPES.Char30TabTyp;
86: I_PROJECT_TP_RATE_TYPE PA_PLSQL_DATATYPES.char30tabtyp;
87: I_PROJECT_TP_RATE_DATE PA_PLSQL_DATATYPES.char30tabtyp;
88: I_PROJECT_TP_EXCHANGE_RATE PA_PLSQL_DATATYPES.char30tabtyp;
89: I_PROJECT_TRANSFER_PRICE PA_PLSQL_DATATYPES.char30tabtyp;
90: I_PROJFUNC_TP_RATE_TYPE PA_PLSQL_DATATYPES.char30tabtyp;
91: I_PROJFUNC_TP_RATE_DATE PA_PLSQL_DATATYPES.char30tabtyp;
92: I_PROJFUNC_TP_EXCHANGE_RATE PA_PLSQL_DATATYPES.char30tabtyp;
85: I_TP_AMT_TYPE_CODE PA_PLSQL_DATATYPES.Char30TabTyp;
86: I_PROJECT_TP_RATE_TYPE PA_PLSQL_DATATYPES.char30tabtyp;
87: I_PROJECT_TP_RATE_DATE PA_PLSQL_DATATYPES.char30tabtyp;
88: I_PROJECT_TP_EXCHANGE_RATE PA_PLSQL_DATATYPES.char30tabtyp;
89: I_PROJECT_TRANSFER_PRICE PA_PLSQL_DATATYPES.char30tabtyp;
90: I_PROJFUNC_TP_RATE_TYPE PA_PLSQL_DATATYPES.char30tabtyp;
91: I_PROJFUNC_TP_RATE_DATE PA_PLSQL_DATATYPES.char30tabtyp;
92: I_PROJFUNC_TP_EXCHANGE_RATE PA_PLSQL_DATATYPES.char30tabtyp;
93: I_PROJFUNC_TRANSFER_PRICE PA_PLSQL_DATATYPES.char30tabtyp;
86: I_PROJECT_TP_RATE_TYPE PA_PLSQL_DATATYPES.char30tabtyp;
87: I_PROJECT_TP_RATE_DATE PA_PLSQL_DATATYPES.char30tabtyp;
88: I_PROJECT_TP_EXCHANGE_RATE PA_PLSQL_DATATYPES.char30tabtyp;
89: I_PROJECT_TRANSFER_PRICE PA_PLSQL_DATATYPES.char30tabtyp;
90: I_PROJFUNC_TP_RATE_TYPE PA_PLSQL_DATATYPES.char30tabtyp;
91: I_PROJFUNC_TP_RATE_DATE PA_PLSQL_DATATYPES.char30tabtyp;
92: I_PROJFUNC_TP_EXCHANGE_RATE PA_PLSQL_DATATYPES.char30tabtyp;
93: I_PROJFUNC_TRANSFER_PRICE PA_PLSQL_DATATYPES.char30tabtyp;
94:
87: I_PROJECT_TP_RATE_DATE PA_PLSQL_DATATYPES.char30tabtyp;
88: I_PROJECT_TP_EXCHANGE_RATE PA_PLSQL_DATATYPES.char30tabtyp;
89: I_PROJECT_TRANSFER_PRICE PA_PLSQL_DATATYPES.char30tabtyp;
90: I_PROJFUNC_TP_RATE_TYPE PA_PLSQL_DATATYPES.char30tabtyp;
91: I_PROJFUNC_TP_RATE_DATE PA_PLSQL_DATATYPES.char30tabtyp;
92: I_PROJFUNC_TP_EXCHANGE_RATE PA_PLSQL_DATATYPES.char30tabtyp;
93: I_PROJFUNC_TRANSFER_PRICE PA_PLSQL_DATATYPES.char30tabtyp;
94:
95: I_PROJECT_TP_CURRENCY_CODE PA_PLSQL_DATATYPES.char15tabtyp;
88: I_PROJECT_TP_EXCHANGE_RATE PA_PLSQL_DATATYPES.char30tabtyp;
89: I_PROJECT_TRANSFER_PRICE PA_PLSQL_DATATYPES.char30tabtyp;
90: I_PROJFUNC_TP_RATE_TYPE PA_PLSQL_DATATYPES.char30tabtyp;
91: I_PROJFUNC_TP_RATE_DATE PA_PLSQL_DATATYPES.char30tabtyp;
92: I_PROJFUNC_TP_EXCHANGE_RATE PA_PLSQL_DATATYPES.char30tabtyp;
93: I_PROJFUNC_TRANSFER_PRICE PA_PLSQL_DATATYPES.char30tabtyp;
94:
95: I_PROJECT_TP_CURRENCY_CODE PA_PLSQL_DATATYPES.char15tabtyp;
96: I_PROJFUNC_TP_CURRENCY_CODE PA_PLSQL_DATATYPES.char15tabtyp;
89: I_PROJECT_TRANSFER_PRICE PA_PLSQL_DATATYPES.char30tabtyp;
90: I_PROJFUNC_TP_RATE_TYPE PA_PLSQL_DATATYPES.char30tabtyp;
91: I_PROJFUNC_TP_RATE_DATE PA_PLSQL_DATATYPES.char30tabtyp;
92: I_PROJFUNC_TP_EXCHANGE_RATE PA_PLSQL_DATATYPES.char30tabtyp;
93: I_PROJFUNC_TRANSFER_PRICE PA_PLSQL_DATATYPES.char30tabtyp;
94:
95: I_PROJECT_TP_CURRENCY_CODE PA_PLSQL_DATATYPES.char15tabtyp;
96: I_PROJFUNC_TP_CURRENCY_CODE PA_PLSQL_DATATYPES.char15tabtyp;
97: /*End for cross proj*
91: I_PROJFUNC_TP_RATE_DATE PA_PLSQL_DATATYPES.char30tabtyp;
92: I_PROJFUNC_TP_EXCHANGE_RATE PA_PLSQL_DATATYPES.char30tabtyp;
93: I_PROJFUNC_TRANSFER_PRICE PA_PLSQL_DATATYPES.char30tabtyp;
94:
95: I_PROJECT_TP_CURRENCY_CODE PA_PLSQL_DATATYPES.char15tabtyp;
96: I_PROJFUNC_TP_CURRENCY_CODE PA_PLSQL_DATATYPES.char15tabtyp;
97: /*End for cross proj*
98:
99:
92: I_PROJFUNC_TP_EXCHANGE_RATE PA_PLSQL_DATATYPES.char30tabtyp;
93: I_PROJFUNC_TRANSFER_PRICE PA_PLSQL_DATATYPES.char30tabtyp;
94:
95: I_PROJECT_TP_CURRENCY_CODE PA_PLSQL_DATATYPES.char15tabtyp;
96: I_PROJFUNC_TP_CURRENCY_CODE PA_PLSQL_DATATYPES.char15tabtyp;
97: /*End for cross proj*
98:
99:
100: /* CBGA and project Jobs */
98:
99:
100: /* CBGA and project Jobs */
101:
102: I_tp_job_id PA_PLSQL_DATATYPES.IdTabTyp;
103: I_prov_proj_bill_job_id PA_PLSQL_DATATYPES.IdTabTyp;
104:
105: /* Added for bug 3857986 -- The following variables are used during call to get_period_information. */
106:
99:
100: /* CBGA and project Jobs */
101:
102: I_tp_job_id PA_PLSQL_DATATYPES.IdTabTyp;
103: I_prov_proj_bill_job_id PA_PLSQL_DATATYPES.IdTabTyp;
104:
105: /* Added for bug 3857986 -- The following variables are used during call to get_period_information. */
106:
107: l_return_status NUMBER;
1127: END read_orig;
1128:
1129: -- Upadate the rejection reason code of EI
1130: PROCEDURE update_rejection_reason ( P_Error_code
1131: IN PA_PLSQL_DATATYPES.Char30TabTyp,
1132: P_Exp_Id IN PA_PLSQL_DATATYPES.IdTabTyp,
1133: P_No_of_records IN number )
1134: IS
1135: BEGIN
1128:
1129: -- Upadate the rejection reason code of EI
1130: PROCEDURE update_rejection_reason ( P_Error_code
1131: IN PA_PLSQL_DATATYPES.Char30TabTyp,
1132: P_Exp_Id IN PA_PLSQL_DATATYPES.IdTabTyp,
1133: P_No_of_records IN number )
1134: IS
1135: BEGIN
1136: IF g1_debug_mode = 'Y' THEN
1147: Raise;
1148: END update_rejection_reason;
1149:
1150: -- Apply all pending DB changes in Bulk
1151: PROCEDURE apply_db_changes (P_Error_code IN PA_PLSQL_DATATYPES.Char30TabTyp,
1152: P_Exp_Id IN PA_PLSQL_DATATYPES.IdTabTyp,
1153: P_no_of_records IN Number )
1154: IS
1155: BEGIN
1148: END update_rejection_reason;
1149:
1150: -- Apply all pending DB changes in Bulk
1151: PROCEDURE apply_db_changes (P_Error_code IN PA_PLSQL_DATATYPES.Char30TabTyp,
1152: P_Exp_Id IN PA_PLSQL_DATATYPES.IdTabTyp,
1153: P_no_of_records IN Number )
1154: IS
1155: BEGIN
1156:
1196: P_Bill_to_site_use_id IN number,
1197: P_Ship_to_site_use_id IN number ,
1198: P_Set_of_books_id IN number ,
1199: P_Acct_curr_code IN varchar2,
1200: P_Expenditure_category IN PA_PLSQL_DATATYPES.Char30TabTyp,
1201: P_CC_Project_Id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1202: P_CC_Tax_task_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1203: P_EI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1204: P_AdjEI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1197: P_Ship_to_site_use_id IN number ,
1198: P_Set_of_books_id IN number ,
1199: P_Acct_curr_code IN varchar2,
1200: P_Expenditure_category IN PA_PLSQL_DATATYPES.Char30TabTyp,
1201: P_CC_Project_Id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1202: P_CC_Tax_task_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1203: P_EI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1204: P_AdjEI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1205: P_Net_zero_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1198: P_Set_of_books_id IN number ,
1199: P_Acct_curr_code IN varchar2,
1200: P_Expenditure_category IN PA_PLSQL_DATATYPES.Char30TabTyp,
1201: P_CC_Project_Id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1202: P_CC_Tax_task_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1203: P_EI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1204: P_AdjEI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1205: P_Net_zero_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1206: P_TP_sch_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1199: P_Acct_curr_code IN varchar2,
1200: P_Expenditure_category IN PA_PLSQL_DATATYPES.Char30TabTyp,
1201: P_CC_Project_Id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1202: P_CC_Tax_task_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1203: P_EI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1204: P_AdjEI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1205: P_Net_zero_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1206: P_TP_sch_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1207: P_revenue_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
1200: P_Expenditure_category IN PA_PLSQL_DATATYPES.Char30TabTyp,
1201: P_CC_Project_Id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1202: P_CC_Tax_task_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1203: P_EI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1204: P_AdjEI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1205: P_Net_zero_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1206: P_TP_sch_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1207: P_revenue_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
1208: P_provider_cr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
1201: P_CC_Project_Id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1202: P_CC_Tax_task_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1203: P_EI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1204: P_AdjEI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1205: P_Net_zero_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1206: P_TP_sch_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1207: P_revenue_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
1208: P_provider_cr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
1209: P_provider_dr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
1202: P_CC_Tax_task_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1203: P_EI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1204: P_AdjEI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1205: P_Net_zero_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1206: P_TP_sch_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1207: P_revenue_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
1208: P_provider_cr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
1209: P_provider_dr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
1210: P_Task_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1203: P_EI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1204: P_AdjEI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1205: P_Net_zero_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1206: P_TP_sch_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1207: P_revenue_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
1208: P_provider_cr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
1209: P_provider_dr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
1210: P_Task_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1211: P_Cross_charge_code IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1204: P_AdjEI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1205: P_Net_zero_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1206: P_TP_sch_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1207: P_revenue_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
1208: P_provider_cr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
1209: P_provider_dr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
1210: P_Task_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1211: P_Cross_charge_code IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1212: P_Labor_nl_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1205: P_Net_zero_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1206: P_TP_sch_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1207: P_revenue_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
1208: P_provider_cr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
1209: P_provider_dr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
1210: P_Task_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1211: P_Cross_charge_code IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1212: P_Labor_nl_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1213: P_Revenue_distributed_flag
1206: P_TP_sch_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1207: P_revenue_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
1208: P_provider_cr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
1209: P_provider_dr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
1210: P_Task_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1211: P_Cross_charge_code IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1212: P_Labor_nl_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1213: P_Revenue_distributed_flag
1214: IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1207: P_revenue_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
1208: P_provider_cr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
1209: P_provider_dr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
1210: P_Task_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1211: P_Cross_charge_code IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1212: P_Labor_nl_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1213: P_Revenue_distributed_flag
1214: IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1215: P_Expend_type IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1208: P_provider_cr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
1209: P_provider_dr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
1210: P_Task_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1211: P_Cross_charge_code IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1212: P_Labor_nl_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1213: P_Revenue_distributed_flag
1214: IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1215: P_Expend_type IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1216: P_EI_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1210: P_Task_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1211: P_Cross_charge_code IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1212: P_Labor_nl_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1213: P_Revenue_distributed_flag
1214: IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1215: P_Expend_type IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1216: P_EI_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1217: P_Sys_linkage IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1218: P_Denom_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
1211: P_Cross_charge_code IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1212: P_Labor_nl_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1213: P_Revenue_distributed_flag
1214: IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1215: P_Expend_type IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1216: P_EI_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1217: P_Sys_linkage IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1218: P_Denom_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
1219: P_Prj_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
1212: P_Labor_nl_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1213: P_Revenue_distributed_flag
1214: IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1215: P_Expend_type IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1216: P_EI_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1217: P_Sys_linkage IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1218: P_Denom_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
1219: P_Prj_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
1220: P_TP_fixed_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1213: P_Revenue_distributed_flag
1214: IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1215: P_Expend_type IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1216: P_EI_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1217: P_Sys_linkage IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1218: P_Denom_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
1219: P_Prj_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
1220: P_TP_fixed_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1221: P_Denom_raw_cost_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1214: IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1215: P_Expend_type IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1216: P_EI_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1217: P_Sys_linkage IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1218: P_Denom_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
1219: P_Prj_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
1220: P_TP_fixed_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1221: P_Denom_raw_cost_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1222: P_Denom_burdened_cost_amt
1215: P_Expend_type IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1216: P_EI_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1217: P_Sys_linkage IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1218: P_Denom_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
1219: P_Prj_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
1220: P_TP_fixed_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1221: P_Denom_raw_cost_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1222: P_Denom_burdened_cost_amt
1223: IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1216: P_EI_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1217: P_Sys_linkage IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1218: P_Denom_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
1219: P_Prj_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
1220: P_TP_fixed_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1221: P_Denom_raw_cost_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1222: P_Denom_burdened_cost_amt
1223: IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1224: P_Raw_revenue_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1217: P_Sys_linkage IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1218: P_Denom_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
1219: P_Prj_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
1220: P_TP_fixed_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1221: P_Denom_raw_cost_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1222: P_Denom_burdened_cost_amt
1223: IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1224: P_Raw_revenue_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1225: P_Quantity IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1219: P_Prj_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
1220: P_TP_fixed_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1221: P_Denom_raw_cost_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1222: P_Denom_burdened_cost_amt
1223: IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1224: P_Raw_revenue_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1225: P_Quantity IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1226: P_Non_labor_resource IN PA_PLSQL_DATATYPES.Char20TabTyp ,
1227: P_Prvdr_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
1220: P_TP_fixed_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1221: P_Denom_raw_cost_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1222: P_Denom_burdened_cost_amt
1223: IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1224: P_Raw_revenue_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1225: P_Quantity IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1226: P_Non_labor_resource IN PA_PLSQL_DATATYPES.Char20TabTyp ,
1227: P_Prvdr_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
1228: P_Recvr_org_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1221: P_Denom_raw_cost_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1222: P_Denom_burdened_cost_amt
1223: IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1224: P_Raw_revenue_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1225: P_Quantity IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1226: P_Non_labor_resource IN PA_PLSQL_DATATYPES.Char20TabTyp ,
1227: P_Prvdr_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
1228: P_Recvr_org_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1229: P_Recvr_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
1222: P_Denom_burdened_cost_amt
1223: IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1224: P_Raw_revenue_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1225: P_Quantity IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1226: P_Non_labor_resource IN PA_PLSQL_DATATYPES.Char20TabTyp ,
1227: P_Prvdr_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
1228: P_Recvr_org_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1229: P_Recvr_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
1230: P_Expnd_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
1223: IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1224: P_Raw_revenue_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1225: P_Quantity IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1226: P_Non_labor_resource IN PA_PLSQL_DATATYPES.Char20TabTyp ,
1227: P_Prvdr_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
1228: P_Recvr_org_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1229: P_Recvr_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
1230: P_Expnd_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
1231: P_NL_resource_organization
1224: P_Raw_revenue_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1225: P_Quantity IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1226: P_Non_labor_resource IN PA_PLSQL_DATATYPES.Char20TabTyp ,
1227: P_Prvdr_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
1228: P_Recvr_org_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1229: P_Recvr_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
1230: P_Expnd_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
1231: P_NL_resource_organization
1232: IN PA_PLSQL_DATATYPES.IdTabTyp ,
1225: P_Quantity IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1226: P_Non_labor_resource IN PA_PLSQL_DATATYPES.Char20TabTyp ,
1227: P_Prvdr_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
1228: P_Recvr_org_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1229: P_Recvr_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
1230: P_Expnd_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
1231: P_NL_resource_organization
1232: IN PA_PLSQL_DATATYPES.IdTabTyp ,
1233: P_Incurred_by_person_id
1226: P_Non_labor_resource IN PA_PLSQL_DATATYPES.Char20TabTyp ,
1227: P_Prvdr_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
1228: P_Recvr_org_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1229: P_Recvr_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
1230: P_Expnd_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
1231: P_NL_resource_organization
1232: IN PA_PLSQL_DATATYPES.IdTabTyp ,
1233: P_Incurred_by_person_id
1234: IN PA_PLSQL_DATATYPES.IdTabTyp ,
1228: P_Recvr_org_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1229: P_Recvr_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
1230: P_Expnd_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
1231: P_NL_resource_organization
1232: IN PA_PLSQL_DATATYPES.IdTabTyp ,
1233: P_Incurred_by_person_id
1234: IN PA_PLSQL_DATATYPES.IdTabTyp ,
1235: P_Job_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1236: P_Denom_TP_currency_code
1230: P_Expnd_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
1231: P_NL_resource_organization
1232: IN PA_PLSQL_DATATYPES.IdTabTyp ,
1233: P_Incurred_by_person_id
1234: IN PA_PLSQL_DATATYPES.IdTabTyp ,
1235: P_Job_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1236: P_Denom_TP_currency_code
1237: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char15TabTyp ,
1238: P_Denom_transfer_price
1231: P_NL_resource_organization
1232: IN PA_PLSQL_DATATYPES.IdTabTyp ,
1233: P_Incurred_by_person_id
1234: IN PA_PLSQL_DATATYPES.IdTabTyp ,
1235: P_Job_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1236: P_Denom_TP_currency_code
1237: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char15TabTyp ,
1238: P_Denom_transfer_price
1239: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1233: P_Incurred_by_person_id
1234: IN PA_PLSQL_DATATYPES.IdTabTyp ,
1235: P_Job_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1236: P_Denom_TP_currency_code
1237: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char15TabTyp ,
1238: P_Denom_transfer_price
1239: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1240: P_Acct_TP_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1241: P_Acct_TP_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1235: P_Job_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1236: P_Denom_TP_currency_code
1237: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char15TabTyp ,
1238: P_Denom_transfer_price
1239: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1240: P_Acct_TP_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1241: P_Acct_TP_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1242: P_Acct_TP_exchange_rate
1243: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1236: P_Denom_TP_currency_code
1237: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char15TabTyp ,
1238: P_Denom_transfer_price
1239: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1240: P_Acct_TP_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1241: P_Acct_TP_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1242: P_Acct_TP_exchange_rate
1243: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1244: P_Acct_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1237: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char15TabTyp ,
1238: P_Denom_transfer_price
1239: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1240: P_Acct_TP_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1241: P_Acct_TP_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1242: P_Acct_TP_exchange_rate
1243: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1244: P_Acct_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1245: P_CC_markup_base_code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1239: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1240: P_Acct_TP_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1241: P_Acct_TP_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1242: P_Acct_TP_exchange_rate
1243: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1244: P_Acct_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1245: P_CC_markup_base_code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1246: P_TP_ind_compiled_set_id
1247: IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
1240: P_Acct_TP_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1241: P_Acct_TP_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1242: P_Acct_TP_exchange_rate
1243: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1244: P_Acct_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1245: P_CC_markup_base_code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1246: P_TP_ind_compiled_set_id
1247: IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
1248: P_TP_bill_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1241: P_Acct_TP_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1242: P_Acct_TP_exchange_rate
1243: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1244: P_Acct_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1245: P_CC_markup_base_code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1246: P_TP_ind_compiled_set_id
1247: IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
1248: P_TP_bill_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1249: P_TP_base_amt IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1243: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1244: P_Acct_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1245: P_CC_markup_base_code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1246: P_TP_ind_compiled_set_id
1247: IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
1248: P_TP_bill_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1249: P_TP_base_amt IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1250: P_TP_bill_markup_percentage
1251: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1244: P_Acct_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1245: P_CC_markup_base_code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1246: P_TP_ind_compiled_set_id
1247: IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
1248: P_TP_bill_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1249: P_TP_base_amt IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1250: P_TP_bill_markup_percentage
1251: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1252: P_TP_schedule_line_percentage
1245: P_CC_markup_base_code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1246: P_TP_ind_compiled_set_id
1247: IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
1248: P_TP_bill_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1249: P_TP_base_amt IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1250: P_TP_bill_markup_percentage
1251: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1252: P_TP_schedule_line_percentage
1253: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1247: IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
1248: P_TP_bill_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1249: P_TP_base_amt IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1250: P_TP_bill_markup_percentage
1251: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1252: P_TP_schedule_line_percentage
1253: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1254: P_TP_rule_percentage IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1255: P_burden_disp_method IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1249: P_TP_base_amt IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1250: P_TP_bill_markup_percentage
1251: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1252: P_TP_schedule_line_percentage
1253: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1254: P_TP_rule_percentage IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1255: P_burden_disp_method IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1256: P_ca_prov_code IN Varchar2,
1257: P_nca_prov_code IN Varchar2,
1250: P_TP_bill_markup_percentage
1251: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1252: P_TP_schedule_line_percentage
1253: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1254: P_TP_rule_percentage IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1255: P_burden_disp_method IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1256: P_ca_prov_code IN Varchar2,
1257: P_nca_prov_code IN Varchar2,
1258: P_Processed_thru_date IN Date ,
1251: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1252: P_TP_schedule_line_percentage
1253: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1254: P_TP_rule_percentage IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1255: P_burden_disp_method IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1256: P_ca_prov_code IN Varchar2,
1257: P_nca_prov_code IN Varchar2,
1258: P_Processed_thru_date IN Date ,
1259: P_No_of_records IN NUMBER ,
1258: P_Processed_thru_date IN Date ,
1259: P_No_of_records IN NUMBER ,
1260: P_User_Id IN NUMBER ,
1261: P_Request_id IN NUMBER ,
1262: P_Error_Code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
1263: P_tp_Job_id IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
1264: P_prov_proj_bill_job_id IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
1265: /*Added for cross proj*/
1266: P_tp_amt_type_code IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1259: P_No_of_records IN NUMBER ,
1260: P_User_Id IN NUMBER ,
1261: P_Request_id IN NUMBER ,
1262: P_Error_Code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
1263: P_tp_Job_id IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
1264: P_prov_proj_bill_job_id IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
1265: /*Added for cross proj*/
1266: P_tp_amt_type_code IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1267: P_projfunc_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
1260: P_User_Id IN NUMBER ,
1261: P_Request_id IN NUMBER ,
1262: P_Error_Code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
1263: P_tp_Job_id IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
1264: P_prov_proj_bill_job_id IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
1265: /*Added for cross proj*/
1266: P_tp_amt_type_code IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1267: P_projfunc_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
1268: P_project_tp_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1262: P_Error_Code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
1263: P_tp_Job_id IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
1264: P_prov_proj_bill_job_id IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
1265: /*Added for cross proj*/
1266: P_tp_amt_type_code IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1267: P_projfunc_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
1268: P_project_tp_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1269: P_project_tp_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1270: P_project_tp_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1263: P_tp_Job_id IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
1264: P_prov_proj_bill_job_id IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
1265: /*Added for cross proj*/
1266: P_tp_amt_type_code IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1267: P_projfunc_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
1268: P_project_tp_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1269: P_project_tp_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1270: P_project_tp_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1271: P_projfunc_tp_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1264: P_prov_proj_bill_job_id IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
1265: /*Added for cross proj*/
1266: P_tp_amt_type_code IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1267: P_projfunc_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
1268: P_project_tp_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1269: P_project_tp_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1270: P_project_tp_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1271: P_projfunc_tp_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1272: P_projfunc_tp_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1265: /*Added for cross proj*/
1266: P_tp_amt_type_code IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1267: P_projfunc_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
1268: P_project_tp_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1269: P_project_tp_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1270: P_project_tp_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1271: P_projfunc_tp_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1272: P_projfunc_tp_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1273: P_projfunc_tp_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1266: P_tp_amt_type_code IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1267: P_projfunc_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
1268: P_project_tp_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1269: P_project_tp_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1270: P_project_tp_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1271: P_projfunc_tp_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1272: P_projfunc_tp_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1273: P_projfunc_tp_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1274: P_assignment_id IN PA_PLSQL_DATATYPES.IdTabTyp,
1267: P_projfunc_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
1268: P_project_tp_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1269: P_project_tp_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1270: P_project_tp_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1271: P_projfunc_tp_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1272: P_projfunc_tp_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1273: P_projfunc_tp_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1274: P_assignment_id IN PA_PLSQL_DATATYPES.IdTabTyp,
1275: P_project_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1268: P_project_tp_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1269: P_project_tp_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1270: P_project_tp_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1271: P_projfunc_tp_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1272: P_projfunc_tp_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1273: P_projfunc_tp_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1274: P_assignment_id IN PA_PLSQL_DATATYPES.IdTabTyp,
1275: P_project_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1276: P_projfunc_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp
1269: P_project_tp_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1270: P_project_tp_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1271: P_projfunc_tp_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1272: P_projfunc_tp_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1273: P_projfunc_tp_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1274: P_assignment_id IN PA_PLSQL_DATATYPES.IdTabTyp,
1275: P_project_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1276: P_projfunc_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp
1277: /*End for cross proj*/
1270: P_project_tp_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1271: P_projfunc_tp_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1272: P_projfunc_tp_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1273: P_projfunc_tp_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1274: P_assignment_id IN PA_PLSQL_DATATYPES.IdTabTyp,
1275: P_project_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1276: P_projfunc_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp
1277: /*End for cross proj*/
1278: )
1271: P_projfunc_tp_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1272: P_projfunc_tp_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1273: P_projfunc_tp_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1274: P_assignment_id IN PA_PLSQL_DATATYPES.IdTabTyp,
1275: P_project_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1276: P_projfunc_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp
1277: /*End for cross proj*/
1278: )
1279: IS
1272: P_projfunc_tp_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1273: P_projfunc_tp_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1274: P_assignment_id IN PA_PLSQL_DATATYPES.IdTabTyp,
1275: P_project_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1276: P_projfunc_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp
1277: /*End for cross proj*/
1278: )
1279: IS
1280: BEGIN
1290: P_Bill_to_site_use_id IN number,
1291: P_Ship_to_site_use_id IN number ,
1292: P_Set_of_books_id IN number ,
1293: P_Acct_curr_code IN varchar2,
1294: P_Expenditure_category IN PA_PLSQL_DATATYPES.Char30TabTyp,
1295: P_CC_Project_Id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1296: P_CC_Tax_task_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1297: P_EI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1298: P_AdjEI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1291: P_Ship_to_site_use_id IN number ,
1292: P_Set_of_books_id IN number ,
1293: P_Acct_curr_code IN varchar2,
1294: P_Expenditure_category IN PA_PLSQL_DATATYPES.Char30TabTyp,
1295: P_CC_Project_Id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1296: P_CC_Tax_task_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1297: P_EI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1298: P_AdjEI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1299: P_Net_zero_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1292: P_Set_of_books_id IN number ,
1293: P_Acct_curr_code IN varchar2,
1294: P_Expenditure_category IN PA_PLSQL_DATATYPES.Char30TabTyp,
1295: P_CC_Project_Id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1296: P_CC_Tax_task_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1297: P_EI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1298: P_AdjEI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1299: P_Net_zero_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1300: P_TP_sch_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1293: P_Acct_curr_code IN varchar2,
1294: P_Expenditure_category IN PA_PLSQL_DATATYPES.Char30TabTyp,
1295: P_CC_Project_Id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1296: P_CC_Tax_task_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1297: P_EI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1298: P_AdjEI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1299: P_Net_zero_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1300: P_TP_sch_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1301: P_revenue_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
1294: P_Expenditure_category IN PA_PLSQL_DATATYPES.Char30TabTyp,
1295: P_CC_Project_Id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1296: P_CC_Tax_task_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1297: P_EI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1298: P_AdjEI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1299: P_Net_zero_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1300: P_TP_sch_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1301: P_revenue_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
1302: P_provider_cr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
1295: P_CC_Project_Id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1296: P_CC_Tax_task_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1297: P_EI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1298: P_AdjEI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1299: P_Net_zero_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1300: P_TP_sch_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1301: P_revenue_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
1302: P_provider_cr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
1303: P_provider_dr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
1296: P_CC_Tax_task_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1297: P_EI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1298: P_AdjEI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1299: P_Net_zero_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1300: P_TP_sch_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1301: P_revenue_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
1302: P_provider_cr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
1303: P_provider_dr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
1304: P_Task_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1297: P_EI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1298: P_AdjEI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1299: P_Net_zero_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1300: P_TP_sch_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1301: P_revenue_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
1302: P_provider_cr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
1303: P_provider_dr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
1304: P_Task_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1305: P_Cross_charge_code IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1298: P_AdjEI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1299: P_Net_zero_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1300: P_TP_sch_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1301: P_revenue_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
1302: P_provider_cr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
1303: P_provider_dr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
1304: P_Task_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1305: P_Cross_charge_code IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1306: P_Labor_nl_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1299: P_Net_zero_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1300: P_TP_sch_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1301: P_revenue_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
1302: P_provider_cr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
1303: P_provider_dr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
1304: P_Task_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1305: P_Cross_charge_code IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1306: P_Labor_nl_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1307: P_Revenue_distributed_flag
1300: P_TP_sch_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1301: P_revenue_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
1302: P_provider_cr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
1303: P_provider_dr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
1304: P_Task_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1305: P_Cross_charge_code IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1306: P_Labor_nl_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1307: P_Revenue_distributed_flag
1308: IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1301: P_revenue_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
1302: P_provider_cr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
1303: P_provider_dr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
1304: P_Task_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1305: P_Cross_charge_code IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1306: P_Labor_nl_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1307: P_Revenue_distributed_flag
1308: IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1309: P_Expend_type IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1302: P_provider_cr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
1303: P_provider_dr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
1304: P_Task_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1305: P_Cross_charge_code IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1306: P_Labor_nl_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1307: P_Revenue_distributed_flag
1308: IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1309: P_Expend_type IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1310: P_EI_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1304: P_Task_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1305: P_Cross_charge_code IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1306: P_Labor_nl_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1307: P_Revenue_distributed_flag
1308: IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1309: P_Expend_type IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1310: P_EI_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1311: P_Sys_linkage IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1312: P_Denom_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
1305: P_Cross_charge_code IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1306: P_Labor_nl_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1307: P_Revenue_distributed_flag
1308: IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1309: P_Expend_type IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1310: P_EI_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1311: P_Sys_linkage IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1312: P_Denom_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
1313: P_Prj_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
1306: P_Labor_nl_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1307: P_Revenue_distributed_flag
1308: IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1309: P_Expend_type IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1310: P_EI_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1311: P_Sys_linkage IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1312: P_Denom_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
1313: P_Prj_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
1314: P_TP_fixed_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1307: P_Revenue_distributed_flag
1308: IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1309: P_Expend_type IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1310: P_EI_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1311: P_Sys_linkage IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1312: P_Denom_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
1313: P_Prj_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
1314: P_TP_fixed_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1315: P_Denom_raw_cost_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1308: IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1309: P_Expend_type IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1310: P_EI_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1311: P_Sys_linkage IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1312: P_Denom_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
1313: P_Prj_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
1314: P_TP_fixed_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1315: P_Denom_raw_cost_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1316: P_Denom_burdened_cost_amt
1309: P_Expend_type IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1310: P_EI_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1311: P_Sys_linkage IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1312: P_Denom_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
1313: P_Prj_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
1314: P_TP_fixed_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1315: P_Denom_raw_cost_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1316: P_Denom_burdened_cost_amt
1317: IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1310: P_EI_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1311: P_Sys_linkage IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1312: P_Denom_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
1313: P_Prj_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
1314: P_TP_fixed_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1315: P_Denom_raw_cost_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1316: P_Denom_burdened_cost_amt
1317: IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1318: P_Raw_revenue_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1311: P_Sys_linkage IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1312: P_Denom_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
1313: P_Prj_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
1314: P_TP_fixed_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1315: P_Denom_raw_cost_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1316: P_Denom_burdened_cost_amt
1317: IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1318: P_Raw_revenue_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1319: P_Quantity IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1313: P_Prj_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
1314: P_TP_fixed_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1315: P_Denom_raw_cost_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1316: P_Denom_burdened_cost_amt
1317: IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1318: P_Raw_revenue_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1319: P_Quantity IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1320: P_Non_labor_resource IN PA_PLSQL_DATATYPES.Char20TabTyp ,
1321: P_Prvdr_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
1314: P_TP_fixed_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1315: P_Denom_raw_cost_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1316: P_Denom_burdened_cost_amt
1317: IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1318: P_Raw_revenue_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1319: P_Quantity IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1320: P_Non_labor_resource IN PA_PLSQL_DATATYPES.Char20TabTyp ,
1321: P_Prvdr_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
1322: P_Recvr_org_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1315: P_Denom_raw_cost_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1316: P_Denom_burdened_cost_amt
1317: IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1318: P_Raw_revenue_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1319: P_Quantity IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1320: P_Non_labor_resource IN PA_PLSQL_DATATYPES.Char20TabTyp ,
1321: P_Prvdr_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
1322: P_Recvr_org_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1323: P_Recvr_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
1316: P_Denom_burdened_cost_amt
1317: IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1318: P_Raw_revenue_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1319: P_Quantity IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1320: P_Non_labor_resource IN PA_PLSQL_DATATYPES.Char20TabTyp ,
1321: P_Prvdr_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
1322: P_Recvr_org_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1323: P_Recvr_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
1324: P_Expnd_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
1317: IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1318: P_Raw_revenue_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1319: P_Quantity IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1320: P_Non_labor_resource IN PA_PLSQL_DATATYPES.Char20TabTyp ,
1321: P_Prvdr_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
1322: P_Recvr_org_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1323: P_Recvr_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
1324: P_Expnd_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
1325: P_NL_resource_organization
1318: P_Raw_revenue_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1319: P_Quantity IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1320: P_Non_labor_resource IN PA_PLSQL_DATATYPES.Char20TabTyp ,
1321: P_Prvdr_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
1322: P_Recvr_org_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1323: P_Recvr_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
1324: P_Expnd_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
1325: P_NL_resource_organization
1326: IN PA_PLSQL_DATATYPES.IdTabTyp ,
1319: P_Quantity IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1320: P_Non_labor_resource IN PA_PLSQL_DATATYPES.Char20TabTyp ,
1321: P_Prvdr_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
1322: P_Recvr_org_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1323: P_Recvr_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
1324: P_Expnd_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
1325: P_NL_resource_organization
1326: IN PA_PLSQL_DATATYPES.IdTabTyp ,
1327: P_Incurred_by_person_id
1320: P_Non_labor_resource IN PA_PLSQL_DATATYPES.Char20TabTyp ,
1321: P_Prvdr_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
1322: P_Recvr_org_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1323: P_Recvr_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
1324: P_Expnd_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
1325: P_NL_resource_organization
1326: IN PA_PLSQL_DATATYPES.IdTabTyp ,
1327: P_Incurred_by_person_id
1328: IN PA_PLSQL_DATATYPES.IdTabTyp ,
1322: P_Recvr_org_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1323: P_Recvr_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
1324: P_Expnd_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
1325: P_NL_resource_organization
1326: IN PA_PLSQL_DATATYPES.IdTabTyp ,
1327: P_Incurred_by_person_id
1328: IN PA_PLSQL_DATATYPES.IdTabTyp ,
1329: P_Job_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1330: P_Denom_TP_currency_code
1324: P_Expnd_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
1325: P_NL_resource_organization
1326: IN PA_PLSQL_DATATYPES.IdTabTyp ,
1327: P_Incurred_by_person_id
1328: IN PA_PLSQL_DATATYPES.IdTabTyp ,
1329: P_Job_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1330: P_Denom_TP_currency_code
1331: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char15TabTyp ,
1332: P_Denom_transfer_price
1325: P_NL_resource_organization
1326: IN PA_PLSQL_DATATYPES.IdTabTyp ,
1327: P_Incurred_by_person_id
1328: IN PA_PLSQL_DATATYPES.IdTabTyp ,
1329: P_Job_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1330: P_Denom_TP_currency_code
1331: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char15TabTyp ,
1332: P_Denom_transfer_price
1333: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1327: P_Incurred_by_person_id
1328: IN PA_PLSQL_DATATYPES.IdTabTyp ,
1329: P_Job_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1330: P_Denom_TP_currency_code
1331: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char15TabTyp ,
1332: P_Denom_transfer_price
1333: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1334: P_Acct_TP_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1335: P_Acct_TP_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1329: P_Job_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1330: P_Denom_TP_currency_code
1331: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char15TabTyp ,
1332: P_Denom_transfer_price
1333: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1334: P_Acct_TP_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1335: P_Acct_TP_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1336: P_Acct_TP_exchange_rate
1337: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1330: P_Denom_TP_currency_code
1331: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char15TabTyp ,
1332: P_Denom_transfer_price
1333: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1334: P_Acct_TP_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1335: P_Acct_TP_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1336: P_Acct_TP_exchange_rate
1337: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1338: P_Acct_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1331: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char15TabTyp ,
1332: P_Denom_transfer_price
1333: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1334: P_Acct_TP_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1335: P_Acct_TP_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1336: P_Acct_TP_exchange_rate
1337: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1338: P_Acct_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1339: P_CC_markup_base_code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1333: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1334: P_Acct_TP_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1335: P_Acct_TP_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1336: P_Acct_TP_exchange_rate
1337: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1338: P_Acct_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1339: P_CC_markup_base_code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1340: P_TP_ind_compiled_set_id
1341: IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
1334: P_Acct_TP_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1335: P_Acct_TP_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1336: P_Acct_TP_exchange_rate
1337: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1338: P_Acct_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1339: P_CC_markup_base_code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1340: P_TP_ind_compiled_set_id
1341: IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
1342: P_TP_bill_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1335: P_Acct_TP_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1336: P_Acct_TP_exchange_rate
1337: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1338: P_Acct_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1339: P_CC_markup_base_code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1340: P_TP_ind_compiled_set_id
1341: IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
1342: P_TP_bill_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1343: P_TP_base_amt IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1337: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1338: P_Acct_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1339: P_CC_markup_base_code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1340: P_TP_ind_compiled_set_id
1341: IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
1342: P_TP_bill_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1343: P_TP_base_amt IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1344: P_TP_bill_markup_percentage
1345: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1338: P_Acct_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1339: P_CC_markup_base_code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1340: P_TP_ind_compiled_set_id
1341: IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
1342: P_TP_bill_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1343: P_TP_base_amt IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1344: P_TP_bill_markup_percentage
1345: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1346: P_TP_schedule_line_percentage
1339: P_CC_markup_base_code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1340: P_TP_ind_compiled_set_id
1341: IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
1342: P_TP_bill_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1343: P_TP_base_amt IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1344: P_TP_bill_markup_percentage
1345: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1346: P_TP_schedule_line_percentage
1347: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1341: IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
1342: P_TP_bill_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1343: P_TP_base_amt IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1344: P_TP_bill_markup_percentage
1345: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1346: P_TP_schedule_line_percentage
1347: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1348: P_TP_rule_percentage IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1349: P_burden_disp_method IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1343: P_TP_base_amt IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1344: P_TP_bill_markup_percentage
1345: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1346: P_TP_schedule_line_percentage
1347: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1348: P_TP_rule_percentage IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1349: P_burden_disp_method IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1350: P_ca_prov_code IN Varchar2,
1351: P_nca_prov_code IN Varchar2,
1344: P_TP_bill_markup_percentage
1345: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1346: P_TP_schedule_line_percentage
1347: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1348: P_TP_rule_percentage IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1349: P_burden_disp_method IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1350: P_ca_prov_code IN Varchar2,
1351: P_nca_prov_code IN Varchar2,
1352: P_Processed_thru_date IN Date ,
1345: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1346: P_TP_schedule_line_percentage
1347: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1348: P_TP_rule_percentage IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1349: P_burden_disp_method IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1350: P_ca_prov_code IN Varchar2,
1351: P_nca_prov_code IN Varchar2,
1352: P_Processed_thru_date IN Date ,
1353: P_No_of_records IN NUMBER ,
1352: P_Processed_thru_date IN Date ,
1353: P_No_of_records IN NUMBER ,
1354: P_User_Id IN NUMBER ,
1355: P_Request_id IN NUMBER ,
1356: P_Error_Code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
1357: P_tp_Job_id IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
1358: P_prov_proj_bill_job_id IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp)
1359: IS
1360: BEGIN
1353: P_No_of_records IN NUMBER ,
1354: P_User_Id IN NUMBER ,
1355: P_Request_id IN NUMBER ,
1356: P_Error_Code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
1357: P_tp_Job_id IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
1358: P_prov_proj_bill_job_id IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp)
1359: IS
1360: BEGIN
1361: null;
1354: P_User_Id IN NUMBER ,
1355: P_Request_id IN NUMBER ,
1356: P_Error_Code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
1357: P_tp_Job_id IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
1358: P_prov_proj_bill_job_id IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp)
1359: IS
1360: BEGIN
1361: null;
1362: END;
1369: P_Bill_to_site_use_id IN number,
1370: P_Ship_to_site_use_id IN number ,
1371: P_Set_of_books_id IN number ,
1372: P_Acct_curr_code IN varchar2,
1373: P_Expenditure_category IN PA_PLSQL_DATATYPES.Char30TabTyp,
1374: P_CC_Project_Id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1375: P_CC_Tax_task_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1376: P_EI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1377: P_AdjEI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1370: P_Ship_to_site_use_id IN number ,
1371: P_Set_of_books_id IN number ,
1372: P_Acct_curr_code IN varchar2,
1373: P_Expenditure_category IN PA_PLSQL_DATATYPES.Char30TabTyp,
1374: P_CC_Project_Id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1375: P_CC_Tax_task_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1376: P_EI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1377: P_AdjEI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1378: P_Net_zero_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1371: P_Set_of_books_id IN number ,
1372: P_Acct_curr_code IN varchar2,
1373: P_Expenditure_category IN PA_PLSQL_DATATYPES.Char30TabTyp,
1374: P_CC_Project_Id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1375: P_CC_Tax_task_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1376: P_EI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1377: P_AdjEI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1378: P_Net_zero_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1379: P_TP_sch_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1372: P_Acct_curr_code IN varchar2,
1373: P_Expenditure_category IN PA_PLSQL_DATATYPES.Char30TabTyp,
1374: P_CC_Project_Id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1375: P_CC_Tax_task_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1376: P_EI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1377: P_AdjEI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1378: P_Net_zero_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1379: P_TP_sch_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1380: P_revenue_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
1373: P_Expenditure_category IN PA_PLSQL_DATATYPES.Char30TabTyp,
1374: P_CC_Project_Id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1375: P_CC_Tax_task_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1376: P_EI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1377: P_AdjEI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1378: P_Net_zero_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1379: P_TP_sch_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1380: P_revenue_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
1381: P_provider_cr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
1374: P_CC_Project_Id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1375: P_CC_Tax_task_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1376: P_EI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1377: P_AdjEI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1378: P_Net_zero_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1379: P_TP_sch_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1380: P_revenue_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
1381: P_provider_cr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
1382: P_provider_dr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
1375: P_CC_Tax_task_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1376: P_EI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1377: P_AdjEI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1378: P_Net_zero_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1379: P_TP_sch_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1380: P_revenue_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
1381: P_provider_cr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
1382: P_provider_dr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
1383: P_Task_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1376: P_EI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1377: P_AdjEI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1378: P_Net_zero_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1379: P_TP_sch_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1380: P_revenue_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
1381: P_provider_cr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
1382: P_provider_dr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
1383: P_Task_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1384: P_Cross_charge_code IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1377: P_AdjEI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1378: P_Net_zero_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1379: P_TP_sch_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1380: P_revenue_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
1381: P_provider_cr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
1382: P_provider_dr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
1383: P_Task_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1384: P_Cross_charge_code IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1385: P_Labor_nl_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1378: P_Net_zero_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1379: P_TP_sch_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1380: P_revenue_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
1381: P_provider_cr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
1382: P_provider_dr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
1383: P_Task_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1384: P_Cross_charge_code IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1385: P_Labor_nl_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1386: P_Revenue_distributed_flag
1379: P_TP_sch_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1380: P_revenue_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
1381: P_provider_cr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
1382: P_provider_dr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
1383: P_Task_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1384: P_Cross_charge_code IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1385: P_Labor_nl_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1386: P_Revenue_distributed_flag
1387: IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1380: P_revenue_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
1381: P_provider_cr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
1382: P_provider_dr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
1383: P_Task_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1384: P_Cross_charge_code IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1385: P_Labor_nl_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1386: P_Revenue_distributed_flag
1387: IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1388: P_Expend_type IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1381: P_provider_cr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
1382: P_provider_dr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
1383: P_Task_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1384: P_Cross_charge_code IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1385: P_Labor_nl_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1386: P_Revenue_distributed_flag
1387: IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1388: P_Expend_type IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1389: P_EI_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1383: P_Task_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1384: P_Cross_charge_code IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1385: P_Labor_nl_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1386: P_Revenue_distributed_flag
1387: IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1388: P_Expend_type IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1389: P_EI_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1390: P_Sys_linkage IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1391: P_Denom_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
1384: P_Cross_charge_code IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1385: P_Labor_nl_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1386: P_Revenue_distributed_flag
1387: IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1388: P_Expend_type IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1389: P_EI_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1390: P_Sys_linkage IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1391: P_Denom_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
1392: P_Prj_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
1385: P_Labor_nl_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1386: P_Revenue_distributed_flag
1387: IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1388: P_Expend_type IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1389: P_EI_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1390: P_Sys_linkage IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1391: P_Denom_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
1392: P_Prj_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
1393: P_TP_fixed_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1386: P_Revenue_distributed_flag
1387: IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1388: P_Expend_type IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1389: P_EI_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1390: P_Sys_linkage IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1391: P_Denom_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
1392: P_Prj_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
1393: P_TP_fixed_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1394: P_Denom_raw_cost_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1387: IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1388: P_Expend_type IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1389: P_EI_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1390: P_Sys_linkage IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1391: P_Denom_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
1392: P_Prj_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
1393: P_TP_fixed_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1394: P_Denom_raw_cost_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1395: P_Denom_burdened_cost_amt
1388: P_Expend_type IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1389: P_EI_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1390: P_Sys_linkage IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1391: P_Denom_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
1392: P_Prj_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
1393: P_TP_fixed_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1394: P_Denom_raw_cost_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1395: P_Denom_burdened_cost_amt
1396: IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1389: P_EI_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1390: P_Sys_linkage IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1391: P_Denom_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
1392: P_Prj_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
1393: P_TP_fixed_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1394: P_Denom_raw_cost_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1395: P_Denom_burdened_cost_amt
1396: IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1397: P_Raw_revenue_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1390: P_Sys_linkage IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1391: P_Denom_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
1392: P_Prj_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
1393: P_TP_fixed_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1394: P_Denom_raw_cost_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1395: P_Denom_burdened_cost_amt
1396: IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1397: P_Raw_revenue_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1398: P_Quantity IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1392: P_Prj_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
1393: P_TP_fixed_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1394: P_Denom_raw_cost_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1395: P_Denom_burdened_cost_amt
1396: IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1397: P_Raw_revenue_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1398: P_Quantity IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1399: P_Non_labor_resource IN PA_PLSQL_DATATYPES.Char20TabTyp ,
1400: P_Prvdr_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
1393: P_TP_fixed_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1394: P_Denom_raw_cost_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1395: P_Denom_burdened_cost_amt
1396: IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1397: P_Raw_revenue_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1398: P_Quantity IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1399: P_Non_labor_resource IN PA_PLSQL_DATATYPES.Char20TabTyp ,
1400: P_Prvdr_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
1401: P_Recvr_org_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1394: P_Denom_raw_cost_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1395: P_Denom_burdened_cost_amt
1396: IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1397: P_Raw_revenue_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1398: P_Quantity IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1399: P_Non_labor_resource IN PA_PLSQL_DATATYPES.Char20TabTyp ,
1400: P_Prvdr_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
1401: P_Recvr_org_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1402: P_Recvr_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
1395: P_Denom_burdened_cost_amt
1396: IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1397: P_Raw_revenue_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1398: P_Quantity IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1399: P_Non_labor_resource IN PA_PLSQL_DATATYPES.Char20TabTyp ,
1400: P_Prvdr_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
1401: P_Recvr_org_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1402: P_Recvr_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
1403: P_Expnd_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
1396: IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1397: P_Raw_revenue_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1398: P_Quantity IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1399: P_Non_labor_resource IN PA_PLSQL_DATATYPES.Char20TabTyp ,
1400: P_Prvdr_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
1401: P_Recvr_org_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1402: P_Recvr_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
1403: P_Expnd_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
1404: P_NL_resource_organization
1397: P_Raw_revenue_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1398: P_Quantity IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1399: P_Non_labor_resource IN PA_PLSQL_DATATYPES.Char20TabTyp ,
1400: P_Prvdr_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
1401: P_Recvr_org_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1402: P_Recvr_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
1403: P_Expnd_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
1404: P_NL_resource_organization
1405: IN PA_PLSQL_DATATYPES.IdTabTyp ,
1398: P_Quantity IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1399: P_Non_labor_resource IN PA_PLSQL_DATATYPES.Char20TabTyp ,
1400: P_Prvdr_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
1401: P_Recvr_org_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1402: P_Recvr_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
1403: P_Expnd_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
1404: P_NL_resource_organization
1405: IN PA_PLSQL_DATATYPES.IdTabTyp ,
1406: P_Incurred_by_person_id
1399: P_Non_labor_resource IN PA_PLSQL_DATATYPES.Char20TabTyp ,
1400: P_Prvdr_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
1401: P_Recvr_org_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1402: P_Recvr_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
1403: P_Expnd_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
1404: P_NL_resource_organization
1405: IN PA_PLSQL_DATATYPES.IdTabTyp ,
1406: P_Incurred_by_person_id
1407: IN PA_PLSQL_DATATYPES.IdTabTyp ,
1401: P_Recvr_org_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1402: P_Recvr_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
1403: P_Expnd_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
1404: P_NL_resource_organization
1405: IN PA_PLSQL_DATATYPES.IdTabTyp ,
1406: P_Incurred_by_person_id
1407: IN PA_PLSQL_DATATYPES.IdTabTyp ,
1408: P_Job_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1409: P_Denom_TP_currency_code
1403: P_Expnd_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
1404: P_NL_resource_organization
1405: IN PA_PLSQL_DATATYPES.IdTabTyp ,
1406: P_Incurred_by_person_id
1407: IN PA_PLSQL_DATATYPES.IdTabTyp ,
1408: P_Job_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1409: P_Denom_TP_currency_code
1410: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char15TabTyp ,
1411: P_Denom_transfer_price
1404: P_NL_resource_organization
1405: IN PA_PLSQL_DATATYPES.IdTabTyp ,
1406: P_Incurred_by_person_id
1407: IN PA_PLSQL_DATATYPES.IdTabTyp ,
1408: P_Job_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1409: P_Denom_TP_currency_code
1410: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char15TabTyp ,
1411: P_Denom_transfer_price
1412: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1406: P_Incurred_by_person_id
1407: IN PA_PLSQL_DATATYPES.IdTabTyp ,
1408: P_Job_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1409: P_Denom_TP_currency_code
1410: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char15TabTyp ,
1411: P_Denom_transfer_price
1412: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1413: P_Acct_TP_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1414: P_Acct_TP_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1408: P_Job_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1409: P_Denom_TP_currency_code
1410: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char15TabTyp ,
1411: P_Denom_transfer_price
1412: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1413: P_Acct_TP_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1414: P_Acct_TP_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1415: P_Acct_TP_exchange_rate
1416: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1409: P_Denom_TP_currency_code
1410: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char15TabTyp ,
1411: P_Denom_transfer_price
1412: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1413: P_Acct_TP_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1414: P_Acct_TP_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1415: P_Acct_TP_exchange_rate
1416: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1417: P_Acct_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1410: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char15TabTyp ,
1411: P_Denom_transfer_price
1412: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1413: P_Acct_TP_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1414: P_Acct_TP_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1415: P_Acct_TP_exchange_rate
1416: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1417: P_Acct_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1418: P_CC_markup_base_code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1412: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1413: P_Acct_TP_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1414: P_Acct_TP_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1415: P_Acct_TP_exchange_rate
1416: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1417: P_Acct_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1418: P_CC_markup_base_code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1419: P_TP_ind_compiled_set_id
1420: IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
1413: P_Acct_TP_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1414: P_Acct_TP_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1415: P_Acct_TP_exchange_rate
1416: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1417: P_Acct_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1418: P_CC_markup_base_code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1419: P_TP_ind_compiled_set_id
1420: IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
1421: P_TP_bill_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1414: P_Acct_TP_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1415: P_Acct_TP_exchange_rate
1416: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1417: P_Acct_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1418: P_CC_markup_base_code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1419: P_TP_ind_compiled_set_id
1420: IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
1421: P_TP_bill_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1422: P_TP_base_amt IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1416: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1417: P_Acct_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1418: P_CC_markup_base_code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1419: P_TP_ind_compiled_set_id
1420: IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
1421: P_TP_bill_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1422: P_TP_base_amt IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1423: P_TP_bill_markup_percentage
1424: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1417: P_Acct_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1418: P_CC_markup_base_code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1419: P_TP_ind_compiled_set_id
1420: IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
1421: P_TP_bill_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1422: P_TP_base_amt IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1423: P_TP_bill_markup_percentage
1424: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1425: P_TP_schedule_line_percentage
1418: P_CC_markup_base_code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1419: P_TP_ind_compiled_set_id
1420: IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
1421: P_TP_bill_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1422: P_TP_base_amt IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1423: P_TP_bill_markup_percentage
1424: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1425: P_TP_schedule_line_percentage
1426: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1420: IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
1421: P_TP_bill_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1422: P_TP_base_amt IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1423: P_TP_bill_markup_percentage
1424: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1425: P_TP_schedule_line_percentage
1426: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1427: P_TP_rule_percentage IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1428: P_burden_disp_method IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1422: P_TP_base_amt IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1423: P_TP_bill_markup_percentage
1424: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1425: P_TP_schedule_line_percentage
1426: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1427: P_TP_rule_percentage IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1428: P_burden_disp_method IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1429: P_ca_prov_code IN Varchar2,
1430: P_nca_prov_code IN Varchar2,
1423: P_TP_bill_markup_percentage
1424: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1425: P_TP_schedule_line_percentage
1426: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1427: P_TP_rule_percentage IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1428: P_burden_disp_method IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1429: P_ca_prov_code IN Varchar2,
1430: P_nca_prov_code IN Varchar2,
1431: P_Processed_thru_date IN Date ,
1424: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1425: P_TP_schedule_line_percentage
1426: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1427: P_TP_rule_percentage IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1428: P_burden_disp_method IN PA_PLSQL_DATATYPES.Char1TabTyp ,
1429: P_ca_prov_code IN Varchar2,
1430: P_nca_prov_code IN Varchar2,
1431: P_Processed_thru_date IN Date ,
1432: P_No_of_records IN NUMBER ,
1431: P_Processed_thru_date IN Date ,
1432: P_No_of_records IN NUMBER ,
1433: P_User_Id IN NUMBER ,
1434: P_Request_id IN NUMBER ,
1435: P_Error_Code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
1436: P_tp_Job_id IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
1437: P_prov_proj_bill_job_id IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
1438: /*Added for cross proj*/
1439: P_tp_amt_type_code IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1432: P_No_of_records IN NUMBER ,
1433: P_User_Id IN NUMBER ,
1434: P_Request_id IN NUMBER ,
1435: P_Error_Code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
1436: P_tp_Job_id IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
1437: P_prov_proj_bill_job_id IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
1438: /*Added for cross proj*/
1439: P_tp_amt_type_code IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1440: P_projfunc_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
1433: P_User_Id IN NUMBER ,
1434: P_Request_id IN NUMBER ,
1435: P_Error_Code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
1436: P_tp_Job_id IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
1437: P_prov_proj_bill_job_id IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
1438: /*Added for cross proj*/
1439: P_tp_amt_type_code IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1440: P_projfunc_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
1441: P_project_tp_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1435: P_Error_Code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
1436: P_tp_Job_id IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
1437: P_prov_proj_bill_job_id IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
1438: /*Added for cross proj*/
1439: P_tp_amt_type_code IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1440: P_projfunc_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
1441: P_project_tp_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1442: P_project_tp_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1443: P_project_tp_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1436: P_tp_Job_id IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
1437: P_prov_proj_bill_job_id IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
1438: /*Added for cross proj*/
1439: P_tp_amt_type_code IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1440: P_projfunc_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
1441: P_project_tp_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1442: P_project_tp_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1443: P_project_tp_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1444: P_projfunc_tp_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1437: P_prov_proj_bill_job_id IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
1438: /*Added for cross proj*/
1439: P_tp_amt_type_code IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1440: P_projfunc_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
1441: P_project_tp_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1442: P_project_tp_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1443: P_project_tp_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1444: P_projfunc_tp_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1445: P_projfunc_tp_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1438: /*Added for cross proj*/
1439: P_tp_amt_type_code IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1440: P_projfunc_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
1441: P_project_tp_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1442: P_project_tp_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1443: P_project_tp_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1444: P_projfunc_tp_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1445: P_projfunc_tp_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1446: P_projfunc_tp_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1439: P_tp_amt_type_code IN PA_PLSQL_DATATYPES.Char30TabTyp ,
1440: P_projfunc_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
1441: P_project_tp_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1442: P_project_tp_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1443: P_project_tp_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1444: P_projfunc_tp_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1445: P_projfunc_tp_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1446: P_projfunc_tp_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1447: P_assignment_id IN PA_PLSQL_DATATYPES.IdTabTyp,
1440: P_projfunc_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
1441: P_project_tp_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1442: P_project_tp_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1443: P_project_tp_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1444: P_projfunc_tp_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1445: P_projfunc_tp_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1446: P_projfunc_tp_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1447: P_assignment_id IN PA_PLSQL_DATATYPES.IdTabTyp,
1448: P_project_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1441: P_project_tp_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1442: P_project_tp_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1443: P_project_tp_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1444: P_projfunc_tp_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1445: P_projfunc_tp_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1446: P_projfunc_tp_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1447: P_assignment_id IN PA_PLSQL_DATATYPES.IdTabTyp,
1448: P_project_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1449: P_projfunc_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1442: P_project_tp_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1443: P_project_tp_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1444: P_projfunc_tp_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1445: P_projfunc_tp_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1446: P_projfunc_tp_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1447: P_assignment_id IN PA_PLSQL_DATATYPES.IdTabTyp,
1448: P_project_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1449: P_projfunc_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1450:
1443: P_project_tp_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1444: P_projfunc_tp_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1445: P_projfunc_tp_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1446: P_projfunc_tp_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1447: P_assignment_id IN PA_PLSQL_DATATYPES.IdTabTyp,
1448: P_project_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1449: P_projfunc_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1450:
1451: /*End for cross proj*/
1444: P_projfunc_tp_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1445: P_projfunc_tp_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1446: P_projfunc_tp_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1447: P_assignment_id IN PA_PLSQL_DATATYPES.IdTabTyp,
1448: P_project_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1449: P_projfunc_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1450:
1451: /*End for cross proj*/
1452: /* Bill rate Discount*/
1445: P_projfunc_tp_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1446: P_projfunc_tp_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1447: P_assignment_id IN PA_PLSQL_DATATYPES.IdTabTyp,
1448: P_project_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1449: P_projfunc_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1450:
1451: /*End for cross proj*/
1452: /* Bill rate Discount*/
1453: p_dist_rule IN PA_PLSQL_DATATYPES.Char30TabTyp,
1449: P_projfunc_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
1450:
1451: /*End for cross proj*/
1452: /* Bill rate Discount*/
1453: p_dist_rule IN PA_PLSQL_DATATYPES.Char30TabTyp,
1454: p_mcb_flag IN PA_PLSQL_DATATYPES.Char1TabTyp,
1455: p_bill_rate_multiplier IN PA_PLSQL_DATATYPES.Char30TabTyp,
1456: p_raw_cost IN PA_PLSQL_DATATYPES.Char30TabTyp,
1457: /* p_labor_schdl_discnt IN PA_PLSQL_DATATYPES.NumTabTyp, Commented for bug 3252190 */
1450:
1451: /*End for cross proj*/
1452: /* Bill rate Discount*/
1453: p_dist_rule IN PA_PLSQL_DATATYPES.Char30TabTyp,
1454: p_mcb_flag IN PA_PLSQL_DATATYPES.Char1TabTyp,
1455: p_bill_rate_multiplier IN PA_PLSQL_DATATYPES.Char30TabTyp,
1456: p_raw_cost IN PA_PLSQL_DATATYPES.Char30TabTyp,
1457: /* p_labor_schdl_discnt IN PA_PLSQL_DATATYPES.NumTabTyp, Commented for bug 3252190 */
1458: p_labor_schdl_discnt IN PA_PLSQL_DATATYPES.Char30TabTyp, /* Changed the data type from Num to char for bug3252190 */
1451: /*End for cross proj*/
1452: /* Bill rate Discount*/
1453: p_dist_rule IN PA_PLSQL_DATATYPES.Char30TabTyp,
1454: p_mcb_flag IN PA_PLSQL_DATATYPES.Char1TabTyp,
1455: p_bill_rate_multiplier IN PA_PLSQL_DATATYPES.Char30TabTyp,
1456: p_raw_cost IN PA_PLSQL_DATATYPES.Char30TabTyp,
1457: /* p_labor_schdl_discnt IN PA_PLSQL_DATATYPES.NumTabTyp, Commented for bug 3252190 */
1458: p_labor_schdl_discnt IN PA_PLSQL_DATATYPES.Char30TabTyp, /* Changed the data type from Num to char for bug3252190 */
1459: p_labor_schdl_fixed_date IN PA_PLSQL_DATATYPES.Char30TabTyp,
1452: /* Bill rate Discount*/
1453: p_dist_rule IN PA_PLSQL_DATATYPES.Char30TabTyp,
1454: p_mcb_flag IN PA_PLSQL_DATATYPES.Char1TabTyp,
1455: p_bill_rate_multiplier IN PA_PLSQL_DATATYPES.Char30TabTyp,
1456: p_raw_cost IN PA_PLSQL_DATATYPES.Char30TabTyp,
1457: /* p_labor_schdl_discnt IN PA_PLSQL_DATATYPES.NumTabTyp, Commented for bug 3252190 */
1458: p_labor_schdl_discnt IN PA_PLSQL_DATATYPES.Char30TabTyp, /* Changed the data type from Num to char for bug3252190 */
1459: p_labor_schdl_fixed_date IN PA_PLSQL_DATATYPES.Char30TabTyp,
1460: p_bill_job_grp_id IN PA_PLSQL_DATATYPES.NumTabTyp,
1453: p_dist_rule IN PA_PLSQL_DATATYPES.Char30TabTyp,
1454: p_mcb_flag IN PA_PLSQL_DATATYPES.Char1TabTyp,
1455: p_bill_rate_multiplier IN PA_PLSQL_DATATYPES.Char30TabTyp,
1456: p_raw_cost IN PA_PLSQL_DATATYPES.Char30TabTyp,
1457: /* p_labor_schdl_discnt IN PA_PLSQL_DATATYPES.NumTabTyp, Commented for bug 3252190 */
1458: p_labor_schdl_discnt IN PA_PLSQL_DATATYPES.Char30TabTyp, /* Changed the data type from Num to char for bug3252190 */
1459: p_labor_schdl_fixed_date IN PA_PLSQL_DATATYPES.Char30TabTyp,
1460: p_bill_job_grp_id IN PA_PLSQL_DATATYPES.NumTabTyp,
1461: p_labor_sch_type IN PA_PLSQL_DATATYPES.Char1TabTyp,
1454: p_mcb_flag IN PA_PLSQL_DATATYPES.Char1TabTyp,
1455: p_bill_rate_multiplier IN PA_PLSQL_DATATYPES.Char30TabTyp,
1456: p_raw_cost IN PA_PLSQL_DATATYPES.Char30TabTyp,
1457: /* p_labor_schdl_discnt IN PA_PLSQL_DATATYPES.NumTabTyp, Commented for bug 3252190 */
1458: p_labor_schdl_discnt IN PA_PLSQL_DATATYPES.Char30TabTyp, /* Changed the data type from Num to char for bug3252190 */
1459: p_labor_schdl_fixed_date IN PA_PLSQL_DATATYPES.Char30TabTyp,
1460: p_bill_job_grp_id IN PA_PLSQL_DATATYPES.NumTabTyp,
1461: p_labor_sch_type IN PA_PLSQL_DATATYPES.Char1TabTyp,
1462: p_project_org_id IN PA_PLSQL_DATATYPES.NumTabTyp ,
1455: p_bill_rate_multiplier IN PA_PLSQL_DATATYPES.Char30TabTyp,
1456: p_raw_cost IN PA_PLSQL_DATATYPES.Char30TabTyp,
1457: /* p_labor_schdl_discnt IN PA_PLSQL_DATATYPES.NumTabTyp, Commented for bug 3252190 */
1458: p_labor_schdl_discnt IN PA_PLSQL_DATATYPES.Char30TabTyp, /* Changed the data type from Num to char for bug3252190 */
1459: p_labor_schdl_fixed_date IN PA_PLSQL_DATATYPES.Char30TabTyp,
1460: p_bill_job_grp_id IN PA_PLSQL_DATATYPES.NumTabTyp,
1461: p_labor_sch_type IN PA_PLSQL_DATATYPES.Char1TabTyp,
1462: p_project_org_id IN PA_PLSQL_DATATYPES.NumTabTyp ,
1463: p_project_type IN PA_PLSQL_DATATYPES.Char30TabTyp,
1456: p_raw_cost IN PA_PLSQL_DATATYPES.Char30TabTyp,
1457: /* p_labor_schdl_discnt IN PA_PLSQL_DATATYPES.NumTabTyp, Commented for bug 3252190 */
1458: p_labor_schdl_discnt IN PA_PLSQL_DATATYPES.Char30TabTyp, /* Changed the data type from Num to char for bug3252190 */
1459: p_labor_schdl_fixed_date IN PA_PLSQL_DATATYPES.Char30TabTyp,
1460: p_bill_job_grp_id IN PA_PLSQL_DATATYPES.NumTabTyp,
1461: p_labor_sch_type IN PA_PLSQL_DATATYPES.Char1TabTyp,
1462: p_project_org_id IN PA_PLSQL_DATATYPES.NumTabTyp ,
1463: p_project_type IN PA_PLSQL_DATATYPES.Char30TabTyp,
1464: p_exp_func_curr_code IN PA_PLSQL_DATATYPES.Char30TabTyp,
1457: /* p_labor_schdl_discnt IN PA_PLSQL_DATATYPES.NumTabTyp, Commented for bug 3252190 */
1458: p_labor_schdl_discnt IN PA_PLSQL_DATATYPES.Char30TabTyp, /* Changed the data type from Num to char for bug3252190 */
1459: p_labor_schdl_fixed_date IN PA_PLSQL_DATATYPES.Char30TabTyp,
1460: p_bill_job_grp_id IN PA_PLSQL_DATATYPES.NumTabTyp,
1461: p_labor_sch_type IN PA_PLSQL_DATATYPES.Char1TabTyp,
1462: p_project_org_id IN PA_PLSQL_DATATYPES.NumTabTyp ,
1463: p_project_type IN PA_PLSQL_DATATYPES.Char30TabTyp,
1464: p_exp_func_curr_code IN PA_PLSQL_DATATYPES.Char30TabTyp,
1465: p_incurred_by_organz_id IN PA_PLSQL_DATATYPES.NumTabTyp,
1458: p_labor_schdl_discnt IN PA_PLSQL_DATATYPES.Char30TabTyp, /* Changed the data type from Num to char for bug3252190 */
1459: p_labor_schdl_fixed_date IN PA_PLSQL_DATATYPES.Char30TabTyp,
1460: p_bill_job_grp_id IN PA_PLSQL_DATATYPES.NumTabTyp,
1461: p_labor_sch_type IN PA_PLSQL_DATATYPES.Char1TabTyp,
1462: p_project_org_id IN PA_PLSQL_DATATYPES.NumTabTyp ,
1463: p_project_type IN PA_PLSQL_DATATYPES.Char30TabTyp,
1464: p_exp_func_curr_code IN PA_PLSQL_DATATYPES.Char30TabTyp,
1465: p_incurred_by_organz_id IN PA_PLSQL_DATATYPES.NumTabTyp,
1466: p_raw_cost_rate IN PA_PLSQL_DATATYPES.Char30TabTyp,
1459: p_labor_schdl_fixed_date IN PA_PLSQL_DATATYPES.Char30TabTyp,
1460: p_bill_job_grp_id IN PA_PLSQL_DATATYPES.NumTabTyp,
1461: p_labor_sch_type IN PA_PLSQL_DATATYPES.Char1TabTyp,
1462: p_project_org_id IN PA_PLSQL_DATATYPES.NumTabTyp ,
1463: p_project_type IN PA_PLSQL_DATATYPES.Char30TabTyp,
1464: p_exp_func_curr_code IN PA_PLSQL_DATATYPES.Char30TabTyp,
1465: p_incurred_by_organz_id IN PA_PLSQL_DATATYPES.NumTabTyp,
1466: p_raw_cost_rate IN PA_PLSQL_DATATYPES.Char30TabTyp,
1467: p_override_to_organz_id IN PA_PLSQL_DATATYPES.NumTabTyp,
1460: p_bill_job_grp_id IN PA_PLSQL_DATATYPES.NumTabTyp,
1461: p_labor_sch_type IN PA_PLSQL_DATATYPES.Char1TabTyp,
1462: p_project_org_id IN PA_PLSQL_DATATYPES.NumTabTyp ,
1463: p_project_type IN PA_PLSQL_DATATYPES.Char30TabTyp,
1464: p_exp_func_curr_code IN PA_PLSQL_DATATYPES.Char30TabTyp,
1465: p_incurred_by_organz_id IN PA_PLSQL_DATATYPES.NumTabTyp,
1466: p_raw_cost_rate IN PA_PLSQL_DATATYPES.Char30TabTyp,
1467: p_override_to_organz_id IN PA_PLSQL_DATATYPES.NumTabTyp,
1468: p_emp_bill_rate_schedule_id IN PA_PLSQL_DATATYPES.NumTabTyp,
1461: p_labor_sch_type IN PA_PLSQL_DATATYPES.Char1TabTyp,
1462: p_project_org_id IN PA_PLSQL_DATATYPES.NumTabTyp ,
1463: p_project_type IN PA_PLSQL_DATATYPES.Char30TabTyp,
1464: p_exp_func_curr_code IN PA_PLSQL_DATATYPES.Char30TabTyp,
1465: p_incurred_by_organz_id IN PA_PLSQL_DATATYPES.NumTabTyp,
1466: p_raw_cost_rate IN PA_PLSQL_DATATYPES.Char30TabTyp,
1467: p_override_to_organz_id IN PA_PLSQL_DATATYPES.NumTabTyp,
1468: p_emp_bill_rate_schedule_id IN PA_PLSQL_DATATYPES.NumTabTyp,
1469: p_job_bill_rate_schedule_id IN PA_PLSQL_DATATYPES.NumTabTyp,
1462: p_project_org_id IN PA_PLSQL_DATATYPES.NumTabTyp ,
1463: p_project_type IN PA_PLSQL_DATATYPES.Char30TabTyp,
1464: p_exp_func_curr_code IN PA_PLSQL_DATATYPES.Char30TabTyp,
1465: p_incurred_by_organz_id IN PA_PLSQL_DATATYPES.NumTabTyp,
1466: p_raw_cost_rate IN PA_PLSQL_DATATYPES.Char30TabTyp,
1467: p_override_to_organz_id IN PA_PLSQL_DATATYPES.NumTabTyp,
1468: p_emp_bill_rate_schedule_id IN PA_PLSQL_DATATYPES.NumTabTyp,
1469: p_job_bill_rate_schedule_id IN PA_PLSQL_DATATYPES.NumTabTyp,
1470: p_exp_raw_cost IN PA_PLSQL_DATATYPES.Char30TabTyp,
1463: p_project_type IN PA_PLSQL_DATATYPES.Char30TabTyp,
1464: p_exp_func_curr_code IN PA_PLSQL_DATATYPES.Char30TabTyp,
1465: p_incurred_by_organz_id IN PA_PLSQL_DATATYPES.NumTabTyp,
1466: p_raw_cost_rate IN PA_PLSQL_DATATYPES.Char30TabTyp,
1467: p_override_to_organz_id IN PA_PLSQL_DATATYPES.NumTabTyp,
1468: p_emp_bill_rate_schedule_id IN PA_PLSQL_DATATYPES.NumTabTyp,
1469: p_job_bill_rate_schedule_id IN PA_PLSQL_DATATYPES.NumTabTyp,
1470: p_exp_raw_cost IN PA_PLSQL_DATATYPES.Char30TabTyp,
1471: p_assignment_precedes_task IN PA_PLSQL_DATATYPES.Char1TabTyp,
1464: p_exp_func_curr_code IN PA_PLSQL_DATATYPES.Char30TabTyp,
1465: p_incurred_by_organz_id IN PA_PLSQL_DATATYPES.NumTabTyp,
1466: p_raw_cost_rate IN PA_PLSQL_DATATYPES.Char30TabTyp,
1467: p_override_to_organz_id IN PA_PLSQL_DATATYPES.NumTabTyp,
1468: p_emp_bill_rate_schedule_id IN PA_PLSQL_DATATYPES.NumTabTyp,
1469: p_job_bill_rate_schedule_id IN PA_PLSQL_DATATYPES.NumTabTyp,
1470: p_exp_raw_cost IN PA_PLSQL_DATATYPES.Char30TabTyp,
1471: p_assignment_precedes_task IN PA_PLSQL_DATATYPES.Char1TabTyp,
1472:
1465: p_incurred_by_organz_id IN PA_PLSQL_DATATYPES.NumTabTyp,
1466: p_raw_cost_rate IN PA_PLSQL_DATATYPES.Char30TabTyp,
1467: p_override_to_organz_id IN PA_PLSQL_DATATYPES.NumTabTyp,
1468: p_emp_bill_rate_schedule_id IN PA_PLSQL_DATATYPES.NumTabTyp,
1469: p_job_bill_rate_schedule_id IN PA_PLSQL_DATATYPES.NumTabTyp,
1470: p_exp_raw_cost IN PA_PLSQL_DATATYPES.Char30TabTyp,
1471: p_assignment_precedes_task IN PA_PLSQL_DATATYPES.Char1TabTyp,
1472:
1473: p_burden_cost IN PA_PLSQL_DATATYPES.Char30TabTyp,
1466: p_raw_cost_rate IN PA_PLSQL_DATATYPES.Char30TabTyp,
1467: p_override_to_organz_id IN PA_PLSQL_DATATYPES.NumTabTyp,
1468: p_emp_bill_rate_schedule_id IN PA_PLSQL_DATATYPES.NumTabTyp,
1469: p_job_bill_rate_schedule_id IN PA_PLSQL_DATATYPES.NumTabTyp,
1470: p_exp_raw_cost IN PA_PLSQL_DATATYPES.Char30TabTyp,
1471: p_assignment_precedes_task IN PA_PLSQL_DATATYPES.Char1TabTyp,
1472:
1473: p_burden_cost IN PA_PLSQL_DATATYPES.Char30TabTyp,
1474: p_task_nl_bill_rate_org_id IN PA_PLSQL_DATATYPES.IdTabTyp,
1467: p_override_to_organz_id IN PA_PLSQL_DATATYPES.NumTabTyp,
1468: p_emp_bill_rate_schedule_id IN PA_PLSQL_DATATYPES.NumTabTyp,
1469: p_job_bill_rate_schedule_id IN PA_PLSQL_DATATYPES.NumTabTyp,
1470: p_exp_raw_cost IN PA_PLSQL_DATATYPES.Char30TabTyp,
1471: p_assignment_precedes_task IN PA_PLSQL_DATATYPES.Char1TabTyp,
1472:
1473: p_burden_cost IN PA_PLSQL_DATATYPES.Char30TabTyp,
1474: p_task_nl_bill_rate_org_id IN PA_PLSQL_DATATYPES.IdTabTyp,
1475: p_proj_nl_bill_rate_org_id IN PA_PLSQL_DATATYPES.IdTabTyp,
1469: p_job_bill_rate_schedule_id IN PA_PLSQL_DATATYPES.NumTabTyp,
1470: p_exp_raw_cost IN PA_PLSQL_DATATYPES.Char30TabTyp,
1471: p_assignment_precedes_task IN PA_PLSQL_DATATYPES.Char1TabTyp,
1472:
1473: p_burden_cost IN PA_PLSQL_DATATYPES.Char30TabTyp,
1474: p_task_nl_bill_rate_org_id IN PA_PLSQL_DATATYPES.IdTabTyp,
1475: p_proj_nl_bill_rate_org_id IN PA_PLSQL_DATATYPES.IdTabTyp,
1476: p_task_nl_std_bill_rate_sch IN PA_PLSQL_DATATYPES.Char30TabTyp,
1477: p_proj_nl_std_bill_rate_sch IN PA_PLSQL_DATATYPES.Char30TabTyp,
1470: p_exp_raw_cost IN PA_PLSQL_DATATYPES.Char30TabTyp,
1471: p_assignment_precedes_task IN PA_PLSQL_DATATYPES.Char1TabTyp,
1472:
1473: p_burden_cost IN PA_PLSQL_DATATYPES.Char30TabTyp,
1474: p_task_nl_bill_rate_org_id IN PA_PLSQL_DATATYPES.IdTabTyp,
1475: p_proj_nl_bill_rate_org_id IN PA_PLSQL_DATATYPES.IdTabTyp,
1476: p_task_nl_std_bill_rate_sch IN PA_PLSQL_DATATYPES.Char30TabTyp,
1477: p_proj_nl_std_bill_rate_sch IN PA_PLSQL_DATATYPES.Char30TabTyp,
1478: p_nl_sch_type IN PA_PLSQL_DATATYPES.Char1TabTyp,
1471: p_assignment_precedes_task IN PA_PLSQL_DATATYPES.Char1TabTyp,
1472:
1473: p_burden_cost IN PA_PLSQL_DATATYPES.Char30TabTyp,
1474: p_task_nl_bill_rate_org_id IN PA_PLSQL_DATATYPES.IdTabTyp,
1475: p_proj_nl_bill_rate_org_id IN PA_PLSQL_DATATYPES.IdTabTyp,
1476: p_task_nl_std_bill_rate_sch IN PA_PLSQL_DATATYPES.Char30TabTyp,
1477: p_proj_nl_std_bill_rate_sch IN PA_PLSQL_DATATYPES.Char30TabTyp,
1478: p_nl_sch_type IN PA_PLSQL_DATATYPES.Char1TabTyp,
1479: p_nl_task_sch_date IN PA_PLSQL_DATATYPES.Char30TabTyp,
1472:
1473: p_burden_cost IN PA_PLSQL_DATATYPES.Char30TabTyp,
1474: p_task_nl_bill_rate_org_id IN PA_PLSQL_DATATYPES.IdTabTyp,
1475: p_proj_nl_bill_rate_org_id IN PA_PLSQL_DATATYPES.IdTabTyp,
1476: p_task_nl_std_bill_rate_sch IN PA_PLSQL_DATATYPES.Char30TabTyp,
1477: p_proj_nl_std_bill_rate_sch IN PA_PLSQL_DATATYPES.Char30TabTyp,
1478: p_nl_sch_type IN PA_PLSQL_DATATYPES.Char1TabTyp,
1479: p_nl_task_sch_date IN PA_PLSQL_DATATYPES.Char30TabTyp,
1480: p_nl_proj_sch_date IN PA_PLSQL_DATATYPES.Char30TabTyp,
1473: p_burden_cost IN PA_PLSQL_DATATYPES.Char30TabTyp,
1474: p_task_nl_bill_rate_org_id IN PA_PLSQL_DATATYPES.IdTabTyp,
1475: p_proj_nl_bill_rate_org_id IN PA_PLSQL_DATATYPES.IdTabTyp,
1476: p_task_nl_std_bill_rate_sch IN PA_PLSQL_DATATYPES.Char30TabTyp,
1477: p_proj_nl_std_bill_rate_sch IN PA_PLSQL_DATATYPES.Char30TabTyp,
1478: p_nl_sch_type IN PA_PLSQL_DATATYPES.Char1TabTyp,
1479: p_nl_task_sch_date IN PA_PLSQL_DATATYPES.Char30TabTyp,
1480: p_nl_proj_sch_date IN PA_PLSQL_DATATYPES.Char30TabTyp,
1481: p_nl_task_sch_discount IN PA_PLSQL_DATATYPES.NumTabTyp,
1474: p_task_nl_bill_rate_org_id IN PA_PLSQL_DATATYPES.IdTabTyp,
1475: p_proj_nl_bill_rate_org_id IN PA_PLSQL_DATATYPES.IdTabTyp,
1476: p_task_nl_std_bill_rate_sch IN PA_PLSQL_DATATYPES.Char30TabTyp,
1477: p_proj_nl_std_bill_rate_sch IN PA_PLSQL_DATATYPES.Char30TabTyp,
1478: p_nl_sch_type IN PA_PLSQL_DATATYPES.Char1TabTyp,
1479: p_nl_task_sch_date IN PA_PLSQL_DATATYPES.Char30TabTyp,
1480: p_nl_proj_sch_date IN PA_PLSQL_DATATYPES.Char30TabTyp,
1481: p_nl_task_sch_discount IN PA_PLSQL_DATATYPES.NumTabTyp,
1482: p_nl_proj_sch_discount IN PA_PLSQL_DATATYPES.NumTabTyp,
1475: p_proj_nl_bill_rate_org_id IN PA_PLSQL_DATATYPES.IdTabTyp,
1476: p_task_nl_std_bill_rate_sch IN PA_PLSQL_DATATYPES.Char30TabTyp,
1477: p_proj_nl_std_bill_rate_sch IN PA_PLSQL_DATATYPES.Char30TabTyp,
1478: p_nl_sch_type IN PA_PLSQL_DATATYPES.Char1TabTyp,
1479: p_nl_task_sch_date IN PA_PLSQL_DATATYPES.Char30TabTyp,
1480: p_nl_proj_sch_date IN PA_PLSQL_DATATYPES.Char30TabTyp,
1481: p_nl_task_sch_discount IN PA_PLSQL_DATATYPES.NumTabTyp,
1482: p_nl_proj_sch_discount IN PA_PLSQL_DATATYPES.NumTabTyp,
1483: /* The following two parameters are added for Doosan rate api enhancement */
1476: p_task_nl_std_bill_rate_sch IN PA_PLSQL_DATATYPES.Char30TabTyp,
1477: p_proj_nl_std_bill_rate_sch IN PA_PLSQL_DATATYPES.Char30TabTyp,
1478: p_nl_sch_type IN PA_PLSQL_DATATYPES.Char1TabTyp,
1479: p_nl_task_sch_date IN PA_PLSQL_DATATYPES.Char30TabTyp,
1480: p_nl_proj_sch_date IN PA_PLSQL_DATATYPES.Char30TabTyp,
1481: p_nl_task_sch_discount IN PA_PLSQL_DATATYPES.NumTabTyp,
1482: p_nl_proj_sch_discount IN PA_PLSQL_DATATYPES.NumTabTyp,
1483: /* The following two parameters are added for Doosan rate api enhancement */
1484: p_task_nl_std_bill_rate_sch_id IN PA_PLSQL_DATATYPES.NumTabTyp DEFAULT PA_PLSQL_DATATYPES.EmptyNumTab,
1477: p_proj_nl_std_bill_rate_sch IN PA_PLSQL_DATATYPES.Char30TabTyp,
1478: p_nl_sch_type IN PA_PLSQL_DATATYPES.Char1TabTyp,
1479: p_nl_task_sch_date IN PA_PLSQL_DATATYPES.Char30TabTyp,
1480: p_nl_proj_sch_date IN PA_PLSQL_DATATYPES.Char30TabTyp,
1481: p_nl_task_sch_discount IN PA_PLSQL_DATATYPES.NumTabTyp,
1482: p_nl_proj_sch_discount IN PA_PLSQL_DATATYPES.NumTabTyp,
1483: /* The following two parameters are added for Doosan rate api enhancement */
1484: p_task_nl_std_bill_rate_sch_id IN PA_PLSQL_DATATYPES.NumTabTyp DEFAULT PA_PLSQL_DATATYPES.EmptyNumTab,
1485: p_proj_nl_std_bill_rate_sch_id IN PA_PLSQL_DATATYPES.NumTabTyp DEFAULT PA_PLSQL_DATATYPES.EmptyNumTab,
1478: p_nl_sch_type IN PA_PLSQL_DATATYPES.Char1TabTyp,
1479: p_nl_task_sch_date IN PA_PLSQL_DATATYPES.Char30TabTyp,
1480: p_nl_proj_sch_date IN PA_PLSQL_DATATYPES.Char30TabTyp,
1481: p_nl_task_sch_discount IN PA_PLSQL_DATATYPES.NumTabTyp,
1482: p_nl_proj_sch_discount IN PA_PLSQL_DATATYPES.NumTabTyp,
1483: /* The following two parameters are added for Doosan rate api enhancement */
1484: p_task_nl_std_bill_rate_sch_id IN PA_PLSQL_DATATYPES.NumTabTyp DEFAULT PA_PLSQL_DATATYPES.EmptyNumTab,
1485: p_proj_nl_std_bill_rate_sch_id IN PA_PLSQL_DATATYPES.NumTabTyp DEFAULT PA_PLSQL_DATATYPES.EmptyNumTab,
1486: p_uom_flag IN PA_PLSQL_DATATYPES.NumTabTyp
1480: p_nl_proj_sch_date IN PA_PLSQL_DATATYPES.Char30TabTyp,
1481: p_nl_task_sch_discount IN PA_PLSQL_DATATYPES.NumTabTyp,
1482: p_nl_proj_sch_discount IN PA_PLSQL_DATATYPES.NumTabTyp,
1483: /* The following two parameters are added for Doosan rate api enhancement */
1484: p_task_nl_std_bill_rate_sch_id IN PA_PLSQL_DATATYPES.NumTabTyp DEFAULT PA_PLSQL_DATATYPES.EmptyNumTab,
1485: p_proj_nl_std_bill_rate_sch_id IN PA_PLSQL_DATATYPES.NumTabTyp DEFAULT PA_PLSQL_DATATYPES.EmptyNumTab,
1486: p_uom_flag IN PA_PLSQL_DATATYPES.NumTabTyp
1487: DEFAULT PA_PLSQL_DATATYPES.EmptyNumTab
1488: )
1481: p_nl_task_sch_discount IN PA_PLSQL_DATATYPES.NumTabTyp,
1482: p_nl_proj_sch_discount IN PA_PLSQL_DATATYPES.NumTabTyp,
1483: /* The following two parameters are added for Doosan rate api enhancement */
1484: p_task_nl_std_bill_rate_sch_id IN PA_PLSQL_DATATYPES.NumTabTyp DEFAULT PA_PLSQL_DATATYPES.EmptyNumTab,
1485: p_proj_nl_std_bill_rate_sch_id IN PA_PLSQL_DATATYPES.NumTabTyp DEFAULT PA_PLSQL_DATATYPES.EmptyNumTab,
1486: p_uom_flag IN PA_PLSQL_DATATYPES.NumTabTyp
1487: DEFAULT PA_PLSQL_DATATYPES.EmptyNumTab
1488: )
1489: IS
1482: p_nl_proj_sch_discount IN PA_PLSQL_DATATYPES.NumTabTyp,
1483: /* The following two parameters are added for Doosan rate api enhancement */
1484: p_task_nl_std_bill_rate_sch_id IN PA_PLSQL_DATATYPES.NumTabTyp DEFAULT PA_PLSQL_DATATYPES.EmptyNumTab,
1485: p_proj_nl_std_bill_rate_sch_id IN PA_PLSQL_DATATYPES.NumTabTyp DEFAULT PA_PLSQL_DATATYPES.EmptyNumTab,
1486: p_uom_flag IN PA_PLSQL_DATATYPES.NumTabTyp
1487: DEFAULT PA_PLSQL_DATATYPES.EmptyNumTab
1488: )
1489: IS
1490:
1483: /* The following two parameters are added for Doosan rate api enhancement */
1484: p_task_nl_std_bill_rate_sch_id IN PA_PLSQL_DATATYPES.NumTabTyp DEFAULT PA_PLSQL_DATATYPES.EmptyNumTab,
1485: p_proj_nl_std_bill_rate_sch_id IN PA_PLSQL_DATATYPES.NumTabTyp DEFAULT PA_PLSQL_DATATYPES.EmptyNumTab,
1486: p_uom_flag IN PA_PLSQL_DATATYPES.NumTabTyp
1487: DEFAULT PA_PLSQL_DATATYPES.EmptyNumTab
1488: )
1489: IS
1490:
1491: /** Local variable for SQL Fetch *******/
1495: L_IND_REC_NEW pa_draft_invoice_details%rowtype;
1496: X_Inv_rec pa_draft_invoice_details%rowtype;
1497: L_CC_REC get_cc_dist%rowtype;
1498: L_CDL_REC prv_class_rec;
1499: L_Compute_flag PA_PLSQL_DATATYPES.Char1TabTyp;
1500: L_AdjEI_id PA_PLSQL_DATATYPES.IdTabTyp;
1501: L_Output_vat_tax_id PA_PLSQL_DATATYPES.IdTabTyp;
1502: L_Output_tax_code PA_PLSQL_DATATYPES.Char30TabTyp;
1503: L_Output_tax_exempt_flag PA_PLSQL_DATATYPES.Char1TabTyp;
1496: X_Inv_rec pa_draft_invoice_details%rowtype;
1497: L_CC_REC get_cc_dist%rowtype;
1498: L_CDL_REC prv_class_rec;
1499: L_Compute_flag PA_PLSQL_DATATYPES.Char1TabTyp;
1500: L_AdjEI_id PA_PLSQL_DATATYPES.IdTabTyp;
1501: L_Output_vat_tax_id PA_PLSQL_DATATYPES.IdTabTyp;
1502: L_Output_tax_code PA_PLSQL_DATATYPES.Char30TabTyp;
1503: L_Output_tax_exempt_flag PA_PLSQL_DATATYPES.Char1TabTyp;
1504: L_Output_tax_exempt_number PA_PLSQL_DATATYPES.Char30TabTyp;
1497: L_CC_REC get_cc_dist%rowtype;
1498: L_CDL_REC prv_class_rec;
1499: L_Compute_flag PA_PLSQL_DATATYPES.Char1TabTyp;
1500: L_AdjEI_id PA_PLSQL_DATATYPES.IdTabTyp;
1501: L_Output_vat_tax_id PA_PLSQL_DATATYPES.IdTabTyp;
1502: L_Output_tax_code PA_PLSQL_DATATYPES.Char30TabTyp;
1503: L_Output_tax_exempt_flag PA_PLSQL_DATATYPES.Char1TabTyp;
1504: L_Output_tax_exempt_number PA_PLSQL_DATATYPES.Char30TabTyp;
1505: L_Output_exempt_reason_code PA_PLSQL_DATATYPES.Char80TabTyp;
1498: L_CDL_REC prv_class_rec;
1499: L_Compute_flag PA_PLSQL_DATATYPES.Char1TabTyp;
1500: L_AdjEI_id PA_PLSQL_DATATYPES.IdTabTyp;
1501: L_Output_vat_tax_id PA_PLSQL_DATATYPES.IdTabTyp;
1502: L_Output_tax_code PA_PLSQL_DATATYPES.Char30TabTyp;
1503: L_Output_tax_exempt_flag PA_PLSQL_DATATYPES.Char1TabTyp;
1504: L_Output_tax_exempt_number PA_PLSQL_DATATYPES.Char30TabTyp;
1505: L_Output_exempt_reason_code PA_PLSQL_DATATYPES.Char80TabTyp;
1506: RECORD_FOUND BOOLEAN;
1499: L_Compute_flag PA_PLSQL_DATATYPES.Char1TabTyp;
1500: L_AdjEI_id PA_PLSQL_DATATYPES.IdTabTyp;
1501: L_Output_vat_tax_id PA_PLSQL_DATATYPES.IdTabTyp;
1502: L_Output_tax_code PA_PLSQL_DATATYPES.Char30TabTyp;
1503: L_Output_tax_exempt_flag PA_PLSQL_DATATYPES.Char1TabTyp;
1504: L_Output_tax_exempt_number PA_PLSQL_DATATYPES.Char30TabTyp;
1505: L_Output_exempt_reason_code PA_PLSQL_DATATYPES.Char80TabTyp;
1506: RECORD_FOUND BOOLEAN;
1507: CC_RECORD_FOUND BOOLEAN;
1500: L_AdjEI_id PA_PLSQL_DATATYPES.IdTabTyp;
1501: L_Output_vat_tax_id PA_PLSQL_DATATYPES.IdTabTyp;
1502: L_Output_tax_code PA_PLSQL_DATATYPES.Char30TabTyp;
1503: L_Output_tax_exempt_flag PA_PLSQL_DATATYPES.Char1TabTyp;
1504: L_Output_tax_exempt_number PA_PLSQL_DATATYPES.Char30TabTyp;
1505: L_Output_exempt_reason_code PA_PLSQL_DATATYPES.Char80TabTyp;
1506: RECORD_FOUND BOOLEAN;
1507: CC_RECORD_FOUND BOOLEAN;
1508: X_Error_Code PA_PLSQL_DATATYPES.Char30TabTyp;
1501: L_Output_vat_tax_id PA_PLSQL_DATATYPES.IdTabTyp;
1502: L_Output_tax_code PA_PLSQL_DATATYPES.Char30TabTyp;
1503: L_Output_tax_exempt_flag PA_PLSQL_DATATYPES.Char1TabTyp;
1504: L_Output_tax_exempt_number PA_PLSQL_DATATYPES.Char30TabTyp;
1505: L_Output_exempt_reason_code PA_PLSQL_DATATYPES.Char80TabTyp;
1506: RECORD_FOUND BOOLEAN;
1507: CC_RECORD_FOUND BOOLEAN;
1508: X_Error_Code PA_PLSQL_DATATYPES.Char30TabTyp;
1509: X_Error_Stage number;
1504: L_Output_tax_exempt_number PA_PLSQL_DATATYPES.Char30TabTyp;
1505: L_Output_exempt_reason_code PA_PLSQL_DATATYPES.Char80TabTyp;
1506: RECORD_FOUND BOOLEAN;
1507: CC_RECORD_FOUND BOOLEAN;
1508: X_Error_Code PA_PLSQL_DATATYPES.Char30TabTyp;
1509: X_Error_Stage number;
1510: L_PROV_ENABLED BOOLEAN := TRUE;
1511: l_cost_accrual_flag Varchar2(1);
1512: l_denom_transfer_price NUMBER;
2501: -- Procedure to reverse provider reclass entries from
2502: -- Invoice cancellation
2503: --
2504: PROCEDURE reverse_preclass (
2505: P_inv_detail_id PA_PLSQL_DATATYPES.IdTabTyp,
2506: P_new_inv_detail_id PA_PLSQL_DATATYPES.IdTabTyp,
2507: P_EI_id PA_PLSQL_DATATYPES.IdTabTyp,
2508: P_EI_date PA_PLSQL_DATATYPES.Char30TabTyp,
2509: P_Sys_Linkage PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for 3857986 */
2502: -- Invoice cancellation
2503: --
2504: PROCEDURE reverse_preclass (
2505: P_inv_detail_id PA_PLSQL_DATATYPES.IdTabTyp,
2506: P_new_inv_detail_id PA_PLSQL_DATATYPES.IdTabTyp,
2507: P_EI_id PA_PLSQL_DATATYPES.IdTabTyp,
2508: P_EI_date PA_PLSQL_DATATYPES.Char30TabTyp,
2509: P_Sys_Linkage PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for 3857986 */
2510: P_tab_count NUMBER) IS
2503: --
2504: PROCEDURE reverse_preclass (
2505: P_inv_detail_id PA_PLSQL_DATATYPES.IdTabTyp,
2506: P_new_inv_detail_id PA_PLSQL_DATATYPES.IdTabTyp,
2507: P_EI_id PA_PLSQL_DATATYPES.IdTabTyp,
2508: P_EI_date PA_PLSQL_DATATYPES.Char30TabTyp,
2509: P_Sys_Linkage PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for 3857986 */
2510: P_tab_count NUMBER) IS
2511:
2504: PROCEDURE reverse_preclass (
2505: P_inv_detail_id PA_PLSQL_DATATYPES.IdTabTyp,
2506: P_new_inv_detail_id PA_PLSQL_DATATYPES.IdTabTyp,
2507: P_EI_id PA_PLSQL_DATATYPES.IdTabTyp,
2508: P_EI_date PA_PLSQL_DATATYPES.Char30TabTyp,
2509: P_Sys_Linkage PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for 3857986 */
2510: P_tab_count NUMBER) IS
2511:
2512: l_cc_dist_rec get_cc_dist%rowtype;
2505: P_inv_detail_id PA_PLSQL_DATATYPES.IdTabTyp,
2506: P_new_inv_detail_id PA_PLSQL_DATATYPES.IdTabTyp,
2507: P_EI_id PA_PLSQL_DATATYPES.IdTabTyp,
2508: P_EI_date PA_PLSQL_DATATYPES.Char30TabTyp,
2509: P_Sys_Linkage PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for 3857986 */
2510: P_tab_count NUMBER) IS
2511:
2512: l_cc_dist_rec get_cc_dist%rowtype;
2513: