[Home] [Help]
1: package body OTA_GENERAL as
2: /* $Header: otgenral.pkb 120.3 2005/07/20 01:03:03 dbatra noship $ */
3: /*
4: ===========================================================================
5: | Copyright (c) 1996 Oracle Corporation |
38: 115.10 10-JUL-01 D HMulia Added Function get_finance.
39: 115.11 12-Mar-02 A Sud Bug 2256328. Modified the length
40: of variables for Organization name
41: and training center.
42: 115.12 26-Oct-02 J Bharath Enh 253086 - Modified the ota_general.check_current_employee
43: cursor(c_current_employee) query to support PTU for CWK.
44: 115.15 29-Nov-02 Jbharath Bug#2684733 NOCOPY added for IN OUT/OUT arguments of procedure
45: 115.16 11-Dec-02 Arkashya Bug#2705857 Removed the debug routines eg.set_location as a part
46: debug performance changes.Package classified as R11.5.9 category A.
55: */
56:
57: -- Global package name
58: --
59: g_package varchar2(33) := ' ota_general.';
60: g_dummy number (1);
61: --
62: --------------------------------------------------------------------------------
63: --
1068: AND ori.org_information_context = 'CLASS'
1069: AND ori.org_information1 ='OTA_TC';
1070:
1071: BEGIN
1072: l_business_group_id := OTA_GENERAL.get_business_group_id;
1073: For a in c_get_training_center
1074: loop
1075: l_training_center := a.name;
1076: end loop;
1220: IS
1221: CURSOR csr_get_legislation_code IS
1222: SELECT PBG.legislation_code
1223: FROM per_business_groups PBG
1224: WHERE PBG.business_group_id = ota_general.get_business_group_id;
1225:
1226: l_legislation_code per_business_groups.legislation_code%TYPE;
1227: BEGIN
1228: OPEN csr_get_legislation_code;
1231:
1232: RETURN l_legislation_code;
1233:
1234: END get_legislation_code;
1235: end OTA_GENERAL;