[Home] [Help]
1: PACKAGE BODY PA_COST_RATE_PUB AS
2: /* $Header: PAXPCRTB.pls 120.18 2011/07/05 06:59:41 racheruv ship $ */
3:
4: -- Start of comments
5: -- API name : get_labor_rate
80: IF ( l_debug_mode = 'Y' ) THEN
81: pa_debug.set_process( x_process => 'PLSQL'
82: ,x_debug_mode => l_debug_mode
83: );
84: pa_cc_utils.set_curr_function('PA_COST_RATE_PUB.get_labor_rate');
85: -- pa_cc_utils.log_message('Start ');
86: END IF;
87:
88: l_stage := 'Input person_id [' || to_char(p_person_id) || '] job_id ['
376: then
377: pa_cc_utils.log_message(l_stage);
378: end if;
379: begin
380: pa_cost_rate_pub.get_orgn_level_costing_info
381: ( p_org_id => nvl(p_org_id, g_ou_id) --7158405
382: ,p_organization_id => x_organization_id
383: ,p_person_id => p_person_id
384: ,p_job_id => x_job_id
1090: l_job_id := P_job_id; --IN OUT parameter
1091: l_organization_id := P_organization_id; --IN OUT parameter.
1092:
1093: Begin
1094: PA_COST_RATE_PUB.get_labor_rate ( p_person_id =>P_person_id
1095: ,x_job_id =>l_job_id
1096: ,p_txn_date =>P_effective_date
1097: ,p_org_id =>l_org_id /*2879644*/
1098: ,x_organization_id =>l_organization_id
1256: l_job_id := P_job_id; --IN OUT parameter
1257: l_organization_id := P_organization_id; --IN OUT parameter.
1258:
1259: Begin
1260: PA_COST_RATE_PUB.get_labor_rate ( p_person_id =>P_person_id
1261: ,x_job_id =>l_job_id
1262: ,p_txn_date =>P_effective_date
1263: ,p_org_id =>l_org_id /*2879644*/
1264: ,x_organization_id =>l_organization_id
1385: /*
1386: * GSCC: Handled File.Date.5 for p_txn_date_tab(i).
1387: */
1388: begin
1389: pa_cost_rate_pub.get_orgn_level_costing_info
1390: (p_org_id => p_org_id_tab(i)
1391: ,p_organization_id => p_organization_id_tab(i)
1392: ,p_person_id => p_person_id_tab(i)
1393: ,p_job_id => p_job_id_tab(i)
1448: end get_orgn_lvl_cst_info_set;
1449: --------------------------------
1450:
1451:
1452: END PA_COST_RATE_PUB;