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_SCHEDULE_PVT dependencies on PA_ASSIGNMENT_CONFLICT_HIST

Line 5695: -- action in PA_ASSIGNMENT_CONFLICT_HIST.

5691:
5692: -- Procedure : check_overcommitment_single
5693: -- Purpose : First checks if this assignment alone causes resource
5694: -- overcommitment. If Yes, then stores self-conflict and user
5695: -- action in PA_ASSIGNMENT_CONFLICT_HIST.
5696: PROCEDURE check_overcommitment_single( p_assignment_id IN NUMBER,
5697: p_resolve_conflict_action_code IN VARCHAR2,
5698: p_conflict_group_id IN NUMBER := NULL,
5699: x_overcommitment_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 5886: -- action in PA_ASSIGNMENT_CONFLICT_HIST.

5882:
5883: -- Procedure : check_overcommitment_mult
5884: -- Purpose : First checks if this assignment alone causes resource
5885: -- overcommitment. If Yes, then stores self-conflict and user
5886: -- action in PA_ASSIGNMENT_CONFLICT_HIST.
5887: PROCEDURE check_overcommitment_mult(p_item_type IN PA_WF_PROCESSES.item_type%TYPE,
5888: p_item_key IN PA_WF_PROCESSES.item_key%TYPE,
5889: p_conflict_group_id IN NUMBER := NULL,
5890: p_resolve_conflict_action_code IN VARCHAR2,

Line 6296: -- detailed in PA_ASSIGNMENT_CONFLICT_HIST. Updates

6292:
6293:
6294: -- Procedure : resolve_conflicts
6295: -- Purpose : Resolves remaining conflicts by taking action chosen to user
6296: -- detailed in PA_ASSIGNMENT_CONFLICT_HIST. Updates
6297: -- processed_flag in the table once complete.
6298: PROCEDURE resolve_conflicts( p_conflict_group_id IN NUMBER,
6299: p_assignment_id IN NUMBER,
6300: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 6311: FROM pa_assignment_conflict_hist

6307:
6308: -- Cursor c1 is used to resolve_conflicts_action_code.
6309: CURSOR c1 IS
6310: SELECT DISTINCT resolve_conflicts_action_code
6311: FROM pa_assignment_conflict_hist
6312: WHERE conflict_group_id = p_conflict_group_id
6313: AND assignment_id = p_assignment_id
6314: AND processed_flag = 'N';
6315:

Line 6325: FROM pa_assignment_conflict_hist hist, pa_project_assignments asgn

6321: SELECT conflict_assignment_id,
6322: decode(asgn.MASS_WF_IN_PROGRESS_FLAG,
6323: 'Y', decode(hist.intra_txn_conflict_flag, 'N', 'Y', 'N'),
6324: decode(asgn.apprvl_status_code, 'ASGMT_APPRVL_SUBMITTED', 'Y', 'N')) locking_flag
6325: FROM pa_assignment_conflict_hist hist, pa_project_assignments asgn
6326: WHERE hist.conflict_assignment_id = asgn.assignment_id
6327: AND hist.conflict_group_id = p_conflict_group_id
6328: AND hist.assignment_id = p_assignment_id
6329: AND hist.processed_flag = 'N'

Line 6426: pa_assignment_conflict_hist conf,

6422: fi.item_quantity,
6423: fi_overcom.overcommitment_quantity
6424: BULK COLLECT INTO l_assignment_id_tbl, l_item_date_tbl, l_week_end_date_tbl, l_item_quantity_tbl, l_overcom_quantity_tbl
6425: FROM pa_forecast_items fi,
6426: pa_assignment_conflict_hist conf,
6427: (SELECT
6428: resource_id,
6429: item_date,
6430: DECODE(sign(capacity_quantity*G_OVERCOMMITMENT_PERCENTAGE-overcommitment_quantity), 1, 0, overcommitment_quantity) overcommitment_quantity,

Line 6459: FROM pa_forecast_items fi, pa_assignment_conflict_hist conf,

6455: fi.GLOBAL_EXP_PERIOD_END_DATE,
6456: fi.item_quantity,
6457: fi_overcom.overcommitment_quantity
6458: BULK COLLECT INTO l_assignment_id_tbl, l_item_date_tbl, l_week_end_date_tbl, l_item_quantity_tbl, l_overcom_quantity_tbl
6459: FROM pa_forecast_items fi, pa_assignment_conflict_hist conf,
6460: (SELECT
6461: resource_id,
6462: overcommitment_quantity,
6463: item_date,

Line 6694: -- Update pa_assignment_conflict_hist table.

6690: PA_SCHEDULE_UTILS.debug('After Change Work Pattern');
6691: END IF;
6692: END LOOP;
6693:
6694: -- Update pa_assignment_conflict_hist table.
6695: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
6696: PA_ASGN_CONFLICT_HIST_PKG.update_rows(p_conflict_group_id => p_conflict_group_id,
6697: p_assignment_id => p_assignment_id,
6698: p_processed_flag => 'Y',

Line 7041: FROM pa_project_assignments asgn, pa_assignment_conflict_hist hist, pa_project_lists_v proj

7037: Also removed distinct and added rownum = 1
7038:
7039: CURSOR c1 IS
7040: SELECT DISTINCT asgn.project_id, proj.name, proj.segment1, proj.person_name, proj.carrying_out_organization_name, proj.customer_name
7041: FROM pa_project_assignments asgn, pa_assignment_conflict_hist hist, pa_project_lists_v proj
7042: WHERE asgn.assignment_id = hist.assignment_id
7043: AND hist.conflict_group_id = p_conflict_group_id
7044: AND asgn.project_id = proj.project_id;
7045:

Line 7052: FROM pa_project_assignments asgn, pa_assignment_conflict_hist hist, pa_projects_all proj

7048: /* Cursor added for bug 3115273 */
7049:
7050: CURSOR c1 IS
7051: SELECT asgn.project_id, proj.name, proj.segment1, proj.carrying_out_organization_id
7052: FROM pa_project_assignments asgn, pa_assignment_conflict_hist hist, pa_projects_all proj
7053: WHERE asgn.assignment_id = hist.assignment_id
7054: AND hist.conflict_group_id = p_conflict_group_id
7055: AND asgn.project_id = proj.project_id
7056: AND ROWNUM = 1;

Line 7063: FROM pa_project_assignments asgn, pa_assignment_conflict_hist hist, pa_projects_all proj

7059:
7060: -- Retrieve conflict projects info.
7061: CURSOR c2 IS
7062: SELECT DISTINCT asgn.project_id, proj.name, proj.segment1
7063: FROM pa_project_assignments asgn, pa_assignment_conflict_hist hist, pa_projects_all proj
7064: WHERE asgn.assignment_id = hist.conflict_assignment_id
7065: AND hist.conflict_group_id = p_conflict_group_id
7066: AND asgn.project_id = proj.project_id
7067: AND hist.self_conflict_flag = 'N';

Line 7074: FROM pa_assignment_conflict_hist

7070:
7071: -- Retrieve Self Conflicts info.
7072: CURSOR c3 IS
7073: SELECT assignment_id
7074: FROM pa_assignment_conflict_hist
7075: WHERE conflict_group_id = p_conflict_group_id
7076: AND self_conflict_flag = 'Y'
7077: AND resolve_conflicts_action_code = 'REMOVE_CONFLICTS';
7078:

Line 7409: FROM pa_assignment_conflict_hist

7405: IS
7406:
7407: CURSOR c1 IS
7408: SELECT assignment_id
7409: FROM pa_assignment_conflict_hist
7410: WHERE conflict_group_id = p_conflict_group_id
7411: AND resolve_conflicts_action_code = 'REMOVE_CONFLICTS'
7412: AND self_conflict_flag = 'N'
7413: AND processed_flag = 'N';

Line 7454: FROM pa_assignment_conflict_hist

7450: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
7451: IS
7452: CURSOR c1 IS
7453: SELECT processed_flag
7454: FROM pa_assignment_conflict_hist
7455: WHERE conflict_group_id = p_conflict_group_id
7456: AND assignment_id = p_assignment_id
7457: AND resolve_conflicts_action_code = 'REMOVE_CONFLICTS'
7458: AND self_conflict_flag = 'N'

Line 7499: FROM pa_assignment_conflict_hist conf, pa_project_assignments asgn

7495:
7496: -- 2167889: null instead of record_version_number
7497: CURSOR c1 IS
7498: SELECT DISTINCT conf.assignment_id, null record_version_number, asgn.assignment_type, asgn.start_date, asgn.end_date
7499: FROM pa_assignment_conflict_hist conf, pa_project_assignments asgn
7500: WHERE conf.conflict_group_id = p_conflict_group_id
7501: AND conf.assignment_id = asgn.assignment_id
7502: AND conf.resolve_conflicts_action_code = 'CANCEL_TXN_ITEM'
7503: AND conf.processed_flag = 'N';

Line 7550: FROM pa_assignment_conflict_hist

7546: IS
7547:
7548: CURSOR c1 IS
7549: SELECT DISTINCT assignment_id
7550: FROM pa_assignment_conflict_hist
7551: WHERE conflict_group_id = p_conflict_group_id
7552: AND resolve_conflicts_action_code = 'REVERT_TXN_ITEM'
7553: AND processed_flag = 'N';
7554:

Line 7600: FROM pa_assignment_conflict_hist

7596: BEGIN
7597:
7598: SELECT COUNT(DISTINCT assignment_id)
7599: INTO x_assignment_count
7600: FROM pa_assignment_conflict_hist
7601: WHERE conflict_group_id = p_conflict_group_id;
7602:
7603: x_return_status := FND_API.G_RET_STS_SUCCESS;
7604: EXCEPTION

Line 7634: FROM pa_assignment_conflict_hist

7630:
7631: -- Cursor which retrieves the assignments on which action is not taken.
7632: CURSOR c1 IS
7633: SELECT assignment_id
7634: FROM pa_assignment_conflict_hist
7635: WHERE conflict_group_id = p_conflict_group_id
7636: AND resolve_conflicts_action_code = 'NOTIFY_IF_CONFLICT';
7637:
7638: v_c1 c1%ROWTYPE;

Line 7678: FROM pa_assignment_conflict_hist hist, pa_project_assignments asgn

7674: IS
7675:
7676: CURSOR c1 IS
7677: SELECT hist.assignment_id
7678: FROM pa_assignment_conflict_hist hist, pa_project_assignments asgn
7679: WHERE hist.assignment_id = asgn.assignment_id
7680: AND hist.conflict_group_id = p_conflict_group_id
7681: AND asgn.apprvl_status_code = 'ASGMT_APPRVL_WORKING';
7682:

Line 8688: from pa_assignment_conflict_hist

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
8689: where assignment_id = p_assignment_id
8690: and conflict_group_id = p_conflict_group_id
8691: and self_conflict_flag = 'N'
8692: and intra_txn_conflict_flag = 'Y'))

Line 8706: from pa_forecast_items fi2, pa_project_assignments asgn, pa_assignment_conflict_hist hist

8702: select fi2.resource_id,
8703: item_quantity,
8704: fi2.item_date,
8705: fi2.delete_flag
8706: from pa_forecast_items fi2, pa_project_assignments asgn, pa_assignment_conflict_hist hist
8707: where fi2.assignment_id = asgn.assignment_id
8708: and fi2.assignment_id = hist.conflict_assignment_id
8709: and hist.conflict_group_id = p_conflict_group_id
8710: and hist.assignment_id = p_assignment_id

Line 8770: from pa_assignment_conflict_hist

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
8772: and assignment_id = p_assignment_id
8773: and self_conflict_flag = 'N'))
8774: and fi1.assignment_id = sch.assignment_id

Line 8828: FROM pa_assignment_conflict_hist

8824: IS
8825:
8826: CURSOR c1 IS
8827: SELECT conflict_group_id, assignment_id
8828: FROM pa_assignment_conflict_hist
8829: WHERE conflict_group_id = p_conflict_group_id
8830: AND assignment_id = p_assignment_id;
8831: -- AND processed_flag = 'N';
8832:

Line 8881: FROM pa_assignment_conflict_hist

8877: l_action_code VARCHAR2(30);
8878:
8879: CURSOR c1 IS
8880: SELECT resolve_conflicts_action_code
8881: FROM pa_assignment_conflict_hist
8882: WHERE conflict_group_id = p_conflict_group_id
8883: AND assignment_id = p_assignment_id;
8884:
8885: v_c1 c1%ROWTYPE;

Line 8926: FROM pa_project_assignments asgn, pa_assignment_conflict_hist hist

8922:
8923: l_affected VARCHAR2(1) := 'N';
8924: CURSOR c1 IS
8925: SELECT DISTINCT asgn.project_id
8926: FROM pa_project_assignments asgn, pa_assignment_conflict_hist hist
8927: WHERE asgn.assignment_id = hist.conflict_assignment_id
8928: AND hist.conflict_group_id = p_conflict_group_id
8929: AND hist.assignment_id = p_assignment_id;
8930:

Line 8961: FROM pa_assignment_conflict_hist

8957: l_result VARCHAR2(1);
8958:
8959: CURSOR c1 IS
8960: SELECT self_conflict_flag
8961: FROM pa_assignment_conflict_hist
8962: WHERE conflict_group_id = p_conflict_group_id
8963: AND assignment_id = p_assignment_id
8964: AND self_conflict_flag = 'Y'
8965: AND resolve_conflicts_action_code = 'REMOVE_CONFLICTS';