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 2005/12/22 04:26:02 lkasturi noship $ */
3:
4: -- Global variables and constants
5: -- ---------------------------------------------------------------------------

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

2: /* $Header: ENGUCCMB.pls 120.3 2005/12/22 04:26:02 lkasturi noship $ */
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 282: SELECT eng_change_actions_s.nextval into l_new_action_id

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

Line 293: ENG_CHANGE_ACTIONS_PKG.INSERT_ROW(

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

Line 486: UPDATE Eng_Change_Actions

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

Line 620: FROM eng_change_actions

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

Line 775: l_action_id ENG_CHANGE_ACTIONS.ACTION_ID%TYPE;

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

Line 778: FROM ENG_CHANGE_ACTIONS

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

Line 824: ENG_CHANGE_ACTIONS_PKG.DELETE_ROW( l_action_id );

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

Line 883: END ENG_CHANGE_ACTIONS_UTIL;

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