DBA Data[Home] [Help]

APPS.AP_UTILITIES_PKG dependencies on MO_GLOBAL

Line 400: mo_global.get_current_org_id) return varchar2

396: -- function to return the correct period.
397:
398: function get_current_gl_date (P_Date IN date,
399: P_Org_ID IN number default
400: mo_global.get_current_org_id) return varchar2
401: is
402: cursor l_current_cursor is
403: SELECT period_name
404: FROM gl_period_statuses GLPS,

Line 487: mo_global.get_current_org_id) return varchar2

483: -- returns the period name of the P_Date.
484: -----------------------------------------------------------------------
485: function get_gl_period_name (P_Date IN date,
486: P_Org_ID IN NUMBER DEFAULT
487: mo_global.get_current_org_id) return varchar2
488: is
489: cursor l_current_cursor is
490: SELECT period_name
491: FROM gl_period_statuses GLPS,

Line 527: mo_global.get_current_org_id)

523: (P_Date IN date
524: ,P_Period_Name OUT NOCOPY varchar2
525: ,P_GL_Date OUT NOCOPY date
526: ,P_Org_Id IN number DEFAULT
527: mo_global.get_current_org_id)
528: is
529: cursor l_open_cursor is
530: SELECT MIN(start_date),
531: period_name

Line 629: mo_global.get_current_org_id)

625: (P_Date IN date
626: ,P_Period_Name OUT NOCOPY varchar2
627: ,P_GL_Date OUT NOCOPY date
628: ,P_Org_Id IN number DEFAULT
629: mo_global.get_current_org_id)
630: is
631: cursor l_open_cursor is
632: SELECT MIN(start_date),
633: period_name

Line 1816: FUNCTION Get_Inventory_Org(P_org_id Number default mo_global.get_current_org_id) return NUMBER IS

1812:
1813: -- MO Access Control: Added the parameter p_org_id.
1814: -- including default to the current_org_id
1815:
1816: FUNCTION Get_Inventory_Org(P_org_id Number default mo_global.get_current_org_id) return NUMBER IS
1817: inv_org_id financials_system_parameters.inventory_organization_id%TYPE;
1818: BEGIN
1819:
1820: select inventory_organization_id

Line 3328: mo_global.get_current_org_id) RETURN varchar2 IS

3324:
3325: FUNCTION pa_period_status(
3326: p_gl_date IN DATE,
3327: p_org_id IN number default
3328: mo_global.get_current_org_id) RETURN varchar2 IS
3329:
3330: CURSOR c_closing_status IS
3331: SELECT GLPS.closing_status
3332: FROM gl_period_statuses GLPS,

Line 3857: MO_GLOBAL.GET_CURRENT_ORG_ID)

3853: P_Period_Name OUT NOCOPY VARCHAR2,
3854: P_GL_Date OUT NOCOPY DATE,
3855: P_Batch_GL_Date IN DATE DEFAULT NULL,
3856: P_Org_Id IN NUMBER DEFAULT
3857: MO_GLOBAL.GET_CURRENT_ORG_ID)
3858: IS
3859: l_period_name gl_period_statuses.period_name%TYPE := '';
3860: l_current_date date := '';
3861: l_gl_date date := '';

Line 3925: mo_global.get_current_org_id) return varchar2

3921: -- Added for bug 8408345.
3922:
3923: function get_current_gl_date_no_cache (P_Date IN date,
3924: P_Org_ID IN number default
3925: mo_global.get_current_org_id) return varchar2
3926: is
3927: cursor l_current_cursor is
3928: SELECT period_name
3929: FROM gl_period_statuses GLPS,

Line 3965: mo_global.get_current_org_id)

3961: (P_Date IN date
3962: ,P_Period_Name OUT NOCOPY varchar2
3963: ,P_GL_Date OUT NOCOPY date
3964: ,P_Org_Id IN number DEFAULT
3965: mo_global.get_current_org_id)
3966: is
3967: cursor l_open_cursor is
3968: SELECT MIN(start_date),
3969: period_name