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_ENGINEERING_CHANGES

Line 28: FROM eng_engineering_changes

24: RETURN NUMBER
25: IS
26: CURSOR check_co_sch IS
27: SELECT status_type
28: FROM eng_engineering_changes
29: WHERE change_notice = p_change_notice
30: AND organization_id = p_organization_id
31: AND nvl(plm_or_erp_change, 'PLM') = 'PLM'; -- Added for bug 3692807
32:

Line 33: l_chk_co_sch eng_engineering_changes.status_type%TYPE;

29: WHERE change_notice = p_change_notice
30: AND organization_id = p_organization_id
31: AND nvl(plm_or_erp_change, 'PLM') = 'PLM'; -- Added for bug 3692807
32:
33: l_chk_co_sch eng_engineering_changes.status_type%TYPE;
34: BEGIN
35: OPEN check_co_sch;
36: FETCH check_co_sch INTO l_chk_co_sch;
37: IF check_co_sch%FOUND THEN

Line 8949: l_chk_co_sch eng_engineering_changes.status_type%TYPE;

8945:
8946: -- Bug 2918350 // kamohan
8947: -- Start Changes
8948:
8949: l_chk_co_sch eng_engineering_changes.status_type%TYPE;
8950:
8951: -- End Changes
8952:
8953: BEGIN

Line 10377: l_chk_co_sch eng_engineering_changes.status_type%TYPE;

10373:
10374: -- Bug 2918350 // kamohan
10375: -- Start Changes
10376:
10377: l_chk_co_sch eng_engineering_changes.status_type%TYPE;
10378:
10379: -- End Changes
10380:
10381: BEGIN

Line 11947: l_chk_co_sch eng_engineering_changes.status_type%TYPE;

11943:
11944: EXC_FAT_QUIT_BRANCH EXCEPTION ;
11945: EXC_SEV_QUIT_OBJECT EXCEPTION;
11946:
11947: l_chk_co_sch eng_engineering_changes.status_type%TYPE;
11948: l_change_subject_unexp_rec Eng_Eco_Pub.Change_Subject_Unexp_Rec_Type;
11949:
11950: BEGIN
11951:

Line 13151: l_chk_co_sch eng_engineering_changes.status_type%TYPE;

13147:
13148: -- Bug 2918350 // kamohan
13149: -- Start Changes
13150:
13151: l_chk_co_sch eng_engineering_changes.status_type%TYPE;
13152:
13153: -- Bug 2918350 // kamohan
13154: -- End Changes
13155:

Line 14221: FROM eng_engineering_changes eec, eng_change_order_types_vl ecot

14217: -- Start Changes
14218:
14219: CURSOR check_co_type ( p_change_notice VARCHAR2, p_organization_id NUMBER) IS
14220: SELECT ecot.type_name CHANGE_ORDER_TYPE, eec.assignee_id
14221: FROM eng_engineering_changes eec, eng_change_order_types_vl ecot
14222: WHERE eec.change_notice =p_change_notice
14223: AND eec.organization_id = p_organization_id
14224: AND eec.change_order_type_id = ecot.change_order_type_id;
14225:

Line 17172: FROM ENG_ENGINEERING_CHANGES

17168: LAST_UPDATED_BY
17169: FROM ENG_LIFECYCLE_STATUSES
17170: WHERE ENTITY_ID1 IN
17171: (SELECT CHANGE_ID
17172: FROM ENG_ENGINEERING_CHANGES
17173: WHERE CHANGE_NOTICE = p_change_notice
17174: AND ORGANIZATION_ID = p_org_id)
17175: and change_wf_route_id is null
17176: and change_wf_route_template_id is not null --needed for part with workflow

Line 17203: CURSOR c_propagated_change_order(cp_change_notice eng_engineering_changes.change_notice%type, cp_local_organization_id eng_change_obj_relationships.object_to_id3%type)

17199: FROM ENG_SECURITY_GROUP_MEMBERS_V
17200: WHERE GROUP_ID = cp_group_id
17201: ORDER BY MEMBER_PERSON_ID;
17202:
17203: CURSOR c_propagated_change_order(cp_change_notice eng_engineering_changes.change_notice%type, cp_local_organization_id eng_change_obj_relationships.object_to_id3%type)
17204: IS
17205: SELECT eec.change_id
17206: FROM eng_engineering_changes eec ,
17207: eng_change_obj_relationships ecor

Line 17206: FROM eng_engineering_changes eec ,

17202:
17203: CURSOR c_propagated_change_order(cp_change_notice eng_engineering_changes.change_notice%type, cp_local_organization_id eng_change_obj_relationships.object_to_id3%type)
17204: IS
17205: SELECT eec.change_id
17206: FROM eng_engineering_changes eec ,
17207: eng_change_obj_relationships ecor
17208: WHERE eec.change_id = ecor.object_to_id1
17209: AND ecor.relationship_code IN ( 'PROPAGATED_TO', 'TRANSFERRED_TO' )
17210: AND ecor.object_to_name ='ENG_CHANGE'

Line 17218: FROM ENG_ENGINEERING_CHANGES

17214: BEGIN
17215:
17216: SELECT CHANGE_MGMT_TYPE_CODE
17217: INTO l_change_mgmt_type_code
17218: FROM ENG_ENGINEERING_CHANGES
17219: WHERE CHANGE_NOTICE = p_change_notice
17220: AND ORGANIZATION_ID = p_org_id;
17221:
17222: FOR C_CHANGES_REC IN C_CHANGES LOOP

Line 17310: FROM ENG_ENGINEERING_CHANGES

17306: IF (l_menu_name is not null and 'ENG_CHANGE_ASSIGNEE' = l_menu_name) THEN
17307:
17308: SELECT ASSIGNEE_ID
17309: into l_assignee_id
17310: FROM ENG_ENGINEERING_CHANGES
17311: WHERE CHANGE_NOTICE = p_change_notice
17312: AND ORGANIZATION_ID = p_org_id;
17313: IF (l_assignee_id is not null) THEN
17314: -- check if the person is created in current step, if l_people_existed_flag = 0, then create

Line 17492: FROM ENG_ENGINEERING_CHANGES

17488: 'ENG_CHANGE_REQUESTOR' = l_menu_name) THEN
17489:
17490: SELECT REQUESTOR_ID
17491: into l_requestor_id
17492: FROM ENG_ENGINEERING_CHANGES
17493: WHERE CHANGE_NOTICE = p_change_notice
17494: AND ORGANIZATION_ID = p_org_id;
17495: IF (l_requestor_id is not null) THEN
17496: -- check if the person is created in current step, if l_people_existed_flag = 0, then create

Line 18279: FROM eng_engineering_changes WHERE change_notice = p_change_notice

18275: IF (l_submit_flag = 1 AND l_change_id is null) THEN
18276: --After the explosion is done then the workflow needs to be started
18277: SELECT change_id
18278: INTO l_change_id
18279: FROM eng_engineering_changes WHERE change_notice = p_change_notice
18280: AND organization_id = p_org_id;
18281:
18282: ENG_CHANGE_LIFECYCLE_UTIL.Init_Lifecycle(
18283: p_api_version => 1.0,