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_RELATIONSHIPS_PVT dependencies on OKC_ARTICLE_RELATNS_ALL

Line 129: FROM OKC_ARTICLE_RELATNS_ALL t

125: CREATION_DATE,
126: LAST_UPDATED_BY,
127: LAST_UPDATE_LOGIN,
128: LAST_UPDATE_DATE
129: FROM OKC_ARTICLE_RELATNS_ALL t
130: WHERE t.SOURCE_ARTICLE_ID = cp_source_article_id and
131: t.TARGET_ARTICLE_ID = cp_target_article_id and
132: t.ORG_ID = cp_org_id;
133: BEGIN

Line 183: -- Set_Attributes for:OKC_ARTICLE_RELATNS_ALL --

179:
180: END Get_Rec;
181:
182: -----------------------------------------
183: -- Set_Attributes for:OKC_ARTICLE_RELATNS_ALL --
184: -----------------------------------------
185: FUNCTION Set_Attributes(
186: p_source_article_id IN NUMBER,
187: p_target_article_id IN NUMBER,

Line 195: l_object_version_number OKC_ARTICLE_RELATNS_ALL.OBJECT_VERSION_NUMBER%TYPE;

191:
192: x_relationship_type OUT NOCOPY VARCHAR2
193: ) RETURN VARCHAR2 IS
194: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
195: l_object_version_number OKC_ARTICLE_RELATNS_ALL.OBJECT_VERSION_NUMBER%TYPE;
196: l_created_by OKC_ARTICLE_RELATNS_ALL.CREATED_BY%TYPE;
197: l_creation_date OKC_ARTICLE_RELATNS_ALL.CREATION_DATE%TYPE;
198: l_last_updated_by OKC_ARTICLE_RELATNS_ALL.LAST_UPDATED_BY%TYPE;
199: l_last_update_login OKC_ARTICLE_RELATNS_ALL.LAST_UPDATE_LOGIN%TYPE;

Line 196: l_created_by OKC_ARTICLE_RELATNS_ALL.CREATED_BY%TYPE;

192: x_relationship_type OUT NOCOPY VARCHAR2
193: ) RETURN VARCHAR2 IS
194: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
195: l_object_version_number OKC_ARTICLE_RELATNS_ALL.OBJECT_VERSION_NUMBER%TYPE;
196: l_created_by OKC_ARTICLE_RELATNS_ALL.CREATED_BY%TYPE;
197: l_creation_date OKC_ARTICLE_RELATNS_ALL.CREATION_DATE%TYPE;
198: l_last_updated_by OKC_ARTICLE_RELATNS_ALL.LAST_UPDATED_BY%TYPE;
199: l_last_update_login OKC_ARTICLE_RELATNS_ALL.LAST_UPDATE_LOGIN%TYPE;
200: l_last_update_date OKC_ARTICLE_RELATNS_ALL.LAST_UPDATE_DATE%TYPE;

Line 197: l_creation_date OKC_ARTICLE_RELATNS_ALL.CREATION_DATE%TYPE;

193: ) RETURN VARCHAR2 IS
194: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
195: l_object_version_number OKC_ARTICLE_RELATNS_ALL.OBJECT_VERSION_NUMBER%TYPE;
196: l_created_by OKC_ARTICLE_RELATNS_ALL.CREATED_BY%TYPE;
197: l_creation_date OKC_ARTICLE_RELATNS_ALL.CREATION_DATE%TYPE;
198: l_last_updated_by OKC_ARTICLE_RELATNS_ALL.LAST_UPDATED_BY%TYPE;
199: l_last_update_login OKC_ARTICLE_RELATNS_ALL.LAST_UPDATE_LOGIN%TYPE;
200: l_last_update_date OKC_ARTICLE_RELATNS_ALL.LAST_UPDATE_DATE%TYPE;
201: BEGIN

Line 198: l_last_updated_by OKC_ARTICLE_RELATNS_ALL.LAST_UPDATED_BY%TYPE;

194: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
195: l_object_version_number OKC_ARTICLE_RELATNS_ALL.OBJECT_VERSION_NUMBER%TYPE;
196: l_created_by OKC_ARTICLE_RELATNS_ALL.CREATED_BY%TYPE;
197: l_creation_date OKC_ARTICLE_RELATNS_ALL.CREATION_DATE%TYPE;
198: l_last_updated_by OKC_ARTICLE_RELATNS_ALL.LAST_UPDATED_BY%TYPE;
199: l_last_update_login OKC_ARTICLE_RELATNS_ALL.LAST_UPDATE_LOGIN%TYPE;
200: l_last_update_date OKC_ARTICLE_RELATNS_ALL.LAST_UPDATE_DATE%TYPE;
201: BEGIN
202: IF (l_debug = 'Y') THEN

Line 199: l_last_update_login OKC_ARTICLE_RELATNS_ALL.LAST_UPDATE_LOGIN%TYPE;

195: l_object_version_number OKC_ARTICLE_RELATNS_ALL.OBJECT_VERSION_NUMBER%TYPE;
196: l_created_by OKC_ARTICLE_RELATNS_ALL.CREATED_BY%TYPE;
197: l_creation_date OKC_ARTICLE_RELATNS_ALL.CREATION_DATE%TYPE;
198: l_last_updated_by OKC_ARTICLE_RELATNS_ALL.LAST_UPDATED_BY%TYPE;
199: l_last_update_login OKC_ARTICLE_RELATNS_ALL.LAST_UPDATE_LOGIN%TYPE;
200: l_last_update_date OKC_ARTICLE_RELATNS_ALL.LAST_UPDATE_DATE%TYPE;
201: BEGIN
202: IF (l_debug = 'Y') THEN
203: Okc_Debug.Log('700: Entered Set_Attributes ', 2);

Line 200: l_last_update_date OKC_ARTICLE_RELATNS_ALL.LAST_UPDATE_DATE%TYPE;

196: l_created_by OKC_ARTICLE_RELATNS_ALL.CREATED_BY%TYPE;
197: l_creation_date OKC_ARTICLE_RELATNS_ALL.CREATION_DATE%TYPE;
198: l_last_updated_by OKC_ARTICLE_RELATNS_ALL.LAST_UPDATED_BY%TYPE;
199: l_last_update_login OKC_ARTICLE_RELATNS_ALL.LAST_UPDATE_LOGIN%TYPE;
200: l_last_update_date OKC_ARTICLE_RELATNS_ALL.LAST_UPDATE_DATE%TYPE;
201: BEGIN
202: IF (l_debug = 'Y') THEN
203: Okc_Debug.Log('700: Entered Set_Attributes ', 2);
204: END IF;

Line 271: -- Validate_Attributes for: OKC_ARTICLE_RELATNS_ALL --

267:
268: END Set_Attributes ;
269:
270: ----------------------------------------------
271: -- Validate_Attributes for: OKC_ARTICLE_RELATNS_ALL --
272: ----------------------------------------------
273: FUNCTION Validate_Attributes (
274: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
275:

Line 526: -- Validate_Record for:OKC_ARTICLE_RELATNS_ALL --

522: -- PROCEDURE Validate_Record
523: -- It calls Item Level Validations and then makes Record Level Validations
524: ---------------------------------------------------------------------------
525: ------------------------------------------
526: -- Validate_Record for:OKC_ARTICLE_RELATNS_ALL --
527: ------------------------------------------
528: FUNCTION Validate_Record (
529: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
530:

Line 543: SELECT '1' FROM OKC_ARTICLE_RELATNS_ALL

539: l_dummy_var VARCHAR2(1) := '?';
540: CURSOR l_unq_csr(cp_source_article_id IN NUMBER,
541: cp_target_article_id IN NUMBER,
542: cp_org_id IN NUMBER) IS
543: SELECT '1' FROM OKC_ARTICLE_RELATNS_ALL
544: WHERE source_article_id = cp_source_article_id
545: AND target_article_id = cp_target_article_id
546: AND org_id = cp_org_id
547: AND rownum < 2;

Line 641: -- validate_row for:OKC_ARTICLE_RELATNS_ALL --

637: ---------------------------------------------------------------------------
638: -- PROCEDURE validate_row
639: ---------------------------------------------------------------------------
640: ---------------------------------------
641: -- validate_row for:OKC_ARTICLE_RELATNS_ALL --
642: ---------------------------------------
643: PROCEDURE validate_row(
644: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
645:

Line 657: l_relationship_type OKC_ARTICLE_RELATNS_ALL.RELATIONSHIP_TYPE%TYPE;

653:
654:
655: p_object_version_number IN NUMBER
656: ) IS
657: l_relationship_type OKC_ARTICLE_RELATNS_ALL.RELATIONSHIP_TYPE%TYPE;
658: l_object_version_number OKC_ARTICLE_RELATNS_ALL.OBJECT_VERSION_NUMBER%TYPE;
659: l_created_by OKC_ARTICLE_RELATNS_ALL.CREATED_BY%TYPE;
660: l_creation_date OKC_ARTICLE_RELATNS_ALL.CREATION_DATE%TYPE;
661: l_last_updated_by OKC_ARTICLE_RELATNS_ALL.LAST_UPDATED_BY%TYPE;

Line 658: l_object_version_number OKC_ARTICLE_RELATNS_ALL.OBJECT_VERSION_NUMBER%TYPE;

654:
655: p_object_version_number IN NUMBER
656: ) IS
657: l_relationship_type OKC_ARTICLE_RELATNS_ALL.RELATIONSHIP_TYPE%TYPE;
658: l_object_version_number OKC_ARTICLE_RELATNS_ALL.OBJECT_VERSION_NUMBER%TYPE;
659: l_created_by OKC_ARTICLE_RELATNS_ALL.CREATED_BY%TYPE;
660: l_creation_date OKC_ARTICLE_RELATNS_ALL.CREATION_DATE%TYPE;
661: l_last_updated_by OKC_ARTICLE_RELATNS_ALL.LAST_UPDATED_BY%TYPE;
662: l_last_update_login OKC_ARTICLE_RELATNS_ALL.LAST_UPDATE_LOGIN%TYPE;

Line 659: l_created_by OKC_ARTICLE_RELATNS_ALL.CREATED_BY%TYPE;

655: p_object_version_number IN NUMBER
656: ) IS
657: l_relationship_type OKC_ARTICLE_RELATNS_ALL.RELATIONSHIP_TYPE%TYPE;
658: l_object_version_number OKC_ARTICLE_RELATNS_ALL.OBJECT_VERSION_NUMBER%TYPE;
659: l_created_by OKC_ARTICLE_RELATNS_ALL.CREATED_BY%TYPE;
660: l_creation_date OKC_ARTICLE_RELATNS_ALL.CREATION_DATE%TYPE;
661: l_last_updated_by OKC_ARTICLE_RELATNS_ALL.LAST_UPDATED_BY%TYPE;
662: l_last_update_login OKC_ARTICLE_RELATNS_ALL.LAST_UPDATE_LOGIN%TYPE;
663: l_last_update_date OKC_ARTICLE_RELATNS_ALL.LAST_UPDATE_DATE%TYPE;

Line 660: l_creation_date OKC_ARTICLE_RELATNS_ALL.CREATION_DATE%TYPE;

656: ) IS
657: l_relationship_type OKC_ARTICLE_RELATNS_ALL.RELATIONSHIP_TYPE%TYPE;
658: l_object_version_number OKC_ARTICLE_RELATNS_ALL.OBJECT_VERSION_NUMBER%TYPE;
659: l_created_by OKC_ARTICLE_RELATNS_ALL.CREATED_BY%TYPE;
660: l_creation_date OKC_ARTICLE_RELATNS_ALL.CREATION_DATE%TYPE;
661: l_last_updated_by OKC_ARTICLE_RELATNS_ALL.LAST_UPDATED_BY%TYPE;
662: l_last_update_login OKC_ARTICLE_RELATNS_ALL.LAST_UPDATE_LOGIN%TYPE;
663: l_last_update_date OKC_ARTICLE_RELATNS_ALL.LAST_UPDATE_DATE%TYPE;
664: BEGIN

Line 661: l_last_updated_by OKC_ARTICLE_RELATNS_ALL.LAST_UPDATED_BY%TYPE;

657: l_relationship_type OKC_ARTICLE_RELATNS_ALL.RELATIONSHIP_TYPE%TYPE;
658: l_object_version_number OKC_ARTICLE_RELATNS_ALL.OBJECT_VERSION_NUMBER%TYPE;
659: l_created_by OKC_ARTICLE_RELATNS_ALL.CREATED_BY%TYPE;
660: l_creation_date OKC_ARTICLE_RELATNS_ALL.CREATION_DATE%TYPE;
661: l_last_updated_by OKC_ARTICLE_RELATNS_ALL.LAST_UPDATED_BY%TYPE;
662: l_last_update_login OKC_ARTICLE_RELATNS_ALL.LAST_UPDATE_LOGIN%TYPE;
663: l_last_update_date OKC_ARTICLE_RELATNS_ALL.LAST_UPDATE_DATE%TYPE;
664: BEGIN
665:

Line 662: l_last_update_login OKC_ARTICLE_RELATNS_ALL.LAST_UPDATE_LOGIN%TYPE;

658: l_object_version_number OKC_ARTICLE_RELATNS_ALL.OBJECT_VERSION_NUMBER%TYPE;
659: l_created_by OKC_ARTICLE_RELATNS_ALL.CREATED_BY%TYPE;
660: l_creation_date OKC_ARTICLE_RELATNS_ALL.CREATION_DATE%TYPE;
661: l_last_updated_by OKC_ARTICLE_RELATNS_ALL.LAST_UPDATED_BY%TYPE;
662: l_last_update_login OKC_ARTICLE_RELATNS_ALL.LAST_UPDATE_LOGIN%TYPE;
663: l_last_update_date OKC_ARTICLE_RELATNS_ALL.LAST_UPDATE_DATE%TYPE;
664: BEGIN
665:
666: IF (l_debug = 'Y') THEN

Line 663: l_last_update_date OKC_ARTICLE_RELATNS_ALL.LAST_UPDATE_DATE%TYPE;

659: l_created_by OKC_ARTICLE_RELATNS_ALL.CREATED_BY%TYPE;
660: l_creation_date OKC_ARTICLE_RELATNS_ALL.CREATION_DATE%TYPE;
661: l_last_updated_by OKC_ARTICLE_RELATNS_ALL.LAST_UPDATED_BY%TYPE;
662: l_last_update_login OKC_ARTICLE_RELATNS_ALL.LAST_UPDATE_LOGIN%TYPE;
663: l_last_update_date OKC_ARTICLE_RELATNS_ALL.LAST_UPDATE_DATE%TYPE;
664: BEGIN
665:
666: IF (l_debug = 'Y') THEN
667: Okc_Debug.Log('3100: Entered validate_row', 2);

Line 729: -- Insert_Row for:OKC_ARTICLE_RELATNS_ALL --

725: ---------------------------------------------------------------------------
726: -- PROCEDURE Insert_Row
727: ---------------------------------------------------------------------------
728: -------------------------------------
729: -- Insert_Row for:OKC_ARTICLE_RELATNS_ALL --
730: -------------------------------------
731: FUNCTION Insert_Row(
732: p_source_article_id IN NUMBER,
733: p_target_article_id IN NUMBER,

Line 751: INSERT INTO OKC_ARTICLE_RELATNS_ALL(

747: IF (l_debug = 'Y') THEN
748: Okc_Debug.Log('3600: Entered Insert_Row function', 2);
749: END IF;
750: -- Create opposite rows (mutually related by flipping the source and target ids)
751: INSERT INTO OKC_ARTICLE_RELATNS_ALL(
752: SOURCE_ARTICLE_ID,
753: TARGET_ARTICLE_ID,
754: ORG_ID,
755: RELATIONSHIP_TYPE,

Line 800: -- Insert_Row for:OKC_ARTICLE_RELATNS_ALL --

796: END Insert_Row;
797:
798:
799: -------------------------------------
800: -- Insert_Row for:OKC_ARTICLE_RELATNS_ALL --
801: -------------------------------------
802: PROCEDURE Insert_Row(
803: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
804: x_return_status OUT NOCOPY VARCHAR2,

Line 819: l_object_version_number OKC_ARTICLE_RELATNS_ALL.OBJECT_VERSION_NUMBER%TYPE;

815: x_org_id OUT NOCOPY NUMBER
816:
817: ) IS
818:
819: l_object_version_number OKC_ARTICLE_RELATNS_ALL.OBJECT_VERSION_NUMBER%TYPE;
820: l_created_by OKC_ARTICLE_RELATNS_ALL.CREATED_BY%TYPE;
821: l_creation_date OKC_ARTICLE_RELATNS_ALL.CREATION_DATE%TYPE;
822: l_last_updated_by OKC_ARTICLE_RELATNS_ALL.LAST_UPDATED_BY%TYPE;
823: l_last_update_login OKC_ARTICLE_RELATNS_ALL.LAST_UPDATE_LOGIN%TYPE;

Line 820: l_created_by OKC_ARTICLE_RELATNS_ALL.CREATED_BY%TYPE;

816:
817: ) IS
818:
819: l_object_version_number OKC_ARTICLE_RELATNS_ALL.OBJECT_VERSION_NUMBER%TYPE;
820: l_created_by OKC_ARTICLE_RELATNS_ALL.CREATED_BY%TYPE;
821: l_creation_date OKC_ARTICLE_RELATNS_ALL.CREATION_DATE%TYPE;
822: l_last_updated_by OKC_ARTICLE_RELATNS_ALL.LAST_UPDATED_BY%TYPE;
823: l_last_update_login OKC_ARTICLE_RELATNS_ALL.LAST_UPDATE_LOGIN%TYPE;
824: l_last_update_date OKC_ARTICLE_RELATNS_ALL.LAST_UPDATE_DATE%TYPE;

Line 821: l_creation_date OKC_ARTICLE_RELATNS_ALL.CREATION_DATE%TYPE;

817: ) IS
818:
819: l_object_version_number OKC_ARTICLE_RELATNS_ALL.OBJECT_VERSION_NUMBER%TYPE;
820: l_created_by OKC_ARTICLE_RELATNS_ALL.CREATED_BY%TYPE;
821: l_creation_date OKC_ARTICLE_RELATNS_ALL.CREATION_DATE%TYPE;
822: l_last_updated_by OKC_ARTICLE_RELATNS_ALL.LAST_UPDATED_BY%TYPE;
823: l_last_update_login OKC_ARTICLE_RELATNS_ALL.LAST_UPDATE_LOGIN%TYPE;
824: l_last_update_date OKC_ARTICLE_RELATNS_ALL.LAST_UPDATE_DATE%TYPE;
825: BEGIN

Line 822: l_last_updated_by OKC_ARTICLE_RELATNS_ALL.LAST_UPDATED_BY%TYPE;

818:
819: l_object_version_number OKC_ARTICLE_RELATNS_ALL.OBJECT_VERSION_NUMBER%TYPE;
820: l_created_by OKC_ARTICLE_RELATNS_ALL.CREATED_BY%TYPE;
821: l_creation_date OKC_ARTICLE_RELATNS_ALL.CREATION_DATE%TYPE;
822: l_last_updated_by OKC_ARTICLE_RELATNS_ALL.LAST_UPDATED_BY%TYPE;
823: l_last_update_login OKC_ARTICLE_RELATNS_ALL.LAST_UPDATE_LOGIN%TYPE;
824: l_last_update_date OKC_ARTICLE_RELATNS_ALL.LAST_UPDATE_DATE%TYPE;
825: BEGIN
826:

Line 823: l_last_update_login OKC_ARTICLE_RELATNS_ALL.LAST_UPDATE_LOGIN%TYPE;

819: l_object_version_number OKC_ARTICLE_RELATNS_ALL.OBJECT_VERSION_NUMBER%TYPE;
820: l_created_by OKC_ARTICLE_RELATNS_ALL.CREATED_BY%TYPE;
821: l_creation_date OKC_ARTICLE_RELATNS_ALL.CREATION_DATE%TYPE;
822: l_last_updated_by OKC_ARTICLE_RELATNS_ALL.LAST_UPDATED_BY%TYPE;
823: l_last_update_login OKC_ARTICLE_RELATNS_ALL.LAST_UPDATE_LOGIN%TYPE;
824: l_last_update_date OKC_ARTICLE_RELATNS_ALL.LAST_UPDATE_DATE%TYPE;
825: BEGIN
826:
827: x_return_status := G_RET_STS_SUCCESS;

Line 824: l_last_update_date OKC_ARTICLE_RELATNS_ALL.LAST_UPDATE_DATE%TYPE;

820: l_created_by OKC_ARTICLE_RELATNS_ALL.CREATED_BY%TYPE;
821: l_creation_date OKC_ARTICLE_RELATNS_ALL.CREATION_DATE%TYPE;
822: l_last_updated_by OKC_ARTICLE_RELATNS_ALL.LAST_UPDATED_BY%TYPE;
823: l_last_update_login OKC_ARTICLE_RELATNS_ALL.LAST_UPDATE_LOGIN%TYPE;
824: l_last_update_date OKC_ARTICLE_RELATNS_ALL.LAST_UPDATE_DATE%TYPE;
825: BEGIN
826:
827: x_return_status := G_RET_STS_SUCCESS;
828:

Line 929: -- Lock_Row for:OKC_ARTICLE_RELATNS_ALL --

925: ---------------------------------------------------------------------------
926: -- PROCEDURE Lock_Row
927: ---------------------------------------------------------------------------
928: -----------------------------------
929: -- Lock_Row for:OKC_ARTICLE_RELATNS_ALL --
930: -----------------------------------
931: FUNCTION Lock_Row(
932: p_source_article_id IN NUMBER,
933: p_target_article_id IN NUMBER,

Line 943: FROM OKC_ARTICLE_RELATNS_ALL

939: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
940:
941: CURSOR lock_csr (cp_source_article_id NUMBER, cp_target_article_id NUMBER, cp_org_id NUMBER, cp_object_version_number NUMBER) IS
942: SELECT object_version_number
943: FROM OKC_ARTICLE_RELATNS_ALL
944: WHERE SOURCE_ARTICLE_ID = cp_source_article_id AND TARGET_ARTICLE_ID = cp_target_article_id AND ORG_ID = cp_org_id
945: AND (object_version_number = cp_object_version_number OR cp_object_version_number IS NULL)
946: FOR UPDATE OF object_version_number NOWAIT;
947:

Line 950: FROM OKC_ARTICLE_RELATNS_ALL

946: FOR UPDATE OF object_version_number NOWAIT;
947:
948: CURSOR lchk_csr (cp_source_article_id NUMBER, cp_target_article_id NUMBER, cp_org_id NUMBER) IS
949: SELECT object_version_number
950: FROM OKC_ARTICLE_RELATNS_ALL
951: WHERE SOURCE_ARTICLE_ID = cp_source_article_id AND TARGET_ARTICLE_ID = cp_target_article_id AND ORG_ID = cp_org_id;
952:
953: l_return_status VARCHAR2(1);
954:

Line 955: l_object_version_number OKC_ARTICLE_RELATNS_ALL.OBJECT_VERSION_NUMBER%TYPE;

951: WHERE SOURCE_ARTICLE_ID = cp_source_article_id AND TARGET_ARTICLE_ID = cp_target_article_id AND ORG_ID = cp_org_id;
952:
953: l_return_status VARCHAR2(1);
954:
955: l_object_version_number OKC_ARTICLE_RELATNS_ALL.OBJECT_VERSION_NUMBER%TYPE;
956:
957: l_row_notfound BOOLEAN := FALSE;
958: BEGIN
959:

Line 1038: -- Lock_Row for:OKC_ARTICLE_RELATNS_ALL --

1034: RETURN( G_RET_STS_UNEXP_ERROR );
1035: END Lock_Row;
1036:
1037: -----------------------------------
1038: -- Lock_Row for:OKC_ARTICLE_RELATNS_ALL --
1039: -----------------------------------
1040: PROCEDURE Lock_Row(
1041: x_return_status OUT NOCOPY VARCHAR2,
1042:

Line 1106: -- Update_Row for:OKC_ARTICLE_RELATNS_ALL --

1102: ---------------------------------------------------------------------------
1103: -- PROCEDURE Update_Row
1104: ---------------------------------------------------------------------------
1105: -------------------------------------
1106: -- Update_Row for:OKC_ARTICLE_RELATNS_ALL --
1107: -------------------------------------
1108: FUNCTION Update_Row(
1109: p_source_article_id IN NUMBER,
1110: p_target_article_id IN NUMBER,

Line 1127: UPDATE OKC_ARTICLE_RELATNS_ALL

1123: IF (l_debug = 'Y') THEN
1124: Okc_Debug.Log('6400: Entered Update_Row', 2);
1125: END IF;
1126:
1127: UPDATE OKC_ARTICLE_RELATNS_ALL
1128: SET RELATIONSHIP_TYPE = p_relationship_type,
1129: OBJECT_VERSION_NUMBER = p_object_version_number,
1130: CREATED_BY = p_created_by,
1131: CREATION_DATE = p_creation_date,

Line 1162: -- Update_Row for:OKC_ARTICLE_RELATNS_ALL --

1158:
1159: END Update_Row;
1160:
1161: -------------------------------------
1162: -- Update_Row for:OKC_ARTICLE_RELATNS_ALL --
1163: -------------------------------------
1164: PROCEDURE Update_Row(
1165: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1166:

Line 1180: l_relationship_type OKC_ARTICLE_RELATNS_ALL.RELATIONSHIP_TYPE%TYPE;

1176: p_object_version_number IN NUMBER
1177:
1178: ) IS
1179:
1180: l_relationship_type OKC_ARTICLE_RELATNS_ALL.RELATIONSHIP_TYPE%TYPE;
1181: l_object_version_number OKC_ARTICLE_RELATNS_ALL.OBJECT_VERSION_NUMBER%TYPE;
1182: l_created_by OKC_ARTICLE_RELATNS_ALL.CREATED_BY%TYPE;
1183: l_creation_date OKC_ARTICLE_RELATNS_ALL.CREATION_DATE%TYPE;
1184: l_last_updated_by OKC_ARTICLE_RELATNS_ALL.LAST_UPDATED_BY%TYPE;

Line 1181: l_object_version_number OKC_ARTICLE_RELATNS_ALL.OBJECT_VERSION_NUMBER%TYPE;

1177:
1178: ) IS
1179:
1180: l_relationship_type OKC_ARTICLE_RELATNS_ALL.RELATIONSHIP_TYPE%TYPE;
1181: l_object_version_number OKC_ARTICLE_RELATNS_ALL.OBJECT_VERSION_NUMBER%TYPE;
1182: l_created_by OKC_ARTICLE_RELATNS_ALL.CREATED_BY%TYPE;
1183: l_creation_date OKC_ARTICLE_RELATNS_ALL.CREATION_DATE%TYPE;
1184: l_last_updated_by OKC_ARTICLE_RELATNS_ALL.LAST_UPDATED_BY%TYPE;
1185: l_last_update_login OKC_ARTICLE_RELATNS_ALL.LAST_UPDATE_LOGIN%TYPE;

Line 1182: l_created_by OKC_ARTICLE_RELATNS_ALL.CREATED_BY%TYPE;

1178: ) IS
1179:
1180: l_relationship_type OKC_ARTICLE_RELATNS_ALL.RELATIONSHIP_TYPE%TYPE;
1181: l_object_version_number OKC_ARTICLE_RELATNS_ALL.OBJECT_VERSION_NUMBER%TYPE;
1182: l_created_by OKC_ARTICLE_RELATNS_ALL.CREATED_BY%TYPE;
1183: l_creation_date OKC_ARTICLE_RELATNS_ALL.CREATION_DATE%TYPE;
1184: l_last_updated_by OKC_ARTICLE_RELATNS_ALL.LAST_UPDATED_BY%TYPE;
1185: l_last_update_login OKC_ARTICLE_RELATNS_ALL.LAST_UPDATE_LOGIN%TYPE;
1186: l_last_update_date OKC_ARTICLE_RELATNS_ALL.LAST_UPDATE_DATE%TYPE;

Line 1183: l_creation_date OKC_ARTICLE_RELATNS_ALL.CREATION_DATE%TYPE;

1179:
1180: l_relationship_type OKC_ARTICLE_RELATNS_ALL.RELATIONSHIP_TYPE%TYPE;
1181: l_object_version_number OKC_ARTICLE_RELATNS_ALL.OBJECT_VERSION_NUMBER%TYPE;
1182: l_created_by OKC_ARTICLE_RELATNS_ALL.CREATED_BY%TYPE;
1183: l_creation_date OKC_ARTICLE_RELATNS_ALL.CREATION_DATE%TYPE;
1184: l_last_updated_by OKC_ARTICLE_RELATNS_ALL.LAST_UPDATED_BY%TYPE;
1185: l_last_update_login OKC_ARTICLE_RELATNS_ALL.LAST_UPDATE_LOGIN%TYPE;
1186: l_last_update_date OKC_ARTICLE_RELATNS_ALL.LAST_UPDATE_DATE%TYPE;
1187:

Line 1184: l_last_updated_by OKC_ARTICLE_RELATNS_ALL.LAST_UPDATED_BY%TYPE;

1180: l_relationship_type OKC_ARTICLE_RELATNS_ALL.RELATIONSHIP_TYPE%TYPE;
1181: l_object_version_number OKC_ARTICLE_RELATNS_ALL.OBJECT_VERSION_NUMBER%TYPE;
1182: l_created_by OKC_ARTICLE_RELATNS_ALL.CREATED_BY%TYPE;
1183: l_creation_date OKC_ARTICLE_RELATNS_ALL.CREATION_DATE%TYPE;
1184: l_last_updated_by OKC_ARTICLE_RELATNS_ALL.LAST_UPDATED_BY%TYPE;
1185: l_last_update_login OKC_ARTICLE_RELATNS_ALL.LAST_UPDATE_LOGIN%TYPE;
1186: l_last_update_date OKC_ARTICLE_RELATNS_ALL.LAST_UPDATE_DATE%TYPE;
1187:
1188: BEGIN

Line 1185: l_last_update_login OKC_ARTICLE_RELATNS_ALL.LAST_UPDATE_LOGIN%TYPE;

1181: l_object_version_number OKC_ARTICLE_RELATNS_ALL.OBJECT_VERSION_NUMBER%TYPE;
1182: l_created_by OKC_ARTICLE_RELATNS_ALL.CREATED_BY%TYPE;
1183: l_creation_date OKC_ARTICLE_RELATNS_ALL.CREATION_DATE%TYPE;
1184: l_last_updated_by OKC_ARTICLE_RELATNS_ALL.LAST_UPDATED_BY%TYPE;
1185: l_last_update_login OKC_ARTICLE_RELATNS_ALL.LAST_UPDATE_LOGIN%TYPE;
1186: l_last_update_date OKC_ARTICLE_RELATNS_ALL.LAST_UPDATE_DATE%TYPE;
1187:
1188: BEGIN
1189:

Line 1186: l_last_update_date OKC_ARTICLE_RELATNS_ALL.LAST_UPDATE_DATE%TYPE;

1182: l_created_by OKC_ARTICLE_RELATNS_ALL.CREATED_BY%TYPE;
1183: l_creation_date OKC_ARTICLE_RELATNS_ALL.CREATION_DATE%TYPE;
1184: l_last_updated_by OKC_ARTICLE_RELATNS_ALL.LAST_UPDATED_BY%TYPE;
1185: l_last_update_login OKC_ARTICLE_RELATNS_ALL.LAST_UPDATE_LOGIN%TYPE;
1186: l_last_update_date OKC_ARTICLE_RELATNS_ALL.LAST_UPDATE_DATE%TYPE;
1187:
1188: BEGIN
1189:
1190: IF (l_debug = 'Y') THEN

Line 1320: -- Delete_Row for:OKC_ARTICLE_RELATNS_ALL --

1316: ---------------------------------------------------------------------------
1317: -- PROCEDURE Delete_Row
1318: ---------------------------------------------------------------------------
1319: -------------------------------------
1320: -- Delete_Row for:OKC_ARTICLE_RELATNS_ALL --
1321: -------------------------------------
1322: FUNCTION Delete_Row(
1323: p_source_article_id IN NUMBER,
1324: p_target_article_id IN NUMBER,

Line 1335: DELETE FROM OKC_ARTICLE_RELATNS_ALL

1331: Okc_Debug.Log('8200: Entered Delete_Row', 2);
1332: END IF;
1333: -- Delete opposite rows (mutually related by flipping the source and target ids)
1334:
1335: DELETE FROM OKC_ARTICLE_RELATNS_ALL
1336: WHERE SOURCE_ARTICLE_ID = p_SOURCE_ARTICLE_ID AND
1337: TARGET_ARTICLE_ID = p_TARGET_ARTICLE_ID AND
1338: ORG_ID = p_ORG_ID;
1339:

Line 1365: -- Delete_Row for:OKC_ARTICLE_RELATNS_ALL --

1361:
1362: END Delete_Row;
1363:
1364: -------------------------------------
1365: -- Delete_Row for:OKC_ARTICLE_RELATNS_ALL --
1366: -------------------------------------
1367: PROCEDURE Delete_Row(
1368: x_return_status OUT NOCOPY VARCHAR2,
1369: p_source_article_id IN NUMBER,