APPS.EGO_ITEM_AML_PUB dependencies on MTL_MFG_PART_NUMBERS

Line 142: l_prod_data_row MTL_MFG_PART_NUMBERS%ROWTYPE;

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;
146:

Line 144: TYPE NUM_TABLE_TYPE IS TABLE OF mtl_mfg_part_numbers.manufacturer_id%TYPE;

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;
146:
147: l_organization_id_tbl NUM_TABLE_TYPE;
148: l_manufacturer_id_tbl NUM_TABLE_TYPE;

Line 145: TYPE CHAR150_TABLE_TYPE IS TABLE OF mtl_mfg_part_numbers.mfg_part_num%TYPE;

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;
146:
147: l_organization_id_tbl NUM_TABLE_TYPE;
148: l_manufacturer_id_tbl NUM_TABLE_TYPE;
149: l_mfg_part_num_tbl CHAR150_TABLE_TYPE;

Line 182: FROM mtl_mfg_part_numbers

178: ,cp_organization_id IN NUMBER
179: ,cp_manufacturer_id IN NUMBER
180: ,cp_mfg_part_num IN VARCHAR2) IS
181: SELECT *
182: FROM mtl_mfg_part_numbers
183: WHERE inventory_item_id = cp_inventory_item_id
184: AND organization_id = cp_organization_id
185: AND manufacturer_id = cp_manufacturer_id
186: AND mfg_part_num = cp_mfg_part_num;

Line 364: UPDATE mtl_mfg_part_numbers

360: ,cp_acd_type => l_acd_type_tbl(l_pend_index)
361: );
362: FETCH c_get_pending_data INTO l_pend_data_row;
363: CLOSE c_get_pending_data;
364: UPDATE mtl_mfg_part_numbers
365: SET first_article_status = l_pend_data_row.first_article_status
366: ,approval_status = l_pend_data_row.approval_status
367: ,start_date = l_pend_data_row.start_date
368: ,end_date = l_pend_data_row.end_date

Line 397: -- delete the record from mtl_mfg_part_numbers

393: ,p_message => 'successfully updated production row'
394: );
395: event_dml_Type := 'UPDATE';
396: ELSIF l_acd_type_tbl(l_pend_index) = G_DELETE_ACD_TYPE THEN
397: -- delete the record from mtl_mfg_part_numbers
398: DELETE mtl_mfg_part_numbers
399: WHERE manufacturer_id = l_manufacturer_id_tbl(l_pend_index)
400: AND inventory_item_id = l_inventory_item_id_tbl(l_pend_index)
401: AND organization_id = l_organization_id_tbl(l_pend_index)

Line 398: DELETE mtl_mfg_part_numbers

394: );
395: event_dml_Type := 'UPDATE';
396: ELSIF l_acd_type_tbl(l_pend_index) = G_DELETE_ACD_TYPE THEN
397: -- delete the record from mtl_mfg_part_numbers
398: DELETE mtl_mfg_part_numbers
399: WHERE manufacturer_id = l_manufacturer_id_tbl(l_pend_index)
400: AND inventory_item_id = l_inventory_item_id_tbl(l_pend_index)
401: AND organization_id = l_organization_id_tbl(l_pend_index)
402: AND mfg_part_num = l_mfg_part_num_tbl(l_pend_index);

Line 440: INSERT INTO mtl_mfg_part_numbers

436: );
437: FETCH c_get_pending_data INTO l_pend_data_row;
438: CLOSE c_get_pending_data;
439: -- insert a new record into production table
440: INSERT INTO mtl_mfg_part_numbers
441: (manufacturer_id
442: ,mfg_part_num
443: ,inventory_item_id
444: ,last_update_date

Line 1297: FROM mtl_mfg_part_numbers

1293: --
1294: BEGIN
1295: SELECT 'X'
1296: INTO l_return_status
1297: FROM mtl_mfg_part_numbers
1298: WHERE manufacturer_id = p_manufacturer_id
1299: AND rownum = 1;
1300: l_message_name := 'EGO_MTL_MFG_PART_NUM_EXIST';
1301: EXCEPTION