APPS.OKC_COPY_CONTRACT_PVT dependencies on FND_ATTACHED_DOCUMENTS

Line 3548: x_from_version FND_ATTACHED_DOCUMENTS.PK2_VALUE%TYPE := NULL;

3544: SELECT to_char(major_version)
3545: FROM okc_k_vers_numbers
3546: WHERE chr_id = p_chr_id;
3547:
3548: x_from_version FND_ATTACHED_DOCUMENTS.PK2_VALUE%TYPE := NULL;
3549:
3550: BEGIN
3551: open l_cvm_csr;
3552: fetch l_cvm_csr into x_from_version;

Line 3606: l_from_version FND_ATTACHED_DOCUMENTS.PK2_VALUE%TYPE;

3602: l_cpl_id NUMBER;
3603: l_start_date DATE;
3604: l_end_date DATE;
3605: l_old_lse_id NUMBER;
3606: l_from_version FND_ATTACHED_DOCUMENTS.PK2_VALUE%TYPE;
3607: l_to_version FND_ATTACHED_DOCUMENTS.PK2_VALUE%TYPE;
3608:
3609: l_euro_currency varchar2(15) := NULL; /* For Euro Conversion - Bug 2155930 */
3610: l_converted_amount number := NULL; /* For Euro Conversion - Bug 2155930 */

Line 3607: l_to_version FND_ATTACHED_DOCUMENTS.PK2_VALUE%TYPE;

3603: l_start_date DATE;
3604: l_end_date DATE;
3605: l_old_lse_id NUMBER;
3606: l_from_version FND_ATTACHED_DOCUMENTS.PK2_VALUE%TYPE;
3607: l_to_version FND_ATTACHED_DOCUMENTS.PK2_VALUE%TYPE;
3608:
3609: l_euro_currency varchar2(15) := NULL; /* For Euro Conversion - Bug 2155930 */
3610: l_converted_amount number := NULL; /* For Euro Conversion - Bug 2155930 */
3611:

Line 4436: -- in fnd_attached_documents2_pkg.copy_attachments call

4432: -- The following line to be added to the code once
4433: -- bug 1553916 completes
4434: -- ,l_pkey2 => l_from_version) = 'Y')
4435: -- also below remove the comments
4436: -- in fnd_attached_documents2_pkg.copy_attachments call
4437: Then
4438: l_to_version := Get_Major_Version(x_clev_rec.dnz_chr_id);
4439:
4440: fnd_attached_documents2_pkg.copy_attachments(

Line 4440: fnd_attached_documents2_pkg.copy_attachments(

4436: -- in fnd_attached_documents2_pkg.copy_attachments call
4437: Then
4438: l_to_version := Get_Major_Version(x_clev_rec.dnz_chr_id);
4439:
4440: fnd_attached_documents2_pkg.copy_attachments(
4441: x_from_entity_name => 'OKC_K_LINES_B',
4442: x_from_pk1_value => p_from_cle_id,
4443: x_from_pk2_value => l_from_version,
4444: x_to_entity_name => 'OKC_K_LINES_B',

Line 5254: l_from_version FND_ATTACHED_DOCUMENTS.PK2_VALUE%TYPE;

5250: l_sts_code VARCHAR2(30);
5251: l_status_type VARCHAR2(30) := 'ENTERED';
5252: l_orig_system_source_code VARCHAR2(30) := 'OKC_HDR';
5253: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
5254: l_from_version FND_ATTACHED_DOCUMENTS.PK2_VALUE%TYPE;
5255:
5256: l_euro_currency varchar2(15) := NULL; /* For Euro Conversion - Bug 2155930 */
5257: l_converted_amount number := NULL; /* For Euro Conversion - Bug 2155930 */
5258:

Line 5659: -- in fnd_attached_documents2_pkg.copy_attachments call

5655: -- The following line to be added to the code once
5656: -- bug 1553916 completes
5657: -- ,l_pkey2 => l_from_version) = 'Y')
5658: -- also below remove the comments
5659: -- in fnd_attached_documents2_pkg.copy_attachments call
5660: Then
5661: fnd_attached_documents2_pkg.copy_attachments(
5662: x_from_entity_name => l_from_entity_name,
5663: x_from_pk1_value => p_from_chr_id,

Line 5661: fnd_attached_documents2_pkg.copy_attachments(

5657: -- ,l_pkey2 => l_from_version) = 'Y')
5658: -- also below remove the comments
5659: -- in fnd_attached_documents2_pkg.copy_attachments call
5660: Then
5661: fnd_attached_documents2_pkg.copy_attachments(
5662: x_from_entity_name => l_from_entity_name,
5663: x_from_pk1_value => p_from_chr_id,
5664: x_from_pk2_value => l_from_version,
5665: x_to_entity_name => l_to_entity_name,