[Home] [Help]
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,
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,
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
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
1808:
1809: -- MO Access Control: Added the parameter p_org_id.
1810: -- including default to the current_org_id
1811:
1812: FUNCTION Get_Inventory_Org(P_org_id Number default mo_global.get_current_org_id) return NUMBER IS
1813: inv_org_id financials_system_parameters.inventory_organization_id%TYPE;
1814: BEGIN
1815:
1816: select inventory_organization_id
3294:
3295: FUNCTION pa_period_status(
3296: p_gl_date IN DATE,
3297: p_org_id IN number default
3298: mo_global.get_current_org_id) RETURN varchar2 IS
3299:
3300: CURSOR c_closing_status IS
3301: SELECT GLPS.closing_status
3302: FROM gl_period_statuses GLPS,