APPS.ENG_NIR_UTIL_PKG dependencies on ENG_CHANGE_ACTIONS

Line 128: l_action_id eng_change_actions.action_id%TYPE;

124: l_wf_process_name VARCHAR2(30);
125: l_return_status VARCHAR2(1);
126: l_msg_count NUMBER ;
127: l_msg_data VARCHAR2(200);
128: l_action_id eng_change_actions.action_id%TYPE;
129: l_chk_fn_ret_val VARCHAR2(10);
130: l_party_id NUMBER;
131: l_inventory_item_id VARCHAR2(100); -- ENG_CHANGE_SUBJECTS.PK1_VALUE
132: l_organization_id VARCHAR2(100); -- ENG_CHANGE_SUBJECTS.PK2_VALUE

Line 240: ENG_CHANGE_ACTIONS_UTIL.Create_Change_Action

236:
237: x_nir_cancel_status := 'TRUE';
238:
239: -- Create action log entries for the Cancel action.
240: ENG_CHANGE_ACTIONS_UTIL.Create_Change_Action
241: (
242: p_api_version => 1.0,
243: p_init_msg_list => FND_API.G_TRUE,
244: p_commit => FND_API.G_FALSE,

Line 689: l_action_id eng_change_actions.action_id%TYPE;

685: l_change_notice ENG_ENGINEERING_CHANGES.CHANGE_NOTICE%TYPE;
686: l_return_status VARCHAR2(1);
687: l_msg_count NUMBER ;
688: l_msg_data VARCHAR2(200);
689: l_action_id eng_change_actions.action_id%TYPE;
690: l_change_status_code eng_engineering_changes.status_code%TYPE;
691: BEGIN
692: -- First check whether the change(NIR) is in Draft status. If so the remove the line and subjects
693: SELECT status_code INTO l_change_status_code FROM eng_engineering_changes WHERE change_id = p_change_id;

Line 721: ENG_CHANGE_ACTIONS_UTIL.Create_Change_Action

717: -- Set change line status to Cancelled
718: UPDATE ENG_CHANGE_LINES SET status_code = 5 -- Cancelled
719: WHERE change_id = p_change_id AND change_line_id = l_change_line_id;
720: -- Update the Action Log of the NIR.
721: ENG_CHANGE_ACTIONS_UTIL.Create_Change_Action
722: (
723: p_api_version => 1.0,
724: p_init_msg_list => FND_API.G_TRUE,
725: p_commit => FND_API.G_FALSE,