APPS.OKC_COPY_CONTRACT_PVT dependencies on FND_ATTACHED_DOCUMENTS

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

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

Line 3607: l_from_version FND_ATTACHED_DOCUMENTS.PK2_VALUE%TYPE;

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

Line 3608: l_to_version FND_ATTACHED_DOCUMENTS.PK2_VALUE%TYPE;

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

Line 4437: -- in fnd_attached_documents2_pkg.copy_attachments call

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

Line 4441: fnd_attached_documents2_pkg.copy_attachments(

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

Line 5255: l_from_version FND_ATTACHED_DOCUMENTS.PK2_VALUE%TYPE;

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

Line 5660: -- in fnd_attached_documents2_pkg.copy_attachments call

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

Line 5662: fnd_attached_documents2_pkg.copy_attachments(

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