DBA Data[Home] [Help]

APPS.OKL_INS_QUOTE_PVT dependencies on OKL_K_PARTY_ROLES_PVT

Line 36: l_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;

32: l_cplv_rec_type okl_okc_migration_pvt.cplv_rec_type;
33: x_cplv_rec_type okl_okc_migration_pvt.cplv_rec_type;
34:
35: --gboomina 26-Oct-05 Bug#4558486 - Added - Start
36: l_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
37: lx_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
38: --gboomina 26-Oct-05 Bug#4558486 - Added - End
39:
40: CURSOR c_vendor_exist (p_khr_id NUMBER , p_isu_id NUMBER) IS

Line 37: lx_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;

33: x_cplv_rec_type okl_okc_migration_pvt.cplv_rec_type;
34:
35: --gboomina 26-Oct-05 Bug#4558486 - Added - Start
36: l_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
37: lx_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
38: --gboomina 26-Oct-05 Bug#4558486 - Added - End
39:
40: CURSOR c_vendor_exist (p_khr_id NUMBER , p_isu_id NUMBER) IS
41: select 'x'

Line 78: -- Start of wraper code generated automatically by Debug code generator for okl_k_party_roles_pvt.create_k_party_role

74: l_cplv_rec_type.RLE_CODE := 'EXTERNAL_PARTY' ;
75: l_cplv_rec_type.OBJECT1_ID1 := p_ipyv_rec.ISU_ID ;
76: l_cplv_rec_type.OBJECT1_ID2 := '#' ;
77: l_cplv_rec_type.JTOT_OBJECT1_CODE := 'OKX_PARTY' ;
78: -- Start of wraper code generated automatically by Debug code generator for okl_k_party_roles_pvt.create_k_party_role
79: IF(L_DEBUG_ENABLED='Y') THEN
80: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
81: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
82: END IF;

Line 85: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call okl_k_party_roles_pvt.create_k_party_role ');

81: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
82: END IF;
83: IF(IS_DEBUG_PROCEDURE_ON) THEN
84: BEGIN
85: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call okl_k_party_roles_pvt.create_k_party_role ');
86: END;
87: END IF;
88: -- gboomina 26-Oct-05 Bug#4558486 Start - Changed okl_okc_migration_pvt.create_k_party_role to okl_k_party_roles_pvt.create_k_party_role
89: okl_k_party_roles_pvt.create_k_party_role(

Line 88: -- gboomina 26-Oct-05 Bug#4558486 Start - Changed okl_okc_migration_pvt.create_k_party_role to okl_k_party_roles_pvt.create_k_party_role

84: BEGIN
85: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call okl_k_party_roles_pvt.create_k_party_role ');
86: END;
87: END IF;
88: -- gboomina 26-Oct-05 Bug#4558486 Start - Changed okl_okc_migration_pvt.create_k_party_role to okl_k_party_roles_pvt.create_k_party_role
89: okl_k_party_roles_pvt.create_k_party_role(
90: p_api_version =>l_api_version,
91: p_init_msg_list => OKC_API.G_FALSE,
92: x_return_status => l_return_status,

Line 89: okl_k_party_roles_pvt.create_k_party_role(

85: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call okl_k_party_roles_pvt.create_k_party_role ');
86: END;
87: END IF;
88: -- gboomina 26-Oct-05 Bug#4558486 Start - Changed okl_okc_migration_pvt.create_k_party_role to okl_k_party_roles_pvt.create_k_party_role
89: okl_k_party_roles_pvt.create_k_party_role(
90: p_api_version =>l_api_version,
91: p_init_msg_list => OKC_API.G_FALSE,
92: x_return_status => l_return_status,
93: x_msg_count => x_msg_count,

Line 100: -- gboomina 26-Oct-05 Bug#4558486 End - Changed okl_okc_migration_pvt.create_k_party_role to okl_k_party_roles_pvt.create_k_party_role

96: x_cplv_rec => x_cplv_rec_type,
97: p_kplv_rec => l_kplv_rec,
98: x_kplv_rec => lx_kplv_rec);
99:
100: -- gboomina 26-Oct-05 Bug#4558486 End - Changed okl_okc_migration_pvt.create_k_party_role to okl_k_party_roles_pvt.create_k_party_role
101:
102: IF(IS_DEBUG_PROCEDURE_ON) THEN
103: BEGIN
104: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call okl_k_party_roles_pvt.create_k_party_role ');

Line 104: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call okl_k_party_roles_pvt.create_k_party_role ');

100: -- gboomina 26-Oct-05 Bug#4558486 End - Changed okl_okc_migration_pvt.create_k_party_role to okl_k_party_roles_pvt.create_k_party_role
101:
102: IF(IS_DEBUG_PROCEDURE_ON) THEN
103: BEGIN
104: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call okl_k_party_roles_pvt.create_k_party_role ');
105: END;
106: END IF;
107: -- End of wraper code generated automatically by Debug code generator for okl_k_party_roles_pvt.create_k_party_role
108: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 107: -- End of wraper code generated automatically by Debug code generator for okl_k_party_roles_pvt.create_k_party_role

103: BEGIN
104: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call okl_k_party_roles_pvt.create_k_party_role ');
105: END;
106: END IF;
107: -- End of wraper code generated automatically by Debug code generator for okl_k_party_roles_pvt.create_k_party_role
108: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
109:
110: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
111: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 118: -- Start of wraper code generated automatically by Debug code generator for okl_k_party_roles_pvt.create_k_party_role

114:
115:
116: END IF ;
117:
118: -- Start of wraper code generated automatically by Debug code generator for okl_k_party_roles_pvt.create_k_party_role
119: IF(L_DEBUG_ENABLED='Y') THEN
120: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
121: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
122: END IF;

Line 358: l_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;

354: x_cplv_rec_type okl_okc_migration_pvt.cplv_rec_type;
355: l_ovn NUMBER;
356:
357: --gboomina 26-Oct-05 Bug#4558486 - Added - Start
358: l_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
359: lx_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
360: --gboomina 26-Oct-05 Bug#4558486 - Added - End
361:
362: CURSOR fetch_lease_app(c_lakhr_id IN NUMBER)

Line 359: lx_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;

355: l_ovn NUMBER;
356:
357: --gboomina 26-Oct-05 Bug#4558486 - Added - Start
358: l_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
359: lx_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
360: --gboomina 26-Oct-05 Bug#4558486 - Added - End
361:
362: CURSOR fetch_lease_app(c_lakhr_id IN NUMBER)
363: IS

Line 441: ,'Begin Debug OKLRINQB.pls call okl_k_party_roles_pvt.create_k_party_role');

437: BEGIN
438: OKL_DEBUG_PUB.LOG_DEBUG(
439: L_LEVEL_PROCEDURE
440: ,L_MODULE
441: ,'Begin Debug OKLRINQB.pls call okl_k_party_roles_pvt.create_k_party_role');
442: END;
443: END IF;
444: -- gboomina 26-Oct-05 Bug#4558486 Start - Changed okl_okc_migration_pvt.create_k_party_role to okl_k_party_roles_pvt.create_k_party_role
445: okl_k_party_roles_pvt.create_k_party_role(

Line 444: -- gboomina 26-Oct-05 Bug#4558486 Start - Changed okl_okc_migration_pvt.create_k_party_role to okl_k_party_roles_pvt.create_k_party_role

440: ,L_MODULE
441: ,'Begin Debug OKLRINQB.pls call okl_k_party_roles_pvt.create_k_party_role');
442: END;
443: END IF;
444: -- gboomina 26-Oct-05 Bug#4558486 Start - Changed okl_okc_migration_pvt.create_k_party_role to okl_k_party_roles_pvt.create_k_party_role
445: okl_k_party_roles_pvt.create_k_party_role(
446: p_api_version => l_api_version,
447: p_init_msg_list => OKL_API.G_FALSE,
448: x_return_status => l_return_status,

Line 445: okl_k_party_roles_pvt.create_k_party_role(

441: ,'Begin Debug OKLRINQB.pls call okl_k_party_roles_pvt.create_k_party_role');
442: END;
443: END IF;
444: -- gboomina 26-Oct-05 Bug#4558486 Start - Changed okl_okc_migration_pvt.create_k_party_role to okl_k_party_roles_pvt.create_k_party_role
445: okl_k_party_roles_pvt.create_k_party_role(
446: p_api_version => l_api_version,
447: p_init_msg_list => OKL_API.G_FALSE,
448: x_return_status => l_return_status,
449: x_msg_count => x_msg_count,

Line 456: -- gboomina 26-Oct-05 Bug#4558486 End - Changed okl_okc_migration_pvt.create_k_party_role to okl_k_party_roles_pvt.create_k_party_role

452: x_cplv_rec => x_cplv_rec_type,
453: p_kplv_rec => l_kplv_rec,
454: x_kplv_rec => lx_kplv_rec);
455:
456: -- gboomina 26-Oct-05 Bug#4558486 End - Changed okl_okc_migration_pvt.create_k_party_role to okl_k_party_roles_pvt.create_k_party_role
457: IF(IS_DEBUG_PROCEDURE_ON)
458: THEN
459: BEGIN
460: OKL_DEBUG_PUB.LOG_DEBUG(

Line 463: ,'End Debug OKLRINQB.pls call okl_k_party_roles_pvt.create_k_party_role');

459: BEGIN
460: OKL_DEBUG_PUB.LOG_DEBUG(
461: L_LEVEL_PROCEDURE
462: ,L_MODULE
463: ,'End Debug OKLRINQB.pls call okl_k_party_roles_pvt.create_k_party_role');
464: END;
465: END IF;
466: -- End of call to okl_k_party_roles_pvt.create_k_party_role
467: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)

Line 466: -- End of call to okl_k_party_roles_pvt.create_k_party_role

462: ,L_MODULE
463: ,'End Debug OKLRINQB.pls call okl_k_party_roles_pvt.create_k_party_role');
464: END;
465: END IF;
466: -- End of call to okl_k_party_roles_pvt.create_k_party_role
467: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)
468: THEN
469: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
470: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR)

Line 6803: l_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;

6799: p_sty_id NUMBER;
6800: l_total_oec NUMBER;
6801:
6802: --gboomina 26-Oct-05 Bug#4558486 - Added - Start
6803: l_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
6804: lx_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
6805: --gboomina 26-Oct-05 Bug#4558486 - Added - End
6806:
6807:

Line 6804: lx_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;

6800: l_total_oec NUMBER;
6801:
6802: --gboomina 26-Oct-05 Bug#4558486 - Added - Start
6803: l_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
6804: lx_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
6805: --gboomina 26-Oct-05 Bug#4558486 - Added - End
6806:
6807:
6808: CURSOR okl_k_total_oec_csr (p_khr_id NUMBER ) IS --Bug 4105057

Line 7034: -- Start of wraper code generated automatically by Debug code generator for okl_k_party_roles_pvt.create_k_party_role

7030: l_cplv_rec_type.RLE_CODE := 'OKL_VENDOR' ;
7031: l_cplv_rec_type.OBJECT1_ID1 := l_ipyv_rec.ISU_ID ;
7032: l_cplv_rec_type.OBJECT1_ID2 := '#' ;
7033: l_cplv_rec_type.JTOT_OBJECT1_CODE := 'OKX_VENDOR' ;
7034: -- Start of wraper code generated automatically by Debug code generator for okl_k_party_roles_pvt.create_k_party_role
7035: IF(L_DEBUG_ENABLED='Y') THEN
7036: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
7037: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
7038: END IF;

Line 7041: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call okl_k_party_roles_pvt.create_k_party_role ');

7037: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
7038: END IF;
7039: IF(IS_DEBUG_PROCEDURE_ON) THEN
7040: BEGIN
7041: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call okl_k_party_roles_pvt.create_k_party_role ');
7042: END;
7043: END IF;
7044: -- gboomina 26-Oct-05 Bug#4558486 Start - Changed okl_okc_migration_pvt.create_k_party_role to okl_k_party_roles_pvt.create_k_party_role
7045: okl_k_party_roles_pvt.create_k_party_role(

Line 7044: -- gboomina 26-Oct-05 Bug#4558486 Start - Changed okl_okc_migration_pvt.create_k_party_role to okl_k_party_roles_pvt.create_k_party_role

7040: BEGIN
7041: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call okl_k_party_roles_pvt.create_k_party_role ');
7042: END;
7043: END IF;
7044: -- gboomina 26-Oct-05 Bug#4558486 Start - Changed okl_okc_migration_pvt.create_k_party_role to okl_k_party_roles_pvt.create_k_party_role
7045: okl_k_party_roles_pvt.create_k_party_role(
7046: p_api_version =>l_api_version,
7047: p_init_msg_list => OKC_API.G_FALSE,
7048: x_return_status => l_return_status,

Line 7045: okl_k_party_roles_pvt.create_k_party_role(

7041: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call okl_k_party_roles_pvt.create_k_party_role ');
7042: END;
7043: END IF;
7044: -- gboomina 26-Oct-05 Bug#4558486 Start - Changed okl_okc_migration_pvt.create_k_party_role to okl_k_party_roles_pvt.create_k_party_role
7045: okl_k_party_roles_pvt.create_k_party_role(
7046: p_api_version =>l_api_version,
7047: p_init_msg_list => OKC_API.G_FALSE,
7048: x_return_status => l_return_status,
7049: x_msg_count => x_msg_count,

Line 7056: -- gboomina 26-Oct-05 Bug#4558486 End - Changed okl_okc_migration_pvt.create_k_party_role to okl_k_party_roles_pvt.create_k_party_role

7052: x_cplv_rec => x_cplv_rec_type,
7053: p_kplv_rec => l_kplv_rec,
7054: x_kplv_rec => lx_kplv_rec);
7055:
7056: -- gboomina 26-Oct-05 Bug#4558486 End - Changed okl_okc_migration_pvt.create_k_party_role to okl_k_party_roles_pvt.create_k_party_role
7057: IF(IS_DEBUG_PROCEDURE_ON) THEN
7058: BEGIN
7059: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call okl_k_party_roles_pvt.create_k_party_role ');
7060: END;

Line 7059: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call okl_k_party_roles_pvt.create_k_party_role ');

7055:
7056: -- gboomina 26-Oct-05 Bug#4558486 End - Changed okl_okc_migration_pvt.create_k_party_role to okl_k_party_roles_pvt.create_k_party_role
7057: IF(IS_DEBUG_PROCEDURE_ON) THEN
7058: BEGIN
7059: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call okl_k_party_roles_pvt.create_k_party_role ');
7060: END;
7061: END IF;
7062: -- End of wraper code generated automatically by Debug code generator for okl_k_party_roles_pvt.create_k_party_role
7063: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 7062: -- End of wraper code generated automatically by Debug code generator for okl_k_party_roles_pvt.create_k_party_role

7058: BEGIN
7059: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call okl_k_party_roles_pvt.create_k_party_role ');
7060: END;
7061: END IF;
7062: -- End of wraper code generated automatically by Debug code generator for okl_k_party_roles_pvt.create_k_party_role
7063: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
7064:
7065: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
7066: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN