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 6810: l_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;

6806: p_sty_id NUMBER;
6807: l_total_oec NUMBER;
6808:
6809: --gboomina 26-Oct-05 Bug#4558486 - Added - Start
6810: l_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
6811: lx_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
6812: --gboomina 26-Oct-05 Bug#4558486 - Added - End
6813:
6814:

Line 6811: lx_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;

6807: l_total_oec NUMBER;
6808:
6809: --gboomina 26-Oct-05 Bug#4558486 - Added - Start
6810: l_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
6811: lx_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
6812: --gboomina 26-Oct-05 Bug#4558486 - Added - End
6813:
6814:
6815: CURSOR okl_k_total_oec_csr (p_khr_id NUMBER ) IS --Bug 4105057

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

7037: l_cplv_rec_type.RLE_CODE := 'OKL_VENDOR' ;
7038: l_cplv_rec_type.OBJECT1_ID1 := l_ipyv_rec.ISU_ID ;
7039: l_cplv_rec_type.OBJECT1_ID2 := '#' ;
7040: l_cplv_rec_type.JTOT_OBJECT1_CODE := 'OKX_VENDOR' ;
7041: -- Start of wraper code generated automatically by Debug code generator for okl_k_party_roles_pvt.create_k_party_role
7042: IF(L_DEBUG_ENABLED='Y') THEN
7043: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
7044: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
7045: END IF;

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

7044: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
7045: END IF;
7046: IF(IS_DEBUG_PROCEDURE_ON) THEN
7047: BEGIN
7048: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call okl_k_party_roles_pvt.create_k_party_role ');
7049: END;
7050: END IF;
7051: -- 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
7052: okl_k_party_roles_pvt.create_k_party_role(

Line 7051: -- 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

7047: BEGIN
7048: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call okl_k_party_roles_pvt.create_k_party_role ');
7049: END;
7050: END IF;
7051: -- 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
7052: okl_k_party_roles_pvt.create_k_party_role(
7053: p_api_version =>l_api_version,
7054: p_init_msg_list => OKC_API.G_FALSE,
7055: x_return_status => l_return_status,

Line 7052: okl_k_party_roles_pvt.create_k_party_role(

7048: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call okl_k_party_roles_pvt.create_k_party_role ');
7049: END;
7050: END IF;
7051: -- 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
7052: okl_k_party_roles_pvt.create_k_party_role(
7053: p_api_version =>l_api_version,
7054: p_init_msg_list => OKC_API.G_FALSE,
7055: x_return_status => l_return_status,
7056: x_msg_count => x_msg_count,

Line 7063: -- 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

7059: x_cplv_rec => x_cplv_rec_type,
7060: p_kplv_rec => l_kplv_rec,
7061: x_kplv_rec => lx_kplv_rec);
7062:
7063: -- 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
7064: IF(IS_DEBUG_PROCEDURE_ON) THEN
7065: BEGIN
7066: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call okl_k_party_roles_pvt.create_k_party_role ');
7067: END;

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

7062:
7063: -- 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
7064: IF(IS_DEBUG_PROCEDURE_ON) THEN
7065: BEGIN
7066: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call okl_k_party_roles_pvt.create_k_party_role ');
7067: END;
7068: END IF;
7069: -- End of wraper code generated automatically by Debug code generator for okl_k_party_roles_pvt.create_k_party_role
7070: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

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

7065: BEGIN
7066: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call okl_k_party_roles_pvt.create_k_party_role ');
7067: END;
7068: END IF;
7069: -- End of wraper code generated automatically by Debug code generator for okl_k_party_roles_pvt.create_k_party_role
7070: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
7071:
7072: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
7073: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN