APPS.CTO_DEACTIVATE_CONFIG_PK dependencies on MTL_PENDING_ITEM_STATUS

Line 66: | multiple times in mtl_pending_item_status ,every |

62: | chnages for using table of records at various |
63: | The changes are identfied in the code by bugfix# |
64: | |
65: | 2.Deactivated items were getting inserted |
66: | multiple times in mtl_pending_item_status ,every |
67: | time the deactiavtion program is being run . It |
68: | should get inserted only once during teh first |
69: | time |
70: | changed the check_delete_status to pick |

Line 243: mtl_pending_item_status and deleting from bom_ato_configuration_items

239:
240: /*************************************************************************
241: forward declaration
242: DEACTIVATE_ITEMS deactivates the items by inserting pending flag in
243: mtl_pending_item_status and deleting from bom_ato_configuration_items
244: ***************************************************************************/
245: PROCEDURE DEACTIVATE_ITEMS(
246: p_table IN t_cfg_item_details,
247: p_org_id IN NUMBER,

Line 1141: -- also in mtl_pending_item_status or just master level insertion is fine ?

1137:
1138:
1139: --
1140: -- If the attribute control is at Master level, should we insert the child orgs
1141: -- also in mtl_pending_item_status or just master level insertion is fine ?
1142: -- shailendra agarwal (skagarwa) from BOM team confirmed on Jul 31st that we dont have to
1143: -- insert the child orgs if attr control is at master level
1144: --
1145:

Line 1701: INSERT INTO mtl_pending_item_status

1697: WriteToLog('inserting item id '||p_table(l_index).cfg_item_id ||
1698: ' in organization '||p_table(l_index).cfg_orgn_id, 5);
1699:
1700:
1701: INSERT INTO mtl_pending_item_status
1702: ( inventory_item_id,
1703: organization_id,
1704: status_code,
1705: effective_date,

Line 1818: from bom_bill_of_materials b, mtl_pending_item_status m

1814: program_id = p_program_id,
1815: program_update_date = sysdate
1816: WHERE bill_sequence_id in (
1817: select b.bill_sequence_id
1818: from bom_bill_of_materials b, mtl_pending_item_status m
1819: where m.status_code = p_status_code
1820: and m.pending_flag = 'Y'
1821: and m.request_id = p_request_id
1822: -- and m.organization_id = b.organization_id --mbsk: for master level control

Line 1840: from bom_operational_routings b,mtl_pending_item_status m

1836: program_id = p_program_id,
1837: program_update_date = SYSDATE
1838: WHERE routing_sequence_id in(
1839: select b.routing_sequence_id
1840: from bom_operational_routings b,mtl_pending_item_status m
1841: where m.status_code = p_status_code
1842: and m.pending_flag = 'Y'
1843: and m.request_id = p_request_id
1844: -- and b.organization_id = m.organization_id --mbsk: for mast level control

Line 1865: from bom_bill_of_materials b, mtl_pending_item_status m

1861: program_id = p_program_id,
1862: program_update_date = sysdate
1863: WHERE bill_sequence_id in (
1864: select b.bill_sequence_id
1865: from bom_bill_of_materials b, mtl_pending_item_status m
1866: where m.status_code = p_status_code
1867: and m.pending_flag = 'Y'
1868: and m.request_id = p_request_id
1869: and m.organization_id = b.organization_id

Line 1888: from bom_operational_routings b,mtl_pending_item_status m

1884: program_id = p_program_id,
1885: program_update_date = SYSDATE
1886: WHERE routing_sequence_id in(
1887: select b.routing_sequence_id
1888: from bom_operational_routings b,mtl_pending_item_status m
1889: where m.status_code = p_status_code
1890: and m.pending_flag = 'Y'
1891: and m.request_id = p_request_id
1892: and b.organization_id = m.organization_id

Line 1956: FROM mtl_pending_item_status

1952: --End Bugfix 7011607
1953:
1954:
1955: SELECT status_code INTO l_status_code
1956: FROM mtl_pending_item_status
1957: WHERE organization_id = l_org_id --Bugfix 7011607
1958: AND inventory_item_id = p_inventory_item_id
1959: AND EFFECTIVE_DATE --bugfix2308063
1960: = (SELECT max( EFFECTIVE_DATE) --bugfix2308063

Line 1961: FROM mtl_pending_item_status

1957: WHERE organization_id = l_org_id --Bugfix 7011607
1958: AND inventory_item_id = p_inventory_item_id
1959: AND EFFECTIVE_DATE --bugfix2308063
1960: = (SELECT max( EFFECTIVE_DATE) --bugfix2308063
1961: FROM mtl_pending_item_status
1962: WHERE organization_id = l_org_id --Bugfix 7011607
1963: AND inventory_item_id = p_inventory_item_id);
1964:
1965: WriteToLog('l_status_code:'||l_status_code, 5 );

Line 1976: /* (FP 5546965)Bug 5527407: Handle the case when no record exists in mtl_pending_item_status. */

1972: END IF;
1973:
1974: WriteToLog('Exiting check_delete_status with return status '||x_return_status, 5 );
1975: EXCEPTION
1976: /* (FP 5546965)Bug 5527407: Handle the case when no record exists in mtl_pending_item_status. */
1977: WHEN NO_DATA_FOUND THEN
1978: WriteToLog('Came to no_data_found in CHECK_DELETE_STATUS', 5);
1979:
1980: select inventory_item_status_code