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_DOC_QA_LIST_PVT dependencies on OKC_DOC_QA_LISTS

Line 51: -- FUNCTION get_rec for: OKC_DOC_QA_LISTS

47: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
48: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
49:
50: ---------------------------------------------------------------------------
51: -- FUNCTION get_rec for: OKC_DOC_QA_LISTS
52: ---------------------------------------------------------------------------
53: FUNCTION Get_Rec (
54: p_qa_code IN VARCHAR2,
55: p_document_type IN VARCHAR2,

Line 67: CURSOR OKC_DOC_QA_LISTS_pk_csr (cp_qa_code IN VARCHAR2,cp_document_type IN VARCHAR2) IS

63: x_last_update_login OUT NOCOPY NUMBER,
64: x_last_update_date OUT NOCOPY DATE
65:
66: ) RETURN VARCHAR2 IS
67: CURSOR OKC_DOC_QA_LISTS_pk_csr (cp_qa_code IN VARCHAR2,cp_document_type IN VARCHAR2) IS
68: SELECT
69: SEVERITY_FLAG,
70: ENABLE_QA_YN,
71: OBJECT_VERSION_NUMBER,

Line 77: FROM OKC_DOC_QA_LISTS t

73: CREATION_DATE,
74: LAST_UPDATED_BY,
75: LAST_UPDATE_LOGIN,
76: LAST_UPDATE_DATE
77: FROM OKC_DOC_QA_LISTS t
78: WHERE t.QA_CODE = cp_qa_code and
79: t.DOCUMENT_TYPE = cp_document_type;
80: BEGIN
81:

Line 87: OPEN OKC_DOC_QA_LISTS_pk_csr (p_qa_code, p_document_type);

83: Okc_Debug.Log('400: Entered get_rec', 2);
84: END IF;
85:
86: -- Get current database values
87: OPEN OKC_DOC_QA_LISTS_pk_csr (p_qa_code, p_document_type);
88: FETCH OKC_DOC_QA_LISTS_pk_csr INTO
89: x_severity_flag,
90: x_enable_qa_yn,
91: x_object_version_number,

Line 88: FETCH OKC_DOC_QA_LISTS_pk_csr INTO

84: END IF;
85:
86: -- Get current database values
87: OPEN OKC_DOC_QA_LISTS_pk_csr (p_qa_code, p_document_type);
88: FETCH OKC_DOC_QA_LISTS_pk_csr INTO
89: x_severity_flag,
90: x_enable_qa_yn,
91: x_object_version_number,
92: x_created_by,

Line 97: IF OKC_DOC_QA_LISTS_pk_csr%NOTFOUND THEN

93: x_creation_date,
94: x_last_updated_by,
95: x_last_update_login,
96: x_last_update_date;
97: IF OKC_DOC_QA_LISTS_pk_csr%NOTFOUND THEN
98: RAISE NO_DATA_FOUND;
99: END IF;
100: CLOSE OKC_DOC_QA_LISTS_pk_csr;
101:

Line 100: CLOSE OKC_DOC_QA_LISTS_pk_csr;

96: x_last_update_date;
97: IF OKC_DOC_QA_LISTS_pk_csr%NOTFOUND THEN
98: RAISE NO_DATA_FOUND;
99: END IF;
100: CLOSE OKC_DOC_QA_LISTS_pk_csr;
101:
102: IF (l_debug = 'Y') THEN
103: Okc_Debug.Log('500: Leaving get_rec ', 2);
104: END IF;

Line 122: IF OKC_DOC_QA_LISTS_pk_csr%ISOPEN THEN

118: p_token1_value => sqlcode,
119: p_token2 => G_SQLERRM_TOKEN,
120: p_token2_value => sqlerrm);
121:
122: IF OKC_DOC_QA_LISTS_pk_csr%ISOPEN THEN
123: CLOSE OKC_DOC_QA_LISTS_pk_csr;
124: END IF;
125:
126: RETURN G_RET_STS_UNEXP_ERROR ;

Line 123: CLOSE OKC_DOC_QA_LISTS_pk_csr;

119: p_token2 => G_SQLERRM_TOKEN,
120: p_token2_value => sqlerrm);
121:
122: IF OKC_DOC_QA_LISTS_pk_csr%ISOPEN THEN
123: CLOSE OKC_DOC_QA_LISTS_pk_csr;
124: END IF;
125:
126: RETURN G_RET_STS_UNEXP_ERROR ;
127:

Line 131: -- Set_Attributes for:OKC_DOC_QA_LISTS --

127:
128: END Get_Rec;
129:
130: -----------------------------------------
131: -- Set_Attributes for:OKC_DOC_QA_LISTS --
132: -----------------------------------------
133: FUNCTION Set_Attributes(
134: p_qa_code IN VARCHAR2,
135: p_document_type IN VARCHAR2,

Line 145: l_object_version_number OKC_DOC_QA_LISTS.OBJECT_VERSION_NUMBER%TYPE;

141: x_severity_flag OUT NOCOPY VARCHAR2,
142: x_enable_qa_yn OUT NOCOPY VARCHAR2
143: ) RETURN VARCHAR2 IS
144: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
145: l_object_version_number OKC_DOC_QA_LISTS.OBJECT_VERSION_NUMBER%TYPE;
146: l_created_by OKC_DOC_QA_LISTS.CREATED_BY%TYPE;
147: l_creation_date OKC_DOC_QA_LISTS.CREATION_DATE%TYPE;
148: l_last_updated_by OKC_DOC_QA_LISTS.LAST_UPDATED_BY%TYPE;
149: l_last_update_login OKC_DOC_QA_LISTS.LAST_UPDATE_LOGIN%TYPE;

Line 146: l_created_by OKC_DOC_QA_LISTS.CREATED_BY%TYPE;

142: x_enable_qa_yn OUT NOCOPY VARCHAR2
143: ) RETURN VARCHAR2 IS
144: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
145: l_object_version_number OKC_DOC_QA_LISTS.OBJECT_VERSION_NUMBER%TYPE;
146: l_created_by OKC_DOC_QA_LISTS.CREATED_BY%TYPE;
147: l_creation_date OKC_DOC_QA_LISTS.CREATION_DATE%TYPE;
148: l_last_updated_by OKC_DOC_QA_LISTS.LAST_UPDATED_BY%TYPE;
149: l_last_update_login OKC_DOC_QA_LISTS.LAST_UPDATE_LOGIN%TYPE;
150: l_last_update_date OKC_DOC_QA_LISTS.LAST_UPDATE_DATE%TYPE;

Line 147: l_creation_date OKC_DOC_QA_LISTS.CREATION_DATE%TYPE;

143: ) RETURN VARCHAR2 IS
144: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
145: l_object_version_number OKC_DOC_QA_LISTS.OBJECT_VERSION_NUMBER%TYPE;
146: l_created_by OKC_DOC_QA_LISTS.CREATED_BY%TYPE;
147: l_creation_date OKC_DOC_QA_LISTS.CREATION_DATE%TYPE;
148: l_last_updated_by OKC_DOC_QA_LISTS.LAST_UPDATED_BY%TYPE;
149: l_last_update_login OKC_DOC_QA_LISTS.LAST_UPDATE_LOGIN%TYPE;
150: l_last_update_date OKC_DOC_QA_LISTS.LAST_UPDATE_DATE%TYPE;
151: BEGIN

Line 148: l_last_updated_by OKC_DOC_QA_LISTS.LAST_UPDATED_BY%TYPE;

144: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
145: l_object_version_number OKC_DOC_QA_LISTS.OBJECT_VERSION_NUMBER%TYPE;
146: l_created_by OKC_DOC_QA_LISTS.CREATED_BY%TYPE;
147: l_creation_date OKC_DOC_QA_LISTS.CREATION_DATE%TYPE;
148: l_last_updated_by OKC_DOC_QA_LISTS.LAST_UPDATED_BY%TYPE;
149: l_last_update_login OKC_DOC_QA_LISTS.LAST_UPDATE_LOGIN%TYPE;
150: l_last_update_date OKC_DOC_QA_LISTS.LAST_UPDATE_DATE%TYPE;
151: BEGIN
152: IF (l_debug = 'Y') THEN

Line 149: l_last_update_login OKC_DOC_QA_LISTS.LAST_UPDATE_LOGIN%TYPE;

145: l_object_version_number OKC_DOC_QA_LISTS.OBJECT_VERSION_NUMBER%TYPE;
146: l_created_by OKC_DOC_QA_LISTS.CREATED_BY%TYPE;
147: l_creation_date OKC_DOC_QA_LISTS.CREATION_DATE%TYPE;
148: l_last_updated_by OKC_DOC_QA_LISTS.LAST_UPDATED_BY%TYPE;
149: l_last_update_login OKC_DOC_QA_LISTS.LAST_UPDATE_LOGIN%TYPE;
150: l_last_update_date OKC_DOC_QA_LISTS.LAST_UPDATE_DATE%TYPE;
151: BEGIN
152: IF (l_debug = 'Y') THEN
153: Okc_Debug.Log('700: Entered Set_Attributes ', 2);

Line 150: l_last_update_date OKC_DOC_QA_LISTS.LAST_UPDATE_DATE%TYPE;

146: l_created_by OKC_DOC_QA_LISTS.CREATED_BY%TYPE;
147: l_creation_date OKC_DOC_QA_LISTS.CREATION_DATE%TYPE;
148: l_last_updated_by OKC_DOC_QA_LISTS.LAST_UPDATED_BY%TYPE;
149: l_last_update_login OKC_DOC_QA_LISTS.LAST_UPDATE_LOGIN%TYPE;
150: l_last_update_date OKC_DOC_QA_LISTS.LAST_UPDATE_DATE%TYPE;
151: BEGIN
152: IF (l_debug = 'Y') THEN
153: Okc_Debug.Log('700: Entered Set_Attributes ', 2);
154: END IF;

Line 227: -- Validate_Attributes for: OKC_DOC_QA_LISTS --

223:
224: END Set_Attributes ;
225:
226: ----------------------------------------------
227: -- Validate_Attributes for: OKC_DOC_QA_LISTS --
228: ----------------------------------------------
229: FUNCTION Validate_Attributes (
230: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
231:

Line 399: -- Validate_Record for:OKC_DOC_QA_LISTS --

395: -- PROCEDURE Validate_Record
396: -- It calls Item Level Validations and then makes Record Level Validations
397: ---------------------------------------------------------------------------
398: ------------------------------------------
399: -- Validate_Record for:OKC_DOC_QA_LISTS --
400: ------------------------------------------
401: FUNCTION Validate_Record (
402: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
403:

Line 468: -- validate_row for:OKC_DOC_QA_LISTS --

464: ---------------------------------------------------------------------------
465: -- PROCEDURE validate_row
466: ---------------------------------------------------------------------------
467: ---------------------------------------
468: -- validate_row for:OKC_DOC_QA_LISTS --
469: ---------------------------------------
470: PROCEDURE validate_row(
471: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
472:

Line 484: l_severity_flag OKC_DOC_QA_LISTS.SEVERITY_FLAG%TYPE;

480:
481:
482: p_object_version_number IN NUMBER
483: ) IS
484: l_severity_flag OKC_DOC_QA_LISTS.SEVERITY_FLAG%TYPE;
485: l_enable_qa_yn OKC_DOC_QA_LISTS.enable_qa_yn%TYPE;
486: l_object_version_number OKC_DOC_QA_LISTS.OBJECT_VERSION_NUMBER%TYPE;
487: l_created_by OKC_DOC_QA_LISTS.CREATED_BY%TYPE;
488: l_creation_date OKC_DOC_QA_LISTS.CREATION_DATE%TYPE;

Line 485: l_enable_qa_yn OKC_DOC_QA_LISTS.enable_qa_yn%TYPE;

481:
482: p_object_version_number IN NUMBER
483: ) IS
484: l_severity_flag OKC_DOC_QA_LISTS.SEVERITY_FLAG%TYPE;
485: l_enable_qa_yn OKC_DOC_QA_LISTS.enable_qa_yn%TYPE;
486: l_object_version_number OKC_DOC_QA_LISTS.OBJECT_VERSION_NUMBER%TYPE;
487: l_created_by OKC_DOC_QA_LISTS.CREATED_BY%TYPE;
488: l_creation_date OKC_DOC_QA_LISTS.CREATION_DATE%TYPE;
489: l_last_updated_by OKC_DOC_QA_LISTS.LAST_UPDATED_BY%TYPE;

Line 486: l_object_version_number OKC_DOC_QA_LISTS.OBJECT_VERSION_NUMBER%TYPE;

482: p_object_version_number IN NUMBER
483: ) IS
484: l_severity_flag OKC_DOC_QA_LISTS.SEVERITY_FLAG%TYPE;
485: l_enable_qa_yn OKC_DOC_QA_LISTS.enable_qa_yn%TYPE;
486: l_object_version_number OKC_DOC_QA_LISTS.OBJECT_VERSION_NUMBER%TYPE;
487: l_created_by OKC_DOC_QA_LISTS.CREATED_BY%TYPE;
488: l_creation_date OKC_DOC_QA_LISTS.CREATION_DATE%TYPE;
489: l_last_updated_by OKC_DOC_QA_LISTS.LAST_UPDATED_BY%TYPE;
490: l_last_update_login OKC_DOC_QA_LISTS.LAST_UPDATE_LOGIN%TYPE;

Line 487: l_created_by OKC_DOC_QA_LISTS.CREATED_BY%TYPE;

483: ) IS
484: l_severity_flag OKC_DOC_QA_LISTS.SEVERITY_FLAG%TYPE;
485: l_enable_qa_yn OKC_DOC_QA_LISTS.enable_qa_yn%TYPE;
486: l_object_version_number OKC_DOC_QA_LISTS.OBJECT_VERSION_NUMBER%TYPE;
487: l_created_by OKC_DOC_QA_LISTS.CREATED_BY%TYPE;
488: l_creation_date OKC_DOC_QA_LISTS.CREATION_DATE%TYPE;
489: l_last_updated_by OKC_DOC_QA_LISTS.LAST_UPDATED_BY%TYPE;
490: l_last_update_login OKC_DOC_QA_LISTS.LAST_UPDATE_LOGIN%TYPE;
491: l_last_update_date OKC_DOC_QA_LISTS.LAST_UPDATE_DATE%TYPE;

Line 488: l_creation_date OKC_DOC_QA_LISTS.CREATION_DATE%TYPE;

484: l_severity_flag OKC_DOC_QA_LISTS.SEVERITY_FLAG%TYPE;
485: l_enable_qa_yn OKC_DOC_QA_LISTS.enable_qa_yn%TYPE;
486: l_object_version_number OKC_DOC_QA_LISTS.OBJECT_VERSION_NUMBER%TYPE;
487: l_created_by OKC_DOC_QA_LISTS.CREATED_BY%TYPE;
488: l_creation_date OKC_DOC_QA_LISTS.CREATION_DATE%TYPE;
489: l_last_updated_by OKC_DOC_QA_LISTS.LAST_UPDATED_BY%TYPE;
490: l_last_update_login OKC_DOC_QA_LISTS.LAST_UPDATE_LOGIN%TYPE;
491: l_last_update_date OKC_DOC_QA_LISTS.LAST_UPDATE_DATE%TYPE;
492: BEGIN

Line 489: l_last_updated_by OKC_DOC_QA_LISTS.LAST_UPDATED_BY%TYPE;

485: l_enable_qa_yn OKC_DOC_QA_LISTS.enable_qa_yn%TYPE;
486: l_object_version_number OKC_DOC_QA_LISTS.OBJECT_VERSION_NUMBER%TYPE;
487: l_created_by OKC_DOC_QA_LISTS.CREATED_BY%TYPE;
488: l_creation_date OKC_DOC_QA_LISTS.CREATION_DATE%TYPE;
489: l_last_updated_by OKC_DOC_QA_LISTS.LAST_UPDATED_BY%TYPE;
490: l_last_update_login OKC_DOC_QA_LISTS.LAST_UPDATE_LOGIN%TYPE;
491: l_last_update_date OKC_DOC_QA_LISTS.LAST_UPDATE_DATE%TYPE;
492: BEGIN
493:

Line 490: l_last_update_login OKC_DOC_QA_LISTS.LAST_UPDATE_LOGIN%TYPE;

486: l_object_version_number OKC_DOC_QA_LISTS.OBJECT_VERSION_NUMBER%TYPE;
487: l_created_by OKC_DOC_QA_LISTS.CREATED_BY%TYPE;
488: l_creation_date OKC_DOC_QA_LISTS.CREATION_DATE%TYPE;
489: l_last_updated_by OKC_DOC_QA_LISTS.LAST_UPDATED_BY%TYPE;
490: l_last_update_login OKC_DOC_QA_LISTS.LAST_UPDATE_LOGIN%TYPE;
491: l_last_update_date OKC_DOC_QA_LISTS.LAST_UPDATE_DATE%TYPE;
492: BEGIN
493:
494: IF (l_debug = 'Y') THEN

Line 491: l_last_update_date OKC_DOC_QA_LISTS.LAST_UPDATE_DATE%TYPE;

487: l_created_by OKC_DOC_QA_LISTS.CREATED_BY%TYPE;
488: l_creation_date OKC_DOC_QA_LISTS.CREATION_DATE%TYPE;
489: l_last_updated_by OKC_DOC_QA_LISTS.LAST_UPDATED_BY%TYPE;
490: l_last_update_login OKC_DOC_QA_LISTS.LAST_UPDATE_LOGIN%TYPE;
491: l_last_update_date OKC_DOC_QA_LISTS.LAST_UPDATE_DATE%TYPE;
492: BEGIN
493:
494: IF (l_debug = 'Y') THEN
495: Okc_Debug.Log('3100: Entered validate_row', 2);

Line 559: -- Insert_Row for:OKC_DOC_QA_LISTS --

555: ---------------------------------------------------------------------------
556: -- PROCEDURE Insert_Row
557: ---------------------------------------------------------------------------
558: -------------------------------------
559: -- Insert_Row for:OKC_DOC_QA_LISTS --
560: -------------------------------------
561: FUNCTION Insert_Row(
562: p_qa_code IN VARCHAR2,
563: p_document_type IN VARCHAR2,

Line 581: INSERT INTO OKC_DOC_QA_LISTS(

577: IF (l_debug = 'Y') THEN
578: Okc_Debug.Log('3600: Entered Insert_Row function', 2);
579: END IF;
580:
581: INSERT INTO OKC_DOC_QA_LISTS(
582: QA_CODE,
583: DOCUMENT_TYPE,
584: SEVERITY_FLAG,
585: ENABLE_QA_YN,

Line 630: -- Insert_Row for:OKC_DOC_QA_LISTS --

626: END Insert_Row;
627:
628:
629: -------------------------------------
630: -- Insert_Row for:OKC_DOC_QA_LISTS --
631: -------------------------------------
632: PROCEDURE Insert_Row(
633: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
634: x_return_status OUT NOCOPY VARCHAR2,

Line 648: l_object_version_number OKC_DOC_QA_LISTS.OBJECT_VERSION_NUMBER%TYPE;

644: x_document_type OUT NOCOPY VARCHAR2
645:
646: ) IS
647:
648: l_object_version_number OKC_DOC_QA_LISTS.OBJECT_VERSION_NUMBER%TYPE;
649: l_created_by OKC_DOC_QA_LISTS.CREATED_BY%TYPE;
650: l_creation_date OKC_DOC_QA_LISTS.CREATION_DATE%TYPE;
651: l_last_updated_by OKC_DOC_QA_LISTS.LAST_UPDATED_BY%TYPE;
652: l_last_update_login OKC_DOC_QA_LISTS.LAST_UPDATE_LOGIN%TYPE;

Line 649: l_created_by OKC_DOC_QA_LISTS.CREATED_BY%TYPE;

645:
646: ) IS
647:
648: l_object_version_number OKC_DOC_QA_LISTS.OBJECT_VERSION_NUMBER%TYPE;
649: l_created_by OKC_DOC_QA_LISTS.CREATED_BY%TYPE;
650: l_creation_date OKC_DOC_QA_LISTS.CREATION_DATE%TYPE;
651: l_last_updated_by OKC_DOC_QA_LISTS.LAST_UPDATED_BY%TYPE;
652: l_last_update_login OKC_DOC_QA_LISTS.LAST_UPDATE_LOGIN%TYPE;
653: l_last_update_date OKC_DOC_QA_LISTS.LAST_UPDATE_DATE%TYPE;

Line 650: l_creation_date OKC_DOC_QA_LISTS.CREATION_DATE%TYPE;

646: ) IS
647:
648: l_object_version_number OKC_DOC_QA_LISTS.OBJECT_VERSION_NUMBER%TYPE;
649: l_created_by OKC_DOC_QA_LISTS.CREATED_BY%TYPE;
650: l_creation_date OKC_DOC_QA_LISTS.CREATION_DATE%TYPE;
651: l_last_updated_by OKC_DOC_QA_LISTS.LAST_UPDATED_BY%TYPE;
652: l_last_update_login OKC_DOC_QA_LISTS.LAST_UPDATE_LOGIN%TYPE;
653: l_last_update_date OKC_DOC_QA_LISTS.LAST_UPDATE_DATE%TYPE;
654: BEGIN

Line 651: l_last_updated_by OKC_DOC_QA_LISTS.LAST_UPDATED_BY%TYPE;

647:
648: l_object_version_number OKC_DOC_QA_LISTS.OBJECT_VERSION_NUMBER%TYPE;
649: l_created_by OKC_DOC_QA_LISTS.CREATED_BY%TYPE;
650: l_creation_date OKC_DOC_QA_LISTS.CREATION_DATE%TYPE;
651: l_last_updated_by OKC_DOC_QA_LISTS.LAST_UPDATED_BY%TYPE;
652: l_last_update_login OKC_DOC_QA_LISTS.LAST_UPDATE_LOGIN%TYPE;
653: l_last_update_date OKC_DOC_QA_LISTS.LAST_UPDATE_DATE%TYPE;
654: BEGIN
655:

Line 652: l_last_update_login OKC_DOC_QA_LISTS.LAST_UPDATE_LOGIN%TYPE;

648: l_object_version_number OKC_DOC_QA_LISTS.OBJECT_VERSION_NUMBER%TYPE;
649: l_created_by OKC_DOC_QA_LISTS.CREATED_BY%TYPE;
650: l_creation_date OKC_DOC_QA_LISTS.CREATION_DATE%TYPE;
651: l_last_updated_by OKC_DOC_QA_LISTS.LAST_UPDATED_BY%TYPE;
652: l_last_update_login OKC_DOC_QA_LISTS.LAST_UPDATE_LOGIN%TYPE;
653: l_last_update_date OKC_DOC_QA_LISTS.LAST_UPDATE_DATE%TYPE;
654: BEGIN
655:
656: x_return_status := G_RET_STS_SUCCESS;

Line 653: l_last_update_date OKC_DOC_QA_LISTS.LAST_UPDATE_DATE%TYPE;

649: l_created_by OKC_DOC_QA_LISTS.CREATED_BY%TYPE;
650: l_creation_date OKC_DOC_QA_LISTS.CREATION_DATE%TYPE;
651: l_last_updated_by OKC_DOC_QA_LISTS.LAST_UPDATED_BY%TYPE;
652: l_last_update_login OKC_DOC_QA_LISTS.LAST_UPDATE_LOGIN%TYPE;
653: l_last_update_date OKC_DOC_QA_LISTS.LAST_UPDATE_DATE%TYPE;
654: BEGIN
655:
656: x_return_status := G_RET_STS_SUCCESS;
657:

Line 751: -- Lock_Row for:OKC_DOC_QA_LISTS --

747: ---------------------------------------------------------------------------
748: -- PROCEDURE Lock_Row
749: ---------------------------------------------------------------------------
750: -----------------------------------
751: -- Lock_Row for:OKC_DOC_QA_LISTS --
752: -----------------------------------
753: FUNCTION Lock_Row(
754: p_qa_code IN VARCHAR2,
755: p_document_type IN VARCHAR2,

Line 764: FROM OKC_DOC_QA_LISTS

760: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
761:
762: CURSOR lock_csr (cp_qa_code VARCHAR2, cp_document_type VARCHAR2, cp_object_version_number NUMBER) IS
763: SELECT object_version_number
764: FROM OKC_DOC_QA_LISTS
765: WHERE QA_CODE = cp_qa_code AND DOCUMENT_TYPE = cp_document_type
766: AND (object_version_number = cp_object_version_number OR cp_object_version_number IS NULL)
767: FOR UPDATE OF object_version_number NOWAIT;
768:

Line 771: FROM OKC_DOC_QA_LISTS

767: FOR UPDATE OF object_version_number NOWAIT;
768:
769: CURSOR lchk_csr (cp_qa_code VARCHAR2, cp_document_type VARCHAR2) IS
770: SELECT object_version_number
771: FROM OKC_DOC_QA_LISTS
772: WHERE QA_CODE = cp_qa_code AND DOCUMENT_TYPE = cp_document_type;
773:
774: l_return_status VARCHAR2(1);
775:

Line 776: l_object_version_number OKC_DOC_QA_LISTS.OBJECT_VERSION_NUMBER%TYPE;

772: WHERE QA_CODE = cp_qa_code AND DOCUMENT_TYPE = cp_document_type;
773:
774: l_return_status VARCHAR2(1);
775:
776: l_object_version_number OKC_DOC_QA_LISTS.OBJECT_VERSION_NUMBER%TYPE;
777:
778: l_row_notfound BOOLEAN := FALSE;
779: BEGIN
780:

Line 859: -- Lock_Row for:OKC_DOC_QA_LISTS --

855: RETURN( G_RET_STS_UNEXP_ERROR );
856: END Lock_Row;
857:
858: -----------------------------------
859: -- Lock_Row for:OKC_DOC_QA_LISTS --
860: -----------------------------------
861: PROCEDURE Lock_Row(
862: x_return_status OUT NOCOPY VARCHAR2,
863:

Line 925: -- Update_Row for:OKC_DOC_QA_LISTS --

921: ---------------------------------------------------------------------------
922: -- PROCEDURE Update_Row
923: ---------------------------------------------------------------------------
924: -------------------------------------
925: -- Update_Row for:OKC_DOC_QA_LISTS --
926: -------------------------------------
927: FUNCTION Update_Row(
928: p_qa_code IN VARCHAR2,
929: p_document_type IN VARCHAR2,

Line 944: UPDATE OKC_DOC_QA_LISTS

940: IF (l_debug = 'Y') THEN
941: Okc_Debug.Log('6400: Entered Update_Row', 2);
942: END IF;
943:
944: UPDATE OKC_DOC_QA_LISTS
945: SET SEVERITY_FLAG = p_severity_flag,
946: ENABLE_QA_YN = p_enable_qa_yn,
947: OBJECT_VERSION_NUMBER = p_object_version_number,
948: LAST_UPDATED_BY = p_last_updated_by,

Line 978: -- Update_Row for:OKC_DOC_QA_LISTS --

974:
975: END Update_Row;
976:
977: -------------------------------------
978: -- Update_Row for:OKC_DOC_QA_LISTS --
979: -------------------------------------
980: PROCEDURE Update_Row(
981: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
982:

Line 994: l_severity_flag OKC_DOC_QA_LISTS.SEVERITY_FLAG%TYPE;

990: p_object_version_number IN NUMBER
991:
992: ) IS
993:
994: l_severity_flag OKC_DOC_QA_LISTS.SEVERITY_FLAG%TYPE;
995: l_enable_qa_yn OKC_DOC_QA_LISTS.ENABLE_QA_YN%TYPE;
996: l_object_version_number OKC_DOC_QA_LISTS.OBJECT_VERSION_NUMBER%TYPE;
997: l_last_updated_by OKC_DOC_QA_LISTS.LAST_UPDATED_BY%TYPE;
998: l_last_update_login OKC_DOC_QA_LISTS.LAST_UPDATE_LOGIN%TYPE;

Line 995: l_enable_qa_yn OKC_DOC_QA_LISTS.ENABLE_QA_YN%TYPE;

991:
992: ) IS
993:
994: l_severity_flag OKC_DOC_QA_LISTS.SEVERITY_FLAG%TYPE;
995: l_enable_qa_yn OKC_DOC_QA_LISTS.ENABLE_QA_YN%TYPE;
996: l_object_version_number OKC_DOC_QA_LISTS.OBJECT_VERSION_NUMBER%TYPE;
997: l_last_updated_by OKC_DOC_QA_LISTS.LAST_UPDATED_BY%TYPE;
998: l_last_update_login OKC_DOC_QA_LISTS.LAST_UPDATE_LOGIN%TYPE;
999: l_last_update_date OKC_DOC_QA_LISTS.LAST_UPDATE_DATE%TYPE;

Line 996: l_object_version_number OKC_DOC_QA_LISTS.OBJECT_VERSION_NUMBER%TYPE;

992: ) IS
993:
994: l_severity_flag OKC_DOC_QA_LISTS.SEVERITY_FLAG%TYPE;
995: l_enable_qa_yn OKC_DOC_QA_LISTS.ENABLE_QA_YN%TYPE;
996: l_object_version_number OKC_DOC_QA_LISTS.OBJECT_VERSION_NUMBER%TYPE;
997: l_last_updated_by OKC_DOC_QA_LISTS.LAST_UPDATED_BY%TYPE;
998: l_last_update_login OKC_DOC_QA_LISTS.LAST_UPDATE_LOGIN%TYPE;
999: l_last_update_date OKC_DOC_QA_LISTS.LAST_UPDATE_DATE%TYPE;
1000:

Line 997: l_last_updated_by OKC_DOC_QA_LISTS.LAST_UPDATED_BY%TYPE;

993:
994: l_severity_flag OKC_DOC_QA_LISTS.SEVERITY_FLAG%TYPE;
995: l_enable_qa_yn OKC_DOC_QA_LISTS.ENABLE_QA_YN%TYPE;
996: l_object_version_number OKC_DOC_QA_LISTS.OBJECT_VERSION_NUMBER%TYPE;
997: l_last_updated_by OKC_DOC_QA_LISTS.LAST_UPDATED_BY%TYPE;
998: l_last_update_login OKC_DOC_QA_LISTS.LAST_UPDATE_LOGIN%TYPE;
999: l_last_update_date OKC_DOC_QA_LISTS.LAST_UPDATE_DATE%TYPE;
1000:
1001: BEGIN

Line 998: l_last_update_login OKC_DOC_QA_LISTS.LAST_UPDATE_LOGIN%TYPE;

994: l_severity_flag OKC_DOC_QA_LISTS.SEVERITY_FLAG%TYPE;
995: l_enable_qa_yn OKC_DOC_QA_LISTS.ENABLE_QA_YN%TYPE;
996: l_object_version_number OKC_DOC_QA_LISTS.OBJECT_VERSION_NUMBER%TYPE;
997: l_last_updated_by OKC_DOC_QA_LISTS.LAST_UPDATED_BY%TYPE;
998: l_last_update_login OKC_DOC_QA_LISTS.LAST_UPDATE_LOGIN%TYPE;
999: l_last_update_date OKC_DOC_QA_LISTS.LAST_UPDATE_DATE%TYPE;
1000:
1001: BEGIN
1002:

Line 999: l_last_update_date OKC_DOC_QA_LISTS.LAST_UPDATE_DATE%TYPE;

995: l_enable_qa_yn OKC_DOC_QA_LISTS.ENABLE_QA_YN%TYPE;
996: l_object_version_number OKC_DOC_QA_LISTS.OBJECT_VERSION_NUMBER%TYPE;
997: l_last_updated_by OKC_DOC_QA_LISTS.LAST_UPDATED_BY%TYPE;
998: l_last_update_login OKC_DOC_QA_LISTS.LAST_UPDATE_LOGIN%TYPE;
999: l_last_update_date OKC_DOC_QA_LISTS.LAST_UPDATE_DATE%TYPE;
1000:
1001: BEGIN
1002:
1003: IF (l_debug = 'Y') THEN

Line 1132: -- Delete_Row for:OKC_DOC_QA_LISTS --

1128: ---------------------------------------------------------------------------
1129: -- PROCEDURE Delete_Row
1130: ---------------------------------------------------------------------------
1131: -------------------------------------
1132: -- Delete_Row for:OKC_DOC_QA_LISTS --
1133: -------------------------------------
1134: FUNCTION Delete_Row(
1135: p_qa_code IN VARCHAR2,
1136: p_document_type IN VARCHAR2

Line 1145: DELETE FROM OKC_DOC_QA_LISTS

1141: IF (l_debug = 'Y') THEN
1142: Okc_Debug.Log('8200: Entered Delete_Row', 2);
1143: END IF;
1144:
1145: DELETE FROM OKC_DOC_QA_LISTS
1146: WHERE QA_CODE = p_QA_CODE AND DOCUMENT_TYPE = p_DOCUMENT_TYPE;
1147:
1148: IF (l_debug = 'Y') THEN
1149: Okc_Debug.Log('8300: Leaving Delete_Row', 2);

Line 1173: -- Delete_Row for:OKC_DOC_QA_LISTS --

1169:
1170: END Delete_Row;
1171:
1172: -------------------------------------
1173: -- Delete_Row for:OKC_DOC_QA_LISTS --
1174: -------------------------------------
1175: PROCEDURE Delete_Row(
1176: x_return_status OUT NOCOPY VARCHAR2,
1177: p_qa_code IN VARCHAR2,