DBA Data[Home] [Help]

APPS.OKC_CONTRACT_PUB dependencies on OKC_UTIL

Line 5: -- subtype control_rec_type is okc_util.okc_control_rec_type;

1: PACKAGE BODY OKC_CONTRACT_PUB AS
2: /* $Header: OKCPCHRB.pls 120.3 2005/07/19 05:12:03 maanand noship $ */
3: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
4:
5: -- subtype control_rec_type is okc_util.okc_control_rec_type;
6:
7: g_api_type CONSTANT VARCHAR2(4) := '_PVT';
8:
9: PROCEDURE create_contract_header(

Line 47: OKC_UTIL.call_user_hook(x_return_status => x_return_status,

43: -- call BEFORE user hook
44: l_chrv_rec := p_chrv_rec;
45: g_chrv_rec := l_chrv_rec;
46:
47: OKC_UTIL.call_user_hook(x_return_status => x_return_status,
48: p_package_name => g_pkg_name,
49: p_procedure_name => l_api_name,
50: p_before_after => 'B');
51:

Line 67: l_modify_access := OKC_UTIL.Create_K_Access(p_chrv_rec.scs_code);

63:
64: -- bug 2684439
65: --l_modify_access willbe TRUE, if category has modify access.
66: If p_check_access = 'Y' Then
67: l_modify_access := OKC_UTIL.Create_K_Access(p_chrv_rec.scs_code);
68: Elsif p_check_access = 'N' Then
69: l_modify_access := TRUE;
70: End If;
71:

Line 100: OKC_UTIL.call_user_hook(x_return_status => x_return_status,

96:
97: -- call AFTER user hook
98: g_chrv_rec := x_chrv_rec;
99:
100: OKC_UTIL.call_user_hook(x_return_status => x_return_status,
101: p_package_name => g_pkg_name,
102: p_procedure_name => l_api_name,
103: p_before_after => 'A');
104:

Line 282: OKC_UTIL.call_user_hook(x_return_status => x_return_status,

278: -- call BEFORE user hook
279: l_chrv_rec := p_chrv_rec;
280: g_chrv_rec := l_chrv_rec;
281:
282: OKC_UTIL.call_user_hook(x_return_status => x_return_status,
283: p_package_name => g_pkg_name,
284: p_procedure_name => l_api_name,
285: p_before_after => 'B');
286:

Line 320: OKC_UTIL.call_user_hook(x_return_status => x_return_status,

316:
317: -- call AFTER user hook
318: g_chrv_rec := x_chrv_rec;
319:
320: OKC_UTIL.call_user_hook(x_return_status => x_return_status,
321: p_package_name => g_pkg_name,
322: p_procedure_name => l_api_name,
323: p_before_after => 'A');
324:

Line 503: OKC_UTIL.call_user_hook(x_return_status => x_return_status,

499: -- call BEFORE user hook
500: l_chrv_rec := p_chrv_rec;
501: g_chrv_rec := l_chrv_rec;
502:
503: OKC_UTIL.call_user_hook(x_return_status => x_return_status,
504: p_package_name => g_pkg_name,
505: p_procedure_name => l_api_name,
506: p_before_after => 'B');
507:

Line 542: OKC_UTIL.call_user_hook(x_return_status => x_return_status,

538:
539: -- call AFTER user hook
540: g_chrv_rec := x_chrv_rec;
541:
542: OKC_UTIL.call_user_hook(x_return_status => x_return_status,
543: p_package_name => g_pkg_name,
544: p_procedure_name => l_api_name,
545: p_before_after => 'A');
546:

Line 724: OKC_UTIL.call_user_hook(x_return_status => x_return_status,

720: -- call BEFORE user hook
721: l_chrv_rec := p_chrv_rec;
722: g_chrv_rec := l_chrv_rec;
723:
724: OKC_UTIL.call_user_hook(x_return_status => x_return_status,
725: p_package_name => g_pkg_name,
726: p_procedure_name => l_api_name,
727: p_before_after => 'B');
728:

Line 757: OKC_UTIL.call_user_hook(x_return_status => x_return_status,

753: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
754: raise OKC_API.G_EXCEPTION_ERROR;
755: End If;
756:
757: OKC_UTIL.call_user_hook(x_return_status => x_return_status,
758: p_package_name => g_pkg_name,
759: p_procedure_name => l_api_name,
760: p_before_after => 'A');
761:

Line 933: OKC_UTIL.call_user_hook(x_return_status => x_return_status,

929: -- call BEFORE user hook
930: l_chrv_rec := p_chrv_rec;
931: g_chrv_rec := l_chrv_rec;
932:
933: OKC_UTIL.call_user_hook(x_return_status => x_return_status,
934: p_package_name => g_pkg_name,
935: p_procedure_name => l_api_name,
936: p_before_after => 'B');
937:

Line 966: OKC_UTIL.call_user_hook(x_return_status => x_return_status,

962: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
963: raise OKC_API.G_EXCEPTION_ERROR;
964: End If;
965:
966: OKC_UTIL.call_user_hook(x_return_status => x_return_status,
967: p_package_name => g_pkg_name,
968: p_procedure_name => l_api_name,
969: p_before_after => 'A');
970:

Line 1142: OKC_UTIL.call_user_hook(x_return_status => x_return_status,

1138: -- call BEFORE user hook
1139: l_chrv_rec := p_chrv_rec;
1140: g_chrv_rec := l_chrv_rec;
1141:
1142: OKC_UTIL.call_user_hook(x_return_status => x_return_status,
1143: p_package_name => g_pkg_name,
1144: p_procedure_name => l_api_name,
1145: p_before_after => 'B');
1146:

Line 1175: OKC_UTIL.call_user_hook(x_return_status => x_return_status,

1171: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
1172: raise OKC_API.G_EXCEPTION_ERROR;
1173: End If;
1174:
1175: OKC_UTIL.call_user_hook(x_return_status => x_return_status,
1176: p_package_name => g_pkg_name,
1177: p_procedure_name => l_api_name,
1178: p_before_after => 'A');
1179:

Line 1353: OKC_UTIL.call_user_hook(x_return_status => x_return_status,

1349: -- call BEFORE user hook
1350: l_clev_rec := p_clev_rec;
1351: g_clev_rec := l_clev_rec;
1352:
1353: OKC_UTIL.call_user_hook(x_return_status => x_return_status,
1354: p_package_name => g_pkg_name,
1355: p_procedure_name => l_api_name,
1356: p_before_after => 'B');
1357:

Line 1388: OKC_UTIL.call_user_hook(x_return_status => x_return_status,

1384: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
1385: raise OKC_API.G_EXCEPTION_ERROR;
1386: End If;
1387:
1388: OKC_UTIL.call_user_hook(x_return_status => x_return_status,
1389: p_package_name => g_pkg_name,
1390: p_procedure_name => l_api_name,
1391: p_before_after => 'A');
1392:

Line 1570: OKC_UTIL.call_user_hook(x_return_status => x_return_status,

1566: -- call BEFORE user hook
1567: l_clev_rec := p_clev_rec;
1568: g_clev_rec := l_clev_rec;
1569:
1570: OKC_UTIL.call_user_hook(x_return_status => x_return_status,
1571: p_package_name => g_pkg_name,
1572: p_procedure_name => l_api_name,
1573: p_before_after => 'B');
1574:

Line 1605: OKC_UTIL.call_user_hook(x_return_status => x_return_status,

1601: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
1602: raise OKC_API.G_EXCEPTION_ERROR;
1603: End If;
1604:
1605: OKC_UTIL.call_user_hook(x_return_status => x_return_status,
1606: p_package_name => g_pkg_name,
1607: p_procedure_name => l_api_name,
1608: p_before_after => 'A');
1609:

Line 1785: OKC_UTIL.call_user_hook(x_return_status => x_return_status,

1781: -- call BEFORE user hook
1782: l_clev_rec := p_clev_rec;
1783: g_clev_rec := l_clev_rec;
1784:
1785: OKC_UTIL.call_user_hook(x_return_status => x_return_status,
1786: p_package_name => g_pkg_name,
1787: p_procedure_name => l_api_name,
1788: p_before_after => 'B');
1789:

Line 1818: OKC_UTIL.call_user_hook(x_return_status => x_return_status,

1814: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
1815: raise OKC_API.G_EXCEPTION_ERROR;
1816: End If;
1817:
1818: OKC_UTIL.call_user_hook(x_return_status => x_return_status,
1819: p_package_name => g_pkg_name,
1820: p_procedure_name => l_api_name,
1821: p_before_after => 'A');
1822:

Line 2025: OKC_UTIL.call_user_hook(x_return_status => x_return_status,

2021: -- call BEFORE user hook
2022: l_clev_rec := p_clev_rec;
2023: g_clev_rec := l_clev_rec;
2024:
2025: OKC_UTIL.call_user_hook(x_return_status => x_return_status,
2026: p_package_name => g_pkg_name,
2027: p_procedure_name => l_api_name,
2028: p_before_after => 'B');
2029:

Line 2058: OKC_UTIL.call_user_hook(x_return_status => x_return_status,

2054: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
2055: raise OKC_API.G_EXCEPTION_ERROR;
2056: End If;
2057:
2058: OKC_UTIL.call_user_hook(x_return_status => x_return_status,
2059: p_package_name => g_pkg_name,
2060: p_procedure_name => l_api_name,
2061: p_before_after => 'A');
2062:

Line 2234: OKC_UTIL.call_user_hook(x_return_status => x_return_status,

2230: -- call BEFORE user hook
2231: l_clev_rec := p_clev_rec;
2232: g_clev_rec := l_clev_rec;
2233:
2234: OKC_UTIL.call_user_hook(x_return_status => x_return_status,
2235: p_package_name => g_pkg_name,
2236: p_procedure_name => l_api_name,
2237: p_before_after => 'B');
2238:

Line 2267: OKC_UTIL.call_user_hook(x_return_status => x_return_status,

2263: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
2264: raise OKC_API.G_EXCEPTION_ERROR;
2265: End If;
2266:
2267: OKC_UTIL.call_user_hook(x_return_status => x_return_status,
2268: p_package_name => g_pkg_name,
2269: p_procedure_name => l_api_name,
2270: p_before_after => 'A');
2271:

Line 2444: OKC_UTIL.call_user_hook(x_return_status => x_return_status,

2440: -- call BEFORE user hook
2441: l_gvev_rec := p_gvev_rec;
2442: g_gvev_rec := l_gvev_rec;
2443:
2444: OKC_UTIL.call_user_hook(x_return_status => x_return_status,
2445: p_package_name => g_pkg_name,
2446: p_procedure_name => l_api_name,
2447: p_before_after => 'B');
2448:

Line 2478: OKC_UTIL.call_user_hook(x_return_status => x_return_status,

2474: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
2475: raise OKC_API.G_EXCEPTION_ERROR;
2476: End If;
2477:
2478: OKC_UTIL.call_user_hook(x_return_status => x_return_status,
2479: p_package_name => g_pkg_name,
2480: p_procedure_name => l_api_name,
2481: p_before_after => 'A');
2482:

Line 2657: OKC_UTIL.call_user_hook(x_return_status => x_return_status,

2653: -- call BEFORE user hook
2654: l_gvev_rec := p_gvev_rec;
2655: g_gvev_rec := l_gvev_rec;
2656:
2657: OKC_UTIL.call_user_hook(x_return_status => x_return_status,
2658: p_package_name => g_pkg_name,
2659: p_procedure_name => l_api_name,
2660: p_before_after => 'B');
2661:

Line 2691: OKC_UTIL.call_user_hook(x_return_status => x_return_status,

2687: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
2688: raise OKC_API.G_EXCEPTION_ERROR;
2689: End If;
2690:
2691: OKC_UTIL.call_user_hook(x_return_status => x_return_status,
2692: p_package_name => g_pkg_name,
2693: p_procedure_name => l_api_name,
2694: p_before_after => 'A');
2695:

Line 2869: OKC_UTIL.call_user_hook(x_return_status => x_return_status,

2865: -- call BEFORE user hook
2866: l_gvev_rec := p_gvev_rec;
2867: g_gvev_rec := l_gvev_rec;
2868:
2869: OKC_UTIL.call_user_hook(x_return_status => x_return_status,
2870: p_package_name => g_pkg_name,
2871: p_procedure_name => l_api_name,
2872: p_before_after => 'B');
2873:

Line 2902: OKC_UTIL.call_user_hook(x_return_status => x_return_status,

2898: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
2899: raise OKC_API.G_EXCEPTION_ERROR;
2900: End If;
2901:
2902: OKC_UTIL.call_user_hook(x_return_status => x_return_status,
2903: p_package_name => g_pkg_name,
2904: p_procedure_name => l_api_name,
2905: p_before_after => 'A');
2906:

Line 3078: OKC_UTIL.call_user_hook(x_return_status => x_return_status,

3074: -- call BEFORE user hook
3075: l_gvev_rec := p_gvev_rec;
3076: g_gvev_rec := l_gvev_rec;
3077:
3078: OKC_UTIL.call_user_hook(x_return_status => x_return_status,
3079: p_package_name => g_pkg_name,
3080: p_procedure_name => l_api_name,
3081: p_before_after => 'B');
3082:

Line 3111: OKC_UTIL.call_user_hook(x_return_status => x_return_status,

3107: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
3108: raise OKC_API.G_EXCEPTION_ERROR;
3109: End If;
3110:
3111: OKC_UTIL.call_user_hook(x_return_status => x_return_status,
3112: p_package_name => g_pkg_name,
3113: p_procedure_name => l_api_name,
3114: p_before_after => 'A');
3115:

Line 3287: OKC_UTIL.call_user_hook(x_return_status => x_return_status,

3283: -- call BEFORE user hook
3284: l_gvev_rec := p_gvev_rec;
3285: g_gvev_rec := l_gvev_rec;
3286:
3287: OKC_UTIL.call_user_hook(x_return_status => x_return_status,
3288: p_package_name => g_pkg_name,
3289: p_procedure_name => l_api_name,
3290: p_before_after => 'B');
3291:

Line 3320: OKC_UTIL.call_user_hook(x_return_status => x_return_status,

3316: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
3317: raise OKC_API.G_EXCEPTION_ERROR;
3318: End If;
3319:
3320: OKC_UTIL.call_user_hook(x_return_status => x_return_status,
3321: p_package_name => g_pkg_name,
3322: p_procedure_name => l_api_name,
3323: p_before_after => 'A');
3324:

Line 3497: OKC_UTIL.call_user_hook(x_return_status => x_return_status,

3493: -- call BEFORE user hook
3494: l_cpsv_rec := p_cpsv_rec;
3495: g_cpsv_rec := l_cpsv_rec;
3496:
3497: OKC_UTIL.call_user_hook(x_return_status => x_return_status,
3498: p_package_name => g_pkg_name,
3499: p_procedure_name => l_api_name,
3500: p_before_after => 'B');
3501:

Line 3531: OKC_UTIL.call_user_hook(x_return_status => x_return_status,

3527: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
3528: raise OKC_API.G_EXCEPTION_ERROR;
3529: End If;
3530:
3531: OKC_UTIL.call_user_hook(x_return_status => x_return_status,
3532: p_package_name => g_pkg_name,
3533: p_procedure_name => l_api_name,
3534: p_before_after => 'A');
3535:

Line 3710: OKC_UTIL.call_user_hook(x_return_status => x_return_status,

3706: -- call BEFORE user hook
3707: l_cpsv_rec := p_cpsv_rec;
3708: g_cpsv_rec := l_cpsv_rec;
3709:
3710: OKC_UTIL.call_user_hook(x_return_status => x_return_status,
3711: p_package_name => g_pkg_name,
3712: p_procedure_name => l_api_name,
3713: p_before_after => 'B');
3714:

Line 3744: OKC_UTIL.call_user_hook(x_return_status => x_return_status,

3740: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
3741: raise OKC_API.G_EXCEPTION_ERROR;
3742: End If;
3743:
3744: OKC_UTIL.call_user_hook(x_return_status => x_return_status,
3745: p_package_name => g_pkg_name,
3746: p_procedure_name => l_api_name,
3747: p_before_after => 'A');
3748:

Line 3922: OKC_UTIL.call_user_hook(x_return_status => x_return_status,

3918: -- call BEFORE user hook
3919: l_cpsv_rec := p_cpsv_rec;
3920: g_cpsv_rec := l_cpsv_rec;
3921:
3922: OKC_UTIL.call_user_hook(x_return_status => x_return_status,
3923: p_package_name => g_pkg_name,
3924: p_procedure_name => l_api_name,
3925: p_before_after => 'B');
3926:

Line 3955: OKC_UTIL.call_user_hook(x_return_status => x_return_status,

3951: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
3952: raise OKC_API.G_EXCEPTION_ERROR;
3953: End If;
3954:
3955: OKC_UTIL.call_user_hook(x_return_status => x_return_status,
3956: p_package_name => g_pkg_name,
3957: p_procedure_name => l_api_name,
3958: p_before_after => 'A');
3959:

Line 4131: OKC_UTIL.call_user_hook(x_return_status => x_return_status,

4127: -- call BEFORE user hook
4128: l_cpsv_rec := p_cpsv_rec;
4129: g_cpsv_rec := l_cpsv_rec;
4130:
4131: OKC_UTIL.call_user_hook(x_return_status => x_return_status,
4132: p_package_name => g_pkg_name,
4133: p_procedure_name => l_api_name,
4134: p_before_after => 'B');
4135:

Line 4164: OKC_UTIL.call_user_hook(x_return_status => x_return_status,

4160: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
4161: raise OKC_API.G_EXCEPTION_ERROR;
4162: End If;
4163:
4164: OKC_UTIL.call_user_hook(x_return_status => x_return_status,
4165: p_package_name => g_pkg_name,
4166: p_procedure_name => l_api_name,
4167: p_before_after => 'A');
4168:

Line 4340: OKC_UTIL.call_user_hook(x_return_status => x_return_status,

4336: -- call BEFORE user hook
4337: l_cpsv_rec := p_cpsv_rec;
4338: g_cpsv_rec := l_cpsv_rec;
4339:
4340: OKC_UTIL.call_user_hook(x_return_status => x_return_status,
4341: p_package_name => g_pkg_name,
4342: p_procedure_name => l_api_name,
4343: p_before_after => 'B');
4344:

Line 4373: OKC_UTIL.call_user_hook(x_return_status => x_return_status,

4369: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
4370: raise OKC_API.G_EXCEPTION_ERROR;
4371: End If;
4372:
4373: OKC_UTIL.call_user_hook(x_return_status => x_return_status,
4374: p_package_name => g_pkg_name,
4375: p_procedure_name => l_api_name,
4376: p_before_after => 'A');
4377:

Line 4550: OKC_UTIL.call_user_hook(x_return_status => x_return_status,

4546: -- call BEFORE user hook
4547: l_cacv_rec := p_cacv_rec;
4548: g_cacv_rec := l_cacv_rec;
4549:
4550: OKC_UTIL.call_user_hook(x_return_status => x_return_status,
4551: p_package_name => g_pkg_name,
4552: p_procedure_name => l_api_name,
4553: p_before_after => 'B');
4554:

Line 4584: OKC_UTIL.call_user_hook(x_return_status => x_return_status,

4580: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
4581: raise OKC_API.G_EXCEPTION_ERROR;
4582: End If;
4583:
4584: OKC_UTIL.call_user_hook(x_return_status => x_return_status,
4585: p_package_name => g_pkg_name,
4586: p_procedure_name => l_api_name,
4587: p_before_after => 'A');
4588:

Line 4763: OKC_UTIL.call_user_hook(x_return_status => x_return_status,

4759: -- call BEFORE user hook
4760: l_cacv_rec := p_cacv_rec;
4761: g_cacv_rec := l_cacv_rec;
4762:
4763: OKC_UTIL.call_user_hook(x_return_status => x_return_status,
4764: p_package_name => g_pkg_name,
4765: p_procedure_name => l_api_name,
4766: p_before_after => 'B');
4767:

Line 4797: OKC_UTIL.call_user_hook(x_return_status => x_return_status,

4793: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
4794: raise OKC_API.G_EXCEPTION_ERROR;
4795: End If;
4796:
4797: OKC_UTIL.call_user_hook(x_return_status => x_return_status,
4798: p_package_name => g_pkg_name,
4799: p_procedure_name => l_api_name,
4800: p_before_after => 'A');
4801:

Line 4975: OKC_UTIL.call_user_hook(x_return_status => x_return_status,

4971: -- call BEFORE user hook
4972: l_cacv_rec := p_cacv_rec;
4973: g_cacv_rec := l_cacv_rec;
4974:
4975: OKC_UTIL.call_user_hook(x_return_status => x_return_status,
4976: p_package_name => g_pkg_name,
4977: p_procedure_name => l_api_name,
4978: p_before_after => 'B');
4979:

Line 5008: OKC_UTIL.call_user_hook(x_return_status => x_return_status,

5004: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
5005: raise OKC_API.G_EXCEPTION_ERROR;
5006: End If;
5007:
5008: OKC_UTIL.call_user_hook(x_return_status => x_return_status,
5009: p_package_name => g_pkg_name,
5010: p_procedure_name => l_api_name,
5011: p_before_after => 'A');
5012:

Line 5184: OKC_UTIL.call_user_hook(x_return_status => x_return_status,

5180: -- call BEFORE user hook
5181: l_cacv_rec := p_cacv_rec;
5182: g_cacv_rec := l_cacv_rec;
5183:
5184: OKC_UTIL.call_user_hook(x_return_status => x_return_status,
5185: p_package_name => g_pkg_name,
5186: p_procedure_name => l_api_name,
5187: p_before_after => 'B');
5188:

Line 5217: OKC_UTIL.call_user_hook(x_return_status => x_return_status,

5213: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
5214: raise OKC_API.G_EXCEPTION_ERROR;
5215: End If;
5216:
5217: OKC_UTIL.call_user_hook(x_return_status => x_return_status,
5218: p_package_name => g_pkg_name,
5219: p_procedure_name => l_api_name,
5220: p_before_after => 'A');
5221:

Line 5393: OKC_UTIL.call_user_hook(x_return_status => x_return_status,

5389: -- call BEFORE user hook
5390: l_cacv_rec := p_cacv_rec;
5391: g_cacv_rec := l_cacv_rec;
5392:
5393: OKC_UTIL.call_user_hook(x_return_status => x_return_status,
5394: p_package_name => g_pkg_name,
5395: p_procedure_name => l_api_name,
5396: p_before_after => 'B');
5397:

Line 5426: OKC_UTIL.call_user_hook(x_return_status => x_return_status,

5422: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
5423: raise OKC_API.G_EXCEPTION_ERROR;
5424: End If;
5425:
5426: OKC_UTIL.call_user_hook(x_return_status => x_return_status,
5427: p_package_name => g_pkg_name,
5428: p_procedure_name => l_api_name,
5429: p_before_after => 'A');
5430: