112: --| ----------------------------------------------------------------------+
113: --| Function Name : get_period_name -- only get active periods
114: --| ----------------------------------------------------------------------+
115: FUNCTION get_period_name( p_period_id NUMBER, p_org_id NUMBER)
116: RETURN cn_periods.period_name%TYPE IS
117:
118: l_period_name cn_periods.period_name%TYPE;
119:
120: BEGIN
114: --| ----------------------------------------------------------------------+
115: FUNCTION get_period_name( p_period_id NUMBER, p_org_id NUMBER)
116: RETURN cn_periods.period_name%TYPE IS
117:
118: l_period_name cn_periods.period_name%TYPE;
119:
120: BEGIN
121: SELECT period_name
122: INTO l_period_name
135: --| ----------------------------------------------------------------------+
136: --| Function Name : get_period_id -- only get active periods
137: --| ----------------------------------------------------------------------+
138: FUNCTION get_period_id( p_period_name VARCHAR2, p_org_id NUMBER)
139: RETURN cn_periods.period_id%TYPE IS
140:
141: l_period_id cn_periods.period_id%TYPE;
142:
143: BEGIN
137: --| ----------------------------------------------------------------------+
138: FUNCTION get_period_id( p_period_name VARCHAR2, p_org_id NUMBER)
139: RETURN cn_periods.period_id%TYPE IS
140:
141: l_period_id cn_periods.period_id%TYPE;
142:
143: BEGIN
144: SELECT period_id
145: INTO l_period_id
1539: --| -----------------------------------------------------------------------=
1540: --| Function Name : get_acc_period_id -- only get active periods
1541: --| ---------------------------------------------------------------------=
1542: FUNCTION get_acc_period_id( p_period_name VARCHAR2, p_org_id NUMBER)
1543: RETURN cn_periods.period_id%TYPE IS
1544:
1545: l_period_id cn_periods.period_id%TYPE;
1546:
1547: BEGIN
1541: --| ---------------------------------------------------------------------=
1542: FUNCTION get_acc_period_id( p_period_name VARCHAR2, p_org_id NUMBER)
1543: RETURN cn_periods.period_id%TYPE IS
1544:
1545: l_period_id cn_periods.period_id%TYPE;
1546:
1547: BEGIN
1548: SELECT period_id
1549: INTO l_period_id
1561: --| -----------------------------------------------------------------------=
1562: --| Function Name : get_acc_period_name -- only get active periods
1563: --| ---------------------------------------------------------------------=
1564: FUNCTION get_acc_period_name( p_period_id NUMBER, p_org_id NUMBER)
1565: RETURN cn_periods.period_name%TYPE IS
1566:
1567: l_period_name cn_periods.period_name%TYPE;
1568:
1569: BEGIN
1563: --| ---------------------------------------------------------------------=
1564: FUNCTION get_acc_period_name( p_period_id NUMBER, p_org_id NUMBER)
1565: RETURN cn_periods.period_name%TYPE IS
1566:
1567: l_period_name cn_periods.period_name%TYPE;
1568:
1569: BEGIN
1570: SELECT period_name
1571: INTO l_period_name