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