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_EXPENDITURES_ALL

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

22: -- End of comments
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

Line 28: ,x_organization_id IN OUT NOCOPY pa_expenditures_all.incurred_by_organization_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
32: ,x_org_labor_sch_rule_id OUT NOCOPY pa_org_labor_sch_rule.org_labor_sch_rule_id%TYPE

Line 60: l_curr_org_id pa_expenditures_all.org_id%TYPE; /* Added for bug 7365397 */

56: l_sch_type pa_std_bill_rate_schedules_all.schedule_type%TYPE;
57: l_job_group_id pa_std_bill_rate_schedules_all.job_group_id%TYPE;
58: l_dest_job_id pa_bill_rates_all.job_id%TYPE;
59: l_costing_method pa_compensation_rule_sets.costing_method%TYPE;
60: l_curr_org_id pa_expenditures_all.org_id%TYPE; /* Added for bug 7365397 */
61:
62: begin
63:
64: ----------------- initializaton ------------------------------

Line 521: ,p_organization_id IN pa_expenditures_all.incurred_by_organization_id%TYPE

517: end get_labor_rate;
518: ---------------------------------------------------------------------------------------------
519: PROCEDURE get_orgn_level_costing_info
520: ( p_org_id IN pa_implementations_all.org_id%TYPE
521: ,p_organization_id IN pa_expenditures_all.incurred_by_organization_id%TYPE
522: ,p_person_id IN pa_expenditures_all.incurred_by_person_id%TYPE
523: ,p_job_id IN pa_expenditure_items_all.job_id%TYPE
524: ,p_txn_date IN pa_expenditure_items_all.expenditure_item_date%TYPE
525: ,p_calling_module IN varchar2 default 'STAFFED'

Line 522: ,p_person_id IN pa_expenditures_all.incurred_by_person_id%TYPE

518: ---------------------------------------------------------------------------------------------
519: PROCEDURE get_orgn_level_costing_info
520: ( p_org_id IN pa_implementations_all.org_id%TYPE
521: ,p_organization_id IN pa_expenditures_all.incurred_by_organization_id%TYPE
522: ,p_person_id IN pa_expenditures_all.incurred_by_person_id%TYPE
523: ,p_job_id IN pa_expenditure_items_all.job_id%TYPE
524: ,p_txn_date IN pa_expenditure_items_all.expenditure_item_date%TYPE
525: ,p_calling_module IN varchar2 default 'STAFFED'
526: ,x_org_labor_sch_rule_id IN OUT NOCOPY pa_org_labor_sch_rule.org_labor_sch_rule_id%TYPE

Line 554: ,p_organization_id IN pa_expenditures_all.incurred_by_organization_id%TYPE

550: l_acct_rate_type pa_org_labor_sch_rule.acct_rate_type%TYPE;
551: l_acct_exch_rate pa_org_labor_sch_rule.acct_exchange_rate%TYPE;
552:
553: cursor assignment( p_org_id IN pa_implementations_all.org_id%TYPE
554: ,p_organization_id IN pa_expenditures_all.incurred_by_organization_id%TYPE
555: ,p_person_id IN pa_expenditures_all.incurred_by_person_id%TYPE
556: ,p_job_id IN pa_expenditure_items_all.job_id%TYPE
557: ,p_txn_date IN pa_expenditure_items_all.expenditure_item_date%TYPE
558: ,p_calling_module IN varchar2

Line 555: ,p_person_id IN pa_expenditures_all.incurred_by_person_id%TYPE

551: l_acct_exch_rate pa_org_labor_sch_rule.acct_exchange_rate%TYPE;
552:
553: cursor assignment( p_org_id IN pa_implementations_all.org_id%TYPE
554: ,p_organization_id IN pa_expenditures_all.incurred_by_organization_id%TYPE
555: ,p_person_id IN pa_expenditures_all.incurred_by_person_id%TYPE
556: ,p_job_id IN pa_expenditure_items_all.job_id%TYPE
557: ,p_txn_date IN pa_expenditure_items_all.expenditure_item_date%TYPE
558: ,p_calling_module IN varchar2
559: )

Line 807: ,P_Organization_Id IN pa_expenditures_all.incurred_by_organization_id%type

803: /*----------------------------------------------------------------------------*/
804:
805: Function GetEmpCostRate( P_Person_Id IN per_all_people_f.person_id%type
806: ,P_Job_Id IN pa_expenditure_items_all.job_id%type
807: ,P_Organization_Id IN pa_expenditures_all.incurred_by_organization_id%type
808: ,P_Effective_Date IN date
809: ,P_Rate_Type IN varchar2
810: ,P_Called_From IN varchar2 DEFAULT 'O' /* Added for 3405326 */
811: )

Line 814: l_organization_id pa_expenditures_all.incurred_by_organization_id%type;

810: ,P_Called_From IN varchar2 DEFAULT 'O' /* Added for 3405326 */
811: )
812: RETURN pa_bill_rates_all.rate%type IS
813: l_job_id pa_expenditure_items_all.job_id%type;
814: l_organization_id pa_expenditures_all.incurred_by_organization_id%type;
815: l_org_id pa_expenditures_all.org_id%type; /*2879644*/
816: l_costing_rule pa_compensation_details_all.compensation_rule_set%type;
817: l_cost_rate pa_bill_rates_all.rate%type;
818: l_acct_cost_rate pa_bill_rates_all.rate%type;

Line 815: l_org_id pa_expenditures_all.org_id%type; /2879644/

811: )
812: RETURN pa_bill_rates_all.rate%type IS
813: l_job_id pa_expenditure_items_all.job_id%type;
814: l_organization_id pa_expenditures_all.incurred_by_organization_id%type;
815: l_org_id pa_expenditures_all.org_id%type; /*2879644*/
816: l_costing_rule pa_compensation_details_all.compensation_rule_set%type;
817: l_cost_rate pa_bill_rates_all.rate%type;
818: l_acct_cost_rate pa_bill_rates_all.rate%type;
819: l_start_date_active date;

Line 978: ,P_Organization_Id IN pa_expenditures_all.incurred_by_organization_id%type

974: --
975: /*----------------------------------------------------------------------------*/
976: Function GetEmpCostRateInfo( P_Person_Id IN per_all_people_f.person_id%type
977: ,P_Job_Id IN pa_expenditure_items_all.job_id%type
978: ,P_Organization_Id IN pa_expenditures_all.incurred_by_organization_id%type
979: ,P_Effective_Date IN date
980: ,P_Rate_Attribute IN varchar2
981: ,P_Called_From IN varchar2 DEFAULT 'O' /* Added for 3405326 */
982: )

Line 985: l_organization_id pa_expenditures_all.incurred_by_organization_id%type;

981: ,P_Called_From IN varchar2 DEFAULT 'O' /* Added for 3405326 */
982: )
983: RETURN VARCHAR2 IS
984: l_job_id pa_expenditure_items_all.job_id%type;
985: l_organization_id pa_expenditures_all.incurred_by_organization_id%type;
986: l_org_id pa_expenditures_all.org_id%TYPE ; /*2879644*/
987: l_costing_rule pa_compensation_details_all.compensation_rule_set%type;
988: l_cost_rate pa_bill_rates_all.rate%type;
989: l_start_date_active date;

Line 986: l_org_id pa_expenditures_all.org_id%TYPE ; /2879644/

982: )
983: RETURN VARCHAR2 IS
984: l_job_id pa_expenditure_items_all.job_id%type;
985: l_organization_id pa_expenditures_all.incurred_by_organization_id%type;
986: l_org_id pa_expenditures_all.org_id%TYPE ; /*2879644*/
987: l_costing_rule pa_compensation_details_all.compensation_rule_set%type;
988: l_cost_rate pa_bill_rates_all.rate%type;
989: l_start_date_active date;
990: l_end_date_active date;