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_WORKFLOW_UTIL dependencies on ENG_CHANGE_ROUTE_PEOPLE

Line 999: , ENG_CHANGE_ROUTE_PEOPLE step_people

995: CURSOR c_route_people (p_route_id NUMBER)
996: IS
997: SELECT EngSecPeople.user_name user_role
998: FROM ENG_SECURITY_PEOPLE_V EngSecPeople
999: , ENG_CHANGE_ROUTE_PEOPLE step_people
1000: , ENG_CHANGE_ROUTE_STEPS step
1001: WHERE EngSecPeople.person_id = step_people.assignee_id
1002: AND step_people.assignee_type_code = Eng_Workflow_Util.G_PERSON
1003: AND step_people.assignee_id <> -1

Line 1053: , ENG_CHANGE_ROUTE_PEOPLE step_people

1049: CURSOR c_step_people (p_route_step_id NUMBER)
1050: IS
1051: SELECT EngSecPeople.user_name user_role
1052: FROM ENG_SECURITY_PEOPLE_V EngSecPeople
1053: , ENG_CHANGE_ROUTE_PEOPLE step_people
1054: WHERE EngSecPeople.person_id = step_people.assignee_id
1055: AND step_people.assignee_id <> -1
1056: AND step_people.assignee_type_code = Eng_Workflow_Util.G_PERSON
1057: AND step_people.step_id = p_route_step_id

Line 1402: , ENG_CHANGE_ROUTE_PEOPLE step_people

1398: CURSOR c_route_people (p_route_id NUMBER)
1399: IS
1400: SELECT EngSecPeople.user_name user_role
1401: FROM ENG_SECURITY_PEOPLE_V EngSecPeople
1402: , ENG_CHANGE_ROUTE_PEOPLE step_people
1403: , ENG_CHANGE_ROUTE_STEPS step
1404: WHERE EngSecPeople.person_id = step_people.assignee_id
1405: AND step_people.assignee_type_code = Eng_Workflow_Util.G_PERSON
1406: AND step_people.assignee_id <> -1

Line 1438: , ENG_CHANGE_ROUTE_PEOPLE step_people

1434: CURSOR c_step_people (p_route_step_id NUMBER)
1435: IS
1436: SELECT EngSecPeople.user_name user_role
1437: FROM ENG_SECURITY_PEOPLE_V EngSecPeople
1438: , ENG_CHANGE_ROUTE_PEOPLE step_people
1439: WHERE EngSecPeople.person_id = step_people.assignee_id
1440: AND step_people.assignee_id <> -1
1441: AND step_people.assignee_type_code = Eng_Workflow_Util.G_PERSON
1442: AND step_people.step_id = p_route_step_id

Line 4671: update ENG_CHANGE_ROUTE_PEOPLE set

4667: END IF ;
4668:
4669:
4670:
4671: update ENG_CHANGE_ROUTE_PEOPLE set
4672: response_code = l_default_assignee_resp,
4673: last_update_date = SYSDATE ,
4674: last_updated_by = p_wf_user_id,
4675: last_update_login = ''

Line 4688: update ENG_CHANGE_ROUTE_PEOPLE set

4684: , Eng_Workflow_Util.G_RT_ABORTED
4685: )
4686: THEN
4687:
4688: update ENG_CHANGE_ROUTE_PEOPLE set
4689: response_code = '',
4690: last_update_date = SYSDATE ,
4691: last_updated_by = p_wf_user_id,
4692: last_update_login = ''

Line 5940: FROM ENG_CHANGE_ROUTE_PEOPLE people

5936:
5937: SELECT step.step_seq_num
5938: FROM ENG_CHANGE_ROUTE_STEPS step
5939: WHERE EXISTS (SELECT 'Invalid Assignee Exists'
5940: FROM ENG_CHANGE_ROUTE_PEOPLE people
5941: WHERE people.assignee_id = -1
5942: AND people.assignee_type_code = Eng_Workflow_Util.G_PERSON
5943: AND people.step_id = step.step_id )
5944: AND step.route_id = p_route_id ;

Line 6023: ENG_CHANGE_ROUTE_PEOPLE PEOPLE

6019: CURSOR c_Mandatory_route_assignees (p_route_id NUMBER)
6020: IS
6021: SELECT steps.STEP_SEQ_NUM ,steps.step_id
6022: FROM ENG_CHANGE_ROUTE_STEPS steps ,
6023: ENG_CHANGE_ROUTE_PEOPLE PEOPLE
6024: WHERE CONDITION_TYPE_CODE = 'PEOPLE'
6025: AND STEPS.STEP_ID = PEOPLE.STEP_ID
6026: AND PEOPLE.RESPONSE_CONDITION_CODE = 'MANDATORY'
6027: AND PEOPLE.ASSIGNEE_ID=-1

Line 8291: FROM ENG_CHANGE_ROUTE_PEOPLE RoutePeople

8287: , RoutePeople.assignee_type_code
8288: , RoutePeople.original_assignee_id
8289: , RoutePeople.original_assignee_type_code
8290: , RoutePeople.response_condition_code
8291: FROM ENG_CHANGE_ROUTE_PEOPLE RoutePeople
8292: , ENG_SECURITY_PEOPLE_V EngSecPeople
8293: , WF_NOTIFICATIONS wn
8294: WHERE RoutePeople.assignee_id = EngSecPeople.person_id
8295: -- AND RoutePeople.assignee_type_code = p_assignee_type_code

Line 8474: Write_Debug('Calling Eng_Change_Route_People_Util.UPDATE_ROW - Route People Id: ' || l_route_people_id ) ;

8470: * if we use UPDATE_ROW api, the response is only updated with
8471: * the lang record used while responding to ntf
8472:
8473: IF g_debug_flag THEN
8474: Write_Debug('Calling Eng_Change_Route_People_Util.UPDATE_ROW - Route People Id: ' || l_route_people_id ) ;
8475: END IF ;
8476:
8477: Eng_Change_Route_People_Util.UPDATE_ROW
8478: ( X_ROUTE_PEOPLE_ID => l_route_people_id ,

Line 8477: Eng_Change_Route_People_Util.UPDATE_ROW

8473: IF g_debug_flag THEN
8474: Write_Debug('Calling Eng_Change_Route_People_Util.UPDATE_ROW - Route People Id: ' || l_route_people_id ) ;
8475: END IF ;
8476:
8477: Eng_Change_Route_People_Util.UPDATE_ROW
8478: ( X_ROUTE_PEOPLE_ID => l_route_people_id ,
8479: X_REQUEST_ID => null ,
8480: X_ORIGINAL_SYSTEM_REFERENCE => null ,
8481: X_ASSIGNEE_ID => l_performer_party_id ,

Line 8501: update ENG_CHANGE_ROUTE_PEOPLE set

8497: X_RESPONSE_CONDITION_CODE => l_response_condition_code
8498: ) ;
8499: */
8500:
8501: update ENG_CHANGE_ROUTE_PEOPLE set
8502: WF_NOTIFICATION_ID = p_notification_id,
8503: RESPONSE_CODE = p_response_code ,
8504: RESPONSE_DATE = SYSDATE ,
8505: LAST_UPDATE_DATE = SYSDATE ,

Line 8510: update ENG_CHANGE_ROUTE_PEOPLE_TL set

8506: LAST_UPDATED_BY = l_performer_user_id ,
8507: LAST_UPDATE_LOGIN = null
8508: where ROUTE_PEOPLE_ID = l_route_people_id ;
8509:
8510: update ENG_CHANGE_ROUTE_PEOPLE_TL set
8511: RESPONSE_DESCRIPTION = l_comment,
8512: LAST_UPDATE_DATE = SYSDATE ,
8513: LAST_UPDATED_BY = l_performer_user_id ,
8514: LAST_UPDATE_LOGIN = null ,

Line 9472: FROM ENG_CHANGE_ROUTE_PEOPLE RoutePeople

9468: IS
9469:
9470: SELECT RoutePeople.assignee_id
9471: , RoutePeople.adhoc_people_flag
9472: FROM ENG_CHANGE_ROUTE_PEOPLE RoutePeople
9473: WHERE RoutePeople.assignee_type_code = p_assignee_type_code
9474: AND RoutePeople.assignee_id <> -1
9475: AND RoutePeople.step_id = p_step_id ;
9476:

Line 9883: FROM ENG_CHANGE_ROUTE_PEOPLE RoutePeople

9879: --
9880: --
9881: SELECT COUNT(*)
9882: INTO l_total_pop
9883: FROM ENG_CHANGE_ROUTE_PEOPLE RoutePeople
9884: , EGO_USER_V UserV
9885: , WF_NOTIFICATIONS wn
9886: WHERE RoutePeople.assignee_id = UserV.party_id
9887: AND RoutePeople.response_condition_code = 'MANDATORY'

Line 9895: FROM ENG_CHANGE_ROUTE_PEOPLE RoutePeople

9891:
9892:
9893: SELECT COUNT(*)
9894: INTO l_total_voted
9895: FROM ENG_CHANGE_ROUTE_PEOPLE RoutePeople
9896: , EGO_USER_V UserV
9897: , WF_NOTIFICATIONS wn
9898: WHERE RoutePeople.assignee_id = UserV.party_id
9899: AND RoutePeople.response_condition_code = 'MANDATORY'

Line 9908: FROM ENG_CHANGE_ROUTE_PEOPLE RoutePeople

9904:
9905:
9906: SELECT COUNT(*)
9907: INTO l_code_count
9908: FROM ENG_CHANGE_ROUTE_PEOPLE RoutePeople
9909: , EGO_USER_V UserV
9910: , WF_NOTIFICATION_ATTRIBUTES wfna
9911: , WF_NOTIFICATIONS wn
9912: WHERE RoutePeople.assignee_id = UserV.party_id

Line 13232: FROM ENG_CHANGE_ROUTE_PEOPLE RoutePeople

13228: , RoutePeople.assignee_type_code
13229: , RoutePeople.original_assignee_id
13230: , RoutePeople.original_assignee_type_code
13231: , RoutePeople.response_condition_code
13232: FROM ENG_CHANGE_ROUTE_PEOPLE RoutePeople
13233: , ENG_SECURITY_PEOPLE_V EngSecPeople
13234: , WF_NOTIFICATIONS wn
13235: WHERE RoutePeople.assignee_id = EngSecPeople.person_id
13236: -- AND RoutePeople.assignee_type_code = p_assignee_type_code

Line 13340: update ENG_CHANGE_ROUTE_PEOPLE set

13336: l_original_assignee_type_code := rtp_rec.original_assignee_type_code ;
13337: l_response_condition_code := rtp_rec.response_condition_code ;
13338:
13339:
13340: update ENG_CHANGE_ROUTE_PEOPLE set
13341: WF_NOTIFICATION_ID = p_notification_id,
13342: RESPONSE_CODE = l_response_code ,
13343: RESPONSE_DATE = SYSDATE ,
13344: LAST_UPDATE_DATE = SYSDATE ,

Line 13349: update ENG_CHANGE_ROUTE_PEOPLE_TL set

13345: LAST_UPDATED_BY = l_performer_user_id ,
13346: LAST_UPDATE_LOGIN = null
13347: where ROUTE_PEOPLE_ID = l_route_people_id ;
13348:
13349: update ENG_CHANGE_ROUTE_PEOPLE_TL set
13350: RESPONSE_DESCRIPTION = l_comment,
13351: LAST_UPDATE_DATE = SYSDATE ,
13352: LAST_UPDATED_BY = l_performer_user_id ,
13353: LAST_UPDATE_LOGIN = null ,

Line 13382: select ENG_CHANGE_ROUTE_PEOPLE_S.nextval into l_new_route_people_id from dual;

13378: END IF ;
13379:
13380: END IF ;
13381:
13382: select ENG_CHANGE_ROUTE_PEOPLE_S.nextval into l_new_route_people_id from dual;
13383:
13384: Eng_Change_Route_People_Util.INSERT_ROW
13385: (
13386: X_ROWID => l_rowid,

Line 13384: Eng_Change_Route_People_Util.INSERT_ROW

13380: END IF ;
13381:
13382: select ENG_CHANGE_ROUTE_PEOPLE_S.nextval into l_new_route_people_id from dual;
13383:
13384: Eng_Change_Route_People_Util.INSERT_ROW
13385: (
13386: X_ROWID => l_rowid,
13387: X_ROUTE_PEOPLE_ID => l_new_route_people_id ,
13388: X_STEP_ID => l_step_id ,

Line 13642: FROM ENG_CHANGE_ROUTE_PEOPLE RoutePeople

13638: , RoutePeople.ORIGINAL_ASSIGNEE_TYPE_CODE
13639: , RoutePeople.RESPONSE_CONDITION_CODE
13640: , TO_CHAR(NULL) ORIG_ROLE_OBJECT_NAME
13641: , TO_NUMBER(NULL) ORIG_ROLE_OBJECT_ID
13642: FROM ENG_CHANGE_ROUTE_PEOPLE RoutePeople
13643: WHERE RoutePeople.ASSIGNEE_TYPE_CODE = 'PERSON'
13644: AND RoutePeople.ASSIGNEE_ID <> -1
13645: AND RoutePeople.ORIGINAL_ASSIGNEE_TYPE_CODE <> 'ROLE'
13646: AND ( RoutePeople.RESPONSE_CODE IS NULL

Line 13664: , ENG_CHANGE_ROUTE_PEOPLE RoutePeople

13660: , fnd_obj.OBJECT_ID ORIG_ROLE_OBJECT_ID
13661: FROM FND_FORM_FUNCTIONS fnd_func
13662: , FND_MENU_ENTRIES fnd_menu
13663: , FND_OBJECTS fnd_obj
13664: , ENG_CHANGE_ROUTE_PEOPLE RoutePeople
13665: WHERE fnd_obj.OBJECT_ID = fnd_func.OBJECT_ID
13666: AND fnd_func.FUNCTION_ID = fnd_menu.FUNCTION_ID
13667: AND fnd_menu.MENU_ID = ORIGINAL_ASSIGNEE_ID
13668: AND ( RoutePeople.RESPONSE_CODE IS NULL

Line 14597: FROM ENG_CHANGE_ROUTE_PEOPLE RoutePeople

14593: , RoutePeople.ORIGINAL_ASSIGNEE_TYPE_CODE
14594: , RoutePeople.RESPONSE_CONDITION_CODE
14595: , TO_CHAR(NULL) ORIG_ROLE_OBJECT_NAME
14596: , TO_NUMBER(NULL) ORIG_ROLE_OBJECT_ID
14597: FROM ENG_CHANGE_ROUTE_PEOPLE RoutePeople
14598: , ENG_CHANGE_ROUTE_STEPS RouteStep
14599: WHERE RoutePeople.ASSIGNEE_TYPE_CODE = 'PERSON'
14600: AND RoutePeople.ASSIGNEE_ID <> -1
14601: AND RoutePeople.ORIGINAL_ASSIGNEE_TYPE_CODE <> 'ROLE'

Line 14620: , ENG_CHANGE_ROUTE_PEOPLE RoutePeople

14616: , fnd_obj.OBJECT_ID ORIG_ROLE_OBJECT_ID
14617: FROM FND_FORM_FUNCTIONS fnd_func
14618: , FND_MENU_ENTRIES fnd_menu
14619: , FND_OBJECTS fnd_obj
14620: , ENG_CHANGE_ROUTE_PEOPLE RoutePeople
14621: , ENG_CHANGE_ROUTE_STEPS RouteStep
14622: WHERE fnd_obj.OBJECT_ID = fnd_func.OBJECT_ID
14623: AND fnd_func.FUNCTION_ID = fnd_menu.FUNCTION_ID
14624: AND fnd_menu.MENU_ID = ORIGINAL_ASSIGNEE_ID