DBA Data[Home] [Help]

APPS.GMF_LEGAL_ENTITY_TZ dependencies on XLE_LE_TIMEZONE_GRP

Line 32: RETURN (XLE_LE_TIMEZONE_GRP.Get_Le_Tz_Code_For_Ou(p_ou_id));

28: RETURN VARCHAR2
29: IS
30: BEGIN
31: IF p_ou_id IS NOT NULL THEN
32: RETURN (XLE_LE_TIMEZONE_GRP.Get_Le_Tz_Code_For_Ou(p_ou_id));
33: ELSE
34: RETURN (NULL);
35: END IF;
36: END get_timezone_code;

Line 83: l_timezone_code := XLE_LE_TIMEZONE_GRP.Get_Le_Tz_Code_For_Inv_Org(p_inv_org_id => l_organization_id);

79: OPEN cur_get_inv_org_id (p_le_id) ;
80: FETCH cur_get_inv_org_id INTO l_organization_id;
81: CLOSE cur_get_inv_org_id ;
82: IF l_organization_id IS NOT NULL THEN
83: l_timezone_code := XLE_LE_TIMEZONE_GRP.Get_Le_Tz_Code_For_Inv_Org(p_inv_org_id => l_organization_id);
84: RETURN (l_timezone_code);
85: ELSE
86: RETURN (NULL);
87: END IF;

Line 182: RETURN (XLE_LE_TIMEZONE_GRP.Get_Le_Day_Time_For_OU(pdate, l_ou_id));

178: THEN
179: OPEN cur_get_ou (pco_code);
180: FETCH cur_get_ou INTO l_ou_id;
181: CLOSE cur_get_ou;
182: RETURN (XLE_LE_TIMEZONE_GRP.Get_Le_Day_Time_For_OU(pdate, l_ou_id));
183: ELSE
184: RETURN (pdate);
185: END IF;
186: END convert_srv_to_le;

Line 218: RETURN (XLE_LE_TIMEZONE_GRP.Get_Le_Day_For_Server(pdate, ple_id));

214: FUNCTION convert_srv_to_le (ple_id IN NUMBER, pdate IN DATE)
215: RETURN DATE
216: IS
217: BEGIN
218: RETURN (XLE_LE_TIMEZONE_GRP.Get_Le_Day_For_Server(pdate, ple_id));
219: END convert_srv_to_le;
220:
221: /*===========================================================================+
222: | Function |

Line 296: RETURN (XLE_LE_TIMEZONE_GRP.Get_Server_Day_Time_For_Le(p_le_date, ple_id));

292: FUNCTION convert_le_to_srv_tz (p_le_date IN DATE, ple_id IN NUMBER)
293: RETURN DATE
294: IS
295: BEGIN
296: RETURN (XLE_LE_TIMEZONE_GRP.Get_Server_Day_Time_For_Le(p_le_date, ple_id));
297: END convert_le_to_srv_tz;
298: END gmf_legal_entity_tz;