[Home] [Help]
6023: sum(item_quantity) total_assigned_quantity,
6024: item_date,
6025: delete_flag,
6026: forecast_item_type
6027: from pa_forecast_items fi1, pa_schedules sch, pa_project_statuses a, pa_project_statuses b
6028: where (fi1.assignment_id = p_assignment_id or asgmt_sys_status_code = 'STAFFED_ASGMT_CONF' )
6029: and fi1.assignment_id = sch.assignment_id
6030: and fi1.item_date between sch.start_date and sch.end_date
6031: and sch.status_code = a.project_status_code
6082: sum(item_quantity) total_assigned_quantity,
6083: GLOBAL_EXP_PERIOD_END_DATE week_end_date,
6084: delete_flag,
6085: forecast_item_type
6086: from pa_forecast_items fi1, pa_schedules sch, pa_project_statuses a, pa_project_statuses b
6087: where (fi1.assignment_id = p_assignment_id or asgmt_sys_status_code = 'STAFFED_ASGMT_CONF' )
6088: and fi1.item_date between l_start_date and l_end_date
6089: and fi1.assignment_id = sch.assignment_id
6090: and fi1.item_date between sch.start_date and sch.end_date
6224: IF G_AVAILABILITY_CAL_PERIOD = 'DAILY' THEN
6225: select distinct fi.assignment_id,
6226: decode (mass.assignment_id, null, 'N', 'Y') intra_txn_conflict_flag
6227: BULK COLLECT INTO l_assignment_id_tbl, l_intra_txn_conflict_flag_tbl
6228: from pa_forecast_items fi, pa_mass_txn_asgmt_success_v mass, pa_schedules sch, pa_project_statuses a, pa_project_statuses b,
6229: (select resource_id,
6230: sum(item_quantity) total_assigned_quantity,
6231: item_date,
6232: delete_flag,
6236: item_quantity,
6237: item_date,
6238: delete_flag,
6239: forecast_item_type
6240: from pa_forecast_items fi1, pa_schedules sch, pa_project_statuses a, pa_project_statuses b
6241: 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' )
6242: and fi1.assignment_id = sch.assignment_id
6243: and fi1.item_date between sch.start_date and sch.end_date
6244: and sch.status_code = a.project_status_code
6303:
6304: select distinct fi.assignment_id,
6305: decode (mass.assignment_id, null, 'N', 'Y') intra_txn_flag
6306: BULK COLLECT INTO l_assignment_id_tbl, l_intra_txn_conflict_flag_tbl
6307: from pa_forecast_items fi, pa_mass_txn_asgmt_success_v mass, pa_schedules sch, pa_project_statuses a, pa_project_statuses b,
6308: (select resource_id,
6309: sum(item_quantity) total_assigned_quantity,
6310: GLOBAL_EXP_PERIOD_END_DATE,
6311: delete_flag,
6315: item_quantity,
6316: GLOBAL_EXP_PERIOD_END_DATE,
6317: delete_flag,
6318: forecast_item_type
6319: from pa_forecast_items fi1, pa_schedules sch, pa_project_statuses a, pa_project_statuses b
6320: 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' )
6321: and fi1.item_date between l_start_date and l_end_date
6322: and fi1.assignment_id = sch.assignment_id
6323: and fi1.item_date between sch.start_date and sch.end_date
6475: item_quantity,
6476: item_date,
6477: asgmt_sys_status_code,
6478: delete_flag
6479: from pa_forecast_items fi, pa_schedules sch, pa_project_statuses a, pa_project_statuses b
6480: where fi.assignment_id = p_assignment_id
6481: and fi.assignment_id = sch.assignment_id
6482: and fi.item_date between sch.start_date and sch.end_date
6483: and forecast_item_type = 'A'
6508: (select resource_id,
6509: sum(item_quantity) weekly_quantity,
6510: GLOBAL_EXP_PERIOD_END_DATE week_end_date,
6511: delete_flag
6512: from pa_forecast_items fi, pa_schedules sch, pa_project_statuses a, pa_project_statuses b
6513: where fi.assignment_id = p_assignment_id
6514: and fi.assignment_id = sch.assignment_id
6515: and item_date between l_week_start_date and l_week_end_date
6516: and item_date between sch.start_date and sch.end_date
8607: IF l_count = 0 THEN
8608: l_current_value := v_c2.status_code;
8609: SELECT project_status_name
8610: INTO l_old_value_text
8611: FROM pa_project_statuses
8612: WHERE project_status_code = v_c2.status_code;
8613: ELSE
8614: l_previous_value := l_current_value;
8615: l_current_value := v_c2.status_code;
8630: IF l_count = 0 THEN
8631: l_current_value := v_c2_current.status_code;
8632: SELECT project_status_name
8633: INTO l_old_value_text
8634: FROM pa_project_statuses
8635: WHERE project_status_code = v_c2_current.status_code;
8636: ELSE
8637: l_previous_value := l_current_value;
8638: l_current_value := v_c2_current.status_code;
8864: --------------------------------------------------
8865: ELSIF p_exception_type_code = 'CHANGE_STATUS' THEN
8866: SELECT project_status_name
8867: INTO l_new_value_text
8868: FROM pa_project_statuses
8869: WHERE project_status_code = p_new_status_code;
8870:
8871: --------------------------------------------------
8872: -- p_exception_type_code = 'CHANGE_WORK_PATTERN'
8973: (select fi1.resource_id,
8974: fi1.item_quantity,
8975: fi1.item_date,
8976: fi1.delete_flag
8977: from pa_forecast_items fi1, pa_project_assignments asgn, pa_schedules sch, pa_project_statuses a, pa_project_statuses b
8978: where (fi1.assignment_id = p_assignment_id
8979: or fi1.assignment_id in
8980: (select conflict_assignment_id
8981: from pa_assignment_conflict_hist
9056: sum(item_quantity) total_assigned_quantity,
9057: GLOBAL_EXP_PERIOD_END_DATE week_end_date,
9058: delete_flag,
9059: forecast_item_type
9060: from pa_forecast_items fi1, pa_schedules sch, pa_project_statuses a, pa_project_statuses b
9061: where (fi1.assignment_id = p_assignment_id
9062: or fi1.assignment_id in (select conflict_assignment_id
9063: from pa_assignment_conflict_hist
9064: where conflict_group_id = p_conflict_group_id