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_CONTRACT_DOCS_PVT dependencies on OKC_CONTRACT_DOCS

Line 1: PACKAGE BODY OKC_CONTRACT_DOCS_PVT AS

1: PACKAGE BODY OKC_CONTRACT_DOCS_PVT AS
2: /* $Header: OKCVCONTRACTDOCB.pls 120.1 2006/02/21 16:16:30 vamuru noship $ */
3:
4:
5:

Line 33: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_CONTRACT_DOCS_PVT';

29: G_RECORD_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_RECORD_VALID_LEVEL;
30: ---------------------------------------------------------------------------
31: -- GLOBAL VARIABLES
32: ---------------------------------------------------------------------------
33: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_CONTRACT_DOCS_PVT';
34: G_MODULE CONSTANT VARCHAR2(200) := 'okc.plsql.'||G_PKG_NAME||'.';
35: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
36: G_ENTITY_NAME CONSTANT VARCHAR2(200) := 'Contract Document';
37:

Line 64: -- FUNCTION get_rec for: OKC_CONTRACT_DOCS

60: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
61:
62:
63: ---------------------------------------------------------------------------
64: -- FUNCTION get_rec for: OKC_CONTRACT_DOCS
65: ---------------------------------------------------------------------------
66: FUNCTION Get_Rec (
67: p_business_document_type IN VARCHAR2,
68: p_business_document_id IN NUMBER,

Line 96: CURSOR OKC_CONTRACT_DOCS_pk_csr (cp_business_document_type IN VARCHAR2,cp_business_document_id IN NUMBER,cp_business_document_version IN NUMBER,cp_attached_document_id IN NUMBER) IS

92: x_mergeable_doc_flag OUT NOCOPY VARCHAR2
93:
94: ) RETURN VARCHAR2 IS
95: l_api_name CONSTANT VARCHAR2(30) := 'get_rec';
96: CURSOR OKC_CONTRACT_DOCS_pk_csr (cp_business_document_type IN VARCHAR2,cp_business_document_id IN NUMBER,cp_business_document_version IN NUMBER,cp_attached_document_id IN NUMBER) IS
97: SELECT
98: EXTERNAL_VISIBILITY_FLAG,
99: EFFECTIVE_FROM_TYPE,
100: EFFECTIVE_FROM_ID,

Line 118: FROM OKC_CONTRACT_DOCS t

114: LAST_UPDATE_LOGIN,
115: LAST_UPDATE_DATE,
116: PRIMARY_CONTRACT_DOC_FLAG,
117: MERGEABLE_DOC_FLAG
118: FROM OKC_CONTRACT_DOCS t
119: WHERE t.BUSINESS_DOCUMENT_TYPE = cp_business_document_type and
120: t.BUSINESS_DOCUMENT_ID = cp_business_document_id and
121: t.BUSINESS_DOCUMENT_VERSION = cp_business_document_version and
122: t.ATTACHED_DOCUMENT_ID = cp_attached_document_id;

Line 130: OPEN OKC_CONTRACT_DOCS_pk_csr (p_business_document_type, p_business_document_id, p_business_document_version, p_attached_document_id);

126: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'400: Entered get_rec');
127: END IF;
128:
129: -- Get current database values
130: OPEN OKC_CONTRACT_DOCS_pk_csr (p_business_document_type, p_business_document_id, p_business_document_version, p_attached_document_id);
131: FETCH OKC_CONTRACT_DOCS_pk_csr INTO
132: x_external_visibility_flag,
133: x_effective_from_type,
134: x_effective_from_id,

Line 131: FETCH OKC_CONTRACT_DOCS_pk_csr INTO

127: END IF;
128:
129: -- Get current database values
130: OPEN OKC_CONTRACT_DOCS_pk_csr (p_business_document_type, p_business_document_id, p_business_document_version, p_attached_document_id);
131: FETCH OKC_CONTRACT_DOCS_pk_csr INTO
132: x_external_visibility_flag,
133: x_effective_from_type,
134: x_effective_from_id,
135: x_effective_from_version,

Line 152: IF OKC_CONTRACT_DOCS_pk_csr%NOTFOUND THEN

148: x_last_update_login,
149: x_last_update_date,
150: x_primary_contract_doc_flag,
151: x_mergeable_doc_flag ;
152: IF OKC_CONTRACT_DOCS_pk_csr%NOTFOUND THEN
153: RAISE NO_DATA_FOUND;
154: END IF;
155: CLOSE OKC_CONTRACT_DOCS_pk_csr;
156:

Line 155: CLOSE OKC_CONTRACT_DOCS_pk_csr;

151: x_mergeable_doc_flag ;
152: IF OKC_CONTRACT_DOCS_pk_csr%NOTFOUND THEN
153: RAISE NO_DATA_FOUND;
154: END IF;
155: CLOSE OKC_CONTRACT_DOCS_pk_csr;
156:
157: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
158: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'500: Leaving get_rec ');
159: END IF;

Line 177: IF OKC_CONTRACT_DOCS_pk_csr%ISOPEN THEN

173: p_token1_value => sqlcode,
174: p_token2 => G_SQLERRM_TOKEN,
175: p_token2_value => sqlerrm);
176:
177: IF OKC_CONTRACT_DOCS_pk_csr%ISOPEN THEN
178: CLOSE OKC_CONTRACT_DOCS_pk_csr;
179: END IF;
180:
181: RETURN G_RET_STS_UNEXP_ERROR ;

Line 178: CLOSE OKC_CONTRACT_DOCS_pk_csr;

174: p_token2 => G_SQLERRM_TOKEN,
175: p_token2_value => sqlerrm);
176:
177: IF OKC_CONTRACT_DOCS_pk_csr%ISOPEN THEN
178: CLOSE OKC_CONTRACT_DOCS_pk_csr;
179: END IF;
180:
181: RETURN G_RET_STS_UNEXP_ERROR ;
182:

Line 186: -- Set_Attributes for:OKC_CONTRACT_DOCS --

182:
183: END Get_Rec;
184:
185: -----------------------------------------
186: -- Set_Attributes for:OKC_CONTRACT_DOCS --
187: -----------------------------------------
188: FUNCTION Set_Attributes(
189: p_business_document_type IN VARCHAR2,
190: p_business_document_id IN NUMBER,

Line 226: l_object_version_number OKC_CONTRACT_DOCS.OBJECT_VERSION_NUMBER%TYPE;

222: x_mergeable_doc_flag OUT NOCOPY VARCHAR2
223: ) RETURN VARCHAR2 IS
224: l_api_name CONSTANT VARCHAR2(30) := 'set_attributes';
225: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
226: l_object_version_number OKC_CONTRACT_DOCS.OBJECT_VERSION_NUMBER%TYPE;
227: l_created_by OKC_CONTRACT_DOCS.CREATED_BY%TYPE;
228: l_creation_date OKC_CONTRACT_DOCS.CREATION_DATE%TYPE;
229: l_last_updated_by OKC_CONTRACT_DOCS.LAST_UPDATED_BY%TYPE;
230: l_last_update_login OKC_CONTRACT_DOCS.LAST_UPDATE_LOGIN%TYPE;

Line 227: l_created_by OKC_CONTRACT_DOCS.CREATED_BY%TYPE;

223: ) RETURN VARCHAR2 IS
224: l_api_name CONSTANT VARCHAR2(30) := 'set_attributes';
225: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
226: l_object_version_number OKC_CONTRACT_DOCS.OBJECT_VERSION_NUMBER%TYPE;
227: l_created_by OKC_CONTRACT_DOCS.CREATED_BY%TYPE;
228: l_creation_date OKC_CONTRACT_DOCS.CREATION_DATE%TYPE;
229: l_last_updated_by OKC_CONTRACT_DOCS.LAST_UPDATED_BY%TYPE;
230: l_last_update_login OKC_CONTRACT_DOCS.LAST_UPDATE_LOGIN%TYPE;
231: l_last_update_date OKC_CONTRACT_DOCS.LAST_UPDATE_DATE%TYPE;

Line 228: l_creation_date OKC_CONTRACT_DOCS.CREATION_DATE%TYPE;

224: l_api_name CONSTANT VARCHAR2(30) := 'set_attributes';
225: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
226: l_object_version_number OKC_CONTRACT_DOCS.OBJECT_VERSION_NUMBER%TYPE;
227: l_created_by OKC_CONTRACT_DOCS.CREATED_BY%TYPE;
228: l_creation_date OKC_CONTRACT_DOCS.CREATION_DATE%TYPE;
229: l_last_updated_by OKC_CONTRACT_DOCS.LAST_UPDATED_BY%TYPE;
230: l_last_update_login OKC_CONTRACT_DOCS.LAST_UPDATE_LOGIN%TYPE;
231: l_last_update_date OKC_CONTRACT_DOCS.LAST_UPDATE_DATE%TYPE;
232: BEGIN

Line 229: l_last_updated_by OKC_CONTRACT_DOCS.LAST_UPDATED_BY%TYPE;

225: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
226: l_object_version_number OKC_CONTRACT_DOCS.OBJECT_VERSION_NUMBER%TYPE;
227: l_created_by OKC_CONTRACT_DOCS.CREATED_BY%TYPE;
228: l_creation_date OKC_CONTRACT_DOCS.CREATION_DATE%TYPE;
229: l_last_updated_by OKC_CONTRACT_DOCS.LAST_UPDATED_BY%TYPE;
230: l_last_update_login OKC_CONTRACT_DOCS.LAST_UPDATE_LOGIN%TYPE;
231: l_last_update_date OKC_CONTRACT_DOCS.LAST_UPDATE_DATE%TYPE;
232: BEGIN
233: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 230: l_last_update_login OKC_CONTRACT_DOCS.LAST_UPDATE_LOGIN%TYPE;

226: l_object_version_number OKC_CONTRACT_DOCS.OBJECT_VERSION_NUMBER%TYPE;
227: l_created_by OKC_CONTRACT_DOCS.CREATED_BY%TYPE;
228: l_creation_date OKC_CONTRACT_DOCS.CREATION_DATE%TYPE;
229: l_last_updated_by OKC_CONTRACT_DOCS.LAST_UPDATED_BY%TYPE;
230: l_last_update_login OKC_CONTRACT_DOCS.LAST_UPDATE_LOGIN%TYPE;
231: l_last_update_date OKC_CONTRACT_DOCS.LAST_UPDATE_DATE%TYPE;
232: BEGIN
233: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
234: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'700: Entered Set_Attributes ');

Line 231: l_last_update_date OKC_CONTRACT_DOCS.LAST_UPDATE_DATE%TYPE;

227: l_created_by OKC_CONTRACT_DOCS.CREATED_BY%TYPE;
228: l_creation_date OKC_CONTRACT_DOCS.CREATION_DATE%TYPE;
229: l_last_updated_by OKC_CONTRACT_DOCS.LAST_UPDATED_BY%TYPE;
230: l_last_update_login OKC_CONTRACT_DOCS.LAST_UPDATE_LOGIN%TYPE;
231: l_last_update_date OKC_CONTRACT_DOCS.LAST_UPDATE_DATE%TYPE;
232: BEGIN
233: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
234: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'700: Entered Set_Attributes ');
235: END IF;

Line 399: -- Validate_Attributes for: OKC_CONTRACT_DOCS --

395:
396: END Set_Attributes ;
397:
398: ----------------------------------------------
399: -- Validate_Attributes for: OKC_CONTRACT_DOCS --
400: ----------------------------------------------
401: FUNCTION Validate_Attributes (
402: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
403:

Line 610: -- Validate_Record for:OKC_CONTRACT_DOCS --

606: -- PROCEDURE Validate_Record
607: -- It calls Item Level Validations and then makes Record Level Validations
608: ---------------------------------------------------------------------------
609: ------------------------------------------
610: -- Validate_Record for:OKC_CONTRACT_DOCS --
611: ------------------------------------------
612: FUNCTION Validate_Record (
613: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
614:

Line 707: -- validate_row for:OKC_CONTRACT_DOCS --

703: ---------------------------------------------------------------------------
704: -- PROCEDURE validate_row
705: ---------------------------------------------------------------------------
706: ---------------------------------------
707: -- validate_row for:OKC_CONTRACT_DOCS --
708: ---------------------------------------
709: PROCEDURE validate_row(
710: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
711:

Line 737: l_external_visibility_flag OKC_CONTRACT_DOCS.EXTERNAL_VISIBILITY_FLAG%TYPE;

733:
734: p_object_version_number IN NUMBER
735: ) IS
736: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
737: l_external_visibility_flag OKC_CONTRACT_DOCS.EXTERNAL_VISIBILITY_FLAG%TYPE;
738: l_effective_from_type OKC_CONTRACT_DOCS.EFFECTIVE_FROM_TYPE%TYPE;
739: l_effective_from_id OKC_CONTRACT_DOCS.EFFECTIVE_FROM_ID%TYPE;
740: l_effective_from_version OKC_CONTRACT_DOCS.EFFECTIVE_FROM_VERSION%TYPE;
741: l_include_for_approval_flag OKC_CONTRACT_DOCS.INCLUDE_FOR_APPROVAL_FLAG%TYPE;

Line 738: l_effective_from_type OKC_CONTRACT_DOCS.EFFECTIVE_FROM_TYPE%TYPE;

734: p_object_version_number IN NUMBER
735: ) IS
736: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
737: l_external_visibility_flag OKC_CONTRACT_DOCS.EXTERNAL_VISIBILITY_FLAG%TYPE;
738: l_effective_from_type OKC_CONTRACT_DOCS.EFFECTIVE_FROM_TYPE%TYPE;
739: l_effective_from_id OKC_CONTRACT_DOCS.EFFECTIVE_FROM_ID%TYPE;
740: l_effective_from_version OKC_CONTRACT_DOCS.EFFECTIVE_FROM_VERSION%TYPE;
741: l_include_for_approval_flag OKC_CONTRACT_DOCS.INCLUDE_FOR_APPROVAL_FLAG%TYPE;
742: l_program_id OKC_CONTRACT_DOCS.PROGRAM_ID%TYPE;

Line 739: l_effective_from_id OKC_CONTRACT_DOCS.EFFECTIVE_FROM_ID%TYPE;

735: ) IS
736: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
737: l_external_visibility_flag OKC_CONTRACT_DOCS.EXTERNAL_VISIBILITY_FLAG%TYPE;
738: l_effective_from_type OKC_CONTRACT_DOCS.EFFECTIVE_FROM_TYPE%TYPE;
739: l_effective_from_id OKC_CONTRACT_DOCS.EFFECTIVE_FROM_ID%TYPE;
740: l_effective_from_version OKC_CONTRACT_DOCS.EFFECTIVE_FROM_VERSION%TYPE;
741: l_include_for_approval_flag OKC_CONTRACT_DOCS.INCLUDE_FOR_APPROVAL_FLAG%TYPE;
742: l_program_id OKC_CONTRACT_DOCS.PROGRAM_ID%TYPE;
743: l_program_application_id OKC_CONTRACT_DOCS.PROGRAM_APPLICATION_ID%TYPE;

Line 740: l_effective_from_version OKC_CONTRACT_DOCS.EFFECTIVE_FROM_VERSION%TYPE;

736: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
737: l_external_visibility_flag OKC_CONTRACT_DOCS.EXTERNAL_VISIBILITY_FLAG%TYPE;
738: l_effective_from_type OKC_CONTRACT_DOCS.EFFECTIVE_FROM_TYPE%TYPE;
739: l_effective_from_id OKC_CONTRACT_DOCS.EFFECTIVE_FROM_ID%TYPE;
740: l_effective_from_version OKC_CONTRACT_DOCS.EFFECTIVE_FROM_VERSION%TYPE;
741: l_include_for_approval_flag OKC_CONTRACT_DOCS.INCLUDE_FOR_APPROVAL_FLAG%TYPE;
742: l_program_id OKC_CONTRACT_DOCS.PROGRAM_ID%TYPE;
743: l_program_application_id OKC_CONTRACT_DOCS.PROGRAM_APPLICATION_ID%TYPE;
744: l_request_id OKC_CONTRACT_DOCS.REQUEST_ID%TYPE;

Line 741: l_include_for_approval_flag OKC_CONTRACT_DOCS.INCLUDE_FOR_APPROVAL_FLAG%TYPE;

737: l_external_visibility_flag OKC_CONTRACT_DOCS.EXTERNAL_VISIBILITY_FLAG%TYPE;
738: l_effective_from_type OKC_CONTRACT_DOCS.EFFECTIVE_FROM_TYPE%TYPE;
739: l_effective_from_id OKC_CONTRACT_DOCS.EFFECTIVE_FROM_ID%TYPE;
740: l_effective_from_version OKC_CONTRACT_DOCS.EFFECTIVE_FROM_VERSION%TYPE;
741: l_include_for_approval_flag OKC_CONTRACT_DOCS.INCLUDE_FOR_APPROVAL_FLAG%TYPE;
742: l_program_id OKC_CONTRACT_DOCS.PROGRAM_ID%TYPE;
743: l_program_application_id OKC_CONTRACT_DOCS.PROGRAM_APPLICATION_ID%TYPE;
744: l_request_id OKC_CONTRACT_DOCS.REQUEST_ID%TYPE;
745: l_program_update_date OKC_CONTRACT_DOCS.PROGRAM_UPDATE_DATE%TYPE;

Line 742: l_program_id OKC_CONTRACT_DOCS.PROGRAM_ID%TYPE;

738: l_effective_from_type OKC_CONTRACT_DOCS.EFFECTIVE_FROM_TYPE%TYPE;
739: l_effective_from_id OKC_CONTRACT_DOCS.EFFECTIVE_FROM_ID%TYPE;
740: l_effective_from_version OKC_CONTRACT_DOCS.EFFECTIVE_FROM_VERSION%TYPE;
741: l_include_for_approval_flag OKC_CONTRACT_DOCS.INCLUDE_FOR_APPROVAL_FLAG%TYPE;
742: l_program_id OKC_CONTRACT_DOCS.PROGRAM_ID%TYPE;
743: l_program_application_id OKC_CONTRACT_DOCS.PROGRAM_APPLICATION_ID%TYPE;
744: l_request_id OKC_CONTRACT_DOCS.REQUEST_ID%TYPE;
745: l_program_update_date OKC_CONTRACT_DOCS.PROGRAM_UPDATE_DATE%TYPE;
746: l_parent_attached_doc_id OKC_CONTRACT_DOCS.PARENT_ATTACHED_DOC_ID%TYPE;

Line 743: l_program_application_id OKC_CONTRACT_DOCS.PROGRAM_APPLICATION_ID%TYPE;

739: l_effective_from_id OKC_CONTRACT_DOCS.EFFECTIVE_FROM_ID%TYPE;
740: l_effective_from_version OKC_CONTRACT_DOCS.EFFECTIVE_FROM_VERSION%TYPE;
741: l_include_for_approval_flag OKC_CONTRACT_DOCS.INCLUDE_FOR_APPROVAL_FLAG%TYPE;
742: l_program_id OKC_CONTRACT_DOCS.PROGRAM_ID%TYPE;
743: l_program_application_id OKC_CONTRACT_DOCS.PROGRAM_APPLICATION_ID%TYPE;
744: l_request_id OKC_CONTRACT_DOCS.REQUEST_ID%TYPE;
745: l_program_update_date OKC_CONTRACT_DOCS.PROGRAM_UPDATE_DATE%TYPE;
746: l_parent_attached_doc_id OKC_CONTRACT_DOCS.PARENT_ATTACHED_DOC_ID%TYPE;
747: l_delete_flag OKC_CONTRACT_DOCS.DELETE_FLAG%TYPE;

Line 744: l_request_id OKC_CONTRACT_DOCS.REQUEST_ID%TYPE;

740: l_effective_from_version OKC_CONTRACT_DOCS.EFFECTIVE_FROM_VERSION%TYPE;
741: l_include_for_approval_flag OKC_CONTRACT_DOCS.INCLUDE_FOR_APPROVAL_FLAG%TYPE;
742: l_program_id OKC_CONTRACT_DOCS.PROGRAM_ID%TYPE;
743: l_program_application_id OKC_CONTRACT_DOCS.PROGRAM_APPLICATION_ID%TYPE;
744: l_request_id OKC_CONTRACT_DOCS.REQUEST_ID%TYPE;
745: l_program_update_date OKC_CONTRACT_DOCS.PROGRAM_UPDATE_DATE%TYPE;
746: l_parent_attached_doc_id OKC_CONTRACT_DOCS.PARENT_ATTACHED_DOC_ID%TYPE;
747: l_delete_flag OKC_CONTRACT_DOCS.DELETE_FLAG%TYPE;
748: l_generated_flag OKC_CONTRACT_DOCS.GENERATED_FLAG%TYPE;

Line 745: l_program_update_date OKC_CONTRACT_DOCS.PROGRAM_UPDATE_DATE%TYPE;

741: l_include_for_approval_flag OKC_CONTRACT_DOCS.INCLUDE_FOR_APPROVAL_FLAG%TYPE;
742: l_program_id OKC_CONTRACT_DOCS.PROGRAM_ID%TYPE;
743: l_program_application_id OKC_CONTRACT_DOCS.PROGRAM_APPLICATION_ID%TYPE;
744: l_request_id OKC_CONTRACT_DOCS.REQUEST_ID%TYPE;
745: l_program_update_date OKC_CONTRACT_DOCS.PROGRAM_UPDATE_DATE%TYPE;
746: l_parent_attached_doc_id OKC_CONTRACT_DOCS.PARENT_ATTACHED_DOC_ID%TYPE;
747: l_delete_flag OKC_CONTRACT_DOCS.DELETE_FLAG%TYPE;
748: l_generated_flag OKC_CONTRACT_DOCS.GENERATED_FLAG%TYPE;
749: l_object_version_number OKC_CONTRACT_DOCS.OBJECT_VERSION_NUMBER%TYPE;

Line 746: l_parent_attached_doc_id OKC_CONTRACT_DOCS.PARENT_ATTACHED_DOC_ID%TYPE;

742: l_program_id OKC_CONTRACT_DOCS.PROGRAM_ID%TYPE;
743: l_program_application_id OKC_CONTRACT_DOCS.PROGRAM_APPLICATION_ID%TYPE;
744: l_request_id OKC_CONTRACT_DOCS.REQUEST_ID%TYPE;
745: l_program_update_date OKC_CONTRACT_DOCS.PROGRAM_UPDATE_DATE%TYPE;
746: l_parent_attached_doc_id OKC_CONTRACT_DOCS.PARENT_ATTACHED_DOC_ID%TYPE;
747: l_delete_flag OKC_CONTRACT_DOCS.DELETE_FLAG%TYPE;
748: l_generated_flag OKC_CONTRACT_DOCS.GENERATED_FLAG%TYPE;
749: l_object_version_number OKC_CONTRACT_DOCS.OBJECT_VERSION_NUMBER%TYPE;
750: l_created_by OKC_CONTRACT_DOCS.CREATED_BY%TYPE;

Line 747: l_delete_flag OKC_CONTRACT_DOCS.DELETE_FLAG%TYPE;

743: l_program_application_id OKC_CONTRACT_DOCS.PROGRAM_APPLICATION_ID%TYPE;
744: l_request_id OKC_CONTRACT_DOCS.REQUEST_ID%TYPE;
745: l_program_update_date OKC_CONTRACT_DOCS.PROGRAM_UPDATE_DATE%TYPE;
746: l_parent_attached_doc_id OKC_CONTRACT_DOCS.PARENT_ATTACHED_DOC_ID%TYPE;
747: l_delete_flag OKC_CONTRACT_DOCS.DELETE_FLAG%TYPE;
748: l_generated_flag OKC_CONTRACT_DOCS.GENERATED_FLAG%TYPE;
749: l_object_version_number OKC_CONTRACT_DOCS.OBJECT_VERSION_NUMBER%TYPE;
750: l_created_by OKC_CONTRACT_DOCS.CREATED_BY%TYPE;
751: l_creation_date OKC_CONTRACT_DOCS.CREATION_DATE%TYPE;

Line 748: l_generated_flag OKC_CONTRACT_DOCS.GENERATED_FLAG%TYPE;

744: l_request_id OKC_CONTRACT_DOCS.REQUEST_ID%TYPE;
745: l_program_update_date OKC_CONTRACT_DOCS.PROGRAM_UPDATE_DATE%TYPE;
746: l_parent_attached_doc_id OKC_CONTRACT_DOCS.PARENT_ATTACHED_DOC_ID%TYPE;
747: l_delete_flag OKC_CONTRACT_DOCS.DELETE_FLAG%TYPE;
748: l_generated_flag OKC_CONTRACT_DOCS.GENERATED_FLAG%TYPE;
749: l_object_version_number OKC_CONTRACT_DOCS.OBJECT_VERSION_NUMBER%TYPE;
750: l_created_by OKC_CONTRACT_DOCS.CREATED_BY%TYPE;
751: l_creation_date OKC_CONTRACT_DOCS.CREATION_DATE%TYPE;
752: l_last_updated_by OKC_CONTRACT_DOCS.LAST_UPDATED_BY%TYPE;

Line 749: l_object_version_number OKC_CONTRACT_DOCS.OBJECT_VERSION_NUMBER%TYPE;

745: l_program_update_date OKC_CONTRACT_DOCS.PROGRAM_UPDATE_DATE%TYPE;
746: l_parent_attached_doc_id OKC_CONTRACT_DOCS.PARENT_ATTACHED_DOC_ID%TYPE;
747: l_delete_flag OKC_CONTRACT_DOCS.DELETE_FLAG%TYPE;
748: l_generated_flag OKC_CONTRACT_DOCS.GENERATED_FLAG%TYPE;
749: l_object_version_number OKC_CONTRACT_DOCS.OBJECT_VERSION_NUMBER%TYPE;
750: l_created_by OKC_CONTRACT_DOCS.CREATED_BY%TYPE;
751: l_creation_date OKC_CONTRACT_DOCS.CREATION_DATE%TYPE;
752: l_last_updated_by OKC_CONTRACT_DOCS.LAST_UPDATED_BY%TYPE;
753: l_last_update_login OKC_CONTRACT_DOCS.LAST_UPDATE_LOGIN%TYPE;

Line 750: l_created_by OKC_CONTRACT_DOCS.CREATED_BY%TYPE;

746: l_parent_attached_doc_id OKC_CONTRACT_DOCS.PARENT_ATTACHED_DOC_ID%TYPE;
747: l_delete_flag OKC_CONTRACT_DOCS.DELETE_FLAG%TYPE;
748: l_generated_flag OKC_CONTRACT_DOCS.GENERATED_FLAG%TYPE;
749: l_object_version_number OKC_CONTRACT_DOCS.OBJECT_VERSION_NUMBER%TYPE;
750: l_created_by OKC_CONTRACT_DOCS.CREATED_BY%TYPE;
751: l_creation_date OKC_CONTRACT_DOCS.CREATION_DATE%TYPE;
752: l_last_updated_by OKC_CONTRACT_DOCS.LAST_UPDATED_BY%TYPE;
753: l_last_update_login OKC_CONTRACT_DOCS.LAST_UPDATE_LOGIN%TYPE;
754: l_last_update_date OKC_CONTRACT_DOCS.LAST_UPDATE_DATE%TYPE;

Line 751: l_creation_date OKC_CONTRACT_DOCS.CREATION_DATE%TYPE;

747: l_delete_flag OKC_CONTRACT_DOCS.DELETE_FLAG%TYPE;
748: l_generated_flag OKC_CONTRACT_DOCS.GENERATED_FLAG%TYPE;
749: l_object_version_number OKC_CONTRACT_DOCS.OBJECT_VERSION_NUMBER%TYPE;
750: l_created_by OKC_CONTRACT_DOCS.CREATED_BY%TYPE;
751: l_creation_date OKC_CONTRACT_DOCS.CREATION_DATE%TYPE;
752: l_last_updated_by OKC_CONTRACT_DOCS.LAST_UPDATED_BY%TYPE;
753: l_last_update_login OKC_CONTRACT_DOCS.LAST_UPDATE_LOGIN%TYPE;
754: l_last_update_date OKC_CONTRACT_DOCS.LAST_UPDATE_DATE%TYPE;
755: l_primary_contract_doc_flag OKC_CONTRACT_DOCS.PRIMARY_CONTRACT_DOC_FLAG%TYPE;

Line 752: l_last_updated_by OKC_CONTRACT_DOCS.LAST_UPDATED_BY%TYPE;

748: l_generated_flag OKC_CONTRACT_DOCS.GENERATED_FLAG%TYPE;
749: l_object_version_number OKC_CONTRACT_DOCS.OBJECT_VERSION_NUMBER%TYPE;
750: l_created_by OKC_CONTRACT_DOCS.CREATED_BY%TYPE;
751: l_creation_date OKC_CONTRACT_DOCS.CREATION_DATE%TYPE;
752: l_last_updated_by OKC_CONTRACT_DOCS.LAST_UPDATED_BY%TYPE;
753: l_last_update_login OKC_CONTRACT_DOCS.LAST_UPDATE_LOGIN%TYPE;
754: l_last_update_date OKC_CONTRACT_DOCS.LAST_UPDATE_DATE%TYPE;
755: l_primary_contract_doc_flag OKC_CONTRACT_DOCS.PRIMARY_CONTRACT_DOC_FLAG%TYPE;
756: l_mergeable_doc_flag OKC_CONTRACT_DOCS.MERGEABLE_DOC_FLAG%TYPE;

Line 753: l_last_update_login OKC_CONTRACT_DOCS.LAST_UPDATE_LOGIN%TYPE;

749: l_object_version_number OKC_CONTRACT_DOCS.OBJECT_VERSION_NUMBER%TYPE;
750: l_created_by OKC_CONTRACT_DOCS.CREATED_BY%TYPE;
751: l_creation_date OKC_CONTRACT_DOCS.CREATION_DATE%TYPE;
752: l_last_updated_by OKC_CONTRACT_DOCS.LAST_UPDATED_BY%TYPE;
753: l_last_update_login OKC_CONTRACT_DOCS.LAST_UPDATE_LOGIN%TYPE;
754: l_last_update_date OKC_CONTRACT_DOCS.LAST_UPDATE_DATE%TYPE;
755: l_primary_contract_doc_flag OKC_CONTRACT_DOCS.PRIMARY_CONTRACT_DOC_FLAG%TYPE;
756: l_mergeable_doc_flag OKC_CONTRACT_DOCS.MERGEABLE_DOC_FLAG%TYPE;
757: BEGIN

Line 754: l_last_update_date OKC_CONTRACT_DOCS.LAST_UPDATE_DATE%TYPE;

750: l_created_by OKC_CONTRACT_DOCS.CREATED_BY%TYPE;
751: l_creation_date OKC_CONTRACT_DOCS.CREATION_DATE%TYPE;
752: l_last_updated_by OKC_CONTRACT_DOCS.LAST_UPDATED_BY%TYPE;
753: l_last_update_login OKC_CONTRACT_DOCS.LAST_UPDATE_LOGIN%TYPE;
754: l_last_update_date OKC_CONTRACT_DOCS.LAST_UPDATE_DATE%TYPE;
755: l_primary_contract_doc_flag OKC_CONTRACT_DOCS.PRIMARY_CONTRACT_DOC_FLAG%TYPE;
756: l_mergeable_doc_flag OKC_CONTRACT_DOCS.MERGEABLE_DOC_FLAG%TYPE;
757: BEGIN
758:

Line 755: l_primary_contract_doc_flag OKC_CONTRACT_DOCS.PRIMARY_CONTRACT_DOC_FLAG%TYPE;

751: l_creation_date OKC_CONTRACT_DOCS.CREATION_DATE%TYPE;
752: l_last_updated_by OKC_CONTRACT_DOCS.LAST_UPDATED_BY%TYPE;
753: l_last_update_login OKC_CONTRACT_DOCS.LAST_UPDATE_LOGIN%TYPE;
754: l_last_update_date OKC_CONTRACT_DOCS.LAST_UPDATE_DATE%TYPE;
755: l_primary_contract_doc_flag OKC_CONTRACT_DOCS.PRIMARY_CONTRACT_DOC_FLAG%TYPE;
756: l_mergeable_doc_flag OKC_CONTRACT_DOCS.MERGEABLE_DOC_FLAG%TYPE;
757: BEGIN
758:
759: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 756: l_mergeable_doc_flag OKC_CONTRACT_DOCS.MERGEABLE_DOC_FLAG%TYPE;

752: l_last_updated_by OKC_CONTRACT_DOCS.LAST_UPDATED_BY%TYPE;
753: l_last_update_login OKC_CONTRACT_DOCS.LAST_UPDATE_LOGIN%TYPE;
754: l_last_update_date OKC_CONTRACT_DOCS.LAST_UPDATE_DATE%TYPE;
755: l_primary_contract_doc_flag OKC_CONTRACT_DOCS.PRIMARY_CONTRACT_DOC_FLAG%TYPE;
756: l_mergeable_doc_flag OKC_CONTRACT_DOCS.MERGEABLE_DOC_FLAG%TYPE;
757: BEGIN
758:
759: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
760: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'3100: Entered validate_row');

Line 865: -- Insert_Row for:OKC_CONTRACT_DOCS --

861: ---------------------------------------------------------------------------
862: -- PROCEDURE Insert_Row
863: ---------------------------------------------------------------------------
864: -------------------------------------
865: -- Insert_Row for:OKC_CONTRACT_DOCS --
866: -------------------------------------
867: FUNCTION Insert_Row(
868: p_business_document_type IN VARCHAR2,
869: p_business_document_id IN NUMBER,

Line 901: INSERT INTO OKC_CONTRACT_DOCS(

897: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
898: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'3600: Entered Insert_Row function');
899: END IF;
900:
901: INSERT INTO OKC_CONTRACT_DOCS(
902: BUSINESS_DOCUMENT_TYPE,
903: BUSINESS_DOCUMENT_ID,
904: BUSINESS_DOCUMENT_VERSION,
905: ATTACHED_DOCUMENT_ID,

Line 978: -- Insert_Row for:OKC_CONTRACT_DOCS --

974: END Insert_Row;
975:
976:
977: -------------------------------------
978: -- Insert_Row for:OKC_CONTRACT_DOCS --
979: -------------------------------------
980: PROCEDURE Insert_Row(
981: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
982: x_return_status OUT NOCOPY VARCHAR2,

Line 1011: l_object_version_number OKC_CONTRACT_DOCS.OBJECT_VERSION_NUMBER%TYPE;

1007: x_attached_document_id OUT NOCOPY NUMBER
1008:
1009: ) IS
1010: l_api_name CONSTANT VARCHAR2(30) := 'insert_row';
1011: l_object_version_number OKC_CONTRACT_DOCS.OBJECT_VERSION_NUMBER%TYPE;
1012: l_created_by OKC_CONTRACT_DOCS.CREATED_BY%TYPE;
1013: l_creation_date OKC_CONTRACT_DOCS.CREATION_DATE%TYPE;
1014: l_last_updated_by OKC_CONTRACT_DOCS.LAST_UPDATED_BY%TYPE;
1015: l_last_update_login OKC_CONTRACT_DOCS.LAST_UPDATE_LOGIN%TYPE;

Line 1012: l_created_by OKC_CONTRACT_DOCS.CREATED_BY%TYPE;

1008:
1009: ) IS
1010: l_api_name CONSTANT VARCHAR2(30) := 'insert_row';
1011: l_object_version_number OKC_CONTRACT_DOCS.OBJECT_VERSION_NUMBER%TYPE;
1012: l_created_by OKC_CONTRACT_DOCS.CREATED_BY%TYPE;
1013: l_creation_date OKC_CONTRACT_DOCS.CREATION_DATE%TYPE;
1014: l_last_updated_by OKC_CONTRACT_DOCS.LAST_UPDATED_BY%TYPE;
1015: l_last_update_login OKC_CONTRACT_DOCS.LAST_UPDATE_LOGIN%TYPE;
1016: l_last_update_date OKC_CONTRACT_DOCS.LAST_UPDATE_DATE%TYPE;

Line 1013: l_creation_date OKC_CONTRACT_DOCS.CREATION_DATE%TYPE;

1009: ) IS
1010: l_api_name CONSTANT VARCHAR2(30) := 'insert_row';
1011: l_object_version_number OKC_CONTRACT_DOCS.OBJECT_VERSION_NUMBER%TYPE;
1012: l_created_by OKC_CONTRACT_DOCS.CREATED_BY%TYPE;
1013: l_creation_date OKC_CONTRACT_DOCS.CREATION_DATE%TYPE;
1014: l_last_updated_by OKC_CONTRACT_DOCS.LAST_UPDATED_BY%TYPE;
1015: l_last_update_login OKC_CONTRACT_DOCS.LAST_UPDATE_LOGIN%TYPE;
1016: l_last_update_date OKC_CONTRACT_DOCS.LAST_UPDATE_DATE%TYPE;
1017: BEGIN

Line 1014: l_last_updated_by OKC_CONTRACT_DOCS.LAST_UPDATED_BY%TYPE;

1010: l_api_name CONSTANT VARCHAR2(30) := 'insert_row';
1011: l_object_version_number OKC_CONTRACT_DOCS.OBJECT_VERSION_NUMBER%TYPE;
1012: l_created_by OKC_CONTRACT_DOCS.CREATED_BY%TYPE;
1013: l_creation_date OKC_CONTRACT_DOCS.CREATION_DATE%TYPE;
1014: l_last_updated_by OKC_CONTRACT_DOCS.LAST_UPDATED_BY%TYPE;
1015: l_last_update_login OKC_CONTRACT_DOCS.LAST_UPDATE_LOGIN%TYPE;
1016: l_last_update_date OKC_CONTRACT_DOCS.LAST_UPDATE_DATE%TYPE;
1017: BEGIN
1018:

Line 1015: l_last_update_login OKC_CONTRACT_DOCS.LAST_UPDATE_LOGIN%TYPE;

1011: l_object_version_number OKC_CONTRACT_DOCS.OBJECT_VERSION_NUMBER%TYPE;
1012: l_created_by OKC_CONTRACT_DOCS.CREATED_BY%TYPE;
1013: l_creation_date OKC_CONTRACT_DOCS.CREATION_DATE%TYPE;
1014: l_last_updated_by OKC_CONTRACT_DOCS.LAST_UPDATED_BY%TYPE;
1015: l_last_update_login OKC_CONTRACT_DOCS.LAST_UPDATE_LOGIN%TYPE;
1016: l_last_update_date OKC_CONTRACT_DOCS.LAST_UPDATE_DATE%TYPE;
1017: BEGIN
1018:
1019: x_return_status := G_RET_STS_SUCCESS;

Line 1016: l_last_update_date OKC_CONTRACT_DOCS.LAST_UPDATE_DATE%TYPE;

1012: l_created_by OKC_CONTRACT_DOCS.CREATED_BY%TYPE;
1013: l_creation_date OKC_CONTRACT_DOCS.CREATION_DATE%TYPE;
1014: l_last_updated_by OKC_CONTRACT_DOCS.LAST_UPDATED_BY%TYPE;
1015: l_last_update_login OKC_CONTRACT_DOCS.LAST_UPDATE_LOGIN%TYPE;
1016: l_last_update_date OKC_CONTRACT_DOCS.LAST_UPDATE_DATE%TYPE;
1017: BEGIN
1018:
1019: x_return_status := G_RET_STS_SUCCESS;
1020:

Line 1141: -- Lock_Row for:OKC_CONTRACT_DOCS --

1137: ---------------------------------------------------------------------------
1138: -- PROCEDURE Lock_Row
1139: ---------------------------------------------------------------------------
1140: -----------------------------------
1141: -- Lock_Row for:OKC_CONTRACT_DOCS --
1142: -----------------------------------
1143: FUNCTION Lock_Row(
1144: p_business_document_type IN VARCHAR2,
1145: p_business_document_id IN NUMBER,

Line 1152: l_object_version_number OKC_CONTRACT_DOCS.OBJECT_VERSION_NUMBER%TYPE;

1148: p_object_version_number IN NUMBER
1149: ) RETURN VARCHAR2 IS
1150: l_api_name CONSTANT VARCHAR2(30) := 'lock_row';
1151: l_return_status VARCHAR2(1);
1152: l_object_version_number OKC_CONTRACT_DOCS.OBJECT_VERSION_NUMBER%TYPE;
1153: l_row_notfound BOOLEAN := FALSE;
1154: l_pk_string VARCHAR2(240);
1155:
1156: CURSOR lock_csr (cp_business_document_type VARCHAR2, cp_business_document_id NUMBER, cp_business_document_version NUMBER, cp_attached_document_id NUMBER, cp_object_version_number NUMBER) IS

Line 1158: FROM OKC_CONTRACT_DOCS

1154: l_pk_string VARCHAR2(240);
1155:
1156: CURSOR lock_csr (cp_business_document_type VARCHAR2, cp_business_document_id NUMBER, cp_business_document_version NUMBER, cp_attached_document_id NUMBER, cp_object_version_number NUMBER) IS
1157: SELECT object_version_number
1158: FROM OKC_CONTRACT_DOCS
1159: WHERE BUSINESS_DOCUMENT_TYPE = cp_business_document_type AND BUSINESS_DOCUMENT_ID = cp_business_document_id AND BUSINESS_DOCUMENT_VERSION = cp_business_document_version AND ATTACHED_DOCUMENT_ID = cp_attached_document_id
1160: AND (object_version_number = cp_object_version_number OR cp_object_version_number IS NULL)
1161: FOR UPDATE OF object_version_number NOWAIT;
1162:

Line 1165: FROM OKC_CONTRACT_DOCS

1161: FOR UPDATE OF object_version_number NOWAIT;
1162:
1163: CURSOR lchk_csr (cp_business_document_type VARCHAR2, cp_business_document_id NUMBER, cp_business_document_version NUMBER, cp_attached_document_id NUMBER) IS
1164: SELECT object_version_number
1165: FROM OKC_CONTRACT_DOCS
1166: WHERE BUSINESS_DOCUMENT_TYPE = cp_business_document_type AND BUSINESS_DOCUMENT_ID = cp_business_document_id AND BUSINESS_DOCUMENT_VERSION = cp_business_document_version AND ATTACHED_DOCUMENT_ID = cp_attached_document_id;
1167: BEGIN
1168:
1169: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1257: -- Lock_Row for:OKC_CONTRACT_DOCS --

1253: RETURN( G_RET_STS_UNEXP_ERROR );
1254: END Lock_Row;
1255:
1256: -----------------------------------
1257: -- Lock_Row for:OKC_CONTRACT_DOCS --
1258: -----------------------------------
1259: PROCEDURE Lock_Row(
1260: x_return_status OUT NOCOPY VARCHAR2,
1261:

Line 1328: -- Update_Row for:OKC_CONTRACT_DOCS --

1324: ---------------------------------------------------------------------------
1325: -- PROCEDURE Update_Row
1326: ---------------------------------------------------------------------------
1327: -------------------------------------
1328: -- Update_Row for:OKC_CONTRACT_DOCS --
1329: -------------------------------------
1330: FUNCTION Update_Row(
1331: p_business_document_type IN VARCHAR2,
1332: p_business_document_id IN NUMBER,

Line 1362: UPDATE OKC_CONTRACT_DOCS

1358: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1359: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'6400: Entered Update_Row');
1360: END IF;
1361:
1362: UPDATE OKC_CONTRACT_DOCS
1363: SET EXTERNAL_VISIBILITY_FLAG = p_external_visibility_flag,
1364: EFFECTIVE_FROM_TYPE = p_effective_from_type,
1365: EFFECTIVE_FROM_ID = p_effective_from_id,
1366: EFFECTIVE_FROM_VERSION = p_effective_from_version,

Line 1408: -- Update_Row for:OKC_CONTRACT_DOCS --

1404:
1405: END Update_Row;
1406:
1407: -------------------------------------
1408: -- Update_Row for:OKC_CONTRACT_DOCS --
1409: -------------------------------------
1410: PROCEDURE Update_Row(
1411: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1412:

Line 1440: l_external_visibility_flag OKC_CONTRACT_DOCS.EXTERNAL_VISIBILITY_FLAG%TYPE;

1436: p_object_version_number IN NUMBER
1437:
1438: ) IS
1439: l_api_name CONSTANT VARCHAR2(30) := 'update_row';
1440: l_external_visibility_flag OKC_CONTRACT_DOCS.EXTERNAL_VISIBILITY_FLAG%TYPE;
1441: l_effective_from_type OKC_CONTRACT_DOCS.EFFECTIVE_FROM_TYPE%TYPE;
1442: l_effective_from_id OKC_CONTRACT_DOCS.EFFECTIVE_FROM_ID%TYPE;
1443: l_effective_from_version OKC_CONTRACT_DOCS.EFFECTIVE_FROM_VERSION%TYPE;
1444: l_include_for_approval_flag OKC_CONTRACT_DOCS.INCLUDE_FOR_APPROVAL_FLAG%TYPE;

Line 1441: l_effective_from_type OKC_CONTRACT_DOCS.EFFECTIVE_FROM_TYPE%TYPE;

1437:
1438: ) IS
1439: l_api_name CONSTANT VARCHAR2(30) := 'update_row';
1440: l_external_visibility_flag OKC_CONTRACT_DOCS.EXTERNAL_VISIBILITY_FLAG%TYPE;
1441: l_effective_from_type OKC_CONTRACT_DOCS.EFFECTIVE_FROM_TYPE%TYPE;
1442: l_effective_from_id OKC_CONTRACT_DOCS.EFFECTIVE_FROM_ID%TYPE;
1443: l_effective_from_version OKC_CONTRACT_DOCS.EFFECTIVE_FROM_VERSION%TYPE;
1444: l_include_for_approval_flag OKC_CONTRACT_DOCS.INCLUDE_FOR_APPROVAL_FLAG%TYPE;
1445: l_program_id OKC_CONTRACT_DOCS.PROGRAM_ID%TYPE;

Line 1442: l_effective_from_id OKC_CONTRACT_DOCS.EFFECTIVE_FROM_ID%TYPE;

1438: ) IS
1439: l_api_name CONSTANT VARCHAR2(30) := 'update_row';
1440: l_external_visibility_flag OKC_CONTRACT_DOCS.EXTERNAL_VISIBILITY_FLAG%TYPE;
1441: l_effective_from_type OKC_CONTRACT_DOCS.EFFECTIVE_FROM_TYPE%TYPE;
1442: l_effective_from_id OKC_CONTRACT_DOCS.EFFECTIVE_FROM_ID%TYPE;
1443: l_effective_from_version OKC_CONTRACT_DOCS.EFFECTIVE_FROM_VERSION%TYPE;
1444: l_include_for_approval_flag OKC_CONTRACT_DOCS.INCLUDE_FOR_APPROVAL_FLAG%TYPE;
1445: l_program_id OKC_CONTRACT_DOCS.PROGRAM_ID%TYPE;
1446: l_program_application_id OKC_CONTRACT_DOCS.PROGRAM_APPLICATION_ID%TYPE;

Line 1443: l_effective_from_version OKC_CONTRACT_DOCS.EFFECTIVE_FROM_VERSION%TYPE;

1439: l_api_name CONSTANT VARCHAR2(30) := 'update_row';
1440: l_external_visibility_flag OKC_CONTRACT_DOCS.EXTERNAL_VISIBILITY_FLAG%TYPE;
1441: l_effective_from_type OKC_CONTRACT_DOCS.EFFECTIVE_FROM_TYPE%TYPE;
1442: l_effective_from_id OKC_CONTRACT_DOCS.EFFECTIVE_FROM_ID%TYPE;
1443: l_effective_from_version OKC_CONTRACT_DOCS.EFFECTIVE_FROM_VERSION%TYPE;
1444: l_include_for_approval_flag OKC_CONTRACT_DOCS.INCLUDE_FOR_APPROVAL_FLAG%TYPE;
1445: l_program_id OKC_CONTRACT_DOCS.PROGRAM_ID%TYPE;
1446: l_program_application_id OKC_CONTRACT_DOCS.PROGRAM_APPLICATION_ID%TYPE;
1447: l_request_id OKC_CONTRACT_DOCS.REQUEST_ID%TYPE;

Line 1444: l_include_for_approval_flag OKC_CONTRACT_DOCS.INCLUDE_FOR_APPROVAL_FLAG%TYPE;

1440: l_external_visibility_flag OKC_CONTRACT_DOCS.EXTERNAL_VISIBILITY_FLAG%TYPE;
1441: l_effective_from_type OKC_CONTRACT_DOCS.EFFECTIVE_FROM_TYPE%TYPE;
1442: l_effective_from_id OKC_CONTRACT_DOCS.EFFECTIVE_FROM_ID%TYPE;
1443: l_effective_from_version OKC_CONTRACT_DOCS.EFFECTIVE_FROM_VERSION%TYPE;
1444: l_include_for_approval_flag OKC_CONTRACT_DOCS.INCLUDE_FOR_APPROVAL_FLAG%TYPE;
1445: l_program_id OKC_CONTRACT_DOCS.PROGRAM_ID%TYPE;
1446: l_program_application_id OKC_CONTRACT_DOCS.PROGRAM_APPLICATION_ID%TYPE;
1447: l_request_id OKC_CONTRACT_DOCS.REQUEST_ID%TYPE;
1448: l_program_update_date OKC_CONTRACT_DOCS.PROGRAM_UPDATE_DATE%TYPE;

Line 1445: l_program_id OKC_CONTRACT_DOCS.PROGRAM_ID%TYPE;

1441: l_effective_from_type OKC_CONTRACT_DOCS.EFFECTIVE_FROM_TYPE%TYPE;
1442: l_effective_from_id OKC_CONTRACT_DOCS.EFFECTIVE_FROM_ID%TYPE;
1443: l_effective_from_version OKC_CONTRACT_DOCS.EFFECTIVE_FROM_VERSION%TYPE;
1444: l_include_for_approval_flag OKC_CONTRACT_DOCS.INCLUDE_FOR_APPROVAL_FLAG%TYPE;
1445: l_program_id OKC_CONTRACT_DOCS.PROGRAM_ID%TYPE;
1446: l_program_application_id OKC_CONTRACT_DOCS.PROGRAM_APPLICATION_ID%TYPE;
1447: l_request_id OKC_CONTRACT_DOCS.REQUEST_ID%TYPE;
1448: l_program_update_date OKC_CONTRACT_DOCS.PROGRAM_UPDATE_DATE%TYPE;
1449: l_parent_attached_doc_id OKC_CONTRACT_DOCS.PARENT_ATTACHED_DOC_ID%TYPE;

Line 1446: l_program_application_id OKC_CONTRACT_DOCS.PROGRAM_APPLICATION_ID%TYPE;

1442: l_effective_from_id OKC_CONTRACT_DOCS.EFFECTIVE_FROM_ID%TYPE;
1443: l_effective_from_version OKC_CONTRACT_DOCS.EFFECTIVE_FROM_VERSION%TYPE;
1444: l_include_for_approval_flag OKC_CONTRACT_DOCS.INCLUDE_FOR_APPROVAL_FLAG%TYPE;
1445: l_program_id OKC_CONTRACT_DOCS.PROGRAM_ID%TYPE;
1446: l_program_application_id OKC_CONTRACT_DOCS.PROGRAM_APPLICATION_ID%TYPE;
1447: l_request_id OKC_CONTRACT_DOCS.REQUEST_ID%TYPE;
1448: l_program_update_date OKC_CONTRACT_DOCS.PROGRAM_UPDATE_DATE%TYPE;
1449: l_parent_attached_doc_id OKC_CONTRACT_DOCS.PARENT_ATTACHED_DOC_ID%TYPE;
1450: l_delete_flag OKC_CONTRACT_DOCS.DELETE_FLAG%TYPE;

Line 1447: l_request_id OKC_CONTRACT_DOCS.REQUEST_ID%TYPE;

1443: l_effective_from_version OKC_CONTRACT_DOCS.EFFECTIVE_FROM_VERSION%TYPE;
1444: l_include_for_approval_flag OKC_CONTRACT_DOCS.INCLUDE_FOR_APPROVAL_FLAG%TYPE;
1445: l_program_id OKC_CONTRACT_DOCS.PROGRAM_ID%TYPE;
1446: l_program_application_id OKC_CONTRACT_DOCS.PROGRAM_APPLICATION_ID%TYPE;
1447: l_request_id OKC_CONTRACT_DOCS.REQUEST_ID%TYPE;
1448: l_program_update_date OKC_CONTRACT_DOCS.PROGRAM_UPDATE_DATE%TYPE;
1449: l_parent_attached_doc_id OKC_CONTRACT_DOCS.PARENT_ATTACHED_DOC_ID%TYPE;
1450: l_delete_flag OKC_CONTRACT_DOCS.DELETE_FLAG%TYPE;
1451: l_generated_flag OKC_CONTRACT_DOCS.GENERATED_FLAG%TYPE;

Line 1448: l_program_update_date OKC_CONTRACT_DOCS.PROGRAM_UPDATE_DATE%TYPE;

1444: l_include_for_approval_flag OKC_CONTRACT_DOCS.INCLUDE_FOR_APPROVAL_FLAG%TYPE;
1445: l_program_id OKC_CONTRACT_DOCS.PROGRAM_ID%TYPE;
1446: l_program_application_id OKC_CONTRACT_DOCS.PROGRAM_APPLICATION_ID%TYPE;
1447: l_request_id OKC_CONTRACT_DOCS.REQUEST_ID%TYPE;
1448: l_program_update_date OKC_CONTRACT_DOCS.PROGRAM_UPDATE_DATE%TYPE;
1449: l_parent_attached_doc_id OKC_CONTRACT_DOCS.PARENT_ATTACHED_DOC_ID%TYPE;
1450: l_delete_flag OKC_CONTRACT_DOCS.DELETE_FLAG%TYPE;
1451: l_generated_flag OKC_CONTRACT_DOCS.GENERATED_FLAG%TYPE;
1452: l_object_version_number OKC_CONTRACT_DOCS.OBJECT_VERSION_NUMBER%TYPE;

Line 1449: l_parent_attached_doc_id OKC_CONTRACT_DOCS.PARENT_ATTACHED_DOC_ID%TYPE;

1445: l_program_id OKC_CONTRACT_DOCS.PROGRAM_ID%TYPE;
1446: l_program_application_id OKC_CONTRACT_DOCS.PROGRAM_APPLICATION_ID%TYPE;
1447: l_request_id OKC_CONTRACT_DOCS.REQUEST_ID%TYPE;
1448: l_program_update_date OKC_CONTRACT_DOCS.PROGRAM_UPDATE_DATE%TYPE;
1449: l_parent_attached_doc_id OKC_CONTRACT_DOCS.PARENT_ATTACHED_DOC_ID%TYPE;
1450: l_delete_flag OKC_CONTRACT_DOCS.DELETE_FLAG%TYPE;
1451: l_generated_flag OKC_CONTRACT_DOCS.GENERATED_FLAG%TYPE;
1452: l_object_version_number OKC_CONTRACT_DOCS.OBJECT_VERSION_NUMBER%TYPE;
1453: l_last_updated_by OKC_CONTRACT_DOCS.LAST_UPDATED_BY%TYPE;

Line 1450: l_delete_flag OKC_CONTRACT_DOCS.DELETE_FLAG%TYPE;

1446: l_program_application_id OKC_CONTRACT_DOCS.PROGRAM_APPLICATION_ID%TYPE;
1447: l_request_id OKC_CONTRACT_DOCS.REQUEST_ID%TYPE;
1448: l_program_update_date OKC_CONTRACT_DOCS.PROGRAM_UPDATE_DATE%TYPE;
1449: l_parent_attached_doc_id OKC_CONTRACT_DOCS.PARENT_ATTACHED_DOC_ID%TYPE;
1450: l_delete_flag OKC_CONTRACT_DOCS.DELETE_FLAG%TYPE;
1451: l_generated_flag OKC_CONTRACT_DOCS.GENERATED_FLAG%TYPE;
1452: l_object_version_number OKC_CONTRACT_DOCS.OBJECT_VERSION_NUMBER%TYPE;
1453: l_last_updated_by OKC_CONTRACT_DOCS.LAST_UPDATED_BY%TYPE;
1454: l_last_update_login OKC_CONTRACT_DOCS.LAST_UPDATE_LOGIN%TYPE;

Line 1451: l_generated_flag OKC_CONTRACT_DOCS.GENERATED_FLAG%TYPE;

1447: l_request_id OKC_CONTRACT_DOCS.REQUEST_ID%TYPE;
1448: l_program_update_date OKC_CONTRACT_DOCS.PROGRAM_UPDATE_DATE%TYPE;
1449: l_parent_attached_doc_id OKC_CONTRACT_DOCS.PARENT_ATTACHED_DOC_ID%TYPE;
1450: l_delete_flag OKC_CONTRACT_DOCS.DELETE_FLAG%TYPE;
1451: l_generated_flag OKC_CONTRACT_DOCS.GENERATED_FLAG%TYPE;
1452: l_object_version_number OKC_CONTRACT_DOCS.OBJECT_VERSION_NUMBER%TYPE;
1453: l_last_updated_by OKC_CONTRACT_DOCS.LAST_UPDATED_BY%TYPE;
1454: l_last_update_login OKC_CONTRACT_DOCS.LAST_UPDATE_LOGIN%TYPE;
1455: l_last_update_date OKC_CONTRACT_DOCS.LAST_UPDATE_DATE%TYPE;

Line 1452: l_object_version_number OKC_CONTRACT_DOCS.OBJECT_VERSION_NUMBER%TYPE;

1448: l_program_update_date OKC_CONTRACT_DOCS.PROGRAM_UPDATE_DATE%TYPE;
1449: l_parent_attached_doc_id OKC_CONTRACT_DOCS.PARENT_ATTACHED_DOC_ID%TYPE;
1450: l_delete_flag OKC_CONTRACT_DOCS.DELETE_FLAG%TYPE;
1451: l_generated_flag OKC_CONTRACT_DOCS.GENERATED_FLAG%TYPE;
1452: l_object_version_number OKC_CONTRACT_DOCS.OBJECT_VERSION_NUMBER%TYPE;
1453: l_last_updated_by OKC_CONTRACT_DOCS.LAST_UPDATED_BY%TYPE;
1454: l_last_update_login OKC_CONTRACT_DOCS.LAST_UPDATE_LOGIN%TYPE;
1455: l_last_update_date OKC_CONTRACT_DOCS.LAST_UPDATE_DATE%TYPE;
1456: l_primary_contract_doc_flag OKC_CONTRACT_DOCS.PRIMARY_CONTRACT_DOC_FLAG%TYPE;

Line 1453: l_last_updated_by OKC_CONTRACT_DOCS.LAST_UPDATED_BY%TYPE;

1449: l_parent_attached_doc_id OKC_CONTRACT_DOCS.PARENT_ATTACHED_DOC_ID%TYPE;
1450: l_delete_flag OKC_CONTRACT_DOCS.DELETE_FLAG%TYPE;
1451: l_generated_flag OKC_CONTRACT_DOCS.GENERATED_FLAG%TYPE;
1452: l_object_version_number OKC_CONTRACT_DOCS.OBJECT_VERSION_NUMBER%TYPE;
1453: l_last_updated_by OKC_CONTRACT_DOCS.LAST_UPDATED_BY%TYPE;
1454: l_last_update_login OKC_CONTRACT_DOCS.LAST_UPDATE_LOGIN%TYPE;
1455: l_last_update_date OKC_CONTRACT_DOCS.LAST_UPDATE_DATE%TYPE;
1456: l_primary_contract_doc_flag OKC_CONTRACT_DOCS.PRIMARY_CONTRACT_DOC_FLAG%TYPE;
1457: l_mergeable_doc_flag OKC_CONTRACT_DOCS.MERGEABLE_DOC_FLAG%TYPE;

Line 1454: l_last_update_login OKC_CONTRACT_DOCS.LAST_UPDATE_LOGIN%TYPE;

1450: l_delete_flag OKC_CONTRACT_DOCS.DELETE_FLAG%TYPE;
1451: l_generated_flag OKC_CONTRACT_DOCS.GENERATED_FLAG%TYPE;
1452: l_object_version_number OKC_CONTRACT_DOCS.OBJECT_VERSION_NUMBER%TYPE;
1453: l_last_updated_by OKC_CONTRACT_DOCS.LAST_UPDATED_BY%TYPE;
1454: l_last_update_login OKC_CONTRACT_DOCS.LAST_UPDATE_LOGIN%TYPE;
1455: l_last_update_date OKC_CONTRACT_DOCS.LAST_UPDATE_DATE%TYPE;
1456: l_primary_contract_doc_flag OKC_CONTRACT_DOCS.PRIMARY_CONTRACT_DOC_FLAG%TYPE;
1457: l_mergeable_doc_flag OKC_CONTRACT_DOCS.MERGEABLE_DOC_FLAG%TYPE;
1458:

Line 1455: l_last_update_date OKC_CONTRACT_DOCS.LAST_UPDATE_DATE%TYPE;

1451: l_generated_flag OKC_CONTRACT_DOCS.GENERATED_FLAG%TYPE;
1452: l_object_version_number OKC_CONTRACT_DOCS.OBJECT_VERSION_NUMBER%TYPE;
1453: l_last_updated_by OKC_CONTRACT_DOCS.LAST_UPDATED_BY%TYPE;
1454: l_last_update_login OKC_CONTRACT_DOCS.LAST_UPDATE_LOGIN%TYPE;
1455: l_last_update_date OKC_CONTRACT_DOCS.LAST_UPDATE_DATE%TYPE;
1456: l_primary_contract_doc_flag OKC_CONTRACT_DOCS.PRIMARY_CONTRACT_DOC_FLAG%TYPE;
1457: l_mergeable_doc_flag OKC_CONTRACT_DOCS.MERGEABLE_DOC_FLAG%TYPE;
1458:
1459: BEGIN

Line 1456: l_primary_contract_doc_flag OKC_CONTRACT_DOCS.PRIMARY_CONTRACT_DOC_FLAG%TYPE;

1452: l_object_version_number OKC_CONTRACT_DOCS.OBJECT_VERSION_NUMBER%TYPE;
1453: l_last_updated_by OKC_CONTRACT_DOCS.LAST_UPDATED_BY%TYPE;
1454: l_last_update_login OKC_CONTRACT_DOCS.LAST_UPDATE_LOGIN%TYPE;
1455: l_last_update_date OKC_CONTRACT_DOCS.LAST_UPDATE_DATE%TYPE;
1456: l_primary_contract_doc_flag OKC_CONTRACT_DOCS.PRIMARY_CONTRACT_DOC_FLAG%TYPE;
1457: l_mergeable_doc_flag OKC_CONTRACT_DOCS.MERGEABLE_DOC_FLAG%TYPE;
1458:
1459: BEGIN
1460:

Line 1457: l_mergeable_doc_flag OKC_CONTRACT_DOCS.MERGEABLE_DOC_FLAG%TYPE;

1453: l_last_updated_by OKC_CONTRACT_DOCS.LAST_UPDATED_BY%TYPE;
1454: l_last_update_login OKC_CONTRACT_DOCS.LAST_UPDATE_LOGIN%TYPE;
1455: l_last_update_date OKC_CONTRACT_DOCS.LAST_UPDATE_DATE%TYPE;
1456: l_primary_contract_doc_flag OKC_CONTRACT_DOCS.PRIMARY_CONTRACT_DOC_FLAG%TYPE;
1457: l_mergeable_doc_flag OKC_CONTRACT_DOCS.MERGEABLE_DOC_FLAG%TYPE;
1458:
1459: BEGIN
1460:
1461: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1648: -- Delete_Row for:OKC_CONTRACT_DOCS --

1644: ---------------------------------------------------------------------------
1645: -- PROCEDURE Delete_Row
1646: ---------------------------------------------------------------------------
1647: -------------------------------------
1648: -- Delete_Row for:OKC_CONTRACT_DOCS --
1649: -------------------------------------
1650: FUNCTION Delete_Row(
1651: p_business_document_type IN VARCHAR2,
1652: p_business_document_id IN NUMBER,

Line 1663: DELETE FROM OKC_CONTRACT_DOCS

1659: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1660: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'8200: Entered Delete_Row');
1661: END IF;
1662:
1663: DELETE FROM OKC_CONTRACT_DOCS
1664: WHERE BUSINESS_DOCUMENT_TYPE = p_BUSINESS_DOCUMENT_TYPE AND BUSINESS_DOCUMENT_ID = p_BUSINESS_DOCUMENT_ID AND BUSINESS_DOCUMENT_VERSION = p_BUSINESS_DOCUMENT_VERSION AND ATTACHED_DOCUMENT_ID = p_ATTACHED_DOCUMENT_ID;
1665:
1666: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1667: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'8300: Leaving Delete_Row');

Line 1691: -- Delete_Row for:OKC_CONTRACT_DOCS --

1687:
1688: END Delete_Row;
1689:
1690: -------------------------------------
1691: -- Delete_Row for:OKC_CONTRACT_DOCS --
1692: -------------------------------------
1693: PROCEDURE Delete_Row(
1694: x_return_status OUT NOCOPY VARCHAR2,
1695: p_business_document_type IN VARCHAR2,

Line 1771: -- : What: This API updates the previous version's attachments in OKC_CONTRACT_DOCS.

1767: --Type : Private.
1768: --Function : When: This API is invoked from the Repository module. It is called when
1769: -- a contract's current version is deleted and a previous version of that contract
1770: -- exists.
1771: -- : What: This API updates the previous version's attachments in OKC_CONTRACT_DOCS.
1772: -- : This function does two things:
1773: -- : 1. Updates the BUSINESS_DOCUMENT_VERSION from its current value to -99.
1774: -- : 2. Updates the EFFECTIVE_FROM_VERSION to -99 for those attachments that were effective
1775: -- : from this current version only (not added from a previous version).

Line 1797: 'Entered OKC_CONTRACT_DOCS_PVT.reset_bus_doc_ver_to_current');

1793: BEGIN
1794:
1795: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1796: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1797: 'Entered OKC_CONTRACT_DOCS_PVT.reset_bus_doc_ver_to_current');
1798: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1799: 'p_business_document_type is: ' || p_business_document_type);
1800: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1801: 'p_business_document_id is: ' || to_char(p_business_document_id));

Line 1815: UPDATE okc_contract_docs

1811: -- Initialize message list
1812: FND_MSG_PUB.initialize;
1813:
1814: -- Update the effective_from_version of the documents added in that version only
1815: UPDATE okc_contract_docs
1816: SET effective_from_version = -99
1817: WHERE delete_flag = 'N'
1818: AND business_document_version = p_business_document_version - 1
1819: AND business_document_id = p_business_document_id

Line 1825: UPDATE okc_contract_docs

1821: AND business_document_version = effective_from_version;
1822:
1823:
1824: -- Update the business_document_version of all the documents of previous version
1825: UPDATE okc_contract_docs
1826: SET business_document_version = -99
1827: WHERE delete_flag = 'N'
1828: AND business_document_version = p_business_document_version - 1
1829: AND business_document_id = p_business_document_id

Line 1835: 'Leaving OKC_CONTRACT_DOCS_PVT.reset_bus_doc_ver_to_current');

1831:
1832:
1833: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1834: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1835: 'Leaving OKC_CONTRACT_DOCS_PVT.reset_bus_doc_ver_to_current');
1836: END IF;
1837:
1838: RETURN(G_RET_STS_SUCCESS);
1839:

Line 1844: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'Leaving OKC_CONTRACT_DOCS_PVT.reset_bus_doc_ver_to_current because of EXCEPTION: '||sqlerrm);

1840: EXCEPTION
1841: WHEN OTHERS THEN
1842:
1843: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1844: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'Leaving OKC_CONTRACT_DOCS_PVT.reset_bus_doc_ver_to_current because of EXCEPTION: '||sqlerrm);
1845: END IF;
1846:
1847: ROLLBACK TO reset_bus_doc_ver_to_current;
1848:

Line 1862: END OKC_CONTRACT_DOCS_PVT;

1858: END reset_bus_doc_ver_to_current;
1859:
1860:
1861:
1862: END OKC_CONTRACT_DOCS_PVT;