DBA Data[Home] [Help]

APPS.PA_RESOURCE_PUB dependencies on STANDARD

Line 64: -- 04-DEC-96 Update jwhite Applied latest standards.

60: -- PA_CREATE_RESOURCE.Create_Resource_List
61: --
62: -- History:
63: -- xx-AUG-96 Created rkrishna
64: -- 04-DEC-96 Update jwhite Applied latest standards.
65: --
66:
67: PROCEDURE Create_Resource_List
68: (p_commit IN VARCHAR2 := FND_API.G_FALSE,

Line 265: -- 04-DEC-96 Update jwhite Applied latest standards.

261: -- Insert_Members
262: --
263: -- History:
264: -- xx-AUG-96 Created rkrishna
265: -- 04-DEC-96 Update jwhite Applied latest standards.
266: --
267:
268: PROCEDURE Process_Members
269: (p_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 432: -- 04-DEC-96 Update jwhite Applied latest standards.

428: -- Called Subprograms: PA_CREATE_RESOURCE.Create_Resource_list_member
429: --
430: -- History:
431: -- xx-AUG-96 Created rkrishna
432: -- 04-DEC-96 Update jwhite Applied latest standards.
433: -- 26-APR-99 Update risingh added call to get_resource_name
434: -- 12-FEB-03 Update sacgupta Added job_group_id parameter to the
435: -- procedure.
436:

Line 640: -- 08-DEC-96 Update jwhite Applied latest standards and merged

636: --
637: --
638: -- History:
639: -- xx-AUG-96 Created rkrishna
640: -- 08-DEC-96 Update jwhite Applied latest standards and merged
641: -- a 'init_create_members' API with this
642: -- API as per Ashwani's direction.
643: --
644:

Line 691: -- 08-DEC-96 Update jwhite Applied latest standards

687: --
688: --
689: -- History:
690: -- xx-AUG-96 Created rkrishna
691: -- 08-DEC-96 Update jwhite Applied latest standards
692: --
693:
694:
695: PROCEDURE Load_Resource_List

Line 715: -- Standard Api compatibility call

711:
712: BEGIN
713: p_return_status := FND_API.g_ret_sts_success;
714:
715: -- Standard Api compatibility call
716: IF NOT FND_API.Compatible_API_Call ( l_api_version_number ,
717: p_api_version_number ,
718: l_api_name ,
719: G_PKG_NAME )

Line 766: -- 08-DEC-96 Update jwhite Applied latest standards

762: --
763: --
764: -- History:
765: -- xx-AUG-96 Created rkrishna
766: -- 08-DEC-96 Update jwhite Applied latest standards
767: --
768:
769:
770: PROCEDURE Load_Members

Line 793: -- Standard Api compatibility call

789:
790: BEGIN
791: p_return_status := FND_API.g_ret_sts_success;
792:
793: -- Standard Api compatibility call
794:
795: IF NOT FND_API.Compatible_API_Call ( l_api_version_number ,
796: p_api_version_number ,
797: l_api_name ,

Line 877: -- 08-DEC-96 Update jwhite Applied latest standards

873: --
874: --
875: -- History:
876: -- xx-AUG-96 Created rkrishna
877: -- 08-DEC-96 Update jwhite Applied latest standards
878: --
879:
880:
881: PROCEDURE Exec_Create_Resource_List

Line 898: -- Standard Api compatibility call

894:
895: BEGIN
896: p_return_status := FND_API.g_ret_sts_success;
897:
898: -- Standard Api compatibility call
899:
900: IF NOT FND_API.Compatible_API_Call ( l_api_version_number ,
901: p_api_version_number ,
902: l_api_name ,

Line 957: -- 08-DEC-96 Update jwhite Applied latest standards

953: --
954: --
955: -- History:
956: -- xx-AUG-96 Created rkrishna
957: -- 08-DEC-96 Update jwhite Applied latest standards
958: --
959:
960:
961: PROCEDURE Fetch_Resource_List

Line 1025: -- 08-DEC-96 Update jwhite Applied latest standards

1021: --
1022: --
1023: -- History:
1024: -- xx-AUG-96 Created rkrishna
1025: -- 08-DEC-96 Update jwhite Applied latest standards
1026: --
1027:
1028:
1029: PROCEDURE Fetch_Members

Line 1106: -- 08-DEC-96 Update jwhite Applied latest standards and merged

1102: --
1103: --
1104: -- History:
1105: -- xx-AUG-96 Created rkrishna
1106: -- 08-DEC-96 Update jwhite Applied latest standards and merged
1107: -- a 'clear_create_members' API with this
1108: -- API as per Ashwani's direction.
1109: --
1110:

Line 1128: -- 08-DEC-96 Update jwhite Applied latest standards

1124: --
1125: --
1126: -- History:
1127: -- xx-AUG-96 Created rkrishna
1128: -- 08-DEC-96 Update jwhite Applied latest standards
1129: --
1130:
1131: PROCEDURE Update_Resource_List
1132: (p_commit IN VARCHAR2 := FND_API.G_FALSE,

Line 1241: -- Standard Api compatibility call

1237:
1238:
1239: BEGIN
1240:
1241: -- Standard Api compatibility call
1242: SAVEPOINT Update_Resource_List_Pub;
1243:
1244: IF NOT FND_API.Compatible_API_Call ( l_api_version_number ,
1245: p_api_version_number ,

Line 1730: -- 04-DEC-96 Update jwhite Applied latest standards.

1726: -- Called Subprograms:
1727: --
1728: -- History:
1729: -- xx-AUG-96 Created rkrishna
1730: -- 04-DEC-96 Update jwhite Applied latest standards.
1731: --
1732:
1733:
1734: PROCEDURE Init_Update_Members IS

Line 1767: -- 04-DEC-96 Update jwhite Applied latest standards.

1763: -- Called Subprograms: Update_Resource_List
1764: --
1765: -- History:
1766: -- xx-AUG-96 Created rkrishna
1767: -- 04-DEC-96 Update jwhite Applied latest standards.
1768: --
1769:
1770:
1771: PROCEDURE Exec_Update_Resource_List

Line 1789: -- Standard Api compatibility call

1785: BEGIN
1786:
1787: p_return_status := FND_API.g_ret_sts_success;
1788:
1789: -- Standard Api compatibility call
1790:
1791: IF NOT FND_API.Compatible_API_Call ( l_api_version_number ,
1792: p_api_version_number ,
1793: l_api_name ,

Line 1853: -- 04-DEC-96 Update jwhite Applied latest standards.

1849: -- Called Subprograms: Init_Update_Members
1850: --
1851: -- History:
1852: -- xx-AUG-96 Created rkrishna
1853: -- 04-DEC-96 Update jwhite Applied latest standards.
1854: --
1855:
1856: PROCEDURE Clear_Update_Members IS
1857: BEGIN

Line 1871: -- 04-DEC-96 Update jwhite Applied latest standards.

1867: -- Called Subprograms:
1868: --
1869: -- History:
1870: -- xx-AUG-96 Created rkrishna
1871: -- 04-DEC-96 Update jwhite Applied latest standards.
1872: -- 02-OCT-98 Updated jxnaraya validations for deletion modified
1873:
1874:
1875: PROCEDURE Delete_Resource_list

Line 1915: -- Standard Api compatibility call

1911: BEGIN
1912:
1913: SAVEPOINT Delete_Resource_List_Pub;
1914:
1915: -- Standard Api compatibility call
1916:
1917: IF NOT FND_API.Compatible_API_Call ( l_api_version_number ,
1918: p_api_version_number ,
1919: l_api_name ,

Line 2138: -- 04-DEC-96 Update jwhite Applied latest standards.

2134: -- , Insert_Members
2135: --
2136: -- History:
2137: -- xx-AUG-96 Created rkrishna
2138: -- 04-DEC-96 Update jwhite Applied latest standards.
2139: --
2140:
2141: PROCEDURE Add_Resource_List_Member
2142: (p_commit IN VARCHAR2 := FND_API.G_FALSE,

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

2245: p_return_status := FND_API.g_ret_sts_error;
2246: RAISE FND_API.G_EXC_ERROR;
2247: END IF;
2248:
2249: -- Standard call to check for call compatibility.
2250: IF NOT FND_API.Compatible_API_Call ( l_api_version_number ,
2251: p_api_version_number ,
2252: l_api_name ,
2253: G_PKG_NAME )

Line 2486: -- 04-DEC-96 Update jwhite Applied latest standards.

2482: -- , Convert_alias_to_id
2483: --
2484: -- History:
2485: -- xx-AUG-96 Created rkrishna
2486: -- 04-DEC-96 Update jwhite Applied latest standards.
2487: --
2488:
2489: PROCEDURE Update_Resource_List_Member
2490: ( p_commit IN VARCHAR2 := FND_API.G_FALSE,

Line 2589: -- Standard Api compatibility call

2585:
2586:
2587: BEGIN
2588:
2589: -- Standard Api compatibility call
2590:
2591: SAVEPOINT Update_Resource_List_Mbr_Pub;
2592:
2593: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2902: -- 04-DEC-96 Update jwhite Applied latest standards.

2898: -- Called Subprograms:
2899: --
2900: -- History:
2901: -- xx-AUG-96 Created rkrishna
2902: -- 04-DEC-96 Update jwhite Applied latest standards.
2903: -- 02-OCT-98 Update jxnaraya validations for deletion modified
2904:
2905: PROCEDURE Delete_Resource_list_Member
2906: ( p_commit IN VARCHAR2 := FND_API.G_FALSE,

Line 2962: -- Standard Api compatibility call

2958:
2959: BEGIN
2960: SAVEPOINT Delete_Resource_List_Mbr_Pub;
2961:
2962: -- Standard Api compatibility call
2963:
2964: IF NOT FND_API.Compatible_API_Call ( l_api_version_number ,
2965: p_api_version_number ,
2966: l_api_name ,

Line 3193: -- 04-DEC-96 Update jwhite Applied latest standards.

3189: -- the cursor 'order by' clauses.
3190: --
3191: -- History:
3192: -- xx-AUG-96 Created rkrishna
3193: -- 04-DEC-96 Update jwhite Applied latest standards.
3194: --
3195:
3196: PROCEDURE Sort_Resource_List_Members
3197: ( p_commit IN VARCHAR2 := FND_API.G_FALSE,

Line 3296: -- Standard Api compatibility call

3292: BEGIN
3293:
3294: SAVEPOINT Sort_Resource_List_Mbr_Pub;
3295:
3296: -- Standard Api compatibility call
3297:
3298: IF NOT FND_API.Compatible_API_Call ( l_api_version_number ,
3299: p_api_version_number ,
3300: l_api_name ,

Line 3533: -- 04-DEC-96 Update jwhite Applied latest standards.

3529: -- Called Subprograms:
3530: --
3531: -- History:
3532: -- xx-AUG-96 Created rkrishna
3533: -- 04-DEC-96 Update jwhite Applied latest standards.
3534: --
3535:
3536:
3537: FUNCTION Fetch_Resource_list_id

Line 3591: -- 04-DEC-96 Update jwhite Applied latest standards.

3587: -- Called Subprograms: Fetch_Resource_list_id
3588: --
3589: -- History:
3590: -- xx-AUG-96 Created rkrishna
3591: -- 04-DEC-96 Update jwhite Applied latest standards.
3592: --
3593:
3594:
3595: PROCEDURE Convert_List_Name_To_Id

Line 3695: -- 04-DEC-96 Update jwhite Applied latest standards.

3691: -- Called Subprograms:
3692: --
3693: -- History:
3694: -- xx-AUG-96 Created rkrishna
3695: -- 04-DEC-96 Update jwhite Applied latest standards.
3696: --
3697:
3698:
3699: FUNCTION Fetch_Resource_list_Member_id

Line 3756: -- 04-DEC-96 Update jwhite Applied latest standards.

3752: -- Called Subprograms: Fetch_Resource_list_Member_id
3753: --
3754: -- History:
3755: -- xx-AUG-96 Created rkrishna
3756: -- 04-DEC-96 Update jwhite Applied latest standards.
3757: --
3758:
3759: PROCEDURE Convert_Alias_To_Id
3760: (