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.ENG_ECO_PVT dependencies on ENG_CHANGE_ROUTE_PEOPLE_TL

Line 17374: insert into ENG_CHANGE_ROUTE_PEOPLE_TL

17370: cr.assignee_type_code,
17371: cr.response_condition_code,
17372: cr.route_people_id);
17373:
17374: insert into ENG_CHANGE_ROUTE_PEOPLE_TL
17375: (ROUTE_PEOPLE_ID,
17376: CREATION_DATE,
17377: CREATED_BY,
17378: LAST_UPDATE_DATE,

Line 17397: from ENG_CHANGE_ROUTE_PEOPLE_TL T

17393: from FND_LANGUAGES L
17394: where L.INSTALLED_FLAG in ('I', 'B')
17395: and not exists
17396: (select NULL
17397: from ENG_CHANGE_ROUTE_PEOPLE_TL T
17398: where T.ROUTE_PEOPLE_ID = l_people_id
17399: and T.LANGUAGE = L.LANGUAGE_CODE);
17400:
17401: END IF;

Line 17457: insert into ENG_CHANGE_ROUTE_PEOPLE_TL

17453: cr.assignee_type_code,
17454: cr.response_condition_code,
17455: cr.route_people_id);
17456:
17457: insert into ENG_CHANGE_ROUTE_PEOPLE_TL
17458: (ROUTE_PEOPLE_ID,
17459: CREATION_DATE,
17460: CREATED_BY,
17461: LAST_UPDATE_DATE,

Line 17480: from ENG_CHANGE_ROUTE_PEOPLE_TL T

17476: from FND_LANGUAGES L
17477: where L.INSTALLED_FLAG in ('I', 'B')
17478: and not exists
17479: (select NULL
17480: from ENG_CHANGE_ROUTE_PEOPLE_TL T
17481: where T.ROUTE_PEOPLE_ID = l_people_id
17482: and T.LANGUAGE = L.LANGUAGE_CODE);
17483:
17484: END IF;

Line 17556: insert into ENG_CHANGE_ROUTE_PEOPLE_TL

17552: cr.assignee_type_code,
17553: cr.response_condition_code,
17554: cr.route_people_id);
17555:
17556: insert into ENG_CHANGE_ROUTE_PEOPLE_TL
17557: (ROUTE_PEOPLE_ID,
17558: CREATION_DATE,
17559: CREATED_BY,
17560: LAST_UPDATE_DATE,

Line 17579: from ENG_CHANGE_ROUTE_PEOPLE_TL T

17575: from FND_LANGUAGES L
17576: where L.INSTALLED_FLAG in ('I', 'B')
17577: and not exists
17578: (select NULL
17579: from ENG_CHANGE_ROUTE_PEOPLE_TL T
17580: where T.ROUTE_PEOPLE_ID = l_people_id
17581: and T.LANGUAGE = L.LANGUAGE_CODE);
17582:
17583: END IF;

Line 17639: insert into ENG_CHANGE_ROUTE_PEOPLE_TL

17635: cr.assignee_type_code,
17636: cr.response_condition_code,
17637: cr.route_people_id);
17638:
17639: insert into ENG_CHANGE_ROUTE_PEOPLE_TL
17640: (ROUTE_PEOPLE_ID,
17641: CREATION_DATE,
17642: CREATED_BY,
17643: LAST_UPDATE_DATE,

Line 17662: from ENG_CHANGE_ROUTE_PEOPLE_TL T

17658: from FND_LANGUAGES L
17659: where L.INSTALLED_FLAG in ('I', 'B')
17660: and not exists
17661: (select NULL
17662: from ENG_CHANGE_ROUTE_PEOPLE_TL T
17663: where T.ROUTE_PEOPLE_ID = l_people_id
17664: and T.LANGUAGE = L.LANGUAGE_CODE);
17665:
17666: END IF;

Line 17738: insert into ENG_CHANGE_ROUTE_PEOPLE_TL (

17734: cr.response_condition_code,
17735: --cr.route_people_id
17736: null);
17737:
17738: insert into ENG_CHANGE_ROUTE_PEOPLE_TL (
17739: ROUTE_PEOPLE_ID,
17740: CREATION_DATE,
17741: CREATED_BY,
17742: LAST_UPDATE_DATE,

Line 17762: from ENG_CHANGE_ROUTE_PEOPLE_TL T

17758: from FND_LANGUAGES L
17759: where L.INSTALLED_FLAG in ('I', 'B')
17760: and not exists
17761: (select NULL
17762: from ENG_CHANGE_ROUTE_PEOPLE_TL T
17763: where T.ROUTE_PEOPLE_ID = l_people_id
17764: and T.LANGUAGE = L.LANGUAGE_CODE);
17765:
17766: END IF;

Line 17839: insert into ENG_CHANGE_ROUTE_PEOPLE_TL (

17835: cr.assignee_type_code,
17836: cr.response_condition_code,
17837: cr.route_people_id);
17838:
17839: insert into ENG_CHANGE_ROUTE_PEOPLE_TL (
17840: ROUTE_PEOPLE_ID,
17841: CREATION_DATE,
17842: CREATED_BY,
17843: LAST_UPDATE_DATE,

Line 17863: from ENG_CHANGE_ROUTE_PEOPLE_TL T

17859: from FND_LANGUAGES L
17860: where L.INSTALLED_FLAG in ('I', 'B')
17861: and not exists
17862: (select NULL
17863: from ENG_CHANGE_ROUTE_PEOPLE_TL T
17864: where T.ROUTE_PEOPLE_ID = l_people_id
17865: and T.LANGUAGE = L.LANGUAGE_CODE);
17866:
17867: l_row_inserted_flag := 1; -- bug 13860012

Line 17932: insert into ENG_CHANGE_ROUTE_PEOPLE_TL (

17928: cr.assignee_type_code,
17929: cr.response_condition_code,
17930: cr.route_people_id);
17931:
17932: insert into ENG_CHANGE_ROUTE_PEOPLE_TL (
17933: ROUTE_PEOPLE_ID,
17934: CREATION_DATE,
17935: CREATED_BY,
17936: LAST_UPDATE_DATE,

Line 17956: from ENG_CHANGE_ROUTE_PEOPLE_TL T

17952: from FND_LANGUAGES L
17953: where L.INSTALLED_FLAG in ('I', 'B')
17954: and not exists
17955: (select NULL
17956: from ENG_CHANGE_ROUTE_PEOPLE_TL T
17957: where T.ROUTE_PEOPLE_ID = l_people_id
17958: and T.LANGUAGE = L.LANGUAGE_CODE);
17959:
17960: l_row_inserted_flag := 1; -- bug 13860012

Line 18035: insert into ENG_CHANGE_ROUTE_PEOPLE_TL (

18031: cr.assignee_type_code,
18032: cr.response_condition_code,
18033: cr.route_people_id);
18034:
18035: insert into ENG_CHANGE_ROUTE_PEOPLE_TL (
18036: ROUTE_PEOPLE_ID,
18037: CREATION_DATE,
18038: CREATED_BY,
18039: LAST_UPDATE_DATE,

Line 18059: from ENG_CHANGE_ROUTE_PEOPLE_TL T

18055: from FND_LANGUAGES L
18056: where L.INSTALLED_FLAG in ('I', 'B')
18057: and not exists
18058: (select NULL
18059: from ENG_CHANGE_ROUTE_PEOPLE_TL T
18060: where T.ROUTE_PEOPLE_ID = l_people_id
18061: and T.LANGUAGE = L.LANGUAGE_CODE);
18062:
18063: l_row_inserted_flag := 1; -- bug 13860012

Line 18128: insert into ENG_CHANGE_ROUTE_PEOPLE_TL (

18124: cr.assignee_type_code,
18125: cr.response_condition_code,
18126: cr.route_people_id);
18127:
18128: insert into ENG_CHANGE_ROUTE_PEOPLE_TL (
18129: ROUTE_PEOPLE_ID,
18130: CREATION_DATE,
18131: CREATED_BY,
18132: LAST_UPDATE_DATE,

Line 18152: from ENG_CHANGE_ROUTE_PEOPLE_TL T

18148: from FND_LANGUAGES L
18149: where L.INSTALLED_FLAG in ('I', 'B')
18150: and not exists
18151: (select NULL
18152: from ENG_CHANGE_ROUTE_PEOPLE_TL T
18153: where T.ROUTE_PEOPLE_ID = l_people_id
18154: and T.LANGUAGE = L.LANGUAGE_CODE);
18155:
18156: l_row_inserted_flag := 1; -- bug 13860012

Line 18221: insert into ENG_CHANGE_ROUTE_PEOPLE_TL (

18217: cr.assignee_type_code,
18218: cr.response_condition_code,
18219: cr.route_people_id);
18220:
18221: insert into ENG_CHANGE_ROUTE_PEOPLE_TL (
18222: ROUTE_PEOPLE_ID,
18223: CREATION_DATE,
18224: CREATED_BY,
18225: LAST_UPDATE_DATE,

Line 18245: from ENG_CHANGE_ROUTE_PEOPLE_TL T

18241: from FND_LANGUAGES L
18242: where L.INSTALLED_FLAG in ('I', 'B')
18243: and not exists
18244: (select NULL
18245: from ENG_CHANGE_ROUTE_PEOPLE_TL T
18246: where T.ROUTE_PEOPLE_ID = l_people_id
18247: and T.LANGUAGE = L.LANGUAGE_CODE);
18248: END IF;
18249: END IF; -- IF GROUP/ROLE

Line 18256: DELETE FROM ENG_CHANGE_ROUTE_PEOPLE_TL

18252: -- Remove the original copied assignee object (Group/Role)
18253: DELETE FROM ENG_CHANGE_ROUTE_PEOPLE
18254: WHERE route_people_id = cr.route_people_id;
18255:
18256: DELETE FROM ENG_CHANGE_ROUTE_PEOPLE_TL
18257: WHERE route_people_id = cr.route_people_id;
18258:
18259: END LOOP; -- end cursor C_GET_ROUTE_STEP_ASSIGNEE
18260: