APPS.OKC_REVIEW_UPLD_HEADER_PVT dependencies on OKC_REVIEW_UPLD_HEADER

Line 1: PACKAGE BODY OKC_REVIEW_UPLD_HEADER_PVT AS

1: PACKAGE BODY OKC_REVIEW_UPLD_HEADER_PVT AS
2: /* $Header: OKCVRUHB.pls 120.0 2005/09/13 22:47 vnanjang noship $ */
3:
4: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
5:

Line 30: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_review_upld_header_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_review_upld_header_PVT';
31: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
32:
33: ------------------------------------------------------------------------------
34: -- GLOBAL CONSTANTS

Line 63: SELECT OKC_review_upld_header_S1.NEXTVAL FROM DUAL;

59: p_review_upld_header_id IN NUMBER,
60: x_review_upld_header_id OUT NOCOPY NUMBER
61: ) RETURN VARCHAR2 IS
62: CURSOR l_seq_csr IS
63: SELECT OKC_review_upld_header_S1.NEXTVAL FROM DUAL;
64: BEGIN
65: IF (l_debug = 'Y') THEN
66: Okc_Debug.Log('100: Entered get_seq_id', 2);
67: END IF;

Line 105: -- FUNCTION get_rec for: OKC_review_upld_header

101:
102: END Get_Seq_Id;
103:
104: ---------------------------------------------------------------------------
105: -- FUNCTION get_rec for: OKC_review_upld_header
106: ---------------------------------------------------------------------------
107: FUNCTION Get_Rec (
108: p_review_upld_header_id IN NUMBER,
109:

Line 126: CURSOR OKC_review_upld_header_pk_csr (cp_review_upld_header_id IN NUMBER) IS

122: x_enable_reporting_flag OUT NOCOPY VARCHAR2,
123: x_file_description OUT NOCOPY VARCHAR2
124:
125: ) RETURN VARCHAR2 IS
126: CURSOR OKC_review_upld_header_pk_csr (cp_review_upld_header_id IN NUMBER) IS
127: SELECT
128: FILE_NAME,
129: FILE_CONTENT_TYPE,
130: FILE_DATA,

Line 142: FROM OKC_review_upld_header t

138: LAST_UPDATE_DATE,
139: new_contract_source,
140: enable_reporting_flag,
141: file_description
142: FROM OKC_review_upld_header t
143: WHERE t.review_upld_header_ID = cp_review_upld_header_id;
144: BEGIN
145:
146: IF (l_debug = 'Y') THEN

Line 151: OPEN OKC_review_upld_header_pk_csr (p_review_upld_header_id);

147: Okc_Debug.Log('400: Entered get_rec', 2);
148: END IF;
149:
150: -- Get current database values
151: OPEN OKC_review_upld_header_pk_csr (p_review_upld_header_id);
152: FETCH OKC_review_upld_header_pk_csr INTO
153: x_file_name,
154: x_file_content_type,
155: x_file_data,

Line 152: FETCH OKC_review_upld_header_pk_csr INTO

148: END IF;
149:
150: -- Get current database values
151: OPEN OKC_review_upld_header_pk_csr (p_review_upld_header_id);
152: FETCH OKC_review_upld_header_pk_csr INTO
153: x_file_name,
154: x_file_content_type,
155: x_file_data,
156: x_document_type,

Line 167: IF OKC_review_upld_header_pk_csr%NOTFOUND THEN

163: x_last_update_date,
164: x_new_contract_source,
165: x_enable_reporting_flag,
166: x_file_description ;
167: IF OKC_review_upld_header_pk_csr%NOTFOUND THEN
168: RAISE NO_DATA_FOUND;
169: END IF;
170: CLOSE OKC_review_upld_header_pk_csr;
171:

Line 170: CLOSE OKC_review_upld_header_pk_csr;

166: x_file_description ;
167: IF OKC_review_upld_header_pk_csr%NOTFOUND THEN
168: RAISE NO_DATA_FOUND;
169: END IF;
170: CLOSE OKC_review_upld_header_pk_csr;
171:
172: IF (l_debug = 'Y') THEN
173: Okc_Debug.Log('500: Leaving get_rec ', 2);
174: END IF;

Line 192: IF OKC_review_upld_header_pk_csr%ISOPEN THEN

188: p_token1_value => sqlcode,
189: p_token2 => G_SQLERRM_TOKEN,
190: p_token2_value => sqlerrm);
191:
192: IF OKC_review_upld_header_pk_csr%ISOPEN THEN
193: CLOSE OKC_review_upld_header_pk_csr;
194: END IF;
195:
196: RETURN G_RET_STS_UNEXP_ERROR ;

Line 193: CLOSE OKC_review_upld_header_pk_csr;

189: p_token2 => G_SQLERRM_TOKEN,
190: p_token2_value => sqlerrm);
191:
192: IF OKC_review_upld_header_pk_csr%ISOPEN THEN
193: CLOSE OKC_review_upld_header_pk_csr;
194: END IF;
195:
196: RETURN G_RET_STS_UNEXP_ERROR ;
197:

Line 201: -- Set_Attributes for:OKC_review_upld_header --

197:
198: END Get_Rec;
199:
200: -----------------------------------------
201: -- Set_Attributes for:OKC_review_upld_header --
202: -----------------------------------------
203: FUNCTION Set_Attributes(
204: p_review_upld_header_id IN NUMBER,
205: p_file_name IN VARCHAR2,

Line 224: l_object_version_number OKC_review_upld_header.OBJECT_VERSION_NUMBER%TYPE;

220: x_enable_reporting_flag OUT NOCOPY VARCHAR2,
221: x_file_description OUT NOCOPY VARCHAR2
222: ) RETURN VARCHAR2 IS
223: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
224: l_object_version_number OKC_review_upld_header.OBJECT_VERSION_NUMBER%TYPE;
225: l_created_by OKC_review_upld_header.CREATED_BY%TYPE;
226: l_creation_date OKC_review_upld_header.CREATION_DATE%TYPE;
227: l_last_updated_by OKC_review_upld_header.LAST_UPDATED_BY%TYPE;
228: l_last_update_login OKC_review_upld_header.LAST_UPDATE_LOGIN%TYPE;

Line 225: l_created_by OKC_review_upld_header.CREATED_BY%TYPE;

221: x_file_description OUT NOCOPY VARCHAR2
222: ) RETURN VARCHAR2 IS
223: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
224: l_object_version_number OKC_review_upld_header.OBJECT_VERSION_NUMBER%TYPE;
225: l_created_by OKC_review_upld_header.CREATED_BY%TYPE;
226: l_creation_date OKC_review_upld_header.CREATION_DATE%TYPE;
227: l_last_updated_by OKC_review_upld_header.LAST_UPDATED_BY%TYPE;
228: l_last_update_login OKC_review_upld_header.LAST_UPDATE_LOGIN%TYPE;
229: l_last_update_date OKC_review_upld_header.LAST_UPDATE_DATE%TYPE;

Line 226: l_creation_date OKC_review_upld_header.CREATION_DATE%TYPE;

222: ) RETURN VARCHAR2 IS
223: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
224: l_object_version_number OKC_review_upld_header.OBJECT_VERSION_NUMBER%TYPE;
225: l_created_by OKC_review_upld_header.CREATED_BY%TYPE;
226: l_creation_date OKC_review_upld_header.CREATION_DATE%TYPE;
227: l_last_updated_by OKC_review_upld_header.LAST_UPDATED_BY%TYPE;
228: l_last_update_login OKC_review_upld_header.LAST_UPDATE_LOGIN%TYPE;
229: l_last_update_date OKC_review_upld_header.LAST_UPDATE_DATE%TYPE;
230: BEGIN

Line 227: l_last_updated_by OKC_review_upld_header.LAST_UPDATED_BY%TYPE;

223: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
224: l_object_version_number OKC_review_upld_header.OBJECT_VERSION_NUMBER%TYPE;
225: l_created_by OKC_review_upld_header.CREATED_BY%TYPE;
226: l_creation_date OKC_review_upld_header.CREATION_DATE%TYPE;
227: l_last_updated_by OKC_review_upld_header.LAST_UPDATED_BY%TYPE;
228: l_last_update_login OKC_review_upld_header.LAST_UPDATE_LOGIN%TYPE;
229: l_last_update_date OKC_review_upld_header.LAST_UPDATE_DATE%TYPE;
230: BEGIN
231: IF (l_debug = 'Y') THEN

Line 228: l_last_update_login OKC_review_upld_header.LAST_UPDATE_LOGIN%TYPE;

224: l_object_version_number OKC_review_upld_header.OBJECT_VERSION_NUMBER%TYPE;
225: l_created_by OKC_review_upld_header.CREATED_BY%TYPE;
226: l_creation_date OKC_review_upld_header.CREATION_DATE%TYPE;
227: l_last_updated_by OKC_review_upld_header.LAST_UPDATED_BY%TYPE;
228: l_last_update_login OKC_review_upld_header.LAST_UPDATE_LOGIN%TYPE;
229: l_last_update_date OKC_review_upld_header.LAST_UPDATE_DATE%TYPE;
230: BEGIN
231: IF (l_debug = 'Y') THEN
232: Okc_Debug.Log('700: Entered Set_Attributes ', 2);

Line 229: l_last_update_date OKC_review_upld_header.LAST_UPDATE_DATE%TYPE;

225: l_created_by OKC_review_upld_header.CREATED_BY%TYPE;
226: l_creation_date OKC_review_upld_header.CREATION_DATE%TYPE;
227: l_last_updated_by OKC_review_upld_header.LAST_UPDATED_BY%TYPE;
228: l_last_update_login OKC_review_upld_header.LAST_UPDATE_LOGIN%TYPE;
229: l_last_update_date OKC_review_upld_header.LAST_UPDATE_DATE%TYPE;
230: BEGIN
231: IF (l_debug = 'Y') THEN
232: Okc_Debug.Log('700: Entered Set_Attributes ', 2);
233: END IF;

Line 355: -- Validate_Attributes for: OKC_review_upld_header --

351:
352: END Set_Attributes ;
353:
354: ----------------------------------------------
355: -- Validate_Attributes for: OKC_review_upld_header --
356: ----------------------------------------------
357: FUNCTION Validate_Attributes (
358: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
359:

Line 506: -- Validate_Record for:OKC_review_upld_header --

502: -- PROCEDURE Validate_Record
503: -- It calls Item Level Validations and then makes Record Level Validations
504: ---------------------------------------------------------------------------
505: ------------------------------------------
506: -- Validate_Record for:OKC_review_upld_header --
507: ------------------------------------------
508: FUNCTION Validate_Record (
509: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
510:

Line 586: -- validate_row for:OKC_review_upld_header --

582: ---------------------------------------------------------------------------
583: -- PROCEDURE validate_row
584: ---------------------------------------------------------------------------
585: ---------------------------------------
586: -- validate_row for:OKC_review_upld_header --
587: ---------------------------------------
588: PROCEDURE validate_row(
589: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
590:

Line 605: l_file_name OKC_review_upld_header.FILE_NAME%TYPE;

601: p_file_description IN VARCHAR2,
602:
603: p_object_version_number IN NUMBER
604: ) IS
605: l_file_name OKC_review_upld_header.FILE_NAME%TYPE;
606: l_file_content_type OKC_review_upld_header.FILE_CONTENT_TYPE%TYPE;
607: l_file_data OKC_review_upld_header.FILE_DATA%TYPE;
608: l_document_type OKC_review_upld_header.DOCUMENT_TYPE%TYPE;
609: l_document_id OKC_review_upld_header.DOCUMENT_ID%TYPE;

Line 606: l_file_content_type OKC_review_upld_header.FILE_CONTENT_TYPE%TYPE;

602:
603: p_object_version_number IN NUMBER
604: ) IS
605: l_file_name OKC_review_upld_header.FILE_NAME%TYPE;
606: l_file_content_type OKC_review_upld_header.FILE_CONTENT_TYPE%TYPE;
607: l_file_data OKC_review_upld_header.FILE_DATA%TYPE;
608: l_document_type OKC_review_upld_header.DOCUMENT_TYPE%TYPE;
609: l_document_id OKC_review_upld_header.DOCUMENT_ID%TYPE;
610: l_object_version_number OKC_review_upld_header.OBJECT_VERSION_NUMBER%TYPE;

Line 607: l_file_data OKC_review_upld_header.FILE_DATA%TYPE;

603: p_object_version_number IN NUMBER
604: ) IS
605: l_file_name OKC_review_upld_header.FILE_NAME%TYPE;
606: l_file_content_type OKC_review_upld_header.FILE_CONTENT_TYPE%TYPE;
607: l_file_data OKC_review_upld_header.FILE_DATA%TYPE;
608: l_document_type OKC_review_upld_header.DOCUMENT_TYPE%TYPE;
609: l_document_id OKC_review_upld_header.DOCUMENT_ID%TYPE;
610: l_object_version_number OKC_review_upld_header.OBJECT_VERSION_NUMBER%TYPE;
611: l_created_by OKC_review_upld_header.CREATED_BY%TYPE;

Line 608: l_document_type OKC_review_upld_header.DOCUMENT_TYPE%TYPE;

604: ) IS
605: l_file_name OKC_review_upld_header.FILE_NAME%TYPE;
606: l_file_content_type OKC_review_upld_header.FILE_CONTENT_TYPE%TYPE;
607: l_file_data OKC_review_upld_header.FILE_DATA%TYPE;
608: l_document_type OKC_review_upld_header.DOCUMENT_TYPE%TYPE;
609: l_document_id OKC_review_upld_header.DOCUMENT_ID%TYPE;
610: l_object_version_number OKC_review_upld_header.OBJECT_VERSION_NUMBER%TYPE;
611: l_created_by OKC_review_upld_header.CREATED_BY%TYPE;
612: l_creation_date OKC_review_upld_header.CREATION_DATE%TYPE;

Line 609: l_document_id OKC_review_upld_header.DOCUMENT_ID%TYPE;

605: l_file_name OKC_review_upld_header.FILE_NAME%TYPE;
606: l_file_content_type OKC_review_upld_header.FILE_CONTENT_TYPE%TYPE;
607: l_file_data OKC_review_upld_header.FILE_DATA%TYPE;
608: l_document_type OKC_review_upld_header.DOCUMENT_TYPE%TYPE;
609: l_document_id OKC_review_upld_header.DOCUMENT_ID%TYPE;
610: l_object_version_number OKC_review_upld_header.OBJECT_VERSION_NUMBER%TYPE;
611: l_created_by OKC_review_upld_header.CREATED_BY%TYPE;
612: l_creation_date OKC_review_upld_header.CREATION_DATE%TYPE;
613: l_last_updated_by OKC_review_upld_header.LAST_UPDATED_BY%TYPE;

Line 610: l_object_version_number OKC_review_upld_header.OBJECT_VERSION_NUMBER%TYPE;

606: l_file_content_type OKC_review_upld_header.FILE_CONTENT_TYPE%TYPE;
607: l_file_data OKC_review_upld_header.FILE_DATA%TYPE;
608: l_document_type OKC_review_upld_header.DOCUMENT_TYPE%TYPE;
609: l_document_id OKC_review_upld_header.DOCUMENT_ID%TYPE;
610: l_object_version_number OKC_review_upld_header.OBJECT_VERSION_NUMBER%TYPE;
611: l_created_by OKC_review_upld_header.CREATED_BY%TYPE;
612: l_creation_date OKC_review_upld_header.CREATION_DATE%TYPE;
613: l_last_updated_by OKC_review_upld_header.LAST_UPDATED_BY%TYPE;
614: l_last_update_login OKC_review_upld_header.LAST_UPDATE_LOGIN%TYPE;

Line 611: l_created_by OKC_review_upld_header.CREATED_BY%TYPE;

607: l_file_data OKC_review_upld_header.FILE_DATA%TYPE;
608: l_document_type OKC_review_upld_header.DOCUMENT_TYPE%TYPE;
609: l_document_id OKC_review_upld_header.DOCUMENT_ID%TYPE;
610: l_object_version_number OKC_review_upld_header.OBJECT_VERSION_NUMBER%TYPE;
611: l_created_by OKC_review_upld_header.CREATED_BY%TYPE;
612: l_creation_date OKC_review_upld_header.CREATION_DATE%TYPE;
613: l_last_updated_by OKC_review_upld_header.LAST_UPDATED_BY%TYPE;
614: l_last_update_login OKC_review_upld_header.LAST_UPDATE_LOGIN%TYPE;
615: l_last_update_date OKC_review_upld_header.LAST_UPDATE_DATE%TYPE;

Line 612: l_creation_date OKC_review_upld_header.CREATION_DATE%TYPE;

608: l_document_type OKC_review_upld_header.DOCUMENT_TYPE%TYPE;
609: l_document_id OKC_review_upld_header.DOCUMENT_ID%TYPE;
610: l_object_version_number OKC_review_upld_header.OBJECT_VERSION_NUMBER%TYPE;
611: l_created_by OKC_review_upld_header.CREATED_BY%TYPE;
612: l_creation_date OKC_review_upld_header.CREATION_DATE%TYPE;
613: l_last_updated_by OKC_review_upld_header.LAST_UPDATED_BY%TYPE;
614: l_last_update_login OKC_review_upld_header.LAST_UPDATE_LOGIN%TYPE;
615: l_last_update_date OKC_review_upld_header.LAST_UPDATE_DATE%TYPE;
616: l_new_contract_source OKC_review_upld_header.new_contract_source%TYPE;

Line 613: l_last_updated_by OKC_review_upld_header.LAST_UPDATED_BY%TYPE;

609: l_document_id OKC_review_upld_header.DOCUMENT_ID%TYPE;
610: l_object_version_number OKC_review_upld_header.OBJECT_VERSION_NUMBER%TYPE;
611: l_created_by OKC_review_upld_header.CREATED_BY%TYPE;
612: l_creation_date OKC_review_upld_header.CREATION_DATE%TYPE;
613: l_last_updated_by OKC_review_upld_header.LAST_UPDATED_BY%TYPE;
614: l_last_update_login OKC_review_upld_header.LAST_UPDATE_LOGIN%TYPE;
615: l_last_update_date OKC_review_upld_header.LAST_UPDATE_DATE%TYPE;
616: l_new_contract_source OKC_review_upld_header.new_contract_source%TYPE;
617: l_enable_reporting_flag OKC_review_upld_header.enable_reporting_flag%TYPE;

Line 614: l_last_update_login OKC_review_upld_header.LAST_UPDATE_LOGIN%TYPE;

610: l_object_version_number OKC_review_upld_header.OBJECT_VERSION_NUMBER%TYPE;
611: l_created_by OKC_review_upld_header.CREATED_BY%TYPE;
612: l_creation_date OKC_review_upld_header.CREATION_DATE%TYPE;
613: l_last_updated_by OKC_review_upld_header.LAST_UPDATED_BY%TYPE;
614: l_last_update_login OKC_review_upld_header.LAST_UPDATE_LOGIN%TYPE;
615: l_last_update_date OKC_review_upld_header.LAST_UPDATE_DATE%TYPE;
616: l_new_contract_source OKC_review_upld_header.new_contract_source%TYPE;
617: l_enable_reporting_flag OKC_review_upld_header.enable_reporting_flag%TYPE;
618: l_file_description OKC_review_upld_header.file_description%TYPE;

Line 615: l_last_update_date OKC_review_upld_header.LAST_UPDATE_DATE%TYPE;

611: l_created_by OKC_review_upld_header.CREATED_BY%TYPE;
612: l_creation_date OKC_review_upld_header.CREATION_DATE%TYPE;
613: l_last_updated_by OKC_review_upld_header.LAST_UPDATED_BY%TYPE;
614: l_last_update_login OKC_review_upld_header.LAST_UPDATE_LOGIN%TYPE;
615: l_last_update_date OKC_review_upld_header.LAST_UPDATE_DATE%TYPE;
616: l_new_contract_source OKC_review_upld_header.new_contract_source%TYPE;
617: l_enable_reporting_flag OKC_review_upld_header.enable_reporting_flag%TYPE;
618: l_file_description OKC_review_upld_header.file_description%TYPE;
619:

Line 616: l_new_contract_source OKC_review_upld_header.new_contract_source%TYPE;

612: l_creation_date OKC_review_upld_header.CREATION_DATE%TYPE;
613: l_last_updated_by OKC_review_upld_header.LAST_UPDATED_BY%TYPE;
614: l_last_update_login OKC_review_upld_header.LAST_UPDATE_LOGIN%TYPE;
615: l_last_update_date OKC_review_upld_header.LAST_UPDATE_DATE%TYPE;
616: l_new_contract_source OKC_review_upld_header.new_contract_source%TYPE;
617: l_enable_reporting_flag OKC_review_upld_header.enable_reporting_flag%TYPE;
618: l_file_description OKC_review_upld_header.file_description%TYPE;
619:
620: BEGIN

Line 617: l_enable_reporting_flag OKC_review_upld_header.enable_reporting_flag%TYPE;

613: l_last_updated_by OKC_review_upld_header.LAST_UPDATED_BY%TYPE;
614: l_last_update_login OKC_review_upld_header.LAST_UPDATE_LOGIN%TYPE;
615: l_last_update_date OKC_review_upld_header.LAST_UPDATE_DATE%TYPE;
616: l_new_contract_source OKC_review_upld_header.new_contract_source%TYPE;
617: l_enable_reporting_flag OKC_review_upld_header.enable_reporting_flag%TYPE;
618: l_file_description OKC_review_upld_header.file_description%TYPE;
619:
620: BEGIN
621:

Line 618: l_file_description OKC_review_upld_header.file_description%TYPE;

614: l_last_update_login OKC_review_upld_header.LAST_UPDATE_LOGIN%TYPE;
615: l_last_update_date OKC_review_upld_header.LAST_UPDATE_DATE%TYPE;
616: l_new_contract_source OKC_review_upld_header.new_contract_source%TYPE;
617: l_enable_reporting_flag OKC_review_upld_header.enable_reporting_flag%TYPE;
618: l_file_description OKC_review_upld_header.file_description%TYPE;
619:
620: BEGIN
621:
622: IF (l_debug = 'Y') THEN

Line 706: -- Insert_Row for:OKC_review_upld_header --

702: ---------------------------------------------------------------------------
703: -- PROCEDURE Insert_Row
704: ---------------------------------------------------------------------------
705: -------------------------------------
706: -- Insert_Row for:OKC_review_upld_header --
707: -------------------------------------
708: FUNCTION Insert_Row(
709: p_review_upld_header_id IN NUMBER,
710: p_file_name IN VARCHAR2,

Line 733: INSERT INTO OKC_review_upld_header(

729: IF (l_debug = 'Y') THEN
730: Okc_Debug.Log('3600: Entered Insert_Row function', 2);
731: END IF;
732:
733: INSERT INTO OKC_review_upld_header(
734: review_upld_header_ID,
735: FILE_NAME,
736: FILE_CONTENT_TYPE,
737: FILE_DATA,

Line 792: -- Insert_Row for:OKC_review_upld_header --

788: END Insert_Row;
789:
790:
791: -------------------------------------
792: -- Insert_Row for:OKC_review_upld_header --
793: -------------------------------------
794: PROCEDURE Insert_Row(
795: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
796: x_return_status OUT NOCOPY VARCHAR2,

Line 812: l_object_version_number OKC_review_upld_header.OBJECT_VERSION_NUMBER%TYPE;

808: x_review_upld_header_id OUT NOCOPY NUMBER
809:
810: ) IS
811:
812: l_object_version_number OKC_review_upld_header.OBJECT_VERSION_NUMBER%TYPE;
813: l_created_by OKC_review_upld_header.CREATED_BY%TYPE;
814: l_creation_date OKC_review_upld_header.CREATION_DATE%TYPE;
815: l_last_updated_by OKC_review_upld_header.LAST_UPDATED_BY%TYPE;
816: l_last_update_login OKC_review_upld_header.LAST_UPDATE_LOGIN%TYPE;

Line 813: l_created_by OKC_review_upld_header.CREATED_BY%TYPE;

809:
810: ) IS
811:
812: l_object_version_number OKC_review_upld_header.OBJECT_VERSION_NUMBER%TYPE;
813: l_created_by OKC_review_upld_header.CREATED_BY%TYPE;
814: l_creation_date OKC_review_upld_header.CREATION_DATE%TYPE;
815: l_last_updated_by OKC_review_upld_header.LAST_UPDATED_BY%TYPE;
816: l_last_update_login OKC_review_upld_header.LAST_UPDATE_LOGIN%TYPE;
817: l_last_update_date OKC_review_upld_header.LAST_UPDATE_DATE%TYPE;

Line 814: l_creation_date OKC_review_upld_header.CREATION_DATE%TYPE;

810: ) IS
811:
812: l_object_version_number OKC_review_upld_header.OBJECT_VERSION_NUMBER%TYPE;
813: l_created_by OKC_review_upld_header.CREATED_BY%TYPE;
814: l_creation_date OKC_review_upld_header.CREATION_DATE%TYPE;
815: l_last_updated_by OKC_review_upld_header.LAST_UPDATED_BY%TYPE;
816: l_last_update_login OKC_review_upld_header.LAST_UPDATE_LOGIN%TYPE;
817: l_last_update_date OKC_review_upld_header.LAST_UPDATE_DATE%TYPE;
818: BEGIN

Line 815: l_last_updated_by OKC_review_upld_header.LAST_UPDATED_BY%TYPE;

811:
812: l_object_version_number OKC_review_upld_header.OBJECT_VERSION_NUMBER%TYPE;
813: l_created_by OKC_review_upld_header.CREATED_BY%TYPE;
814: l_creation_date OKC_review_upld_header.CREATION_DATE%TYPE;
815: l_last_updated_by OKC_review_upld_header.LAST_UPDATED_BY%TYPE;
816: l_last_update_login OKC_review_upld_header.LAST_UPDATE_LOGIN%TYPE;
817: l_last_update_date OKC_review_upld_header.LAST_UPDATE_DATE%TYPE;
818: BEGIN
819:

Line 816: l_last_update_login OKC_review_upld_header.LAST_UPDATE_LOGIN%TYPE;

812: l_object_version_number OKC_review_upld_header.OBJECT_VERSION_NUMBER%TYPE;
813: l_created_by OKC_review_upld_header.CREATED_BY%TYPE;
814: l_creation_date OKC_review_upld_header.CREATION_DATE%TYPE;
815: l_last_updated_by OKC_review_upld_header.LAST_UPDATED_BY%TYPE;
816: l_last_update_login OKC_review_upld_header.LAST_UPDATE_LOGIN%TYPE;
817: l_last_update_date OKC_review_upld_header.LAST_UPDATE_DATE%TYPE;
818: BEGIN
819:
820: x_return_status := G_RET_STS_SUCCESS;

Line 817: l_last_update_date OKC_review_upld_header.LAST_UPDATE_DATE%TYPE;

813: l_created_by OKC_review_upld_header.CREATED_BY%TYPE;
814: l_creation_date OKC_review_upld_header.CREATION_DATE%TYPE;
815: l_last_updated_by OKC_review_upld_header.LAST_UPDATED_BY%TYPE;
816: l_last_update_login OKC_review_upld_header.LAST_UPDATE_LOGIN%TYPE;
817: l_last_update_date OKC_review_upld_header.LAST_UPDATE_DATE%TYPE;
818: BEGIN
819:
820: x_return_status := G_RET_STS_SUCCESS;
821:

Line 937: -- Lock_Row for:OKC_review_upld_header --

933: ---------------------------------------------------------------------------
934: -- PROCEDURE Lock_Row
935: ---------------------------------------------------------------------------
936: -----------------------------------
937: -- Lock_Row for:OKC_review_upld_header --
938: -----------------------------------
939: FUNCTION Lock_Row(
940: p_review_upld_header_id IN NUMBER,
941: p_object_version_number IN NUMBER

Line 945: l_object_version_number OKC_review_upld_header.OBJECT_VERSION_NUMBER%TYPE;

941: p_object_version_number IN NUMBER
942: ) RETURN VARCHAR2 IS
943:
944: l_return_status VARCHAR2(1);
945: l_object_version_number OKC_review_upld_header.OBJECT_VERSION_NUMBER%TYPE;
946: l_row_notfound BOOLEAN := FALSE;
947:
948: CURSOR lock_csr (cp_review_upld_header_id NUMBER, cp_object_version_number NUMBER) IS
949: SELECT object_version_number

Line 950: FROM OKC_review_upld_header

946: l_row_notfound BOOLEAN := FALSE;
947:
948: CURSOR lock_csr (cp_review_upld_header_id NUMBER, cp_object_version_number NUMBER) IS
949: SELECT object_version_number
950: FROM OKC_review_upld_header
951: WHERE review_upld_header_ID = cp_review_upld_header_id
952: AND (object_version_number = cp_object_version_number OR cp_object_version_number IS NULL)
953: FOR UPDATE OF object_version_number NOWAIT;
954:

Line 957: FROM OKC_review_upld_header

953: FOR UPDATE OF object_version_number NOWAIT;
954:
955: CURSOR lchk_csr (cp_review_upld_header_id NUMBER) IS
956: SELECT object_version_number
957: FROM OKC_review_upld_header
958: WHERE review_upld_header_ID = cp_review_upld_header_id;
959: BEGIN
960:
961: IF (l_debug = 'Y') THEN

Line 1039: -- Lock_Row for:OKC_review_upld_header --

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

Line 1103: -- Update_Row for:OKC_review_upld_header --

1099: ---------------------------------------------------------------------------
1100: -- PROCEDURE Update_Row
1101: ---------------------------------------------------------------------------
1102: -------------------------------------
1103: -- Update_Row for:OKC_review_upld_header --
1104: -------------------------------------
1105: FUNCTION Update_Row(
1106: p_review_upld_header_id IN NUMBER,
1107: p_file_name IN VARCHAR2,

Line 1128: UPDATE OKC_review_upld_header

1124: IF (l_debug = 'Y') THEN
1125: Okc_Debug.Log('6400: Entered Update_Row', 2);
1126: END IF;
1127:
1128: UPDATE OKC_review_upld_header
1129: SET FILE_NAME = p_file_name,
1130: FILE_CONTENT_TYPE = p_file_content_type,
1131: FILE_DATA = p_file_data,
1132: DOCUMENT_TYPE = p_document_type,

Line 1168: -- Update_Row for:OKC_review_upld_header --

1164:
1165: END Update_Row;
1166:
1167: -------------------------------------
1168: -- Update_Row for:OKC_review_upld_header --
1169: -------------------------------------
1170: PROCEDURE Update_Row(
1171: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1172:

Line 1190: l_file_name OKC_review_upld_header.FILE_NAME%TYPE;

1186: p_file_description IN VARCHAR2 := NULL
1187:
1188: ) IS
1189:
1190: l_file_name OKC_review_upld_header.FILE_NAME%TYPE;
1191: l_file_content_type OKC_review_upld_header.FILE_CONTENT_TYPE%TYPE;
1192: l_file_data OKC_review_upld_header.FILE_DATA%TYPE;
1193: l_document_type OKC_review_upld_header.DOCUMENT_TYPE%TYPE;
1194: l_document_id OKC_review_upld_header.DOCUMENT_ID%TYPE;

Line 1191: l_file_content_type OKC_review_upld_header.FILE_CONTENT_TYPE%TYPE;

1187:
1188: ) IS
1189:
1190: l_file_name OKC_review_upld_header.FILE_NAME%TYPE;
1191: l_file_content_type OKC_review_upld_header.FILE_CONTENT_TYPE%TYPE;
1192: l_file_data OKC_review_upld_header.FILE_DATA%TYPE;
1193: l_document_type OKC_review_upld_header.DOCUMENT_TYPE%TYPE;
1194: l_document_id OKC_review_upld_header.DOCUMENT_ID%TYPE;
1195: l_object_version_number OKC_review_upld_header.OBJECT_VERSION_NUMBER%TYPE;

Line 1192: l_file_data OKC_review_upld_header.FILE_DATA%TYPE;

1188: ) IS
1189:
1190: l_file_name OKC_review_upld_header.FILE_NAME%TYPE;
1191: l_file_content_type OKC_review_upld_header.FILE_CONTENT_TYPE%TYPE;
1192: l_file_data OKC_review_upld_header.FILE_DATA%TYPE;
1193: l_document_type OKC_review_upld_header.DOCUMENT_TYPE%TYPE;
1194: l_document_id OKC_review_upld_header.DOCUMENT_ID%TYPE;
1195: l_object_version_number OKC_review_upld_header.OBJECT_VERSION_NUMBER%TYPE;
1196: l_last_updated_by OKC_review_upld_header.LAST_UPDATED_BY%TYPE;

Line 1193: l_document_type OKC_review_upld_header.DOCUMENT_TYPE%TYPE;

1189:
1190: l_file_name OKC_review_upld_header.FILE_NAME%TYPE;
1191: l_file_content_type OKC_review_upld_header.FILE_CONTENT_TYPE%TYPE;
1192: l_file_data OKC_review_upld_header.FILE_DATA%TYPE;
1193: l_document_type OKC_review_upld_header.DOCUMENT_TYPE%TYPE;
1194: l_document_id OKC_review_upld_header.DOCUMENT_ID%TYPE;
1195: l_object_version_number OKC_review_upld_header.OBJECT_VERSION_NUMBER%TYPE;
1196: l_last_updated_by OKC_review_upld_header.LAST_UPDATED_BY%TYPE;
1197: l_last_update_login OKC_review_upld_header.LAST_UPDATE_LOGIN%TYPE;

Line 1194: l_document_id OKC_review_upld_header.DOCUMENT_ID%TYPE;

1190: l_file_name OKC_review_upld_header.FILE_NAME%TYPE;
1191: l_file_content_type OKC_review_upld_header.FILE_CONTENT_TYPE%TYPE;
1192: l_file_data OKC_review_upld_header.FILE_DATA%TYPE;
1193: l_document_type OKC_review_upld_header.DOCUMENT_TYPE%TYPE;
1194: l_document_id OKC_review_upld_header.DOCUMENT_ID%TYPE;
1195: l_object_version_number OKC_review_upld_header.OBJECT_VERSION_NUMBER%TYPE;
1196: l_last_updated_by OKC_review_upld_header.LAST_UPDATED_BY%TYPE;
1197: l_last_update_login OKC_review_upld_header.LAST_UPDATE_LOGIN%TYPE;
1198: l_last_update_date OKC_review_upld_header.LAST_UPDATE_DATE%TYPE;

Line 1195: l_object_version_number OKC_review_upld_header.OBJECT_VERSION_NUMBER%TYPE;

1191: l_file_content_type OKC_review_upld_header.FILE_CONTENT_TYPE%TYPE;
1192: l_file_data OKC_review_upld_header.FILE_DATA%TYPE;
1193: l_document_type OKC_review_upld_header.DOCUMENT_TYPE%TYPE;
1194: l_document_id OKC_review_upld_header.DOCUMENT_ID%TYPE;
1195: l_object_version_number OKC_review_upld_header.OBJECT_VERSION_NUMBER%TYPE;
1196: l_last_updated_by OKC_review_upld_header.LAST_UPDATED_BY%TYPE;
1197: l_last_update_login OKC_review_upld_header.LAST_UPDATE_LOGIN%TYPE;
1198: l_last_update_date OKC_review_upld_header.LAST_UPDATE_DATE%TYPE;
1199: l_new_contract_source OKC_review_upld_header.new_contract_source%TYPE;

Line 1196: l_last_updated_by OKC_review_upld_header.LAST_UPDATED_BY%TYPE;

1192: l_file_data OKC_review_upld_header.FILE_DATA%TYPE;
1193: l_document_type OKC_review_upld_header.DOCUMENT_TYPE%TYPE;
1194: l_document_id OKC_review_upld_header.DOCUMENT_ID%TYPE;
1195: l_object_version_number OKC_review_upld_header.OBJECT_VERSION_NUMBER%TYPE;
1196: l_last_updated_by OKC_review_upld_header.LAST_UPDATED_BY%TYPE;
1197: l_last_update_login OKC_review_upld_header.LAST_UPDATE_LOGIN%TYPE;
1198: l_last_update_date OKC_review_upld_header.LAST_UPDATE_DATE%TYPE;
1199: l_new_contract_source OKC_review_upld_header.new_contract_source%TYPE;
1200: l_enable_reporting_flag OKC_review_upld_header.enable_reporting_flag%TYPE;

Line 1197: l_last_update_login OKC_review_upld_header.LAST_UPDATE_LOGIN%TYPE;

1193: l_document_type OKC_review_upld_header.DOCUMENT_TYPE%TYPE;
1194: l_document_id OKC_review_upld_header.DOCUMENT_ID%TYPE;
1195: l_object_version_number OKC_review_upld_header.OBJECT_VERSION_NUMBER%TYPE;
1196: l_last_updated_by OKC_review_upld_header.LAST_UPDATED_BY%TYPE;
1197: l_last_update_login OKC_review_upld_header.LAST_UPDATE_LOGIN%TYPE;
1198: l_last_update_date OKC_review_upld_header.LAST_UPDATE_DATE%TYPE;
1199: l_new_contract_source OKC_review_upld_header.new_contract_source%TYPE;
1200: l_enable_reporting_flag OKC_review_upld_header.enable_reporting_flag%TYPE;
1201: l_file_description OKC_review_upld_header.file_description%TYPE;

Line 1198: l_last_update_date OKC_review_upld_header.LAST_UPDATE_DATE%TYPE;

1194: l_document_id OKC_review_upld_header.DOCUMENT_ID%TYPE;
1195: l_object_version_number OKC_review_upld_header.OBJECT_VERSION_NUMBER%TYPE;
1196: l_last_updated_by OKC_review_upld_header.LAST_UPDATED_BY%TYPE;
1197: l_last_update_login OKC_review_upld_header.LAST_UPDATE_LOGIN%TYPE;
1198: l_last_update_date OKC_review_upld_header.LAST_UPDATE_DATE%TYPE;
1199: l_new_contract_source OKC_review_upld_header.new_contract_source%TYPE;
1200: l_enable_reporting_flag OKC_review_upld_header.enable_reporting_flag%TYPE;
1201: l_file_description OKC_review_upld_header.file_description%TYPE;
1202: BEGIN

Line 1199: l_new_contract_source OKC_review_upld_header.new_contract_source%TYPE;

1195: l_object_version_number OKC_review_upld_header.OBJECT_VERSION_NUMBER%TYPE;
1196: l_last_updated_by OKC_review_upld_header.LAST_UPDATED_BY%TYPE;
1197: l_last_update_login OKC_review_upld_header.LAST_UPDATE_LOGIN%TYPE;
1198: l_last_update_date OKC_review_upld_header.LAST_UPDATE_DATE%TYPE;
1199: l_new_contract_source OKC_review_upld_header.new_contract_source%TYPE;
1200: l_enable_reporting_flag OKC_review_upld_header.enable_reporting_flag%TYPE;
1201: l_file_description OKC_review_upld_header.file_description%TYPE;
1202: BEGIN
1203:

Line 1200: l_enable_reporting_flag OKC_review_upld_header.enable_reporting_flag%TYPE;

1196: l_last_updated_by OKC_review_upld_header.LAST_UPDATED_BY%TYPE;
1197: l_last_update_login OKC_review_upld_header.LAST_UPDATE_LOGIN%TYPE;
1198: l_last_update_date OKC_review_upld_header.LAST_UPDATE_DATE%TYPE;
1199: l_new_contract_source OKC_review_upld_header.new_contract_source%TYPE;
1200: l_enable_reporting_flag OKC_review_upld_header.enable_reporting_flag%TYPE;
1201: l_file_description OKC_review_upld_header.file_description%TYPE;
1202: BEGIN
1203:
1204: IF (l_debug = 'Y') THEN

Line 1201: l_file_description OKC_review_upld_header.file_description%TYPE;

1197: l_last_update_login OKC_review_upld_header.LAST_UPDATE_LOGIN%TYPE;
1198: l_last_update_date OKC_review_upld_header.LAST_UPDATE_DATE%TYPE;
1199: l_new_contract_source OKC_review_upld_header.new_contract_source%TYPE;
1200: l_enable_reporting_flag OKC_review_upld_header.enable_reporting_flag%TYPE;
1201: l_file_description OKC_review_upld_header.file_description%TYPE;
1202: BEGIN
1203:
1204: IF (l_debug = 'Y') THEN
1205: Okc_Debug.Log('7000: Entered Update_Row', 2);

Line 1354: -- Delete_Row for:OKC_review_upld_header --

1350: ---------------------------------------------------------------------------
1351: -- PROCEDURE Delete_Row
1352: ---------------------------------------------------------------------------
1353: -------------------------------------
1354: -- Delete_Row for:OKC_review_upld_header --
1355: -------------------------------------
1356: FUNCTION Delete_Row(
1357: p_review_upld_header_id IN NUMBER
1358: ) RETURN VARCHAR2 IS

Line 1366: DELETE FROM OKC_review_upld_header

1362: IF (l_debug = 'Y') THEN
1363: Okc_Debug.Log('8200: Entered Delete_Row', 2);
1364: END IF;
1365:
1366: DELETE FROM OKC_review_upld_header
1367: WHERE review_upld_header_ID = p_review_upld_header_ID;
1368:
1369: IF (l_debug = 'Y') THEN
1370: Okc_Debug.Log('8300: Leaving Delete_Row', 2);

Line 1394: -- Delete_Row for:OKC_review_upld_header --

1390:
1391: END Delete_Row;
1392:
1393: -------------------------------------
1394: -- Delete_Row for:OKC_review_upld_header --
1395: -------------------------------------
1396: PROCEDURE Delete_Row(
1397: x_return_status OUT NOCOPY VARCHAR2,
1398: p_review_upld_header_id IN NUMBER,

Line 1465: END OKC_REVIEW_UPLD_HEADER_PVT;

1461:
1462:
1463:
1464:
1465: END OKC_REVIEW_UPLD_HEADER_PVT;
1466: