[Home] [Help]
581: x_period_name
582: , x_period_start_date
583: , x_period_end_date
584: FROM
585: gl_periods glp
586: , org_acct_periods orgp
587: WHERE glp.period_name = orgp.period_name
588: AND glp.period_set_name = p_period_set_name
589: AND glp.period_type = p_period_type
726: x_period_name
727: , x_period_start_date
728: , x_period_end_date
729: FROM
730: gl_periods glp
731: , org_acct_periods orgp
732: WHERE glp.period_name = orgp.period_name
733: AND glp.period_set_name = p_period_set_name
734: AND glp.period_type = p_period_type
934: FROM
935: HR_organization_units
936: WHERE ORGANIZATION_ID = c_org_id;
937:
938: -- Select the periods from GL_PERIODS
939: -- that are eligible to be
940: -- opened for a given Org
941:
942: CURSOR c_gl_period_future(c_org_id NUMBER) IS
948: , glp.PERIOD_TYPE acct_period_type
949: , glp.PERIOD_YEAR open_period_year
950: , glp.PERIOD_NUM open_period_num
951: FROM
952: GL_PERIODS glp
953: WHERE glp.ADJUSTMENT_PERIOD_FLAG = 'N'
954: AND glp.period_type = l_sob_period_type
955: AND glp.PERIOD_SET_NAME = l_period_set_name
956: AND glp.PERIOD_NAME NOT IN
966:
967: l_gl_period_future c_gl_period_future%ROWTYPE ;
968:
969:
970: -- Select the periods from GL_PERIODS
971: -- that are eligible to be
972: -- Closed for a given Org
973:
974: CURSOR c_org_acct_periods_open IS
1048: -- The API's return status details the process outcome , which is
1049: -- inserted into the PL/SQL table and later printed as Log report
1050:
1051: -- The periods for Closing are selected from the ORG_ACCT_PERIODS
1052: -- and the periods to Open are retreived from GL_PERIODS
1053:
1054: G_LOG_REPORT_TABLE.DELETE ;
1055:
1056: l_requests_count := p_requests_count ;
1670: END IF; -- input count 0 check
1671:
1672: SELECT max(start_date)
1673: INTO l_max_period_start_date
1674: FROM GL_PERIODS
1675: WHERE ADJUSTMENT_PERIOD_FLAG = 'N'
1676: AND period_type = l_sob_period_type
1677: AND PERIOD_SET_NAME = l_period_set_name;
1678: