DBA Data[Home] [Help]

APPS.OKC_CONTRACT_PVT dependencies on FND_ATTACHED_DOCUMENTS

Line 981: l_major_version FND_ATTACHED_DOCUMENTS.PK2_VALUE%TYPE;

977: x_msg_data OUT NOCOPY VARCHAR2,
978: p_chrv_rec IN OKC_CHR_PVT.chrv_rec_type) IS
979:
980: l_dummy_val NUMBER;
981: l_major_version FND_ATTACHED_DOCUMENTS.PK2_VALUE%TYPE;
982:
983: Cursor l_clev_csr Is
984: select count(*)
985: from OKC_K_LINES_B

Line 1141: -- in fnd_attached_documents2_pkg.delete_attachments call

1137: -- The following line to be added to the code once
1138: -- bug 1553916 completes
1139: -- l_pkey2 => l_major_version) = 'Y')
1140: -- also below remove the comments
1141: -- in fnd_attached_documents2_pkg.delete_attachments call
1142: Then
1143: fnd_attached_documents2_pkg.delete_attachments(
1144: x_entity_name => 'OKC_K_HEADERS_B',
1145: x_pk1_value => p_chrv_rec.id,

Line 1143: fnd_attached_documents2_pkg.delete_attachments(

1139: -- l_pkey2 => l_major_version) = 'Y')
1140: -- also below remove the comments
1141: -- in fnd_attached_documents2_pkg.delete_attachments call
1142: Then
1143: fnd_attached_documents2_pkg.delete_attachments(
1144: x_entity_name => 'OKC_K_HEADERS_B',
1145: x_pk1_value => p_chrv_rec.id,
1146: x_pk2_value => l_major_version
1147: );

Line 1759: l_major_version FND_ATTACHED_DOCUMENTS.PK2_VALUE%TYPE;

1755:
1756: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1757: l_chr_id NUMBER;
1758: l_dummy_val NUMBER;
1759: l_major_version FND_ATTACHED_DOCUMENTS.PK2_VALUE%TYPE;
1760:
1761: Cursor l_clev_csr Is
1762: select count(*)
1763: from OKC_K_LINES_B

Line 2010: -- in fnd_attached_documents2_pkg.delete_attachments call

2006: -- The following line to be added to the code once
2007: -- bug 1553916 completes
2008: -- l_pkey2 => l_major_version) = 'Y')
2009: -- also below remove the comments
2010: -- in fnd_attached_documents2_pkg.delete_attachments call
2011: Then
2012: fnd_attached_documents2_pkg.delete_attachments(
2013: x_entity_name => 'OKC_K_LINES_B',
2014: x_pk1_value => p_clev_rec.id,

Line 2012: fnd_attached_documents2_pkg.delete_attachments(

2008: -- l_pkey2 => l_major_version) = 'Y')
2009: -- also below remove the comments
2010: -- in fnd_attached_documents2_pkg.delete_attachments call
2011: Then
2012: fnd_attached_documents2_pkg.delete_attachments(
2013: x_entity_name => 'OKC_K_LINES_B',
2014: x_pk1_value => p_clev_rec.id,
2015: x_pk2_value => l_major_version
2016: );