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_POLICY_PUB dependencies on STANDARD

Line 46: -- Standard Start of API savepoint

42:
43: CURSOR sequence_cursor IS
44: SELECT jtf_prefab_policies_b_s.NEXTVAL from dual;
45: BEGIN
46: -- Standard Start of API savepoint
47: SAVEPOINT INSERT_POLICY;
48:
49: -- Standard call to check for call compatibility.
50: IF NOT FND_API.Compatible_API_Call (

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

45: BEGIN
46: -- Standard Start of API savepoint
47: SAVEPOINT INSERT_POLICY;
48:
49: -- Standard call to check for call compatibility.
50: IF NOT FND_API.Compatible_API_Call (
51: l_api_version,
52: p_api_version,
53: l_api_name,

Line 151: -- Standard check of p_commit.

147:
148: -----------------------
149: -- end of real logic --
150:
151: -- Standard check of p_commit.
152: IF (FND_API.To_Boolean(p_commit)) THEN
153: COMMIT WORK;
154: END IF;
155:

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

152: IF (FND_API.To_Boolean(p_commit)) THEN
153: COMMIT WORK;
154: END IF;
155:
156: -- Standard call to get message count and if count is 1, get message info.
157: FND_MSG_PUB.Count_And_Get(
158: p_count => x_msg_count,
159: p_data => x_msg_data );
160:

Line 224: -- Standard Start of API savepoint

220: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_POLICY';
221: l_api_version NUMBER := p_api_version;
222:
223: BEGIN
224: -- Standard Start of API savepoint
225: SAVEPOINT UPDATE_POLICY;
226:
227: -- Standard call to check for call compatibility.
228: IF NOT FND_API.Compatible_API_Call (

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

223: BEGIN
224: -- Standard Start of API savepoint
225: SAVEPOINT UPDATE_POLICY;
226:
227: -- Standard call to check for call compatibility.
228: IF NOT FND_API.Compatible_API_Call (
229: l_api_version,
230: p_api_version,
231: l_api_name,

Line 295: -- Standard check of p_commit.

291:
292: -----------------------
293: -- end of real logic --
294:
295: -- Standard check of p_commit.
296: IF (FND_API.To_Boolean(p_commit)) THEN
297: COMMIT WORK;
298: END IF;
299:

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

296: IF (FND_API.To_Boolean(p_commit)) THEN
297: COMMIT WORK;
298: END IF;
299:
300: -- Standard call to get message count and if count is 1, get message info.
301: FND_MSG_PUB.Count_And_Get(
302: p_count => x_msg_count,
303: p_data => x_msg_data );
304:

Line 353: -- Standard Start of API savepoint

349: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_POLICY';
350: l_api_version CONSTANT NUMBER := p_api_version;
351:
352: BEGIN
353: -- Standard Start of API savepoint
354: SAVEPOINT DELETE_POLICY;
355:
356: -- Standard call to check for call compatibility.
357: IF NOT FND_API.Compatible_API_Call (

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

352: BEGIN
353: -- Standard Start of API savepoint
354: SAVEPOINT DELETE_POLICY;
355:
356: -- Standard call to check for call compatibility.
357: IF NOT FND_API.Compatible_API_Call (
358: l_api_version,
359: p_api_version,
360: l_api_name,

Line 387: -- Standard check of p_commit.

383:
384: -----------------------
385: -- end of real logic --
386:
387: -- Standard check of p_commit.
388: IF (FND_API.To_Boolean(p_commit)) THEN
389: COMMIT WORK;
390: END IF;
391:

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

388: IF (FND_API.To_Boolean(p_commit)) THEN
389: COMMIT WORK;
390: END IF;
391:
392: -- Standard call to get message count and if count is 1, get message info.
393: FND_MSG_PUB.Count_And_Get(
394: p_count => x_msg_count,
395: p_data => x_msg_data );
396:

Line 448: -- Standard Start of API savepoint

444: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_UR_POLICY';
445: l_api_version NUMBER := p_api_version;
446:
447: BEGIN
448: -- Standard Start of API savepoint
449: SAVEPOINT INSERT_UR_POLICY;
450:
451: -- Standard call to check for call compatibility.
452: IF NOT FND_API.Compatible_API_Call (

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

447: BEGIN
448: -- Standard Start of API savepoint
449: SAVEPOINT INSERT_UR_POLICY;
450:
451: -- Standard call to check for call compatibility.
452: IF NOT FND_API.Compatible_API_Call (
453: l_api_version,
454: p_api_version,
455: l_api_name,

Line 499: -- Standard check of p_commit.

495:
496: -----------------------
497: -- end of real logic --
498:
499: -- Standard check of p_commit.
500: IF (FND_API.To_Boolean(p_commit)) THEN
501: COMMIT WORK;
502: END IF;
503:

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

500: IF (FND_API.To_Boolean(p_commit)) THEN
501: COMMIT WORK;
502: END IF;
503:
504: -- Standard call to get message count and if count is 1, get message info.
505: FND_MSG_PUB.Count_And_Get(
506: p_count => x_msg_count,
507: p_data => x_msg_data );
508:

Line 559: -- Standard Start of API savepoint

555: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_UR_POLICY';
556: l_api_version NUMBER := p_api_version;
557:
558: BEGIN
559: -- Standard Start of API savepoint
560: SAVEPOINT DELETE_UR_POLICY;
561:
562: -- Standard call to check for call compatibility.
563: IF NOT FND_API.Compatible_API_Call (

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

558: BEGIN
559: -- Standard Start of API savepoint
560: SAVEPOINT DELETE_UR_POLICY;
561:
562: -- Standard call to check for call compatibility.
563: IF NOT FND_API.Compatible_API_Call (
564: l_api_version,
565: p_api_version,
566: l_api_name,

Line 591: -- Standard check of p_commit.

587:
588: -----------------------
589: -- end of real logic --
590:
591: -- Standard check of p_commit.
592: IF (FND_API.To_Boolean(p_commit)) THEN
593: COMMIT WORK;
594: END IF;
595:

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

592: IF (FND_API.To_Boolean(p_commit)) THEN
593: COMMIT WORK;
594: END IF;
595:
596: -- Standard call to get message count and if count is 1, get message info.
597: FND_MSG_PUB.Count_And_Get(
598: p_count => x_msg_count,
599: p_data => x_msg_data );
600:

Line 649: -- Standard Start of API savepoint

645: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_UR_POLICY';
646: l_api_version NUMBER := p_api_version;
647:
648: BEGIN
649: -- Standard Start of API savepoint
650: SAVEPOINT DELETE_UR_POLICY;
651:
652: -- Standard call to check for call compatibility.
653: IF NOT FND_API.Compatible_API_Call (

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

648: BEGIN
649: -- Standard Start of API savepoint
650: SAVEPOINT DELETE_UR_POLICY;
651:
652: -- Standard call to check for call compatibility.
653: IF NOT FND_API.Compatible_API_Call (
654: l_api_version,
655: p_api_version,
656: l_api_name,

Line 679: -- Standard check of p_commit.

675:
676: -----------------------
677: -- end of real logic --
678:
679: -- Standard check of p_commit.
680: IF (FND_API.To_Boolean(p_commit)) THEN
681: COMMIT WORK;
682: END IF;
683:

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

680: IF (FND_API.To_Boolean(p_commit)) THEN
681: COMMIT WORK;
682: END IF;
683:
684: -- Standard call to get message count and if count is 1, get message info.
685: FND_MSG_PUB.Count_And_Get(
686: p_count => x_msg_count,
687: p_data => x_msg_data );
688:

Line 745: -- Standard Start of API savepoint

741: l_api_name CONSTANT VARCHAR2(30) := 'CONFIGURE_SYS_POLICY';
742: l_api_version NUMBER := p_api_version;
743:
744: BEGIN
745: -- Standard Start of API savepoint
746: SAVEPOINT CONFIGURE_SYS_POLICY;
747:
748: -- Standard call to check for call compatibility.
749: IF NOT FND_API.Compatible_API_Call (

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

744: BEGIN
745: -- Standard Start of API savepoint
746: SAVEPOINT CONFIGURE_SYS_POLICY;
747:
748: -- Standard call to check for call compatibility.
749: IF NOT FND_API.Compatible_API_Call (
750: l_api_version,
751: p_api_version,
752: l_api_name,

Line 829: -- Standard check of p_commit.

825:
826: -----------------------
827: -- end of real logic --
828:
829: -- Standard check of p_commit.
830: IF (FND_API.To_Boolean(p_commit)) THEN
831: COMMIT WORK;
832: END IF;
833:

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

830: IF (FND_API.To_Boolean(p_commit)) THEN
831: COMMIT WORK;
832: END IF;
833:
834: -- Standard call to get message count and if count is 1, get message info.
835: FND_MSG_PUB.Count_And_Get(
836: p_count => x_msg_count,
837: p_data => x_msg_data );
838:

Line 898: -- Standard Start of API savepoint

894:
895: CURSOR sequence_cursor IS
896: SELECT jtf_prefab_wsh_poes_b_s.NEXTVAL from dual;
897: BEGIN
898: -- Standard Start of API savepoint
899: SAVEPOINT INSERT_WSH_POLICY;
900:
901: -- Standard call to check for call compatibility.
902: IF NOT FND_API.Compatible_API_Call (

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

897: BEGIN
898: -- Standard Start of API savepoint
899: SAVEPOINT INSERT_WSH_POLICY;
900:
901: -- Standard call to check for call compatibility.
902: IF NOT FND_API.Compatible_API_Call (
903: l_api_version,
904: p_api_version,
905: l_api_name,

Line 983: -- Standard check of p_commit.

979:
980: -----------------------
981: -- end of real logic --
982:
983: -- Standard check of p_commit.
984: IF (FND_API.To_Boolean(p_commit)) THEN
985: COMMIT WORK;
986: END IF;
987:

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

984: IF (FND_API.To_Boolean(p_commit)) THEN
985: COMMIT WORK;
986: END IF;
987:
988: -- Standard call to get message count and if count is 1, get message info.
989: FND_MSG_PUB.Count_And_Get(
990: p_count => x_msg_count,
991: p_data => x_msg_data );
992:

Line 1049: -- Standard Start of API savepoint

1045: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_WSH_POLICY';
1046: l_api_version NUMBER := p_api_version;
1047:
1048: BEGIN
1049: -- Standard Start of API savepoint
1050: SAVEPOINT UPDATE_WSH_POLICY;
1051:
1052: -- Standard call to check for call compatibility.
1053: IF NOT FND_API.Compatible_API_Call (

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

1048: BEGIN
1049: -- Standard Start of API savepoint
1050: SAVEPOINT UPDATE_WSH_POLICY;
1051:
1052: -- Standard call to check for call compatibility.
1053: IF NOT FND_API.Compatible_API_Call (
1054: l_api_version,
1055: p_api_version,
1056: l_api_name,

Line 1105: -- Standard check of p_commit.

1101:
1102: -----------------------
1103: -- end of real logic --
1104:
1105: -- Standard check of p_commit.
1106: IF (FND_API.To_Boolean(p_commit)) THEN
1107: COMMIT WORK;
1108: END IF;
1109:

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

1106: IF (FND_API.To_Boolean(p_commit)) THEN
1107: COMMIT WORK;
1108: END IF;
1109:
1110: -- Standard call to get message count and if count is 1, get message info.
1111: FND_MSG_PUB.Count_And_Get(
1112: p_count => x_msg_count,
1113: p_data => x_msg_data );
1114:

Line 1163: -- Standard Start of API savepoint

1159: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_WSH_POLICY';
1160: l_api_version CONSTANT NUMBER := p_api_version;
1161:
1162: BEGIN
1163: -- Standard Start of API savepoint
1164: SAVEPOINT DELETE_WSH_POLICY;
1165:
1166: -- Standard call to check for call compatibility.
1167: IF NOT FND_API.Compatible_API_Call (

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

1162: BEGIN
1163: -- Standard Start of API savepoint
1164: SAVEPOINT DELETE_WSH_POLICY;
1165:
1166: -- Standard call to check for call compatibility.
1167: IF NOT FND_API.Compatible_API_Call (
1168: l_api_version,
1169: p_api_version,
1170: l_api_name,

Line 1206: -- Standard check of p_commit.

1202:
1203: -----------------------
1204: -- end of real logic --
1205:
1206: -- Standard check of p_commit.
1207: IF (FND_API.To_Boolean(p_commit)) THEN
1208: COMMIT WORK;
1209: END IF;
1210:

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

1207: IF (FND_API.To_Boolean(p_commit)) THEN
1208: COMMIT WORK;
1209: END IF;
1210:
1211: -- Standard call to get message count and if count is 1, get message info.
1212: FND_MSG_PUB.Count_And_Get(
1213: p_count => x_msg_count,
1214: p_data => x_msg_data );
1215:

Line 1266: -- Standard Start of API savepoint

1262: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_WSHP_POLICY';
1263: l_api_version NUMBER := p_api_version;
1264:
1265: BEGIN
1266: -- Standard Start of API savepoint
1267: SAVEPOINT INSERT_WSHP_POLICY;
1268:
1269: -- Standard call to check for call compatibility.
1270: IF NOT FND_API.Compatible_API_Call (

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

1265: BEGIN
1266: -- Standard Start of API savepoint
1267: SAVEPOINT INSERT_WSHP_POLICY;
1268:
1269: -- Standard call to check for call compatibility.
1270: IF NOT FND_API.Compatible_API_Call (
1271: l_api_version,
1272: p_api_version,
1273: l_api_name,

Line 1315: -- Standard check of p_commit.

1311:
1312: -----------------------
1313: -- end of real logic --
1314:
1315: -- Standard check of p_commit.
1316: IF (FND_API.To_Boolean(p_commit)) THEN
1317: COMMIT WORK;
1318: END IF;
1319:

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

1316: IF (FND_API.To_Boolean(p_commit)) THEN
1317: COMMIT WORK;
1318: END IF;
1319:
1320: -- Standard call to get message count and if count is 1, get message info.
1321: FND_MSG_PUB.Count_And_Get(
1322: p_count => x_msg_count,
1323: p_data => x_msg_data );
1324:

Line 1374: -- Standard Start of API savepoint

1370: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_WSHP_POLICY';
1371: l_api_version NUMBER := p_api_version;
1372:
1373: BEGIN
1374: -- Standard Start of API savepoint
1375: SAVEPOINT DELETE_WSHP_POLICY;
1376:
1377: -- Standard call to check for call compatibility.
1378: IF NOT FND_API.Compatible_API_Call (

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

1373: BEGIN
1374: -- Standard Start of API savepoint
1375: SAVEPOINT DELETE_WSHP_POLICY;
1376:
1377: -- Standard call to check for call compatibility.
1378: IF NOT FND_API.Compatible_API_Call (
1379: l_api_version,
1380: p_api_version,
1381: l_api_name,

Line 1405: -- Standard check of p_commit.

1401:
1402: -----------------------
1403: -- end of real logic --
1404:
1405: -- Standard check of p_commit.
1406: IF (FND_API.To_Boolean(p_commit)) THEN
1407: COMMIT WORK;
1408: END IF;
1409:

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

1406: IF (FND_API.To_Boolean(p_commit)) THEN
1407: COMMIT WORK;
1408: END IF;
1409:
1410: -- Standard call to get message count and if count is 1, get message info.
1411: FND_MSG_PUB.Count_And_Get(
1412: p_count => x_msg_count,
1413: p_data => x_msg_data );
1414:

Line 1463: -- Standard Start of API savepoint

1459: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_WSHP_POLICY';
1460: l_api_version NUMBER := p_api_version;
1461:
1462: BEGIN
1463: -- Standard Start of API savepoint
1464: SAVEPOINT DELETE_WSHP_POLICY;
1465:
1466: -- Standard call to check for call compatibility.
1467: IF NOT FND_API.Compatible_API_Call (

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

1462: BEGIN
1463: -- Standard Start of API savepoint
1464: SAVEPOINT DELETE_WSHP_POLICY;
1465:
1466: -- Standard call to check for call compatibility.
1467: IF NOT FND_API.Compatible_API_Call (
1468: l_api_version,
1469: p_api_version,
1470: l_api_name,

Line 1493: -- Standard check of p_commit.

1489:
1490: -----------------------
1491: -- end of real logic --
1492:
1493: -- Standard check of p_commit.
1494: IF (FND_API.To_Boolean(p_commit)) THEN
1495: COMMIT WORK;
1496: END IF;
1497:

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

1494: IF (FND_API.To_Boolean(p_commit)) THEN
1495: COMMIT WORK;
1496: END IF;
1497:
1498: -- Standard call to get message count and if count is 1, get message info.
1499: FND_MSG_PUB.Count_And_Get(
1500: p_count => x_msg_count,
1501: p_data => x_msg_data );
1502: