[Home] [Help]
62: l_DET_PF_LINE_ROWID VARCHAR2(18);
63: l_ACCT_ROWID VARCHAR2(18);
64: l_CC_STATE IGC_CC_HEADERS.CC_STATE%TYPE;
65: l_next_yr_start_date DATE;
66: l_min_period_num gl_periods.period_num%TYPE;
67: V14 C14%ROWTYPE;
68: V15 C15%ROWTYPE;
69: V16 C16%ROWTYPE;
70: l_api_version CONSTANT NUMBER := 1.0;
114:
115: SELECT min(gp.period_num)
116: INTO l_min_period_num
117: FROM gl_period_statuses gps,
118: gl_periods gp,
119: gl_sets_of_books gb
120: WHERE
121: gb.set_of_books_id = p_SOB_ID AND
122: gp.period_set_name = gb.period_set_name AND
130:
131: SELECT gps.start_date INTO
132: l_next_yr_start_date
133: FROM gl_period_statuses gps,
134: gl_periods gp,
135: gl_sets_of_books gb
136: WHERE gb.set_of_books_id = p_SOB_ID AND
137: gp.period_set_name = gb.period_set_name AND
138: gp.period_type = gb.accounted_period_type AND
989:
990: CURSOR C6 IS
991: SELECT B.PERIOD_NUM, B.PERIOD_NAME , A.CC_PERIOD_STATUS
992: FROM IGC_CC_PERIODS A,
993: GL_PERIODS_V B,
994: GL_SETS_OF_BOOKS C
995: WHERE B.PERIOD_YEAR = p_YEAR
996: AND A.PERIOD_SET_NAME = B.PERIOD_SET_NAME
997: AND B.PERIOD_SET_NAME = C.PERIOD_SET_NAME
1005:
1006: CURSOR C7 IS
1007: SELECT B.PERIOD_NUM, B.PERIOD_NAME , A.CC_PERIOD_STATUS
1008: FROM IGC_CC_PERIODS A,
1009: GL_PERIODS_V B,
1010: GL_SETS_OF_BOOKS C
1011: WHERE B.PERIOD_YEAR = p_YEAR+1
1012: AND A.PERIOD_SET_NAME = B.PERIOD_SET_NAME
1013: AND B.PERIOD_SET_NAME = C.PERIOD_SET_NAME
1110: l_yr_start_date_next DATE;
1111: l_yr_end_date DATE;
1112: l_yr_end_cr_date DATE;
1113: l_yr_end_dr_date DATE;
1114: l_min_period_num gl_periods.period_num%TYPE;
1115: l_max_period_num gl_periods.period_num%TYPE;
1116:
1117: l_currency_code gl_sets_of_books.currency_code%TYPE;
1118: l_sbc_on BOOLEAN;
1111: l_yr_end_date DATE;
1112: l_yr_end_cr_date DATE;
1113: l_yr_end_dr_date DATE;
1114: l_min_period_num gl_periods.period_num%TYPE;
1115: l_max_period_num gl_periods.period_num%TYPE;
1116:
1117: l_currency_code gl_sets_of_books.currency_code%TYPE;
1118: l_sbc_on BOOLEAN;
1119: l_cbc_on BOOLEAN;
1349:
1350: SELECT min(gp.period_num)
1351: INTO l_min_period_num
1352: FROM gl_period_statuses gps,
1353: gl_periods gp,
1354: gl_sets_of_books gb
1355: WHERE
1356: gb.set_of_books_id = l_sob_id AND /*p_sob_id => l_sob_id by Bug 6341012 */
1357: gp.period_set_name = gb.period_set_name AND
1365:
1366: SELECT max(gp.period_num)
1367: INTO l_max_period_num
1368: FROM gl_period_statuses gps,
1369: gl_periods gp,
1370: gl_sets_of_books gb
1371: WHERE
1372: gb.set_of_books_id = l_sob_id AND /* p_sob_id => l_sob_id by Bug 6341012 */
1373: gp.period_set_name = gb.period_set_name AND
1382:
1383: SELECT gps.end_date,gps.end_date INTO
1384: l_yr_end_cr_date,l_yr_end_date
1385: FROM gl_period_statuses gps,
1386: gl_periods gp,
1387: gl_sets_of_books gb
1388: WHERE
1389: gb.set_of_books_id = l_sob_id AND /* p_sob_id => l_sob_id by Bug 6341012 */
1390: gp.period_set_name = gb.period_set_name AND
1398:
1399: SELECT gps.start_date, gps.start_date INTO
1400: l_yr_end_dr_date, l_yr_start_date_next
1401: FROM gl_period_statuses gps,
1402: gl_periods gp,
1403: gl_sets_of_books gb
1404: WHERE
1405: gb.set_of_books_id = l_sob_id AND /* p_sob_id => l_sob_id by Bug 6341012 */
1406: gp.period_set_name = gb.period_set_name AND
1414:
1415: SELECT gps.start_date INTO
1416: l_yr_start_date
1417: FROM gl_period_statuses gps,
1418: gl_periods gp,
1419: gl_sets_of_books gb
1420: WHERE
1421: gb.set_of_books_id = l_sob_id AND /* p_sob_id => l_sob_id by Bug 6341012 */
1422: gp.period_set_name = gb.period_set_name AND