APPS.EGO_ITEM_AML_PUB dependencies on EGO_MFG_PART_NUM_CHGS

Line 141: l_pend_data_row EGO_MFG_PART_NUM_CHGS%ROWTYPE;

137: l_user_id NUMBER;
138: l_login_id NUMBER;
139: event_dml_Type VARCHAR2(30) := ' ';
140:
141: l_pend_data_row EGO_MFG_PART_NUM_CHGS%ROWTYPE;
142: l_prod_data_row MTL_MFG_PART_NUMBERS%ROWTYPE;
143:
144: TYPE NUM_TABLE_TYPE IS TABLE OF mtl_mfg_part_numbers.manufacturer_id%TYPE;
145: TYPE CHAR150_TABLE_TYPE IS TABLE OF mtl_mfg_part_numbers.mfg_part_num%TYPE;

Line 166: FROM ego_mfg_part_num_chgs

162: ,cp_mfg_part_num IN VARCHAR2
163: ,cp_change_line_id IN NUMBER
164: ,cp_acd_type IN VARCHAR2) IS
165: SELECT *
166: FROM ego_mfg_part_num_chgs
167: WHERE manufacturer_id = cp_mfg_id
168: AND inventory_item_id = cp_item_id
169: AND organization_id = cp_org_id
170: AND mfg_part_num = cp_mfg_part_num

Line 225: FROM ego_mfg_part_num_chgs

221: BULK COLLECT INTO
222: l_organization_id_tbl, l_manufacturer_id_tbl,
223: l_mfg_part_num_tbl, l_inventory_item_id_tbl,
224: l_change_line_id_tbl, l_acd_type_tbl
225: FROM ego_mfg_part_num_chgs
226: WHERE NVL(change_id,-1) = NVL(NVL(p_change_id, change_id),-1)
227: AND NVL(change_line_id, -1) =
228: NVL(NVL(p_change_line_id, change_line_id),-1)
229: AND implmentation_date IS NULL

Line 276: INSERT INTO ego_mfg_part_num_chgs

272: ,cp_mfg_part_num => l_mfg_part_num_tbl(l_pend_index));
273: FETCH c_get_production_data INTO l_prod_data_row;
274: IF c_get_production_data%FOUND THEN
275: -- create a history record in ego_mfg_part_num_changes
276: INSERT INTO ego_mfg_part_num_chgs
277: (manufacturer_id
278: ,mfg_part_num
279: ,inventory_item_id
280: ,last_update_date

Line 350: ,p_message => 'successfully created a history record in ego_mfg_part_num_chgs'

346: ,l_prod_data_row.start_date
347: ,l_prod_data_row.end_date);
348: log_now (p_log_level => FND_LOG.LEVEL_STATEMENT
349: ,p_module => l_api_name
350: ,p_message => 'successfully created a history record in ego_mfg_part_num_chgs'
351: );
352: IF l_acd_type_tbl(l_pend_index) = G_CHANGE_ACD_TYPE THEN
353: -- copy the pending row into production (basically update)
354: OPEN c_get_pending_data

Line 410: UPDATE ego_mfg_part_num_chgs

406: );
407: event_dml_Type := 'DELETE';
408: END IF;
409:
410: UPDATE ego_mfg_part_num_chgs
411: SET implmentation_date = l_sysdate
412: ,last_update_date = l_sysdate
413: ,last_updated_by = l_user_id
414: ,last_update_login = l_login_id

Line 511: UPDATE ego_mfg_part_num_chgs

507: );
508:
509: event_dml_Type := 'CREATE';
510: -- update the pending row as implemented
511: UPDATE ego_mfg_part_num_chgs
512: SET implmentation_date = l_sysdate
513: ,last_update_date = l_sysdate
514: ,last_updated_by = l_user_id
515: ,last_update_login = l_login_id

Line 653: -- FUNCTION : Delete the pending changes from EGO_MFG_PART_NUM_CHGS

649: -- Start OF comments
650: -- API name : Delete_AML_Pending_Changes
651: -- TYPE : Public
652: -- Pre-reqs : None
653: -- FUNCTION : Delete the pending changes from EGO_MFG_PART_NUM_CHGS
654: --
655: -- Parameters:
656: -- IN : p_inventory_item_id NUMBER
657: -- : p_organization_id NUMBER

Line 705: DELETE EGO_MFG_PART_NUM_CHGS

701: --
702: -- bug 3648353
703: -- delete all unimplemented changes in the context of change order
704: --
705: DELETE EGO_MFG_PART_NUM_CHGS
706: WHERE change_id = NVL(p_change_id, change_id)
707: AND change_line_id = NVL(p_change_line_id, change_line_id)
708: AND implmentation_date IS NULL;
709: ELSE

Line 713: DELETE EGO_MFG_PART_NUM_CHGS

709: ELSE
710: --
711: -- deleting an individual line (all parameters are passed here)
712: --
713: DELETE EGO_MFG_PART_NUM_CHGS
714: WHERE inventory_item_id = p_inventory_item_id
715: AND organization_id = p_organization_id
716: AND manufacturer_id = p_manufacturer_id
717: AND mfg_part_num = p_mfg_part_num

Line 1314: ( SELECT 'Y' FROM ego_mfg_part_num_chgs

1310: SELECT 'X'
1311: INTO l_return_status
1312: FROM DUAL
1313: WHERE EXISTS
1314: ( SELECT 'Y' FROM ego_mfg_part_num_chgs
1315: WHERE manufacturer_id = p_manufacturer_id
1316: );
1317: l_message_name := 'EGO_CHG_MFG_PART_NUM_EXIST';
1318: EXCEPTION