APPS.ENG_CHANGE_ACTIONS_UTIL dependencies on ENG_CHANGE_ACTIONS

Line 1: PACKAGE BODY ENG_CHANGE_ACTIONS_UTIL AS

1: PACKAGE BODY ENG_CHANGE_ACTIONS_UTIL AS
2: /* $Header: ENGUCCMB.pls 120.3.12010000.2 2009/11/04 07:33:07 maychen ship $ */
3:
4: -- Global variables and constants
5: -- ---------------------------------------------------------------------------

Line 6: G_PKG_NAME VARCHAR2(30) := 'ENG_CHANGE_ACTIONS_UTIL';

2: /* $Header: ENGUCCMB.pls 120.3.12010000.2 2009/11/04 07:33:07 maychen ship $ */
3:
4: -- Global variables and constants
5: -- ---------------------------------------------------------------------------
6: G_PKG_NAME VARCHAR2(30) := 'ENG_CHANGE_ACTIONS_UTIL';
7:
8: -- Global cursors
9: -- ---------------------------------------------------------------------------
10:

Line 167: * Create new action row in the ENG_CHANGE_ACTIONS and its TL table

163: * Purpose : Those APIs are private
164: *********************************************************************/
165:
166: /**
167: * Create new action row in the ENG_CHANGE_ACTIONS and its TL table
168: */
169: PROCEDURE Create_Change_Action
170: (
171: p_api_version IN NUMBER --

Line 233: -- Bug 8921326, init message list if any msg in msg_list before ENG_CHANGE_ACTIONS_PKG.INSERT_ROW

229: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
230: END IF;
231:
232: -- Initialize message list if p_init_msg_list is set to TRUE.
233: -- Bug 8921326, init message list if any msg in msg_list before ENG_CHANGE_ACTIONS_PKG.INSERT_ROW
234: IF FND_API.to_Boolean( p_init_msg_list ) OR (FND_MSG_PUB.Count_Msg >0) THEN
235: FND_MSG_PUB.initialize;
236: END IF ;
237:

Line 283: SELECT eng_change_actions_s.nextval into l_new_action_id

279: l_fnd_user_id := p_user_id;
280: l_fnd_login_id := '';
281: END IF;
282:
283: SELECT eng_change_actions_s.nextval into l_new_action_id
284: FROM DUAL;
285:
286: -- make sure it is called
287: IF ( p_parent_action_id IS NULL)

Line 294: ENG_CHANGE_ACTIONS_PKG.INSERT_ROW(

290: ELSE
291: l_parent_action_id := p_parent_action_id;
292: END IF;
293:
294: ENG_CHANGE_ACTIONS_PKG.INSERT_ROW(
295: X_ROWID => l_rowid, -- rowid (in/out)
296: X_ACTION_ID => l_new_action_id, -- action_id
297: X_ORIGINAL_SYSTEM_REFERENCE => null, -- original_system_reference
298: X_WORKFLOW_ITEM_KEY => p_workflow_item_key, -- workflow_item_key

Line 487: UPDATE Eng_Change_Actions

483: -- Initialize API return status to success
484: x_return_status := FND_API.G_RET_STS_SUCCESS;
485:
486: -- Update the comment table
487: UPDATE Eng_Change_Actions
488: SET workflow_item_type = p_workflow_item_type
489: ,workflow_item_key = p_workflow_item_key
490: WHERE action_id = p_change_action_id;
491:

Line 621: FROM eng_change_actions

617:
618: -- look up parent action's action type, workflow item type and item key
619: SELECT action_type, workflow_item_type, workflow_item_key
620: INTO l_action_type, l_wf_item_type, l_wf_item_key
621: FROM eng_change_actions
622: where action_id = p_parent_action_id;
623:
624: ENG_WORKFLOW_UTIL.RespondToActReqCommentFromUI
625: ( x_return_status => l_return_status

Line 776: l_action_id ENG_CHANGE_ACTIONS.ACTION_ID%TYPE;

772: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Line_Actions';
773: l_api_version CONSTANT NUMBER := 1.0;
774:
775:
776: l_action_id ENG_CHANGE_ACTIONS.ACTION_ID%TYPE;
777: CURSOR ECACursor IS
778: SELECT ACTION_ID
779: FROM ENG_CHANGE_ACTIONS
780: WHERE OBJECT_ID1 = p_change_id

Line 779: FROM ENG_CHANGE_ACTIONS

775:
776: l_action_id ENG_CHANGE_ACTIONS.ACTION_ID%TYPE;
777: CURSOR ECACursor IS
778: SELECT ACTION_ID
779: FROM ENG_CHANGE_ACTIONS
780: WHERE OBJECT_ID1 = p_change_id
781: AND OBJECT_ID2 = p_change_line_id
782: FOR UPDATE;
783:

Line 825: ENG_CHANGE_ACTIONS_PKG.DELETE_ROW( l_action_id );

821: OPEN ECACursor;
822: LOOP
823: FETCH ECACursor INTO l_action_id;
824: EXIT WHEN ECACursor%NOTFOUND;
825: ENG_CHANGE_ACTIONS_PKG.DELETE_ROW( l_action_id );
826: END LOOP;
827: CLOSE ECACursor;
828: -- End of Delete
829:

Line 884: END ENG_CHANGE_ACTIONS_UTIL;

880:
881: END Delete_Line_Actions;
882:
883:
884: END ENG_CHANGE_ACTIONS_UTIL;
885: