[Home] [Help]
571: x_period_name
572: , x_period_start_date
573: , x_period_end_date
574: FROM
575: gl_periods glp
576: , org_acct_periods orgp
577: WHERE glp.period_name = orgp.period_name
578: AND glp.period_set_name = p_period_set_name
579: AND glp.period_type = p_period_type
716: x_period_name
717: , x_period_start_date
718: , x_period_end_date
719: FROM
720: gl_periods glp
721: , org_acct_periods orgp
722: WHERE glp.period_name = orgp.period_name
723: AND glp.period_set_name = p_period_set_name
724: AND glp.period_type = p_period_type
924: FROM
925: HR_organization_units
926: WHERE ORGANIZATION_ID = c_org_id;
927:
928: -- Select the periods from GL_PERIODS
929: -- that are eligible to be
930: -- opened for a given Org
931:
932: CURSOR c_gl_period_future(c_org_id NUMBER) IS
938: , glp.PERIOD_TYPE acct_period_type
939: , glp.PERIOD_YEAR open_period_year
940: , glp.PERIOD_NUM open_period_num
941: FROM
942: GL_PERIODS glp
943: WHERE glp.ADJUSTMENT_PERIOD_FLAG = 'N'
944: AND glp.period_type = l_sob_period_type
945: AND glp.PERIOD_SET_NAME = l_period_set_name
946: AND glp.PERIOD_NAME NOT IN
956:
957: l_gl_period_future c_gl_period_future%ROWTYPE ;
958:
959:
960: -- Select the periods from GL_PERIODS
961: -- that are eligible to be
962: -- Closed for a given Org
963:
964: CURSOR c_org_acct_periods_open IS
1034: -- The API's return status details the process outcome , which is
1035: -- inserted into the PL/SQL table and later printed as Log report
1036:
1037: -- The periods for Closing are selected from the ORG_ACCT_PERIODS
1038: -- and the periods to Open are retreived from GL_PERIODS
1039:
1040: G_LOG_REPORT_TABLE.DELETE ;
1041:
1042: l_requests_count := p_requests_count ;
1561: END IF; -- input count 0 check
1562:
1563: SELECT max(start_date)
1564: INTO l_max_period_start_date
1565: FROM GL_PERIODS
1566: WHERE ADJUSTMENT_PERIOD_FLAG = 'N'
1567: AND period_type = l_sob_period_type
1568: AND PERIOD_SET_NAME = l_period_set_name;
1569: