DBA Data[Home] [Help]

APPS.OKC_COPY_CONTRACT_PVT dependencies on FND_ATTACHMENT_UTIL_PKG

Line 3509: FND_ATTACHMENT_UTIL_PKG.function_name IS NULL

3505: FROM okc_k_headers_b
3506: WHERE id = p_chr_id;
3507: BEGIN
3508: If (p_chr_id IS NOT NULL AND
3509: FND_ATTACHMENT_UTIL_PKG.function_name IS NULL
3510: )
3511: Then
3512: open l_chr_csr;
3513: fetch l_chr_csr into l_app_id;

Line 3518: FND_ATTACHMENT_UTIL_PKG.function_name := 'OKSAUDET';

3514: close l_chr_csr;
3515:
3516: -- Added for Bug 2384423
3517: If (l_app_id = 515) Then
3518: FND_ATTACHMENT_UTIL_PKG.function_name := 'OKSAUDET';
3519: FND_ATTACHMENT_UTIL_PKG.function_type := 'O';
3520: Else
3521: FND_ATTACHMENT_UTIL_PKG.function_name := 'OKCAUDET';
3522: FND_ATTACHMENT_UTIL_PKG.function_type := 'O';

Line 3519: FND_ATTACHMENT_UTIL_PKG.function_type := 'O';

3515:
3516: -- Added for Bug 2384423
3517: If (l_app_id = 515) Then
3518: FND_ATTACHMENT_UTIL_PKG.function_name := 'OKSAUDET';
3519: FND_ATTACHMENT_UTIL_PKG.function_type := 'O';
3520: Else
3521: FND_ATTACHMENT_UTIL_PKG.function_name := 'OKCAUDET';
3522: FND_ATTACHMENT_UTIL_PKG.function_type := 'O';
3523: End If;

Line 3521: FND_ATTACHMENT_UTIL_PKG.function_name := 'OKCAUDET';

3517: If (l_app_id = 515) Then
3518: FND_ATTACHMENT_UTIL_PKG.function_name := 'OKSAUDET';
3519: FND_ATTACHMENT_UTIL_PKG.function_type := 'O';
3520: Else
3521: FND_ATTACHMENT_UTIL_PKG.function_name := 'OKCAUDET';
3522: FND_ATTACHMENT_UTIL_PKG.function_type := 'O';
3523: End If;
3524:
3525: /* Commented for Bug 2384423

Line 3522: FND_ATTACHMENT_UTIL_PKG.function_type := 'O';

3518: FND_ATTACHMENT_UTIL_PKG.function_name := 'OKSAUDET';
3519: FND_ATTACHMENT_UTIL_PKG.function_type := 'O';
3520: Else
3521: FND_ATTACHMENT_UTIL_PKG.function_name := 'OKCAUDET';
3522: FND_ATTACHMENT_UTIL_PKG.function_type := 'O';
3523: End If;
3524:
3525: /* Commented for Bug 2384423
3526: If (l_app_id = 510) Then

Line 3527: FND_ATTACHMENT_UTIL_PKG.function_name := 'OKCAUDET';

3523: End If;
3524:
3525: /* Commented for Bug 2384423
3526: If (l_app_id = 510) Then
3527: FND_ATTACHMENT_UTIL_PKG.function_name := 'OKCAUDET';
3528: FND_ATTACHMENT_UTIL_PKG.function_type := 'O';
3529: Elsif (l_app_id = 515) Then
3530: FND_ATTACHMENT_UTIL_PKG.function_name := 'OKSAUDET';
3531: FND_ATTACHMENT_UTIL_PKG.function_type := 'O';

Line 3528: FND_ATTACHMENT_UTIL_PKG.function_type := 'O';

3524:
3525: /* Commented for Bug 2384423
3526: If (l_app_id = 510) Then
3527: FND_ATTACHMENT_UTIL_PKG.function_name := 'OKCAUDET';
3528: FND_ATTACHMENT_UTIL_PKG.function_type := 'O';
3529: Elsif (l_app_id = 515) Then
3530: FND_ATTACHMENT_UTIL_PKG.function_name := 'OKSAUDET';
3531: FND_ATTACHMENT_UTIL_PKG.function_type := 'O';
3532: End If;

Line 3530: FND_ATTACHMENT_UTIL_PKG.function_name := 'OKSAUDET';

3526: If (l_app_id = 510) Then
3527: FND_ATTACHMENT_UTIL_PKG.function_name := 'OKCAUDET';
3528: FND_ATTACHMENT_UTIL_PKG.function_type := 'O';
3529: Elsif (l_app_id = 515) Then
3530: FND_ATTACHMENT_UTIL_PKG.function_name := 'OKSAUDET';
3531: FND_ATTACHMENT_UTIL_PKG.function_type := 'O';
3532: End If;
3533: */
3534: End If;

Line 3531: FND_ATTACHMENT_UTIL_PKG.function_type := 'O';

3527: FND_ATTACHMENT_UTIL_PKG.function_name := 'OKCAUDET';
3528: FND_ATTACHMENT_UTIL_PKG.function_type := 'O';
3529: Elsif (l_app_id = 515) Then
3530: FND_ATTACHMENT_UTIL_PKG.function_name := 'OKSAUDET';
3531: FND_ATTACHMENT_UTIL_PKG.function_type := 'O';
3532: End If;
3533: */
3534: End If;
3535: END;

Line 4425: -- before calling fnd_attachment_util_pkg.get_atchmt_exists

4421: RAISE G_EXCEPTION_HALT_VALIDATION;
4422: END IF;
4423:
4424: -- set attachement session variables
4425: -- before calling fnd_attachment_util_pkg.get_atchmt_exists
4426: Set_Attach_Session_Vars(x_clev_rec.dnz_chr_id);
4427:
4428: If (fnd_attachment_util_pkg.get_atchmt_exists (
4429: l_entity_name => 'OKC_K_LINES_B',

Line 4428: If (fnd_attachment_util_pkg.get_atchmt_exists (

4424: -- set attachement session variables
4425: -- before calling fnd_attachment_util_pkg.get_atchmt_exists
4426: Set_Attach_Session_Vars(x_clev_rec.dnz_chr_id);
4427:
4428: If (fnd_attachment_util_pkg.get_atchmt_exists (
4429: l_entity_name => 'OKC_K_LINES_B',
4430: l_pkey1 => p_from_cle_id,
4431: l_pkey2 => l_from_version) = 'Y')
4432:

Line 5636: -- before calling fnd_attachment_util_pkg.get_atchmt_exists

5632: RAISE G_EXCEPTION_HALT_VALIDATION;
5633: END IF;
5634:
5635: -- set attachement session variables
5636: -- before calling fnd_attachment_util_pkg.get_atchmt_exists
5637: Set_Attach_Session_Vars(p_from_chr_id);
5638:
5639: --Bug 3326337 Removed the hard coding for entity names
5640: /* Commentedout for 11510 GSI Issue on copying attachments

Line 5641: If(FND_ATTACHMENT_UTIL_PKG.function_name = 'OKSAUDET') THEN

5637: Set_Attach_Session_Vars(p_from_chr_id);
5638:
5639: --Bug 3326337 Removed the hard coding for entity names
5640: /* Commentedout for 11510 GSI Issue on copying attachments
5641: If(FND_ATTACHMENT_UTIL_PKG.function_name = 'OKSAUDET') THEN
5642: l_entity_name := 'OKC_K_HEADERS_V';
5643: l_from_entity_name := 'OKC_K_HEADERS_V';
5644: l_to_entity_name := 'OKC_K_HEADERS_V';
5645: ELSE */

Line 5651: If (fnd_attachment_util_pkg.get_atchmt_exists (

5647: l_from_entity_name := 'OKC_K_HEADERS_B';
5648: l_to_entity_name := 'OKC_K_HEADERS_B';
5649: --End If;
5650:
5651: If (fnd_attachment_util_pkg.get_atchmt_exists (
5652: l_entity_name => l_entity_name,
5653: l_pkey1 => p_from_chr_id,
5654: l_pkey2 => l_from_version) = 'Y')
5655: