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

Line 355: * @param p_api_version standard parm - API Version

351: * WORKSPACE and WSFOLDER). Currently supported
352: * in OCM only FOLDER and HIDDEN-FOLDER.
353: * @param p_commit Indicates whether to commit or not at the end
354: * of procedure
355: * @param p_api_version standard parm - API Version
356: * @param p_init_msg_list standard parm - Initialize message list
357: * @param x_return_status standard parm - Return Status
358: * @param x_msg_count standard parm - Message Count
359: * @param x_msg_data standard parm - Message Data

Line 356: * @param p_init_msg_list standard parm - Initialize message list

352: * in OCM only FOLDER and HIDDEN-FOLDER.
353: * @param p_commit Indicates whether to commit or not at the end
354: * of procedure
355: * @param p_api_version standard parm - API Version
356: * @param p_init_msg_list standard parm - Initialize message list
357: * @param x_return_status standard parm - Return Status
358: * @param x_msg_count standard parm - Message Count
359: * @param x_msg_data standard parm - Message Data
360: *

Line 357: * @param x_return_status standard parm - Return Status

353: * @param p_commit Indicates whether to commit or not at the end
354: * of procedure
355: * @param p_api_version standard parm - API Version
356: * @param p_init_msg_list standard parm - Initialize message list
357: * @param x_return_status standard parm - Return Status
358: * @param x_msg_count standard parm - Message Count
359: * @param x_msg_data standard parm - Message Data
360: *
361: * @rep:displayname set_inheritance_type

Line 358: * @param x_msg_count standard parm - Message Count

354: * of procedure
355: * @param p_api_version standard parm - API Version
356: * @param p_init_msg_list standard parm - Initialize message list
357: * @param x_return_status standard parm - Return Status
358: * @param x_msg_count standard parm - Message Count
359: * @param x_msg_data standard parm - Message Data
360: *
361: * @rep:displayname set_inheritance_type
362: *

Line 359: * @param x_msg_data standard parm - Message Data

355: * @param p_api_version standard parm - API Version
356: * @param p_init_msg_list standard parm - Initialize message list
357: * @param x_return_status standard parm - Return Status
358: * @param x_msg_count standard parm - Message Count
359: * @param x_msg_data standard parm - Message Data
360: *
361: * @rep:displayname set_inheritance_type
362: *
363: */

Line 380: -- local variable for standards **

376: ,x_msg_count OUT NOCOPY NUMBER
377: ,x_msg_data OUT NOCOPY VARCHAR2
378: ) AS
379: l_rowid ROWID;
380: --******** local variable for standards **********
381: l_api_name CONSTANT VARCHAR2(30) := 'set_inheritance_type';
382: l_api_version CONSTANT NUMBER := 1.0;
383: -- IBC_object_grant_groups
384: l_object_grant_group_rowid ROWID;

Line 414: -- * Standard Begins **

410:
411: BEGIN
412: SAVEPOINT svpt_set_inheritance_type;
413:
414: -- ******* Standard Begins ********
415: -- Standard call to check for call compatibility.
416: IF NOT FND_API.Compatible_API_Call (
417: l_api_version,
418: p_api_version,

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

411: BEGIN
412: SAVEPOINT svpt_set_inheritance_type;
413:
414: -- ******* Standard Begins ********
415: -- Standard call to check for call compatibility.
416: IF NOT FND_API.Compatible_API_Call (
417: l_api_version,
418: p_api_version,
419: l_api_name,

Line 487: -- Standard call to get message count and if count=1, get the message

483: IF (p_commit = FND_API.g_true) THEN
484: COMMIT;
485: END IF;
486:
487: -- Standard call to get message count and if count=1, get the message
488: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
489: p_data => x_msg_data);
490: EXCEPTION
491: WHEN FND_API.G_EXC_ERROR THEN

Line 560: * @param p_api_version standard parm - API Version

556: * @param p_instance_pk4_value value 4 for instance's primary key
557: * @param p_instance_pk5_value value 5 for instance's primary key
558: * @param p_commit Indicates whether to commit or not at the end
559: * of procedure
560: * @param p_api_version standard parm - API Version
561: * @param p_init_msg_list standard parm - Initialize message list
562: * @param x_return_status standard parm - Return Status
563: * @param x_msg_count standard parm - Message Count
564: * @param x_msg_data standard parm - Message Data

Line 561: * @param p_init_msg_list standard parm - Initialize message list

557: * @param p_instance_pk5_value value 5 for instance's primary key
558: * @param p_commit Indicates whether to commit or not at the end
559: * of procedure
560: * @param p_api_version standard parm - API Version
561: * @param p_init_msg_list standard parm - Initialize message list
562: * @param x_return_status standard parm - Return Status
563: * @param x_msg_count standard parm - Message Count
564: * @param x_msg_data standard parm - Message Data
565: *

Line 562: * @param x_return_status standard parm - Return Status

558: * @param p_commit Indicates whether to commit or not at the end
559: * of procedure
560: * @param p_api_version standard parm - API Version
561: * @param p_init_msg_list standard parm - Initialize message list
562: * @param x_return_status standard parm - Return Status
563: * @param x_msg_count standard parm - Message Count
564: * @param x_msg_data standard parm - Message Data
565: *
566: * @rep:displayname Remove_Instance

Line 563: * @param x_msg_count standard parm - Message Count

559: * of procedure
560: * @param p_api_version standard parm - API Version
561: * @param p_init_msg_list standard parm - Initialize message list
562: * @param x_return_status standard parm - Return Status
563: * @param x_msg_count standard parm - Message Count
564: * @param x_msg_data standard parm - Message Data
565: *
566: * @rep:displayname Remove_Instance
567: *

Line 564: * @param x_msg_data standard parm - Message Data

560: * @param p_api_version standard parm - API Version
561: * @param p_init_msg_list standard parm - Initialize message list
562: * @param x_return_status standard parm - Return Status
563: * @param x_msg_count standard parm - Message Count
564: * @param x_msg_data standard parm - Message Data
565: *
566: * @rep:displayname Remove_Instance
567: *
568: */

Line 584: -- local variable for standards **

580: ,x_msg_count OUT NOCOPY NUMBER
581: ,x_msg_data OUT NOCOPY VARCHAR2
582: ) AS
583: l_rowid ROWID;
584: --******** local variable for standards **********
585: l_api_name CONSTANT VARCHAR2(30) := 'Remove_Instance';
586: l_api_version CONSTANT NUMBER := 1.0;
587: -- IBC_object_grant_groups
588: l_object_grant_group_rowid ROWID;

Line 605: -- * Standard Begins **

601:
602: BEGIN
603: SAVEPOINT svpt_remove_instance;
604:
605: -- ******* Standard Begins ********
606: -- Standard call to check for call compatibility.
607: IF NOT FND_API.Compatible_API_Call (
608: l_api_version,
609: p_api_version,

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

602: BEGIN
603: SAVEPOINT svpt_remove_instance;
604:
605: -- ******* Standard Begins ********
606: -- Standard call to check for call compatibility.
607: IF NOT FND_API.Compatible_API_Call (
608: l_api_version,
609: p_api_version,
610: l_api_name,

Line 679: -- Standard call to get message count and if count=1, get the message

675: IF (p_commit = FND_API.g_true AND x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
676: COMMIT;
677: END IF;
678:
679: -- Standard call to get message count and if count=1, get the message
680: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
681: p_data => x_msg_data);
682: EXCEPTION
683: WHEN FND_API.G_EXC_ERROR THEN

Line 764: * @param p_api_version standard parm - API Version

760: * WORKSPACE and WSFOLDER). Currently supported
761: * in OCM only FOLDER and HIDDEN-FOLDER.
762: * @param p_commit Indicates whether to commit or not at the end
763: * of procedure
764: * @param p_api_version standard parm - API Version
765: * @param p_init_msg_list standard parm - Initialize message list
766: * @param x_return_status standard parm - Return Status
767: * @param x_msg_count standard parm - Message Count
768: * @param x_msg_data standard parm - Message Data

Line 765: * @param p_init_msg_list standard parm - Initialize message list

761: * in OCM only FOLDER and HIDDEN-FOLDER.
762: * @param p_commit Indicates whether to commit or not at the end
763: * of procedure
764: * @param p_api_version standard parm - API Version
765: * @param p_init_msg_list standard parm - Initialize message list
766: * @param x_return_status standard parm - Return Status
767: * @param x_msg_count standard parm - Message Count
768: * @param x_msg_data standard parm - Message Data
769: *

Line 766: * @param x_return_status standard parm - Return Status

762: * @param p_commit Indicates whether to commit or not at the end
763: * of procedure
764: * @param p_api_version standard parm - API Version
765: * @param p_init_msg_list standard parm - Initialize message list
766: * @param x_return_status standard parm - Return Status
767: * @param x_msg_count standard parm - Message Count
768: * @param x_msg_data standard parm - Message Data
769: *
770: * @rep:displayname establish_inheritance

Line 767: * @param x_msg_count standard parm - Message Count

763: * of procedure
764: * @param p_api_version standard parm - API Version
765: * @param p_init_msg_list standard parm - Initialize message list
766: * @param x_return_status standard parm - Return Status
767: * @param x_msg_count standard parm - Message Count
768: * @param x_msg_data standard parm - Message Data
769: *
770: * @rep:displayname establish_inheritance
771: *

Line 768: * @param x_msg_data standard parm - Message Data

764: * @param p_api_version standard parm - API Version
765: * @param p_init_msg_list standard parm - Initialize message list
766: * @param x_return_status standard parm - Return Status
767: * @param x_msg_count standard parm - Message Count
768: * @param x_msg_data standard parm - Message Data
769: *
770: * @rep:displayname establish_inheritance
771: *
772: */

Line 795: -- local variable for standards **

791: ,x_msg_count OUT NOCOPY NUMBER
792: ,x_msg_data OUT NOCOPY VARCHAR2
793: ) AS
794: l_rowid ROWID;
795: --******** local variable for standards **********
796: l_api_name CONSTANT VARCHAR2(30) := 'establish_inheritance';
797: l_api_version CONSTANT NUMBER := 1.0;
798: -- IBC_object_grant_groups
799: l_object_grant_group_rowid ROWID;

Line 822: -- * Standard Begins **

818: WHERE inherited_from = p_ogg_id;
819: BEGIN
820: SAVEPOINT svpt_establish_inheritance;
821:
822: -- ******* Standard Begins ********
823: -- Standard call to check for call compatibility.
824: IF NOT FND_API.Compatible_API_Call (
825: l_api_version,
826: p_api_version,

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

819: BEGIN
820: SAVEPOINT svpt_establish_inheritance;
821:
822: -- ******* Standard Begins ********
823: -- Standard call to check for call compatibility.
824: IF NOT FND_API.Compatible_API_Call (
825: l_api_version,
826: p_api_version,
827: l_api_name,

Line 1078: -- Standard call to get message count and if count=1, get the message

1074: IF (p_commit = FND_API.g_true) THEN
1075: COMMIT;
1076: END IF;
1077:
1078: -- Standard call to get message count and if count=1, get the message
1079: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1080: p_data => x_msg_data);
1081: EXCEPTION
1082: WHEN FND_API.G_EXC_ERROR THEN

Line 1161: * @param p_api_version standard parm - API Version

1157: * @param p_container_pk4_value value 4 for container's primary key
1158: * @param p_container_pk5_value value 5 for container's primary key
1159: * @param p_commit Indicates whether to commit or not at the end
1160: * of procedure
1161: * @param p_api_version standard parm - API Version
1162: * @param p_init_msg_list standard parm - Initialize message list
1163: * @param x_return_status standard parm - Return Status
1164: * @param x_msg_count standard parm - Message Count
1165: * @param x_msg_data standard parm - Message Data

Line 1162: * @param p_init_msg_list standard parm - Initialize message list

1158: * @param p_container_pk5_value value 5 for container's primary key
1159: * @param p_commit Indicates whether to commit or not at the end
1160: * of procedure
1161: * @param p_api_version standard parm - API Version
1162: * @param p_init_msg_list standard parm - Initialize message list
1163: * @param x_return_status standard parm - Return Status
1164: * @param x_msg_count standard parm - Message Count
1165: * @param x_msg_data standard parm - Message Data
1166: *

Line 1163: * @param x_return_status standard parm - Return Status

1159: * @param p_commit Indicates whether to commit or not at the end
1160: * of procedure
1161: * @param p_api_version standard parm - API Version
1162: * @param p_init_msg_list standard parm - Initialize message list
1163: * @param x_return_status standard parm - Return Status
1164: * @param x_msg_count standard parm - Message Count
1165: * @param x_msg_data standard parm - Message Data
1166: *
1167: * @rep:displayname establish_inheritance

Line 1164: * @param x_msg_count standard parm - Message Count

1160: * of procedure
1161: * @param p_api_version standard parm - API Version
1162: * @param p_init_msg_list standard parm - Initialize message list
1163: * @param x_return_status standard parm - Return Status
1164: * @param x_msg_count standard parm - Message Count
1165: * @param x_msg_data standard parm - Message Data
1166: *
1167: * @rep:displayname establish_inheritance
1168: *

Line 1165: * @param x_msg_data standard parm - Message Data

1161: * @param p_api_version standard parm - API Version
1162: * @param p_init_msg_list standard parm - Initialize message list
1163: * @param x_return_status standard parm - Return Status
1164: * @param x_msg_count standard parm - Message Count
1165: * @param x_msg_data standard parm - Message Data
1166: *
1167: * @rep:displayname establish_inheritance
1168: *
1169: */

Line 1231: * @param p_api_version standard parm - API Version

1227: * @param p_instance_pk4_value value 4 for instance's primary key
1228: * @param p_instance_pk5_value value 5 for instance's primary key
1229: * @param p_commit Indicates whether to commit or not at the end
1230: * of procedure
1231: * @param p_api_version standard parm - API Version
1232: * @param p_init_msg_list standard parm - Initialize message list
1233: * @param x_return_status standard parm - Return Status
1234: * @param x_msg_count standard parm - Message Count
1235: * @param x_msg_data standard parm - Message Data

Line 1232: * @param p_init_msg_list standard parm - Initialize message list

1228: * @param p_instance_pk5_value value 5 for instance's primary key
1229: * @param p_commit Indicates whether to commit or not at the end
1230: * of procedure
1231: * @param p_api_version standard parm - API Version
1232: * @param p_init_msg_list standard parm - Initialize message list
1233: * @param x_return_status standard parm - Return Status
1234: * @param x_msg_count standard parm - Message Count
1235: * @param x_msg_data standard parm - Message Data
1236: *

Line 1233: * @param x_return_status standard parm - Return Status

1229: * @param p_commit Indicates whether to commit or not at the end
1230: * of procedure
1231: * @param p_api_version standard parm - API Version
1232: * @param p_init_msg_list standard parm - Initialize message list
1233: * @param x_return_status standard parm - Return Status
1234: * @param x_msg_count standard parm - Message Count
1235: * @param x_msg_data standard parm - Message Data
1236: *
1237: * @rep:displayname reset_permissions

Line 1234: * @param x_msg_count standard parm - Message Count

1230: * of procedure
1231: * @param p_api_version standard parm - API Version
1232: * @param p_init_msg_list standard parm - Initialize message list
1233: * @param x_return_status standard parm - Return Status
1234: * @param x_msg_count standard parm - Message Count
1235: * @param x_msg_data standard parm - Message Data
1236: *
1237: * @rep:displayname reset_permissions
1238: *

Line 1235: * @param x_msg_data standard parm - Message Data

1231: * @param p_api_version standard parm - API Version
1232: * @param p_init_msg_list standard parm - Initialize message list
1233: * @param x_return_status standard parm - Return Status
1234: * @param x_msg_count standard parm - Message Count
1235: * @param x_msg_data standard parm - Message Data
1236: *
1237: * @rep:displayname reset_permissions
1238: *
1239: */

Line 1255: -- local variable for standards **

1251: ,x_msg_count OUT NOCOPY NUMBER
1252: ,x_msg_data OUT NOCOPY VARCHAR2
1253: ) AS
1254: l_rowid ROWID;
1255: --******** local variable for standards **********
1256: l_api_name CONSTANT VARCHAR2(30) := 'reset_permissions';
1257: l_api_version CONSTANT NUMBER := 1.0;
1258: -- IBC_object_grant_groups
1259: l_object_grant_group_rowid ROWID;

Line 1270: -- * Standard Begins **

1266: l_default_inheritance_type VARCHAR2(30);
1267: BEGIN
1268: SAVEPOINT svpt_reset_permissions;
1269:
1270: -- ******* Standard Begins ********
1271: -- Standard call to check for call compatibility.
1272: IF NOT FND_API.Compatible_API_Call (
1273: l_api_version,
1274: p_api_version,

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

1267: BEGIN
1268: SAVEPOINT svpt_reset_permissions;
1269:
1270: -- ******* Standard Begins ********
1271: -- Standard call to check for call compatibility.
1272: IF NOT FND_API.Compatible_API_Call (
1273: l_api_version,
1274: p_api_version,
1275: l_api_name,

Line 1356: -- Standard call to get message count and if count=1, get the message

1352: IF (p_commit = FND_API.g_true) THEN
1353: COMMIT;
1354: END IF;
1355:
1356: -- Standard call to get message count and if count=1, get the message
1357: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1358: p_data => x_msg_data);
1359:
1360: IF IBC_DEBUG_PVT.debug_enabled THEN

Line 1482: * @param p_api_version standard parm - API Version

1478: * @param p_instance_pk4_value value 4 for instance's primary key
1479: * @param p_instance_pk5_value value 5 for instance's primary key
1480: * @param p_commit Indicates whether to commit or not at the end
1481: * of procedure
1482: * @param p_api_version standard parm - API Version
1483: * @param p_init_msg_list standard parm - Initialize message list
1484: * @param x_return_status standard parm - Return Status
1485: * @param x_msg_count standard parm - Message Count
1486: * @param x_msg_data standard parm - Message Data

Line 1483: * @param p_init_msg_list standard parm - Initialize message list

1479: * @param p_instance_pk5_value value 5 for instance's primary key
1480: * @param p_commit Indicates whether to commit or not at the end
1481: * of procedure
1482: * @param p_api_version standard parm - API Version
1483: * @param p_init_msg_list standard parm - Initialize message list
1484: * @param x_return_status standard parm - Return Status
1485: * @param x_msg_count standard parm - Message Count
1486: * @param x_msg_data standard parm - Message Data
1487: *

Line 1484: * @param x_return_status standard parm - Return Status

1480: * @param p_commit Indicates whether to commit or not at the end
1481: * of procedure
1482: * @param p_api_version standard parm - API Version
1483: * @param p_init_msg_list standard parm - Initialize message list
1484: * @param x_return_status standard parm - Return Status
1485: * @param x_msg_count standard parm - Message Count
1486: * @param x_msg_data standard parm - Message Data
1487: *
1488: * @rep:displayname override_permissions

Line 1485: * @param x_msg_count standard parm - Message Count

1481: * of procedure
1482: * @param p_api_version standard parm - API Version
1483: * @param p_init_msg_list standard parm - Initialize message list
1484: * @param x_return_status standard parm - Return Status
1485: * @param x_msg_count standard parm - Message Count
1486: * @param x_msg_data standard parm - Message Data
1487: *
1488: * @rep:displayname override_permissions
1489: *

Line 1486: * @param x_msg_data standard parm - Message Data

1482: * @param p_api_version standard parm - API Version
1483: * @param p_init_msg_list standard parm - Initialize message list
1484: * @param x_return_status standard parm - Return Status
1485: * @param x_msg_count standard parm - Message Count
1486: * @param x_msg_data standard parm - Message Data
1487: *
1488: * @rep:displayname override_permissions
1489: *
1490: */

Line 1506: -- local variable for standards **

1502: ,x_msg_count OUT NOCOPY NUMBER
1503: ,x_msg_data OUT NOCOPY VARCHAR2
1504: ) AS
1505: l_rowid ROWID;
1506: --******** local variable for standards **********
1507: l_api_name CONSTANT VARCHAR2(30) := 'override_permissions';
1508: l_api_version CONSTANT NUMBER := 1.0;
1509: -- IBC_object_grant_groups
1510: l_object_grant_group_rowid ROWID;

Line 1550: -- * Standard Begins **

1546:
1547: BEGIN
1548: SAVEPOINT svpt_override_permissions;
1549:
1550: -- ******* Standard Begins ********
1551: -- Standard call to check for call compatibility.
1552: IF NOT FND_API.Compatible_API_Call (
1553: l_api_version,
1554: p_api_version,

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

1547: BEGIN
1548: SAVEPOINT svpt_override_permissions;
1549:
1550: -- ******* Standard Begins ********
1551: -- Standard call to check for call compatibility.
1552: IF NOT FND_API.Compatible_API_Call (
1553: l_api_version,
1554: p_api_version,
1555: l_api_name,

Line 1718: -- Standard call to get message count and if count=1, get the message

1714: IF (p_commit = FND_API.g_true) THEN
1715: COMMIT;
1716: END IF;
1717:
1718: -- Standard call to get message count and if count=1, get the message
1719: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1720: p_data => x_msg_data);
1721:
1722: IF IBC_DEBUG_PVT.debug_enabled THEN

Line 1858: * @param p_api_version standard parm - API Version

1854: * @param p_cascade_flag Indicates if permission should be carried over
1855: * to contained objects
1856: * @param p_commit Indicates whether to commit or not at the end
1857: * of procedure
1858: * @param p_api_version standard parm - API Version
1859: * @param p_init_msg_list standard parm - Initialize message list
1860: * @param x_return_status standard parm - Return Status
1861: * @param x_msg_count standard parm - Message Count
1862: * @param x_msg_data standard parm - Message Data

Line 1859: * @param p_init_msg_list standard parm - Initialize message list

1855: * to contained objects
1856: * @param p_commit Indicates whether to commit or not at the end
1857: * of procedure
1858: * @param p_api_version standard parm - API Version
1859: * @param p_init_msg_list standard parm - Initialize message list
1860: * @param x_return_status standard parm - Return Status
1861: * @param x_msg_count standard parm - Message Count
1862: * @param x_msg_data standard parm - Message Data
1863: *

Line 1860: * @param x_return_status standard parm - Return Status

1856: * @param p_commit Indicates whether to commit or not at the end
1857: * of procedure
1858: * @param p_api_version standard parm - API Version
1859: * @param p_init_msg_list standard parm - Initialize message list
1860: * @param x_return_status standard parm - Return Status
1861: * @param x_msg_count standard parm - Message Count
1862: * @param x_msg_data standard parm - Message Data
1863: *
1864: * @rep:displayname grant_permission

Line 1861: * @param x_msg_count standard parm - Message Count

1857: * of procedure
1858: * @param p_api_version standard parm - API Version
1859: * @param p_init_msg_list standard parm - Initialize message list
1860: * @param x_return_status standard parm - Return Status
1861: * @param x_msg_count standard parm - Message Count
1862: * @param x_msg_data standard parm - Message Data
1863: *
1864: * @rep:displayname grant_permission
1865: *

Line 1862: * @param x_msg_data standard parm - Message Data

1858: * @param p_api_version standard parm - API Version
1859: * @param p_init_msg_list standard parm - Initialize message list
1860: * @param x_return_status standard parm - Return Status
1861: * @param x_msg_count standard parm - Message Count
1862: * @param x_msg_data standard parm - Message Data
1863: *
1864: * @rep:displayname grant_permission
1865: *
1866: */

Line 1901: -- local variable for standards **

1897: l_statement VARCHAR2(4096);
1898: l_rowid ROWID;
1899: l_grant_id NUMBER;
1900: l_dummy VARCHAR2(30);
1901: --******** local variable for standards **********
1902: l_api_name CONSTANT VARCHAR2(30) := 'establish_inheritance';
1903: l_api_version CONSTANT NUMBER := 1.0;
1904: -- Object Definition
1905: l_nbr_pk_cols NUMBER;

Line 1958: -- * Standard Begins **

1954: AND NVL(end_date_active, SYSDATE);
1955:
1956: BEGIN
1957: SAVEPOINT svpt_grant_permission;
1958: -- ******* Standard Begins ********
1959: -- Standard call to check for call compatibility.
1960: IF NOT FND_API.Compatible_API_Call (
1961: l_api_version,
1962: p_api_version,

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

1955:
1956: BEGIN
1957: SAVEPOINT svpt_grant_permission;
1958: -- ******* Standard Begins ********
1959: -- Standard call to check for call compatibility.
1960: IF NOT FND_API.Compatible_API_Call (
1961: l_api_version,
1962: p_api_version,
1963: l_api_name,

Line 2308: -- Standard call to get message count and if count=1, get the message

2304: IF (p_commit = FND_API.g_true) THEN
2305: COMMIT;
2306: END IF;
2307:
2308: -- Standard call to get message count and if count=1, get the message
2309: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2310: p_data => x_msg_data);
2311:
2312: IF IBC_DEBUG_PVT.debug_enabled THEN

Line 2445: * @param p_api_version standard parm - API Version

2441: * @param p_cascade_flag Indicates if permission should be carried over
2442: * to contained objects
2443: * @param p_commit Indicates whether to commit or not at the end
2444: * of procedure
2445: * @param p_api_version standard parm - API Version
2446: * @param p_init_msg_list standard parm - Initialize message list
2447: * @param x_return_status standard parm - Return Status
2448: * @param x_msg_count standard parm - Message Count
2449: * @param x_msg_data standard parm - Message Data

Line 2446: * @param p_init_msg_list standard parm - Initialize message list

2442: * to contained objects
2443: * @param p_commit Indicates whether to commit or not at the end
2444: * of procedure
2445: * @param p_api_version standard parm - API Version
2446: * @param p_init_msg_list standard parm - Initialize message list
2447: * @param x_return_status standard parm - Return Status
2448: * @param x_msg_count standard parm - Message Count
2449: * @param x_msg_data standard parm - Message Data
2450: *

Line 2447: * @param x_return_status standard parm - Return Status

2443: * @param p_commit Indicates whether to commit or not at the end
2444: * of procedure
2445: * @param p_api_version standard parm - API Version
2446: * @param p_init_msg_list standard parm - Initialize message list
2447: * @param x_return_status standard parm - Return Status
2448: * @param x_msg_count standard parm - Message Count
2449: * @param x_msg_data standard parm - Message Data
2450: *
2451: * @rep:displayname grant_permission

Line 2448: * @param x_msg_count standard parm - Message Count

2444: * of procedure
2445: * @param p_api_version standard parm - API Version
2446: * @param p_init_msg_list standard parm - Initialize message list
2447: * @param x_return_status standard parm - Return Status
2448: * @param x_msg_count standard parm - Message Count
2449: * @param x_msg_data standard parm - Message Data
2450: *
2451: * @rep:displayname grant_permission
2452: *

Line 2449: * @param x_msg_data standard parm - Message Data

2445: * @param p_api_version standard parm - API Version
2446: * @param p_init_msg_list standard parm - Initialize message list
2447: * @param x_return_status standard parm - Return Status
2448: * @param x_msg_count standard parm - Message Count
2449: * @param x_msg_data standard parm - Message Data
2450: *
2451: * @rep:displayname grant_permission
2452: *
2453: */

Line 2544: * @param p_api_version standard parm - API Version

2540: * @param p_cascade_flag Indicates if permission should be carried over
2541: * to contained objects
2542: * @param p_commit Indicates whether to commit or not at the end
2543: * of procedure
2544: * @param p_api_version standard parm - API Version
2545: * @param p_init_msg_list standard parm - Initialize message list
2546: * @param x_return_status standard parm - Return Status
2547: * @param x_msg_count standard parm - Message Count
2548: * @param x_msg_data standard parm - Message Data

Line 2545: * @param p_init_msg_list standard parm - Initialize message list

2541: * to contained objects
2542: * @param p_commit Indicates whether to commit or not at the end
2543: * of procedure
2544: * @param p_api_version standard parm - API Version
2545: * @param p_init_msg_list standard parm - Initialize message list
2546: * @param x_return_status standard parm - Return Status
2547: * @param x_msg_count standard parm - Message Count
2548: * @param x_msg_data standard parm - Message Data
2549: *

Line 2546: * @param x_return_status standard parm - Return Status

2542: * @param p_commit Indicates whether to commit or not at the end
2543: * of procedure
2544: * @param p_api_version standard parm - API Version
2545: * @param p_init_msg_list standard parm - Initialize message list
2546: * @param x_return_status standard parm - Return Status
2547: * @param x_msg_count standard parm - Message Count
2548: * @param x_msg_data standard parm - Message Data
2549: *
2550: * @rep:displayname grant_permission

Line 2547: * @param x_msg_count standard parm - Message Count

2543: * of procedure
2544: * @param p_api_version standard parm - API Version
2545: * @param p_init_msg_list standard parm - Initialize message list
2546: * @param x_return_status standard parm - Return Status
2547: * @param x_msg_count standard parm - Message Count
2548: * @param x_msg_data standard parm - Message Data
2549: *
2550: * @rep:displayname grant_permission
2551: *

Line 2548: * @param x_msg_data standard parm - Message Data

2544: * @param p_api_version standard parm - API Version
2545: * @param p_init_msg_list standard parm - Initialize message list
2546: * @param x_return_status standard parm - Return Status
2547: * @param x_msg_count standard parm - Message Count
2548: * @param x_msg_data standard parm - Message Data
2549: *
2550: * @rep:displayname grant_permission
2551: *
2552: */

Line 2635: * @param p_api_version standard parm - API Version

2631: * granted, if not especified it means ANYBODY
2632: * @param p_grantee_resource_type Resource Type
2633: * @param p_commit Indicates whether to commit or not at the end
2634: * of procedure
2635: * @param p_api_version standard parm - API Version
2636: * @param p_init_msg_list standard parm - Initialize message list
2637: * @param x_return_status standard parm - Return Status
2638: * @param x_msg_count standard parm - Message Count
2639: * @param x_msg_data standard parm - Message Data

Line 2636: * @param p_init_msg_list standard parm - Initialize message list

2632: * @param p_grantee_resource_type Resource Type
2633: * @param p_commit Indicates whether to commit or not at the end
2634: * of procedure
2635: * @param p_api_version standard parm - API Version
2636: * @param p_init_msg_list standard parm - Initialize message list
2637: * @param x_return_status standard parm - Return Status
2638: * @param x_msg_count standard parm - Message Count
2639: * @param x_msg_data standard parm - Message Data
2640: *

Line 2637: * @param x_return_status standard parm - Return Status

2633: * @param p_commit Indicates whether to commit or not at the end
2634: * of procedure
2635: * @param p_api_version standard parm - API Version
2636: * @param p_init_msg_list standard parm - Initialize message list
2637: * @param x_return_status standard parm - Return Status
2638: * @param x_msg_count standard parm - Message Count
2639: * @param x_msg_data standard parm - Message Data
2640: *
2641: * @rep:displayname revoke_permission

Line 2638: * @param x_msg_count standard parm - Message Count

2634: * of procedure
2635: * @param p_api_version standard parm - API Version
2636: * @param p_init_msg_list standard parm - Initialize message list
2637: * @param x_return_status standard parm - Return Status
2638: * @param x_msg_count standard parm - Message Count
2639: * @param x_msg_data standard parm - Message Data
2640: *
2641: * @rep:displayname revoke_permission
2642: *

Line 2639: * @param x_msg_data standard parm - Message Data

2635: * @param p_api_version standard parm - API Version
2636: * @param p_init_msg_list standard parm - Initialize message list
2637: * @param x_return_status standard parm - Return Status
2638: * @param x_msg_count standard parm - Message Count
2639: * @param x_msg_data standard parm - Message Data
2640: *
2641: * @rep:displayname revoke_permission
2642: *
2643: */

Line 2681: -- local variable for standards **

2677: l_new_grant_group_id NUMBER;
2678: l_inherited_flag VARCHAR2(2);
2679: l_inherited_from NUMBER;
2680: l_inheritance_type VARCHAR2(30);
2681: --******** local variable for standards **********
2682: l_api_name CONSTANT VARCHAR2(30) := 'revoke_permission';
2683: l_api_version CONSTANT NUMBER := 1.0;
2684: -- Cursor to apply/propagate changes
2685: CURSOR c_object_grant_group (p_object_grant_group_id NUMBER) IS

Line 2712: -- * Standard Begins **

2708: r_grant c_grants%ROWTYPE;
2709:
2710: BEGIN
2711: SAVEPOINT svpt_revoke_permission;
2712: -- ******* Standard Begins ********
2713: -- Standard call to check for call compatibility.
2714: IF NOT FND_API.Compatible_API_Call (
2715: l_api_version,
2716: p_api_version,

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

2709:
2710: BEGIN
2711: SAVEPOINT svpt_revoke_permission;
2712: -- ******* Standard Begins ********
2713: -- Standard call to check for call compatibility.
2714: IF NOT FND_API.Compatible_API_Call (
2715: l_api_version,
2716: p_api_version,
2717: l_api_name,

Line 3018: -- Standard call to get message count and if count=1, get the message

3014: IF (p_commit = FND_API.g_true) THEN
3015: COMMIT;
3016: END IF;
3017:
3018: -- Standard call to get message count and if count=1, get the message
3019: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
3020: p_data => x_msg_data);
3021:
3022: IF IBC_DEBUG_PVT.debug_enabled THEN

Line 3145: * @param p_api_version standard parm - API Version

3141: * @param p_grantee_user_id User to which permission was originally granted,
3142: * if not especified it means ANYBODY
3143: * @param p_commit Indicates whether to commit or not at the end
3144: * of procedure
3145: * @param p_api_version standard parm - API Version
3146: * @param p_init_msg_list standard parm - Initialize message list
3147: * @param x_return_status standard parm - Return Status
3148: * @param x_msg_count standard parm - Message Count
3149: * @param x_msg_data standard parm - Message Data

Line 3146: * @param p_init_msg_list standard parm - Initialize message list

3142: * if not especified it means ANYBODY
3143: * @param p_commit Indicates whether to commit or not at the end
3144: * of procedure
3145: * @param p_api_version standard parm - API Version
3146: * @param p_init_msg_list standard parm - Initialize message list
3147: * @param x_return_status standard parm - Return Status
3148: * @param x_msg_count standard parm - Message Count
3149: * @param x_msg_data standard parm - Message Data
3150: *

Line 3147: * @param x_return_status standard parm - Return Status

3143: * @param p_commit Indicates whether to commit or not at the end
3144: * of procedure
3145: * @param p_api_version standard parm - API Version
3146: * @param p_init_msg_list standard parm - Initialize message list
3147: * @param x_return_status standard parm - Return Status
3148: * @param x_msg_count standard parm - Message Count
3149: * @param x_msg_data standard parm - Message Data
3150: *
3151: * @rep:displayname revoke_permission

Line 3148: * @param x_msg_count standard parm - Message Count

3144: * of procedure
3145: * @param p_api_version standard parm - API Version
3146: * @param p_init_msg_list standard parm - Initialize message list
3147: * @param x_return_status standard parm - Return Status
3148: * @param x_msg_count standard parm - Message Count
3149: * @param x_msg_data standard parm - Message Data
3150: *
3151: * @rep:displayname revoke_permission
3152: *

Line 3149: * @param x_msg_data standard parm - Message Data

3145: * @param p_api_version standard parm - API Version
3146: * @param p_init_msg_list standard parm - Initialize message list
3147: * @param x_return_status standard parm - Return Status
3148: * @param x_msg_count standard parm - Message Count
3149: * @param x_msg_data standard parm - Message Data
3150: *
3151: * @rep:displayname revoke_permission
3152: *
3153: */

Line 3219: * @param p_api_version standard parm - API Version

3215: * granted, if not especified it means ANYBODY
3216: * @param p_grantee_resource_type Resource Type
3217: * @param p_commit Indicates whether to commit or not at the end
3218: * of procedure
3219: * @param p_api_version standard parm - API Version
3220: * @param p_init_msg_list standard parm - Initialize message list
3221: * @param x_return_status standard parm - Return Status
3222: * @param x_msg_count standard parm - Message Count
3223: * @param x_msg_data standard parm - Message Data

Line 3220: * @param p_init_msg_list standard parm - Initialize message list

3216: * @param p_grantee_resource_type Resource Type
3217: * @param p_commit Indicates whether to commit or not at the end
3218: * of procedure
3219: * @param p_api_version standard parm - API Version
3220: * @param p_init_msg_list standard parm - Initialize message list
3221: * @param x_return_status standard parm - Return Status
3222: * @param x_msg_count standard parm - Message Count
3223: * @param x_msg_data standard parm - Message Data
3224: *

Line 3221: * @param x_return_status standard parm - Return Status

3217: * @param p_commit Indicates whether to commit or not at the end
3218: * of procedure
3219: * @param p_api_version standard parm - API Version
3220: * @param p_init_msg_list standard parm - Initialize message list
3221: * @param x_return_status standard parm - Return Status
3222: * @param x_msg_count standard parm - Message Count
3223: * @param x_msg_data standard parm - Message Data
3224: *
3225: * @rep:displayname revoke_permission

Line 3222: * @param x_msg_count standard parm - Message Count

3218: * of procedure
3219: * @param p_api_version standard parm - API Version
3220: * @param p_init_msg_list standard parm - Initialize message list
3221: * @param x_return_status standard parm - Return Status
3222: * @param x_msg_count standard parm - Message Count
3223: * @param x_msg_data standard parm - Message Data
3224: *
3225: * @rep:displayname revoke_permission
3226: *

Line 3223: * @param x_msg_data standard parm - Message Data

3219: * @param p_api_version standard parm - API Version
3220: * @param p_init_msg_list standard parm - Initialize message list
3221: * @param x_return_status standard parm - Return Status
3222: * @param x_msg_count standard parm - Message Count
3223: * @param x_msg_data standard parm - Message Data
3224: *
3225: * @rep:displayname revoke_permission
3226: *
3227: */

Line 3699: * @param p_api_version standard parm - API Version

3695: * @param p_container_pk5_value value 5 for container's primary key
3696: * @param p_current_user_id Current User Id
3697: * @param x_permission_tbl Output pl/sql table containing all
3698: * different permission codes.
3699: * @param p_api_version standard parm - API Version
3700: * @param p_init_msg_list standard parm - Initialize message list
3701: * @param x_return_status standard parm - Return Status
3702: * @param x_msg_count standard parm - Message Count
3703: * @param x_msg_data standard parm - Message Data

Line 3700: * @param p_init_msg_list standard parm - Initialize message list

3696: * @param p_current_user_id Current User Id
3697: * @param x_permission_tbl Output pl/sql table containing all
3698: * different permission codes.
3699: * @param p_api_version standard parm - API Version
3700: * @param p_init_msg_list standard parm - Initialize message list
3701: * @param x_return_status standard parm - Return Status
3702: * @param x_msg_count standard parm - Message Count
3703: * @param x_msg_data standard parm - Message Data
3704: *

Line 3701: * @param x_return_status standard parm - Return Status

3697: * @param x_permission_tbl Output pl/sql table containing all
3698: * different permission codes.
3699: * @param p_api_version standard parm - API Version
3700: * @param p_init_msg_list standard parm - Initialize message list
3701: * @param x_return_status standard parm - Return Status
3702: * @param x_msg_count standard parm - Message Count
3703: * @param x_msg_data standard parm - Message Data
3704: *
3705: * @rep:displayname get_permissions

Line 3702: * @param x_msg_count standard parm - Message Count

3698: * different permission codes.
3699: * @param p_api_version standard parm - API Version
3700: * @param p_init_msg_list standard parm - Initialize message list
3701: * @param x_return_status standard parm - Return Status
3702: * @param x_msg_count standard parm - Message Count
3703: * @param x_msg_data standard parm - Message Data
3704: *
3705: * @rep:displayname get_permissions
3706: *

Line 3703: * @param x_msg_data standard parm - Message Data

3699: * @param p_api_version standard parm - API Version
3700: * @param p_init_msg_list standard parm - Initialize message list
3701: * @param x_return_status standard parm - Return Status
3702: * @param x_msg_count standard parm - Message Count
3703: * @param x_msg_data standard parm - Message Data
3704: *
3705: * @rep:displayname get_permissions
3706: *
3707: */

Line 3734: -- local variable for standards **

3730: INDEX BY BINARY_INTEGER;
3731: l_result t_vc100_tbl;
3732: l_count NUMBER;
3733: l_perms_lookup_type VARCHAR2(30);
3734: --******** local variable for standards **********
3735: l_api_name CONSTANT VARCHAR2(30) := 'get_permissions';
3736: l_api_version CONSTANT NUMBER := 1.0;
3737: -- Permission variables
3738: l_action VARCHAR2(30);

Line 3792: -- * Standard Begins **

3788: )
3789: )
3790: ORDER BY grant_level asc, grantee_resource_id asc;
3791: BEGIN
3792: -- ******* Standard Begins ********
3793:
3794: -- Standard call to check for call compatibility.
3795: IF NOT FND_API.Compatible_API_Call (
3796: l_api_version,

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

3790: ORDER BY grant_level asc, grantee_resource_id asc;
3791: BEGIN
3792: -- ******* Standard Begins ********
3793:
3794: -- Standard call to check for call compatibility.
3795: IF NOT FND_API.Compatible_API_Call (
3796: l_api_version,
3797: p_api_version,
3798: l_api_name,

Line 3893: -- Standard call to get message count and if count=1, get the message

3889: x_permission_tbl(I) := l_result(I);
3890: END LOOP;
3891: END IF;
3892:
3893: -- Standard call to get message count and if count=1, get the message
3894: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
3895: p_data => x_msg_data);
3896: EXCEPTION
3897: WHEN FND_API.G_EXC_ERROR THEN

Line 4066: * @param p_api_version standard parm - API Version

4062: * @param p_global_value Value to be used as "global" user, by default
4063: * it is 'All'.
4064: * @param x_usernames Output string containing all users with
4065: * permission on object's instance
4066: * @param p_api_version standard parm - API Version
4067: * @param p_init_msg_list standard parm - Initialize message list
4068: * @param x_return_status standard parm - Return Status
4069: * @param x_msg_count standard parm - Message Count
4070: * @param x_msg_data standard parm - Message Data

Line 4067: * @param p_init_msg_list standard parm - Initialize message list

4063: * it is 'All'.
4064: * @param x_usernames Output string containing all users with
4065: * permission on object's instance
4066: * @param p_api_version standard parm - API Version
4067: * @param p_init_msg_list standard parm - Initialize message list
4068: * @param x_return_status standard parm - Return Status
4069: * @param x_msg_count standard parm - Message Count
4070: * @param x_msg_data standard parm - Message Data
4071: *

Line 4068: * @param x_return_status standard parm - Return Status

4064: * @param x_usernames Output string containing all users with
4065: * permission on object's instance
4066: * @param p_api_version standard parm - API Version
4067: * @param p_init_msg_list standard parm - Initialize message list
4068: * @param x_return_status standard parm - Return Status
4069: * @param x_msg_count standard parm - Message Count
4070: * @param x_msg_data standard parm - Message Data
4071: *
4072: * @rep:displayname get_grantee_usernames

Line 4069: * @param x_msg_count standard parm - Message Count

4065: * permission on object's instance
4066: * @param p_api_version standard parm - API Version
4067: * @param p_init_msg_list standard parm - Initialize message list
4068: * @param x_return_status standard parm - Return Status
4069: * @param x_msg_count standard parm - Message Count
4070: * @param x_msg_data standard parm - Message Data
4071: *
4072: * @rep:displayname get_grantee_usernames
4073: *

Line 4070: * @param x_msg_data standard parm - Message Data

4066: * @param p_api_version standard parm - API Version
4067: * @param p_init_msg_list standard parm - Initialize message list
4068: * @param x_return_status standard parm - Return Status
4069: * @param x_msg_count standard parm - Message Count
4070: * @param x_msg_data standard parm - Message Data
4071: *
4072: * @rep:displayname get_grantee_usernames
4073: *
4074: */

Line 4117: -- local variable for standards **

4113: l_inherited_flag VARCHAR2(2);
4114: l_inherited_from NUMBER;
4115: l_inheritance_type VARCHAR2(30);
4116:
4117: --******** local variable for standards **********
4118: l_api_name CONSTANT VARCHAR2(30) := 'get_grantee_usernames';
4119: l_api_version CONSTANT NUMBER := 1.0;
4120:
4121: CURSOR c_user_name(p_user_id NUMBER)

Line 4145: -- * Standard Begins **

4141: ORDER BY grant_level;
4142:
4143:
4144: BEGIN
4145: -- ******* Standard Begins ********
4146:
4147: -- Standard call to check for call compatibility.
4148: IF NOT FND_API.Compatible_API_Call (
4149: l_api_version,

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

4143:
4144: BEGIN
4145: -- ******* Standard Begins ********
4146:
4147: -- Standard call to check for call compatibility.
4148: IF NOT FND_API.Compatible_API_Call (
4149: l_api_version,
4150: p_api_version,
4151: l_api_name,

Line 4287: -- Standard call to get message count and if count=1, get the message

4283: END IF;
4284:
4285: x_usernames := l_result;
4286:
4287: -- Standard call to get message count and if count=1, get the message
4288: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
4289: p_data => x_msg_data);
4290:
4291: IF IBC_DEBUG_PVT.debug_enabled THEN

Line 4414: * @param p_api_version standard parm - API Version

4410: * @param p_container_pk4_value value 4 for container's primary key
4411: * @param p_container_pk5_value value 5 for container's primary key
4412: * @param x_userids Output table containing all users with
4413: * permission on object's instance
4414: * @param p_api_version standard parm - API Version
4415: * @param p_init_msg_list standard parm - Initialize message list
4416: * @param x_return_status standard parm - Return Status
4417: * @param x_msg_count standard parm - Message Count
4418: * @param x_msg_data standard parm - Message Data

Line 4415: * @param p_init_msg_list standard parm - Initialize message list

4411: * @param p_container_pk5_value value 5 for container's primary key
4412: * @param x_userids Output table containing all users with
4413: * permission on object's instance
4414: * @param p_api_version standard parm - API Version
4415: * @param p_init_msg_list standard parm - Initialize message list
4416: * @param x_return_status standard parm - Return Status
4417: * @param x_msg_count standard parm - Message Count
4418: * @param x_msg_data standard parm - Message Data
4419: *

Line 4416: * @param x_return_status standard parm - Return Status

4412: * @param x_userids Output table containing all users with
4413: * permission on object's instance
4414: * @param p_api_version standard parm - API Version
4415: * @param p_init_msg_list standard parm - Initialize message list
4416: * @param x_return_status standard parm - Return Status
4417: * @param x_msg_count standard parm - Message Count
4418: * @param x_msg_data standard parm - Message Data
4419: *
4420: * @rep:displayname get_grantee_userids

Line 4417: * @param x_msg_count standard parm - Message Count

4413: * permission on object's instance
4414: * @param p_api_version standard parm - API Version
4415: * @param p_init_msg_list standard parm - Initialize message list
4416: * @param x_return_status standard parm - Return Status
4417: * @param x_msg_count standard parm - Message Count
4418: * @param x_msg_data standard parm - Message Data
4419: *
4420: * @rep:displayname get_grantee_userids
4421: *

Line 4418: * @param x_msg_data standard parm - Message Data

4414: * @param p_api_version standard parm - API Version
4415: * @param p_init_msg_list standard parm - Initialize message list
4416: * @param x_return_status standard parm - Return Status
4417: * @param x_msg_count standard parm - Message Count
4418: * @param x_msg_data standard parm - Message Data
4419: *
4420: * @rep:displayname get_grantee_userids
4421: *
4422: */

Line 4464: -- local variable for standards **

4460: l_inherited_flag VARCHAR2(2);
4461: l_inherited_from NUMBER;
4462: l_inheritance_type VARCHAR2(30);
4463:
4464: --******** local variable for standards **********
4465: l_api_name CONSTANT VARCHAR2(30) := 'get_grantee_usernames';
4466: l_api_version CONSTANT NUMBER := 1.0;
4467:
4468: CURSOR c_user_name(p_user_id NUMBER)

Line 4490: -- * Standard Begins **

4486: AND action = 'ALLOW'
4487: ORDER BY grant_level;
4488:
4489: BEGIN
4490: -- ******* Standard Begins ********
4491:
4492: -- Standard call to check for call compatibility.
4493: IF NOT FND_API.Compatible_API_Call (
4494: l_api_version,

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

4488:
4489: BEGIN
4490: -- ******* Standard Begins ********
4491:
4492: -- Standard call to check for call compatibility.
4493: IF NOT FND_API.Compatible_API_Call (
4494: l_api_version,
4495: p_api_version,
4496: l_api_name,

Line 4593: -- Standard call to get message count and if count=1, get the message

4589: x_userids(I) := l_result(I);
4590: END LOOP;
4591: END IF;
4592:
4593: -- Standard call to get message count and if count=1, get the message
4594: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
4595: p_data => x_msg_data);
4596: EXCEPTION
4597: WHEN FND_API.G_EXC_ERROR THEN

Line 4666: * @param p_api_version standard parm - API Version

4662: * @param p_container_pk2_value value 2 for container's primary key
4663: * @param p_container_pk3_value value 3 for container's primary key
4664: * @param p_container_pk4_value value 4 for container's primary key
4665: * @param p_container_pk5_value value 5 for container's primary key
4666: * @param p_api_version standard parm - API Version
4667: * @param p_init_msg_list standard parm - Initialize message list
4668: * @param x_inherited_flag Whether instance is inheriting (T) or Not (F)
4669: * @param x_inheritance_type Inheritance Type
4670: * @param x_return_status standard parm - Return Status

Line 4667: * @param p_init_msg_list standard parm - Initialize message list

4663: * @param p_container_pk3_value value 3 for container's primary key
4664: * @param p_container_pk4_value value 4 for container's primary key
4665: * @param p_container_pk5_value value 5 for container's primary key
4666: * @param p_api_version standard parm - API Version
4667: * @param p_init_msg_list standard parm - Initialize message list
4668: * @param x_inherited_flag Whether instance is inheriting (T) or Not (F)
4669: * @param x_inheritance_type Inheritance Type
4670: * @param x_return_status standard parm - Return Status
4671: * @param x_msg_count standard parm - Message Count

Line 4670: * @param x_return_status standard parm - Return Status

4666: * @param p_api_version standard parm - API Version
4667: * @param p_init_msg_list standard parm - Initialize message list
4668: * @param x_inherited_flag Whether instance is inheriting (T) or Not (F)
4669: * @param x_inheritance_type Inheritance Type
4670: * @param x_return_status standard parm - Return Status
4671: * @param x_msg_count standard parm - Message Count
4672: * @param x_msg_data standard parm - Message Data
4673: *
4674: * @rep:displayname get_inheritance_info

Line 4671: * @param x_msg_count standard parm - Message Count

4667: * @param p_init_msg_list standard parm - Initialize message list
4668: * @param x_inherited_flag Whether instance is inheriting (T) or Not (F)
4669: * @param x_inheritance_type Inheritance Type
4670: * @param x_return_status standard parm - Return Status
4671: * @param x_msg_count standard parm - Message Count
4672: * @param x_msg_data standard parm - Message Data
4673: *
4674: * @rep:displayname get_inheritance_info
4675: *

Line 4672: * @param x_msg_data standard parm - Message Data

4668: * @param x_inherited_flag Whether instance is inheriting (T) or Not (F)
4669: * @param x_inheritance_type Inheritance Type
4670: * @param x_return_status standard parm - Return Status
4671: * @param x_msg_count standard parm - Message Count
4672: * @param x_msg_data standard parm - Message Data
4673: *
4674: * @rep:displayname get_inheritance_info
4675: *
4676: */

Line 4707: -- local variable for standards **

4703: l_inherited_flag VARCHAR2(2);
4704: l_inherited_from NUMBER;
4705: l_inheritance_type VARCHAR2(30);
4706:
4707: --******** local variable for standards **********
4708: l_api_name CONSTANT VARCHAR2(30) := 'get_inheritance_info';
4709: l_api_version CONSTANT NUMBER := 1.0;
4710:
4711: BEGIN

Line 4713: -- * Standard Begins **

4709: l_api_version CONSTANT NUMBER := 1.0;
4710:
4711: BEGIN
4712:
4713: -- ******* Standard Begins ********
4714:
4715: -- Standard call to check for call compatibility.
4716: IF NOT FND_API.Compatible_API_Call (
4717: l_api_version,

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

4711: BEGIN
4712:
4713: -- ******* Standard Begins ********
4714:
4715: -- Standard call to check for call compatibility.
4716: IF NOT FND_API.Compatible_API_Call (
4717: l_api_version,
4718: p_api_version,
4719: l_api_name,

Line 4772: -- Standard call to get message count and if count=1, get the message

4768: -- Setting values for OUT parameters.
4769: x_inherited_flag := l_inherited_flag;
4770: x_inheritance_type := l_inheritance_type;
4771:
4772: -- Standard call to get message count and if count=1, get the message
4773: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
4774: p_data => x_msg_data);
4775: EXCEPTION
4776: WHEN FND_API.G_EXC_ERROR THEN