DBA Data[Home] [Help]

APPS.OKC_COPY_CONTRACT_PVT dependencies on FND_ATTACHMENT_UTIL_PKG

Line 3508: FND_ATTACHMENT_UTIL_PKG.function_name IS NULL

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 4424: -- before calling fnd_attachment_util_pkg.get_atchmt_exists

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

Line 4427: If (fnd_attachment_util_pkg.get_atchmt_exists (

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

Line 5635: -- before calling fnd_attachment_util_pkg.get_atchmt_exists

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

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

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

Line 5650: If (fnd_attachment_util_pkg.get_atchmt_exists (

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