DBA Data[Home] [Help]

APPS.PA_COST_RATE_PUB dependencies on PA_EXPENDITURE_ITEMS_ALL

Line 68: ,x_job_id IN OUT NOCOPY pa_expenditure_items_all.job_id%TYPE

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
72: ,x_end_date_active OUT NOCOPY date

Line 77: ,x_acct_rate_type OUT NOCOPY pa_expenditure_items_all.acct_rate_type%TYPE

73: ,x_org_labor_sch_rule_id OUT NOCOPY pa_org_labor_sch_rule.org_labor_sch_rule_id%TYPE
74: ,x_costing_rule OUT NOCOPY pa_compensation_rule_sets.compensation_rule_set%TYPE
75: ,x_rate_sch_id OUT NOCOPY pa_std_bill_rate_schedules_all.bill_rate_sch_id%TYPE
76: ,x_cost_rate_curr_code OUT NOCOPY gl_sets_of_books.currency_code%TYPE
77: ,x_acct_rate_type OUT NOCOPY pa_expenditure_items_all.acct_rate_type%TYPE
78: ,x_acct_rate_date_code OUT NOCOPY pa_implementations_all.acct_rate_date_code%TYPE
79: ,x_acct_exch_rate OUT NOCOPY pa_org_labor_sch_rule.acct_exchange_rate%TYPE
80: ,x_ot_project_id OUT NOCOPY pa_projects_all.project_id%TYPE
81: ,x_ot_task_id OUT NOCOPY pa_tasks.task_id%TYPE

Line 91: ,p_job_id IN pa_expenditure_items_all.job_id%TYPE

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
95: ,x_costing_rule IN OUT NOCOPY pa_compensation_rule_sets.compensation_rule_set%TYPE

Line 92: ,p_txn_date IN pa_expenditure_items_all.expenditure_item_date%TYPE

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
95: ,x_costing_rule IN OUT NOCOPY pa_compensation_rule_sets.compensation_rule_set%TYPE
96: ,x_rate_sch_id IN OUT NOCOPY pa_std_bill_rate_schedules.bill_rate_sch_id%TYPE

Line 101: ,x_cost_rate_curr_code IN OUT NOCOPY pa_expenditure_items_all.denom_currency_code%TYPE

97: ,x_ot_project_id IN OUT NOCOPY pa_projects_all.project_id%TYPE
98: ,x_ot_task_id IN OUT NOCOPY pa_tasks.task_id%TYPE
99: ,x_base_hours IN OUT NOCOPY pa_org_labor_sch_rule.base_hours%TYPE /* 12.2 payroll intg .. bug 11811475 */
100: ,x_rbc_elem_type_id IN OUT NOCOPY pa_org_labor_sch_rule.rbc_element_type_id%TYPE /* 12.2 payroll intg .. bug 11811475 */
101: ,x_cost_rate_curr_code IN OUT NOCOPY pa_expenditure_items_all.denom_currency_code%TYPE
102: ,x_acct_rate_type IN OUT NOCOPY pa_expenditure_items_all.acct_rate_type%TYPE
103: ,x_acct_rate_date_code IN OUT NOCOPY pa_implementations_all.acct_rate_date_code%TYPE
104: ,x_acct_exch_rate IN OUT NOCOPY pa_compensation_details_all.acct_exchange_rate%TYPE
105: ,x_err_stage IN OUT NOCOPY number

Line 102: ,x_acct_rate_type IN OUT NOCOPY pa_expenditure_items_all.acct_rate_type%TYPE

98: ,x_ot_task_id IN OUT NOCOPY pa_tasks.task_id%TYPE
99: ,x_base_hours IN OUT NOCOPY pa_org_labor_sch_rule.base_hours%TYPE /* 12.2 payroll intg .. bug 11811475 */
100: ,x_rbc_elem_type_id IN OUT NOCOPY pa_org_labor_sch_rule.rbc_element_type_id%TYPE /* 12.2 payroll intg .. bug 11811475 */
101: ,x_cost_rate_curr_code IN OUT NOCOPY pa_expenditure_items_all.denom_currency_code%TYPE
102: ,x_acct_rate_type IN OUT NOCOPY pa_expenditure_items_all.acct_rate_type%TYPE
103: ,x_acct_rate_date_code IN OUT NOCOPY pa_implementations_all.acct_rate_date_code%TYPE
104: ,x_acct_exch_rate IN OUT NOCOPY pa_compensation_details_all.acct_exchange_rate%TYPE
105: ,x_err_stage IN OUT NOCOPY number
106: ,x_err_code IN OUT NOCOPY varchar2

Line 114: G_EMP_RATE_CURR pa_expenditure_items_all.acct_currency_code%type;

110: --Globals for the Cache values.
111: G_EMP_RATE_RULE pa_compensation_rule_sets.compensation_rule_set%type;
112: G_EMP_COST_RATE pa_bill_rates_all.rate%type;
113: G_EMP_ACCT_COST_RATE pa_bill_rates_all.rate%type;
114: G_EMP_RATE_CURR pa_expenditure_items_all.acct_currency_code%type;
115: G_EMP_RATE_START_DATE date;
116: G_EMP_RATE_END_DATE date;
117:
118: --Globals for the Cache Attributes.

Line 125: G_TXN_DATE pa_expenditure_items_all.expenditure_item_date%TYPE;

121: G_EMP_ORGANIZATION_ID hr_organization_units.organization_id%type;
122:
123: -- Bug 3785956
124: G_ORG_ID pa_implementations_all.org_id%TYPE;
125: G_TXN_DATE pa_expenditure_items_all.expenditure_item_date%TYPE;
126: G_CALLING_MODULE VARCHAR2(150) := 'STAFFED';
127:
128:
129: /*----------------------------------------------------------------------------*/

Line 150: ,P_Job_Id IN pa_expenditure_items_all.job_id%type

146: --
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 */

Line 182: ,P_Job_Id IN pa_expenditure_items_all.job_id%type

178: --
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 */