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.MTL_CCEOI_ACTION_PVT dependencies on STANDARD

Line 14: --parameters to comply with GSCC File.Sql.39 standard. Bug:4410902

10: --dbms_output.put_line(msg);
11: null;
12: end;
13: --Added NOCOPY hint to x_return_status,x_msg_count,x_msg_data OUT
14: --parameters to comply with GSCC File.Sql.39 standard. Bug:4410902
15: PROCEDURE Process_Error(
16: p_api_version IN NUMBER,
17: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
18: p_commit IN VARCHAR2 := FND_API.G_FALSE,

Line 33: -- Standard start of API savepoint

29: L_api_name CONSTANT VARCHAR2(30) := 'Process_Error';
30: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
31: BEGIN
32:
33: -- Standard start of API savepoint
34: SAVEPOINT Process_Error;
35: --
36: -- Standard Call to check for call compatibility
37: IF NOT FND_API.Compatible_API_Call(l_api_version

Line 36: -- Standard Call to check for call compatibility

32:
33: -- Standard start of API savepoint
34: SAVEPOINT Process_Error;
35: --
36: -- Standard Call to check for call compatibility
37: IF NOT FND_API.Compatible_API_Call(l_api_version
38: , p_api_version
39: , l_api_name
40: , G_PKG_NAME) THEN

Line 100: -- Standard check of p_commit

96: --
97: -- END of API body
98: --
99:
100: -- Standard check of p_commit
101: IF FND_API.to_Boolean(p_commit) THEN
102: COMMIT;
103: END IF;
104:

Line 147: --parameters to comply with GSCC File.Sql.39 standard. Bug:4410902

143:
144: --
145: -- Insert the given row into the interface table.
146: --Added NOCOPY hint to x_return_status,x_msg_count,x_msg_data OUT
147: --parameters to comply with GSCC File.Sql.39 standard. Bug:4410902
148: PROCEDURE Export_CountRequest(
149: p_api_version IN NUMBER ,
150: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
151: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

Line 203: -- Standard start of API savepoint

199: -- FOR this API PROCEDURE
200: L_api_version CONSTANT NUMBER := 0.9;
201: L_api_name CONSTANT VARCHAR2(30) := 'Export_CountRequest';
202: BEGIN
203: -- Standard start of API savepoint
204: SAVEPOINT Export_CountRequest_PVT;
205: --
206: -- Standard Call to check for call compatibility
207: IF NOT FND_API.Compatible_API_Call(l_api_version

Line 206: -- Standard Call to check for call compatibility

202: BEGIN
203: -- Standard start of API savepoint
204: SAVEPOINT Export_CountRequest_PVT;
205: --
206: -- Standard Call to check for call compatibility
207: IF NOT FND_API.Compatible_API_Call(l_api_version
208: , p_api_version
209: , l_api_name
210: , G_PKG_NAME) THEN

Line 248: -- Standard check of p_commit

244: x_msg_data := L_msg_data;
245: x_return_status := L_return_status;
246: --
247: -- END of API body
248: -- Standard check of p_commit
249: IF FND_API.to_Boolean(p_commit) THEN
250: COMMIT;
251: END IF;
252: -- Standard call to get message count and if count is 1, get message info

Line 252: -- Standard call to get message count and if count is 1, get message info

248: -- Standard check of p_commit
249: IF FND_API.to_Boolean(p_commit) THEN
250: COMMIT;
251: END IF;
252: -- Standard call to get message count and if count is 1, get message info
253: FND_MSG_PUB.Count_And_Get
254: (p_count => x_msg_count
255: , p_data => x_msg_data);
256: EXCEPTION

Line 293: --parameters to comply with GSCC File.Sql.39 standard. Bug:4410902

289:
290: --
291: -- Create unscheduled count requests
292: --Added NOCOPY hint to x_return_status,x_msg_count,x_msg_data OUT
293: --parameters to comply with GSCC File.Sql.39 standard. Bug:4410902
294: PROCEDURE Create_CountRequest(
295: p_api_version IN NUMBER ,
296: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
297: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

Line 364: -- Standard start of API savepoint

360: -- L_return_status VARCHAR2(1);
361: -- L_msg_count NUMBER;
362: -- L_msg_data VARCHAR2(240);
363:
364: -- Standard start of API savepoint
365: SAVEPOINT Create_CountRequest;
366: --
367: -- Standard Call to check for call compatibility
368: IF NOT FND_API.Compatible_API_Call(l_api_version

Line 367: -- Standard Call to check for call compatibility

363:
364: -- Standard start of API savepoint
365: SAVEPOINT Create_CountRequest;
366: --
367: -- Standard Call to check for call compatibility
368: IF NOT FND_API.Compatible_API_Call(l_api_version
369: , p_api_version
370: , l_api_name
371: , G_PKG_NAME) THEN

Line 540: -- Standard check of p_commit

536: END IF;
537:
538: --
539: -- END of API body
540: -- Standard check of p_commit
541: IF FND_API.to_Boolean(p_commit) THEN
542: COMMIT;
543: END IF;
544: -- Standard call to get message count and if count is 1, get message info

Line 544: -- Standard call to get message count and if count is 1, get message info

540: -- Standard check of p_commit
541: IF FND_API.to_Boolean(p_commit) THEN
542: COMMIT;
543: END IF;
544: -- Standard call to get message count and if count is 1, get message info
545: FND_MSG_PUB.Count_And_Get
546: (p_count => x_msg_count
547: , p_data => x_msg_data);
548:

Line 588: --parameters to comply with GSCC File.Sql.39 standard. Bug:4410902

584:
585: --
586: -- processed count request from the interface table
587: --Added NOCOPY hint to x_return_status,x_msg_count,x_msg_data OUT
588: --parameters to comply with GSCC File.Sql.39 standard. Bug:4410902
589: PROCEDURE Process_CountRequest
590: (
591: p_api_version IN NUMBER ,
592: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

Line 653: -- Standard start of API savepoint

649: -- Notes : Note text
650: -- END OF comments
651:
652: --MDEBUG( 'Process: CCEId '||to_char(MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_ENTRY_REC.CYCLE_COUNT_ENTRY_ID));
653: -- Standard start of API savepoint
654: SAVEPOINT Process_CountRequest;
655: --
656: -- Standard Call to check for call compatibility
657: IF NOT FND_API.Compatible_API_Call(l_api_version

Line 656: -- Standard Call to check for call compatibility

652: --MDEBUG( 'Process: CCEId '||to_char(MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_ENTRY_REC.CYCLE_COUNT_ENTRY_ID));
653: -- Standard start of API savepoint
654: SAVEPOINT Process_CountRequest;
655: --
656: -- Standard Call to check for call compatibility
657: IF NOT FND_API.Compatible_API_Call(l_api_version
658: , p_api_version
659: , l_api_name
660: , G_PKG_NAME) THEN

Line 884: -- Standard check of p_commit

880: END IF; -- validation's return status
881:
882: --
883: -- END of API body
884: -- Standard check of p_commit
885: IF FND_API.to_Boolean(p_commit) THEN
886: COMMIT;
887: END IF;
888: -- Standard call to get message count and if count is 1, get message info

Line 888: -- Standard call to get message count and if count is 1, get message info

884: -- Standard check of p_commit
885: IF FND_API.to_Boolean(p_commit) THEN
886: COMMIT;
887: END IF;
888: -- Standard call to get message count and if count is 1, get message info
889: FND_MSG_PUB.Count_And_Get
890: (p_count => x_msg_count
891: , p_data => x_msg_data);
892:

Line 935: --parameters to comply with GSCC File.Sql.39 standard. Bug:4410902

931: END Process_CountRequest;
932:
933: -- Validate the records in the interface table
934: --Added NOCOPY hint to x_return_status,x_msg_count,x_msg_data OUT
935: --parameters to comply with GSCC File.Sql.39 standard. Bug:4410902
936: PROCEDURE Validate_CountRequest(
937: p_api_version IN NUMBER ,
938: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
939: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

Line 1029: -- Standard start of API savepoint

1025: AND msi.inventory_item_id = cp_inventory_item_id;
1026: -- END INVCONV
1027:
1028: BEGIN
1029: -- Standard start of API savepoint
1030: SAVEPOINT Validate_CountRequest;
1031: --
1032: -- Standard Call to check for call compatibility
1033: IF NOT FND_API.Compatible_API_Call(l_api_version

Line 1032: -- Standard Call to check for call compatibility

1028: BEGIN
1029: -- Standard start of API savepoint
1030: SAVEPOINT Validate_CountRequest;
1031: --
1032: -- Standard Call to check for call compatibility
1033: IF NOT FND_API.Compatible_API_Call(l_api_version
1034: , p_api_version
1035: , l_api_name
1036: , G_PKG_NAME) THEN

Line 1573: -- Standard check of p_commit

1569: -- the flag means errors, processed with errors, not valid
1570: END IF;
1571: --
1572: -- END of API body
1573: -- Standard check of p_commit
1574: IF FND_API.to_Boolean(p_commit) THEN
1575: COMMIT;
1576: END IF;
1577: -- Standard call to get message count and if count is 1, get message info

Line 1577: -- Standard call to get message count and if count is 1, get message info

1573: -- Standard check of p_commit
1574: IF FND_API.to_Boolean(p_commit) THEN
1575: COMMIT;
1576: END IF;
1577: -- Standard call to get message count and if count is 1, get message info
1578: FND_MSG_PUB.Count_And_Get
1579: (p_count => x_msg_count
1580: , p_data => x_msg_data);
1581: EXCEPTION

Line 1623: --parameters to comply with GSCC File.Sql.39 standard. Bug:4410902

1619: END;
1620: --
1621: -- validates and simulates records from interface table
1622: --Added NOCOPY hint to x_return_status,x_msg_count,x_msg_data OUT
1623: --parameters to comply with GSCC File.Sql.39 standard. Bug:4410902
1624: Procedure ValSim_CountRequest(
1625: p_api_version IN NUMBER ,
1626: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1627: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

Line 1676: -- Standard start of API savepoint

1672: --
1673: L_api_version CONSTANT NUMBER := 0.9;
1674: L_api_name CONSTANT VARCHAR2(30) := 'ValSim_CountRequest';
1675: BEGIN
1676: -- Standard start of API savepoint
1677: SAVEPOINT ValSim_CountRequest;
1678: --
1679: -- Standard Call to check for call compatibility
1680: IF NOT FND_API.Compatible_API_Call(l_api_version

Line 1679: -- Standard Call to check for call compatibility

1675: BEGIN
1676: -- Standard start of API savepoint
1677: SAVEPOINT ValSim_CountRequest;
1678: --
1679: -- Standard Call to check for call compatibility
1680: IF NOT FND_API.Compatible_API_Call(l_api_version
1681: , p_api_version
1682: , l_api_name
1683: , G_PKG_NAME) THEN

Line 1747: -- Standard check of p_commit

1743: --
1744: x_return_status := L_return_status;
1745: --
1746: -- END of API body
1747: -- Standard check of p_commit
1748: IF FND_API.to_Boolean(p_commit) THEN
1749: COMMIT;
1750: END IF;
1751: -- Standard call to get message count and if count is 1, get message info

Line 1751: -- Standard call to get message count and if count is 1, get message info

1747: -- Standard check of p_commit
1748: IF FND_API.to_Boolean(p_commit) THEN
1749: COMMIT;
1750: END IF;
1751: -- Standard call to get message count and if count is 1, get message info
1752: FND_MSG_PUB.Count_And_Get
1753: (p_count => x_msg_count
1754: , p_data => x_msg_data);
1755: EXCEPTION

Line 1791: --parameters to comply with GSCC File.Sql.39 standard. Bug:4410902

1787: END;
1788: --
1789: -- Updated or inserted the interface record table
1790: --Added NOCOPY hint to x_return_status,x_msg_count,x_msg_data OUT
1791: --parameters to comply with GSCC File.Sql.39 standard. Bug:4410902
1792: PROCEDURE Update_Insert_CountRequest(
1793: p_api_version IN NUMBER ,
1794: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1795: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

Line 1853: -- Standard start of API savepoint

1849: --
1850: L_api_version CONSTANT NUMBER := 0.9;
1851: L_api_name CONSTANT VARCHAR2(30) := 'UpdateInsert_CountRequest';
1852: BEGIN
1853: -- Standard start of API savepoint
1854: SAVEPOINT UpdateInsert_CountRequest;
1855: --
1856: -- Standard Call to check for call compatibility
1857: IF NOT FND_API.Compatible_API_Call(l_api_version

Line 1856: -- Standard Call to check for call compatibility

1852: BEGIN
1853: -- Standard start of API savepoint
1854: SAVEPOINT UpdateInsert_CountRequest;
1855: --
1856: -- Standard Call to check for call compatibility
1857: IF NOT FND_API.Compatible_API_Call(l_api_version
1858: , p_api_version
1859: , l_api_name
1860: , G_PKG_NAME) THEN

Line 1927: -- Standard check of p_commit

1923: --
1924: x_return_status := L_return_status;
1925: --
1926: -- END of API body
1927: -- Standard check of p_commit
1928: IF FND_API.to_Boolean(p_commit) THEN
1929: COMMIT;
1930: END IF;
1931: -- Standard call to get message count and if count is 1, get message info

Line 1931: -- Standard call to get message count and if count is 1, get message info

1927: -- Standard check of p_commit
1928: IF FND_API.to_Boolean(p_commit) THEN
1929: COMMIT;
1930: END IF;
1931: -- Standard call to get message count and if count is 1, get message info
1932: FND_MSG_PUB.Count_And_Get
1933: (p_count => x_msg_count
1934: , p_data => x_msg_data);
1935: EXCEPTION WHEN FND_API.G_EXC_ERROR THEN