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 8281: --Note: To check whether ENG_CHANGE_ROUTE_PEOPLE includes null wf_notification_id or not.

8277: l_base_change_mgmt_type_code VARCHAR2(30);
8278: l_message_text VARCHAR2(400);
8279:
8280: --Bug 11802032 Start
8281: --Note: To check whether ENG_CHANGE_ROUTE_PEOPLE includes null wf_notification_id or not.
8282: l_chg_rte_cnt_nonull_ntfid NUMBER := 0;
8283: --Bug 11802032 END
8284:
8285: CURSOR c_route_person ( p_step_id NUMBER

Line 8296: FROM ENG_CHANGE_ROUTE_PEOPLE RoutePeople

8292: , RoutePeople.assignee_type_code
8293: , RoutePeople.original_assignee_id
8294: , RoutePeople.original_assignee_type_code
8295: , RoutePeople.response_condition_code
8296: FROM ENG_CHANGE_ROUTE_PEOPLE RoutePeople
8297: , ENG_SECURITY_PEOPLE_V EngSecPeople
8298: , WF_NOTIFICATIONS wn
8299: WHERE RoutePeople.assignee_id = EngSecPeople.person_id
8300: -- AND RoutePeople.assignee_type_code = p_assignee_type_code

Line 8321: FROM ENG_CHANGE_ROUTE_PEOPLE RoutePeople

8317: , RoutePeople.assignee_type_code
8318: , RoutePeople.original_assignee_id
8319: , RoutePeople.original_assignee_type_code
8320: , RoutePeople.response_condition_code
8321: FROM ENG_CHANGE_ROUTE_PEOPLE RoutePeople
8322: , ENG_SECURITY_PEOPLE_V EngSecPeople
8323: , WF_NOTIFICATIONS wn
8324: WHERE RoutePeople.assignee_id = EngSecPeople.person_id
8325: AND RoutePeople.step_id = p_step_id

Line 8499: --Note: Check whether ENG_CHANGE_ROUTE_PEOPLE has wf_notification_id or not.

8495: Write_Debug('notification_id : ' || to_char(p_notification_id) ) ;
8496: END IF ;
8497:
8498: --Bug 11802032 Start
8499: --Note: Check whether ENG_CHANGE_ROUTE_PEOPLE has wf_notification_id or not.
8500: -- bug 16324566, not use count(), add hint
8501: begin
8502: SELECT /*+ push_pred(ENGSECPEOPLE) */ 1
8503: into l_chg_rte_cnt_nonull_ntfid

Line 8504: FROM ENG_CHANGE_ROUTE_PEOPLE RoutePeople

8500: -- bug 16324566, not use count(), add hint
8501: begin
8502: SELECT /*+ push_pred(ENGSECPEOPLE) */ 1
8503: into l_chg_rte_cnt_nonull_ntfid
8504: FROM ENG_CHANGE_ROUTE_PEOPLE RoutePeople
8505: , ENG_SECURITY_PEOPLE_V EngSecPeople
8506: , WF_NOTIFICATIONS wn
8507: WHERE RoutePeople.assignee_id = EngSecPeople.person_id
8508: AND RoutePeople.step_id = l_step_id

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

8539: * if we use UPDATE_ROW api, the response is only updated with
8540: * the lang record used while responding to ntf
8541:
8542: IF g_debug_flag THEN
8543: Write_Debug('Calling Eng_Change_Route_People_Util.UPDATE_ROW - Route People Id: ' || l_route_people_id ) ;
8544: END IF ;
8545:
8546: Eng_Change_Route_People_Util.UPDATE_ROW
8547: ( X_ROUTE_PEOPLE_ID => l_route_people_id ,

Line 8546: Eng_Change_Route_People_Util.UPDATE_ROW

8542: IF g_debug_flag THEN
8543: Write_Debug('Calling Eng_Change_Route_People_Util.UPDATE_ROW - Route People Id: ' || l_route_people_id ) ;
8544: END IF ;
8545:
8546: Eng_Change_Route_People_Util.UPDATE_ROW
8547: ( X_ROUTE_PEOPLE_ID => l_route_people_id ,
8548: X_REQUEST_ID => null ,
8549: X_ORIGINAL_SYSTEM_REFERENCE => null ,
8550: X_ASSIGNEE_ID => l_performer_party_id ,

Line 8570: update ENG_CHANGE_ROUTE_PEOPLE set

8566: X_RESPONSE_CONDITION_CODE => l_response_condition_code
8567: ) ;
8568: */
8569:
8570: update ENG_CHANGE_ROUTE_PEOPLE set
8571: WF_NOTIFICATION_ID = p_notification_id,
8572: RESPONSE_CODE = p_response_code ,
8573: RESPONSE_DATE = SYSDATE ,
8574: LAST_UPDATE_DATE = SYSDATE ,

Line 8579: update ENG_CHANGE_ROUTE_PEOPLE_TL set

8575: LAST_UPDATED_BY = l_performer_user_id ,
8576: LAST_UPDATE_LOGIN = null
8577: where ROUTE_PEOPLE_ID = l_route_people_id ;
8578:
8579: update ENG_CHANGE_ROUTE_PEOPLE_TL set
8580: RESPONSE_DESCRIPTION = l_comment,
8581: LAST_UPDATE_DATE = SYSDATE ,
8582: LAST_UPDATED_BY = l_performer_user_id ,
8583: LAST_UPDATE_LOGIN = null ,

Line 9548: FROM ENG_CHANGE_ROUTE_PEOPLE RoutePeople

9544: IS
9545:
9546: SELECT RoutePeople.assignee_id
9547: , RoutePeople.adhoc_people_flag
9548: FROM ENG_CHANGE_ROUTE_PEOPLE RoutePeople
9549: WHERE RoutePeople.assignee_type_code = p_assignee_type_code
9550: AND RoutePeople.assignee_id <> -1
9551: AND RoutePeople.step_id = p_step_id ;
9552:

Line 9959: FROM ENG_CHANGE_ROUTE_PEOPLE RoutePeople

9955: --
9956: --
9957: SELECT COUNT(*)
9958: INTO l_total_pop
9959: FROM ENG_CHANGE_ROUTE_PEOPLE RoutePeople
9960: , EGO_USER_V UserV
9961: , WF_NOTIFICATIONS wn
9962: WHERE RoutePeople.assignee_id = UserV.party_id
9963: AND RoutePeople.response_condition_code = 'MANDATORY'

Line 9971: FROM ENG_CHANGE_ROUTE_PEOPLE RoutePeople

9967:
9968:
9969: SELECT COUNT(*)
9970: INTO l_total_voted
9971: FROM ENG_CHANGE_ROUTE_PEOPLE RoutePeople
9972: , EGO_USER_V UserV
9973: , WF_NOTIFICATIONS wn
9974: WHERE RoutePeople.assignee_id = UserV.party_id
9975: AND RoutePeople.response_condition_code = 'MANDATORY'

Line 9984: FROM ENG_CHANGE_ROUTE_PEOPLE RoutePeople

9980:
9981:
9982: SELECT COUNT(*)
9983: INTO l_code_count
9984: FROM ENG_CHANGE_ROUTE_PEOPLE RoutePeople
9985: , EGO_USER_V UserV
9986: , WF_NOTIFICATION_ATTRIBUTES wfna
9987: , WF_NOTIFICATIONS wn
9988: WHERE RoutePeople.assignee_id = UserV.party_id

Line 13311: FROM ENG_CHANGE_ROUTE_PEOPLE RoutePeople

13307: , RoutePeople.assignee_type_code
13308: , RoutePeople.original_assignee_id
13309: , RoutePeople.original_assignee_type_code
13310: , RoutePeople.response_condition_code
13311: FROM ENG_CHANGE_ROUTE_PEOPLE RoutePeople
13312: , ENG_SECURITY_PEOPLE_V EngSecPeople
13313: , WF_NOTIFICATIONS wn
13314: WHERE RoutePeople.assignee_id = EngSecPeople.person_id
13315: -- AND RoutePeople.assignee_type_code = p_assignee_type_code

Line 13338: FROM ENG_CHANGE_ROUTE_PEOPLE RoutePeople

13334: , RoutePeople.assignee_type_code
13335: , RoutePeople.original_assignee_id
13336: , RoutePeople.original_assignee_type_code
13337: , RoutePeople.response_condition_code
13338: FROM ENG_CHANGE_ROUTE_PEOPLE RoutePeople
13339: , ENG_SECURITY_PEOPLE_V EngSecPeople
13340: , WF_NOTIFICATIONS wn
13341: WHERE RoutePeople.assignee_id = EngSecPeople.person_id
13342: -- AND RoutePeople.assignee_type_code = p_assignee_type_code

Line 13450: --Note: Check whether ENG_CHANGE_ROUTE_PEOPLE has wf_notification_id or not.

13446: l_response_code := G_RT_FORWARDED ;
13447: END IF;
13448:
13449: --Bug 11802032 Start
13450: --Note: Check whether ENG_CHANGE_ROUTE_PEOPLE has wf_notification_id or not.
13451: -- bug 16324566, not use count(), add hint
13452: begin
13453: SELECT /*+ push_pred(ENGSECPEOPLE) */ 1
13454: into l_chg_rte_cnt_nonull_ntfid

Line 13455: FROM ENG_CHANGE_ROUTE_PEOPLE RoutePeople

13451: -- bug 16324566, not use count(), add hint
13452: begin
13453: SELECT /*+ push_pred(ENGSECPEOPLE) */ 1
13454: into l_chg_rte_cnt_nonull_ntfid
13455: FROM ENG_CHANGE_ROUTE_PEOPLE RoutePeople
13456: , ENG_SECURITY_PEOPLE_V EngSecPeople
13457: , WF_NOTIFICATIONS wn
13458: WHERE RoutePeople.assignee_id = EngSecPeople.person_id
13459: AND RoutePeople.step_id = l_step_id

Line 13485: update ENG_CHANGE_ROUTE_PEOPLE set

13481: l_original_assignee_type_code := rtp_rec.original_assignee_type_code ;
13482: l_response_condition_code := rtp_rec.response_condition_code ;
13483:
13484:
13485: update ENG_CHANGE_ROUTE_PEOPLE set
13486: WF_NOTIFICATION_ID = p_notification_id,
13487: RESPONSE_CODE = l_response_code ,
13488: RESPONSE_DATE = SYSDATE ,
13489: LAST_UPDATE_DATE = SYSDATE ,

Line 13494: update ENG_CHANGE_ROUTE_PEOPLE_TL set

13490: LAST_UPDATED_BY = l_performer_user_id ,
13491: LAST_UPDATE_LOGIN = null
13492: where ROUTE_PEOPLE_ID = l_route_people_id ;
13493:
13494: update ENG_CHANGE_ROUTE_PEOPLE_TL set
13495: RESPONSE_DESCRIPTION = l_comment,
13496: LAST_UPDATE_DATE = SYSDATE ,
13497: LAST_UPDATED_BY = l_performer_user_id ,
13498: LAST_UPDATE_LOGIN = null ,

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

13523: END IF ;
13524:
13525: END IF ;
13526:
13527: select ENG_CHANGE_ROUTE_PEOPLE_S.nextval into l_new_route_people_id from dual;
13528:
13529: Eng_Change_Route_People_Util.INSERT_ROW
13530: (
13531: X_ROWID => l_rowid,

Line 13529: Eng_Change_Route_People_Util.INSERT_ROW

13525: END IF ;
13526:
13527: select ENG_CHANGE_ROUTE_PEOPLE_S.nextval into l_new_route_people_id from dual;
13528:
13529: Eng_Change_Route_People_Util.INSERT_ROW
13530: (
13531: X_ROWID => l_rowid,
13532: X_ROUTE_PEOPLE_ID => l_new_route_people_id ,
13533: X_STEP_ID => l_step_id ,

Line 13787: FROM ENG_CHANGE_ROUTE_PEOPLE RoutePeople

13783: , RoutePeople.ORIGINAL_ASSIGNEE_TYPE_CODE
13784: , RoutePeople.RESPONSE_CONDITION_CODE
13785: , TO_CHAR(NULL) ORIG_ROLE_OBJECT_NAME
13786: , TO_NUMBER(NULL) ORIG_ROLE_OBJECT_ID
13787: FROM ENG_CHANGE_ROUTE_PEOPLE RoutePeople
13788: WHERE RoutePeople.ASSIGNEE_TYPE_CODE = 'PERSON'
13789: AND RoutePeople.ASSIGNEE_ID <> -1
13790: AND RoutePeople.ORIGINAL_ASSIGNEE_TYPE_CODE <> 'ROLE'
13791: AND ( RoutePeople.RESPONSE_CODE IS NULL

Line 13809: , ENG_CHANGE_ROUTE_PEOPLE RoutePeople

13805: , fnd_obj.OBJECT_ID ORIG_ROLE_OBJECT_ID
13806: FROM FND_FORM_FUNCTIONS fnd_func
13807: , FND_MENU_ENTRIES fnd_menu
13808: , FND_OBJECTS fnd_obj
13809: , ENG_CHANGE_ROUTE_PEOPLE RoutePeople
13810: WHERE fnd_obj.OBJECT_ID = fnd_func.OBJECT_ID
13811: AND fnd_func.FUNCTION_ID = fnd_menu.FUNCTION_ID
13812: AND fnd_menu.MENU_ID = ORIGINAL_ASSIGNEE_ID
13813: AND ( RoutePeople.RESPONSE_CODE IS NULL

Line 14742: FROM ENG_CHANGE_ROUTE_PEOPLE RoutePeople

14738: , RoutePeople.ORIGINAL_ASSIGNEE_TYPE_CODE
14739: , RoutePeople.RESPONSE_CONDITION_CODE
14740: , TO_CHAR(NULL) ORIG_ROLE_OBJECT_NAME
14741: , TO_NUMBER(NULL) ORIG_ROLE_OBJECT_ID
14742: FROM ENG_CHANGE_ROUTE_PEOPLE RoutePeople
14743: , ENG_CHANGE_ROUTE_STEPS RouteStep
14744: WHERE RoutePeople.ASSIGNEE_TYPE_CODE = 'PERSON'
14745: AND RoutePeople.ASSIGNEE_ID <> -1
14746: AND RoutePeople.ORIGINAL_ASSIGNEE_TYPE_CODE <> 'ROLE'

Line 14765: , ENG_CHANGE_ROUTE_PEOPLE RoutePeople

14761: , fnd_obj.OBJECT_ID ORIG_ROLE_OBJECT_ID
14762: FROM FND_FORM_FUNCTIONS fnd_func
14763: , FND_MENU_ENTRIES fnd_menu
14764: , FND_OBJECTS fnd_obj
14765: , ENG_CHANGE_ROUTE_PEOPLE RoutePeople
14766: , ENG_CHANGE_ROUTE_STEPS RouteStep
14767: WHERE fnd_obj.OBJECT_ID = fnd_func.OBJECT_ID
14768: AND fnd_func.FUNCTION_ID = fnd_menu.FUNCTION_ID
14769: AND fnd_menu.MENU_ID = ORIGINAL_ASSIGNEE_ID