The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE SELECT_ADHOC_PARTY(
itemtype in varchar2,
itemkey in varchar2,
actid in number,
funcmode in varchar2,
result in out NOCOPY varchar2)
IS
l_action_id NUMBER ;
SELECT party_id_list adhoc_party_list
, TRUNC(response_by_date) response_by_date
, sysdate
FROM ENG_CHANGE_ACTIONS
WHERE action_id = p_action_id ;
wf_core.context('Eng_Workflow_Pub', 'SELECT_ADHOC_PARTY',
itemtype, itemkey, to_char(actid), funcmode);
wf_core.context('Eng_Workflow_Pub', 'SELECT_ADHOC_PARTY',
itemtype, itemkey, to_char(actid), funcmode);
END SELECT_ADHOC_PARTY ;
PROCEDURE SELECT_ASSIGNEE (
itemtype in varchar2,
itemkey in varchar2,
actid in number,
funcmode in varchar2,
result in out NOCOPY varchar2)
IS
l_return_status VARCHAR2(1);
l_debug_filename VARCHAR2(30) ; -- 'SelectAssignee.log' ;
wf_core.context('Eng_Workflow_Pub', 'SELECT_ASSIGNEE',
itemtype, itemkey, to_char(actid), funcmode);
wf_core.context('Eng_Workflow_Pub', 'SELECT_ASSIGNEE',
itemtype, itemkey, to_char(actid), funcmode);
END SELECT_ASSIGNEE ;
PROCEDURE SELECT_STD_REVIEWERS(
itemtype in varchar2,
itemkey in varchar2,
actid in number,
funcmode in varchar2,
result in out NOCOPY varchar2)
IS
l_return_status VARCHAR2(1);
wf_core.context('Eng_Workflow_Pub', 'SELECT_STD_REVIEWERS',
itemtype, itemkey, to_char(actid), funcmode);
wf_core.context('Eng_Workflow_Pub', 'SELECT_STD_REVIEWERS',
itemtype, itemkey, to_char(actid), funcmode);
END SELECT_STD_REVIEWERS;
PROCEDURE SELECT_REVIEWERS(
itemtype in varchar2,
itemkey in varchar2,
actid in number,
funcmode in varchar2,
result in out NOCOPY varchar2)
IS
l_return_status VARCHAR2(1);
wf_core.context('Eng_Workflow_Pub', 'SELECT_REVIEWERS',
itemtype, itemkey, to_char(actid), funcmode);
wf_core.context('Eng_Workflow_Pub', 'SELECT_REVIEWERS',
itemtype, itemkey, to_char(actid), funcmode);
END SELECT_REVIEWERS;
PROCEDURE SELECT_LINE_ASSIGNEE (
itemtype in varchar2,
itemkey in varchar2,
actid in number,
funcmode in varchar2,
result in out NOCOPY varchar2)
IS
l_return_status VARCHAR2(1);
l_debug_filename VARCHAR2(30) ; -- 'SelectLineAssignee.log' ;
wf_core.context('Eng_Workflow_Pub', 'SELECT_LINE_ASSIGNEE',
itemtype, itemkey, to_char(actid), funcmode);
wf_core.context('Eng_Workflow_Pub', 'SELECT_LINE_ASSIGNEE',
itemtype, itemkey, to_char(actid), funcmode);
END SELECT_LINE_ASSIGNEE ;
PROCEDURE SELECT_STD_LINE_REVIEWERS(
itemtype in varchar2,
itemkey in varchar2,
actid in number,
funcmode in varchar2,
result in out NOCOPY varchar2)
IS
l_return_status VARCHAR2(1);
wf_core.context('Eng_Workflow_Pub', 'SELECT_STD_LINE_REVIEWERS',
itemtype, itemkey, to_char(actid), funcmode);
wf_core.context('Eng_Workflow_Pub', 'SELECT_STD_LINE_REVIEWERS',
itemtype, itemkey, to_char(actid), funcmode);
END SELECT_STD_LINE_REVIEWERS;
PROCEDURE SELECT_LINE_REVIEWERS(
itemtype in varchar2,
itemkey in varchar2,
actid in number,
funcmode in varchar2,
result in out NOCOPY varchar2)
IS
l_return_status VARCHAR2(1);
wf_core.context('Eng_Workflow_Pub', 'SELECT_LINE_REVIEWERS',
itemtype, itemkey, to_char(actid), funcmode);
wf_core.context('Eng_Workflow_Pub', 'SELECT_LINE_REVIEWERS',
itemtype, itemkey, to_char(actid), funcmode);
END SELECT_LINE_REVIEWERS;
PROCEDURE SELECT_ROUTE_PEOPLE(
itemtype in varchar2,
itemkey in varchar2,
actid in number,
funcmode in varchar2,
result in out NOCOPY varchar2)
IS
l_return_status VARCHAR2(1);
wf_core.context('Eng_Workflow_Pub', 'SELECT_ROUTE_PEOPLE',
itemtype, itemkey, to_char(actid), funcmode);
wf_core.context('Eng_Workflow_Pub', 'SELECT_ROUTE_PEOPLE',
itemtype, itemkey, to_char(actid), funcmode);
END SELECT_ROUTE_PEOPLE ;
PROCEDURE SELECT_STEP_PEOPLE(
itemtype in varchar2,
itemkey in varchar2,
actid in number,
funcmode in varchar2,
result in out NOCOPY varchar2)
IS
l_return_status VARCHAR2(1);
wf_core.context('Eng_Workflow_Pub', 'SELECT_STEP_PEOPLE',
itemtype, itemkey, to_char(actid), funcmode);
wf_core.context('Eng_Workflow_Pub', 'SELECT_STEP_PEOPLE',
itemtype, itemkey, to_char(actid), funcmode);
END SELECT_STEP_PEOPLE;
PROCEDURE DELETE_ADHOC_ROLES_AND_USERS(
itemtype in varchar2,
itemkey in varchar2,
actid in number,
funcmode in varchar2,
result in out NOCOPY varchar2)
IS
l_return_status VARCHAR2(1);
Eng_Workflow_Util.DeleteAdhocRolesAndUsers
( x_return_status => l_return_status
, x_msg_count => l_msg_count
, x_msg_data => l_msg_data
, p_item_type => itemtype
, p_item_key => itemkey
) ;
wf_core.context('Eng_Workflow_Pub', 'DELETE_ADHOC_ROLES_AND_USERS',
itemtype, itemkey, to_char(actid), funcmode);
wf_core.context('Eng_Workflow_Pub', 'DELETE_ADHOC_ROLES_AND_USERS',
itemtype, itemkey, to_char(actid), funcmode);
END DELETE_ADHOC_ROLES_AND_USERS ;
SELECT TRUNC(response_by_date) response_by_date
FROM ENG_CHANGE_ACTIONS
WHERE action_id = p_action_id ;
SELECT TRUNC(required_date) response_by_date
, condition_type_code
, required_relative_days required_relative_days
FROM ENG_CHANGE_ROUTE_STEPS
WHERE step_id = p_step_id ;
SELECT TRUNC(response_by_date) response_by_date
, sysdate
FROM ENG_CHANGE_ACTIONS
WHERE action_id = p_action_id ;
SELECT approval_status_type
FROM ENG_ENGINEERING_CHANGES
WHERE change_id = c_change_id ;