DBA Data[Home] [Help]

APPS.OKL_QUOTE_TO_CONTRACT_PVT dependencies on OKL_K_PARTY_ROLES_PVT

Line 416: lp_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;

412: l_debug_enabled VARCHAR2(10);
413: row_count NUMBER DEFAULT 0;
414: lp_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
415: lx_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
416: lp_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
417: lx_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
418:
419: --Check for the existing party roles
420: CURSOR check_line_party_csr IS

Line 417: lx_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;

413: row_count NUMBER DEFAULT 0;
414: lp_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
415: lx_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
416: lp_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
417: lx_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
418:
419: --Check for the existing party roles
420: CURSOR check_line_party_csr IS
421: SELECT COUNT(1)

Line 485: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okl_k_party_roles_pvt.create_k_party_role'

481:
482: IF row_count = 0 THEN
483: lp_kplv_rec.validate_dff_yn := 'Y';
484: IF(l_debug_enabled='Y') THEN
485: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okl_k_party_roles_pvt.create_k_party_role'
486: ,'begin debug call create_k_party_role');
487: END IF;
488:
489: okl_k_party_roles_pvt.create_k_party_role(

Line 489: okl_k_party_roles_pvt.create_k_party_role(

485: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okl_k_party_roles_pvt.create_k_party_role'
486: ,'begin debug call create_k_party_role');
487: END IF;
488:
489: okl_k_party_roles_pvt.create_k_party_role(
490: p_api_version => p_api_version,
491: p_init_msg_list => p_init_msg_list,
492: x_return_status => x_return_status,
493: x_msg_count => x_msg_count,

Line 500: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okl_k_party_roles_pvt.create_k_party_role'

496: x_cplv_rec => lx_cplv_rec,
497: p_kplv_rec => lp_kplv_rec,
498: x_kplv_rec => lx_kplv_rec);
499: IF(l_debug_enabled='Y') THEN
500: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okl_k_party_roles_pvt.create_k_party_role'
501: ,'end debug call create_k_party_role');
502: END IF;
503: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
504: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 4506: lp_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;

4502: --party contacts rec
4503: lp_ctcv_rec OKC_CONTRACT_PARTY_PUB.ctcv_rec_type;
4504: lx_ctcv_rec OKC_CONTRACT_PARTY_PUB.ctcv_rec_type;
4505:
4506: lp_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
4507: lx_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
4508: --Check for the existing party roles
4509: CURSOR check_party_csr(p_chr_id NUMBER,p_customer_id NUMBER) IS
4510: SELECT COUNT(1)

Line 4507: lx_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;

4503: lp_ctcv_rec OKC_CONTRACT_PARTY_PUB.ctcv_rec_type;
4504: lx_ctcv_rec OKC_CONTRACT_PARTY_PUB.ctcv_rec_type;
4505:
4506: lp_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
4507: lx_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
4508: --Check for the existing party roles
4509: CURSOR check_party_csr(p_chr_id NUMBER,p_customer_id NUMBER) IS
4510: SELECT COUNT(1)
4511: FROM okc_k_party_roles_v

Line 4630: null_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;

4626: AND identifying_address_flag = 'Y' ;
4627:
4628: -- Variables Declaration Section
4629: null_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
4630: null_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
4631: lp_rgpv_rec OKL_RULE_PUB.rgpv_rec_type;
4632: lx_rgpv_rec OKL_RULE_PUB.rgpv_rec_type;
4633: l_rulv_tbl OKL_RULE_PUB.rulv_tbl_type;
4634: x_rulv_tbl OKL_RULE_PUB.rulv_tbl_type;

Line 4766: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okl_k_party_roles_pvt.create_k_party_role'

4762: RAISE OKL_API.G_EXCEPTION_ERROR;
4763: END IF;
4764: END IF;
4765: IF(l_debug_enabled='Y') THEN
4766: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okl_k_party_roles_pvt.create_k_party_role'
4767: ,'begin debug call create_k_party_role');
4768: END IF;
4769:
4770: lp_kplv_rec.validate_dff_yn := 'Y';

Line 4772: okl_k_party_roles_pvt.create_k_party_role(

4768: END IF;
4769:
4770: lp_kplv_rec.validate_dff_yn := 'Y';
4771:
4772: okl_k_party_roles_pvt.create_k_party_role(
4773: p_api_version => p_api_version,
4774: p_init_msg_list => p_init_msg_list,
4775: x_return_status => x_return_status,
4776: x_msg_count => x_msg_count,

Line 4783: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okl_k_party_roles_pvt.create_k_party_role'

4779: x_cplv_rec => lx_cplv_rec,
4780: p_kplv_rec => lp_kplv_rec,
4781: x_kplv_rec => lx_kplv_rec);
4782: IF(l_debug_enabled='Y') THEN
4783: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okl_k_party_roles_pvt.create_k_party_role'
4784: ,'end debug call create_k_party_role');
4785: END IF;
4786: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4787: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 4884: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okl_k_party_roles_pvt.create_k_party_role'

4880: RAISE OKL_API.G_EXCEPTION_ERROR;
4881: END IF;
4882: END IF;
4883: IF(l_debug_enabled='Y') THEN
4884: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okl_k_party_roles_pvt.create_k_party_role'
4885: ,'begin debug call create_k_party_role');
4886: END IF;
4887:
4888: lp_kplv_rec.validate_dff_yn := 'Y';

Line 4890: okl_k_party_roles_pvt.create_k_party_role(

4886: END IF;
4887:
4888: lp_kplv_rec.validate_dff_yn := 'Y';
4889:
4890: okl_k_party_roles_pvt.create_k_party_role(
4891: p_api_version => p_api_version,
4892: p_init_msg_list => p_init_msg_list,
4893: x_return_status => x_return_status,
4894: x_msg_count => x_msg_count,

Line 4901: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okl_k_party_roles_pvt.create_k_party_role'

4897: x_cplv_rec => lx_cplv_rec,
4898: p_kplv_rec => lp_kplv_rec,
4899: x_kplv_rec => lx_kplv_rec);
4900: IF(l_debug_enabled='Y') THEN
4901: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okl_k_party_roles_pvt.create_k_party_role'
4902: ,'end debug call create_k_party_role');
4903: END IF;
4904: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4905: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 5040: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okl_k_party_roles_pvt.create_k_party_role'

5036: RAISE OKL_API.G_EXCEPTION_ERROR;
5037: END IF;
5038: END IF;
5039: IF(l_debug_enabled='Y') THEN
5040: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okl_k_party_roles_pvt.create_k_party_role'
5041: ,'begin debug call create_k_party_role');
5042: END IF;
5043:
5044:

Line 5045: okl_k_party_roles_pvt.create_k_party_role(

5041: ,'begin debug call create_k_party_role');
5042: END IF;
5043:
5044:
5045: okl_k_party_roles_pvt.create_k_party_role(
5046: p_api_version => p_api_version,
5047: p_init_msg_list => p_init_msg_list,
5048: x_return_status => x_return_status,
5049: x_msg_count => x_msg_count,

Line 5056: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okl_k_party_roles_pvt.create_k_party_role'

5052: x_cplv_rec => lx_cplv_rec,
5053: p_kplv_rec => lp_kplv_rec,
5054: x_kplv_rec => lx_kplv_rec);
5055: IF(l_debug_enabled='Y') THEN
5056: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okl_k_party_roles_pvt.create_k_party_role'
5057: ,'end debug call create_k_party_role');
5058: END IF;
5059:
5060: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 5109: okl_k_party_roles_pvt.create_k_party_role(

5105:
5106: ----------------------------------------
5107: -- Create party role record --
5108: ----------------------------------------
5109: okl_k_party_roles_pvt.create_k_party_role(
5110: p_api_version => p_api_version,
5111: p_init_msg_list => p_init_msg_list,
5112: x_return_status => x_return_status,
5113: x_msg_count => x_msg_count,