[Home] [Help]
1: PACKAGE BODY PA_COST_RATE_PUB AS
2: /* $Header: PAXPCRTB.pls 120.5.12010000.3 2008/09/01 04:16:44 rmandali ship $ */
3:
4: -- Start of comments
5: -- API name : get_labor_rate
75: IF ( l_debug_mode = 'Y' ) THEN
76: pa_debug.set_process( x_process => 'PLSQL'
77: ,x_debug_mode => l_debug_mode
78: );
79: pa_cc_utils.set_curr_function('PA_COST_RATE_PUB.get_labor_rate');
80: pa_cc_utils.log_message('Start ');
81: END IF;
82:
83: l_stage := 'Input person_id [' || to_char(p_person_id) || '] job_id ['
338: if ( l_debug_mode = 'Y' )
339: then
340: pa_cc_utils.log_message(l_stage);
341: end if;
342: pa_cost_rate_pub.get_orgn_level_costing_info
343: ( p_org_id => g_ou_id
344: ,p_organization_id => x_organization_id
345: ,p_person_id => p_person_id
346: ,p_job_id => x_job_id
852: l_job_id := P_job_id; --IN OUT parameter
853: l_organization_id := P_organization_id; --IN OUT parameter.
854:
855: Begin
856: PA_COST_RATE_PUB.get_labor_rate ( p_person_id =>P_person_id
857: ,x_job_id =>l_job_id
858: ,p_txn_date =>P_effective_date
859: ,p_org_id =>l_org_id /*2879644*/
860: ,x_organization_id =>l_organization_id
1018: l_job_id := P_job_id; --IN OUT parameter
1019: l_organization_id := P_organization_id; --IN OUT parameter.
1020:
1021: Begin
1022: PA_COST_RATE_PUB.get_labor_rate ( p_person_id =>P_person_id
1023: ,x_job_id =>l_job_id
1024: ,p_txn_date =>P_effective_date
1025: ,p_org_id =>l_org_id /*2879644*/
1026: ,x_organization_id =>l_organization_id
1144:
1145: /*
1146: * GSCC: Handled File.Date.5 for p_txn_date_tab(i).
1147: */
1148: pa_cost_rate_pub.get_orgn_level_costing_info
1149: (p_org_id => p_org_id_tab(i)
1150: ,p_organization_id => p_organization_id_tab(i)
1151: ,p_person_id => p_person_id_tab(i)
1152: ,p_job_id => p_job_id_tab(i)
1194: end get_orgn_lvl_cst_info_set;
1195: --------------------------------
1196:
1197:
1198: END PA_COST_RATE_PUB;