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

Line 53: -- Standard Start of API savepoint

49: l_ha_comp_id NUMBER;
50: l_ca_filter_id NUMBER;
51: l_ha_filter_id NUMBER;
52: BEGIN
53: -- Standard Start of API savepoint
54: SAVEPOINT INSERT_HOST_APP;
55:
56: -- Standard call to check for call compatibility.
57: IF NOT FND_API.Compatible_API_Call (

Line 56: -- Standard call to check for call compatibility.

52: BEGIN
53: -- Standard Start of API savepoint
54: SAVEPOINT INSERT_HOST_APP;
55:
56: -- Standard call to check for call compatibility.
57: IF NOT FND_API.Compatible_API_Call (
58: l_api_version,
59: p_api_version,
60: l_api_name,

Line 183: -- Standard check of p_commit.

179:
180: -----------------------
181: -- end of real logic --
182:
183: -- Standard check of p_commit.
184: IF (FND_API.To_Boolean(p_commit)) THEN
185: COMMIT WORK;
186: END IF;
187:

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

184: IF (FND_API.To_Boolean(p_commit)) THEN
185: COMMIT WORK;
186: END IF;
187:
188: -- Standard call to get message count and if count is 1, get message info.
189: FND_MSG_PUB.Count_And_Get(
190: p_count => x_msg_count,
191: p_data => x_msg_data );
192:

Line 246: -- Standard Start of API savepoint

242: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_HOST_APP';
243: l_api_version NUMBER := p_api_version;
244:
245: BEGIN
246: -- Standard Start of API savepoint
247: SAVEPOINT UPDATE_HOST_APP;
248:
249: -- Standard call to check for call compatibility.
250: IF NOT FND_API.Compatible_API_Call (

Line 249: -- Standard call to check for call compatibility.

245: BEGIN
246: -- Standard Start of API savepoint
247: SAVEPOINT UPDATE_HOST_APP;
248:
249: -- Standard call to check for call compatibility.
250: IF NOT FND_API.Compatible_API_Call (
251: l_api_version,
252: p_api_version,
253: l_api_name,

Line 284: -- Standard check of p_commit.

280:
281: -----------------------
282: -- end of real logic --
283:
284: -- Standard check of p_commit.
285: IF (FND_API.To_Boolean(p_commit)) THEN
286: COMMIT WORK;
287: END IF;
288:

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

285: IF (FND_API.To_Boolean(p_commit)) THEN
286: COMMIT WORK;
287: END IF;
288:
289: -- Standard call to get message count and if count is 1, get message info.
290: FND_MSG_PUB.Count_And_Get(
291: p_count => x_msg_count,
292: p_data => x_msg_data );
293:

Line 355: -- Standard call to check for call compatibility.

351: WHERE host_app_id = p_host_app_id;
352:
353: BEGIN
354:
355: -- Standard call to check for call compatibility.
356: IF NOT FND_API.Compatible_API_Call (
357: l_api_version,
358: p_api_version,
359: l_api_name,

Line 423: -- Standard Start of API savepoint

419: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_HOST_APP';
420: l_api_version CONSTANT NUMBER := p_api_version;
421:
422: BEGIN
423: -- Standard Start of API savepoint
424: SAVEPOINT DELETE_HOST_APP;
425:
426: -- Standard call to check for call compatibility.
427: IF NOT FND_API.Compatible_API_Call (

Line 426: -- Standard call to check for call compatibility.

422: BEGIN
423: -- Standard Start of API savepoint
424: SAVEPOINT DELETE_HOST_APP;
425:
426: -- Standard call to check for call compatibility.
427: IF NOT FND_API.Compatible_API_Call (
428: l_api_version,
429: p_api_version,
430: l_api_name,

Line 471: -- Standard check of p_commit.

467:
468: -----------------------
469: -- end of real logic --
470:
471: -- Standard check of p_commit.
472: IF (FND_API.To_Boolean(p_commit)) THEN
473: COMMIT WORK;
474: END IF;
475:

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

472: IF (FND_API.To_Boolean(p_commit)) THEN
473: COMMIT WORK;
474: END IF;
475:
476: -- Standard call to get message count and if count is 1, get message info.
477: FND_MSG_PUB.Count_And_Get(
478: p_count => x_msg_count,
479: p_data => x_msg_data );
480:

Line 534: -- Standard Start of API savepoint

530: FROM jtf_prefab_host_apps
531: WHERE wsh_po_id = p_wsh_po_id;
532: l_host_app_id NUMBER;
533: BEGIN
534: -- Standard Start of API savepoint
535: SAVEPOINT DELETE_HOST_APPS_FOR_HOST;
536:
537: -- Standard call to check for call compatibility.
538: IF NOT FND_API.Compatible_API_Call (

Line 537: -- Standard call to check for call compatibility.

533: BEGIN
534: -- Standard Start of API savepoint
535: SAVEPOINT DELETE_HOST_APPS_FOR_HOST;
536:
537: -- Standard call to check for call compatibility.
538: IF NOT FND_API.Compatible_API_Call (
539: l_api_version,
540: p_api_version,
541: l_api_name,

Line 578: -- Standard check of p_commit.

574:
575: -----------------------
576: -- end of real logic --
577:
578: -- Standard check of p_commit.
579: IF (FND_API.To_Boolean(p_commit)) THEN
580: COMMIT WORK;
581: END IF;
582:

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

579: IF (FND_API.To_Boolean(p_commit)) THEN
580: COMMIT WORK;
581: END IF;
582:
583: -- Standard call to get message count and if count is 1, get message info.
584: FND_MSG_PUB.Count_And_Get(
585: p_count => x_msg_count,
586: p_data => x_msg_data );
587:

Line 663: -- Standard Start of API savepoint

659: WHERE application_id = -1;
660: l_host_app_id NUMBER;
661: l_ha_comp_id NUMBER;
662: BEGIN
663: -- Standard Start of API savepoint
664: SAVEPOINT INSERT_CACHE_COMP;
665:
666: -- Standard call to check for call compatibility.
667: IF NOT FND_API.Compatible_API_Call (

Line 666: -- Standard call to check for call compatibility.

662: BEGIN
663: -- Standard Start of API savepoint
664: SAVEPOINT INSERT_CACHE_COMP;
665:
666: -- Standard call to check for call compatibility.
667: IF NOT FND_API.Compatible_API_Call (
668: l_api_version,
669: p_api_version,
670: l_api_name,

Line 812: -- Standard check of p_commit.

808:
809: -----------------------
810: -- end of real logic --
811:
812: -- Standard check of p_commit.
813: IF (FND_API.To_Boolean(p_commit)) THEN
814: COMMIT WORK;
815: END IF;
816:

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

813: IF (FND_API.To_Boolean(p_commit)) THEN
814: COMMIT WORK;
815: END IF;
816:
817: -- Standard call to get message count and if count is 1, get message info.
818: FND_MSG_PUB.Count_And_Get(
819: p_count => x_msg_count,
820: p_data => x_msg_data );
821:

Line 884: -- Standard Start of API savepoint

880: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_CACHE_COMP';
881: l_api_version NUMBER := p_api_version;
882:
883: BEGIN
884: -- Standard Start of API savepoint
885: SAVEPOINT UPDATE_CACHE_COMP;
886:
887: -- Standard call to check for call compatibility.
888: IF NOT FND_API.Compatible_API_Call (

Line 887: -- Standard call to check for call compatibility.

883: BEGIN
884: -- Standard Start of API savepoint
885: SAVEPOINT UPDATE_CACHE_COMP;
886:
887: -- Standard call to check for call compatibility.
888: IF NOT FND_API.Compatible_API_Call (
889: l_api_version,
890: p_api_version,
891: l_api_name,

Line 950: -- Standard check of p_commit.

946:
947: -----------------------
948: -- end of real logic --
949:
950: -- Standard check of p_commit.
951: IF (FND_API.To_Boolean(p_commit)) THEN
952: COMMIT WORK;
953: END IF;
954:

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

951: IF (FND_API.To_Boolean(p_commit)) THEN
952: COMMIT WORK;
953: END IF;
954:
955: -- Standard call to get message count and if count is 1, get message info.
956: FND_MSG_PUB.Count_And_Get(
957: p_count => x_msg_count,
958: p_data => x_msg_data );
959:

Line 1009: -- Standard Start of API savepoint

1005: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_CACHE_COMP_1';
1006: l_api_version NUMBER := p_api_version;
1007:
1008: BEGIN
1009: -- Standard Start of API savepoint
1010: SAVEPOINT UPDATE_CACHE_COMP_1;
1011:
1012: -- Standard call to check for call compatibility.
1013: IF NOT FND_API.Compatible_API_Call (

Line 1012: -- Standard call to check for call compatibility.

1008: BEGIN
1009: -- Standard Start of API savepoint
1010: SAVEPOINT UPDATE_CACHE_COMP_1;
1011:
1012: -- Standard call to check for call compatibility.
1013: IF NOT FND_API.Compatible_API_Call (
1014: l_api_version,
1015: p_api_version,
1016: l_api_name,

Line 1040: -- Standard check of p_commit.

1036:
1037: -----------------------
1038: -- end of real logic --
1039:
1040: -- Standard check of p_commit.
1041: IF (FND_API.To_Boolean(p_commit)) THEN
1042: COMMIT WORK;
1043: END IF;
1044:

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

1041: IF (FND_API.To_Boolean(p_commit)) THEN
1042: COMMIT WORK;
1043: END IF;
1044:
1045: -- Standard call to get message count and if count is 1, get message info.
1046: FND_MSG_PUB.Count_And_Get(
1047: p_count => x_msg_count,
1048: p_data => x_msg_data );
1049:

Line 1098: -- Standard Start of API savepoint

1094: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_CACHE_COMP';
1095: l_api_version CONSTANT NUMBER := p_api_version;
1096:
1097: BEGIN
1098: -- Standard Start of API savepoint
1099: SAVEPOINT DELETE_CACHE_COMP;
1100:
1101: -- Standard call to check for call compatibility.
1102: IF NOT FND_API.Compatible_API_Call (

Line 1101: -- Standard call to check for call compatibility.

1097: BEGIN
1098: -- Standard Start of API savepoint
1099: SAVEPOINT DELETE_CACHE_COMP;
1100:
1101: -- Standard call to check for call compatibility.
1102: IF NOT FND_API.Compatible_API_Call (
1103: l_api_version,
1104: p_api_version,
1105: l_api_name,

Line 1142: -- Standard check of p_commit.

1138:
1139: -----------------------
1140: -- end of real logic --
1141:
1142: -- Standard check of p_commit.
1143: IF (FND_API.To_Boolean(p_commit)) THEN
1144: COMMIT WORK;
1145: END IF;
1146:

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

1143: IF (FND_API.To_Boolean(p_commit)) THEN
1144: COMMIT WORK;
1145: END IF;
1146:
1147: -- Standard call to get message count and if count is 1, get message info.
1148: FND_MSG_PUB.Count_And_Get(
1149: p_count => x_msg_count,
1150: p_data => x_msg_data );
1151:

Line 1208: -- Standard Start of API savepoint

1204:
1205: CURSOR sequence_cursor IS
1206: SELECT jtf_prefab_ha_comps_s.NEXTVAL from dual;
1207: BEGIN
1208: -- Standard Start of API savepoint
1209: SAVEPOINT INSERT_HA_COMP;
1210:
1211: -- Standard call to check for call compatibility.
1212: IF NOT FND_API.Compatible_API_Call (

Line 1211: -- Standard call to check for call compatibility.

1207: BEGIN
1208: -- Standard Start of API savepoint
1209: SAVEPOINT INSERT_HA_COMP;
1210:
1211: -- Standard call to check for call compatibility.
1212: IF NOT FND_API.Compatible_API_Call (
1213: l_api_version,
1214: p_api_version,
1215: l_api_name,

Line 1267: -- Standard check of p_commit.

1263:
1264: -----------------------
1265: -- end of real logic --
1266:
1267: -- Standard check of p_commit.
1268: IF (FND_API.To_Boolean(p_commit)) THEN
1269: COMMIT WORK;
1270: END IF;
1271:

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

1268: IF (FND_API.To_Boolean(p_commit)) THEN
1269: COMMIT WORK;
1270: END IF;
1271:
1272: -- Standard call to get message count and if count is 1, get message info.
1273: FND_MSG_PUB.Count_And_Get(
1274: p_count => x_msg_count,
1275: p_data => x_msg_data );
1276:

Line 1329: -- Standard Start of API savepoint

1325: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_HA_COMP';
1326: l_api_version NUMBER := p_api_version;
1327:
1328: BEGIN
1329: -- Standard Start of API savepoint
1330: SAVEPOINT UPDATE_HA_COMP;
1331:
1332: -- Standard call to check for call compatibility.
1333: IF NOT FND_API.Compatible_API_Call (

Line 1332: -- Standard call to check for call compatibility.

1328: BEGIN
1329: -- Standard Start of API savepoint
1330: SAVEPOINT UPDATE_HA_COMP;
1331:
1332: -- Standard call to check for call compatibility.
1333: IF NOT FND_API.Compatible_API_Call (
1334: l_api_version,
1335: p_api_version,
1336: l_api_name,

Line 1366: -- Standard check of p_commit.

1362:
1363: -----------------------
1364: -- end of real logic --
1365:
1366: -- Standard check of p_commit.
1367: IF (FND_API.To_Boolean(p_commit)) THEN
1368: COMMIT WORK;
1369: END IF;
1370:

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

1367: IF (FND_API.To_Boolean(p_commit)) THEN
1368: COMMIT WORK;
1369: END IF;
1370:
1371: -- Standard call to get message count and if count is 1, get message info.
1372: FND_MSG_PUB.Count_And_Get(
1373: p_count => x_msg_count,
1374: p_data => x_msg_data );
1375:

Line 1424: -- Standard Start of API savepoint

1420: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_HA_COMPS_FOR_HOST_APP';
1421: l_api_version CONSTANT NUMBER := p_api_version;
1422:
1423: BEGIN
1424: -- Standard Start of API savepoint
1425: SAVEPOINT DELETE_HA_COMPS_FOR_HOST_APP;
1426:
1427: -- Standard call to check for call compatibility.
1428: IF NOT FND_API.Compatible_API_Call (

Line 1427: -- Standard call to check for call compatibility.

1423: BEGIN
1424: -- Standard Start of API savepoint
1425: SAVEPOINT DELETE_HA_COMPS_FOR_HOST_APP;
1426:
1427: -- Standard call to check for call compatibility.
1428: IF NOT FND_API.Compatible_API_Call (
1429: l_api_version,
1430: p_api_version,
1431: l_api_name,

Line 1454: -- Standard check of p_commit.

1450:
1451: -----------------------
1452: -- end of real logic --
1453:
1454: -- Standard check of p_commit.
1455: IF (FND_API.To_Boolean(p_commit)) THEN
1456: COMMIT WORK;
1457: END IF;
1458:

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

1455: IF (FND_API.To_Boolean(p_commit)) THEN
1456: COMMIT WORK;
1457: END IF;
1458:
1459: -- Standard call to get message count and if count is 1, get message info.
1460: FND_MSG_PUB.Count_And_Get(
1461: p_count => x_msg_count,
1462: p_data => x_msg_data );
1463:

Line 1512: -- Standard Start of API savepoint

1508: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_HA_COMPS_FOR_CACHE_COMP';
1509: l_api_version CONSTANT NUMBER := p_api_version;
1510:
1511: BEGIN
1512: -- Standard Start of API savepoint
1513: SAVEPOINT DELETE_HA_COMPS_FOR_CACHE_COMP;
1514:
1515: -- Standard call to check for call compatibility.
1516: IF NOT FND_API.Compatible_API_Call (

Line 1515: -- Standard call to check for call compatibility.

1511: BEGIN
1512: -- Standard Start of API savepoint
1513: SAVEPOINT DELETE_HA_COMPS_FOR_CACHE_COMP;
1514:
1515: -- Standard call to check for call compatibility.
1516: IF NOT FND_API.Compatible_API_Call (
1517: l_api_version,
1518: p_api_version,
1519: l_api_name,

Line 1542: -- Standard check of p_commit.

1538:
1539: -----------------------
1540: -- end of real logic --
1541:
1542: -- Standard check of p_commit.
1543: IF (FND_API.To_Boolean(p_commit)) THEN
1544: COMMIT WORK;
1545: END IF;
1546:

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

1543: IF (FND_API.To_Boolean(p_commit)) THEN
1544: COMMIT WORK;
1545: END IF;
1546:
1547: -- Standard call to get message count and if count is 1, get message info.
1548: FND_MSG_PUB.Count_And_Get(
1549: p_count => x_msg_count,
1550: p_data => x_msg_data );
1551:

Line 1616: -- Standard Start of API savepoint

1612:
1613: CURSOR sequence_cursor IS
1614: SELECT jtf_prefab_cache_stats_s.NEXTVAL from dual;
1615: BEGIN
1616: -- Standard Start of API savepoint
1617: SAVEPOINT INSERT_CACHE_STAT;
1618:
1619: -- Standard call to check for call compatibility.
1620: IF NOT FND_API.Compatible_API_Call (

Line 1619: -- Standard call to check for call compatibility.

1615: BEGIN
1616: -- Standard Start of API savepoint
1617: SAVEPOINT INSERT_CACHE_STAT;
1618:
1619: -- Standard call to check for call compatibility.
1620: IF NOT FND_API.Compatible_API_Call (
1621: l_api_version,
1622: p_api_version,
1623: l_api_name,

Line 1690: -- Standard check of p_commit.

1686:
1687: -----------------------
1688: -- end of real logic --
1689:
1690: -- Standard check of p_commit.
1691: IF (FND_API.To_Boolean(p_commit)) THEN
1692: COMMIT WORK;
1693: END IF;
1694:

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

1691: IF (FND_API.To_Boolean(p_commit)) THEN
1692: COMMIT WORK;
1693: END IF;
1694:
1695: -- Standard call to get message count and if count is 1, get message info.
1696: FND_MSG_PUB.Count_And_Get(
1697: p_count => x_msg_count,
1698: p_data => x_msg_data );
1699:

Line 1761: -- Standard Start of API savepoint

1757: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_CACHE_STAT';
1758: l_api_version NUMBER := p_api_version;
1759:
1760: BEGIN
1761: -- Standard Start of API savepoint
1762: SAVEPOINT UPDATE_CACHE_STAT;
1763:
1764: -- Standard call to check for call compatibility.
1765: IF NOT FND_API.Compatible_API_Call (

Line 1764: -- Standard call to check for call compatibility.

1760: BEGIN
1761: -- Standard Start of API savepoint
1762: SAVEPOINT UPDATE_CACHE_STAT;
1763:
1764: -- Standard call to check for call compatibility.
1765: IF NOT FND_API.Compatible_API_Call (
1766: l_api_version,
1767: p_api_version,
1768: l_api_name,

Line 1810: -- Standard check of p_commit.

1806:
1807: -----------------------
1808: -- end of real logic --
1809:
1810: -- Standard check of p_commit.
1811: IF (FND_API.To_Boolean(p_commit)) THEN
1812: COMMIT WORK;
1813: END IF;
1814:

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

1811: IF (FND_API.To_Boolean(p_commit)) THEN
1812: COMMIT WORK;
1813: END IF;
1814:
1815: -- Standard call to get message count and if count is 1, get message info.
1816: FND_MSG_PUB.Count_And_Get(
1817: p_count => x_msg_count,
1818: p_data => x_msg_data );
1819:

Line 1864: -- Standard Start of API savepoint

1860: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_CACHE_STAT';
1861: l_api_version CONSTANT NUMBER := p_api_version;
1862:
1863: BEGIN
1864: -- Standard Start of API savepoint
1865: SAVEPOINT DELETE_CACHE_STAT;
1866:
1867: -- Standard call to check for call compatibility.
1868: IF NOT FND_API.Compatible_API_Call (

Line 1867: -- Standard call to check for call compatibility.

1863: BEGIN
1864: -- Standard Start of API savepoint
1865: SAVEPOINT DELETE_CACHE_STAT;
1866:
1867: -- Standard call to check for call compatibility.
1868: IF NOT FND_API.Compatible_API_Call (
1869: l_api_version,
1870: p_api_version,
1871: l_api_name,

Line 1896: -- Standard check of p_commit.

1892:
1893: -----------------------
1894: -- end of real logic --
1895:
1896: -- Standard check of p_commit.
1897: IF (FND_API.To_Boolean(p_commit)) THEN
1898: COMMIT WORK;
1899: END IF;
1900:

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

1897: IF (FND_API.To_Boolean(p_commit)) THEN
1898: COMMIT WORK;
1899: END IF;
1900:
1901: -- Standard call to get message count and if count is 1, get message info.
1902: FND_MSG_PUB.Count_And_Get(
1903: p_count => x_msg_count,
1904: p_data => x_msg_data );
1905:

Line 1953: -- Standard Start of API savepoint

1949: l_api_name CONSTANT VARCHAR2(30) := 'RESET_CACHE_STAT';
1950: l_api_version CONSTANT NUMBER := p_api_version;
1951:
1952: BEGIN
1953: -- Standard Start of API savepoint
1954: SAVEPOINT RESET_CACHE_STAT;
1955:
1956: -- Standard call to check for call compatibility.
1957: IF NOT FND_API.Compatible_API_Call (

Line 1956: -- Standard call to check for call compatibility.

1952: BEGIN
1953: -- Standard Start of API savepoint
1954: SAVEPOINT RESET_CACHE_STAT;
1955:
1956: -- Standard call to check for call compatibility.
1957: IF NOT FND_API.Compatible_API_Call (
1958: l_api_version,
1959: p_api_version,
1960: l_api_name,

Line 1992: -- Standard check of p_commit.

1988:
1989: -----------------------
1990: -- end of real logic --
1991:
1992: -- Standard check of p_commit.
1993: IF (FND_API.To_Boolean(p_commit)) THEN
1994: COMMIT WORK;
1995: END IF;
1996:

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

1993: IF (FND_API.To_Boolean(p_commit)) THEN
1994: COMMIT WORK;
1995: END IF;
1996:
1997: -- Standard call to get message count and if count is 1, get message info.
1998: FND_MSG_PUB.Count_And_Get(
1999: p_count => x_msg_count,
2000: p_data => x_msg_data );
2001:

Line 2064: -- Standard Start of API savepoint

2060: WHERE application_id = p_application_id;
2061: l_host_app_id NUMBER;
2062: l_ha_filter_id NUMBER;
2063: BEGIN
2064: -- Standard Start of API savepoint
2065: SAVEPOINT INSERT_CA_FILTER;
2066:
2067: -- Standard call to check for call compatibility.
2068: IF NOT FND_API.Compatible_API_Call (

Line 2067: -- Standard call to check for call compatibility.

2063: BEGIN
2064: -- Standard Start of API savepoint
2065: SAVEPOINT INSERT_CA_FILTER;
2066:
2067: -- Standard call to check for call compatibility.
2068: IF NOT FND_API.Compatible_API_Call (
2069: l_api_version,
2070: p_api_version,
2071: l_api_name,

Line 2131: -- Standard check of p_commit.

2127:
2128: -----------------------
2129: -- end of real logic --
2130:
2131: -- Standard check of p_commit.
2132: IF (FND_API.To_Boolean(p_commit)) THEN
2133: COMMIT WORK;
2134: END IF;
2135:

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

2132: IF (FND_API.To_Boolean(p_commit)) THEN
2133: COMMIT WORK;
2134: END IF;
2135:
2136: -- Standard call to get message count and if count is 1, get message info.
2137: FND_MSG_PUB.Count_And_Get(
2138: p_count => x_msg_count,
2139: p_data => x_msg_data );
2140:

Line 2193: -- Standard Start of API savepoint

2189: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_CA_FILTER';
2190: l_api_version NUMBER := p_api_version;
2191:
2192: BEGIN
2193: -- Standard Start of API savepoint
2194: SAVEPOINT UPDATE_CA_FILTER;
2195:
2196: -- Standard call to check for call compatibility.
2197: IF NOT FND_API.Compatible_API_Call (

Line 2196: -- Standard call to check for call compatibility.

2192: BEGIN
2193: -- Standard Start of API savepoint
2194: SAVEPOINT UPDATE_CA_FILTER;
2195:
2196: -- Standard call to check for call compatibility.
2197: IF NOT FND_API.Compatible_API_Call (
2198: l_api_version,
2199: p_api_version,
2200: l_api_name,

Line 2230: -- Standard check of p_commit.

2226:
2227: -----------------------
2228: -- end of real logic --
2229:
2230: -- Standard check of p_commit.
2231: IF (FND_API.To_Boolean(p_commit)) THEN
2232: COMMIT WORK;
2233: END IF;
2234:

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

2231: IF (FND_API.To_Boolean(p_commit)) THEN
2232: COMMIT WORK;
2233: END IF;
2234:
2235: -- Standard call to get message count and if count is 1, get message info.
2236: FND_MSG_PUB.Count_And_Get(
2237: p_count => x_msg_count,
2238: p_data => x_msg_data );
2239:

Line 2288: -- Standard Start of API savepoint

2284: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_CA_FILTER';
2285: l_api_version CONSTANT NUMBER := p_api_version;
2286:
2287: BEGIN
2288: -- Standard Start of API savepoint
2289: SAVEPOINT DELETE_CA_FILTER;
2290:
2291: -- Standard call to check for call compatibility.
2292: IF NOT FND_API.Compatible_API_Call (

Line 2291: -- Standard call to check for call compatibility.

2287: BEGIN
2288: -- Standard Start of API savepoint
2289: SAVEPOINT DELETE_CA_FILTER;
2290:
2291: -- Standard call to check for call compatibility.
2292: IF NOT FND_API.Compatible_API_Call (
2293: l_api_version,
2294: p_api_version,
2295: l_api_name,

Line 2342: -- Standard check of p_commit.

2338:
2339: -----------------------
2340: -- end of real logic --
2341:
2342: -- Standard check of p_commit.
2343: IF (FND_API.To_Boolean(p_commit)) THEN
2344: COMMIT WORK;
2345: END IF;
2346:

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

2343: IF (FND_API.To_Boolean(p_commit)) THEN
2344: COMMIT WORK;
2345: END IF;
2346:
2347: -- Standard call to get message count and if count is 1, get message info.
2348: FND_MSG_PUB.Count_And_Get(
2349: p_count => x_msg_count,
2350: p_data => x_msg_data );
2351:

Line 2406: -- Standard Start of API savepoint

2402:
2403: CURSOR sequence_cursor IS
2404: SELECT jtf_prefab_ha_filters_s.NEXTVAL from dual;
2405: BEGIN
2406: -- Standard Start of API savepoint
2407: SAVEPOINT INSERT_HA_FILTER;
2408:
2409: -- Standard call to check for call compatibility.
2410: IF NOT FND_API.Compatible_API_Call (

Line 2409: -- Standard call to check for call compatibility.

2405: BEGIN
2406: -- Standard Start of API savepoint
2407: SAVEPOINT INSERT_HA_FILTER;
2408:
2409: -- Standard call to check for call compatibility.
2410: IF NOT FND_API.Compatible_API_Call (
2411: l_api_version,
2412: p_api_version,
2413: l_api_name,

Line 2461: -- Standard check of p_commit.

2457:
2458: -----------------------
2459: -- end of real logic --
2460:
2461: -- Standard check of p_commit.
2462: IF (FND_API.To_Boolean(p_commit)) THEN
2463: COMMIT WORK;
2464: END IF;
2465:

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

2462: IF (FND_API.To_Boolean(p_commit)) THEN
2463: COMMIT WORK;
2464: END IF;
2465:
2466: -- Standard call to get message count and if count is 1, get message info.
2467: FND_MSG_PUB.Count_And_Get(
2468: p_count => x_msg_count,
2469: p_data => x_msg_data );
2470:

Line 2521: -- Standard Start of API savepoint

2517: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_HA_FILTER';
2518: l_api_version NUMBER := p_api_version;
2519:
2520: BEGIN
2521: -- Standard Start of API savepoint
2522: SAVEPOINT UPDATE_HA_FILTER;
2523:
2524: -- Standard call to check for call compatibility.
2525: IF NOT FND_API.Compatible_API_Call (

Line 2524: -- Standard call to check for call compatibility.

2520: BEGIN
2521: -- Standard Start of API savepoint
2522: SAVEPOINT UPDATE_HA_FILTER;
2523:
2524: -- Standard call to check for call compatibility.
2525: IF NOT FND_API.Compatible_API_Call (
2526: l_api_version,
2527: p_api_version,
2528: l_api_name,

Line 2556: -- Standard check of p_commit.

2552:
2553: -----------------------
2554: -- end of real logic --
2555:
2556: -- Standard check of p_commit.
2557: IF (FND_API.To_Boolean(p_commit)) THEN
2558: COMMIT WORK;
2559: END IF;
2560:

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

2557: IF (FND_API.To_Boolean(p_commit)) THEN
2558: COMMIT WORK;
2559: END IF;
2560:
2561: -- Standard call to get message count and if count is 1, get message info.
2562: FND_MSG_PUB.Count_And_Get(
2563: p_count => x_msg_count,
2564: p_data => x_msg_data );
2565:

Line 2614: -- Standard Start of API savepoint

2610: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_HA_FILTERS_F_HOST_APP';
2611: l_api_version CONSTANT NUMBER := p_api_version;
2612:
2613: BEGIN
2614: -- Standard Start of API savepoint
2615: SAVEPOINT DELETE_HA_FILTERS_F_HOST_APP;
2616:
2617: -- Standard call to check for call compatibility.
2618: IF NOT FND_API.Compatible_API_Call (

Line 2617: -- Standard call to check for call compatibility.

2613: BEGIN
2614: -- Standard Start of API savepoint
2615: SAVEPOINT DELETE_HA_FILTERS_F_HOST_APP;
2616:
2617: -- Standard call to check for call compatibility.
2618: IF NOT FND_API.Compatible_API_Call (
2619: l_api_version,
2620: p_api_version,
2621: l_api_name,

Line 2644: -- Standard check of p_commit.

2640:
2641: -----------------------
2642: -- end of real logic --
2643:
2644: -- Standard check of p_commit.
2645: IF (FND_API.To_Boolean(p_commit)) THEN
2646: COMMIT WORK;
2647: END IF;
2648:

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

2645: IF (FND_API.To_Boolean(p_commit)) THEN
2646: COMMIT WORK;
2647: END IF;
2648:
2649: -- Standard call to get message count and if count is 1, get message info.
2650: FND_MSG_PUB.Count_And_Get(
2651: p_count => x_msg_count,
2652: p_data => x_msg_data );
2653:

Line 2702: -- Standard Start of API savepoint

2698: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_HA_FILTERS_F_CA_FILTER';
2699: l_api_version CONSTANT NUMBER := p_api_version;
2700:
2701: BEGIN
2702: -- Standard Start of API savepoint
2703: SAVEPOINT DELETE_HA_FILTERS_F_CA_FILTER;
2704:
2705: -- Standard call to check for call compatibility.
2706: IF NOT FND_API.Compatible_API_Call (

Line 2705: -- Standard call to check for call compatibility.

2701: BEGIN
2702: -- Standard Start of API savepoint
2703: SAVEPOINT DELETE_HA_FILTERS_F_CA_FILTER;
2704:
2705: -- Standard call to check for call compatibility.
2706: IF NOT FND_API.Compatible_API_Call (
2707: l_api_version,
2708: p_api_version,
2709: l_api_name,

Line 2732: -- Standard check of p_commit.

2728:
2729: -----------------------
2730: -- end of real logic --
2731:
2732: -- Standard check of p_commit.
2733: IF (FND_API.To_Boolean(p_commit)) THEN
2734: COMMIT WORK;
2735: END IF;
2736:

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

2733: IF (FND_API.To_Boolean(p_commit)) THEN
2734: COMMIT WORK;
2735: END IF;
2736:
2737: -- Standard call to get message count and if count is 1, get message info.
2738: FND_MSG_PUB.Count_And_Get(
2739: p_count => x_msg_count,
2740: p_data => x_msg_data );
2741:

Line 2796: -- Standard Start of API savepoint

2792:
2793: CURSOR sequence_cursor IS
2794: SELECT jtf_prefab_ca_fl_resps_s.NEXTVAL from dual;
2795: BEGIN
2796: -- Standard Start of API savepoint
2797: SAVEPOINT INSERT_CA_FL_RESP;
2798:
2799: -- Standard call to check for call compatibility.
2800: IF NOT FND_API.Compatible_API_Call (

Line 2799: -- Standard call to check for call compatibility.

2795: BEGIN
2796: -- Standard Start of API savepoint
2797: SAVEPOINT INSERT_CA_FL_RESP;
2798:
2799: -- Standard call to check for call compatibility.
2800: IF NOT FND_API.Compatible_API_Call (
2801: l_api_version,
2802: p_api_version,
2803: l_api_name,

Line 2849: -- Standard check of p_commit.

2845:
2846: -----------------------
2847: -- end of real logic --
2848:
2849: -- Standard check of p_commit.
2850: IF (FND_API.To_Boolean(p_commit)) THEN
2851: COMMIT WORK;
2852: END IF;
2853:

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

2850: IF (FND_API.To_Boolean(p_commit)) THEN
2851: COMMIT WORK;
2852: END IF;
2853:
2854: -- Standard call to get message count and if count is 1, get message info.
2855: FND_MSG_PUB.Count_And_Get(
2856: p_count => x_msg_count,
2857: p_data => x_msg_data );
2858:

Line 2907: -- Standard Start of API savepoint

2903: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_CA_FL_RESP';
2904: l_api_version CONSTANT NUMBER := p_api_version;
2905:
2906: BEGIN
2907: -- Standard Start of API savepoint
2908: SAVEPOINT DELETE_CA_FL_RESP;
2909:
2910: -- Standard call to check for call compatibility.
2911: IF NOT FND_API.Compatible_API_Call (

Line 2910: -- Standard call to check for call compatibility.

2906: BEGIN
2907: -- Standard Start of API savepoint
2908: SAVEPOINT DELETE_CA_FL_RESP;
2909:
2910: -- Standard call to check for call compatibility.
2911: IF NOT FND_API.Compatible_API_Call (
2912: l_api_version,
2913: p_api_version,
2914: l_api_name,

Line 2937: -- Standard check of p_commit.

2933:
2934: -----------------------
2935: -- end of real logic --
2936:
2937: -- Standard check of p_commit.
2938: IF (FND_API.To_Boolean(p_commit)) THEN
2939: COMMIT WORK;
2940: END IF;
2941:

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

2938: IF (FND_API.To_Boolean(p_commit)) THEN
2939: COMMIT WORK;
2940: END IF;
2941:
2942: -- Standard call to get message count and if count is 1, get message info.
2943: FND_MSG_PUB.Count_And_Get(
2944: p_count => x_msg_count,
2945: p_data => x_msg_data );
2946:

Line 2996: -- Standard Start of API savepoint

2992: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_CA_FL_RESP';
2993: l_api_version CONSTANT NUMBER := p_api_version;
2994:
2995: BEGIN
2996: -- Standard Start of API savepoint
2997: SAVEPOINT DELETE_CA_FL_RESP;
2998:
2999: -- Standard call to check for call compatibility.
3000: IF NOT FND_API.Compatible_API_Call (

Line 2999: -- Standard call to check for call compatibility.

2995: BEGIN
2996: -- Standard Start of API savepoint
2997: SAVEPOINT DELETE_CA_FL_RESP;
2998:
2999: -- Standard call to check for call compatibility.
3000: IF NOT FND_API.Compatible_API_Call (
3001: l_api_version,
3002: p_api_version,
3003: l_api_name,

Line 3027: -- Standard check of p_commit.

3023:
3024: -----------------------
3025: -- end of real logic --
3026:
3027: -- Standard check of p_commit.
3028: IF (FND_API.To_Boolean(p_commit)) THEN
3029: COMMIT WORK;
3030: END IF;
3031:

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

3028: IF (FND_API.To_Boolean(p_commit)) THEN
3029: COMMIT WORK;
3030: END IF;
3031:
3032: -- Standard call to get message count and if count is 1, get message info.
3033: FND_MSG_PUB.Count_And_Get(
3034: p_count => x_msg_count,
3035: p_data => x_msg_data );
3036:

Line 3091: -- Standard Start of API savepoint

3087:
3088: CURSOR sequence_cursor IS
3089: SELECT jtf_prefab_ca_fl_langs_s.NEXTVAL from dual;
3090: BEGIN
3091: -- Standard Start of API savepoint
3092: SAVEPOINT INSERT_CA_FL_LANG;
3093:
3094: -- Standard call to check for call compatibility.
3095: IF NOT FND_API.Compatible_API_Call (

Line 3094: -- Standard call to check for call compatibility.

3090: BEGIN
3091: -- Standard Start of API savepoint
3092: SAVEPOINT INSERT_CA_FL_LANG;
3093:
3094: -- Standard call to check for call compatibility.
3095: IF NOT FND_API.Compatible_API_Call (
3096: l_api_version,
3097: p_api_version,
3098: l_api_name,

Line 3144: -- Standard check of p_commit.

3140:
3141: -----------------------
3142: -- end of real logic --
3143:
3144: -- Standard check of p_commit.
3145: IF (FND_API.To_Boolean(p_commit)) THEN
3146: COMMIT WORK;
3147: END IF;
3148:

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

3145: IF (FND_API.To_Boolean(p_commit)) THEN
3146: COMMIT WORK;
3147: END IF;
3148:
3149: -- Standard call to get message count and if count is 1, get message info.
3150: FND_MSG_PUB.Count_And_Get(
3151: p_count => x_msg_count,
3152: p_data => x_msg_data );
3153:

Line 3202: -- Standard Start of API savepoint

3198: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_CA_FL_LANG';
3199: l_api_version CONSTANT NUMBER := p_api_version;
3200:
3201: BEGIN
3202: -- Standard Start of API savepoint
3203: SAVEPOINT DELETE_CA_FL_LANG;
3204:
3205: -- Standard call to check for call compatibility.
3206: IF NOT FND_API.Compatible_API_Call (

Line 3205: -- Standard call to check for call compatibility.

3201: BEGIN
3202: -- Standard Start of API savepoint
3203: SAVEPOINT DELETE_CA_FL_LANG;
3204:
3205: -- Standard call to check for call compatibility.
3206: IF NOT FND_API.Compatible_API_Call (
3207: l_api_version,
3208: p_api_version,
3209: l_api_name,

Line 3232: -- Standard check of p_commit.

3228:
3229: -----------------------
3230: -- end of real logic --
3231:
3232: -- Standard check of p_commit.
3233: IF (FND_API.To_Boolean(p_commit)) THEN
3234: COMMIT WORK;
3235: END IF;
3236:

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

3233: IF (FND_API.To_Boolean(p_commit)) THEN
3234: COMMIT WORK;
3235: END IF;
3236:
3237: -- Standard call to get message count and if count is 1, get message info.
3238: FND_MSG_PUB.Count_And_Get(
3239: p_count => x_msg_count,
3240: p_data => x_msg_data );
3241:

Line 3291: -- Standard Start of API savepoint

3287: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_CA_FL_LANG';
3288: l_api_version CONSTANT NUMBER := p_api_version;
3289:
3290: BEGIN
3291: -- Standard Start of API savepoint
3292: SAVEPOINT DELETE_CA_FL_LANG;
3293:
3294: -- Standard call to check for call compatibility.
3295: IF NOT FND_API.Compatible_API_Call (

Line 3294: -- Standard call to check for call compatibility.

3290: BEGIN
3291: -- Standard Start of API savepoint
3292: SAVEPOINT DELETE_CA_FL_LANG;
3293:
3294: -- Standard call to check for call compatibility.
3295: IF NOT FND_API.Compatible_API_Call (
3296: l_api_version,
3297: p_api_version,
3298: l_api_name,

Line 3322: -- Standard check of p_commit.

3318:
3319: -----------------------
3320: -- end of real logic --
3321:
3322: -- Standard check of p_commit.
3323: IF (FND_API.To_Boolean(p_commit)) THEN
3324: COMMIT WORK;
3325: END IF;
3326:

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

3323: IF (FND_API.To_Boolean(p_commit)) THEN
3324: COMMIT WORK;
3325: END IF;
3326:
3327: -- Standard call to get message count and if count is 1, get message info.
3328: FND_MSG_PUB.Count_And_Get(
3329: p_count => x_msg_count,
3330: p_data => x_msg_data );
3331: