APPS.PA_COST_RATE_PUB dependencies on PA_EXPENDITURES_ALL

Line 23: g_rt_organization_id pa_expenditures_all.incurred_by_organization_id%TYPE;

19: /*
20: * Contains information about the last processed record by the api get_labor_rate.
21: */
22: g_rt_calling_module varchar2(50);
23: g_rt_organization_id pa_expenditures_all.incurred_by_organization_id%TYPE;
24: g_rt_cost_rate pa_bill_rates_all.rate%TYPE;
25: g_rt_start_date_active date;
26: g_rt_end_date_active date;
27: g_rt_org_labor_sch_rule_id pa_org_labor_sch_rule.org_labor_sch_rule_id%TYPE;

Line 67: ,p_org_id IN pa_expenditures_all.org_id%TYPE default NULL /*2879644*/

63: -- End of comments
64: procedure get_labor_rate ( p_person_id IN per_all_people_f.person_id%TYPE
65: ,p_txn_date IN date
66: ,p_calling_module IN varchar2 default 'STAFFED'
67: ,p_org_id IN pa_expenditures_all.org_id%TYPE default NULL /*2879644*/
68: ,x_job_id IN OUT NOCOPY pa_expenditure_items_all.job_id%TYPE
69: ,x_organization_id IN OUT NOCOPY pa_expenditures_all.incurred_by_organization_id%TYPE
70: ,x_cost_rate OUT NOCOPY pa_bill_rates_all.rate%TYPE
71: ,x_start_date_active OUT NOCOPY date

Line 69: ,x_organization_id IN OUT NOCOPY pa_expenditures_all.incurred_by_organization_id%TYPE

65: ,p_txn_date IN date
66: ,p_calling_module IN varchar2 default 'STAFFED'
67: ,p_org_id IN pa_expenditures_all.org_id%TYPE default NULL /*2879644*/
68: ,x_job_id IN OUT NOCOPY pa_expenditure_items_all.job_id%TYPE
69: ,x_organization_id IN OUT NOCOPY pa_expenditures_all.incurred_by_organization_id%TYPE
70: ,x_cost_rate OUT NOCOPY pa_bill_rates_all.rate%TYPE
71: ,x_start_date_active OUT NOCOPY date
72: ,x_end_date_active OUT NOCOPY date
73: ,x_org_labor_sch_rule_id OUT NOCOPY pa_org_labor_sch_rule.org_labor_sch_rule_id%TYPE

Line 89: ,p_organization_id IN pa_expenditures_all.incurred_by_organization_id%TYPE

85: );
86:
87: PROCEDURE get_orgn_level_costing_info(
88: p_org_id IN pa_implementations_all.org_id%TYPE
89: ,p_organization_id IN pa_expenditures_all.incurred_by_organization_id%TYPE
90: ,p_person_id IN pa_expenditures_all.incurred_by_person_id%TYPE
91: ,p_job_id IN pa_expenditure_items_all.job_id%TYPE
92: ,p_txn_date IN pa_expenditure_items_all.expenditure_item_date%TYPE
93: ,p_calling_module IN varchar2 default 'STAFFED'

Line 90: ,p_person_id IN pa_expenditures_all.incurred_by_person_id%TYPE

86:
87: PROCEDURE get_orgn_level_costing_info(
88: p_org_id IN pa_implementations_all.org_id%TYPE
89: ,p_organization_id IN pa_expenditures_all.incurred_by_organization_id%TYPE
90: ,p_person_id IN pa_expenditures_all.incurred_by_person_id%TYPE
91: ,p_job_id IN pa_expenditure_items_all.job_id%TYPE
92: ,p_txn_date IN pa_expenditure_items_all.expenditure_item_date%TYPE
93: ,p_calling_module IN varchar2 default 'STAFFED'
94: ,x_org_labor_sch_rule_id IN OUT NOCOPY pa_org_labor_sch_rule.org_labor_sch_rule_id%TYPE

Line 151: ,P_Organization_Id IN pa_expenditures_all.incurred_by_organization_id%type

147: /*----------------------------------------------------------------------------*/
148:
149: Function GetEmpCostRate( P_Person_Id IN per_all_people_f.person_id%type
150: ,P_Job_Id IN pa_expenditure_items_all.job_id%type
151: ,P_Organization_Id IN pa_expenditures_all.incurred_by_organization_id%type
152: ,P_Effective_Date IN date default SYSDATE
153: ,P_Rate_Type IN varchar2
154: ,P_Called_From IN varchar2 DEFAULT 'O' /* Added for 3405326 */
155: )

Line 183: ,P_Organization_Id IN pa_expenditures_all.incurred_by_organization_id%type

179: /*----------------------------------------------------------------------------*/
180:
181: Function GetEmpCostRateInfo( P_Person_Id IN per_all_people_f.person_id%type
182: ,P_Job_Id IN pa_expenditure_items_all.job_id%type
183: ,P_Organization_Id IN pa_expenditures_all.incurred_by_organization_id%type
184: ,P_Effective_Date IN date default SYSDATE
185: ,P_Rate_Attribute IN varchar2
186: ,P_Called_From IN varchar2 DEFAULT 'O' /* Added for 3405326 */
187: )