APPS.MTL_CROSS_REFERENCES_PVT dependencies on MTL_CROSS_REFERENCES_INTERFACE

Line 1681: -- MTL_CROSS_REFERENCES_INTERFACE for processing.

1677: -- -----------------------------------------------------------------------------
1678: -- Procedure Name: Process_XRef_Intf_Rows
1679: --
1680: -- Description : Concurrent program to pull rows from
1681: -- MTL_CROSS_REFERENCES_INTERFACE for processing.
1682: -- -----------------------------------------------------------------------------
1683: PROCEDURE Process_XRef_Intf_Rows(
1684: ERRBUF OUT NOCOPY VARCHAR2,
1685: RETCODE OUT NOCOPY VARCHAR2,

Line 1714: FROM MTL_CROSS_REFERENCES_INTERFACE A

1710: -- or all records if parameter is NULL
1711: -- and process flag is 1
1712: CURSOR C_INTF_ROWS(C_DATA_SET_ID NUMBER) IS
1713: SELECT A.ROWID, A.*
1714: FROM MTL_CROSS_REFERENCES_INTERFACE A
1715: WHERE DECODE(C_DATA_SET_ID, NULL, -1, A.SET_PROCESS_ID) = NVL(C_DATA_SET_ID, -1)
1716: AND A.PROCESS_FLAG = 1;
1717:
1718: BEGIN

Line 1727: UPDATE MTL_CROSS_REFERENCES_INTERFACE

1723: RETCODE := 0; -- assumes successful completion
1724:
1725: FOR l_mtl_xref_rec IN c_intf_rows(p_data_set_id) LOOP
1726:
1727: UPDATE MTL_CROSS_REFERENCES_INTERFACE
1728: SET Transaction_Id = MTL_CROSS_REF_INTERFACE_S.NEXTVAL,
1729: Request_Id = FND_GLOBAL.CONC_REQUEST_ID
1730: WHERE ROWID = l_mtl_xref_rec.ROWID;
1731: end loop;

Line 1780: ,p_table_name => 'MTL_CROSS_REFERENCES_INTERFACE'

1776: ,p_application_id => 'EGO'
1777: ,p_message_type => 'E'
1778: ,p_entity_code => G_Entity_Code
1779: ,p_entity_index => 1
1780: ,p_table_name => 'MTL_CROSS_REFERENCES_INTERFACE'
1781: );
1782:
1783: l_msg_count := 1;
1784: Error_Handler.Get_Entity_Message(G_Entity_Code, l_msg_list);

Line 1803: ,p_table_name => 'MTL_CROSS_REFERENCES_INTERFACE'

1799: ,p_application_id => 'EGO'
1800: ,p_message_type => 'E'
1801: ,p_entity_code => G_Entity_Code
1802: ,p_entity_index => 1
1803: ,p_table_name => 'MTL_CROSS_REFERENCES_INTERFACE'
1804: );
1805:
1806: l_msg_count := 1;
1807: Error_Handler.Get_Entity_Message(G_Entity_Code, l_msg_list);

Line 1837: ,p_table_name => 'MTL_CROSS_REFERENCES_INTERFACE'

1833: ,p_application_id => 'EGO'
1834: ,p_message_type => 'E'
1835: ,p_entity_code => G_Entity_Code
1836: ,p_entity_index => 1
1837: ,p_table_name => 'MTL_CROSS_REFERENCES_INTERFACE'
1838: );
1839:
1840: l_msg_count := 1;
1841: Error_Handler.Get_Entity_Message(G_Entity_Code, l_msg_list);

Line 1859: ,p_table_name => 'MTL_CROSS_REFERENCES_INTERFACE'

1855: ,p_application_id => 'EGO'
1856: ,p_message_type => 'E'
1857: ,p_entity_code => G_Entity_Code
1858: ,p_entity_index => 1
1859: ,p_table_name => 'MTL_CROSS_REFERENCES_INTERFACE'
1860: );
1861: l_msg_count := 1;
1862: Error_Handler.Get_Entity_Message(G_Entity_Code, l_msg_list);
1863:

Line 1895: ,p_table_name => 'MTL_CROSS_REFERENCES_INTERFACE'

1891: ,p_application_id => 'INV'
1892: ,p_message_type => 'E'
1893: ,p_entity_code => G_Entity_Code
1894: ,p_entity_index => 1
1895: ,p_table_name => 'MTL_CROSS_REFERENCES_INTERFACE'
1896: );
1897:
1898: l_msg_count := 1;
1899: Error_Handler.Get_Entity_Message(G_Entity_Code, l_msg_list);

Line 1916: ,p_table_name => 'MTL_CROSS_REFERENCES_INTERFACE'

1912: ,p_application_id => 'INV'
1913: ,p_message_type => 'E'
1914: ,p_entity_code => G_Entity_Code
1915: ,p_entity_index => 1
1916: ,p_table_name => 'MTL_CROSS_REFERENCES_INTERFACE'
1917: );
1918: l_msg_count := 1;
1919: Error_Handler.Get_Entity_Message(G_Entity_Code, l_msg_list);
1920:

Line 1979: UPDATE MTL_CROSS_REFERENCES_INTERFACE

1975: );
1976: END IF;
1977:
1978: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1979: UPDATE MTL_CROSS_REFERENCES_INTERFACE
1980: SET process_flag = 3
1981: WHERE Transaction_Id = l_mtl_xref_rec.Transaction_Id;
1982:
1983:

Line 2000: ,tbl_name => 'MTL_CROSS_REFERENCES_INTERFACE'

1996: ,req_id => fnd_global.conc_request_id
1997: ,trans_id => l_mtl_xref_rec.Transaction_Id
1998: ,error_text => l_msg.message_text
1999: ,p_column_name => null
2000: ,tbl_name => 'MTL_CROSS_REFERENCES_INTERFACE'
2001: ,msg_name => l_msg.message_name
2002: ,err_text => l_err_text -- error text out
2003: );
2004: END LOOP;

Line 2010: UPDATE MTL_CROSS_REFERENCES_INTERFACE

2006: Write_Debug('Transaction ' ||To_Char(l_mtl_xref_rec.Transaction_Id)|| ' has failed.');
2007: l_err_count := 1;
2008: ELSE
2009: Write_Debug('Transaction ' ||To_Char(l_mtl_xref_rec.Transaction_Id)|| ' has completed successfully.');
2010: UPDATE MTL_CROSS_REFERENCES_INTERFACE
2011: SET process_flag = 7
2012: WHERE Transaction_Id = l_mtl_xref_rec.Transaction_Id;
2013: END IF;
2014:

Line 2160: DELETE FROM MTL_CROSS_REFERENCES_INTERFACE

2156:
2157: BEGIN
2158:
2159: LOOP
2160: DELETE FROM MTL_CROSS_REFERENCES_INTERFACE
2161: WHERE process_flag = l_process_flag_7
2162: AND set_process_id=p_data_set_id
2163: AND rownum < l_rownum;
2164: