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 11349: PA_FORECAST_ITEMS_UTILS.get_resource_ou(

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

Line 11371: PA_FORECAST_ITEMS_UTILS.get_person_id(p_resource_id);

11367:
11368: Print_message( 'Res - Get_Person_id ');
11369:
11370: lv_person_id :=
11371: PA_FORECAST_ITEMS_UTILS.get_person_id(p_resource_id);
11372:
11373:
11374: Print_message(
11375: 'Res - Get_res_org_and_job ');

Line 11377: PA_FORECAST_ITEMS_UTILS.get_res_org_and_job(

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

Line 11398: PA_FORECAST_ITEMS_UTILS.get_Week_Dates_Range_Fc(

11394:
11395: Print_message(
11396: 'Res - Get_week_dates_range_fc ');
11397:
11398: PA_FORECAST_ITEMS_UTILS.get_Week_Dates_Range_Fc(
11399: p_start_date,
11400: p_end_date,
11401: lv_WeekDateRange_Tab,
11402: lv_return_status,

Line 11511: PA_FORECAST_ITEMS_UTILS.get_period_set_name(

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

Line 11531: PA_FORECAST_ITEMS_UTILS.get_pa_period_name(

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

Line 11550: PA_FORECAST_ITEMS_UTILS.get_gl_period_name(

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

Line 11569: PA_FORECAST_ITEMS_UTILS.get_forecastoptions(

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

Line 11644: PA_FORECAST_ITEMS_UTILS.get_period_set_name (

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

Line 11659: PA_FORECAST_ITEMS_UTILS.get_pa_period_name(

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

Line 11680: PA_FORECAST_ITEMS_UTILS.get_gl_period_name(

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

Line 12052: PA_FORECAST_ITEMS_UTILS.get_next_forecast_item_id;

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

Line 12727: lv_resource_type := PA_FORECAST_ITEMS_UTILS.get_resource_type(

12723:
12724: Print_message(
12725: 'Res - Get_resource_type');
12726:
12727: lv_resource_type := PA_FORECAST_ITEMS_UTILS.get_resource_type(
12728: p_resource_id);
12729:
12730: lv_amount_type_id := get_AmountTypeID;
12731:

Line 12732: lv_person_id := PA_FORECAST_ITEMS_UTILS.get_person_id(

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

Line 12799: PA_FORECAST_ITEMS_UTILS.get_work_type_details(

12795: -- 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
12796: -- IF (nvl(TmpDayTab(i).work_type_id, -99) <> nvl(l_worktype_cache, -99)) THEN
12797: IF (nvl(TmpDayTab(i).work_type_id, -199) <> nvl(l_worktype_cache, -199)) THEN --Bug 6202828 Changed the nvl value from -99 to -199
12798: Print_message('PA_FORECASTITEM_PVT.Build_FI_Dtl_Res : TmpDayTab(i).work_type_id not same as the previous value, get from the database');
12799: PA_FORECAST_ITEMS_UTILS.get_work_type_details(
12800: TmpDayTab(i).work_type_id,
12801: lv_billable_flag,
12802: l_resutilweighted,
12803: l_orgutilweighted,

Line 13680: FROM pa_forecast_items

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

Line 13951: FROM pa_forecast_items frcst_itms

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

Line 13971: FROM pa_forecast_items frcst_itms

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

Line 13989: FROM pa_forecast_items frcst_itms

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

Line 14007: FROM pa_forecast_items frcst_itms

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

Line 14034: FROM pa_forecast_items frcst_itms

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

Line 14122: IF (PA_FORECAST_ITEMS_UTILS.Set_User_Lock

14118: -- should be in sink if the same time same assignment id
14119: -- is going to be used for processing
14120: lv_lock_type := 'ASGMT';
14121:
14122: IF (PA_FORECAST_ITEMS_UTILS.Set_User_Lock
14123: (l_AssignmentIdTab(i), 'ASG') <> 0) THEN
14124:
14125: RAISE l_cannot_acquire_lock;
14126:

Line 14143: l_lock_status := PA_FORECAST_ITEMS_UTILS.Release_User_Lock

14139: x_return_status => l_x_return_status,
14140: x_msg_count => l_x_msg_count,
14141: x_msg_data => l_x_msg_data );
14142:
14143: l_lock_status := PA_FORECAST_ITEMS_UTILS.Release_User_Lock
14144: (l_AssignmentIdTab(i), 'ASG');
14145: -- This commit is safe: called from a report.
14146: commit;
14147:

Line 14280: FROM pa_forecast_items frcst_itms

14276: PROVISIONAL_QTY,
14277: asgmt_sys_status_code, capacity_quantity,
14278: overcommitment_quantity, availability_quantity,
14279: overcommitment_flag, availability_flag
14280: FROM pa_forecast_items frcst_itms
14281: WHERE frcst_itms.expenditure_organization_id = p_orgz_id
14282: AND frcst_itms.error_flag = 'Y'
14283: AND frcst_itms.forecast_item_type = 'U'
14284: AND frcst_itms.delete_flag = 'N'

Line 14313: FROM pa_forecast_items frcst_itms

14309: PROVISIONAL_QTY,
14310: asgmt_sys_status_code, capacity_quantity,
14311: overcommitment_quantity, availability_quantity,
14312: overcommitment_flag, availability_flag
14313: FROM pa_forecast_items frcst_itms
14314: WHERE frcst_itms.expenditure_organization_id = p_orgz_id
14315: AND frcst_itms.error_flag = 'Y'
14316: AND frcst_itms.forecast_item_type = 'U'
14317: AND frcst_itms.delete_flag = 'N'

Line 14345: FROM pa_forecast_items frcst_itms

14341: PROVISIONAL_QTY,
14342: asgmt_sys_status_code, capacity_quantity,
14343: overcommitment_quantity, availability_quantity,
14344: overcommitment_flag, availability_flag
14345: FROM pa_forecast_items frcst_itms
14346: WHERE frcst_itms.expenditure_organization_id = p_orgz_id
14347: AND frcst_itms.error_flag = 'Y'
14348: AND frcst_itms.forecast_item_type = 'U'
14349: AND frcst_itms.delete_flag = 'N'

Line 14377: FROM pa_forecast_items frcst_itms

14373: PROVISIONAL_QTY,
14374: asgmt_sys_status_code, capacity_quantity,
14375: overcommitment_quantity, availability_quantity,
14376: overcommitment_flag, availability_flag
14377: FROM pa_forecast_items frcst_itms
14378: WHERE frcst_itms.expenditure_organization_id = p_orgz_id
14379: AND frcst_itms.error_flag = 'Y'
14380: AND frcst_itms.forecast_item_type = 'U'
14381: AND frcst_itms.delete_flag = 'N'

Line 14945: PA_FORECAST_ITEMS_UTILS.log_message(x_msg_data);

14941: p_data => l_data, -- 4537865
14942: p_msg_index_out => l_msg_index_out );
14943: x_msg_data := l_data ; -- 4537865
14944: End If;
14945: PA_FORECAST_ITEMS_UTILS.log_message(x_msg_data);
14946: raise;
14947: END Check_Person_Billable;
14948:
14949: /* ---------------------------------------------------------------------

Line 15075: PA_FORECAST_ITEMS_UTILS.log_message(x_msg_data);

15071: p_data => l_data , -- 4537865
15072: p_msg_index_out => l_msg_index_out );
15073: x_msg_data := l_data ; -- 4537865
15074: End If;
15075: PA_FORECAST_ITEMS_UTILS.log_message(x_msg_data);
15076: raise;
15077:
15078:
15079: END Is_Include_Utilisation;

Line 15176: select pa_forecast_items_s.NEXTVAL

15172: FOR li_counter_source_hdr IN li_source_hdr_first_index .. li_source_hdr_last_index LOOP
15173:
15174: lt_FIHdrInsTab(li_hdr_ins_count) := lt_SourceFIHdrTab(li_counter_source_hdr);
15175:
15176: select pa_forecast_items_s.NEXTVAL
15177: into li_new_forecast_item_id
15178: from dual;
15179:
15180: lt_FIHdrInsTab(li_hdr_ins_count).forecast_item_id := li_new_forecast_item_id;