APPS.ENG_WORKFLOW_UTIL dependencies on ENG_CHANGE_ROUTE_PEOPLE_S

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 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 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 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,