eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_COST_RATE_PUB dependencies on PA_EXPENDITURE_ITEMS_ALL

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

23: procedure get_labor_rate ( p_person_id IN per_all_people_f.person_id%TYPE
24: ,p_txn_date IN date
25: ,p_calling_module IN varchar2 default 'STAFFED'
26: ,p_org_id IN pa_expenditures_all.org_id%TYPE default NULL /*2879644*/
27: ,x_job_id IN OUT NOCOPY pa_expenditure_items_all.job_id%TYPE
28: ,x_organization_id IN OUT NOCOPY pa_expenditures_all.incurred_by_organization_id%TYPE
29: ,x_cost_rate OUT NOCOPY pa_bill_rates_all.rate%TYPE
30: ,x_start_date_active OUT NOCOPY date
31: ,x_end_date_active OUT NOCOPY date

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

32: ,x_org_labor_sch_rule_id OUT NOCOPY pa_org_labor_sch_rule.org_labor_sch_rule_id%TYPE
33: ,x_costing_rule OUT NOCOPY pa_compensation_rule_sets.compensation_rule_set%TYPE
34: ,x_rate_sch_id OUT NOCOPY pa_std_bill_rate_schedules_all.bill_rate_sch_id%TYPE
35: ,x_cost_rate_curr_code OUT NOCOPY gl_sets_of_books.currency_code%TYPE
36: ,x_acct_rate_type OUT NOCOPY pa_expenditure_items_all.acct_rate_type%TYPE
37: ,x_acct_rate_date_code OUT NOCOPY pa_implementations_all.acct_rate_date_code%TYPE
38: ,x_acct_exch_rate OUT NOCOPY pa_org_labor_sch_rule.acct_exchange_rate%TYPE
39: ,x_ot_project_id OUT NOCOPY pa_projects_all.project_id%TYPE
40: ,x_ot_task_id OUT NOCOPY pa_tasks.task_id%TYPE

Line 52: l_num_dummy pa_expenditure_items_all.expenditure_item_id%TYPE;

48:
49: l_debug_mode varchar2(1);
50: l_stage varchar2(300);
51: l_use_cache varchar2(1);
52: l_num_dummy pa_expenditure_items_all.expenditure_item_id%TYPE;
53:
54: l_override_flag varchar2(1) := 'N' ;
55: l_override_type pa_compensation_details.override_type%TYPE;
56: l_sch_type pa_std_bill_rate_schedules_all.schedule_type%TYPE;

Line 639: ,p_job_id IN pa_expenditure_items_all.job_id%TYPE

635: PROCEDURE get_orgn_level_costing_info
636: ( p_org_id IN pa_implementations_all.org_id%TYPE
637: ,p_organization_id IN pa_expenditures_all.incurred_by_organization_id%TYPE
638: ,p_person_id IN pa_expenditures_all.incurred_by_person_id%TYPE
639: ,p_job_id IN pa_expenditure_items_all.job_id%TYPE
640: ,p_txn_date IN pa_expenditure_items_all.expenditure_item_date%TYPE
641: ,p_calling_module IN varchar2 default 'STAFFED'
642: ,x_org_labor_sch_rule_id IN OUT NOCOPY pa_org_labor_sch_rule.org_labor_sch_rule_id%TYPE
643: ,x_costing_rule IN OUT NOCOPY pa_compensation_rule_sets.compensation_rule_set%TYPE

Line 640: ,p_txn_date IN pa_expenditure_items_all.expenditure_item_date%TYPE

636: ( p_org_id IN pa_implementations_all.org_id%TYPE
637: ,p_organization_id IN pa_expenditures_all.incurred_by_organization_id%TYPE
638: ,p_person_id IN pa_expenditures_all.incurred_by_person_id%TYPE
639: ,p_job_id IN pa_expenditure_items_all.job_id%TYPE
640: ,p_txn_date IN pa_expenditure_items_all.expenditure_item_date%TYPE
641: ,p_calling_module IN varchar2 default 'STAFFED'
642: ,x_org_labor_sch_rule_id IN OUT NOCOPY pa_org_labor_sch_rule.org_labor_sch_rule_id%TYPE
643: ,x_costing_rule IN OUT NOCOPY pa_compensation_rule_sets.compensation_rule_set%TYPE
644: ,x_rate_sch_id IN OUT NOCOPY pa_std_bill_rate_schedules.bill_rate_sch_id%TYPE

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

645: ,x_ot_project_id IN OUT NOCOPY pa_projects_all.project_id%TYPE
646: ,x_ot_task_id IN OUT NOCOPY pa_tasks.task_id%TYPE
647: ,x_base_hours IN OUT NOCOPY pa_org_labor_sch_rule.base_hours%TYPE /* 12.2 payroll intg .. bug 11811475 */
648: ,x_rbc_elem_type_id IN OUT NOCOPY pa_org_labor_sch_rule.rbc_element_type_id%TYPE
649: ,x_cost_rate_curr_code IN OUT NOCOPY pa_expenditure_items_all.denom_currency_code%TYPE
650: ,x_acct_rate_type IN OUT NOCOPY pa_expenditure_items_all.acct_rate_type%TYPE
651: ,x_acct_rate_date_code IN OUT NOCOPY pa_implementations_all.acct_rate_date_code%TYPE
652: ,x_acct_exch_rate IN OUT NOCOPY pa_compensation_details_all.acct_exchange_rate%TYPE
653: ,x_err_stage IN OUT NOCOPY number

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

646: ,x_ot_task_id IN OUT NOCOPY pa_tasks.task_id%TYPE
647: ,x_base_hours IN OUT NOCOPY pa_org_labor_sch_rule.base_hours%TYPE /* 12.2 payroll intg .. bug 11811475 */
648: ,x_rbc_elem_type_id IN OUT NOCOPY pa_org_labor_sch_rule.rbc_element_type_id%TYPE
649: ,x_cost_rate_curr_code IN OUT NOCOPY pa_expenditure_items_all.denom_currency_code%TYPE
650: ,x_acct_rate_type IN OUT NOCOPY pa_expenditure_items_all.acct_rate_type%TYPE
651: ,x_acct_rate_date_code IN OUT NOCOPY pa_implementations_all.acct_rate_date_code%TYPE
652: ,x_acct_exch_rate IN OUT NOCOPY pa_compensation_details_all.acct_exchange_rate%TYPE
653: ,x_err_stage IN OUT NOCOPY number
654: ,x_err_code IN OUT NOCOPY varchar2

Line 679: ,p_job_id IN pa_expenditure_items_all.job_id%TYPE

675:
676: cursor org_costing_rule( p_org_id IN pa_implementations_all.org_id%TYPE
677: ,p_organization_id IN pa_expenditures_all.incurred_by_organization_id%TYPE
678: ,p_person_id IN pa_expenditures_all.incurred_by_person_id%TYPE
679: ,p_job_id IN pa_expenditure_items_all.job_id%TYPE
680: ,p_txn_date IN pa_expenditure_items_all.expenditure_item_date%TYPE
681: ,p_calling_module IN varchar2
682: )
683: is

Line 680: ,p_txn_date IN pa_expenditure_items_all.expenditure_item_date%TYPE

676: cursor org_costing_rule( p_org_id IN pa_implementations_all.org_id%TYPE
677: ,p_organization_id IN pa_expenditures_all.incurred_by_organization_id%TYPE
678: ,p_person_id IN pa_expenditures_all.incurred_by_person_id%TYPE
679: ,p_job_id IN pa_expenditure_items_all.job_id%TYPE
680: ,p_txn_date IN pa_expenditure_items_all.expenditure_item_date%TYPE
681: ,p_calling_module IN varchar2
682: )
683: is
684: select assign.org_labor_sch_rule_id

Line 710: ,p_job_id IN pa_expenditure_items_all.job_id%TYPE

706:
707: cursor assignment( p_org_id IN pa_implementations_all.org_id%TYPE
708: ,p_organization_id IN pa_expenditures_all.incurred_by_organization_id%TYPE
709: ,p_person_id IN pa_expenditures_all.incurred_by_person_id%TYPE
710: ,p_job_id IN pa_expenditure_items_all.job_id%TYPE
711: ,p_txn_date IN pa_expenditure_items_all.expenditure_item_date%TYPE
712: ,p_calling_module IN varchar2
713: )
714: is

Line 711: ,p_txn_date IN pa_expenditure_items_all.expenditure_item_date%TYPE

707: cursor assignment( p_org_id IN pa_implementations_all.org_id%TYPE
708: ,p_organization_id IN pa_expenditures_all.incurred_by_organization_id%TYPE
709: ,p_person_id IN pa_expenditures_all.incurred_by_person_id%TYPE
710: ,p_job_id IN pa_expenditure_items_all.job_id%TYPE
711: ,p_txn_date IN pa_expenditure_items_all.expenditure_item_date%TYPE
712: ,p_calling_module IN varchar2
713: )
714: is
715: select assign.org_labor_sch_rule_id

Line 1044: ,P_Job_Id IN pa_expenditure_items_all.job_id%type

1040: --
1041: /*----------------------------------------------------------------------------*/
1042:
1043: Function GetEmpCostRate( P_Person_Id IN per_all_people_f.person_id%type
1044: ,P_Job_Id IN pa_expenditure_items_all.job_id%type
1045: ,P_Organization_Id IN pa_expenditures_all.incurred_by_organization_id%type
1046: ,P_Effective_Date IN date
1047: ,P_Rate_Type IN varchar2
1048: ,P_Called_From IN varchar2 DEFAULT 'O' /* Added for 3405326 */

Line 1051: l_job_id pa_expenditure_items_all.job_id%type;

1047: ,P_Rate_Type IN varchar2
1048: ,P_Called_From IN varchar2 DEFAULT 'O' /* Added for 3405326 */
1049: )
1050: RETURN pa_bill_rates_all.rate%type IS
1051: l_job_id pa_expenditure_items_all.job_id%type;
1052: l_organization_id pa_expenditures_all.incurred_by_organization_id%type;
1053: l_org_id pa_expenditures_all.org_id%type; /*2879644*/
1054: l_costing_rule pa_compensation_details_all.compensation_rule_set%type;
1055: l_cost_rate pa_bill_rates_all.rate%type;

Line 1215: ,P_Job_Id IN pa_expenditure_items_all.job_id%type

1211: -- 03-OCT-02 Vgade -Created
1212: --
1213: /*----------------------------------------------------------------------------*/
1214: Function GetEmpCostRateInfo( P_Person_Id IN per_all_people_f.person_id%type
1215: ,P_Job_Id IN pa_expenditure_items_all.job_id%type
1216: ,P_Organization_Id IN pa_expenditures_all.incurred_by_organization_id%type
1217: ,P_Effective_Date IN date
1218: ,P_Rate_Attribute IN varchar2
1219: ,P_Called_From IN varchar2 DEFAULT 'O' /* Added for 3405326 */

Line 1222: l_job_id pa_expenditure_items_all.job_id%type;

1218: ,P_Rate_Attribute IN varchar2
1219: ,P_Called_From IN varchar2 DEFAULT 'O' /* Added for 3405326 */
1220: )
1221: RETURN VARCHAR2 IS
1222: l_job_id pa_expenditure_items_all.job_id%type;
1223: l_organization_id pa_expenditures_all.incurred_by_organization_id%type;
1224: l_org_id pa_expenditures_all.org_id%TYPE ; /*2879644*/
1225: l_costing_rule pa_compensation_details_all.compensation_rule_set%type;
1226: l_cost_rate pa_bill_rates_all.rate%type;