3:
4: --
5: -- Table to store the project type - Cost Accrual/Non Cost Accrual
6: --
7: G_project_category PA_PLSQL_DATATYPES.Char1TabTyp;
8:
9:
10: /* Cursor to get CC Distribution */
11: cursor get_cc_dist ( l_exp_item_id IN NUMBER )
40: P_Bill_to_site_use_id IN number,
41: P_Ship_to_site_use_id IN number ,
42: P_Set_of_books_id IN number ,
43: P_Acct_curr_code IN varchar2 ,
44: P_Expenditure_category IN PA_PLSQL_DATATYPES.Char30TabTyp,
45: P_CC_Project_Id IN PA_PLSQL_DATATYPES.IdTabTyp ,
46: P_CC_Tax_task_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
47: P_EI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
48: P_AdjEI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
41: P_Ship_to_site_use_id IN number ,
42: P_Set_of_books_id IN number ,
43: P_Acct_curr_code IN varchar2 ,
44: P_Expenditure_category IN PA_PLSQL_DATATYPES.Char30TabTyp,
45: P_CC_Project_Id IN PA_PLSQL_DATATYPES.IdTabTyp ,
46: P_CC_Tax_task_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
47: P_EI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
48: P_AdjEI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
49: P_Net_zero_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
42: P_Set_of_books_id IN number ,
43: P_Acct_curr_code IN varchar2 ,
44: P_Expenditure_category IN PA_PLSQL_DATATYPES.Char30TabTyp,
45: P_CC_Project_Id IN PA_PLSQL_DATATYPES.IdTabTyp ,
46: P_CC_Tax_task_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
47: P_EI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
48: P_AdjEI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
49: P_Net_zero_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
50: P_TP_sch_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
43: P_Acct_curr_code IN varchar2 ,
44: P_Expenditure_category IN PA_PLSQL_DATATYPES.Char30TabTyp,
45: P_CC_Project_Id IN PA_PLSQL_DATATYPES.IdTabTyp ,
46: P_CC_Tax_task_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
47: P_EI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
48: P_AdjEI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
49: P_Net_zero_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
50: P_TP_sch_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
51: P_revenue_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
44: P_Expenditure_category IN PA_PLSQL_DATATYPES.Char30TabTyp,
45: P_CC_Project_Id IN PA_PLSQL_DATATYPES.IdTabTyp ,
46: P_CC_Tax_task_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
47: P_EI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
48: P_AdjEI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
49: P_Net_zero_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
50: P_TP_sch_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
51: P_revenue_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
52: P_provider_cr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
45: P_CC_Project_Id IN PA_PLSQL_DATATYPES.IdTabTyp ,
46: P_CC_Tax_task_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
47: P_EI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
48: P_AdjEI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
49: P_Net_zero_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
50: P_TP_sch_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
51: P_revenue_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
52: P_provider_cr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
53: P_provider_dr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
46: P_CC_Tax_task_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
47: P_EI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
48: P_AdjEI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
49: P_Net_zero_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
50: P_TP_sch_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
51: P_revenue_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
52: P_provider_cr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
53: P_provider_dr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
54: P_Task_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
47: P_EI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
48: P_AdjEI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
49: P_Net_zero_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
50: P_TP_sch_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
51: P_revenue_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
52: P_provider_cr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
53: P_provider_dr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
54: P_Task_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
55: P_Cross_charge_code IN PA_PLSQL_DATATYPES.Char1TabTyp ,
48: P_AdjEI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
49: P_Net_zero_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
50: P_TP_sch_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
51: P_revenue_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
52: P_provider_cr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
53: P_provider_dr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
54: P_Task_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
55: P_Cross_charge_code IN PA_PLSQL_DATATYPES.Char1TabTyp ,
56: P_Labor_nl_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
49: P_Net_zero_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
50: P_TP_sch_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
51: P_revenue_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
52: P_provider_cr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
53: P_provider_dr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
54: P_Task_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
55: P_Cross_charge_code IN PA_PLSQL_DATATYPES.Char1TabTyp ,
56: P_Labor_nl_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
57: P_Revenue_distributed_flag
50: P_TP_sch_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
51: P_revenue_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
52: P_provider_cr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
53: P_provider_dr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
54: P_Task_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
55: P_Cross_charge_code IN PA_PLSQL_DATATYPES.Char1TabTyp ,
56: P_Labor_nl_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
57: P_Revenue_distributed_flag
58: IN PA_PLSQL_DATATYPES.Char1TabTyp ,
51: P_revenue_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
52: P_provider_cr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
53: P_provider_dr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
54: P_Task_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
55: P_Cross_charge_code IN PA_PLSQL_DATATYPES.Char1TabTyp ,
56: P_Labor_nl_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
57: P_Revenue_distributed_flag
58: IN PA_PLSQL_DATATYPES.Char1TabTyp ,
59: P_Expend_type IN PA_PLSQL_DATATYPES.Char30TabTyp ,
52: P_provider_cr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
53: P_provider_dr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
54: P_Task_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
55: P_Cross_charge_code IN PA_PLSQL_DATATYPES.Char1TabTyp ,
56: P_Labor_nl_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
57: P_Revenue_distributed_flag
58: IN PA_PLSQL_DATATYPES.Char1TabTyp ,
59: P_Expend_type IN PA_PLSQL_DATATYPES.Char30TabTyp ,
60: P_EI_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
54: P_Task_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
55: P_Cross_charge_code IN PA_PLSQL_DATATYPES.Char1TabTyp ,
56: P_Labor_nl_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
57: P_Revenue_distributed_flag
58: IN PA_PLSQL_DATATYPES.Char1TabTyp ,
59: P_Expend_type IN PA_PLSQL_DATATYPES.Char30TabTyp ,
60: P_EI_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
61: P_Sys_linkage IN PA_PLSQL_DATATYPES.Char30TabTyp ,
62: P_Denom_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
55: P_Cross_charge_code IN PA_PLSQL_DATATYPES.Char1TabTyp ,
56: P_Labor_nl_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
57: P_Revenue_distributed_flag
58: IN PA_PLSQL_DATATYPES.Char1TabTyp ,
59: P_Expend_type IN PA_PLSQL_DATATYPES.Char30TabTyp ,
60: P_EI_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
61: P_Sys_linkage IN PA_PLSQL_DATATYPES.Char30TabTyp ,
62: P_Denom_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
63: P_Prj_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
56: P_Labor_nl_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
57: P_Revenue_distributed_flag
58: IN PA_PLSQL_DATATYPES.Char1TabTyp ,
59: P_Expend_type IN PA_PLSQL_DATATYPES.Char30TabTyp ,
60: P_EI_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
61: P_Sys_linkage IN PA_PLSQL_DATATYPES.Char30TabTyp ,
62: P_Denom_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
63: P_Prj_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
64: P_TP_fixed_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
57: P_Revenue_distributed_flag
58: IN PA_PLSQL_DATATYPES.Char1TabTyp ,
59: P_Expend_type IN PA_PLSQL_DATATYPES.Char30TabTyp ,
60: P_EI_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
61: P_Sys_linkage IN PA_PLSQL_DATATYPES.Char30TabTyp ,
62: P_Denom_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
63: P_Prj_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
64: P_TP_fixed_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
65: P_Denom_raw_cost_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
58: IN PA_PLSQL_DATATYPES.Char1TabTyp ,
59: P_Expend_type IN PA_PLSQL_DATATYPES.Char30TabTyp ,
60: P_EI_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
61: P_Sys_linkage IN PA_PLSQL_DATATYPES.Char30TabTyp ,
62: P_Denom_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
63: P_Prj_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
64: P_TP_fixed_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
65: P_Denom_raw_cost_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
66: P_Denom_burdened_cost_amt
59: P_Expend_type IN PA_PLSQL_DATATYPES.Char30TabTyp ,
60: P_EI_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
61: P_Sys_linkage IN PA_PLSQL_DATATYPES.Char30TabTyp ,
62: P_Denom_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
63: P_Prj_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
64: P_TP_fixed_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
65: P_Denom_raw_cost_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
66: P_Denom_burdened_cost_amt
67: IN PA_PLSQL_DATATYPES.Char30TabTyp ,
60: P_EI_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
61: P_Sys_linkage IN PA_PLSQL_DATATYPES.Char30TabTyp ,
62: P_Denom_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
63: P_Prj_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
64: P_TP_fixed_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
65: P_Denom_raw_cost_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
66: P_Denom_burdened_cost_amt
67: IN PA_PLSQL_DATATYPES.Char30TabTyp ,
68: P_Raw_revenue_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
61: P_Sys_linkage IN PA_PLSQL_DATATYPES.Char30TabTyp ,
62: P_Denom_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
63: P_Prj_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
64: P_TP_fixed_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
65: P_Denom_raw_cost_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
66: P_Denom_burdened_cost_amt
67: IN PA_PLSQL_DATATYPES.Char30TabTyp ,
68: P_Raw_revenue_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
69: P_Quantity IN PA_PLSQL_DATATYPES.Char30TabTyp ,
63: P_Prj_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
64: P_TP_fixed_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
65: P_Denom_raw_cost_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
66: P_Denom_burdened_cost_amt
67: IN PA_PLSQL_DATATYPES.Char30TabTyp ,
68: P_Raw_revenue_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
69: P_Quantity IN PA_PLSQL_DATATYPES.Char30TabTyp ,
70: P_Non_labor_resource IN PA_PLSQL_DATATYPES.Char20TabTyp ,
71: P_Prvdr_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
64: P_TP_fixed_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
65: P_Denom_raw_cost_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
66: P_Denom_burdened_cost_amt
67: IN PA_PLSQL_DATATYPES.Char30TabTyp ,
68: P_Raw_revenue_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
69: P_Quantity IN PA_PLSQL_DATATYPES.Char30TabTyp ,
70: P_Non_labor_resource IN PA_PLSQL_DATATYPES.Char20TabTyp ,
71: P_Prvdr_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
72: P_Recvr_org_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
65: P_Denom_raw_cost_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
66: P_Denom_burdened_cost_amt
67: IN PA_PLSQL_DATATYPES.Char30TabTyp ,
68: P_Raw_revenue_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
69: P_Quantity IN PA_PLSQL_DATATYPES.Char30TabTyp ,
70: P_Non_labor_resource IN PA_PLSQL_DATATYPES.Char20TabTyp ,
71: P_Prvdr_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
72: P_Recvr_org_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
73: P_Recvr_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
66: P_Denom_burdened_cost_amt
67: IN PA_PLSQL_DATATYPES.Char30TabTyp ,
68: P_Raw_revenue_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
69: P_Quantity IN PA_PLSQL_DATATYPES.Char30TabTyp ,
70: P_Non_labor_resource IN PA_PLSQL_DATATYPES.Char20TabTyp ,
71: P_Prvdr_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
72: P_Recvr_org_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
73: P_Recvr_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
74: P_Expnd_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
67: IN PA_PLSQL_DATATYPES.Char30TabTyp ,
68: P_Raw_revenue_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
69: P_Quantity IN PA_PLSQL_DATATYPES.Char30TabTyp ,
70: P_Non_labor_resource IN PA_PLSQL_DATATYPES.Char20TabTyp ,
71: P_Prvdr_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
72: P_Recvr_org_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
73: P_Recvr_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
74: P_Expnd_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
75: P_NL_resource_organization
68: P_Raw_revenue_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
69: P_Quantity IN PA_PLSQL_DATATYPES.Char30TabTyp ,
70: P_Non_labor_resource IN PA_PLSQL_DATATYPES.Char20TabTyp ,
71: P_Prvdr_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
72: P_Recvr_org_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
73: P_Recvr_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
74: P_Expnd_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
75: P_NL_resource_organization
76: IN PA_PLSQL_DATATYPES.IdTabTyp ,
69: P_Quantity IN PA_PLSQL_DATATYPES.Char30TabTyp ,
70: P_Non_labor_resource IN PA_PLSQL_DATATYPES.Char20TabTyp ,
71: P_Prvdr_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
72: P_Recvr_org_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
73: P_Recvr_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
74: P_Expnd_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
75: P_NL_resource_organization
76: IN PA_PLSQL_DATATYPES.IdTabTyp ,
77: P_Incurred_by_person_id
70: P_Non_labor_resource IN PA_PLSQL_DATATYPES.Char20TabTyp ,
71: P_Prvdr_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
72: P_Recvr_org_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
73: P_Recvr_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
74: P_Expnd_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
75: P_NL_resource_organization
76: IN PA_PLSQL_DATATYPES.IdTabTyp ,
77: P_Incurred_by_person_id
78: IN PA_PLSQL_DATATYPES.IdTabTyp ,
72: P_Recvr_org_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
73: P_Recvr_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
74: P_Expnd_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
75: P_NL_resource_organization
76: IN PA_PLSQL_DATATYPES.IdTabTyp ,
77: P_Incurred_by_person_id
78: IN PA_PLSQL_DATATYPES.IdTabTyp ,
79: P_Job_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
80: P_Denom_TP_currency_code
74: P_Expnd_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
75: P_NL_resource_organization
76: IN PA_PLSQL_DATATYPES.IdTabTyp ,
77: P_Incurred_by_person_id
78: IN PA_PLSQL_DATATYPES.IdTabTyp ,
79: P_Job_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
80: P_Denom_TP_currency_code
81: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char15TabTyp ,
82: P_Denom_transfer_price
75: P_NL_resource_organization
76: IN PA_PLSQL_DATATYPES.IdTabTyp ,
77: P_Incurred_by_person_id
78: IN PA_PLSQL_DATATYPES.IdTabTyp ,
79: P_Job_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
80: P_Denom_TP_currency_code
81: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char15TabTyp ,
82: P_Denom_transfer_price
83: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
77: P_Incurred_by_person_id
78: IN PA_PLSQL_DATATYPES.IdTabTyp ,
79: P_Job_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
80: P_Denom_TP_currency_code
81: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char15TabTyp ,
82: P_Denom_transfer_price
83: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
84: P_Acct_TP_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
85: P_Acct_TP_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
79: P_Job_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
80: P_Denom_TP_currency_code
81: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char15TabTyp ,
82: P_Denom_transfer_price
83: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
84: P_Acct_TP_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
85: P_Acct_TP_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
86: P_Acct_TP_exchange_rate
87: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
80: P_Denom_TP_currency_code
81: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char15TabTyp ,
82: P_Denom_transfer_price
83: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
84: P_Acct_TP_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
85: P_Acct_TP_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
86: P_Acct_TP_exchange_rate
87: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
88: P_Acct_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
81: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char15TabTyp ,
82: P_Denom_transfer_price
83: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
84: P_Acct_TP_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
85: P_Acct_TP_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
86: P_Acct_TP_exchange_rate
87: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
88: P_Acct_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
89: P_CC_markup_base_code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
83: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
84: P_Acct_TP_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
85: P_Acct_TP_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
86: P_Acct_TP_exchange_rate
87: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
88: P_Acct_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
89: P_CC_markup_base_code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
90: P_TP_ind_compiled_set_id
91: IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
84: P_Acct_TP_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
85: P_Acct_TP_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
86: P_Acct_TP_exchange_rate
87: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
88: P_Acct_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
89: P_CC_markup_base_code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
90: P_TP_ind_compiled_set_id
91: IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
92: P_TP_bill_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
85: P_Acct_TP_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
86: P_Acct_TP_exchange_rate
87: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
88: P_Acct_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
89: P_CC_markup_base_code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
90: P_TP_ind_compiled_set_id
91: IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
92: P_TP_bill_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
93: P_TP_base_amt IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
87: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
88: P_Acct_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
89: P_CC_markup_base_code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
90: P_TP_ind_compiled_set_id
91: IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
92: P_TP_bill_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
93: P_TP_base_amt IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
94: P_TP_bill_markup_percentage
95: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
88: P_Acct_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
89: P_CC_markup_base_code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
90: P_TP_ind_compiled_set_id
91: IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
92: P_TP_bill_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
93: P_TP_base_amt IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
94: P_TP_bill_markup_percentage
95: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
96: P_TP_schedule_line_percentage
89: P_CC_markup_base_code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
90: P_TP_ind_compiled_set_id
91: IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
92: P_TP_bill_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
93: P_TP_base_amt IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
94: P_TP_bill_markup_percentage
95: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
96: P_TP_schedule_line_percentage
97: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
91: IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
92: P_TP_bill_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
93: P_TP_base_amt IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
94: P_TP_bill_markup_percentage
95: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
96: P_TP_schedule_line_percentage
97: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
98: P_TP_rule_percentage IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
99: P_burden_disp_method IN PA_PLSQL_DATATYPES.Char1TabTyp ,
93: P_TP_base_amt IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
94: P_TP_bill_markup_percentage
95: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
96: P_TP_schedule_line_percentage
97: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
98: P_TP_rule_percentage IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
99: P_burden_disp_method IN PA_PLSQL_DATATYPES.Char1TabTyp ,
100: P_ca_prov_code IN Varchar2,
101: P_nca_prov_code IN Varchar2,
94: P_TP_bill_markup_percentage
95: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
96: P_TP_schedule_line_percentage
97: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
98: P_TP_rule_percentage IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
99: P_burden_disp_method IN PA_PLSQL_DATATYPES.Char1TabTyp ,
100: P_ca_prov_code IN Varchar2,
101: P_nca_prov_code IN Varchar2,
102: P_Processed_thru_date IN Date ,
95: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
96: P_TP_schedule_line_percentage
97: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
98: P_TP_rule_percentage IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
99: P_burden_disp_method IN PA_PLSQL_DATATYPES.Char1TabTyp ,
100: P_ca_prov_code IN Varchar2,
101: P_nca_prov_code IN Varchar2,
102: P_Processed_thru_date IN Date ,
103: P_No_of_records IN NUMBER ,
102: P_Processed_thru_date IN Date ,
103: P_No_of_records IN NUMBER ,
104: P_User_Id IN NUMBER ,
105: P_Request_id IN NUMBER ,
106: P_Error_Code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
107: P_tp_job_id IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
108: P_prov_proj_bill_job_id
109: IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
110: /*Added for cross proj*/
103: P_No_of_records IN NUMBER ,
104: P_User_Id IN NUMBER ,
105: P_Request_id IN NUMBER ,
106: P_Error_Code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
107: P_tp_job_id IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
108: P_prov_proj_bill_job_id
109: IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
110: /*Added for cross proj*/
111: P_tp_amt_type_code IN PA_PLSQL_DATATYPES.Char30TabTyp ,
105: P_Request_id IN NUMBER ,
106: P_Error_Code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
107: P_tp_job_id IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
108: P_prov_proj_bill_job_id
109: IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
110: /*Added for cross proj*/
111: P_tp_amt_type_code IN PA_PLSQL_DATATYPES.Char30TabTyp ,
112: P_projfunc_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
113: P_project_tp_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
107: P_tp_job_id IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
108: P_prov_proj_bill_job_id
109: IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
110: /*Added for cross proj*/
111: P_tp_amt_type_code IN PA_PLSQL_DATATYPES.Char30TabTyp ,
112: P_projfunc_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
113: P_project_tp_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
114: P_project_tp_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
115: P_project_tp_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
108: P_prov_proj_bill_job_id
109: IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
110: /*Added for cross proj*/
111: P_tp_amt_type_code IN PA_PLSQL_DATATYPES.Char30TabTyp ,
112: P_projfunc_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
113: P_project_tp_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
114: P_project_tp_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
115: P_project_tp_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
116: P_projfunc_tp_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
109: IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
110: /*Added for cross proj*/
111: P_tp_amt_type_code IN PA_PLSQL_DATATYPES.Char30TabTyp ,
112: P_projfunc_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
113: P_project_tp_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
114: P_project_tp_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
115: P_project_tp_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
116: P_projfunc_tp_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
117: P_projfunc_tp_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
110: /*Added for cross proj*/
111: P_tp_amt_type_code IN PA_PLSQL_DATATYPES.Char30TabTyp ,
112: P_projfunc_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
113: P_project_tp_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
114: P_project_tp_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
115: P_project_tp_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
116: P_projfunc_tp_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
117: P_projfunc_tp_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
118: P_projfunc_tp_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
111: P_tp_amt_type_code IN PA_PLSQL_DATATYPES.Char30TabTyp ,
112: P_projfunc_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
113: P_project_tp_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
114: P_project_tp_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
115: P_project_tp_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
116: P_projfunc_tp_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
117: P_projfunc_tp_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
118: P_projfunc_tp_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
119: P_assignment_id IN PA_PLSQL_DATATYPES.IdTabTyp,
112: P_projfunc_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
113: P_project_tp_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
114: P_project_tp_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
115: P_project_tp_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
116: P_projfunc_tp_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
117: P_projfunc_tp_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
118: P_projfunc_tp_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
119: P_assignment_id IN PA_PLSQL_DATATYPES.IdTabTyp,
120: P_project_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
113: P_project_tp_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
114: P_project_tp_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
115: P_project_tp_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
116: P_projfunc_tp_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
117: P_projfunc_tp_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
118: P_projfunc_tp_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
119: P_assignment_id IN PA_PLSQL_DATATYPES.IdTabTyp,
120: P_project_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
121: P_projfunc_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
114: P_project_tp_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
115: P_project_tp_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
116: P_projfunc_tp_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
117: P_projfunc_tp_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
118: P_projfunc_tp_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
119: P_assignment_id IN PA_PLSQL_DATATYPES.IdTabTyp,
120: P_project_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
121: P_projfunc_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
122: /*End for cross proj*/
115: P_project_tp_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
116: P_projfunc_tp_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
117: P_projfunc_tp_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
118: P_projfunc_tp_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
119: P_assignment_id IN PA_PLSQL_DATATYPES.IdTabTyp,
120: P_project_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
121: P_projfunc_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
122: /*End for cross proj*/
123: /* Bill rate Discount*/
116: P_projfunc_tp_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
117: P_projfunc_tp_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
118: P_projfunc_tp_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
119: P_assignment_id IN PA_PLSQL_DATATYPES.IdTabTyp,
120: P_project_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
121: P_projfunc_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
122: /*End for cross proj*/
123: /* Bill rate Discount*/
124: p_dist_rule IN PA_PLSQL_DATATYPES.Char30TabTyp,
117: P_projfunc_tp_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
118: P_projfunc_tp_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
119: P_assignment_id IN PA_PLSQL_DATATYPES.IdTabTyp,
120: P_project_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
121: P_projfunc_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
122: /*End for cross proj*/
123: /* Bill rate Discount*/
124: p_dist_rule IN PA_PLSQL_DATATYPES.Char30TabTyp,
125: p_mcb_flag IN PA_PLSQL_DATATYPES.Char1TabTyp,
120: P_project_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
121: P_projfunc_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
122: /*End for cross proj*/
123: /* Bill rate Discount*/
124: p_dist_rule IN PA_PLSQL_DATATYPES.Char30TabTyp,
125: p_mcb_flag IN PA_PLSQL_DATATYPES.Char1TabTyp,
126: p_bill_rate_multiplier IN PA_PLSQL_DATATYPES.Char30TabTyp,
127: p_raw_cost IN PA_PLSQL_DATATYPES.Char30TabTyp,
128: /* p_labor_schdl_discnt IN PA_PLSQL_DATATYPES.NumTabTyp, Commented for bug 3252190 */
121: P_projfunc_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
122: /*End for cross proj*/
123: /* Bill rate Discount*/
124: p_dist_rule IN PA_PLSQL_DATATYPES.Char30TabTyp,
125: p_mcb_flag IN PA_PLSQL_DATATYPES.Char1TabTyp,
126: p_bill_rate_multiplier IN PA_PLSQL_DATATYPES.Char30TabTyp,
127: p_raw_cost IN PA_PLSQL_DATATYPES.Char30TabTyp,
128: /* p_labor_schdl_discnt IN PA_PLSQL_DATATYPES.NumTabTyp, Commented for bug 3252190 */
129: p_labor_schdl_discnt IN PA_PLSQL_DATATYPES.Char30TabTyp, /* Changed the data type from Num to char for bug3252190 */
122: /*End for cross proj*/
123: /* Bill rate Discount*/
124: p_dist_rule IN PA_PLSQL_DATATYPES.Char30TabTyp,
125: p_mcb_flag IN PA_PLSQL_DATATYPES.Char1TabTyp,
126: p_bill_rate_multiplier IN PA_PLSQL_DATATYPES.Char30TabTyp,
127: p_raw_cost IN PA_PLSQL_DATATYPES.Char30TabTyp,
128: /* p_labor_schdl_discnt IN PA_PLSQL_DATATYPES.NumTabTyp, Commented for bug 3252190 */
129: p_labor_schdl_discnt IN PA_PLSQL_DATATYPES.Char30TabTyp, /* Changed the data type from Num to char for bug3252190 */
130: p_labor_schdl_fixed_date IN PA_PLSQL_DATATYPES.Char30TabTyp,
123: /* Bill rate Discount*/
124: p_dist_rule IN PA_PLSQL_DATATYPES.Char30TabTyp,
125: p_mcb_flag IN PA_PLSQL_DATATYPES.Char1TabTyp,
126: p_bill_rate_multiplier IN PA_PLSQL_DATATYPES.Char30TabTyp,
127: p_raw_cost IN PA_PLSQL_DATATYPES.Char30TabTyp,
128: /* p_labor_schdl_discnt IN PA_PLSQL_DATATYPES.NumTabTyp, Commented for bug 3252190 */
129: p_labor_schdl_discnt IN PA_PLSQL_DATATYPES.Char30TabTyp, /* Changed the data type from Num to char for bug3252190 */
130: p_labor_schdl_fixed_date IN PA_PLSQL_DATATYPES.Char30TabTyp,
131: p_bill_job_grp_id IN PA_PLSQL_DATATYPES.NumTabTyp,
124: p_dist_rule IN PA_PLSQL_DATATYPES.Char30TabTyp,
125: p_mcb_flag IN PA_PLSQL_DATATYPES.Char1TabTyp,
126: p_bill_rate_multiplier IN PA_PLSQL_DATATYPES.Char30TabTyp,
127: p_raw_cost IN PA_PLSQL_DATATYPES.Char30TabTyp,
128: /* p_labor_schdl_discnt IN PA_PLSQL_DATATYPES.NumTabTyp, Commented for bug 3252190 */
129: p_labor_schdl_discnt IN PA_PLSQL_DATATYPES.Char30TabTyp, /* Changed the data type from Num to char for bug3252190 */
130: p_labor_schdl_fixed_date IN PA_PLSQL_DATATYPES.Char30TabTyp,
131: p_bill_job_grp_id IN PA_PLSQL_DATATYPES.NumTabTyp,
132: p_labor_sch_type IN PA_PLSQL_DATATYPES.Char1TabTyp,
125: p_mcb_flag IN PA_PLSQL_DATATYPES.Char1TabTyp,
126: p_bill_rate_multiplier IN PA_PLSQL_DATATYPES.Char30TabTyp,
127: p_raw_cost IN PA_PLSQL_DATATYPES.Char30TabTyp,
128: /* p_labor_schdl_discnt IN PA_PLSQL_DATATYPES.NumTabTyp, Commented for bug 3252190 */
129: p_labor_schdl_discnt IN PA_PLSQL_DATATYPES.Char30TabTyp, /* Changed the data type from Num to char for bug3252190 */
130: p_labor_schdl_fixed_date IN PA_PLSQL_DATATYPES.Char30TabTyp,
131: p_bill_job_grp_id IN PA_PLSQL_DATATYPES.NumTabTyp,
132: p_labor_sch_type IN PA_PLSQL_DATATYPES.Char1TabTyp,
133: p_project_org_id IN PA_PLSQL_DATATYPES.NumTabTyp ,
126: p_bill_rate_multiplier IN PA_PLSQL_DATATYPES.Char30TabTyp,
127: p_raw_cost IN PA_PLSQL_DATATYPES.Char30TabTyp,
128: /* p_labor_schdl_discnt IN PA_PLSQL_DATATYPES.NumTabTyp, Commented for bug 3252190 */
129: p_labor_schdl_discnt IN PA_PLSQL_DATATYPES.Char30TabTyp, /* Changed the data type from Num to char for bug3252190 */
130: p_labor_schdl_fixed_date IN PA_PLSQL_DATATYPES.Char30TabTyp,
131: p_bill_job_grp_id IN PA_PLSQL_DATATYPES.NumTabTyp,
132: p_labor_sch_type IN PA_PLSQL_DATATYPES.Char1TabTyp,
133: p_project_org_id IN PA_PLSQL_DATATYPES.NumTabTyp ,
134: p_project_type IN PA_PLSQL_DATATYPES.Char30TabTyp,
127: p_raw_cost IN PA_PLSQL_DATATYPES.Char30TabTyp,
128: /* p_labor_schdl_discnt IN PA_PLSQL_DATATYPES.NumTabTyp, Commented for bug 3252190 */
129: p_labor_schdl_discnt IN PA_PLSQL_DATATYPES.Char30TabTyp, /* Changed the data type from Num to char for bug3252190 */
130: p_labor_schdl_fixed_date IN PA_PLSQL_DATATYPES.Char30TabTyp,
131: p_bill_job_grp_id IN PA_PLSQL_DATATYPES.NumTabTyp,
132: p_labor_sch_type IN PA_PLSQL_DATATYPES.Char1TabTyp,
133: p_project_org_id IN PA_PLSQL_DATATYPES.NumTabTyp ,
134: p_project_type IN PA_PLSQL_DATATYPES.Char30TabTyp,
135: p_exp_func_curr_code IN PA_PLSQL_DATATYPES.Char30TabTyp,
128: /* p_labor_schdl_discnt IN PA_PLSQL_DATATYPES.NumTabTyp, Commented for bug 3252190 */
129: p_labor_schdl_discnt IN PA_PLSQL_DATATYPES.Char30TabTyp, /* Changed the data type from Num to char for bug3252190 */
130: p_labor_schdl_fixed_date IN PA_PLSQL_DATATYPES.Char30TabTyp,
131: p_bill_job_grp_id IN PA_PLSQL_DATATYPES.NumTabTyp,
132: p_labor_sch_type IN PA_PLSQL_DATATYPES.Char1TabTyp,
133: p_project_org_id IN PA_PLSQL_DATATYPES.NumTabTyp ,
134: p_project_type IN PA_PLSQL_DATATYPES.Char30TabTyp,
135: p_exp_func_curr_code IN PA_PLSQL_DATATYPES.Char30TabTyp,
136: p_incurred_by_organz_id IN PA_PLSQL_DATATYPES.NumTabTyp,
129: p_labor_schdl_discnt IN PA_PLSQL_DATATYPES.Char30TabTyp, /* Changed the data type from Num to char for bug3252190 */
130: p_labor_schdl_fixed_date IN PA_PLSQL_DATATYPES.Char30TabTyp,
131: p_bill_job_grp_id IN PA_PLSQL_DATATYPES.NumTabTyp,
132: p_labor_sch_type IN PA_PLSQL_DATATYPES.Char1TabTyp,
133: p_project_org_id IN PA_PLSQL_DATATYPES.NumTabTyp ,
134: p_project_type IN PA_PLSQL_DATATYPES.Char30TabTyp,
135: p_exp_func_curr_code IN PA_PLSQL_DATATYPES.Char30TabTyp,
136: p_incurred_by_organz_id IN PA_PLSQL_DATATYPES.NumTabTyp,
137: p_raw_cost_rate IN PA_PLSQL_DATATYPES.Char30TabTyp,
130: p_labor_schdl_fixed_date IN PA_PLSQL_DATATYPES.Char30TabTyp,
131: p_bill_job_grp_id IN PA_PLSQL_DATATYPES.NumTabTyp,
132: p_labor_sch_type IN PA_PLSQL_DATATYPES.Char1TabTyp,
133: p_project_org_id IN PA_PLSQL_DATATYPES.NumTabTyp ,
134: p_project_type IN PA_PLSQL_DATATYPES.Char30TabTyp,
135: p_exp_func_curr_code IN PA_PLSQL_DATATYPES.Char30TabTyp,
136: p_incurred_by_organz_id IN PA_PLSQL_DATATYPES.NumTabTyp,
137: p_raw_cost_rate IN PA_PLSQL_DATATYPES.Char30TabTyp,
138: p_override_to_organz_id IN PA_PLSQL_DATATYPES.NumTabTyp,
131: p_bill_job_grp_id IN PA_PLSQL_DATATYPES.NumTabTyp,
132: p_labor_sch_type IN PA_PLSQL_DATATYPES.Char1TabTyp,
133: p_project_org_id IN PA_PLSQL_DATATYPES.NumTabTyp ,
134: p_project_type IN PA_PLSQL_DATATYPES.Char30TabTyp,
135: p_exp_func_curr_code IN PA_PLSQL_DATATYPES.Char30TabTyp,
136: p_incurred_by_organz_id IN PA_PLSQL_DATATYPES.NumTabTyp,
137: p_raw_cost_rate IN PA_PLSQL_DATATYPES.Char30TabTyp,
138: p_override_to_organz_id IN PA_PLSQL_DATATYPES.NumTabTyp,
139: p_emp_bill_rate_schedule_id IN PA_PLSQL_DATATYPES.NumTabTyp,
132: p_labor_sch_type IN PA_PLSQL_DATATYPES.Char1TabTyp,
133: p_project_org_id IN PA_PLSQL_DATATYPES.NumTabTyp ,
134: p_project_type IN PA_PLSQL_DATATYPES.Char30TabTyp,
135: p_exp_func_curr_code IN PA_PLSQL_DATATYPES.Char30TabTyp,
136: p_incurred_by_organz_id IN PA_PLSQL_DATATYPES.NumTabTyp,
137: p_raw_cost_rate IN PA_PLSQL_DATATYPES.Char30TabTyp,
138: p_override_to_organz_id IN PA_PLSQL_DATATYPES.NumTabTyp,
139: p_emp_bill_rate_schedule_id IN PA_PLSQL_DATATYPES.NumTabTyp,
140: p_job_bill_rate_schedule_id IN PA_PLSQL_DATATYPES.NumTabTyp,
133: p_project_org_id IN PA_PLSQL_DATATYPES.NumTabTyp ,
134: p_project_type IN PA_PLSQL_DATATYPES.Char30TabTyp,
135: p_exp_func_curr_code IN PA_PLSQL_DATATYPES.Char30TabTyp,
136: p_incurred_by_organz_id IN PA_PLSQL_DATATYPES.NumTabTyp,
137: p_raw_cost_rate IN PA_PLSQL_DATATYPES.Char30TabTyp,
138: p_override_to_organz_id IN PA_PLSQL_DATATYPES.NumTabTyp,
139: p_emp_bill_rate_schedule_id IN PA_PLSQL_DATATYPES.NumTabTyp,
140: p_job_bill_rate_schedule_id IN PA_PLSQL_DATATYPES.NumTabTyp,
141: p_exp_raw_cost IN PA_PLSQL_DATATYPES.Char30TabTyp,
134: p_project_type IN PA_PLSQL_DATATYPES.Char30TabTyp,
135: p_exp_func_curr_code IN PA_PLSQL_DATATYPES.Char30TabTyp,
136: p_incurred_by_organz_id IN PA_PLSQL_DATATYPES.NumTabTyp,
137: p_raw_cost_rate IN PA_PLSQL_DATATYPES.Char30TabTyp,
138: p_override_to_organz_id IN PA_PLSQL_DATATYPES.NumTabTyp,
139: p_emp_bill_rate_schedule_id IN PA_PLSQL_DATATYPES.NumTabTyp,
140: p_job_bill_rate_schedule_id IN PA_PLSQL_DATATYPES.NumTabTyp,
141: p_exp_raw_cost IN PA_PLSQL_DATATYPES.Char30TabTyp,
142: p_assignment_precedes_task IN PA_PLSQL_DATATYPES.Char1TabTyp,
135: p_exp_func_curr_code IN PA_PLSQL_DATATYPES.Char30TabTyp,
136: p_incurred_by_organz_id IN PA_PLSQL_DATATYPES.NumTabTyp,
137: p_raw_cost_rate IN PA_PLSQL_DATATYPES.Char30TabTyp,
138: p_override_to_organz_id IN PA_PLSQL_DATATYPES.NumTabTyp,
139: p_emp_bill_rate_schedule_id IN PA_PLSQL_DATATYPES.NumTabTyp,
140: p_job_bill_rate_schedule_id IN PA_PLSQL_DATATYPES.NumTabTyp,
141: p_exp_raw_cost IN PA_PLSQL_DATATYPES.Char30TabTyp,
142: p_assignment_precedes_task IN PA_PLSQL_DATATYPES.Char1TabTyp,
143:
136: p_incurred_by_organz_id IN PA_PLSQL_DATATYPES.NumTabTyp,
137: p_raw_cost_rate IN PA_PLSQL_DATATYPES.Char30TabTyp,
138: p_override_to_organz_id IN PA_PLSQL_DATATYPES.NumTabTyp,
139: p_emp_bill_rate_schedule_id IN PA_PLSQL_DATATYPES.NumTabTyp,
140: p_job_bill_rate_schedule_id IN PA_PLSQL_DATATYPES.NumTabTyp,
141: p_exp_raw_cost IN PA_PLSQL_DATATYPES.Char30TabTyp,
142: p_assignment_precedes_task IN PA_PLSQL_DATATYPES.Char1TabTyp,
143:
144: p_burden_cost IN PA_PLSQL_DATATYPES.Char30TabTyp,
137: p_raw_cost_rate IN PA_PLSQL_DATATYPES.Char30TabTyp,
138: p_override_to_organz_id IN PA_PLSQL_DATATYPES.NumTabTyp,
139: p_emp_bill_rate_schedule_id IN PA_PLSQL_DATATYPES.NumTabTyp,
140: p_job_bill_rate_schedule_id IN PA_PLSQL_DATATYPES.NumTabTyp,
141: p_exp_raw_cost IN PA_PLSQL_DATATYPES.Char30TabTyp,
142: p_assignment_precedes_task IN PA_PLSQL_DATATYPES.Char1TabTyp,
143:
144: p_burden_cost IN PA_PLSQL_DATATYPES.Char30TabTyp,
145: p_task_nl_bill_rate_org_id IN PA_PLSQL_DATATYPES.IdTabTyp,
138: p_override_to_organz_id IN PA_PLSQL_DATATYPES.NumTabTyp,
139: p_emp_bill_rate_schedule_id IN PA_PLSQL_DATATYPES.NumTabTyp,
140: p_job_bill_rate_schedule_id IN PA_PLSQL_DATATYPES.NumTabTyp,
141: p_exp_raw_cost IN PA_PLSQL_DATATYPES.Char30TabTyp,
142: p_assignment_precedes_task IN PA_PLSQL_DATATYPES.Char1TabTyp,
143:
144: p_burden_cost IN PA_PLSQL_DATATYPES.Char30TabTyp,
145: p_task_nl_bill_rate_org_id IN PA_PLSQL_DATATYPES.IdTabTyp,
146: p_proj_nl_bill_rate_org_id IN PA_PLSQL_DATATYPES.IdTabTyp,
140: p_job_bill_rate_schedule_id IN PA_PLSQL_DATATYPES.NumTabTyp,
141: p_exp_raw_cost IN PA_PLSQL_DATATYPES.Char30TabTyp,
142: p_assignment_precedes_task IN PA_PLSQL_DATATYPES.Char1TabTyp,
143:
144: p_burden_cost IN PA_PLSQL_DATATYPES.Char30TabTyp,
145: p_task_nl_bill_rate_org_id IN PA_PLSQL_DATATYPES.IdTabTyp,
146: p_proj_nl_bill_rate_org_id IN PA_PLSQL_DATATYPES.IdTabTyp,
147: p_task_nl_std_bill_rate_sch IN PA_PLSQL_DATATYPES.Char30TabTyp,
148: p_proj_nl_std_bill_rate_sch IN PA_PLSQL_DATATYPES.Char30TabTyp,
141: p_exp_raw_cost IN PA_PLSQL_DATATYPES.Char30TabTyp,
142: p_assignment_precedes_task IN PA_PLSQL_DATATYPES.Char1TabTyp,
143:
144: p_burden_cost IN PA_PLSQL_DATATYPES.Char30TabTyp,
145: p_task_nl_bill_rate_org_id IN PA_PLSQL_DATATYPES.IdTabTyp,
146: p_proj_nl_bill_rate_org_id IN PA_PLSQL_DATATYPES.IdTabTyp,
147: p_task_nl_std_bill_rate_sch IN PA_PLSQL_DATATYPES.Char30TabTyp,
148: p_proj_nl_std_bill_rate_sch IN PA_PLSQL_DATATYPES.Char30TabTyp,
149: p_nl_sch_type IN PA_PLSQL_DATATYPES.Char1TabTyp,
142: p_assignment_precedes_task IN PA_PLSQL_DATATYPES.Char1TabTyp,
143:
144: p_burden_cost IN PA_PLSQL_DATATYPES.Char30TabTyp,
145: p_task_nl_bill_rate_org_id IN PA_PLSQL_DATATYPES.IdTabTyp,
146: p_proj_nl_bill_rate_org_id IN PA_PLSQL_DATATYPES.IdTabTyp,
147: p_task_nl_std_bill_rate_sch IN PA_PLSQL_DATATYPES.Char30TabTyp,
148: p_proj_nl_std_bill_rate_sch IN PA_PLSQL_DATATYPES.Char30TabTyp,
149: p_nl_sch_type IN PA_PLSQL_DATATYPES.Char1TabTyp,
150: p_nl_task_sch_date IN PA_PLSQL_DATATYPES.Char30TabTyp,
143:
144: p_burden_cost IN PA_PLSQL_DATATYPES.Char30TabTyp,
145: p_task_nl_bill_rate_org_id IN PA_PLSQL_DATATYPES.IdTabTyp,
146: p_proj_nl_bill_rate_org_id IN PA_PLSQL_DATATYPES.IdTabTyp,
147: p_task_nl_std_bill_rate_sch IN PA_PLSQL_DATATYPES.Char30TabTyp,
148: p_proj_nl_std_bill_rate_sch IN PA_PLSQL_DATATYPES.Char30TabTyp,
149: p_nl_sch_type IN PA_PLSQL_DATATYPES.Char1TabTyp,
150: p_nl_task_sch_date IN PA_PLSQL_DATATYPES.Char30TabTyp,
151: p_nl_proj_sch_date IN PA_PLSQL_DATATYPES.Char30TabTyp,
144: p_burden_cost IN PA_PLSQL_DATATYPES.Char30TabTyp,
145: p_task_nl_bill_rate_org_id IN PA_PLSQL_DATATYPES.IdTabTyp,
146: p_proj_nl_bill_rate_org_id IN PA_PLSQL_DATATYPES.IdTabTyp,
147: p_task_nl_std_bill_rate_sch IN PA_PLSQL_DATATYPES.Char30TabTyp,
148: p_proj_nl_std_bill_rate_sch IN PA_PLSQL_DATATYPES.Char30TabTyp,
149: p_nl_sch_type IN PA_PLSQL_DATATYPES.Char1TabTyp,
150: p_nl_task_sch_date IN PA_PLSQL_DATATYPES.Char30TabTyp,
151: p_nl_proj_sch_date IN PA_PLSQL_DATATYPES.Char30TabTyp,
152: p_nl_task_sch_discount IN PA_PLSQL_DATATYPES.NumTabTyp,
145: p_task_nl_bill_rate_org_id IN PA_PLSQL_DATATYPES.IdTabTyp,
146: p_proj_nl_bill_rate_org_id IN PA_PLSQL_DATATYPES.IdTabTyp,
147: p_task_nl_std_bill_rate_sch IN PA_PLSQL_DATATYPES.Char30TabTyp,
148: p_proj_nl_std_bill_rate_sch IN PA_PLSQL_DATATYPES.Char30TabTyp,
149: p_nl_sch_type IN PA_PLSQL_DATATYPES.Char1TabTyp,
150: p_nl_task_sch_date IN PA_PLSQL_DATATYPES.Char30TabTyp,
151: p_nl_proj_sch_date IN PA_PLSQL_DATATYPES.Char30TabTyp,
152: p_nl_task_sch_discount IN PA_PLSQL_DATATYPES.NumTabTyp,
153: p_nl_proj_sch_discount IN PA_PLSQL_DATATYPES.NumTabTyp,
146: p_proj_nl_bill_rate_org_id IN PA_PLSQL_DATATYPES.IdTabTyp,
147: p_task_nl_std_bill_rate_sch IN PA_PLSQL_DATATYPES.Char30TabTyp,
148: p_proj_nl_std_bill_rate_sch IN PA_PLSQL_DATATYPES.Char30TabTyp,
149: p_nl_sch_type IN PA_PLSQL_DATATYPES.Char1TabTyp,
150: p_nl_task_sch_date IN PA_PLSQL_DATATYPES.Char30TabTyp,
151: p_nl_proj_sch_date IN PA_PLSQL_DATATYPES.Char30TabTyp,
152: p_nl_task_sch_discount IN PA_PLSQL_DATATYPES.NumTabTyp,
153: p_nl_proj_sch_discount IN PA_PLSQL_DATATYPES.NumTabTyp,
154: /* Added the last two parameters for Doosan Rate api changes */
147: p_task_nl_std_bill_rate_sch IN PA_PLSQL_DATATYPES.Char30TabTyp,
148: p_proj_nl_std_bill_rate_sch IN PA_PLSQL_DATATYPES.Char30TabTyp,
149: p_nl_sch_type IN PA_PLSQL_DATATYPES.Char1TabTyp,
150: p_nl_task_sch_date IN PA_PLSQL_DATATYPES.Char30TabTyp,
151: p_nl_proj_sch_date IN PA_PLSQL_DATATYPES.Char30TabTyp,
152: p_nl_task_sch_discount IN PA_PLSQL_DATATYPES.NumTabTyp,
153: p_nl_proj_sch_discount IN PA_PLSQL_DATATYPES.NumTabTyp,
154: /* Added the last two parameters for Doosan Rate api changes */
155: p_task_nl_std_bill_rate_sch_id IN PA_PLSQL_DATATYPES.NumTabTyp DEFAULT PA_PLSQL_DATATYPES.EmptyNumTab,
148: p_proj_nl_std_bill_rate_sch IN PA_PLSQL_DATATYPES.Char30TabTyp,
149: p_nl_sch_type IN PA_PLSQL_DATATYPES.Char1TabTyp,
150: p_nl_task_sch_date IN PA_PLSQL_DATATYPES.Char30TabTyp,
151: p_nl_proj_sch_date IN PA_PLSQL_DATATYPES.Char30TabTyp,
152: p_nl_task_sch_discount IN PA_PLSQL_DATATYPES.NumTabTyp,
153: p_nl_proj_sch_discount IN PA_PLSQL_DATATYPES.NumTabTyp,
154: /* Added the last two parameters for Doosan Rate api changes */
155: p_task_nl_std_bill_rate_sch_id IN PA_PLSQL_DATATYPES.NumTabTyp DEFAULT PA_PLSQL_DATATYPES.EmptyNumTab,
156: p_proj_nl_std_bill_rate_sch_id IN PA_PLSQL_DATATYPES.NumTabTyp DEFAULT PA_PLSQL_DATATYPES.EmptyNumTab,
149: p_nl_sch_type IN PA_PLSQL_DATATYPES.Char1TabTyp,
150: p_nl_task_sch_date IN PA_PLSQL_DATATYPES.Char30TabTyp,
151: p_nl_proj_sch_date IN PA_PLSQL_DATATYPES.Char30TabTyp,
152: p_nl_task_sch_discount IN PA_PLSQL_DATATYPES.NumTabTyp,
153: p_nl_proj_sch_discount IN PA_PLSQL_DATATYPES.NumTabTyp,
154: /* Added the last two parameters for Doosan Rate api changes */
155: p_task_nl_std_bill_rate_sch_id IN PA_PLSQL_DATATYPES.NumTabTyp DEFAULT PA_PLSQL_DATATYPES.EmptyNumTab,
156: p_proj_nl_std_bill_rate_sch_id IN PA_PLSQL_DATATYPES.NumTabTyp DEFAULT PA_PLSQL_DATATYPES.EmptyNumTab,
157: p_uom_flag IN PA_PLSQL_DATATYPES.NumTabTyp
151: p_nl_proj_sch_date IN PA_PLSQL_DATATYPES.Char30TabTyp,
152: p_nl_task_sch_discount IN PA_PLSQL_DATATYPES.NumTabTyp,
153: p_nl_proj_sch_discount IN PA_PLSQL_DATATYPES.NumTabTyp,
154: /* Added the last two parameters for Doosan Rate api changes */
155: p_task_nl_std_bill_rate_sch_id IN PA_PLSQL_DATATYPES.NumTabTyp DEFAULT PA_PLSQL_DATATYPES.EmptyNumTab,
156: p_proj_nl_std_bill_rate_sch_id IN PA_PLSQL_DATATYPES.NumTabTyp DEFAULT PA_PLSQL_DATATYPES.EmptyNumTab,
157: p_uom_flag IN PA_PLSQL_DATATYPES.NumTabTyp
158: DEFAULT PA_PLSQL_DATATYPES.EmptyNumTab
159: );
152: p_nl_task_sch_discount IN PA_PLSQL_DATATYPES.NumTabTyp,
153: p_nl_proj_sch_discount IN PA_PLSQL_DATATYPES.NumTabTyp,
154: /* Added the last two parameters for Doosan Rate api changes */
155: p_task_nl_std_bill_rate_sch_id IN PA_PLSQL_DATATYPES.NumTabTyp DEFAULT PA_PLSQL_DATATYPES.EmptyNumTab,
156: p_proj_nl_std_bill_rate_sch_id IN PA_PLSQL_DATATYPES.NumTabTyp DEFAULT PA_PLSQL_DATATYPES.EmptyNumTab,
157: p_uom_flag IN PA_PLSQL_DATATYPES.NumTabTyp
158: DEFAULT PA_PLSQL_DATATYPES.EmptyNumTab
159: );
160:
153: p_nl_proj_sch_discount IN PA_PLSQL_DATATYPES.NumTabTyp,
154: /* Added the last two parameters for Doosan Rate api changes */
155: p_task_nl_std_bill_rate_sch_id IN PA_PLSQL_DATATYPES.NumTabTyp DEFAULT PA_PLSQL_DATATYPES.EmptyNumTab,
156: p_proj_nl_std_bill_rate_sch_id IN PA_PLSQL_DATATYPES.NumTabTyp DEFAULT PA_PLSQL_DATATYPES.EmptyNumTab,
157: p_uom_flag IN PA_PLSQL_DATATYPES.NumTabTyp
158: DEFAULT PA_PLSQL_DATATYPES.EmptyNumTab
159: );
160:
161: /* !!!!This is overloaded procedure for compilation of pro*c files of Patchset H */
154: /* Added the last two parameters for Doosan Rate api changes */
155: p_task_nl_std_bill_rate_sch_id IN PA_PLSQL_DATATYPES.NumTabTyp DEFAULT PA_PLSQL_DATATYPES.EmptyNumTab,
156: p_proj_nl_std_bill_rate_sch_id IN PA_PLSQL_DATATYPES.NumTabTyp DEFAULT PA_PLSQL_DATATYPES.EmptyNumTab,
157: p_uom_flag IN PA_PLSQL_DATATYPES.NumTabTyp
158: DEFAULT PA_PLSQL_DATATYPES.EmptyNumTab
159: );
160:
161: /* !!!!This is overloaded procedure for compilation of pro*c files of Patchset H */
162: /* !!!!Note: This .pls with overload function should not be sent along with the patch for Patchset H customers */
166: P_Bill_to_site_use_id IN number,
167: P_Ship_to_site_use_id IN number ,
168: P_Set_of_books_id IN number ,
169: P_Acct_curr_code IN varchar2 ,
170: P_Expenditure_category IN PA_PLSQL_DATATYPES.Char30TabTyp,
171: P_CC_Project_Id IN PA_PLSQL_DATATYPES.IdTabTyp ,
172: P_CC_Tax_task_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
173: P_EI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
174: P_AdjEI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
167: P_Ship_to_site_use_id IN number ,
168: P_Set_of_books_id IN number ,
169: P_Acct_curr_code IN varchar2 ,
170: P_Expenditure_category IN PA_PLSQL_DATATYPES.Char30TabTyp,
171: P_CC_Project_Id IN PA_PLSQL_DATATYPES.IdTabTyp ,
172: P_CC_Tax_task_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
173: P_EI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
174: P_AdjEI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
175: P_Net_zero_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
168: P_Set_of_books_id IN number ,
169: P_Acct_curr_code IN varchar2 ,
170: P_Expenditure_category IN PA_PLSQL_DATATYPES.Char30TabTyp,
171: P_CC_Project_Id IN PA_PLSQL_DATATYPES.IdTabTyp ,
172: P_CC_Tax_task_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
173: P_EI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
174: P_AdjEI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
175: P_Net_zero_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
176: P_TP_sch_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
169: P_Acct_curr_code IN varchar2 ,
170: P_Expenditure_category IN PA_PLSQL_DATATYPES.Char30TabTyp,
171: P_CC_Project_Id IN PA_PLSQL_DATATYPES.IdTabTyp ,
172: P_CC_Tax_task_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
173: P_EI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
174: P_AdjEI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
175: P_Net_zero_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
176: P_TP_sch_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
177: P_revenue_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
170: P_Expenditure_category IN PA_PLSQL_DATATYPES.Char30TabTyp,
171: P_CC_Project_Id IN PA_PLSQL_DATATYPES.IdTabTyp ,
172: P_CC_Tax_task_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
173: P_EI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
174: P_AdjEI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
175: P_Net_zero_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
176: P_TP_sch_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
177: P_revenue_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
178: P_provider_cr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
171: P_CC_Project_Id IN PA_PLSQL_DATATYPES.IdTabTyp ,
172: P_CC_Tax_task_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
173: P_EI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
174: P_AdjEI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
175: P_Net_zero_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
176: P_TP_sch_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
177: P_revenue_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
178: P_provider_cr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
179: P_provider_dr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
172: P_CC_Tax_task_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
173: P_EI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
174: P_AdjEI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
175: P_Net_zero_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
176: P_TP_sch_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
177: P_revenue_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
178: P_provider_cr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
179: P_provider_dr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
180: P_Task_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
173: P_EI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
174: P_AdjEI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
175: P_Net_zero_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
176: P_TP_sch_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
177: P_revenue_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
178: P_provider_cr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
179: P_provider_dr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
180: P_Task_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
181: P_Cross_charge_code IN PA_PLSQL_DATATYPES.Char1TabTyp ,
174: P_AdjEI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
175: P_Net_zero_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
176: P_TP_sch_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
177: P_revenue_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
178: P_provider_cr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
179: P_provider_dr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
180: P_Task_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
181: P_Cross_charge_code IN PA_PLSQL_DATATYPES.Char1TabTyp ,
182: P_Labor_nl_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
175: P_Net_zero_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
176: P_TP_sch_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
177: P_revenue_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
178: P_provider_cr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
179: P_provider_dr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
180: P_Task_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
181: P_Cross_charge_code IN PA_PLSQL_DATATYPES.Char1TabTyp ,
182: P_Labor_nl_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
183: P_Revenue_distributed_flag
176: P_TP_sch_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
177: P_revenue_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
178: P_provider_cr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
179: P_provider_dr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
180: P_Task_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
181: P_Cross_charge_code IN PA_PLSQL_DATATYPES.Char1TabTyp ,
182: P_Labor_nl_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
183: P_Revenue_distributed_flag
184: IN PA_PLSQL_DATATYPES.Char1TabTyp ,
177: P_revenue_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
178: P_provider_cr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
179: P_provider_dr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
180: P_Task_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
181: P_Cross_charge_code IN PA_PLSQL_DATATYPES.Char1TabTyp ,
182: P_Labor_nl_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
183: P_Revenue_distributed_flag
184: IN PA_PLSQL_DATATYPES.Char1TabTyp ,
185: P_Expend_type IN PA_PLSQL_DATATYPES.Char30TabTyp ,
178: P_provider_cr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
179: P_provider_dr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
180: P_Task_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
181: P_Cross_charge_code IN PA_PLSQL_DATATYPES.Char1TabTyp ,
182: P_Labor_nl_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
183: P_Revenue_distributed_flag
184: IN PA_PLSQL_DATATYPES.Char1TabTyp ,
185: P_Expend_type IN PA_PLSQL_DATATYPES.Char30TabTyp ,
186: P_EI_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
180: P_Task_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
181: P_Cross_charge_code IN PA_PLSQL_DATATYPES.Char1TabTyp ,
182: P_Labor_nl_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
183: P_Revenue_distributed_flag
184: IN PA_PLSQL_DATATYPES.Char1TabTyp ,
185: P_Expend_type IN PA_PLSQL_DATATYPES.Char30TabTyp ,
186: P_EI_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
187: P_Sys_linkage IN PA_PLSQL_DATATYPES.Char30TabTyp ,
188: P_Denom_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
181: P_Cross_charge_code IN PA_PLSQL_DATATYPES.Char1TabTyp ,
182: P_Labor_nl_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
183: P_Revenue_distributed_flag
184: IN PA_PLSQL_DATATYPES.Char1TabTyp ,
185: P_Expend_type IN PA_PLSQL_DATATYPES.Char30TabTyp ,
186: P_EI_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
187: P_Sys_linkage IN PA_PLSQL_DATATYPES.Char30TabTyp ,
188: P_Denom_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
189: P_Prj_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
182: P_Labor_nl_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
183: P_Revenue_distributed_flag
184: IN PA_PLSQL_DATATYPES.Char1TabTyp ,
185: P_Expend_type IN PA_PLSQL_DATATYPES.Char30TabTyp ,
186: P_EI_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
187: P_Sys_linkage IN PA_PLSQL_DATATYPES.Char30TabTyp ,
188: P_Denom_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
189: P_Prj_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
190: P_TP_fixed_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
183: P_Revenue_distributed_flag
184: IN PA_PLSQL_DATATYPES.Char1TabTyp ,
185: P_Expend_type IN PA_PLSQL_DATATYPES.Char30TabTyp ,
186: P_EI_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
187: P_Sys_linkage IN PA_PLSQL_DATATYPES.Char30TabTyp ,
188: P_Denom_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
189: P_Prj_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
190: P_TP_fixed_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
191: P_Denom_raw_cost_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
184: IN PA_PLSQL_DATATYPES.Char1TabTyp ,
185: P_Expend_type IN PA_PLSQL_DATATYPES.Char30TabTyp ,
186: P_EI_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
187: P_Sys_linkage IN PA_PLSQL_DATATYPES.Char30TabTyp ,
188: P_Denom_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
189: P_Prj_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
190: P_TP_fixed_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
191: P_Denom_raw_cost_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
192: P_Denom_burdened_cost_amt
185: P_Expend_type IN PA_PLSQL_DATATYPES.Char30TabTyp ,
186: P_EI_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
187: P_Sys_linkage IN PA_PLSQL_DATATYPES.Char30TabTyp ,
188: P_Denom_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
189: P_Prj_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
190: P_TP_fixed_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
191: P_Denom_raw_cost_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
192: P_Denom_burdened_cost_amt
193: IN PA_PLSQL_DATATYPES.Char30TabTyp ,
186: P_EI_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
187: P_Sys_linkage IN PA_PLSQL_DATATYPES.Char30TabTyp ,
188: P_Denom_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
189: P_Prj_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
190: P_TP_fixed_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
191: P_Denom_raw_cost_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
192: P_Denom_burdened_cost_amt
193: IN PA_PLSQL_DATATYPES.Char30TabTyp ,
194: P_Raw_revenue_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
187: P_Sys_linkage IN PA_PLSQL_DATATYPES.Char30TabTyp ,
188: P_Denom_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
189: P_Prj_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
190: P_TP_fixed_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
191: P_Denom_raw_cost_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
192: P_Denom_burdened_cost_amt
193: IN PA_PLSQL_DATATYPES.Char30TabTyp ,
194: P_Raw_revenue_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
195: P_Quantity IN PA_PLSQL_DATATYPES.Char30TabTyp ,
189: P_Prj_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
190: P_TP_fixed_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
191: P_Denom_raw_cost_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
192: P_Denom_burdened_cost_amt
193: IN PA_PLSQL_DATATYPES.Char30TabTyp ,
194: P_Raw_revenue_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
195: P_Quantity IN PA_PLSQL_DATATYPES.Char30TabTyp ,
196: P_Non_labor_resource IN PA_PLSQL_DATATYPES.Char20TabTyp ,
197: P_Prvdr_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
190: P_TP_fixed_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
191: P_Denom_raw_cost_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
192: P_Denom_burdened_cost_amt
193: IN PA_PLSQL_DATATYPES.Char30TabTyp ,
194: P_Raw_revenue_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
195: P_Quantity IN PA_PLSQL_DATATYPES.Char30TabTyp ,
196: P_Non_labor_resource IN PA_PLSQL_DATATYPES.Char20TabTyp ,
197: P_Prvdr_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
198: P_Recvr_org_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
191: P_Denom_raw_cost_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
192: P_Denom_burdened_cost_amt
193: IN PA_PLSQL_DATATYPES.Char30TabTyp ,
194: P_Raw_revenue_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
195: P_Quantity IN PA_PLSQL_DATATYPES.Char30TabTyp ,
196: P_Non_labor_resource IN PA_PLSQL_DATATYPES.Char20TabTyp ,
197: P_Prvdr_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
198: P_Recvr_org_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
199: P_Recvr_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
192: P_Denom_burdened_cost_amt
193: IN PA_PLSQL_DATATYPES.Char30TabTyp ,
194: P_Raw_revenue_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
195: P_Quantity IN PA_PLSQL_DATATYPES.Char30TabTyp ,
196: P_Non_labor_resource IN PA_PLSQL_DATATYPES.Char20TabTyp ,
197: P_Prvdr_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
198: P_Recvr_org_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
199: P_Recvr_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
200: P_Expnd_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
193: IN PA_PLSQL_DATATYPES.Char30TabTyp ,
194: P_Raw_revenue_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
195: P_Quantity IN PA_PLSQL_DATATYPES.Char30TabTyp ,
196: P_Non_labor_resource IN PA_PLSQL_DATATYPES.Char20TabTyp ,
197: P_Prvdr_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
198: P_Recvr_org_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
199: P_Recvr_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
200: P_Expnd_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
201: P_NL_resource_organization
194: P_Raw_revenue_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
195: P_Quantity IN PA_PLSQL_DATATYPES.Char30TabTyp ,
196: P_Non_labor_resource IN PA_PLSQL_DATATYPES.Char20TabTyp ,
197: P_Prvdr_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
198: P_Recvr_org_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
199: P_Recvr_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
200: P_Expnd_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
201: P_NL_resource_organization
202: IN PA_PLSQL_DATATYPES.IdTabTyp ,
195: P_Quantity IN PA_PLSQL_DATATYPES.Char30TabTyp ,
196: P_Non_labor_resource IN PA_PLSQL_DATATYPES.Char20TabTyp ,
197: P_Prvdr_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
198: P_Recvr_org_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
199: P_Recvr_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
200: P_Expnd_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
201: P_NL_resource_organization
202: IN PA_PLSQL_DATATYPES.IdTabTyp ,
203: P_Incurred_by_person_id
196: P_Non_labor_resource IN PA_PLSQL_DATATYPES.Char20TabTyp ,
197: P_Prvdr_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
198: P_Recvr_org_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
199: P_Recvr_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
200: P_Expnd_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
201: P_NL_resource_organization
202: IN PA_PLSQL_DATATYPES.IdTabTyp ,
203: P_Incurred_by_person_id
204: IN PA_PLSQL_DATATYPES.IdTabTyp ,
198: P_Recvr_org_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
199: P_Recvr_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
200: P_Expnd_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
201: P_NL_resource_organization
202: IN PA_PLSQL_DATATYPES.IdTabTyp ,
203: P_Incurred_by_person_id
204: IN PA_PLSQL_DATATYPES.IdTabTyp ,
205: P_Job_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
206: P_Denom_TP_currency_code
200: P_Expnd_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
201: P_NL_resource_organization
202: IN PA_PLSQL_DATATYPES.IdTabTyp ,
203: P_Incurred_by_person_id
204: IN PA_PLSQL_DATATYPES.IdTabTyp ,
205: P_Job_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
206: P_Denom_TP_currency_code
207: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char15TabTyp ,
208: P_Denom_transfer_price
201: P_NL_resource_organization
202: IN PA_PLSQL_DATATYPES.IdTabTyp ,
203: P_Incurred_by_person_id
204: IN PA_PLSQL_DATATYPES.IdTabTyp ,
205: P_Job_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
206: P_Denom_TP_currency_code
207: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char15TabTyp ,
208: P_Denom_transfer_price
209: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
203: P_Incurred_by_person_id
204: IN PA_PLSQL_DATATYPES.IdTabTyp ,
205: P_Job_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
206: P_Denom_TP_currency_code
207: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char15TabTyp ,
208: P_Denom_transfer_price
209: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
210: P_Acct_TP_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
211: P_Acct_TP_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
205: P_Job_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
206: P_Denom_TP_currency_code
207: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char15TabTyp ,
208: P_Denom_transfer_price
209: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
210: P_Acct_TP_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
211: P_Acct_TP_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
212: P_Acct_TP_exchange_rate
213: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
206: P_Denom_TP_currency_code
207: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char15TabTyp ,
208: P_Denom_transfer_price
209: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
210: P_Acct_TP_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
211: P_Acct_TP_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
212: P_Acct_TP_exchange_rate
213: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
214: P_Acct_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
207: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char15TabTyp ,
208: P_Denom_transfer_price
209: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
210: P_Acct_TP_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
211: P_Acct_TP_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
212: P_Acct_TP_exchange_rate
213: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
214: P_Acct_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
215: P_CC_markup_base_code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
209: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
210: P_Acct_TP_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
211: P_Acct_TP_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
212: P_Acct_TP_exchange_rate
213: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
214: P_Acct_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
215: P_CC_markup_base_code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
216: P_TP_ind_compiled_set_id
217: IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
210: P_Acct_TP_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
211: P_Acct_TP_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
212: P_Acct_TP_exchange_rate
213: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
214: P_Acct_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
215: P_CC_markup_base_code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
216: P_TP_ind_compiled_set_id
217: IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
218: P_TP_bill_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
211: P_Acct_TP_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
212: P_Acct_TP_exchange_rate
213: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
214: P_Acct_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
215: P_CC_markup_base_code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
216: P_TP_ind_compiled_set_id
217: IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
218: P_TP_bill_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
219: P_TP_base_amt IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
213: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
214: P_Acct_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
215: P_CC_markup_base_code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
216: P_TP_ind_compiled_set_id
217: IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
218: P_TP_bill_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
219: P_TP_base_amt IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
220: P_TP_bill_markup_percentage
221: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
214: P_Acct_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
215: P_CC_markup_base_code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
216: P_TP_ind_compiled_set_id
217: IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
218: P_TP_bill_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
219: P_TP_base_amt IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
220: P_TP_bill_markup_percentage
221: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
222: P_TP_schedule_line_percentage
215: P_CC_markup_base_code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
216: P_TP_ind_compiled_set_id
217: IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
218: P_TP_bill_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
219: P_TP_base_amt IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
220: P_TP_bill_markup_percentage
221: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
222: P_TP_schedule_line_percentage
223: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
217: IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
218: P_TP_bill_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
219: P_TP_base_amt IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
220: P_TP_bill_markup_percentage
221: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
222: P_TP_schedule_line_percentage
223: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
224: P_TP_rule_percentage IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
225: P_burden_disp_method IN PA_PLSQL_DATATYPES.Char1TabTyp ,
219: P_TP_base_amt IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
220: P_TP_bill_markup_percentage
221: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
222: P_TP_schedule_line_percentage
223: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
224: P_TP_rule_percentage IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
225: P_burden_disp_method IN PA_PLSQL_DATATYPES.Char1TabTyp ,
226: P_ca_prov_code IN Varchar2,
227: P_nca_prov_code IN Varchar2,
220: P_TP_bill_markup_percentage
221: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
222: P_TP_schedule_line_percentage
223: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
224: P_TP_rule_percentage IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
225: P_burden_disp_method IN PA_PLSQL_DATATYPES.Char1TabTyp ,
226: P_ca_prov_code IN Varchar2,
227: P_nca_prov_code IN Varchar2,
228: P_Processed_thru_date IN Date ,
221: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
222: P_TP_schedule_line_percentage
223: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
224: P_TP_rule_percentage IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
225: P_burden_disp_method IN PA_PLSQL_DATATYPES.Char1TabTyp ,
226: P_ca_prov_code IN Varchar2,
227: P_nca_prov_code IN Varchar2,
228: P_Processed_thru_date IN Date ,
229: P_No_of_records IN NUMBER ,
228: P_Processed_thru_date IN Date ,
229: P_No_of_records IN NUMBER ,
230: P_User_Id IN NUMBER ,
231: P_Request_id IN NUMBER ,
232: P_Error_Code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
233: P_tp_job_id IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
234: P_prov_proj_bill_job_id
235: IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp);
236:
229: P_No_of_records IN NUMBER ,
230: P_User_Id IN NUMBER ,
231: P_Request_id IN NUMBER ,
232: P_Error_Code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
233: P_tp_job_id IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
234: P_prov_proj_bill_job_id
235: IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp);
236:
237:
231: P_Request_id IN NUMBER ,
232: P_Error_Code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
233: P_tp_job_id IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
234: P_prov_proj_bill_job_id
235: IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp);
236:
237:
238: /* !!!!This is overloaded procedure for compilation of pro*c files of Patchset J */
239: /* !!!!Note: This .pls with overload function should not be sent along with the patch for Patchset J customers */
244: P_Bill_to_site_use_id IN number,
245: P_Ship_to_site_use_id IN number ,
246: P_Set_of_books_id IN number ,
247: P_Acct_curr_code IN varchar2 ,
248: P_Expenditure_category IN PA_PLSQL_DATATYPES.Char30TabTyp,
249: P_CC_Project_Id IN PA_PLSQL_DATATYPES.IdTabTyp ,
250: P_CC_Tax_task_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
251: P_EI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
252: P_AdjEI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
245: P_Ship_to_site_use_id IN number ,
246: P_Set_of_books_id IN number ,
247: P_Acct_curr_code IN varchar2 ,
248: P_Expenditure_category IN PA_PLSQL_DATATYPES.Char30TabTyp,
249: P_CC_Project_Id IN PA_PLSQL_DATATYPES.IdTabTyp ,
250: P_CC_Tax_task_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
251: P_EI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
252: P_AdjEI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
253: P_Net_zero_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
246: P_Set_of_books_id IN number ,
247: P_Acct_curr_code IN varchar2 ,
248: P_Expenditure_category IN PA_PLSQL_DATATYPES.Char30TabTyp,
249: P_CC_Project_Id IN PA_PLSQL_DATATYPES.IdTabTyp ,
250: P_CC_Tax_task_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
251: P_EI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
252: P_AdjEI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
253: P_Net_zero_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
254: P_TP_sch_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
247: P_Acct_curr_code IN varchar2 ,
248: P_Expenditure_category IN PA_PLSQL_DATATYPES.Char30TabTyp,
249: P_CC_Project_Id IN PA_PLSQL_DATATYPES.IdTabTyp ,
250: P_CC_Tax_task_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
251: P_EI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
252: P_AdjEI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
253: P_Net_zero_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
254: P_TP_sch_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
255: P_revenue_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
248: P_Expenditure_category IN PA_PLSQL_DATATYPES.Char30TabTyp,
249: P_CC_Project_Id IN PA_PLSQL_DATATYPES.IdTabTyp ,
250: P_CC_Tax_task_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
251: P_EI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
252: P_AdjEI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
253: P_Net_zero_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
254: P_TP_sch_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
255: P_revenue_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
256: P_provider_cr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
249: P_CC_Project_Id IN PA_PLSQL_DATATYPES.IdTabTyp ,
250: P_CC_Tax_task_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
251: P_EI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
252: P_AdjEI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
253: P_Net_zero_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
254: P_TP_sch_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
255: P_revenue_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
256: P_provider_cr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
257: P_provider_dr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
250: P_CC_Tax_task_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
251: P_EI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
252: P_AdjEI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
253: P_Net_zero_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
254: P_TP_sch_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
255: P_revenue_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
256: P_provider_cr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
257: P_provider_dr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
258: P_Task_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
251: P_EI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
252: P_AdjEI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
253: P_Net_zero_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
254: P_TP_sch_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
255: P_revenue_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
256: P_provider_cr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
257: P_provider_dr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
258: P_Task_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
259: P_Cross_charge_code IN PA_PLSQL_DATATYPES.Char1TabTyp ,
252: P_AdjEI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
253: P_Net_zero_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
254: P_TP_sch_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
255: P_revenue_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
256: P_provider_cr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
257: P_provider_dr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
258: P_Task_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
259: P_Cross_charge_code IN PA_PLSQL_DATATYPES.Char1TabTyp ,
260: P_Labor_nl_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
253: P_Net_zero_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
254: P_TP_sch_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
255: P_revenue_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
256: P_provider_cr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
257: P_provider_dr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
258: P_Task_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
259: P_Cross_charge_code IN PA_PLSQL_DATATYPES.Char1TabTyp ,
260: P_Labor_nl_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
261: P_Revenue_distributed_flag
254: P_TP_sch_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
255: P_revenue_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
256: P_provider_cr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
257: P_provider_dr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
258: P_Task_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
259: P_Cross_charge_code IN PA_PLSQL_DATATYPES.Char1TabTyp ,
260: P_Labor_nl_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
261: P_Revenue_distributed_flag
262: IN PA_PLSQL_DATATYPES.Char1TabTyp ,
255: P_revenue_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
256: P_provider_cr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
257: P_provider_dr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
258: P_Task_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
259: P_Cross_charge_code IN PA_PLSQL_DATATYPES.Char1TabTyp ,
260: P_Labor_nl_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
261: P_Revenue_distributed_flag
262: IN PA_PLSQL_DATATYPES.Char1TabTyp ,
263: P_Expend_type IN PA_PLSQL_DATATYPES.Char30TabTyp ,
256: P_provider_cr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
257: P_provider_dr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
258: P_Task_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
259: P_Cross_charge_code IN PA_PLSQL_DATATYPES.Char1TabTyp ,
260: P_Labor_nl_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
261: P_Revenue_distributed_flag
262: IN PA_PLSQL_DATATYPES.Char1TabTyp ,
263: P_Expend_type IN PA_PLSQL_DATATYPES.Char30TabTyp ,
264: P_EI_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
258: P_Task_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
259: P_Cross_charge_code IN PA_PLSQL_DATATYPES.Char1TabTyp ,
260: P_Labor_nl_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
261: P_Revenue_distributed_flag
262: IN PA_PLSQL_DATATYPES.Char1TabTyp ,
263: P_Expend_type IN PA_PLSQL_DATATYPES.Char30TabTyp ,
264: P_EI_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
265: P_Sys_linkage IN PA_PLSQL_DATATYPES.Char30TabTyp ,
266: P_Denom_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
259: P_Cross_charge_code IN PA_PLSQL_DATATYPES.Char1TabTyp ,
260: P_Labor_nl_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
261: P_Revenue_distributed_flag
262: IN PA_PLSQL_DATATYPES.Char1TabTyp ,
263: P_Expend_type IN PA_PLSQL_DATATYPES.Char30TabTyp ,
264: P_EI_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
265: P_Sys_linkage IN PA_PLSQL_DATATYPES.Char30TabTyp ,
266: P_Denom_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
267: P_Prj_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
260: P_Labor_nl_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
261: P_Revenue_distributed_flag
262: IN PA_PLSQL_DATATYPES.Char1TabTyp ,
263: P_Expend_type IN PA_PLSQL_DATATYPES.Char30TabTyp ,
264: P_EI_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
265: P_Sys_linkage IN PA_PLSQL_DATATYPES.Char30TabTyp ,
266: P_Denom_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
267: P_Prj_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
268: P_TP_fixed_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
261: P_Revenue_distributed_flag
262: IN PA_PLSQL_DATATYPES.Char1TabTyp ,
263: P_Expend_type IN PA_PLSQL_DATATYPES.Char30TabTyp ,
264: P_EI_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
265: P_Sys_linkage IN PA_PLSQL_DATATYPES.Char30TabTyp ,
266: P_Denom_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
267: P_Prj_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
268: P_TP_fixed_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
269: P_Denom_raw_cost_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
262: IN PA_PLSQL_DATATYPES.Char1TabTyp ,
263: P_Expend_type IN PA_PLSQL_DATATYPES.Char30TabTyp ,
264: P_EI_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
265: P_Sys_linkage IN PA_PLSQL_DATATYPES.Char30TabTyp ,
266: P_Denom_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
267: P_Prj_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
268: P_TP_fixed_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
269: P_Denom_raw_cost_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
270: P_Denom_burdened_cost_amt
263: P_Expend_type IN PA_PLSQL_DATATYPES.Char30TabTyp ,
264: P_EI_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
265: P_Sys_linkage IN PA_PLSQL_DATATYPES.Char30TabTyp ,
266: P_Denom_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
267: P_Prj_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
268: P_TP_fixed_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
269: P_Denom_raw_cost_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
270: P_Denom_burdened_cost_amt
271: IN PA_PLSQL_DATATYPES.Char30TabTyp ,
264: P_EI_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
265: P_Sys_linkage IN PA_PLSQL_DATATYPES.Char30TabTyp ,
266: P_Denom_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
267: P_Prj_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
268: P_TP_fixed_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
269: P_Denom_raw_cost_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
270: P_Denom_burdened_cost_amt
271: IN PA_PLSQL_DATATYPES.Char30TabTyp ,
272: P_Raw_revenue_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
265: P_Sys_linkage IN PA_PLSQL_DATATYPES.Char30TabTyp ,
266: P_Denom_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
267: P_Prj_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
268: P_TP_fixed_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
269: P_Denom_raw_cost_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
270: P_Denom_burdened_cost_amt
271: IN PA_PLSQL_DATATYPES.Char30TabTyp ,
272: P_Raw_revenue_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
273: P_Quantity IN PA_PLSQL_DATATYPES.Char30TabTyp ,
267: P_Prj_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
268: P_TP_fixed_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
269: P_Denom_raw_cost_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
270: P_Denom_burdened_cost_amt
271: IN PA_PLSQL_DATATYPES.Char30TabTyp ,
272: P_Raw_revenue_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
273: P_Quantity IN PA_PLSQL_DATATYPES.Char30TabTyp ,
274: P_Non_labor_resource IN PA_PLSQL_DATATYPES.Char20TabTyp ,
275: P_Prvdr_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
268: P_TP_fixed_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
269: P_Denom_raw_cost_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
270: P_Denom_burdened_cost_amt
271: IN PA_PLSQL_DATATYPES.Char30TabTyp ,
272: P_Raw_revenue_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
273: P_Quantity IN PA_PLSQL_DATATYPES.Char30TabTyp ,
274: P_Non_labor_resource IN PA_PLSQL_DATATYPES.Char20TabTyp ,
275: P_Prvdr_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
276: P_Recvr_org_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
269: P_Denom_raw_cost_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
270: P_Denom_burdened_cost_amt
271: IN PA_PLSQL_DATATYPES.Char30TabTyp ,
272: P_Raw_revenue_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
273: P_Quantity IN PA_PLSQL_DATATYPES.Char30TabTyp ,
274: P_Non_labor_resource IN PA_PLSQL_DATATYPES.Char20TabTyp ,
275: P_Prvdr_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
276: P_Recvr_org_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
277: P_Recvr_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
270: P_Denom_burdened_cost_amt
271: IN PA_PLSQL_DATATYPES.Char30TabTyp ,
272: P_Raw_revenue_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
273: P_Quantity IN PA_PLSQL_DATATYPES.Char30TabTyp ,
274: P_Non_labor_resource IN PA_PLSQL_DATATYPES.Char20TabTyp ,
275: P_Prvdr_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
276: P_Recvr_org_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
277: P_Recvr_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
278: P_Expnd_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
271: IN PA_PLSQL_DATATYPES.Char30TabTyp ,
272: P_Raw_revenue_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
273: P_Quantity IN PA_PLSQL_DATATYPES.Char30TabTyp ,
274: P_Non_labor_resource IN PA_PLSQL_DATATYPES.Char20TabTyp ,
275: P_Prvdr_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
276: P_Recvr_org_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
277: P_Recvr_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
278: P_Expnd_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
279: P_NL_resource_organization
272: P_Raw_revenue_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
273: P_Quantity IN PA_PLSQL_DATATYPES.Char30TabTyp ,
274: P_Non_labor_resource IN PA_PLSQL_DATATYPES.Char20TabTyp ,
275: P_Prvdr_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
276: P_Recvr_org_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
277: P_Recvr_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
278: P_Expnd_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
279: P_NL_resource_organization
280: IN PA_PLSQL_DATATYPES.IdTabTyp ,
273: P_Quantity IN PA_PLSQL_DATATYPES.Char30TabTyp ,
274: P_Non_labor_resource IN PA_PLSQL_DATATYPES.Char20TabTyp ,
275: P_Prvdr_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
276: P_Recvr_org_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
277: P_Recvr_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
278: P_Expnd_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
279: P_NL_resource_organization
280: IN PA_PLSQL_DATATYPES.IdTabTyp ,
281: P_Incurred_by_person_id
274: P_Non_labor_resource IN PA_PLSQL_DATATYPES.Char20TabTyp ,
275: P_Prvdr_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
276: P_Recvr_org_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
277: P_Recvr_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
278: P_Expnd_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
279: P_NL_resource_organization
280: IN PA_PLSQL_DATATYPES.IdTabTyp ,
281: P_Incurred_by_person_id
282: IN PA_PLSQL_DATATYPES.IdTabTyp ,
276: P_Recvr_org_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
277: P_Recvr_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
278: P_Expnd_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
279: P_NL_resource_organization
280: IN PA_PLSQL_DATATYPES.IdTabTyp ,
281: P_Incurred_by_person_id
282: IN PA_PLSQL_DATATYPES.IdTabTyp ,
283: P_Job_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
284: P_Denom_TP_currency_code
278: P_Expnd_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
279: P_NL_resource_organization
280: IN PA_PLSQL_DATATYPES.IdTabTyp ,
281: P_Incurred_by_person_id
282: IN PA_PLSQL_DATATYPES.IdTabTyp ,
283: P_Job_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
284: P_Denom_TP_currency_code
285: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char15TabTyp ,
286: P_Denom_transfer_price
279: P_NL_resource_organization
280: IN PA_PLSQL_DATATYPES.IdTabTyp ,
281: P_Incurred_by_person_id
282: IN PA_PLSQL_DATATYPES.IdTabTyp ,
283: P_Job_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
284: P_Denom_TP_currency_code
285: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char15TabTyp ,
286: P_Denom_transfer_price
287: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
281: P_Incurred_by_person_id
282: IN PA_PLSQL_DATATYPES.IdTabTyp ,
283: P_Job_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
284: P_Denom_TP_currency_code
285: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char15TabTyp ,
286: P_Denom_transfer_price
287: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
288: P_Acct_TP_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
289: P_Acct_TP_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
283: P_Job_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
284: P_Denom_TP_currency_code
285: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char15TabTyp ,
286: P_Denom_transfer_price
287: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
288: P_Acct_TP_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
289: P_Acct_TP_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
290: P_Acct_TP_exchange_rate
291: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
284: P_Denom_TP_currency_code
285: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char15TabTyp ,
286: P_Denom_transfer_price
287: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
288: P_Acct_TP_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
289: P_Acct_TP_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
290: P_Acct_TP_exchange_rate
291: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
292: P_Acct_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
285: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char15TabTyp ,
286: P_Denom_transfer_price
287: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
288: P_Acct_TP_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
289: P_Acct_TP_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
290: P_Acct_TP_exchange_rate
291: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
292: P_Acct_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
293: P_CC_markup_base_code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
287: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
288: P_Acct_TP_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
289: P_Acct_TP_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
290: P_Acct_TP_exchange_rate
291: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
292: P_Acct_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
293: P_CC_markup_base_code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
294: P_TP_ind_compiled_set_id
295: IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
288: P_Acct_TP_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
289: P_Acct_TP_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
290: P_Acct_TP_exchange_rate
291: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
292: P_Acct_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
293: P_CC_markup_base_code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
294: P_TP_ind_compiled_set_id
295: IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
296: P_TP_bill_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
289: P_Acct_TP_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
290: P_Acct_TP_exchange_rate
291: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
292: P_Acct_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
293: P_CC_markup_base_code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
294: P_TP_ind_compiled_set_id
295: IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
296: P_TP_bill_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
297: P_TP_base_amt IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
291: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
292: P_Acct_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
293: P_CC_markup_base_code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
294: P_TP_ind_compiled_set_id
295: IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
296: P_TP_bill_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
297: P_TP_base_amt IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
298: P_TP_bill_markup_percentage
299: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
292: P_Acct_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
293: P_CC_markup_base_code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
294: P_TP_ind_compiled_set_id
295: IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
296: P_TP_bill_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
297: P_TP_base_amt IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
298: P_TP_bill_markup_percentage
299: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
300: P_TP_schedule_line_percentage
293: P_CC_markup_base_code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
294: P_TP_ind_compiled_set_id
295: IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
296: P_TP_bill_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
297: P_TP_base_amt IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
298: P_TP_bill_markup_percentage
299: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
300: P_TP_schedule_line_percentage
301: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
295: IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
296: P_TP_bill_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
297: P_TP_base_amt IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
298: P_TP_bill_markup_percentage
299: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
300: P_TP_schedule_line_percentage
301: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
302: P_TP_rule_percentage IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
303: P_burden_disp_method IN PA_PLSQL_DATATYPES.Char1TabTyp ,
297: P_TP_base_amt IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
298: P_TP_bill_markup_percentage
299: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
300: P_TP_schedule_line_percentage
301: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
302: P_TP_rule_percentage IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
303: P_burden_disp_method IN PA_PLSQL_DATATYPES.Char1TabTyp ,
304: P_ca_prov_code IN Varchar2,
305: P_nca_prov_code IN Varchar2,
298: P_TP_bill_markup_percentage
299: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
300: P_TP_schedule_line_percentage
301: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
302: P_TP_rule_percentage IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
303: P_burden_disp_method IN PA_PLSQL_DATATYPES.Char1TabTyp ,
304: P_ca_prov_code IN Varchar2,
305: P_nca_prov_code IN Varchar2,
306: P_Processed_thru_date IN Date ,
299: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
300: P_TP_schedule_line_percentage
301: IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
302: P_TP_rule_percentage IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
303: P_burden_disp_method IN PA_PLSQL_DATATYPES.Char1TabTyp ,
304: P_ca_prov_code IN Varchar2,
305: P_nca_prov_code IN Varchar2,
306: P_Processed_thru_date IN Date ,
307: P_No_of_records IN NUMBER ,
306: P_Processed_thru_date IN Date ,
307: P_No_of_records IN NUMBER ,
308: P_User_Id IN NUMBER ,
309: P_Request_id IN NUMBER ,
310: P_Error_Code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
311: P_tp_job_id IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
312: P_prov_proj_bill_job_id
313: IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
314: /*Added for cross proj*/
307: P_No_of_records IN NUMBER ,
308: P_User_Id IN NUMBER ,
309: P_Request_id IN NUMBER ,
310: P_Error_Code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
311: P_tp_job_id IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
312: P_prov_proj_bill_job_id
313: IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
314: /*Added for cross proj*/
315: P_tp_amt_type_code IN PA_PLSQL_DATATYPES.Char30TabTyp ,
309: P_Request_id IN NUMBER ,
310: P_Error_Code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
311: P_tp_job_id IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
312: P_prov_proj_bill_job_id
313: IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
314: /*Added for cross proj*/
315: P_tp_amt_type_code IN PA_PLSQL_DATATYPES.Char30TabTyp ,
316: P_projfunc_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
317: P_project_tp_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
311: P_tp_job_id IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
312: P_prov_proj_bill_job_id
313: IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
314: /*Added for cross proj*/
315: P_tp_amt_type_code IN PA_PLSQL_DATATYPES.Char30TabTyp ,
316: P_projfunc_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
317: P_project_tp_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
318: P_project_tp_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
319: P_project_tp_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
312: P_prov_proj_bill_job_id
313: IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
314: /*Added for cross proj*/
315: P_tp_amt_type_code IN PA_PLSQL_DATATYPES.Char30TabTyp ,
316: P_projfunc_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
317: P_project_tp_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
318: P_project_tp_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
319: P_project_tp_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
320: P_projfunc_tp_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
313: IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
314: /*Added for cross proj*/
315: P_tp_amt_type_code IN PA_PLSQL_DATATYPES.Char30TabTyp ,
316: P_projfunc_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
317: P_project_tp_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
318: P_project_tp_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
319: P_project_tp_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
320: P_projfunc_tp_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
321: P_projfunc_tp_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
314: /*Added for cross proj*/
315: P_tp_amt_type_code IN PA_PLSQL_DATATYPES.Char30TabTyp ,
316: P_projfunc_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
317: P_project_tp_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
318: P_project_tp_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
319: P_project_tp_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
320: P_projfunc_tp_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
321: P_projfunc_tp_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
322: P_projfunc_tp_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
315: P_tp_amt_type_code IN PA_PLSQL_DATATYPES.Char30TabTyp ,
316: P_projfunc_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
317: P_project_tp_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
318: P_project_tp_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
319: P_project_tp_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
320: P_projfunc_tp_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
321: P_projfunc_tp_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
322: P_projfunc_tp_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
323: P_assignment_id IN PA_PLSQL_DATATYPES.IdTabTyp,
316: P_projfunc_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
317: P_project_tp_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
318: P_project_tp_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
319: P_project_tp_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
320: P_projfunc_tp_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
321: P_projfunc_tp_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
322: P_projfunc_tp_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
323: P_assignment_id IN PA_PLSQL_DATATYPES.IdTabTyp,
324: P_project_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
317: P_project_tp_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
318: P_project_tp_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
319: P_project_tp_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
320: P_projfunc_tp_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
321: P_projfunc_tp_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
322: P_projfunc_tp_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
323: P_assignment_id IN PA_PLSQL_DATATYPES.IdTabTyp,
324: P_project_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
325: P_projfunc_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp
318: P_project_tp_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
319: P_project_tp_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
320: P_projfunc_tp_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
321: P_projfunc_tp_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
322: P_projfunc_tp_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
323: P_assignment_id IN PA_PLSQL_DATATYPES.IdTabTyp,
324: P_project_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
325: P_projfunc_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp
326: /*End for cross proj*/
319: P_project_tp_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
320: P_projfunc_tp_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
321: P_projfunc_tp_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
322: P_projfunc_tp_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
323: P_assignment_id IN PA_PLSQL_DATATYPES.IdTabTyp,
324: P_project_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
325: P_projfunc_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp
326: /*End for cross proj*/
327: );
320: P_projfunc_tp_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
321: P_projfunc_tp_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
322: P_projfunc_tp_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
323: P_assignment_id IN PA_PLSQL_DATATYPES.IdTabTyp,
324: P_project_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
325: P_projfunc_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp
326: /*End for cross proj*/
327: );
328: --Procedure to initialize global counter
321: P_projfunc_tp_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
322: P_projfunc_tp_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
323: P_assignment_id IN PA_PLSQL_DATATYPES.IdTabTyp,
324: P_project_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
325: P_projfunc_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp
326: /*End for cross proj*/
327: );
328: --Procedure to initialize global counter
329: PROCEDURE init;
347: -- Procedure to reverse the provider reclass entries
348: -- from invoice cancellation
349: --
350: PROCEDURE reverse_preclass (
351: P_inv_detail_id PA_PLSQL_DATATYPES.IdTabTyp,
352: P_new_inv_detail_id PA_PLSQL_DATATYPES.IdTabTyp,
353: P_EI_id PA_PLSQL_DATATYPES.IdTabTyp,
354: P_EI_date PA_PLSQL_DATATYPES.Char30TabTyp,
355: P_Sys_Linkage PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for 3857986 */
348: -- from invoice cancellation
349: --
350: PROCEDURE reverse_preclass (
351: P_inv_detail_id PA_PLSQL_DATATYPES.IdTabTyp,
352: P_new_inv_detail_id PA_PLSQL_DATATYPES.IdTabTyp,
353: P_EI_id PA_PLSQL_DATATYPES.IdTabTyp,
354: P_EI_date PA_PLSQL_DATATYPES.Char30TabTyp,
355: P_Sys_Linkage PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for 3857986 */
356: P_tab_count NUMBER);
349: --
350: PROCEDURE reverse_preclass (
351: P_inv_detail_id PA_PLSQL_DATATYPES.IdTabTyp,
352: P_new_inv_detail_id PA_PLSQL_DATATYPES.IdTabTyp,
353: P_EI_id PA_PLSQL_DATATYPES.IdTabTyp,
354: P_EI_date PA_PLSQL_DATATYPES.Char30TabTyp,
355: P_Sys_Linkage PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for 3857986 */
356: P_tab_count NUMBER);
357:
350: PROCEDURE reverse_preclass (
351: P_inv_detail_id PA_PLSQL_DATATYPES.IdTabTyp,
352: P_new_inv_detail_id PA_PLSQL_DATATYPES.IdTabTyp,
353: P_EI_id PA_PLSQL_DATATYPES.IdTabTyp,
354: P_EI_date PA_PLSQL_DATATYPES.Char30TabTyp,
355: P_Sys_Linkage PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for 3857986 */
356: P_tab_count NUMBER);
357:
358: END PA_INVOICE_DETAIL_PROCESS;
351: P_inv_detail_id PA_PLSQL_DATATYPES.IdTabTyp,
352: P_new_inv_detail_id PA_PLSQL_DATATYPES.IdTabTyp,
353: P_EI_id PA_PLSQL_DATATYPES.IdTabTyp,
354: P_EI_date PA_PLSQL_DATATYPES.Char30TabTyp,
355: P_Sys_Linkage PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for 3857986 */
356: P_tab_count NUMBER);
357:
358: END PA_INVOICE_DETAIL_PROCESS;