[Home] [Help]
101: WHERE application_id = 222
102: -- BEGIN abindal bug 4356410 --
103: AND closing_status IN ('F','O')
104: -- END abindal bug 4356410 --
105: AND ledger_id = okl_accounting_util.get_set_of_books_id
106: AND trunc(cp_date) between start_date and end_date
107: AND adjustment_period_flag = 'N'
108: UNION
109: SELECT MAX(end_date) gl_date, 2 Counter
108: UNION
109: SELECT MAX(end_date) gl_date, 2 Counter
110: FROM gl_period_statuses
111: WHERE application_id = 222
112: AND ledger_id = okl_accounting_util.get_set_of_books_id
113: AND closing_status IN ('F','O')
114: AND end_date <= trunc(cp_date)
115: AND adjustment_period_flag = 'N'
116: UNION
116: UNION
117: SELECT MIN(start_date) gl_date, 3 Counter
118: FROM gl_period_statuses
119: WHERE application_id = 222
120: AND ledger_id = okl_accounting_util.get_set_of_books_id
121: AND closing_status IN ('F','O')
122: AND start_date >= trunc(cp_date)
123: AND adjustment_period_flag = 'N'
124: )
138: ELSE
139: l_init_msg_list := fnd_api.g_true;
140: END IF;
141:
142: l_functional_currency := okl_accounting_util.get_func_curr_code;
143:
144: -- BEGIN abindal bug 4356410 --
145: OPEN c_get_gl_date(p_xcrv_rec.receipt_date);
146: -- END abindal bug 4356410 --
477: l_attribute_rec.attribute14 := l_rcpt_rec.dff_attribute14;
478: l_attribute_rec.attribute15 := l_rcpt_rec.dff_attribute15;
479:
480:
481: l_functional_currency := okl_accounting_util.get_func_curr_code;
482: IF l_functional_currency <> l_rcpt_rec.currency_code THEN
483:
484: l_exchange_rate_type := l_rcpt_rec.exchange_rate_type;
485:
641: CURSOR c_get_gl_date(cp_date IN DATE) IS SELECT * from (
642: SELECT end_date gl_date, 1 Counter
643: FROM gl_period_statuses
644: WHERE application_id = 222
645: AND ledger_id = okl_accounting_util.get_set_of_books_id
646: AND trunc(cp_date) between start_date and end_date
647: AND adjustment_period_flag = 'N'
648: UNION
649: SELECT MAX(end_date) gl_date, 2 Counter
648: UNION
649: SELECT MAX(end_date) gl_date, 2 Counter
650: FROM gl_period_statuses
651: WHERE application_id = 222
652: AND ledger_id = okl_accounting_util.get_set_of_books_id
653: AND closing_status IN ('F','O')
654: AND end_date <= trunc(cp_date)
655: AND adjustment_period_flag = 'N'
656: UNION
656: UNION
657: SELECT MIN(end_date) gl_date, 3 Counter
658: FROM gl_period_statuses
659: WHERE application_id = 222
660: AND ledger_id = okl_accounting_util.get_set_of_books_id
661: AND closing_status IN ('F','O')
662: AND start_date >= trunc(cp_date)
663: AND adjustment_period_flag = 'N'
664: )
671: CURSOR c_get_gl_date_start(cp_date IN DATE) IS SELECT * from (
672: SELECT start_date gl_date, 1 Counter
673: FROM gl_period_statuses
674: WHERE application_id = 222
675: AND ledger_id = okl_accounting_util.get_set_of_books_id
676: AND trunc(cp_date) between start_date and end_date
677: AND adjustment_period_flag = 'N'
678: UNION
679: SELECT MAX(start_date) gl_date, 2 Counter
678: UNION
679: SELECT MAX(start_date) gl_date, 2 Counter
680: FROM gl_period_statuses
681: WHERE application_id = 222
682: AND ledger_id = okl_accounting_util.get_set_of_books_id
683: AND closing_status IN ('F','O')
684: AND end_date <= trunc(cp_date)
685: AND adjustment_period_flag = 'N'
686: UNION
686: UNION
687: SELECT MIN(start_date) gl_date, 3 Counter
688: FROM gl_period_statuses
689: WHERE application_id = 222
690: AND ledger_id = okl_accounting_util.get_set_of_books_id
691: AND closing_status IN ('F','O')
692: AND start_date >= trunc(cp_date)
693: AND adjustment_period_flag = 'N'
694: )
710: ELSE
711: l_init_msg_list := fnd_api.g_true;
712: END IF;
713:
714: l_functional_currency := okl_accounting_util.get_func_curr_code;
715:
716: OPEN c_get_gl_date(SYSDATE);
717: FETCH c_get_gl_date INTO l_gl_date, l_counter;
718: