eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CLN_SYNC_ITEM_PKG dependencies on CLN_CST_DTLS_TEMP

Line 1708: DELETE FROM CLN_CST_DTLS_TEMP

1704: IF (l_Debug_Level <= 1) THEN
1705: cln_debug_pub.Add('Deleting the rows from the temp table for which the item import failed', 1);
1706: END IF;
1707:
1708: DELETE FROM CLN_CST_DTLS_TEMP
1709: WHERE item_number = l_item_number
1710: AND group_id = l_cst_group_id;
1711:
1712: IF (l_Debug_Level <= 1) THEN

Line 1720: ||' FROM CLN_CST_DTLS_TEMP'

1716: END LOOP;
1717: CLOSE c_cursor;
1718:
1719: sql_statement_1 := ' SELECT DISTINCT ITEM_NUMBER'
1720: ||' FROM CLN_CST_DTLS_TEMP'
1721: ||' WHERE group_id = '|| l_cst_group_id;
1722:
1723:
1724: IF (l_Debug_Level <= 1) THEN

Line 1763: UPDATE CLN_CST_DTLS_TEMP

1759: cln_debug_pub.Add('ERROR : Could not find the record in the mtl_system_items_b table for the item number -'||l_item_number, 1);
1760: RAISE FND_API.G_EXC_ERROR;
1761: END;
1762:
1763: UPDATE CLN_CST_DTLS_TEMP
1764: SET inventory_item_id = l_inventory_item_id,
1765: resource_id = l_resource_id
1766: -- cost_type = l_cost_type
1767: WHERE item_number = l_item_number

Line 1809: CLN_CST_DTLS_TEMP

1805: GROUP_ID,
1806: ITEM_NUMBER,
1807: ITEM_COST
1808: FROM
1809: CLN_CST_DTLS_TEMP
1810: WHERE group_id = l_cst_group_id
1811: );
1812:
1813: IF (l_Debug_Level <= 1) THEN

Line 2613: cln_debug_pub.Add('Deleting the rows from the CLN_CST_DTLS_TEMP table...', 1);

2609: END IF;
2610: ELSE
2611:
2612: IF (l_Debug_Level <= 1) THEN
2613: cln_debug_pub.Add('Deleting the rows from the CLN_CST_DTLS_TEMP table...', 1);
2614: END IF;
2615:
2616: DELETE FROM CLN_CST_DTLS_TEMP
2617: WHERE group_id = l_cst_group_id;

Line 2616: DELETE FROM CLN_CST_DTLS_TEMP

2612: IF (l_Debug_Level <= 1) THEN
2613: cln_debug_pub.Add('Deleting the rows from the CLN_CST_DTLS_TEMP table...', 1);
2614: END IF;
2615:
2616: DELETE FROM CLN_CST_DTLS_TEMP
2617: WHERE group_id = l_cst_group_id;
2618:
2619: IF (l_Debug_Level <= 1) THEN
2620: cln_debug_pub.Add('Rows from the CLN_CST_DTLS_TEMP table deleted...', 1);

Line 2620: cln_debug_pub.Add('Rows from the CLN_CST_DTLS_TEMP table deleted...', 1);

2616: DELETE FROM CLN_CST_DTLS_TEMP
2617: WHERE group_id = l_cst_group_id;
2618:
2619: IF (l_Debug_Level <= 1) THEN
2620: cln_debug_pub.Add('Rows from the CLN_CST_DTLS_TEMP table deleted...', 1);
2621: END IF;
2622:
2623: END IF;
2624: