APPS.ENG_NIR_UTIL_PKG dependencies on ENG_CHANGE_ACTIONS

Line 124: l_action_id eng_change_actions.action_id%TYPE;

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

Line 236: ENG_CHANGE_ACTIONS_UTIL.Create_Change_Action

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

Line 685: l_action_id eng_change_actions.action_id%TYPE;

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

Line 717: ENG_CHANGE_ACTIONS_UTIL.Create_Change_Action

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