APPS.XLE_LE_TIMEZONE_GRP dependencies on XLE_ENTITY_PROFILES

Line 58: l_legal_entity_id XLE_ENTITY_PROFILES.LEGAL_ENTITY_ID%TYPE;

54: /* Local Variable */
55: l_ou_le_info XLE_BUSINESSINFO_GRP.OU_LE_Tbl_Type;
56: l_le_info XLE_UTILITIES_GRP.LegalEntity_Rec;
57: l_inv_le_info XLE_BUSINESSINFO_GRP.Inv_Org_Rec_Type;
58: l_legal_entity_id XLE_ENTITY_PROFILES.LEGAL_ENTITY_ID%TYPE;
59: l_return_status VARCHAR2(30) ;
60: l_msg_count NUMBER ;
61: l_msg_data VARCHAR2(2000) ;
62:

Line 157: p_legalentity_id IN XLE_ENTITY_PROFILES.legal_entity_id%TYPE,

153: p_commit IN VARCHAR2 := FND_API.G_FALSE,
154: x_return_status OUT NOCOPY VARCHAR2,
155: x_msg_count OUT NOCOPY NUMBER,
156: x_msg_data OUT NOCOPY VARCHAR2,
157: p_legalentity_id IN XLE_ENTITY_PROFILES.legal_entity_id%TYPE,
158: x_timezone_code OUT NOCOPY VARCHAR2,
159: x_timezone_id OUT NOCOPY NUMBER
160: )
161: IS

Line 181: FROM XLE_ENTITY_PROFILES xlep,

177: SELECT hrl.timezone_code ,
178: ftb.upgrade_tz_id
179: INTO x_timezone_code,
180: x_timezone_id
181: FROM XLE_ENTITY_PROFILES xlep,
182: XLE_REGISTRATIONS reg,
183: HR_LOCATIONS_ALL hrl,
184: fnd_timezones_b ftb
185: WHERE xlep.legal_entity_id = reg.source_id

Line 186: AND reg.source_table = 'XLE_ENTITY_PROFILES'

182: XLE_REGISTRATIONS reg,
183: HR_LOCATIONS_ALL hrl,
184: fnd_timezones_b ftb
185: WHERE xlep.legal_entity_id = reg.source_id
186: AND reg.source_table = 'XLE_ENTITY_PROFILES'
187: AND reg.identifying_flag = 'Y'
188: AND nvl(reg.effective_from,sysdate) <= sysdate
189: AND nvl(reg.effective_to, sysdate) >= sysdate
190: AND reg.location_id = hrl.location_id

Line 253: l_legal_entity_id XLE_ENTITY_PROFILES.LEGAL_ENTITY_ID%TYPE;

249: l_msg_data VARCHAR2(2000) ;
250: l_return_status1 VARCHAR2(30) ;
251: l_msg_count1 NUMBER ;
252: l_msg_data1 VARCHAR2(2000) ;
253: l_legal_entity_id XLE_ENTITY_PROFILES.LEGAL_ENTITY_ID%TYPE;
254:
255: BEGIN
256:
257: -- check if Legal Entity Timezone is enabled and p_ou_id is NOT NULL

Line 374: l_legal_entity_id XLE_ENTITY_PROFILES.LEGAL_ENTITY_ID%TYPE;

370: l_msg_data VARCHAR2(2000) ;
371: l_return_status1 VARCHAR2(30) ;
372: l_msg_count1 NUMBER ;
373: l_msg_data1 VARCHAR2(2000) ;
374: l_legal_entity_id XLE_ENTITY_PROFILES.LEGAL_ENTITY_ID%TYPE;
375:
376: BEGIN
377:
378: -- check if Legal Entity Timezone is enabled and p_inv_org_id is NOT NULL

Line 500: l_legal_entity_id XLE_ENTITY_PROFILES.LEGAL_ENTITY_ID%TYPE;

496: l_msg_data VARCHAR2(2000) ;
497: l_return_status1 VARCHAR2(30) ;
498: l_msg_count1 NUMBER ;
499: l_msg_data1 VARCHAR2(2000) ;
500: l_legal_entity_id XLE_ENTITY_PROFILES.LEGAL_ENTITY_ID%TYPE;
501:
502: BEGIN
503:
504: -- check if Legal Entity Timezone is enabled and p_inv_org_id is NOT NULL

Line 667: l_legal_entity_id XLE_ENTITY_PROFILES.LEGAL_ENTITY_ID%TYPE;

663: l_msg_data VARCHAR2(2000) ;
664: l_return_status1 VARCHAR2(30) ;
665: l_msg_count1 NUMBER ;
666: l_msg_data1 VARCHAR2(2000) ;
667: l_legal_entity_id XLE_ENTITY_PROFILES.LEGAL_ENTITY_ID%TYPE;
668:
669: BEGIN
670:
671: -- check if Legal Entity Timezone is enabled and p_ou_id is NOT NULL

Line 783: l_legal_entity_id XLE_ENTITY_PROFILES.LEGAL_ENTITY_ID%TYPE;

779: l_timezone_id NUMBER := NULL;
780: l_return_status VARCHAR2(30) ;
781: l_msg_count NUMBER ;
782: l_msg_data VARCHAR2(2000) ;
783: l_legal_entity_id XLE_ENTITY_PROFILES.LEGAL_ENTITY_ID%TYPE;
784:
785: BEGIN
786:
787: -- check if Legal Entity Timezone is enabled and p_inv_org_id IS NOT NULL

Line 869: l_legal_entity_id XLE_ENTITY_PROFILES.LEGAL_ENTITY_ID%TYPE;

865: l_timezone_id NUMBER := NULL;
866: l_return_status VARCHAR2(30) ;
867: l_msg_count NUMBER ;
868: l_msg_data VARCHAR2(2000) ;
869: l_legal_entity_id XLE_ENTITY_PROFILES.LEGAL_ENTITY_ID%TYPE;
870:
871: BEGIN
872:
873: -- check if Legal Entity Timezone is enabled AND p_ou_id IS NOT NULL

Line 961: l_legal_entity_id XLE_ENTITY_PROFILES.LEGAL_ENTITY_ID%TYPE;

957: l_msg_data VARCHAR2(2000) ;
958: l_return_status1 VARCHAR2(30) ;
959: l_msg_count1 NUMBER ;
960: l_msg_data1 VARCHAR2(2000) ;
961: l_legal_entity_id XLE_ENTITY_PROFILES.LEGAL_ENTITY_ID%TYPE;
962:
963: BEGIN
964:
965: -- check if Legal Entity Timezone is enabled AND p_le_id IS NOT NULL

Line 1086: l_legal_entity_id XLE_ENTITY_PROFILES.LEGAL_ENTITY_ID%TYPE;

1082: l_msg_data VARCHAR2(2000) ;
1083: l_return_status1 VARCHAR2(30) ;
1084: l_msg_count1 NUMBER ;
1085: l_msg_data1 VARCHAR2(2000) ;
1086: l_legal_entity_id XLE_ENTITY_PROFILES.LEGAL_ENTITY_ID%TYPE;
1087:
1088: BEGIN
1089:
1090: -- check if Legal Entity Timezone is enabled AND p_le_id is NOT NULL

Line 1209: l_legal_entity_id XLE_ENTITY_PROFILES.LEGAL_ENTITY_ID%TYPE;

1205: l_msg_data VARCHAR2(2000) ;
1206: l_return_status1 VARCHAR2(30) ;
1207: l_msg_count1 NUMBER ;
1208: l_msg_data1 VARCHAR2(2000) ;
1209: l_legal_entity_id XLE_ENTITY_PROFILES.LEGAL_ENTITY_ID%TYPE;
1210:
1211: BEGIN
1212:
1213: -- check if Legal Entity Timezone is enabled AND p_le_id is NOT NULL