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_RESOURCE_PVT dependencies on PA_RESOURCE_PVT

Line 1: PACKAGE BODY PA_RESOURCE_PVT AS

1: PACKAGE BODY PA_RESOURCE_PVT AS
2: -- $Header: PARRESVB.pls 120.8.12010000.5 2009/07/03 11:14:08 nisinha ship $
3: g_profile_id NUMBER := 0;
4: g_person_id NUMBER := 0;
5:

Line 12: PA_RESOURCE_PVT.no_of_days := p_no_of_days;

8: Procedure Set_No_of_Days
9: (p_no_of_days IN NUMBER)
10: IS
11: BEGIN
12: PA_RESOURCE_PVT.no_of_days := p_no_of_days;
13: END;
14:
15: /*-----------------------------------------------------------------+
16: FUNCTION: Get_Start_Date

Line 72: PA_RESOURCE_PVT.end_date := null;

68:
69:
70: BEGIN
71:
72: PA_RESOURCE_PVT.end_date := null;
73:
74: /* ----------------------------------------------------------
75: * comment out the following code because no longer using
76: * forecast item and project assignments to get the available

Line 125: PA_RESOURCE_PVT.end_date := null;

121: END IF;
122:
123: EXCEPTION
124: WHEN OTHERS THEN
125: PA_RESOURCE_PVT.end_date := null;
126: END;
127:
128: ------------------------------------------------- */
129:

Line 138: l_end_date := PA_RESOURCE_PVT.get_resource_avl_to_date(p_resource_id, l_start_date);

134: FETCH get_available_from INTO l_start_date;
135: CLOSE get_available_from;
136:
137: IF l_start_date IS NOT NULL THEN
138: l_end_date := PA_RESOURCE_PVT.get_resource_avl_to_date(p_resource_id, l_start_date);
139: ELSE
140: l_end_date := null;
141: END IF;
142:

Line 143: PA_RESOURCE_PVT.end_date := l_end_date;

139: ELSE
140: l_end_date := null;
141: END IF;
142:
143: PA_RESOURCE_PVT.end_date := l_end_date;
144:
145: RETURN l_start_date;
146:
147: EXCEPTION

Line 149: PA_RESOURCE_PVT.end_date := null;

145: RETURN l_start_date;
146:
147: EXCEPTION
148: WHEN OTHERS THEN
149: PA_RESOURCE_PVT.end_date := null;
150: return null;
151: END;
152:
153: FUNCTION Get_End_Date

Line 158: RETURN PA_RESOURCE_PVT.end_date;

154: (p_resource_id IN NUMBER)
155: RETURN DATE
156: IS
157: BEGIN
158: RETURN PA_RESOURCE_PVT.end_date;
159: END;
160:
161: FUNCTION Get_Start_Date1
162: (p_row_label_id IN NUMBER)

Line 188: PA_RESOURCE_PVT.end_date1 := null;

184: return l_start_date1;
185:
186: EXCEPTION
187: WHEN OTHERS THEN
188: PA_RESOURCE_PVT.end_date1 := null;
189: PA_RESOURCE_PVT.scale_type := null;
190: return null;
191: END Get_Start_Date1;
192:

Line 189: PA_RESOURCE_PVT.scale_type := null;

185:
186: EXCEPTION
187: WHEN OTHERS THEN
188: PA_RESOURCE_PVT.end_date1 := null;
189: PA_RESOURCE_PVT.scale_type := null;
190: return null;
191: END Get_Start_Date1;
192:
193:

Line 198: RETURN PA_RESOURCE_PVT.end_date1;

194: FUNCTION Get_End_Date1
195: RETURN DATE
196: IS
197: BEGIN
198: RETURN PA_RESOURCE_PVT.end_date1;
199: END;
200:
201: FUNCTION get_scale_type
202: RETURN VARCHAR2

Line 205: RETURN PA_RESOURCE_PVT.scale_type;

201: FUNCTION get_scale_type
202: RETURN VARCHAR2
203: IS
204: BEGIN
205: RETURN PA_RESOURCE_PVT.scale_type;
206: END;
207:
208:
209: -------------------------------------------------------------------------------+

Line 223: l_resource_denorm_rec PA_RESOURCE_PVT.Resource_denorm_Rec_type;

219: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
220: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
221: x_msg_count OUT NOCOPY NUMBER) --File.Sql.39 bug 4440895
222: IS
223: l_resource_denorm_rec PA_RESOURCE_PVT.Resource_denorm_Rec_type;
224: l_resource_id pa_resources_denorm.resource_id%TYPE := NULL;
225: l_return_status VARCHAR2(1);
226: l_err_msg_code fnd_new_messages.message_name%TYPE;
227: l_msg_index_out NUMBER;

Line 231: PA_DEBUG.init_err_stack('PA_RESOURCE_PVT.Insert_resource_denorm');

227: l_msg_index_out NUMBER;
228: l_rows_exists VARCHAR2(1);
229: BEGIN
230: -- Initialize the Error Stack
231: PA_DEBUG.init_err_stack('PA_RESOURCE_PVT.Insert_resource_denorm');
232:
233: -- Initialize the return status to success
234: x_return_status := FND_API.G_RET_STS_SUCCESS;
235:

Line 409: (p_pkg_name => 'PA_RESOURCE_PVT.Insert_resource_denorm'

405: ROLLBACK TO RES_PVT_INSERT_RES_DENORM;
406:
407: -- Set the exception Message and the stack
408: FND_MSG_PUB.add_exc_msg
409: (p_pkg_name => 'PA_RESOURCE_PVT.Insert_resource_denorm'
410: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
411:
412: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
413:

Line 461: l_resource_denorm_new_rec PA_RESOURCE_PVT.Resource_denorm_Rec_type;

457: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
458: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
459: x_msg_count OUT NOCOPY NUMBER ) --File.Sql.39 bug 4440895
460: IS
461: l_resource_denorm_new_rec PA_RESOURCE_PVT.Resource_denorm_Rec_type;
462: l_resource_id NUMBER;
463: l_exists VARCHAR2(1);
464: l_return_status VARCHAR2(1);
465: l_err_msg_code fnd_new_messages.message_name%TYPE;

Line 470: PA_DEBUG.init_err_stack('PA_RESOURCE_PVT.Update_resource_denorm');

466: l_msg_index_out NUMBER;
467:
468: BEGIN
469: -- Initialize the Error Stack
470: PA_DEBUG.init_err_stack('PA_RESOURCE_PVT.Update_resource_denorm');
471:
472: -- Initialize the return status to success
473: x_return_status := FND_API.G_RET_STS_SUCCESS;
474:

Line 595: (p_pkg_name => 'PA_RESOURCE_PVT.Update_resource_denorm'

591: ROLLBACK TO RES_PVT_UPDATE_RES_DENORM;
592:
593: -- Set the exception Message and the stack
594: FND_MSG_PUB.add_exc_msg
595: (p_pkg_name => 'PA_RESOURCE_PVT.Update_resource_denorm'
596: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
597:
598: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
599:

Line 680: (p_pkg_name => 'PA_RESOURCE_PVT.update_person_res_denorm_recs',

676: EXCEPTION
677: WHEN OTHERS THEN
678: -- Set the exception Message and the stack
679: FND_MSG_PUB.add_exc_msg
680: (p_pkg_name => 'PA_RESOURCE_PVT.update_person_res_denorm_recs',
681: p_procedure_name => PA_DEBUG.G_Err_Stack );
682:
683: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
684: -- RAISE;

Line 751: (p_pkg_name => 'PA_RESOURCE_PVT.update_person_res_denorm_recs'

747: WHEN OTHERS THEN
748:
749: -- Set the exception Message and the stack
750: FND_MSG_PUB.add_exc_msg
751: (p_pkg_name => 'PA_RESOURCE_PVT.update_person_res_denorm_recs'
752: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
753:
754: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
755:

Line 814: (p_pkg_name => 'PA_RESOURCE_PVT.update_person_res_denorm_recs',

810: WHEN OTHERS THEN
811:
812: -- Set the exception Message and the stack
813: FND_MSG_PUB.add_exc_msg
814: (p_pkg_name => 'PA_RESOURCE_PVT.update_person_res_denorm_recs',
815: p_procedure_name => 'PA_RESOURCE_PVT.syncronize_manager_name'); --PA_DEBUG.G_Err_Stack ); 5336386
816:
817: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
818:

Line 815: p_procedure_name => 'PA_RESOURCE_PVT.syncronize_manager_name'); --PA_DEBUG.G_Err_Stack ); 5336386

811:
812: -- Set the exception Message and the stack
813: FND_MSG_PUB.add_exc_msg
814: (p_pkg_name => 'PA_RESOURCE_PVT.update_person_res_denorm_recs',
815: p_procedure_name => 'PA_RESOURCE_PVT.syncronize_manager_name'); --PA_DEBUG.G_Err_Stack ); 5336386
816:
817: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
818:
819: END syncronize_manager_name;

Line 862: (p_pkg_name => 'PA_RESOURCE_PVT.update_person_res_denorm_recs'

858: EXCEPTION
859: WHEN OTHERS THEN
860: -- Set the exception Message and the stack
861: FND_MSG_PUB.add_exc_msg
862: (p_pkg_name => 'PA_RESOURCE_PVT.update_person_res_denorm_recs'
863: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
864:
865: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
866:

Line 904: ( p_pkg_name => 'PA_RESOURCE_PVT.delete_resource_denorm'

900: EXCEPTION
901: WHEN OTHERS THEN
902: -- Set the exception Message and the stack
903: FND_MSG_PUB.add_exc_msg
904: ( p_pkg_name => 'PA_RESOURCE_PVT.delete_resource_denorm'
905: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
906:
907: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
908: END delete_resource_denorm;

Line 1403: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_RESOURCE_PVT.Populate_Resources_Denorm'

1399: ,p_commit => p_commit
1400: ,x_return_status => l_return_status);
1401: /* Bug 2898766 - End */
1402: WHEN OTHERS THEN
1403: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_RESOURCE_PVT.Populate_Resources_Denorm'
1404: , p_procedure_name => PA_DEBUG.G_Err_Stack);
1405: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
1406: RAISE;
1407:

Line 1868: pa_resource_pvt.get_res_conf_availability(resource_id, nvl(item_date,' || '''' || p_cstart_date || ''''|| '),

1864: (lead(item_date) over(order by item_date)) - 1,
1865: c * 100 ,
1866: ' || '''C''' ||
1867: ' , resource_id,
1868: pa_resource_pvt.get_res_conf_availability(resource_id, nvl(item_date,' || '''' || p_cstart_date || ''''|| '),
1869: nvl((lead(item_date) over(order by item_date)),' || '''' || p_cend_date || ''''|| ') - 1),
1870: sysdate,
1871: sysdate,
1872: ' || l_created_by || ',

Line 1910: pa_resource_pvt.get_res_conf_availability(resource_id, nvl(item_date, :cstart_date ),

1906: (lead(item_date) over(order by item_date)) - 1,
1907: c * 100 ,
1908: :c,
1909: resource_id,
1910: pa_resource_pvt.get_res_conf_availability(resource_id, nvl(item_date, :cstart_date ),
1911: nvl((lead(item_date) over(order by item_date)), :cend_date ) - 1),
1912: sysdate,
1913: sysdate,
1914: :created_by,

Line 1953: pa_resource_pvt.get_res_prov_conf_availability(resource_id, nvl(item_date,' || '''' || p_bstart_date || '''' || '), nvl((lead(item_date) over(order by item_date)),' || '''' || p_bend_date || ''''|| ') - 1),

1949: (lead(item_date) over(order by item_date)) - 1,
1950: c * 100 ,
1951: ' || '''B''' ||
1952: ' , resource_id,
1953: pa_resource_pvt.get_res_prov_conf_availability(resource_id, nvl(item_date,' || '''' || p_bstart_date || '''' || '), nvl((lead(item_date) over(order by item_date)),' || '''' || p_bend_date || ''''|| ') - 1),
1954: sysdate,
1955: sysdate,
1956: ' || l_created_by || ' ,
1957: ' || l_last_updated_by || ' ,

Line 1994: pa_resource_pvt.get_res_prov_conf_availability(resource_id, nvl(item_date, :bstart_date ), nvl((lead(item_date) over(order by item_date)), :bend_date ) - 1),

1990: (lead(item_date) over(order by item_date)) - 1,
1991: c * 100 ,
1992: :b,
1993: resource_id,
1994: pa_resource_pvt.get_res_prov_conf_availability(resource_id, nvl(item_date, :bstart_date ), nvl((lead(item_date) over(order by item_date)), :bend_date ) - 1),
1995: sysdate,
1996: sysdate,
1997: :created_by,
1998: :last_updated_by,

Line 2281: pa_resource_pvt.get_res_conf_availability(resource_id, nvl(item_date,' || '''' || p_cstart_date || '''' || '), nvl((lead(item_date) over(order by item_date)),' || '''' || p_cend_date || ''''|| ') - 1),

2277: (lead(item_date) over(order by item_date)) - 1,
2278: c * 100 ,
2279: ' || '''C''' ||
2280: ' , resource_id,
2281: pa_resource_pvt.get_res_conf_availability(resource_id, nvl(item_date,' || '''' || p_cstart_date || '''' || '), nvl((lead(item_date) over(order by item_date)),' || '''' || p_cend_date || ''''|| ') - 1),
2282: sysdate,
2283: sysdate,
2284: ' || l_created_by || ',
2285: ' || l_last_updated_by || ',

Line 2330: pa_resource_pvt.get_res_conf_availability(resource_id, nvl(item_date, :cstart_date), nvl((lead(item_date) over(order by item_date)), :cend_date ) - 1),

2326: (lead(item_date) over(order by item_date)) - 1,
2327: c * 100 ,
2328: :c,
2329: resource_id,
2330: pa_resource_pvt.get_res_conf_availability(resource_id, nvl(item_date, :cstart_date), nvl((lead(item_date) over(order by item_date)), :cend_date ) - 1),
2331: sysdate,
2332: sysdate,
2333: :created_by,
2334: :last_updated_by,

Line 2380: pa_resource_pvt.get_res_prov_conf_availability(resource_id, nvl(item_date,' || '''' || p_bstart_date || '''' || '), nvl((lead(item_date) over(order by item_date)),' || '''' || p_bend_date || ''''|| ') - 1),

2376: (lead(item_date) over(order by item_date)) - 1,
2377: c * 100 ,
2378: ' || '''B''' ||
2379: ' , resource_id,
2380: pa_resource_pvt.get_res_prov_conf_availability(resource_id, nvl(item_date,' || '''' || p_bstart_date || '''' || '), nvl((lead(item_date) over(order by item_date)),' || '''' || p_bend_date || ''''|| ') - 1),
2381: sysdate,
2382: sysdate,
2383: ' || l_created_by || ',
2384: ' || l_last_updated_by ||',

Line 2430: pa_resource_pvt.get_res_prov_conf_availability(resource_id, nvl(item_date, :bstart_date ), nvl((lead(item_date) over(order by item_date)), :bend_date ) - 1),

2426: (lead(item_date) over(order by item_date)) - 1,
2427: c * 100 ,
2428: :b,
2429: resource_id,
2430: pa_resource_pvt.get_res_prov_conf_availability(resource_id, nvl(item_date, :bstart_date ), nvl((lead(item_date) over(order by item_date)), :bend_date ) - 1),
2431: sysdate,
2432: sysdate,
2433: :created_by,
2434: :last_updated_by,

Line 2844: PA_DEBUG.init_err_stack('PA_RESOURCE_PVT.Update_Res_Availability');

2840:
2841: BEGIN
2842:
2843: -- Initialize the Error Stack
2844: PA_DEBUG.init_err_stack('PA_RESOURCE_PVT.Update_Res_Availability');
2845:
2846: -- Initialize the return status to success
2847: x_return_status := FND_API.G_RET_STS_SUCCESS;
2848:

Line 2911: (p_pkg_name => 'PA_RESOURCE_PVT.Update_Res_Availability'

2907:
2908: WHEN OTHERS THEN
2909: -- Set the exception Message and the stack
2910: FND_MSG_PUB.add_exc_msg
2911: (p_pkg_name => 'PA_RESOURCE_PVT.Update_Res_Availability'
2912: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
2913:
2914: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2915:

Line 2980: pa_resource_pvt.populate_res_availability(

2976:
2977: delete
2978: from PA_RES_AVAILABILITY where RESOURCE_ID = rec.resource_id; --Added for bug 4928773
2979:
2980: pa_resource_pvt.populate_res_availability(
2981: p_resource_id => rec.resource_id,
2982: p_cstart_date => rec.start_date,
2983: p_cend_date => rec.end_date,
2984: p_bstart_date => rec.start_date,

Line 3091: END PA_RESOURCE_PVT;

3087:
3088: END Get_Staff_Mgr_Org_Id;
3089:
3090:
3091: END PA_RESOURCE_PVT;