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.OKC_ARTICLE_ADOPTIONS_PVT dependencies on OKC_ARTICLE_ADOPTIONS

Line 1: PACKAGE BODY OKC_ARTICLE_ADOPTIONS_PVT AS

1: PACKAGE BODY OKC_ARTICLE_ADOPTIONS_PVT AS
2: /* $Header: OKCVADPB.pls 120.0 2005/05/25 22:38:22 appldev noship $ */
3:
4: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
5:

Line 30: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_ARTICLE_ADOPTIONS_PVT';

26: G_RECORD_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_RECORD_VALID_LEVEL;
27: ---------------------------------------------------------------------------
28: -- GLOBAL VARIABLES
29: ---------------------------------------------------------------------------
30: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_ARTICLE_ADOPTIONS_PVT';
31: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
32:
33: ------------------------------------------------------------------------------
34: -- GLOBAL CONSTANTS

Line 104: -- FUNCTION get_rec for: OKC_ARTICLE_ADOPTIONS

100:
101: END Get_Seq_Id;
102: */
103: ---------------------------------------------------------------------------
104: -- FUNCTION get_rec for: OKC_ARTICLE_ADOPTIONS
105: ---------------------------------------------------------------------------
106: FUNCTION Get_Rec (
107: p_global_article_version_id IN OUT NOCOPY NUMBER,
108: p_local_org_id IN NUMBER,

Line 132: FROM OKC_ARTICLE_ADOPTIONS t

128: CREATION_DATE,
129: LAST_UPDATED_BY,
130: LAST_UPDATE_LOGIN,
131: LAST_UPDATE_DATE
132: FROM OKC_ARTICLE_ADOPTIONS t
133: WHERE t.LOCAL_ORG_ID = cp_local_org_id and
134: t.LOCAL_ARTICLE_VERSION_ID = cp_local_article_version_id;
135:
136: CURSOR OKC_ADOPTIONS_wo_lv_csr (cp_global_article_version_id IN NUMBER,cp_local_org_id IN NUMBER) IS

Line 146: FROM OKC_ARTICLE_ADOPTIONS t

142: CREATION_DATE,
143: LAST_UPDATED_BY,
144: LAST_UPDATE_LOGIN,
145: LAST_UPDATE_DATE
146: FROM OKC_ARTICLE_ADOPTIONS t
147: WHERE t.GLOBAL_ARTICLE_VERSION_ID = cp_global_article_version_id and
148: t.LOCAL_ORG_ID = cp_local_org_id and
149: t.LOCAL_ARTICLE_VERSION_ID IS NULL;
150:

Line 223: -- Set_Attributes for:OKC_ARTICLE_ADOPTIONS --

219:
220: END Get_Rec;
221:
222: -----------------------------------------
223: -- Set_Attributes for:OKC_ARTICLE_ADOPTIONS --
224: -----------------------------------------
225: FUNCTION Set_Attributes(
226: p_global_article_version_id IN OUT NOCOPY NUMBER,
227: p_adoption_type IN VARCHAR2,

Line 237: l_object_version_number OKC_ARTICLE_ADOPTIONS.OBJECT_VERSION_NUMBER%TYPE;

233: x_adoption_type OUT NOCOPY VARCHAR2,
234: x_adoption_status OUT NOCOPY VARCHAR2
235: ) RETURN VARCHAR2 IS
236: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
237: l_object_version_number OKC_ARTICLE_ADOPTIONS.OBJECT_VERSION_NUMBER%TYPE;
238: l_created_by OKC_ARTICLE_ADOPTIONS.CREATED_BY%TYPE;
239: l_creation_date OKC_ARTICLE_ADOPTIONS.CREATION_DATE%TYPE;
240: l_last_updated_by OKC_ARTICLE_ADOPTIONS.LAST_UPDATED_BY%TYPE;
241: l_last_update_login OKC_ARTICLE_ADOPTIONS.LAST_UPDATE_LOGIN%TYPE;

Line 238: l_created_by OKC_ARTICLE_ADOPTIONS.CREATED_BY%TYPE;

234: x_adoption_status OUT NOCOPY VARCHAR2
235: ) RETURN VARCHAR2 IS
236: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
237: l_object_version_number OKC_ARTICLE_ADOPTIONS.OBJECT_VERSION_NUMBER%TYPE;
238: l_created_by OKC_ARTICLE_ADOPTIONS.CREATED_BY%TYPE;
239: l_creation_date OKC_ARTICLE_ADOPTIONS.CREATION_DATE%TYPE;
240: l_last_updated_by OKC_ARTICLE_ADOPTIONS.LAST_UPDATED_BY%TYPE;
241: l_last_update_login OKC_ARTICLE_ADOPTIONS.LAST_UPDATE_LOGIN%TYPE;
242: l_last_update_date OKC_ARTICLE_ADOPTIONS.LAST_UPDATE_DATE%TYPE;

Line 239: l_creation_date OKC_ARTICLE_ADOPTIONS.CREATION_DATE%TYPE;

235: ) RETURN VARCHAR2 IS
236: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
237: l_object_version_number OKC_ARTICLE_ADOPTIONS.OBJECT_VERSION_NUMBER%TYPE;
238: l_created_by OKC_ARTICLE_ADOPTIONS.CREATED_BY%TYPE;
239: l_creation_date OKC_ARTICLE_ADOPTIONS.CREATION_DATE%TYPE;
240: l_last_updated_by OKC_ARTICLE_ADOPTIONS.LAST_UPDATED_BY%TYPE;
241: l_last_update_login OKC_ARTICLE_ADOPTIONS.LAST_UPDATE_LOGIN%TYPE;
242: l_last_update_date OKC_ARTICLE_ADOPTIONS.LAST_UPDATE_DATE%TYPE;
243: BEGIN

Line 240: l_last_updated_by OKC_ARTICLE_ADOPTIONS.LAST_UPDATED_BY%TYPE;

236: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
237: l_object_version_number OKC_ARTICLE_ADOPTIONS.OBJECT_VERSION_NUMBER%TYPE;
238: l_created_by OKC_ARTICLE_ADOPTIONS.CREATED_BY%TYPE;
239: l_creation_date OKC_ARTICLE_ADOPTIONS.CREATION_DATE%TYPE;
240: l_last_updated_by OKC_ARTICLE_ADOPTIONS.LAST_UPDATED_BY%TYPE;
241: l_last_update_login OKC_ARTICLE_ADOPTIONS.LAST_UPDATE_LOGIN%TYPE;
242: l_last_update_date OKC_ARTICLE_ADOPTIONS.LAST_UPDATE_DATE%TYPE;
243: BEGIN
244: IF (l_debug = 'Y') THEN

Line 241: l_last_update_login OKC_ARTICLE_ADOPTIONS.LAST_UPDATE_LOGIN%TYPE;

237: l_object_version_number OKC_ARTICLE_ADOPTIONS.OBJECT_VERSION_NUMBER%TYPE;
238: l_created_by OKC_ARTICLE_ADOPTIONS.CREATED_BY%TYPE;
239: l_creation_date OKC_ARTICLE_ADOPTIONS.CREATION_DATE%TYPE;
240: l_last_updated_by OKC_ARTICLE_ADOPTIONS.LAST_UPDATED_BY%TYPE;
241: l_last_update_login OKC_ARTICLE_ADOPTIONS.LAST_UPDATE_LOGIN%TYPE;
242: l_last_update_date OKC_ARTICLE_ADOPTIONS.LAST_UPDATE_DATE%TYPE;
243: BEGIN
244: IF (l_debug = 'Y') THEN
245: Okc_Debug.Log('700: Entered Set_Attributes ', 2);

Line 242: l_last_update_date OKC_ARTICLE_ADOPTIONS.LAST_UPDATE_DATE%TYPE;

238: l_created_by OKC_ARTICLE_ADOPTIONS.CREATED_BY%TYPE;
239: l_creation_date OKC_ARTICLE_ADOPTIONS.CREATION_DATE%TYPE;
240: l_last_updated_by OKC_ARTICLE_ADOPTIONS.LAST_UPDATED_BY%TYPE;
241: l_last_update_login OKC_ARTICLE_ADOPTIONS.LAST_UPDATE_LOGIN%TYPE;
242: l_last_update_date OKC_ARTICLE_ADOPTIONS.LAST_UPDATE_DATE%TYPE;
243: BEGIN
244: IF (l_debug = 'Y') THEN
245: Okc_Debug.Log('700: Entered Set_Attributes ', 2);
246: END IF;

Line 331: -- Validate_Attributes for: OKC_ARTICLE_ADOPTIONS --

327:
328: END Set_Attributes ;
329:
330: ----------------------------------------------
331: -- Validate_Attributes for: OKC_ARTICLE_ADOPTIONS --
332: ----------------------------------------------
333: FUNCTION Validate_Attributes (
334: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
335:

Line 546: -- Validate_Record for:OKC_ARTICLE_ADOPTIONS --

542: -- PROCEDURE Validate_Record
543: -- It calls Item Level Validations and then makes Record Level Validations
544: ---------------------------------------------------------------------------
545: ------------------------------------------
546: -- Validate_Record for:OKC_ARTICLE_ADOPTIONS --
547: ------------------------------------------
548: FUNCTION Validate_Record (
549: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
550:

Line 617: -- validate_row for:OKC_ARTICLE_ADOPTIONS --

613: ---------------------------------------------------------------------------
614: -- PROCEDURE validate_row
615: ---------------------------------------------------------------------------
616: ---------------------------------------
617: -- validate_row for:OKC_ARTICLE_ADOPTIONS --
618: ---------------------------------------
619: PROCEDURE validate_row(
620: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
621:

Line 634: l_global_article_version_id OKC_ARTICLE_ADOPTIONS.GLOBAL_ARTICLE_VERSION_ID%TYPE;

630:
631:
632: p_object_version_number IN NUMBER
633: ) IS
634: l_global_article_version_id OKC_ARTICLE_ADOPTIONS.GLOBAL_ARTICLE_VERSION_ID%TYPE;
635: l_adoption_type OKC_ARTICLE_ADOPTIONS.ADOPTION_TYPE%TYPE;
636: l_adoption_status OKC_ARTICLE_ADOPTIONS.ADOPTION_STATUS%TYPE;
637: l_object_version_number OKC_ARTICLE_ADOPTIONS.OBJECT_VERSION_NUMBER%TYPE;
638: l_created_by OKC_ARTICLE_ADOPTIONS.CREATED_BY%TYPE;

Line 635: l_adoption_type OKC_ARTICLE_ADOPTIONS.ADOPTION_TYPE%TYPE;

631:
632: p_object_version_number IN NUMBER
633: ) IS
634: l_global_article_version_id OKC_ARTICLE_ADOPTIONS.GLOBAL_ARTICLE_VERSION_ID%TYPE;
635: l_adoption_type OKC_ARTICLE_ADOPTIONS.ADOPTION_TYPE%TYPE;
636: l_adoption_status OKC_ARTICLE_ADOPTIONS.ADOPTION_STATUS%TYPE;
637: l_object_version_number OKC_ARTICLE_ADOPTIONS.OBJECT_VERSION_NUMBER%TYPE;
638: l_created_by OKC_ARTICLE_ADOPTIONS.CREATED_BY%TYPE;
639: l_creation_date OKC_ARTICLE_ADOPTIONS.CREATION_DATE%TYPE;

Line 636: l_adoption_status OKC_ARTICLE_ADOPTIONS.ADOPTION_STATUS%TYPE;

632: p_object_version_number IN NUMBER
633: ) IS
634: l_global_article_version_id OKC_ARTICLE_ADOPTIONS.GLOBAL_ARTICLE_VERSION_ID%TYPE;
635: l_adoption_type OKC_ARTICLE_ADOPTIONS.ADOPTION_TYPE%TYPE;
636: l_adoption_status OKC_ARTICLE_ADOPTIONS.ADOPTION_STATUS%TYPE;
637: l_object_version_number OKC_ARTICLE_ADOPTIONS.OBJECT_VERSION_NUMBER%TYPE;
638: l_created_by OKC_ARTICLE_ADOPTIONS.CREATED_BY%TYPE;
639: l_creation_date OKC_ARTICLE_ADOPTIONS.CREATION_DATE%TYPE;
640: l_last_updated_by OKC_ARTICLE_ADOPTIONS.LAST_UPDATED_BY%TYPE;

Line 637: l_object_version_number OKC_ARTICLE_ADOPTIONS.OBJECT_VERSION_NUMBER%TYPE;

633: ) IS
634: l_global_article_version_id OKC_ARTICLE_ADOPTIONS.GLOBAL_ARTICLE_VERSION_ID%TYPE;
635: l_adoption_type OKC_ARTICLE_ADOPTIONS.ADOPTION_TYPE%TYPE;
636: l_adoption_status OKC_ARTICLE_ADOPTIONS.ADOPTION_STATUS%TYPE;
637: l_object_version_number OKC_ARTICLE_ADOPTIONS.OBJECT_VERSION_NUMBER%TYPE;
638: l_created_by OKC_ARTICLE_ADOPTIONS.CREATED_BY%TYPE;
639: l_creation_date OKC_ARTICLE_ADOPTIONS.CREATION_DATE%TYPE;
640: l_last_updated_by OKC_ARTICLE_ADOPTIONS.LAST_UPDATED_BY%TYPE;
641: l_last_update_login OKC_ARTICLE_ADOPTIONS.LAST_UPDATE_LOGIN%TYPE;

Line 638: l_created_by OKC_ARTICLE_ADOPTIONS.CREATED_BY%TYPE;

634: l_global_article_version_id OKC_ARTICLE_ADOPTIONS.GLOBAL_ARTICLE_VERSION_ID%TYPE;
635: l_adoption_type OKC_ARTICLE_ADOPTIONS.ADOPTION_TYPE%TYPE;
636: l_adoption_status OKC_ARTICLE_ADOPTIONS.ADOPTION_STATUS%TYPE;
637: l_object_version_number OKC_ARTICLE_ADOPTIONS.OBJECT_VERSION_NUMBER%TYPE;
638: l_created_by OKC_ARTICLE_ADOPTIONS.CREATED_BY%TYPE;
639: l_creation_date OKC_ARTICLE_ADOPTIONS.CREATION_DATE%TYPE;
640: l_last_updated_by OKC_ARTICLE_ADOPTIONS.LAST_UPDATED_BY%TYPE;
641: l_last_update_login OKC_ARTICLE_ADOPTIONS.LAST_UPDATE_LOGIN%TYPE;
642: l_last_update_date OKC_ARTICLE_ADOPTIONS.LAST_UPDATE_DATE%TYPE;

Line 639: l_creation_date OKC_ARTICLE_ADOPTIONS.CREATION_DATE%TYPE;

635: l_adoption_type OKC_ARTICLE_ADOPTIONS.ADOPTION_TYPE%TYPE;
636: l_adoption_status OKC_ARTICLE_ADOPTIONS.ADOPTION_STATUS%TYPE;
637: l_object_version_number OKC_ARTICLE_ADOPTIONS.OBJECT_VERSION_NUMBER%TYPE;
638: l_created_by OKC_ARTICLE_ADOPTIONS.CREATED_BY%TYPE;
639: l_creation_date OKC_ARTICLE_ADOPTIONS.CREATION_DATE%TYPE;
640: l_last_updated_by OKC_ARTICLE_ADOPTIONS.LAST_UPDATED_BY%TYPE;
641: l_last_update_login OKC_ARTICLE_ADOPTIONS.LAST_UPDATE_LOGIN%TYPE;
642: l_last_update_date OKC_ARTICLE_ADOPTIONS.LAST_UPDATE_DATE%TYPE;
643: BEGIN

Line 640: l_last_updated_by OKC_ARTICLE_ADOPTIONS.LAST_UPDATED_BY%TYPE;

636: l_adoption_status OKC_ARTICLE_ADOPTIONS.ADOPTION_STATUS%TYPE;
637: l_object_version_number OKC_ARTICLE_ADOPTIONS.OBJECT_VERSION_NUMBER%TYPE;
638: l_created_by OKC_ARTICLE_ADOPTIONS.CREATED_BY%TYPE;
639: l_creation_date OKC_ARTICLE_ADOPTIONS.CREATION_DATE%TYPE;
640: l_last_updated_by OKC_ARTICLE_ADOPTIONS.LAST_UPDATED_BY%TYPE;
641: l_last_update_login OKC_ARTICLE_ADOPTIONS.LAST_UPDATE_LOGIN%TYPE;
642: l_last_update_date OKC_ARTICLE_ADOPTIONS.LAST_UPDATE_DATE%TYPE;
643: BEGIN
644:

Line 641: l_last_update_login OKC_ARTICLE_ADOPTIONS.LAST_UPDATE_LOGIN%TYPE;

637: l_object_version_number OKC_ARTICLE_ADOPTIONS.OBJECT_VERSION_NUMBER%TYPE;
638: l_created_by OKC_ARTICLE_ADOPTIONS.CREATED_BY%TYPE;
639: l_creation_date OKC_ARTICLE_ADOPTIONS.CREATION_DATE%TYPE;
640: l_last_updated_by OKC_ARTICLE_ADOPTIONS.LAST_UPDATED_BY%TYPE;
641: l_last_update_login OKC_ARTICLE_ADOPTIONS.LAST_UPDATE_LOGIN%TYPE;
642: l_last_update_date OKC_ARTICLE_ADOPTIONS.LAST_UPDATE_DATE%TYPE;
643: BEGIN
644:
645: IF (l_debug = 'Y') THEN

Line 642: l_last_update_date OKC_ARTICLE_ADOPTIONS.LAST_UPDATE_DATE%TYPE;

638: l_created_by OKC_ARTICLE_ADOPTIONS.CREATED_BY%TYPE;
639: l_creation_date OKC_ARTICLE_ADOPTIONS.CREATION_DATE%TYPE;
640: l_last_updated_by OKC_ARTICLE_ADOPTIONS.LAST_UPDATED_BY%TYPE;
641: l_last_update_login OKC_ARTICLE_ADOPTIONS.LAST_UPDATE_LOGIN%TYPE;
642: l_last_update_date OKC_ARTICLE_ADOPTIONS.LAST_UPDATE_DATE%TYPE;
643: BEGIN
644:
645: IF (l_debug = 'Y') THEN
646: Okc_Debug.Log('3100: Entered validate_row', 2);

Line 712: -- Insert_Row for:OKC_ARTICLE_ADOPTIONS --

708: ---------------------------------------------------------------------------
709: -- PROCEDURE Insert_Row
710: ---------------------------------------------------------------------------
711: -------------------------------------
712: -- Insert_Row for:OKC_ARTICLE_ADOPTIONS --
713: -------------------------------------
714: FUNCTION Insert_Row(
715: p_global_article_version_id IN NUMBER,
716: p_adoption_type IN VARCHAR2,

Line 735: INSERT INTO OKC_ARTICLE_ADOPTIONS(

731: IF (l_debug = 'Y') THEN
732: Okc_Debug.Log('3600: Entered Insert_Row function', 2);
733: END IF;
734:
735: INSERT INTO OKC_ARTICLE_ADOPTIONS(
736: GLOBAL_ARTICLE_VERSION_ID,
737: ADOPTION_TYPE,
738: LOCAL_ORG_ID,
739: LOCAL_ARTICLE_VERSION_ID,

Line 786: -- Insert_Row for:OKC_ARTICLE_ADOPTIONS --

782: END Insert_Row;
783:
784:
785: -------------------------------------
786: -- Insert_Row for:OKC_ARTICLE_ADOPTIONS --
787: -------------------------------------
788: PROCEDURE Insert_Row(
789: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
790: x_return_status OUT NOCOPY VARCHAR2,

Line 806: l_object_version_number OKC_ARTICLE_ADOPTIONS.OBJECT_VERSION_NUMBER%TYPE;

802: x_local_article_version_id OUT NOCOPY NUMBER
803:
804: ) IS
805:
806: l_object_version_number OKC_ARTICLE_ADOPTIONS.OBJECT_VERSION_NUMBER%TYPE;
807: l_created_by OKC_ARTICLE_ADOPTIONS.CREATED_BY%TYPE;
808: l_creation_date OKC_ARTICLE_ADOPTIONS.CREATION_DATE%TYPE;
809: l_last_updated_by OKC_ARTICLE_ADOPTIONS.LAST_UPDATED_BY%TYPE;
810: l_last_update_login OKC_ARTICLE_ADOPTIONS.LAST_UPDATE_LOGIN%TYPE;

Line 807: l_created_by OKC_ARTICLE_ADOPTIONS.CREATED_BY%TYPE;

803:
804: ) IS
805:
806: l_object_version_number OKC_ARTICLE_ADOPTIONS.OBJECT_VERSION_NUMBER%TYPE;
807: l_created_by OKC_ARTICLE_ADOPTIONS.CREATED_BY%TYPE;
808: l_creation_date OKC_ARTICLE_ADOPTIONS.CREATION_DATE%TYPE;
809: l_last_updated_by OKC_ARTICLE_ADOPTIONS.LAST_UPDATED_BY%TYPE;
810: l_last_update_login OKC_ARTICLE_ADOPTIONS.LAST_UPDATE_LOGIN%TYPE;
811: l_last_update_date OKC_ARTICLE_ADOPTIONS.LAST_UPDATE_DATE%TYPE;

Line 808: l_creation_date OKC_ARTICLE_ADOPTIONS.CREATION_DATE%TYPE;

804: ) IS
805:
806: l_object_version_number OKC_ARTICLE_ADOPTIONS.OBJECT_VERSION_NUMBER%TYPE;
807: l_created_by OKC_ARTICLE_ADOPTIONS.CREATED_BY%TYPE;
808: l_creation_date OKC_ARTICLE_ADOPTIONS.CREATION_DATE%TYPE;
809: l_last_updated_by OKC_ARTICLE_ADOPTIONS.LAST_UPDATED_BY%TYPE;
810: l_last_update_login OKC_ARTICLE_ADOPTIONS.LAST_UPDATE_LOGIN%TYPE;
811: l_last_update_date OKC_ARTICLE_ADOPTIONS.LAST_UPDATE_DATE%TYPE;
812: BEGIN

Line 809: l_last_updated_by OKC_ARTICLE_ADOPTIONS.LAST_UPDATED_BY%TYPE;

805:
806: l_object_version_number OKC_ARTICLE_ADOPTIONS.OBJECT_VERSION_NUMBER%TYPE;
807: l_created_by OKC_ARTICLE_ADOPTIONS.CREATED_BY%TYPE;
808: l_creation_date OKC_ARTICLE_ADOPTIONS.CREATION_DATE%TYPE;
809: l_last_updated_by OKC_ARTICLE_ADOPTIONS.LAST_UPDATED_BY%TYPE;
810: l_last_update_login OKC_ARTICLE_ADOPTIONS.LAST_UPDATE_LOGIN%TYPE;
811: l_last_update_date OKC_ARTICLE_ADOPTIONS.LAST_UPDATE_DATE%TYPE;
812: BEGIN
813:

Line 810: l_last_update_login OKC_ARTICLE_ADOPTIONS.LAST_UPDATE_LOGIN%TYPE;

806: l_object_version_number OKC_ARTICLE_ADOPTIONS.OBJECT_VERSION_NUMBER%TYPE;
807: l_created_by OKC_ARTICLE_ADOPTIONS.CREATED_BY%TYPE;
808: l_creation_date OKC_ARTICLE_ADOPTIONS.CREATION_DATE%TYPE;
809: l_last_updated_by OKC_ARTICLE_ADOPTIONS.LAST_UPDATED_BY%TYPE;
810: l_last_update_login OKC_ARTICLE_ADOPTIONS.LAST_UPDATE_LOGIN%TYPE;
811: l_last_update_date OKC_ARTICLE_ADOPTIONS.LAST_UPDATE_DATE%TYPE;
812: BEGIN
813:
814: x_return_status := G_RET_STS_SUCCESS;

Line 811: l_last_update_date OKC_ARTICLE_ADOPTIONS.LAST_UPDATE_DATE%TYPE;

807: l_created_by OKC_ARTICLE_ADOPTIONS.CREATED_BY%TYPE;
808: l_creation_date OKC_ARTICLE_ADOPTIONS.CREATION_DATE%TYPE;
809: l_last_updated_by OKC_ARTICLE_ADOPTIONS.LAST_UPDATED_BY%TYPE;
810: l_last_update_login OKC_ARTICLE_ADOPTIONS.LAST_UPDATE_LOGIN%TYPE;
811: l_last_update_date OKC_ARTICLE_ADOPTIONS.LAST_UPDATE_DATE%TYPE;
812: BEGIN
813:
814: x_return_status := G_RET_STS_SUCCESS;
815:

Line 917: -- Lock_Row for:OKC_ARTICLE_ADOPTIONS --

913: ---------------------------------------------------------------------------
914: -- PROCEDURE Lock_Row
915: ---------------------------------------------------------------------------
916: -----------------------------------
917: -- Lock_Row for:OKC_ARTICLE_ADOPTIONS --
918: -----------------------------------
919: FUNCTION Lock_Row(
920: p_global_article_version_id IN NUMBER,
921: p_local_org_id IN NUMBER,

Line 931: FROM OKC_ARTICLE_ADOPTIONS

927: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
928:
929: CURSOR lock_csr (cp_local_org_id NUMBER, cp_local_article_version_id NUMBER, cp_object_version_number NUMBER) IS
930: SELECT object_version_number
931: FROM OKC_ARTICLE_ADOPTIONS
932: WHERE LOCAL_ORG_ID = cp_local_org_id AND
933: (object_version_number = cp_object_version_number OR cp_object_version_number IS NULL) AND
934: LOCAL_ARTICLE_VERSION_ID = cp_local_article_version_id
935: FOR UPDATE OF object_version_number NOWAIT;

Line 939: FROM OKC_ARTICLE_ADOPTIONS

935: FOR UPDATE OF object_version_number NOWAIT;
936:
937: CURSOR lchk_csr (cp_local_org_id NUMBER, cp_local_article_version_id NUMBER) IS
938: SELECT object_version_number
939: FROM OKC_ARTICLE_ADOPTIONS
940: WHERE LOCAL_ORG_ID = cp_local_org_id AND
941: LOCAL_ARTICLE_VERSION_ID = cp_local_article_version_id;
942:
943: CURSOR lock_wo_lv_csr (cp_global_article_version_id NUMBER, cp_local_org_id NUMBER, cp_object_version_number NUMBER) IS

Line 945: FROM OKC_ARTICLE_ADOPTIONS

941: LOCAL_ARTICLE_VERSION_ID = cp_local_article_version_id;
942:
943: CURSOR lock_wo_lv_csr (cp_global_article_version_id NUMBER, cp_local_org_id NUMBER, cp_object_version_number NUMBER) IS
944: SELECT object_version_number
945: FROM OKC_ARTICLE_ADOPTIONS
946: WHERE GLOBAL_ARTICLE_VERSION_ID = cp_global_article_version_id AND
947: LOCAL_ORG_ID = cp_local_org_id AND
948: (object_version_number = cp_object_version_number OR cp_object_version_number IS NULL) AND
949: LOCAL_ARTICLE_VERSION_ID IS NULL

Line 954: FROM OKC_ARTICLE_ADOPTIONS

950: FOR UPDATE OF object_version_number NOWAIT;
951:
952: CURSOR lchk_wo_lv_csr (cp_global_article_version_id NUMBER, cp_local_org_id NUMBER) IS
953: SELECT object_version_number
954: FROM OKC_ARTICLE_ADOPTIONS
955: WHERE GLOBAL_ARTICLE_VERSION_ID = cp_global_article_version_id AND LOCAL_ORG_ID = cp_local_org_id AND LOCAL_ARTICLE_VERSION_ID IS NULL;
956:
957: l_return_status VARCHAR2(1);
958:

Line 959: l_object_version_number OKC_ARTICLE_ADOPTIONS.OBJECT_VERSION_NUMBER%TYPE;

955: WHERE GLOBAL_ARTICLE_VERSION_ID = cp_global_article_version_id AND LOCAL_ORG_ID = cp_local_org_id AND LOCAL_ARTICLE_VERSION_ID IS NULL;
956:
957: l_return_status VARCHAR2(1);
958:
959: l_object_version_number OKC_ARTICLE_ADOPTIONS.OBJECT_VERSION_NUMBER%TYPE;
960:
961: l_row_notfound BOOLEAN := FALSE;
962: BEGIN
963:

Line 1088: -- Lock_Row for:OKC_ARTICLE_ADOPTIONS --

1084: RETURN( G_RET_STS_UNEXP_ERROR );
1085: END Lock_Row;
1086:
1087: -----------------------------------
1088: -- Lock_Row for:OKC_ARTICLE_ADOPTIONS --
1089: -----------------------------------
1090: PROCEDURE Lock_Row(
1091: x_return_status OUT NOCOPY VARCHAR2,
1092:

Line 1156: -- Update_Row for:OKC_ARTICLE_ADOPTIONS --

1152: ---------------------------------------------------------------------------
1153: -- PROCEDURE Update_Row
1154: ---------------------------------------------------------------------------
1155: -------------------------------------
1156: -- Update_Row for:OKC_ARTICLE_ADOPTIONS --
1157: -------------------------------------
1158: FUNCTION Update_Row(
1159: p_global_article_version_id IN NUMBER,
1160: p_adoption_type IN VARCHAR2,

Line 1179: UPDATE OKC_ARTICLE_ADOPTIONS

1175: IF (l_debug = 'Y') THEN
1176: Okc_Debug.Log('6400: Entered Update_Row', 2);
1177: END IF;
1178: IF p_orig_local_version_id IS NOT NULL THEN
1179: UPDATE OKC_ARTICLE_ADOPTIONS
1180: SET ADOPTION_TYPE = p_adoption_type,
1181: ADOPTION_STATUS = p_adoption_status,
1182: LOCAL_ARTICLE_VERSION_ID = p_new_local_version_id,
1183: -- muteshev

Line 1191: UPDATE OKC_ARTICLE_ADOPTIONS

1187: LAST_UPDATE_DATE = p_last_update_date
1188: WHERE GLOBAL_ARTICLE_VERSION_ID = p_global_article_version_id AND
1189: LOCAL_ORG_ID = p_local_org_id AND LOCAL_ARTICLE_VERSION_ID = p_orig_local_version_id;
1190: ELSE
1191: UPDATE OKC_ARTICLE_ADOPTIONS
1192: SET ADOPTION_TYPE = p_adoption_type,
1193: ADOPTION_STATUS = p_adoption_status,
1194: LOCAL_ARTICLE_VERSION_ID = p_new_local_version_id,
1195: -- muteshev

Line 1230: -- Update_Row for:OKC_ARTICLE_ADOPTIONS --

1226:
1227: END Update_Row;
1228:
1229: -------------------------------------
1230: -- Update_Row for:OKC_ARTICLE_ADOPTIONS --
1231: -------------------------------------
1232: PROCEDURE Update_Row(
1233: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1234:

Line 1250: l_global_article_version_id OKC_ARTICLE_ADOPTIONS.GLOBAL_ARTICLE_VERSION_ID%TYPE;

1246: p_object_version_number IN NUMBER
1247:
1248: ) IS
1249:
1250: l_global_article_version_id OKC_ARTICLE_ADOPTIONS.GLOBAL_ARTICLE_VERSION_ID%TYPE;
1251: l_adoption_type OKC_ARTICLE_ADOPTIONS.ADOPTION_TYPE%TYPE;
1252: l_adoption_status OKC_ARTICLE_ADOPTIONS.ADOPTION_STATUS%TYPE;
1253: l_object_version_number OKC_ARTICLE_ADOPTIONS.OBJECT_VERSION_NUMBER%TYPE;
1254: l_created_by OKC_ARTICLE_ADOPTIONS.CREATED_BY%TYPE;

Line 1251: l_adoption_type OKC_ARTICLE_ADOPTIONS.ADOPTION_TYPE%TYPE;

1247:
1248: ) IS
1249:
1250: l_global_article_version_id OKC_ARTICLE_ADOPTIONS.GLOBAL_ARTICLE_VERSION_ID%TYPE;
1251: l_adoption_type OKC_ARTICLE_ADOPTIONS.ADOPTION_TYPE%TYPE;
1252: l_adoption_status OKC_ARTICLE_ADOPTIONS.ADOPTION_STATUS%TYPE;
1253: l_object_version_number OKC_ARTICLE_ADOPTIONS.OBJECT_VERSION_NUMBER%TYPE;
1254: l_created_by OKC_ARTICLE_ADOPTIONS.CREATED_BY%TYPE;
1255: l_creation_date OKC_ARTICLE_ADOPTIONS.CREATION_DATE%TYPE;

Line 1252: l_adoption_status OKC_ARTICLE_ADOPTIONS.ADOPTION_STATUS%TYPE;

1248: ) IS
1249:
1250: l_global_article_version_id OKC_ARTICLE_ADOPTIONS.GLOBAL_ARTICLE_VERSION_ID%TYPE;
1251: l_adoption_type OKC_ARTICLE_ADOPTIONS.ADOPTION_TYPE%TYPE;
1252: l_adoption_status OKC_ARTICLE_ADOPTIONS.ADOPTION_STATUS%TYPE;
1253: l_object_version_number OKC_ARTICLE_ADOPTIONS.OBJECT_VERSION_NUMBER%TYPE;
1254: l_created_by OKC_ARTICLE_ADOPTIONS.CREATED_BY%TYPE;
1255: l_creation_date OKC_ARTICLE_ADOPTIONS.CREATION_DATE%TYPE;
1256: l_last_updated_by OKC_ARTICLE_ADOPTIONS.LAST_UPDATED_BY%TYPE;

Line 1253: l_object_version_number OKC_ARTICLE_ADOPTIONS.OBJECT_VERSION_NUMBER%TYPE;

1249:
1250: l_global_article_version_id OKC_ARTICLE_ADOPTIONS.GLOBAL_ARTICLE_VERSION_ID%TYPE;
1251: l_adoption_type OKC_ARTICLE_ADOPTIONS.ADOPTION_TYPE%TYPE;
1252: l_adoption_status OKC_ARTICLE_ADOPTIONS.ADOPTION_STATUS%TYPE;
1253: l_object_version_number OKC_ARTICLE_ADOPTIONS.OBJECT_VERSION_NUMBER%TYPE;
1254: l_created_by OKC_ARTICLE_ADOPTIONS.CREATED_BY%TYPE;
1255: l_creation_date OKC_ARTICLE_ADOPTIONS.CREATION_DATE%TYPE;
1256: l_last_updated_by OKC_ARTICLE_ADOPTIONS.LAST_UPDATED_BY%TYPE;
1257: l_last_update_login OKC_ARTICLE_ADOPTIONS.LAST_UPDATE_LOGIN%TYPE;

Line 1254: l_created_by OKC_ARTICLE_ADOPTIONS.CREATED_BY%TYPE;

1250: l_global_article_version_id OKC_ARTICLE_ADOPTIONS.GLOBAL_ARTICLE_VERSION_ID%TYPE;
1251: l_adoption_type OKC_ARTICLE_ADOPTIONS.ADOPTION_TYPE%TYPE;
1252: l_adoption_status OKC_ARTICLE_ADOPTIONS.ADOPTION_STATUS%TYPE;
1253: l_object_version_number OKC_ARTICLE_ADOPTIONS.OBJECT_VERSION_NUMBER%TYPE;
1254: l_created_by OKC_ARTICLE_ADOPTIONS.CREATED_BY%TYPE;
1255: l_creation_date OKC_ARTICLE_ADOPTIONS.CREATION_DATE%TYPE;
1256: l_last_updated_by OKC_ARTICLE_ADOPTIONS.LAST_UPDATED_BY%TYPE;
1257: l_last_update_login OKC_ARTICLE_ADOPTIONS.LAST_UPDATE_LOGIN%TYPE;
1258: l_last_update_date OKC_ARTICLE_ADOPTIONS.LAST_UPDATE_DATE%TYPE;

Line 1255: l_creation_date OKC_ARTICLE_ADOPTIONS.CREATION_DATE%TYPE;

1251: l_adoption_type OKC_ARTICLE_ADOPTIONS.ADOPTION_TYPE%TYPE;
1252: l_adoption_status OKC_ARTICLE_ADOPTIONS.ADOPTION_STATUS%TYPE;
1253: l_object_version_number OKC_ARTICLE_ADOPTIONS.OBJECT_VERSION_NUMBER%TYPE;
1254: l_created_by OKC_ARTICLE_ADOPTIONS.CREATED_BY%TYPE;
1255: l_creation_date OKC_ARTICLE_ADOPTIONS.CREATION_DATE%TYPE;
1256: l_last_updated_by OKC_ARTICLE_ADOPTIONS.LAST_UPDATED_BY%TYPE;
1257: l_last_update_login OKC_ARTICLE_ADOPTIONS.LAST_UPDATE_LOGIN%TYPE;
1258: l_last_update_date OKC_ARTICLE_ADOPTIONS.LAST_UPDATE_DATE%TYPE;
1259:

Line 1256: l_last_updated_by OKC_ARTICLE_ADOPTIONS.LAST_UPDATED_BY%TYPE;

1252: l_adoption_status OKC_ARTICLE_ADOPTIONS.ADOPTION_STATUS%TYPE;
1253: l_object_version_number OKC_ARTICLE_ADOPTIONS.OBJECT_VERSION_NUMBER%TYPE;
1254: l_created_by OKC_ARTICLE_ADOPTIONS.CREATED_BY%TYPE;
1255: l_creation_date OKC_ARTICLE_ADOPTIONS.CREATION_DATE%TYPE;
1256: l_last_updated_by OKC_ARTICLE_ADOPTIONS.LAST_UPDATED_BY%TYPE;
1257: l_last_update_login OKC_ARTICLE_ADOPTIONS.LAST_UPDATE_LOGIN%TYPE;
1258: l_last_update_date OKC_ARTICLE_ADOPTIONS.LAST_UPDATE_DATE%TYPE;
1259:
1260: BEGIN

Line 1257: l_last_update_login OKC_ARTICLE_ADOPTIONS.LAST_UPDATE_LOGIN%TYPE;

1253: l_object_version_number OKC_ARTICLE_ADOPTIONS.OBJECT_VERSION_NUMBER%TYPE;
1254: l_created_by OKC_ARTICLE_ADOPTIONS.CREATED_BY%TYPE;
1255: l_creation_date OKC_ARTICLE_ADOPTIONS.CREATION_DATE%TYPE;
1256: l_last_updated_by OKC_ARTICLE_ADOPTIONS.LAST_UPDATED_BY%TYPE;
1257: l_last_update_login OKC_ARTICLE_ADOPTIONS.LAST_UPDATE_LOGIN%TYPE;
1258: l_last_update_date OKC_ARTICLE_ADOPTIONS.LAST_UPDATE_DATE%TYPE;
1259:
1260: BEGIN
1261:

Line 1258: l_last_update_date OKC_ARTICLE_ADOPTIONS.LAST_UPDATE_DATE%TYPE;

1254: l_created_by OKC_ARTICLE_ADOPTIONS.CREATED_BY%TYPE;
1255: l_creation_date OKC_ARTICLE_ADOPTIONS.CREATION_DATE%TYPE;
1256: l_last_updated_by OKC_ARTICLE_ADOPTIONS.LAST_UPDATED_BY%TYPE;
1257: l_last_update_login OKC_ARTICLE_ADOPTIONS.LAST_UPDATE_LOGIN%TYPE;
1258: l_last_update_date OKC_ARTICLE_ADOPTIONS.LAST_UPDATE_DATE%TYPE;
1259:
1260: BEGIN
1261:
1262: IF (l_debug = 'Y') THEN

Line 1397: -- Delete_Row for:OKC_ARTICLE_ADOPTIONS --

1393: ---------------------------------------------------------------------------
1394: -- PROCEDURE Delete_Row
1395: ---------------------------------------------------------------------------
1396: -------------------------------------
1397: -- Delete_Row for:OKC_ARTICLE_ADOPTIONS --
1398: -------------------------------------
1399: FUNCTION Delete_Row(
1400: p_global_article_version_id IN NUMBER,
1401: p_local_org_id IN NUMBER,

Line 1411: DELETE FROM OKC_ARTICLE_ADOPTIONS

1407: IF (l_debug = 'Y') THEN
1408: Okc_Debug.Log('8200: Entered Delete_Row', 2);
1409: END IF;
1410:
1411: DELETE FROM OKC_ARTICLE_ADOPTIONS
1412: WHERE GLOBAL_ARTICLE_VERSION_ID = p_GLOBAL_ARTICLE_VERSION_ID AND LOCAL_ORG_ID = p_LOCAL_ORG_ID AND LOCAL_ARTICLE_VERSION_ID = p_LOCAL_ARTICLE_VERSION_ID;
1413:
1414: IF (l_debug = 'Y') THEN
1415: Okc_Debug.Log('8300: Leaving Delete_Row', 2);

Line 1439: -- Delete_Row for:OKC_ARTICLE_ADOPTIONS --

1435:
1436: END Delete_Row;
1437:
1438: -------------------------------------
1439: -- Delete_Row for:OKC_ARTICLE_ADOPTIONS --
1440: -------------------------------------
1441: PROCEDURE Delete_Row(
1442: x_return_status OUT NOCOPY VARCHAR2,
1443: p_global_article_version_id IN NUMBER,

Line 1513: END OKC_ARTICLE_ADOPTIONS_PVT;

1509: END Delete_Row;
1510:
1511:
1512:
1513: END OKC_ARTICLE_ADOPTIONS_PVT;