90: --| ----------------------------------------------------------------------+
91: --| Function Name : get_period_name -- only get active periods
92: --| ----------------------------------------------------------------------+
93: FUNCTION get_period_name( p_period_id NUMBER, p_org_id NUMBER)
94: RETURN cn_periods.period_name%TYPE IS
95:
96: l_period_name cn_periods.period_name%TYPE;
97:
98: BEGIN
92: --| ----------------------------------------------------------------------+
93: FUNCTION get_period_name( p_period_id NUMBER, p_org_id NUMBER)
94: RETURN cn_periods.period_name%TYPE IS
95:
96: l_period_name cn_periods.period_name%TYPE;
97:
98: BEGIN
99: SELECT period_name
100: INTO l_period_name
113: --| ----------------------------------------------------------------------+
114: --| Function Name : get_period_id -- only get active periods
115: --| ----------------------------------------------------------------------+
116: FUNCTION get_period_id( p_period_name VARCHAR2, p_org_id NUMBER)
117: RETURN cn_periods.period_id%TYPE IS
118:
119: l_period_id cn_periods.period_id%TYPE;
120:
121: BEGIN
115: --| ----------------------------------------------------------------------+
116: FUNCTION get_period_id( p_period_name VARCHAR2, p_org_id NUMBER)
117: RETURN cn_periods.period_id%TYPE IS
118:
119: l_period_id cn_periods.period_id%TYPE;
120:
121: BEGIN
122: SELECT period_id
123: INTO l_period_id
1517: --| -----------------------------------------------------------------------=
1518: --| Function Name : get_acc_period_id -- only get active periods
1519: --| ---------------------------------------------------------------------=
1520: FUNCTION get_acc_period_id( p_period_name VARCHAR2, p_org_id NUMBER)
1521: RETURN cn_periods.period_id%TYPE IS
1522:
1523: l_period_id cn_periods.period_id%TYPE;
1524:
1525: BEGIN
1519: --| ---------------------------------------------------------------------=
1520: FUNCTION get_acc_period_id( p_period_name VARCHAR2, p_org_id NUMBER)
1521: RETURN cn_periods.period_id%TYPE IS
1522:
1523: l_period_id cn_periods.period_id%TYPE;
1524:
1525: BEGIN
1526: SELECT period_id
1527: INTO l_period_id
1539: --| -----------------------------------------------------------------------=
1540: --| Function Name : get_acc_period_name -- only get active periods
1541: --| ---------------------------------------------------------------------=
1542: FUNCTION get_acc_period_name( p_period_id NUMBER, p_org_id NUMBER)
1543: RETURN cn_periods.period_name%TYPE IS
1544:
1545: l_period_name cn_periods.period_name%TYPE;
1546:
1547: BEGIN
1541: --| ---------------------------------------------------------------------=
1542: FUNCTION get_acc_period_name( p_period_id NUMBER, p_org_id NUMBER)
1543: RETURN cn_periods.period_name%TYPE IS
1544:
1545: l_period_name cn_periods.period_name%TYPE;
1546:
1547: BEGIN
1548: SELECT period_name
1549: INTO l_period_name