[Home] [Help]
5735: sum(item_quantity) total_assigned_quantity,
5736: item_date,
5737: delete_flag,
5738: forecast_item_type
5739: from pa_forecast_items fi1, pa_schedules sch, pa_project_statuses a, pa_project_statuses b
5740: where (fi1.assignment_id = p_assignment_id or asgmt_sys_status_code = 'STAFFED_ASGMT_CONF' )
5741: and fi1.assignment_id = sch.assignment_id
5742: and fi1.item_date between sch.start_date and sch.end_date
5743: and sch.status_code = a.project_status_code
5789: sum(item_quantity) total_assigned_quantity,
5790: GLOBAL_EXP_PERIOD_END_DATE week_end_date,
5791: delete_flag,
5792: forecast_item_type
5793: from pa_forecast_items fi1, pa_schedules sch, pa_project_statuses a, pa_project_statuses b
5794: where (fi1.assignment_id = p_assignment_id or asgmt_sys_status_code = 'STAFFED_ASGMT_CONF' )
5795: and fi1.item_date between l_start_date and l_end_date
5796: and fi1.assignment_id = sch.assignment_id
5797: and fi1.item_date between sch.start_date and sch.end_date
5931: IF G_AVAILABILITY_CAL_PERIOD = 'DAILY' THEN
5932: select distinct fi.assignment_id,
5933: decode (mass.assignment_id, null, 'N', 'Y') intra_txn_conflict_flag
5934: BULK COLLECT INTO l_assignment_id_tbl, l_intra_txn_conflict_flag_tbl
5935: from pa_forecast_items fi, pa_mass_txn_asgmt_success_v mass, pa_schedules sch, pa_project_statuses a, pa_project_statuses b,
5936: (select resource_id,
5937: sum(item_quantity) total_assigned_quantity,
5938: item_date,
5939: delete_flag,
5943: item_quantity,
5944: item_date,
5945: delete_flag,
5946: forecast_item_type
5947: from pa_forecast_items fi1, pa_schedules sch, pa_project_statuses a, pa_project_statuses b
5948: where (fi1.assignment_id in (select assignment_id from pa_mass_txn_asgmt_success_v where item_type = p_item_type and item_key = p_item_key) or asgmt_sys_status_code = 'STAFFED_ASGMT_CONF' )
5949: and fi1.assignment_id = sch.assignment_id
5950: and fi1.item_date between sch.start_date and sch.end_date
5951: and sch.status_code = a.project_status_code
6010:
6011: select distinct fi.assignment_id,
6012: decode (mass.assignment_id, null, 'N', 'Y') intra_txn_flag
6013: BULK COLLECT INTO l_assignment_id_tbl, l_intra_txn_conflict_flag_tbl
6014: from pa_forecast_items fi, pa_mass_txn_asgmt_success_v mass, pa_schedules sch, pa_project_statuses a, pa_project_statuses b,
6015: (select resource_id,
6016: sum(item_quantity) total_assigned_quantity,
6017: GLOBAL_EXP_PERIOD_END_DATE,
6018: delete_flag,
6022: item_quantity,
6023: GLOBAL_EXP_PERIOD_END_DATE,
6024: delete_flag,
6025: forecast_item_type
6026: from pa_forecast_items fi1, pa_schedules sch, pa_project_statuses a, pa_project_statuses b
6027: where (fi1.assignment_id in (select assignment_id from pa_mass_txn_asgmt_success_v where item_type = p_item_type and item_key = p_item_key) or asgmt_sys_status_code = 'STAFFED_ASGMT_CONF' )
6028: and fi1.item_date between l_start_date and l_end_date
6029: and fi1.assignment_id = sch.assignment_id
6030: and fi1.item_date between sch.start_date and sch.end_date
6182: item_quantity,
6183: item_date,
6184: asgmt_sys_status_code,
6185: delete_flag
6186: from pa_forecast_items fi, pa_schedules sch, pa_project_statuses a, pa_project_statuses b
6187: where fi.assignment_id = p_assignment_id
6188: and fi.assignment_id = sch.assignment_id
6189: and fi.item_date between sch.start_date and sch.end_date
6190: and forecast_item_type = 'A'
6215: (select resource_id,
6216: sum(item_quantity) weekly_quantity,
6217: GLOBAL_EXP_PERIOD_END_DATE week_end_date,
6218: delete_flag
6219: from pa_forecast_items fi, pa_schedules sch, pa_project_statuses a, pa_project_statuses b
6220: where fi.assignment_id = p_assignment_id
6221: and fi.assignment_id = sch.assignment_id
6222: and item_date between l_week_start_date and l_week_end_date
6223: and item_date between sch.start_date and sch.end_date
8314: IF l_count = 0 THEN
8315: l_current_value := v_c2.status_code;
8316: SELECT project_status_name
8317: INTO l_old_value_text
8318: FROM pa_project_statuses
8319: WHERE project_status_code = v_c2.status_code;
8320: ELSE
8321: l_previous_value := l_current_value;
8322: l_current_value := v_c2.status_code;
8337: IF l_count = 0 THEN
8338: l_current_value := v_c2_current.status_code;
8339: SELECT project_status_name
8340: INTO l_old_value_text
8341: FROM pa_project_statuses
8342: WHERE project_status_code = v_c2_current.status_code;
8343: ELSE
8344: l_previous_value := l_current_value;
8345: l_current_value := v_c2_current.status_code;
8571: --------------------------------------------------
8572: ELSIF p_exception_type_code = 'CHANGE_STATUS' THEN
8573: SELECT project_status_name
8574: INTO l_new_value_text
8575: FROM pa_project_statuses
8576: WHERE project_status_code = p_new_status_code;
8577:
8578: --------------------------------------------------
8579: -- p_exception_type_code = 'CHANGE_WORK_PATTERN'
8680: (select fi1.resource_id,
8681: fi1.item_quantity,
8682: fi1.item_date,
8683: fi1.delete_flag
8684: from pa_forecast_items fi1, pa_project_assignments asgn, pa_schedules sch, pa_project_statuses a, pa_project_statuses b
8685: where (fi1.assignment_id = p_assignment_id
8686: or fi1.assignment_id in
8687: (select conflict_assignment_id
8688: from pa_assignment_conflict_hist
8763: sum(item_quantity) total_assigned_quantity,
8764: GLOBAL_EXP_PERIOD_END_DATE week_end_date,
8765: delete_flag,
8766: forecast_item_type
8767: from pa_forecast_items fi1, pa_schedules sch, pa_project_statuses a, pa_project_statuses b
8768: where (fi1.assignment_id = p_assignment_id
8769: or fi1.assignment_id in (select conflict_assignment_id
8770: from pa_assignment_conflict_hist
8771: where conflict_group_id = p_conflict_group_id