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_FORECASTITEM_PVT dependencies on PA_FORECAST_ITEMS

Line 19: --PA_FORECAST_ITEMS_UTILS.log_message(p_msg);

15: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); /* Added Debug Profile Option variable initialization for bug#2674619 */
16:
17: PROCEDURE print_message(p_msg IN varchar2) IS
18: BEGIN
19: --PA_FORECAST_ITEMS_UTILS.log_message(p_msg);
20: if (p_msg is not null) then
21: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
22: pa_debug.write(x_module => 'pa.plsql.pa_forecastitem_pvt',
23: x_msg => p_msg,

Line 84: FROM pa_forecast_items

80: AVAILABILITY_DURATION NUMBER;
81:
82: CURSOR c1 IS
83: SELECT MAX(item_date) item_date
84: FROM pa_forecast_items
85: WHERE resource_id = TmpAsgnDtlRec.resource_id
86: AND delete_flag = 'N'
87: AND forecast_item_type = 'U';
88:

Line 456: lv_resource_id := PA_FORECAST_ITEMS_UTILS.get_resource_id(

452:
453: print_message('lv_start_date: ' || lv_start_date);
454: print_message('lv_end_date: ' || lv_end_date);
455:
456: lv_resource_id := PA_FORECAST_ITEMS_UTILS.get_resource_id(
457: p_person_id);
458:
459: OPEN asgmt_dtls(lv_resource_id);
460:

Line 1194: PA_FORECAST_ITEMS_UTILS.Get_assignment_Schedule(

1190:
1191: -- Get schedule data AND build day fI Records
1192: Print_message( 'Req - Calling Get_Assignment_Schedule');
1193:
1194: PA_FORECAST_ITEMS_UTILS.Get_assignment_Schedule(
1195: p_AsgnDtlRec.assignment_id,
1196: lv_start_date, lv_end_date,p_process_mode,
1197: Tmpscheduletab,
1198: lv_return_status, x_msg_count, x_msg_data);

Line 1533: FROM pa_forecast_items

1529: SELECT 'Y'
1530: INTO lv_exist_flag
1531: FROM DUAL
1532: WHERE EXISTS (SELECT NULL
1533: FROM pa_forecast_items
1534: WHERE assignment_id = p_assignment_id
1535: AND delete_flag = 'N');
1536:
1537: EXCEPTION

Line 2257: FROM pa_forecast_items hdr

2253: PROVISIONAL_QTY_tab,
2254: asgmt_sys_status_code_tab, capacity_quantity_tab,
2255: overcommitment_quantity_tab, availability_quantity_tab,
2256: overcommitment_flag_tab, availability_flag_tab
2257: FROM pa_forecast_items hdr
2258: WHERE assignment_id = p_assignment_id
2259: AND delete_flag = 'N'
2260: AND (trunc(hdr.item_date) < trunc(p_start_date)
2261: OR trunc(hdr.item_date) > trunc(p_end_date))

Line 2571: FROM pa_forecast_item_details dtl, pa_forecast_items hdr

2567: org_util_category_id_tab, resource_util_weighted_tab,
2568: org_util_weighted_tab, provisional_flag_tab,
2569: reversed_flag_tab, net_zero_flag_tab,
2570: reduce_capacity_flag_tab, line_num_reversed_tab
2571: FROM pa_forecast_item_details dtl, pa_forecast_items hdr
2572: WHERE hdr.assignment_id = p_assignment_id
2573: AND hdr.delete_flag = 'N'
2574: AND dtl.forecast_item_id = hdr.forecast_item_id
2575: AND (dtl.item_date < trunc(p_start_date)

Line 3023: FROM pa_forecast_items

3019: PROVISIONAL_QTY_tab,
3020: asgmt_sys_status_code_tab, capacity_quantity_tab,
3021: overcommitment_quantity_tab, availability_quantity_tab,
3022: overcommitment_flag_tab, availability_flag_tab
3023: FROM pa_forecast_items
3024: WHERE assignment_id = p_assignment_id
3025: AND delete_flag = 'N'
3026: AND item_date BETWEEN trunc(p_start_date) AND
3027: trunc(p_end_date) + 1 - (1/86400)

Line 3324: FROM pa_forecast_item_details dtl , pa_forecast_items hdr

3320: org_util_category_id_tab, resource_util_weighted_tab,
3321: org_util_weighted_tab, provisional_flag_tab,
3322: reversed_flag_tab, net_zero_flag_tab,
3323: reduce_capacity_flag_tab, line_num_reversed_tab
3324: FROM pa_forecast_item_details dtl , pa_forecast_items hdr
3325: WHERE hdr.assignment_id = p_assignment_id
3326: AND hdr.delete_flag = 'N'
3327: AND dtl.forecast_item_id = hdr.forecast_item_id
3328: AND dtl.item_date BETWEEN trunc(p_start_date) AND

Line 3589: PA_FORECAST_ITEMS_UTILS.get_period_set_name

3585: Print_message(
3586: 'Req - Get_period_set_name (pvdr) ');
3587:
3588: lv_pvdr_period_set_name :=
3589: PA_FORECAST_ITEMS_UTILS.get_period_set_name
3590: (p_AsgnDtlRec.expenditure_org_id);
3591:
3592: if lv_pvdr_period_set_name = 'NO_DATA_FOUND' THEN
3593:

Line 3621: PA_FORECAST_ITEMS_UTILS.get_period_set_name (

3617: 'Req - Get_period_set_name (rcvr) ');
3618:
3619: Print_message('lv_project_org_id: ' || lv_project_org_id);
3620: lv_rcvr_period_set_name :=
3621: PA_FORECAST_ITEMS_UTILS.get_period_set_name (
3622: lv_project_org_id);
3623:
3624: if lv_rcvr_period_set_name = 'NO_DATA_FOUND' THEN
3625:

Line 3642: PA_FORECAST_ITEMS_UTILS.get_pa_period_name(

3638:
3639: Print_message(
3640: 'Req - Get_pa_period_name (pvdr) ');
3641:
3642: PA_FORECAST_ITEMS_UTILS.get_pa_period_name(
3643: p_AsgnDtlRec.expenditure_org_id,
3644: p_AsgnDtlRec.start_date,
3645: p_AsgnDtlRec.end_date,
3646: ld_pvdrpa_startdate_tab,

Line 3654: PA_FORECAST_ITEMS_UTILS.get_gl_period_name(

3650:
3651: Print_message(
3652: 'Req - Get_gl_period_name (pvdr) ');
3653:
3654: PA_FORECAST_ITEMS_UTILS.get_gl_period_name(
3655: p_AsgnDtlRec.expenditure_org_id,
3656: p_AsgnDtlRec.start_date,
3657: p_AsgnDtlRec.end_date,
3658: ld_pvdrgl_startdate_tab,

Line 3666: PA_FORECAST_ITEMS_UTILS.get_pa_period_name(

3662:
3663: Print_message(
3664: 'Req - Get_pa_period_name (rcvr) ');
3665: Print_message('lv_project_org_id: ' || lv_project_org_id);
3666: PA_FORECAST_ITEMS_UTILS.get_pa_period_name(
3667: lv_project_org_id,
3668: p_AsgnDtlRec.start_date,
3669: p_AsgnDtlRec.end_date,
3670: ld_rcvrpa_startdate_tab,

Line 3678: PA_FORECAST_ITEMS_UTILS.get_gl_period_name(

3674:
3675: Print_message(
3676: 'Req - Get_gl_period_name (rcvr) ');
3677: Print_message('lv_project_org_id: ' || lv_project_org_id);
3678: PA_FORECAST_ITEMS_UTILS.get_gl_period_name(
3679: lv_project_org_id,
3680: p_AsgnDtlRec.start_date,
3681: p_AsgnDtlRec.end_date,
3682: ld_rcvrgl_startdate_tab,

Line 3691: PA_FORECAST_ITEMS_UTILS.get_Week_Dates_Range_Fc(

3687:
3688: Print_message(
3689: 'Req - Get_week_dates_range_fc ');
3690:
3691: PA_FORECAST_ITEMS_UTILS.get_Week_Dates_Range_Fc(
3692: p_AsgnDtlRec.start_date,
3693: p_AsgnDtlRec.end_date,
3694: lv_WeekDateRange_Tab,
3695: x_return_status,

Line 3959: PA_FORECAST_ITEMS_UTILS.get_next_forecast_item_id;

3955: lv_call_pos := 'Req : in if data create';
3956: IF TmpDayTab(i).action_flag <> 'E' THEN
3957:
3958: lv_forecast_item_id :=
3959: PA_FORECAST_ITEMS_UTILS.get_next_forecast_item_id;
3960:
3961: TmpDayTab(i).forecast_item_id := lv_forecast_item_id;
3962:
3963: ELSE

Line 4550: PA_FORECAST_ITEMS_UTILS.get_work_type_details(

4546:
4547: Print_message(
4548: 'Req - Get_work_type_details');
4549:
4550: PA_FORECAST_ITEMS_UTILS.get_work_type_details(
4551: p_AsgnDtlRec.work_type_id,
4552: lv_billable_flag,
4553: l_resutilweighted,
4554: l_orgutilweighted,

Line 5249: IF (PA_FORECAST_ITEMS_UTILS.Set_User_Lock(

5245: -- print_message('Assignment is outside of HR assignment');
5246: -- raise l_no_fis_to_create;
5247: --end if;
5248:
5249: IF (PA_FORECAST_ITEMS_UTILS.Set_User_Lock(
5250: p_AsgnDtlRec.resource_id, 'RES') <> 0) THEN
5251: RAISE l_cannot_acquire_lock;
5252:
5253: END IF;

Line 5393: PA_FORECAST_ITEMS_UTILS.Get_assignment_Schedule(

5389:
5390: Print_message(
5391: 'Asg - Calling Get_Assignment_Schedule');
5392:
5393: PA_FORECAST_ITEMS_UTILS.Get_assignment_Schedule(
5394: p_AsgnDtlRec.assignment_id,
5395: lv_start_date,
5396: lv_end_date,
5397: p_process_mode,

Line 5639: li_lock_status := PA_FORECAST_ITEMS_UTILS.Release_User_lock(p_AsgnDtlRec.resource_id, 'RES');

5635:
5636: PA_DEBUG.Reset_Err_Stack;
5637:
5638: /** Release the lock once process is completed **/
5639: li_lock_status := PA_FORECAST_ITEMS_UTILS.Release_User_lock(p_AsgnDtlRec.resource_id, 'RES');
5640: Print_message('Resource lock released');
5641:
5642: x_return_status := lv_return_status;
5643:

Line 5745: li_lock_status := PA_FORECAST_ITEMS_UTILS.Release_User_lock(p_AsgnDtlRec.resource_id, 'RES');

5741:
5742:
5743: END IF;
5744: /** lock must be released once process completes or errors out **/
5745: li_lock_status := PA_FORECAST_ITEMS_UTILS.Release_User_lock(p_AsgnDtlRec.resource_id, 'RES');
5746: Print_message('Resource lock released ');
5747:
5748: WHEN OTHERS THEN
5749: print_message('Failed in Generate_Assignemnt api');

Line 5778: li_lock_status := PA_FORECAST_ITEMS_UTILS.Release_User_lock(p_AsgnDtlRec.resource_id, 'RES');

5774: End If;
5775: Print_message(x_msg_data);
5776:
5777: /** lock must be released once process completes or errors out **/
5778: li_lock_status := PA_FORECAST_ITEMS_UTILS.Release_User_lock(p_AsgnDtlRec.resource_id, 'RES');
5779: Print_message('Resource lock released ');
5780:
5781: RAISE;
5782:

Line 5808: FROM pa_forecast_items

5804: SELECT 'Y'
5805: INTO lv_exist_flag
5806: FROM dual
5807: WHERE exists (SELECT null
5808: FROM pa_forecast_items
5809: WHERE assignment_id = p_assignment_id
5810: AND delete_flag = 'N');
5811:
5812: EXCEPTION

Line 6071: FROM pa_forecast_items hdr

6067: PROVISIONAL_QTY_tab,
6068: asgmt_sys_status_code_tab, capacity_quantity_tab,
6069: overcommitment_quantity_tab, availability_quantity_tab,
6070: overcommitment_flag_tab, availability_flag_tab
6071: FROM pa_forecast_items hdr
6072: WHERE hdr.assignment_id = p_assignment_id
6073: AND hdr.delete_flag = 'N'
6074: order by item_date, forecast_item_id ;
6075:

Line 6381: FROM pa_forecast_item_details dtl, pa_forecast_items hdr

6377: org_util_category_id_tab, resource_util_weighted_tab,
6378: org_util_weighted_tab, provisional_flag_tab,
6379: reversed_flag_tab, net_zero_flag_tab,
6380: reduce_capacity_flag_tab, line_num_reversed_tab
6381: FROM pa_forecast_item_details dtl, pa_forecast_items hdr
6382: WHERE hdr.assignment_id = p_assignment_id
6383: AND hdr.delete_flag = 'N'
6384: AND dtl.forecast_item_id = hdr.forecast_item_id
6385: AND dtl.line_num =

Line 6838: FROM pa_forecast_items hdr

6834: expenditure_type_class_tab, cost_rejection_code_tab,
6835: rev_rejection_code_tab, tp_rejection_code_tab,
6836: burden_rejection_code_tab, other_rejection_code_tab,
6837: delete_flag_tab, error_flag_tab, provisional_flag_tab
6838: FROM pa_forecast_items hdr
6839: WHERE hdr.resource_id = p_resource_id
6840: AND hdr.delete_flag = 'N'
6841: AND hdr.forecast_item_type = 'U'
6842: order by item_date, forecast_item_id ;

Line 7133: FROM pa_forecast_item_details dtl, pa_forecast_items hdr

7129: org_util_category_id_tab, resource_util_weighted_tab,
7130: org_util_weighted_tab, provisional_flag_tab,
7131: reversed_flag_tab, net_zero_flag_tab,
7132: reduce_capacity_flag_tab, line_num_reversed_tab
7133: FROM pa_forecast_item_details dtl, pa_forecast_items hdr
7134: WHERE hdr.resource_id = p_resource_id
7135: AND hdr.delete_flag = 'N'
7136: AND hdr.forecast_item_type = 'U'
7137: AND dtl.forecast_item_id = hdr.forecast_item_id

Line 7591: PA_FORECAST_ITEMS_UTILS.get_resource_ou(

7587:
7588:
7589: Print_message( 'Asg - Get_resource_ou');
7590:
7591: PA_FORECAST_ITEMS_UTILS.get_resource_ou(
7592: p_AsgnDtlRec.resource_id,
7593: p_AsgnDtlRec.start_date,
7594: p_AsgnDtlRec.end_date,
7595: ld_resou_startdate_tab,ld_resou_enddate_tab,

Line 7614: lv_person_id := PA_FORECAST_ITEMS_UTILS.get_person_id(

7610:
7611:
7612: Print_message( 'Asg - Get_person_id');
7613:
7614: lv_person_id := PA_FORECAST_ITEMS_UTILS.get_person_id(
7615: p_AsgnDtlRec.resource_id);
7616:
7617: Print_message('Asg - Get_res_org_and_job');
7618:

Line 7619: PA_FORECAST_ITEMS_UTILS.get_res_org_and_job(

7615: p_AsgnDtlRec.resource_id);
7616:
7617: Print_message('Asg - Get_res_org_and_job');
7618:
7619: PA_FORECAST_ITEMS_UTILS.get_res_org_and_job(
7620: lv_person_id, p_AsgnDtlRec.start_date,
7621: p_AsgnDtlRec.end_date,
7622: ld_orgn_startdate_tab, ld_orgn_enddate_tab,
7623: l_orgn_tab, l_jobid_tab);

Line 7655: PA_FORECAST_ITEMS_UTILS.get_period_set_name (

7651:
7652: Print_message('Asg - Get_period_set_name (rcvr)');
7653: Print_message('lv_project_org_id: ' || lv_project_org_id);
7654: lv_rcvr_period_set_name :=
7655: PA_FORECAST_ITEMS_UTILS.get_period_set_name (
7656: lv_project_org_id);
7657:
7658: if lv_rcvr_period_set_name = 'NO_DATA_FOUND' THEN
7659:

Line 7671: PA_FORECAST_ITEMS_UTILS.get_pa_period_name(

7667: Print_message(
7668: 'Asg - Get_pa_period_name (rcvr)');
7669:
7670: Print_message('lv_project_org_id: ' || lv_project_org_id);
7671: PA_FORECAST_ITEMS_UTILS.get_pa_period_name(
7672: lv_project_org_id,
7673: p_AsgnDtlRec.start_date,
7674: p_AsgnDtlRec.end_date,
7675: ld_rcvrpa_startdate_tab,

Line 7686: PA_FORECAST_ITEMS_UTILS.get_gl_period_name(

7682: Print_message(
7683: 'Asg - Get_gl_period_name (rcvr)');
7684:
7685: Print_message('lv_project_org_id: ' || lv_project_org_id);
7686: PA_FORECAST_ITEMS_UTILS.get_gl_period_name(
7687: lv_project_org_id,
7688: p_AsgnDtlRec.start_date,
7689: p_AsgnDtlRec.end_date,
7690: ld_rcvrgl_startdate_tab,

Line 7699: PA_FORECAST_ITEMS_UTILS.get_Week_Dates_Range_Fc(

7695:
7696: Print_message(
7697: 'Asg - Get_week_dates_range_fc ');
7698:
7699: PA_FORECAST_ITEMS_UTILS.get_Week_Dates_Range_Fc(
7700: p_AsgnDtlRec.start_date,
7701: p_AsgnDtlRec.end_date,
7702: lv_WeekDateRange_Tab,
7703: x_return_status,

Line 7839: PA_FORECAST_ITEMS_UTILS.get_period_set_name(

7835: Print_message(
7836: 'Asg - Get_period_set_name (pvdr) ');
7837:
7838: lv_pvdr_period_set_name :=
7839: PA_FORECAST_ITEMS_UTILS.get_period_set_name(
7840: lv_resou);
7841:
7842: if lv_pvdr_period_set_name = 'NO_DATA_FOUND' THEN
7843: lv_pvdr_period_set_name := '-99';

Line 7857: PA_FORECAST_ITEMS_UTILS.get_pa_period_name(

7853:
7854: Print_message(
7855: 'Asg - Get_pa_period_name (pvdr)');
7856:
7857: PA_FORECAST_ITEMS_UTILS.get_pa_period_name(
7858: lv_resou,
7859: p_AsgnDtlRec.start_date,
7860: p_AsgnDtlRec.end_date,
7861: ld_pvdrpa_startdate_tab,

Line 7870: PA_FORECAST_ITEMS_UTILS.get_gl_period_name(

7866:
7867: Print_message(
7868: 'Asg - Get_gl_period_name (pvdr)');
7869:
7870: PA_FORECAST_ITEMS_UTILS.get_gl_period_name(
7871: lv_resou,
7872: p_AsgnDtlRec.start_date,
7873: p_AsgnDtlRec.end_date,
7874: ld_pvdrgl_startdate_tab,

Line 7885: PA_FORECAST_ITEMS_UTILS.get_forecastoptions(

7881: Print_message(
7882: 'Asg - Get_forecastoptions');
7883:
7884: -- dbms_output.put_line(l_resou_tab(lv_res_index));
7885: PA_FORECAST_ITEMS_UTILS.get_forecastoptions(
7886: lv_resou,
7887: -- lv_include_admin_proj_flag, Bug 4576715
7888: lv_util_cal_method,
7889: lv_bill_unasg_proj_id,

Line 8195: PA_FORECAST_ITEMS_UTILS.get_next_forecast_item_id;

8191: lv_call_pos := 'Asg : in if data create ';
8192: IF TmpDayTab(i).action_flag <> 'E' THEN
8193:
8194: lv_forecast_item_id :=
8195: PA_FORECAST_ITEMS_UTILS.get_next_forecast_item_id;
8196:
8197: TmpDayTab(i).forecast_item_id := lv_forecast_item_id;
8198:
8199: ELSE

Line 8848: lv_resource_type := PA_FORECAST_ITEMS_UTILS.get_resource_type(

8844:
8845:
8846: Print_message( 'Asg - Get_resource_type');
8847:
8848: lv_resource_type := PA_FORECAST_ITEMS_UTILS.get_resource_type(
8849: p_AsgnDtlRec.resource_id);
8850:
8851: lv_amount_type_id := get_AmountTypeID;
8852:

Line 8853: lv_person_id := PA_FORECAST_ITEMS_UTILS.get_person_id(

8849: p_AsgnDtlRec.resource_id);
8850:
8851: lv_amount_type_id := get_AmountTypeID;
8852:
8853: lv_person_id := PA_FORECAST_ITEMS_UTILS.get_person_id(
8854: p_AsgnDtlRec.resource_id);
8855:
8856: Print_message('Asg - Get_work_type_details');
8857: PA_FORECAST_ITEMS_UTILS.get_work_type_details(

Line 8857: PA_FORECAST_ITEMS_UTILS.get_work_type_details(

8853: lv_person_id := PA_FORECAST_ITEMS_UTILS.get_person_id(
8854: p_AsgnDtlRec.resource_id);
8855:
8856: Print_message('Asg - Get_work_type_details');
8857: PA_FORECAST_ITEMS_UTILS.get_work_type_details(
8858: p_AsgnDtlRec.work_type_id,
8859: lv_billable_flag,
8860: l_resutilweighted,
8861: l_orgutilweighted,

Line 9685: IF (PA_FORECAST_ITEMS_UTILS.Set_User_Lock(

9681:
9682: Print_message(
9683: 'Entering Regenerate_Res_Unassigned_FI');
9684:
9685: IF (PA_FORECAST_ITEMS_UTILS.Set_User_Lock(
9686: p_resource_id, 'RES') <> 0) THEN
9687: RAISE l_cannot_acquire_lock;
9688:
9689: END IF;

Line 9912: li_lock_status := PA_FORECAST_ITEMS_UTILS.Release_User_lock(p_resource_id, 'RES');

9908: END IF;
9909:
9910: If TmpScheduleTab.count = 0 then
9911: /** if the schedule tab is zero then release the lock and return **/
9912: li_lock_status := PA_FORECAST_ITEMS_UTILS.Release_User_lock(p_resource_id, 'RES');
9913: Print_message('Resource lock released ');
9914: Return;
9915: End if;
9916:

Line 9984: PA_FORECAST_ITEMS_UTILS.Get_Resource_Asgn_Schedules (

9980: IF lv_return_status = FND_API.G_RET_STS_SUCCESS THEN
9981:
9982: Print_message( 'Calling Get_Resource_Asgn_Schedule');
9983:
9984: PA_FORECAST_ITEMS_UTILS.Get_Resource_Asgn_Schedules (
9985: p_resource_id,
9986: p_start_date,
9987: p_end_date ,
9988: TmpAsgnScheduleTab,

Line 10381: li_lock_status := PA_FORECAST_ITEMS_UTILS.Release_User_lock(p_resource_id, 'RES');

10377: ------------------END AVAILABILITY SUMMARY TABLE POPULATION-----------------
10378: ----------------------------------------------------------------------------
10379:
10380: /** once the process is completed release the lock **/
10381: li_lock_status := PA_FORECAST_ITEMS_UTILS.Release_User_lock(p_resource_id, 'RES');
10382: Print_message('Resource lock released ');
10383:
10384: END IF;
10385:

Line 10400: li_lock_status := PA_FORECAST_ITEMS_UTILS.Release_User_lock(p_resource_id, 'RES');

10396: -- There are no FIs to create.
10397: PA_DEBUG.Reset_Err_Stack;
10398: x_return_status := lv_return_status;
10399: -- release the lock
10400: li_lock_status := PA_FORECAST_ITEMS_UTILS.Release_User_lock(p_resource_id, 'RES');
10401: Print_message('Resource lock released ');
10402:
10403: WHEN NO_DATA_FOUND THEN
10404:

Line 10468: li_lock_status := PA_FORECAST_ITEMS_UTILS.Release_User_lock(p_resource_id, 'RES');

10464: RAISE;
10465:
10466: END IF;
10467: /** lock should be released if the process fails **/
10468: li_lock_status := PA_FORECAST_ITEMS_UTILS.Release_User_lock(p_resource_id, 'RES');
10469: Print_message('Resouce lock released ');
10470:
10471: WHEN l_cannot_acquire_lock THEN
10472:

Line 10510: li_lock_status := PA_FORECAST_ITEMS_UTILS.Release_User_lock(p_resource_id, 'RES');

10506: x_msg_count := 1;
10507: x_msg_data := sqlerrm;
10508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10509: /** release the lock if the process fails **/
10510: li_lock_status := PA_FORECAST_ITEMS_UTILS.Release_User_lock(p_resource_id, 'RES');
10511: Print_message('Resource lock released ');
10512:
10513: -- 4537865
10514: p_start_date := NULL ;

Line 10712: FROM pa_forecast_items

10708: PROVISIONAL_QTY_tab,
10709: asgmt_sys_status_code_tab, capacity_quantity_tab,
10710: overcommitment_quantity_tab, availability_quantity_tab,
10711: overcommitment_flag_tab, availability_flag_tab
10712: FROM pa_forecast_items
10713: WHERE resource_id = p_resource_id
10714: AND forecast_item_type = 'U'
10715: AND delete_flag = 'N'
10716: /* Commented for bug3998166

Line 11019: FROM pa_forecast_item_details dtl, pa_forecast_items hdr

11015: org_util_category_id_tab, resource_util_weighted_tab,
11016: org_util_weighted_tab, provisional_flag_tab,
11017: reversed_flag_tab, net_zero_flag_tab,
11018: reduce_capacity_flag_tab, line_num_reversed_tab
11019: FROM pa_forecast_item_details dtl, pa_forecast_items hdr
11020: WHERE hdr.resource_id = p_resource_id
11021: AND hdr.delete_flag = 'N'
11022: AND hdr.forecast_item_type = 'U'
11023: /***Addeded the following condition to fix the bug : 1913377

Line 11352: PA_FORECAST_ITEMS_UTILS.get_resource_ou(

11348:
11349: Print_message(
11350: 'Res - Get_resource_ou ');
11351:
11352: PA_FORECAST_ITEMS_UTILS.get_resource_ou(
11353: p_resource_id,p_start_date, p_end_date,
11354: ld_resou_startdate_tab,ld_resou_enddate_tab,
11355: l_resou_tab);
11356:

Line 11374: PA_FORECAST_ITEMS_UTILS.get_person_id(p_resource_id);

11370:
11371: Print_message( 'Res - Get_Person_id ');
11372:
11373: lv_person_id :=
11374: PA_FORECAST_ITEMS_UTILS.get_person_id(p_resource_id);
11375:
11376:
11377: Print_message(
11378: 'Res - Get_res_org_and_job ');

Line 11380: PA_FORECAST_ITEMS_UTILS.get_res_org_and_job(

11376:
11377: Print_message(
11378: 'Res - Get_res_org_and_job ');
11379:
11380: PA_FORECAST_ITEMS_UTILS.get_res_org_and_job(
11381: lv_person_id, p_start_date, p_end_date,
11382: ld_orgn_startdate_tab, ld_orgn_enddate_tab,
11383: l_orgn_tab, l_jobid_tab);
11384:

Line 11401: PA_FORECAST_ITEMS_UTILS.get_Week_Dates_Range_Fc(

11397:
11398: Print_message(
11399: 'Res - Get_week_dates_range_fc ');
11400:
11401: PA_FORECAST_ITEMS_UTILS.get_Week_Dates_Range_Fc(
11402: p_start_date,
11403: p_end_date,
11404: lv_WeekDateRange_Tab,
11405: lv_return_status,

Line 11514: PA_FORECAST_ITEMS_UTILS.get_period_set_name(

11510: Print_message(
11511: 'Res - Get_period_set_name (pvdr) ');
11512:
11513: lv_pvdr_period_set_name :=
11514: PA_FORECAST_ITEMS_UTILS.get_period_set_name(
11515: lv_resou);
11516:
11517: if lv_pvdr_period_set_name = 'NO_DATA_FOUND' THEN
11518:

Line 11534: PA_FORECAST_ITEMS_UTILS.get_pa_period_name(

11530:
11531: Print_message(
11532: 'Res - Get_pa_period_name (pvdr) ');
11533:
11534: PA_FORECAST_ITEMS_UTILS.get_pa_period_name(
11535: lv_resou,p_start_date,
11536: p_end_date,
11537: ld_pvdrpa_startdate_tab,
11538: ld_pvdrpa_enddate_tab,

Line 11553: PA_FORECAST_ITEMS_UTILS.get_gl_period_name(

11549:
11550: Print_message(
11551: 'Res - Get_gl_period_name (pvdr) ');
11552:
11553: PA_FORECAST_ITEMS_UTILS.get_gl_period_name(
11554: lv_resou,p_start_date,
11555: p_end_date,
11556: ld_pvdrgl_startdate_tab,
11557: ld_pvdrgl_enddate_tab,

Line 11572: PA_FORECAST_ITEMS_UTILS.get_forecastoptions(

11568:
11569: Print_message(
11570: 'Res - Get_forecastoptions ');
11571:
11572: PA_FORECAST_ITEMS_UTILS.get_forecastoptions(
11573: lv_resou,
11574: -- lv_include_admin_proj_flag, Bug 4576715
11575: lv_util_cal_method,
11576: lv_bill_unasg_proj_id,

Line 11647: PA_FORECAST_ITEMS_UTILS.get_period_set_name (

11643: 'Res - Get_Period_set_name (rcvr) ');
11644:
11645: Print_message('lv_project_org_id: ' || lv_project_org_id);
11646: lv_rcvr_period_set_name :=
11647: PA_FORECAST_ITEMS_UTILS.get_period_set_name (
11648: lv_project_org_id);
11649:
11650: if lv_rcvr_period_set_name = 'NO_DATA_FOUND' THEN
11651:

Line 11662: PA_FORECAST_ITEMS_UTILS.get_pa_period_name(

11658: Print_message(
11659: 'Res - Get_PA_Period_name (rcvr) ');
11660:
11661: Print_message('lv_project_org_id: ' || lv_project_org_id);
11662: PA_FORECAST_ITEMS_UTILS.get_pa_period_name(
11663: lv_project_org_id,
11664: p_start_date,
11665: p_end_date,
11666: ld_rcvrpa_startdate_tab,

Line 11683: PA_FORECAST_ITEMS_UTILS.get_gl_period_name(

11679: Print_message(
11680: 'Res - Get_gl_Period_name (rcvr) ');
11681:
11682: Print_message('lv_project_org_id: ' || lv_project_org_id);
11683: PA_FORECAST_ITEMS_UTILS.get_gl_period_name(
11684: lv_project_org_id,
11685: p_start_date,
11686: p_end_date,
11687: ld_rcvrgl_startdate_tab,

Line 12055: PA_FORECAST_ITEMS_UTILS.get_next_forecast_item_id;

12051: --print_message('JM: 115');
12052: IF TmpDayTab(i).action_flag <> 'E' THEN
12053:
12054: lv_forecast_item_id :=
12055: PA_FORECAST_ITEMS_UTILS.get_next_forecast_item_id;
12056:
12057: TmpDayTab(i).forecast_item_id := lv_forecast_item_id;
12058:
12059: ELSE

Line 12730: lv_resource_type := PA_FORECAST_ITEMS_UTILS.get_resource_type(

12726:
12727: Print_message(
12728: 'Res - Get_resource_type');
12729:
12730: lv_resource_type := PA_FORECAST_ITEMS_UTILS.get_resource_type(
12731: p_resource_id);
12732:
12733: lv_amount_type_id := get_AmountTypeID;
12734:

Line 12735: lv_person_id := PA_FORECAST_ITEMS_UTILS.get_person_id(

12731: p_resource_id);
12732:
12733: lv_amount_type_id := get_AmountTypeID;
12734:
12735: lv_person_id := PA_FORECAST_ITEMS_UTILS.get_person_id(
12736: p_resource_id);
12737:
12738:
12739: if (TmpDayTab.count <> 0) then

Line 12802: PA_FORECAST_ITEMS_UTILS.get_work_type_details(

12798: -- If the work_type_id is same as the previous loop iteration then no need to fetch it from the database. NVL check added since work_type_id may be passed as null
12799: -- IF (nvl(TmpDayTab(i).work_type_id, -99) <> nvl(l_worktype_cache, -99)) THEN
12800: IF (nvl(TmpDayTab(i).work_type_id, -199) <> nvl(l_worktype_cache, -199)) THEN --Bug 6202828 Changed the nvl value from -99 to -199
12801: Print_message('PA_FORECASTITEM_PVT.Build_FI_Dtl_Res : TmpDayTab(i).work_type_id not same as the previous value, get from the database');
12802: PA_FORECAST_ITEMS_UTILS.get_work_type_details(
12803: TmpDayTab(i).work_type_id,
12804: lv_billable_flag,
12805: l_resutilweighted,
12806: l_orgutilweighted,

Line 13683: FROM pa_forecast_items

13679: PROVISIONAL_QTY_tab,
13680: asgmt_sys_status_code_tab, capacity_quantity_tab,
13681: overcommitment_quantity_tab, availability_quantity_tab,
13682: overcommitment_flag_tab, availability_flag_tab
13683: FROM pa_forecast_items
13684: WHERE assignment_id = p_AsgnDtlRec.assignment_id
13685: AND delete_flag = 'N'
13686: AND error_flag = 'Y'
13687: /* Modified for bug 3998166

Line 13954: FROM pa_forecast_items frcst_itms

13950: AND proj_asgn.template_flag = 'N'
13951: AND p_start_date IS NOT NULL
13952: AND p_end_date IS NOT NULL
13953: AND EXISTS ( SELECT null
13954: FROM pa_forecast_items frcst_itms
13955: WHERE proj_asgn.assignment_id =
13956: frcst_itms.assignment_id
13957: AND frcst_itms.delete_flag = 'N'
13958: AND frcst_itms.error_flag =

Line 13974: FROM pa_forecast_items frcst_itms

13970: AND proj_asgn.template_flag = 'N'
13971: AND p_start_date IS NOT NULL
13972: AND p_end_date IS NULL
13973: AND EXISTS ( SELECT null
13974: FROM pa_forecast_items frcst_itms
13975: WHERE proj_asgn.assignment_id =
13976: frcst_itms.assignment_id
13977: AND frcst_itms.delete_flag = 'N'
13978: AND frcst_itms.error_flag =

Line 13992: FROM pa_forecast_items frcst_itms

13988: AND proj_asgn.template_flag = 'N'
13989: AND p_start_date IS NULL
13990: AND p_end_date IS NOT NULL
13991: AND EXISTS ( SELECT null
13992: FROM pa_forecast_items frcst_itms
13993: WHERE proj_asgn.assignment_id =
13994: frcst_itms.assignment_id
13995: AND frcst_itms.delete_flag = 'N'
13996: AND frcst_itms.error_flag =

Line 14010: FROM pa_forecast_items frcst_itms

14006: AND proj_asgn.template_flag = 'N'
14007: AND p_start_date IS NULL
14008: AND p_end_date IS NULL
14009: AND EXISTS ( SELECT null
14010: FROM pa_forecast_items frcst_itms
14011: WHERE proj_asgn.assignment_id =
14012: frcst_itms.assignment_id
14013: AND frcst_itms.delete_flag = 'N'
14014: AND frcst_itms.error_flag =

Line 14038: FROM pa_forecast_items frcst_itms

14034: FROM pa_project_assignments proj_asgn
14035: WHERE proj_asgn.expenditure_organization_id = p_orgz_id
14036: AND proj_asgn.template_flag = 'N'
14037: AND ( EXISTS ( SELECT null
14038: FROM pa_forecast_items frcst_itms
14039: WHERE proj_asgn.assignment_id = frcst_itms.assignment_id
14040: AND frcst_itms.delete_flag = 'N'
14041: AND frcst_itms.error_flag = DECODE(p_process_mode,'ERROR','Y',frcst_itms.error_flag)
14042: AND ( (p_start_date IS NOT NULL AND p_end_date IS NOT NULL AND trunc(frcst_itms.item_date) BETWEEN

Line 14063: FROM pa_forecast_items frcst_itms

14059: WHERE proj_asgn.expenditure_organization_id = p_orgz_id
14060: AND proj_asgn.template_flag = 'N'
14061: AND proj_asgn.assignment_type = 'OPEN_ASSIGNMENT'
14062: AND ( EXISTS ( SELECT null
14063: FROM pa_forecast_items frcst_itms
14064: WHERE proj_asgn.assignment_id = frcst_itms.assignment_id
14065: AND frcst_itms.delete_flag = 'N'
14066: AND frcst_itms.error_flag = DECODE(p_process_mode,'ERROR','Y',frcst_itms.error_flag)
14067: AND trunc(frcst_itms.item_date)

Line 14090: FROM pa_forecast_items frcst_itms

14086: AND proj_asgn.start_date BETWEEN prd.resource_effective_start_date
14087: and prd.resource_effective_end_date
14088: AND prd.schedulable_flag = 'Y'
14089: AND ( EXISTS ( SELECT null
14090: FROM pa_forecast_items frcst_itms
14091: WHERE proj_asgn.assignment_id = frcst_itms.assignment_id
14092: AND frcst_itms.delete_flag = 'N'
14093: AND frcst_itms.error_flag = DECODE(p_process_mode,'ERROR','Y',frcst_itms.error_flag)
14094: AND trunc(frcst_itms.item_date)

Line 14177: IF (PA_FORECAST_ITEMS_UTILS.Set_User_Lock

14173: -- should be in sink if the same time same assignment id
14174: -- is going to be used for processing
14175: lv_lock_type := 'ASGMT';
14176:
14177: IF (PA_FORECAST_ITEMS_UTILS.Set_User_Lock
14178: (l_AssignmentIdTab(i), 'ASG') <> 0) THEN
14179:
14180: RAISE l_cannot_acquire_lock;
14181:

Line 14198: l_lock_status := PA_FORECAST_ITEMS_UTILS.Release_User_Lock

14194: x_return_status => l_x_return_status,
14195: x_msg_count => l_x_msg_count,
14196: x_msg_data => l_x_msg_data );
14197:
14198: l_lock_status := PA_FORECAST_ITEMS_UTILS.Release_User_Lock
14199: (l_AssignmentIdTab(i), 'ASG');
14200: -- This commit is safe: called from a report.
14201: commit;
14202:

Line 14335: FROM pa_forecast_items frcst_itms

14331: PROVISIONAL_QTY,
14332: asgmt_sys_status_code, capacity_quantity,
14333: overcommitment_quantity, availability_quantity,
14334: overcommitment_flag, availability_flag
14335: FROM pa_forecast_items frcst_itms
14336: WHERE frcst_itms.expenditure_organization_id = p_orgz_id
14337: AND frcst_itms.error_flag = 'Y'
14338: AND frcst_itms.forecast_item_type = 'U'
14339: AND frcst_itms.delete_flag = 'N'

Line 14368: FROM pa_forecast_items frcst_itms

14364: PROVISIONAL_QTY,
14365: asgmt_sys_status_code, capacity_quantity,
14366: overcommitment_quantity, availability_quantity,
14367: overcommitment_flag, availability_flag
14368: FROM pa_forecast_items frcst_itms
14369: WHERE frcst_itms.expenditure_organization_id = p_orgz_id
14370: AND frcst_itms.error_flag = 'Y'
14371: AND frcst_itms.forecast_item_type = 'U'
14372: AND frcst_itms.delete_flag = 'N'

Line 14400: FROM pa_forecast_items frcst_itms

14396: PROVISIONAL_QTY,
14397: asgmt_sys_status_code, capacity_quantity,
14398: overcommitment_quantity, availability_quantity,
14399: overcommitment_flag, availability_flag
14400: FROM pa_forecast_items frcst_itms
14401: WHERE frcst_itms.expenditure_organization_id = p_orgz_id
14402: AND frcst_itms.error_flag = 'Y'
14403: AND frcst_itms.forecast_item_type = 'U'
14404: AND frcst_itms.delete_flag = 'N'

Line 14432: FROM pa_forecast_items frcst_itms

14428: PROVISIONAL_QTY,
14429: asgmt_sys_status_code, capacity_quantity,
14430: overcommitment_quantity, availability_quantity,
14431: overcommitment_flag, availability_flag
14432: FROM pa_forecast_items frcst_itms
14433: WHERE frcst_itms.expenditure_organization_id = p_orgz_id
14434: AND frcst_itms.error_flag = 'Y'
14435: AND frcst_itms.forecast_item_type = 'U'
14436: AND frcst_itms.delete_flag = 'N'

Line 15000: PA_FORECAST_ITEMS_UTILS.log_message(x_msg_data);

14996: p_data => l_data, -- 4537865
14997: p_msg_index_out => l_msg_index_out );
14998: x_msg_data := l_data ; -- 4537865
14999: End If;
15000: PA_FORECAST_ITEMS_UTILS.log_message(x_msg_data);
15001: raise;
15002: END Check_Person_Billable;
15003:
15004: /* ---------------------------------------------------------------------

Line 15130: PA_FORECAST_ITEMS_UTILS.log_message(x_msg_data);

15126: p_data => l_data , -- 4537865
15127: p_msg_index_out => l_msg_index_out );
15128: x_msg_data := l_data ; -- 4537865
15129: End If;
15130: PA_FORECAST_ITEMS_UTILS.log_message(x_msg_data);
15131: raise;
15132:
15133:
15134: END Is_Include_Utilisation;

Line 15231: select pa_forecast_items_s.NEXTVAL

15227: FOR li_counter_source_hdr IN li_source_hdr_first_index .. li_source_hdr_last_index LOOP
15228:
15229: lt_FIHdrInsTab(li_hdr_ins_count) := lt_SourceFIHdrTab(li_counter_source_hdr);
15230:
15231: select pa_forecast_items_s.NEXTVAL
15232: into li_new_forecast_item_id
15233: from dual;
15234:
15235: lt_FIHdrInsTab(li_hdr_ins_count).forecast_item_id := li_new_forecast_item_id;