eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BIM_CAMP_COLLECTION dependencies on BIM_SET_OF_BOOKS

Line 83: bim_set_of_books.get_fiscal_month(x.start_date, 0),

79: -1,
80: -1,
81: -1,
82: -1,
83: bim_set_of_books.get_fiscal_month(x.start_date, 0),
84: bim_set_of_books.get_fiscal_month_end(x.start_date, 0),
85: bim_set_of_books.get_fiscal_month_num(x.start_date, 0),
86: bim_set_of_books.get_fiscal_month_start(x.start_date, 0),
87: bim_set_of_books.get_fiscal_qtr(x.start_date, 0),

Line 84: bim_set_of_books.get_fiscal_month_end(x.start_date, 0),

80: -1,
81: -1,
82: -1,
83: bim_set_of_books.get_fiscal_month(x.start_date, 0),
84: bim_set_of_books.get_fiscal_month_end(x.start_date, 0),
85: bim_set_of_books.get_fiscal_month_num(x.start_date, 0),
86: bim_set_of_books.get_fiscal_month_start(x.start_date, 0),
87: bim_set_of_books.get_fiscal_qtr(x.start_date, 0),
88: bim_set_of_books.get_fiscal_qtr_end(x.start_date, 0),

Line 85: bim_set_of_books.get_fiscal_month_num(x.start_date, 0),

81: -1,
82: -1,
83: bim_set_of_books.get_fiscal_month(x.start_date, 0),
84: bim_set_of_books.get_fiscal_month_end(x.start_date, 0),
85: bim_set_of_books.get_fiscal_month_num(x.start_date, 0),
86: bim_set_of_books.get_fiscal_month_start(x.start_date, 0),
87: bim_set_of_books.get_fiscal_qtr(x.start_date, 0),
88: bim_set_of_books.get_fiscal_qtr_end(x.start_date, 0),
89: bim_set_of_books.get_fiscal_qtr_num(x.start_date, 0),

Line 86: bim_set_of_books.get_fiscal_month_start(x.start_date, 0),

82: -1,
83: bim_set_of_books.get_fiscal_month(x.start_date, 0),
84: bim_set_of_books.get_fiscal_month_end(x.start_date, 0),
85: bim_set_of_books.get_fiscal_month_num(x.start_date, 0),
86: bim_set_of_books.get_fiscal_month_start(x.start_date, 0),
87: bim_set_of_books.get_fiscal_qtr(x.start_date, 0),
88: bim_set_of_books.get_fiscal_qtr_end(x.start_date, 0),
89: bim_set_of_books.get_fiscal_qtr_num(x.start_date, 0),
90: bim_set_of_books.get_fiscal_qtr_start(x.start_date, 0),

Line 87: bim_set_of_books.get_fiscal_qtr(x.start_date, 0),

83: bim_set_of_books.get_fiscal_month(x.start_date, 0),
84: bim_set_of_books.get_fiscal_month_end(x.start_date, 0),
85: bim_set_of_books.get_fiscal_month_num(x.start_date, 0),
86: bim_set_of_books.get_fiscal_month_start(x.start_date, 0),
87: bim_set_of_books.get_fiscal_qtr(x.start_date, 0),
88: bim_set_of_books.get_fiscal_qtr_end(x.start_date, 0),
89: bim_set_of_books.get_fiscal_qtr_num(x.start_date, 0),
90: bim_set_of_books.get_fiscal_qtr_start(x.start_date, 0),
91: bim_set_of_books.get_fiscal_year(x.start_date, 0),

Line 88: bim_set_of_books.get_fiscal_qtr_end(x.start_date, 0),

84: bim_set_of_books.get_fiscal_month_end(x.start_date, 0),
85: bim_set_of_books.get_fiscal_month_num(x.start_date, 0),
86: bim_set_of_books.get_fiscal_month_start(x.start_date, 0),
87: bim_set_of_books.get_fiscal_qtr(x.start_date, 0),
88: bim_set_of_books.get_fiscal_qtr_end(x.start_date, 0),
89: bim_set_of_books.get_fiscal_qtr_num(x.start_date, 0),
90: bim_set_of_books.get_fiscal_qtr_start(x.start_date, 0),
91: bim_set_of_books.get_fiscal_year(x.start_date, 0),
92: bim_set_of_books.get_fiscal_year_end(x.start_date, 0),

Line 89: bim_set_of_books.get_fiscal_qtr_num(x.start_date, 0),

85: bim_set_of_books.get_fiscal_month_num(x.start_date, 0),
86: bim_set_of_books.get_fiscal_month_start(x.start_date, 0),
87: bim_set_of_books.get_fiscal_qtr(x.start_date, 0),
88: bim_set_of_books.get_fiscal_qtr_end(x.start_date, 0),
89: bim_set_of_books.get_fiscal_qtr_num(x.start_date, 0),
90: bim_set_of_books.get_fiscal_qtr_start(x.start_date, 0),
91: bim_set_of_books.get_fiscal_year(x.start_date, 0),
92: bim_set_of_books.get_fiscal_year_end(x.start_date, 0),
93: bim_set_of_books.get_fiscal_year_start(x.start_date, 0),

Line 90: bim_set_of_books.get_fiscal_qtr_start(x.start_date, 0),

86: bim_set_of_books.get_fiscal_month_start(x.start_date, 0),
87: bim_set_of_books.get_fiscal_qtr(x.start_date, 0),
88: bim_set_of_books.get_fiscal_qtr_end(x.start_date, 0),
89: bim_set_of_books.get_fiscal_qtr_num(x.start_date, 0),
90: bim_set_of_books.get_fiscal_qtr_start(x.start_date, 0),
91: bim_set_of_books.get_fiscal_year(x.start_date, 0),
92: bim_set_of_books.get_fiscal_year_end(x.start_date, 0),
93: bim_set_of_books.get_fiscal_year_start(x.start_date, 0),
94: bim_set_of_books.get_pre_fiscal_month_end(x.start_date, 0),

Line 91: bim_set_of_books.get_fiscal_year(x.start_date, 0),

87: bim_set_of_books.get_fiscal_qtr(x.start_date, 0),
88: bim_set_of_books.get_fiscal_qtr_end(x.start_date, 0),
89: bim_set_of_books.get_fiscal_qtr_num(x.start_date, 0),
90: bim_set_of_books.get_fiscal_qtr_start(x.start_date, 0),
91: bim_set_of_books.get_fiscal_year(x.start_date, 0),
92: bim_set_of_books.get_fiscal_year_end(x.start_date, 0),
93: bim_set_of_books.get_fiscal_year_start(x.start_date, 0),
94: bim_set_of_books.get_pre_fiscal_month_end(x.start_date, 0),
95: bim_set_of_books.get_pre_fiscal_month_start(x.start_date, 0),

Line 92: bim_set_of_books.get_fiscal_year_end(x.start_date, 0),

88: bim_set_of_books.get_fiscal_qtr_end(x.start_date, 0),
89: bim_set_of_books.get_fiscal_qtr_num(x.start_date, 0),
90: bim_set_of_books.get_fiscal_qtr_start(x.start_date, 0),
91: bim_set_of_books.get_fiscal_year(x.start_date, 0),
92: bim_set_of_books.get_fiscal_year_end(x.start_date, 0),
93: bim_set_of_books.get_fiscal_year_start(x.start_date, 0),
94: bim_set_of_books.get_pre_fiscal_month_end(x.start_date, 0),
95: bim_set_of_books.get_pre_fiscal_month_start(x.start_date, 0),
96: bim_set_of_books.get_pre_fiscal_qtr_end(x.start_date, 0),

Line 93: bim_set_of_books.get_fiscal_year_start(x.start_date, 0),

89: bim_set_of_books.get_fiscal_qtr_num(x.start_date, 0),
90: bim_set_of_books.get_fiscal_qtr_start(x.start_date, 0),
91: bim_set_of_books.get_fiscal_year(x.start_date, 0),
92: bim_set_of_books.get_fiscal_year_end(x.start_date, 0),
93: bim_set_of_books.get_fiscal_year_start(x.start_date, 0),
94: bim_set_of_books.get_pre_fiscal_month_end(x.start_date, 0),
95: bim_set_of_books.get_pre_fiscal_month_start(x.start_date, 0),
96: bim_set_of_books.get_pre_fiscal_qtr_end(x.start_date, 0),
97: bim_set_of_books.get_pre_fiscal_qtr_start(x.start_date, 0),

Line 94: bim_set_of_books.get_pre_fiscal_month_end(x.start_date, 0),

90: bim_set_of_books.get_fiscal_qtr_start(x.start_date, 0),
91: bim_set_of_books.get_fiscal_year(x.start_date, 0),
92: bim_set_of_books.get_fiscal_year_end(x.start_date, 0),
93: bim_set_of_books.get_fiscal_year_start(x.start_date, 0),
94: bim_set_of_books.get_pre_fiscal_month_end(x.start_date, 0),
95: bim_set_of_books.get_pre_fiscal_month_start(x.start_date, 0),
96: bim_set_of_books.get_pre_fiscal_qtr_end(x.start_date, 0),
97: bim_set_of_books.get_pre_fiscal_qtr_start(x.start_date, 0),
98: bim_set_of_books.get_pre_fiscal_year_end(x.start_date, 0),

Line 95: bim_set_of_books.get_pre_fiscal_month_start(x.start_date, 0),

91: bim_set_of_books.get_fiscal_year(x.start_date, 0),
92: bim_set_of_books.get_fiscal_year_end(x.start_date, 0),
93: bim_set_of_books.get_fiscal_year_start(x.start_date, 0),
94: bim_set_of_books.get_pre_fiscal_month_end(x.start_date, 0),
95: bim_set_of_books.get_pre_fiscal_month_start(x.start_date, 0),
96: bim_set_of_books.get_pre_fiscal_qtr_end(x.start_date, 0),
97: bim_set_of_books.get_pre_fiscal_qtr_start(x.start_date, 0),
98: bim_set_of_books.get_pre_fiscal_year_end(x.start_date, 0),
99: bim_set_of_books.get_pre_fiscal_year_start(x.start_date, 0),

Line 96: bim_set_of_books.get_pre_fiscal_qtr_end(x.start_date, 0),

92: bim_set_of_books.get_fiscal_year_end(x.start_date, 0),
93: bim_set_of_books.get_fiscal_year_start(x.start_date, 0),
94: bim_set_of_books.get_pre_fiscal_month_end(x.start_date, 0),
95: bim_set_of_books.get_pre_fiscal_month_start(x.start_date, 0),
96: bim_set_of_books.get_pre_fiscal_qtr_end(x.start_date, 0),
97: bim_set_of_books.get_pre_fiscal_qtr_start(x.start_date, 0),
98: bim_set_of_books.get_pre_fiscal_year_end(x.start_date, 0),
99: bim_set_of_books.get_pre_fiscal_year_start(x.start_date, 0),
100: 'MONTH'

Line 97: bim_set_of_books.get_pre_fiscal_qtr_start(x.start_date, 0),

93: bim_set_of_books.get_fiscal_year_start(x.start_date, 0),
94: bim_set_of_books.get_pre_fiscal_month_end(x.start_date, 0),
95: bim_set_of_books.get_pre_fiscal_month_start(x.start_date, 0),
96: bim_set_of_books.get_pre_fiscal_qtr_end(x.start_date, 0),
97: bim_set_of_books.get_pre_fiscal_qtr_start(x.start_date, 0),
98: bim_set_of_books.get_pre_fiscal_year_end(x.start_date, 0),
99: bim_set_of_books.get_pre_fiscal_year_start(x.start_date, 0),
100: 'MONTH'
101: FROM DUAL;

Line 98: bim_set_of_books.get_pre_fiscal_year_end(x.start_date, 0),

94: bim_set_of_books.get_pre_fiscal_month_end(x.start_date, 0),
95: bim_set_of_books.get_pre_fiscal_month_start(x.start_date, 0),
96: bim_set_of_books.get_pre_fiscal_qtr_end(x.start_date, 0),
97: bim_set_of_books.get_pre_fiscal_qtr_start(x.start_date, 0),
98: bim_set_of_books.get_pre_fiscal_year_end(x.start_date, 0),
99: bim_set_of_books.get_pre_fiscal_year_start(x.start_date, 0),
100: 'MONTH'
101: FROM DUAL;
102:

Line 99: bim_set_of_books.get_pre_fiscal_year_start(x.start_date, 0),

95: bim_set_of_books.get_pre_fiscal_month_start(x.start_date, 0),
96: bim_set_of_books.get_pre_fiscal_qtr_end(x.start_date, 0),
97: bim_set_of_books.get_pre_fiscal_qtr_start(x.start_date, 0),
98: bim_set_of_books.get_pre_fiscal_year_end(x.start_date, 0),
99: bim_set_of_books.get_pre_fiscal_year_start(x.start_date, 0),
100: 'MONTH'
101: FROM DUAL;
102:
103: --commit;

Line 148: bim_set_of_books.get_fiscal_month(x.start_date, 0),

144: -1,
145: -1,
146: -1,
147: -1,
148: bim_set_of_books.get_fiscal_month(x.start_date, 0),
149: bim_set_of_books.get_fiscal_month_end(x.start_date, 0),
150: bim_set_of_books.get_fiscal_month_num(x.start_date, 0),
151: bim_set_of_books.get_fiscal_month_start(x.start_date, 0),
152: bim_set_of_books.get_fiscal_qtr(x.start_date, 0),

Line 149: bim_set_of_books.get_fiscal_month_end(x.start_date, 0),

145: -1,
146: -1,
147: -1,
148: bim_set_of_books.get_fiscal_month(x.start_date, 0),
149: bim_set_of_books.get_fiscal_month_end(x.start_date, 0),
150: bim_set_of_books.get_fiscal_month_num(x.start_date, 0),
151: bim_set_of_books.get_fiscal_month_start(x.start_date, 0),
152: bim_set_of_books.get_fiscal_qtr(x.start_date, 0),
153: bim_set_of_books.get_fiscal_qtr_end(x.start_date, 0),

Line 150: bim_set_of_books.get_fiscal_month_num(x.start_date, 0),

146: -1,
147: -1,
148: bim_set_of_books.get_fiscal_month(x.start_date, 0),
149: bim_set_of_books.get_fiscal_month_end(x.start_date, 0),
150: bim_set_of_books.get_fiscal_month_num(x.start_date, 0),
151: bim_set_of_books.get_fiscal_month_start(x.start_date, 0),
152: bim_set_of_books.get_fiscal_qtr(x.start_date, 0),
153: bim_set_of_books.get_fiscal_qtr_end(x.start_date, 0),
154: bim_set_of_books.get_fiscal_qtr_num(x.start_date, 0),

Line 151: bim_set_of_books.get_fiscal_month_start(x.start_date, 0),

147: -1,
148: bim_set_of_books.get_fiscal_month(x.start_date, 0),
149: bim_set_of_books.get_fiscal_month_end(x.start_date, 0),
150: bim_set_of_books.get_fiscal_month_num(x.start_date, 0),
151: bim_set_of_books.get_fiscal_month_start(x.start_date, 0),
152: bim_set_of_books.get_fiscal_qtr(x.start_date, 0),
153: bim_set_of_books.get_fiscal_qtr_end(x.start_date, 0),
154: bim_set_of_books.get_fiscal_qtr_num(x.start_date, 0),
155: bim_set_of_books.get_fiscal_qtr_start(x.start_date, 0),

Line 152: bim_set_of_books.get_fiscal_qtr(x.start_date, 0),

148: bim_set_of_books.get_fiscal_month(x.start_date, 0),
149: bim_set_of_books.get_fiscal_month_end(x.start_date, 0),
150: bim_set_of_books.get_fiscal_month_num(x.start_date, 0),
151: bim_set_of_books.get_fiscal_month_start(x.start_date, 0),
152: bim_set_of_books.get_fiscal_qtr(x.start_date, 0),
153: bim_set_of_books.get_fiscal_qtr_end(x.start_date, 0),
154: bim_set_of_books.get_fiscal_qtr_num(x.start_date, 0),
155: bim_set_of_books.get_fiscal_qtr_start(x.start_date, 0),
156: bim_set_of_books.get_fiscal_year(x.start_date, 0),

Line 153: bim_set_of_books.get_fiscal_qtr_end(x.start_date, 0),

149: bim_set_of_books.get_fiscal_month_end(x.start_date, 0),
150: bim_set_of_books.get_fiscal_month_num(x.start_date, 0),
151: bim_set_of_books.get_fiscal_month_start(x.start_date, 0),
152: bim_set_of_books.get_fiscal_qtr(x.start_date, 0),
153: bim_set_of_books.get_fiscal_qtr_end(x.start_date, 0),
154: bim_set_of_books.get_fiscal_qtr_num(x.start_date, 0),
155: bim_set_of_books.get_fiscal_qtr_start(x.start_date, 0),
156: bim_set_of_books.get_fiscal_year(x.start_date, 0),
157: bim_set_of_books.get_fiscal_year_end(x.start_date, 0),

Line 154: bim_set_of_books.get_fiscal_qtr_num(x.start_date, 0),

150: bim_set_of_books.get_fiscal_month_num(x.start_date, 0),
151: bim_set_of_books.get_fiscal_month_start(x.start_date, 0),
152: bim_set_of_books.get_fiscal_qtr(x.start_date, 0),
153: bim_set_of_books.get_fiscal_qtr_end(x.start_date, 0),
154: bim_set_of_books.get_fiscal_qtr_num(x.start_date, 0),
155: bim_set_of_books.get_fiscal_qtr_start(x.start_date, 0),
156: bim_set_of_books.get_fiscal_year(x.start_date, 0),
157: bim_set_of_books.get_fiscal_year_end(x.start_date, 0),
158: bim_set_of_books.get_fiscal_year_start(x.start_date, 0),

Line 155: bim_set_of_books.get_fiscal_qtr_start(x.start_date, 0),

151: bim_set_of_books.get_fiscal_month_start(x.start_date, 0),
152: bim_set_of_books.get_fiscal_qtr(x.start_date, 0),
153: bim_set_of_books.get_fiscal_qtr_end(x.start_date, 0),
154: bim_set_of_books.get_fiscal_qtr_num(x.start_date, 0),
155: bim_set_of_books.get_fiscal_qtr_start(x.start_date, 0),
156: bim_set_of_books.get_fiscal_year(x.start_date, 0),
157: bim_set_of_books.get_fiscal_year_end(x.start_date, 0),
158: bim_set_of_books.get_fiscal_year_start(x.start_date, 0),
159: bim_set_of_books.get_pre_fiscal_month_end(x.start_date, 0),

Line 156: bim_set_of_books.get_fiscal_year(x.start_date, 0),

152: bim_set_of_books.get_fiscal_qtr(x.start_date, 0),
153: bim_set_of_books.get_fiscal_qtr_end(x.start_date, 0),
154: bim_set_of_books.get_fiscal_qtr_num(x.start_date, 0),
155: bim_set_of_books.get_fiscal_qtr_start(x.start_date, 0),
156: bim_set_of_books.get_fiscal_year(x.start_date, 0),
157: bim_set_of_books.get_fiscal_year_end(x.start_date, 0),
158: bim_set_of_books.get_fiscal_year_start(x.start_date, 0),
159: bim_set_of_books.get_pre_fiscal_month_end(x.start_date, 0),
160: bim_set_of_books.get_pre_fiscal_month_start(x.start_date, 0),

Line 157: bim_set_of_books.get_fiscal_year_end(x.start_date, 0),

153: bim_set_of_books.get_fiscal_qtr_end(x.start_date, 0),
154: bim_set_of_books.get_fiscal_qtr_num(x.start_date, 0),
155: bim_set_of_books.get_fiscal_qtr_start(x.start_date, 0),
156: bim_set_of_books.get_fiscal_year(x.start_date, 0),
157: bim_set_of_books.get_fiscal_year_end(x.start_date, 0),
158: bim_set_of_books.get_fiscal_year_start(x.start_date, 0),
159: bim_set_of_books.get_pre_fiscal_month_end(x.start_date, 0),
160: bim_set_of_books.get_pre_fiscal_month_start(x.start_date, 0),
161: bim_set_of_books.get_pre_fiscal_qtr_end(x.start_date, 0),

Line 158: bim_set_of_books.get_fiscal_year_start(x.start_date, 0),

154: bim_set_of_books.get_fiscal_qtr_num(x.start_date, 0),
155: bim_set_of_books.get_fiscal_qtr_start(x.start_date, 0),
156: bim_set_of_books.get_fiscal_year(x.start_date, 0),
157: bim_set_of_books.get_fiscal_year_end(x.start_date, 0),
158: bim_set_of_books.get_fiscal_year_start(x.start_date, 0),
159: bim_set_of_books.get_pre_fiscal_month_end(x.start_date, 0),
160: bim_set_of_books.get_pre_fiscal_month_start(x.start_date, 0),
161: bim_set_of_books.get_pre_fiscal_qtr_end(x.start_date, 0),
162: bim_set_of_books.get_pre_fiscal_qtr_start(x.start_date, 0),

Line 159: bim_set_of_books.get_pre_fiscal_month_end(x.start_date, 0),

155: bim_set_of_books.get_fiscal_qtr_start(x.start_date, 0),
156: bim_set_of_books.get_fiscal_year(x.start_date, 0),
157: bim_set_of_books.get_fiscal_year_end(x.start_date, 0),
158: bim_set_of_books.get_fiscal_year_start(x.start_date, 0),
159: bim_set_of_books.get_pre_fiscal_month_end(x.start_date, 0),
160: bim_set_of_books.get_pre_fiscal_month_start(x.start_date, 0),
161: bim_set_of_books.get_pre_fiscal_qtr_end(x.start_date, 0),
162: bim_set_of_books.get_pre_fiscal_qtr_start(x.start_date, 0),
163: bim_set_of_books.get_pre_fiscal_year_end(x.start_date, 0),

Line 160: bim_set_of_books.get_pre_fiscal_month_start(x.start_date, 0),

156: bim_set_of_books.get_fiscal_year(x.start_date, 0),
157: bim_set_of_books.get_fiscal_year_end(x.start_date, 0),
158: bim_set_of_books.get_fiscal_year_start(x.start_date, 0),
159: bim_set_of_books.get_pre_fiscal_month_end(x.start_date, 0),
160: bim_set_of_books.get_pre_fiscal_month_start(x.start_date, 0),
161: bim_set_of_books.get_pre_fiscal_qtr_end(x.start_date, 0),
162: bim_set_of_books.get_pre_fiscal_qtr_start(x.start_date, 0),
163: bim_set_of_books.get_pre_fiscal_year_end(x.start_date, 0),
164: bim_set_of_books.get_pre_fiscal_year_start(x.start_date, 0),

Line 161: bim_set_of_books.get_pre_fiscal_qtr_end(x.start_date, 0),

157: bim_set_of_books.get_fiscal_year_end(x.start_date, 0),
158: bim_set_of_books.get_fiscal_year_start(x.start_date, 0),
159: bim_set_of_books.get_pre_fiscal_month_end(x.start_date, 0),
160: bim_set_of_books.get_pre_fiscal_month_start(x.start_date, 0),
161: bim_set_of_books.get_pre_fiscal_qtr_end(x.start_date, 0),
162: bim_set_of_books.get_pre_fiscal_qtr_start(x.start_date, 0),
163: bim_set_of_books.get_pre_fiscal_year_end(x.start_date, 0),
164: bim_set_of_books.get_pre_fiscal_year_start(x.start_date, 0),
165: 'QUARTER'

Line 162: bim_set_of_books.get_pre_fiscal_qtr_start(x.start_date, 0),

158: bim_set_of_books.get_fiscal_year_start(x.start_date, 0),
159: bim_set_of_books.get_pre_fiscal_month_end(x.start_date, 0),
160: bim_set_of_books.get_pre_fiscal_month_start(x.start_date, 0),
161: bim_set_of_books.get_pre_fiscal_qtr_end(x.start_date, 0),
162: bim_set_of_books.get_pre_fiscal_qtr_start(x.start_date, 0),
163: bim_set_of_books.get_pre_fiscal_year_end(x.start_date, 0),
164: bim_set_of_books.get_pre_fiscal_year_start(x.start_date, 0),
165: 'QUARTER'
166: FROM DUAL;

Line 163: bim_set_of_books.get_pre_fiscal_year_end(x.start_date, 0),

159: bim_set_of_books.get_pre_fiscal_month_end(x.start_date, 0),
160: bim_set_of_books.get_pre_fiscal_month_start(x.start_date, 0),
161: bim_set_of_books.get_pre_fiscal_qtr_end(x.start_date, 0),
162: bim_set_of_books.get_pre_fiscal_qtr_start(x.start_date, 0),
163: bim_set_of_books.get_pre_fiscal_year_end(x.start_date, 0),
164: bim_set_of_books.get_pre_fiscal_year_start(x.start_date, 0),
165: 'QUARTER'
166: FROM DUAL;
167:

Line 164: bim_set_of_books.get_pre_fiscal_year_start(x.start_date, 0),

160: bim_set_of_books.get_pre_fiscal_month_start(x.start_date, 0),
161: bim_set_of_books.get_pre_fiscal_qtr_end(x.start_date, 0),
162: bim_set_of_books.get_pre_fiscal_qtr_start(x.start_date, 0),
163: bim_set_of_books.get_pre_fiscal_year_end(x.start_date, 0),
164: bim_set_of_books.get_pre_fiscal_year_start(x.start_date, 0),
165: 'QUARTER'
166: FROM DUAL;
167:
168: --commit;

Line 213: bim_set_of_books.get_fiscal_month(x.start_date, 0),

209: -1,
210: -1,
211: -1,
212: -1,
213: bim_set_of_books.get_fiscal_month(x.start_date, 0),
214: bim_set_of_books.get_fiscal_month_end(x.start_date, 0),
215: bim_set_of_books.get_fiscal_month_num(x.start_date, 0),
216: bim_set_of_books.get_fiscal_month_start(x.start_date, 0),
217: bim_set_of_books.get_fiscal_qtr(x.start_date, 0),

Line 214: bim_set_of_books.get_fiscal_month_end(x.start_date, 0),

210: -1,
211: -1,
212: -1,
213: bim_set_of_books.get_fiscal_month(x.start_date, 0),
214: bim_set_of_books.get_fiscal_month_end(x.start_date, 0),
215: bim_set_of_books.get_fiscal_month_num(x.start_date, 0),
216: bim_set_of_books.get_fiscal_month_start(x.start_date, 0),
217: bim_set_of_books.get_fiscal_qtr(x.start_date, 0),
218: bim_set_of_books.get_fiscal_qtr_end(x.start_date, 0),

Line 215: bim_set_of_books.get_fiscal_month_num(x.start_date, 0),

211: -1,
212: -1,
213: bim_set_of_books.get_fiscal_month(x.start_date, 0),
214: bim_set_of_books.get_fiscal_month_end(x.start_date, 0),
215: bim_set_of_books.get_fiscal_month_num(x.start_date, 0),
216: bim_set_of_books.get_fiscal_month_start(x.start_date, 0),
217: bim_set_of_books.get_fiscal_qtr(x.start_date, 0),
218: bim_set_of_books.get_fiscal_qtr_end(x.start_date, 0),
219: bim_set_of_books.get_fiscal_qtr_num(x.start_date, 0),

Line 216: bim_set_of_books.get_fiscal_month_start(x.start_date, 0),

212: -1,
213: bim_set_of_books.get_fiscal_month(x.start_date, 0),
214: bim_set_of_books.get_fiscal_month_end(x.start_date, 0),
215: bim_set_of_books.get_fiscal_month_num(x.start_date, 0),
216: bim_set_of_books.get_fiscal_month_start(x.start_date, 0),
217: bim_set_of_books.get_fiscal_qtr(x.start_date, 0),
218: bim_set_of_books.get_fiscal_qtr_end(x.start_date, 0),
219: bim_set_of_books.get_fiscal_qtr_num(x.start_date, 0),
220: bim_set_of_books.get_fiscal_qtr_start(x.start_date, 0),

Line 217: bim_set_of_books.get_fiscal_qtr(x.start_date, 0),

213: bim_set_of_books.get_fiscal_month(x.start_date, 0),
214: bim_set_of_books.get_fiscal_month_end(x.start_date, 0),
215: bim_set_of_books.get_fiscal_month_num(x.start_date, 0),
216: bim_set_of_books.get_fiscal_month_start(x.start_date, 0),
217: bim_set_of_books.get_fiscal_qtr(x.start_date, 0),
218: bim_set_of_books.get_fiscal_qtr_end(x.start_date, 0),
219: bim_set_of_books.get_fiscal_qtr_num(x.start_date, 0),
220: bim_set_of_books.get_fiscal_qtr_start(x.start_date, 0),
221: bim_set_of_books.get_fiscal_year(x.start_date, 0),

Line 218: bim_set_of_books.get_fiscal_qtr_end(x.start_date, 0),

214: bim_set_of_books.get_fiscal_month_end(x.start_date, 0),
215: bim_set_of_books.get_fiscal_month_num(x.start_date, 0),
216: bim_set_of_books.get_fiscal_month_start(x.start_date, 0),
217: bim_set_of_books.get_fiscal_qtr(x.start_date, 0),
218: bim_set_of_books.get_fiscal_qtr_end(x.start_date, 0),
219: bim_set_of_books.get_fiscal_qtr_num(x.start_date, 0),
220: bim_set_of_books.get_fiscal_qtr_start(x.start_date, 0),
221: bim_set_of_books.get_fiscal_year(x.start_date, 0),
222: bim_set_of_books.get_fiscal_year_end(x.start_date, 0),

Line 219: bim_set_of_books.get_fiscal_qtr_num(x.start_date, 0),

215: bim_set_of_books.get_fiscal_month_num(x.start_date, 0),
216: bim_set_of_books.get_fiscal_month_start(x.start_date, 0),
217: bim_set_of_books.get_fiscal_qtr(x.start_date, 0),
218: bim_set_of_books.get_fiscal_qtr_end(x.start_date, 0),
219: bim_set_of_books.get_fiscal_qtr_num(x.start_date, 0),
220: bim_set_of_books.get_fiscal_qtr_start(x.start_date, 0),
221: bim_set_of_books.get_fiscal_year(x.start_date, 0),
222: bim_set_of_books.get_fiscal_year_end(x.start_date, 0),
223: bim_set_of_books.get_fiscal_year_start(x.start_date, 0),

Line 220: bim_set_of_books.get_fiscal_qtr_start(x.start_date, 0),

216: bim_set_of_books.get_fiscal_month_start(x.start_date, 0),
217: bim_set_of_books.get_fiscal_qtr(x.start_date, 0),
218: bim_set_of_books.get_fiscal_qtr_end(x.start_date, 0),
219: bim_set_of_books.get_fiscal_qtr_num(x.start_date, 0),
220: bim_set_of_books.get_fiscal_qtr_start(x.start_date, 0),
221: bim_set_of_books.get_fiscal_year(x.start_date, 0),
222: bim_set_of_books.get_fiscal_year_end(x.start_date, 0),
223: bim_set_of_books.get_fiscal_year_start(x.start_date, 0),
224: bim_set_of_books.get_pre_fiscal_month_end(x.start_date, 0),

Line 221: bim_set_of_books.get_fiscal_year(x.start_date, 0),

217: bim_set_of_books.get_fiscal_qtr(x.start_date, 0),
218: bim_set_of_books.get_fiscal_qtr_end(x.start_date, 0),
219: bim_set_of_books.get_fiscal_qtr_num(x.start_date, 0),
220: bim_set_of_books.get_fiscal_qtr_start(x.start_date, 0),
221: bim_set_of_books.get_fiscal_year(x.start_date, 0),
222: bim_set_of_books.get_fiscal_year_end(x.start_date, 0),
223: bim_set_of_books.get_fiscal_year_start(x.start_date, 0),
224: bim_set_of_books.get_pre_fiscal_month_end(x.start_date, 0),
225: bim_set_of_books.get_pre_fiscal_month_start(x.start_date, 0),

Line 222: bim_set_of_books.get_fiscal_year_end(x.start_date, 0),

218: bim_set_of_books.get_fiscal_qtr_end(x.start_date, 0),
219: bim_set_of_books.get_fiscal_qtr_num(x.start_date, 0),
220: bim_set_of_books.get_fiscal_qtr_start(x.start_date, 0),
221: bim_set_of_books.get_fiscal_year(x.start_date, 0),
222: bim_set_of_books.get_fiscal_year_end(x.start_date, 0),
223: bim_set_of_books.get_fiscal_year_start(x.start_date, 0),
224: bim_set_of_books.get_pre_fiscal_month_end(x.start_date, 0),
225: bim_set_of_books.get_pre_fiscal_month_start(x.start_date, 0),
226: bim_set_of_books.get_pre_fiscal_qtr_end(x.start_date, 0),

Line 223: bim_set_of_books.get_fiscal_year_start(x.start_date, 0),

219: bim_set_of_books.get_fiscal_qtr_num(x.start_date, 0),
220: bim_set_of_books.get_fiscal_qtr_start(x.start_date, 0),
221: bim_set_of_books.get_fiscal_year(x.start_date, 0),
222: bim_set_of_books.get_fiscal_year_end(x.start_date, 0),
223: bim_set_of_books.get_fiscal_year_start(x.start_date, 0),
224: bim_set_of_books.get_pre_fiscal_month_end(x.start_date, 0),
225: bim_set_of_books.get_pre_fiscal_month_start(x.start_date, 0),
226: bim_set_of_books.get_pre_fiscal_qtr_end(x.start_date, 0),
227: bim_set_of_books.get_pre_fiscal_qtr_start(x.start_date, 0),

Line 224: bim_set_of_books.get_pre_fiscal_month_end(x.start_date, 0),

220: bim_set_of_books.get_fiscal_qtr_start(x.start_date, 0),
221: bim_set_of_books.get_fiscal_year(x.start_date, 0),
222: bim_set_of_books.get_fiscal_year_end(x.start_date, 0),
223: bim_set_of_books.get_fiscal_year_start(x.start_date, 0),
224: bim_set_of_books.get_pre_fiscal_month_end(x.start_date, 0),
225: bim_set_of_books.get_pre_fiscal_month_start(x.start_date, 0),
226: bim_set_of_books.get_pre_fiscal_qtr_end(x.start_date, 0),
227: bim_set_of_books.get_pre_fiscal_qtr_start(x.start_date, 0),
228: bim_set_of_books.get_pre_fiscal_year_end(x.start_date, 0),

Line 225: bim_set_of_books.get_pre_fiscal_month_start(x.start_date, 0),

221: bim_set_of_books.get_fiscal_year(x.start_date, 0),
222: bim_set_of_books.get_fiscal_year_end(x.start_date, 0),
223: bim_set_of_books.get_fiscal_year_start(x.start_date, 0),
224: bim_set_of_books.get_pre_fiscal_month_end(x.start_date, 0),
225: bim_set_of_books.get_pre_fiscal_month_start(x.start_date, 0),
226: bim_set_of_books.get_pre_fiscal_qtr_end(x.start_date, 0),
227: bim_set_of_books.get_pre_fiscal_qtr_start(x.start_date, 0),
228: bim_set_of_books.get_pre_fiscal_year_end(x.start_date, 0),
229: bim_set_of_books.get_pre_fiscal_year_start(x.start_date, 0),

Line 226: bim_set_of_books.get_pre_fiscal_qtr_end(x.start_date, 0),

222: bim_set_of_books.get_fiscal_year_end(x.start_date, 0),
223: bim_set_of_books.get_fiscal_year_start(x.start_date, 0),
224: bim_set_of_books.get_pre_fiscal_month_end(x.start_date, 0),
225: bim_set_of_books.get_pre_fiscal_month_start(x.start_date, 0),
226: bim_set_of_books.get_pre_fiscal_qtr_end(x.start_date, 0),
227: bim_set_of_books.get_pre_fiscal_qtr_start(x.start_date, 0),
228: bim_set_of_books.get_pre_fiscal_year_end(x.start_date, 0),
229: bim_set_of_books.get_pre_fiscal_year_start(x.start_date, 0),
230: 'YEAR'

Line 227: bim_set_of_books.get_pre_fiscal_qtr_start(x.start_date, 0),

223: bim_set_of_books.get_fiscal_year_start(x.start_date, 0),
224: bim_set_of_books.get_pre_fiscal_month_end(x.start_date, 0),
225: bim_set_of_books.get_pre_fiscal_month_start(x.start_date, 0),
226: bim_set_of_books.get_pre_fiscal_qtr_end(x.start_date, 0),
227: bim_set_of_books.get_pre_fiscal_qtr_start(x.start_date, 0),
228: bim_set_of_books.get_pre_fiscal_year_end(x.start_date, 0),
229: bim_set_of_books.get_pre_fiscal_year_start(x.start_date, 0),
230: 'YEAR'
231: FROM DUAL;

Line 228: bim_set_of_books.get_pre_fiscal_year_end(x.start_date, 0),

224: bim_set_of_books.get_pre_fiscal_month_end(x.start_date, 0),
225: bim_set_of_books.get_pre_fiscal_month_start(x.start_date, 0),
226: bim_set_of_books.get_pre_fiscal_qtr_end(x.start_date, 0),
227: bim_set_of_books.get_pre_fiscal_qtr_start(x.start_date, 0),
228: bim_set_of_books.get_pre_fiscal_year_end(x.start_date, 0),
229: bim_set_of_books.get_pre_fiscal_year_start(x.start_date, 0),
230: 'YEAR'
231: FROM DUAL;
232: --commit;

Line 229: bim_set_of_books.get_pre_fiscal_year_start(x.start_date, 0),

225: bim_set_of_books.get_pre_fiscal_month_start(x.start_date, 0),
226: bim_set_of_books.get_pre_fiscal_qtr_end(x.start_date, 0),
227: bim_set_of_books.get_pre_fiscal_qtr_start(x.start_date, 0),
228: bim_set_of_books.get_pre_fiscal_year_end(x.start_date, 0),
229: bim_set_of_books.get_pre_fiscal_year_start(x.start_date, 0),
230: 'YEAR'
231: FROM DUAL;
232: --commit;
233: /* EXCEPTION

Line 279: l_fiscal_month := bim_set_of_books.get_fiscal_month(l_SYSDATE - 1, l_org_id);

275: OPEN chk_history_data;
276: FETCH chk_history_data INTO l_min_start_date;
277: CLOSE chk_history_data;
278: l_org_id := 0;
279: l_fiscal_month := bim_set_of_books.get_fiscal_month(l_SYSDATE - 1, l_org_id);
280: l_fiscal_month_end := bim_set_of_books.get_fiscal_month_end(l_SYSDATE - 1, l_org_id);
281: l_fiscal_month_start := bim_set_of_books.get_fiscal_month_start(l_SYSDATE - 1, l_org_id);
282: l_pre_fiscal_month_end := bim_set_of_books.get_fiscal_month_end(l_fiscal_month_start - 1,l_org_id);
283: l_pre_fiscal_month_start := bim_set_of_books.get_pre_fiscal_month_start(l_SYSDATE - 1, l_org_id);

Line 280: l_fiscal_month_end := bim_set_of_books.get_fiscal_month_end(l_SYSDATE - 1, l_org_id);

276: FETCH chk_history_data INTO l_min_start_date;
277: CLOSE chk_history_data;
278: l_org_id := 0;
279: l_fiscal_month := bim_set_of_books.get_fiscal_month(l_SYSDATE - 1, l_org_id);
280: l_fiscal_month_end := bim_set_of_books.get_fiscal_month_end(l_SYSDATE - 1, l_org_id);
281: l_fiscal_month_start := bim_set_of_books.get_fiscal_month_start(l_SYSDATE - 1, l_org_id);
282: l_pre_fiscal_month_end := bim_set_of_books.get_fiscal_month_end(l_fiscal_month_start - 1,l_org_id);
283: l_pre_fiscal_month_start := bim_set_of_books.get_pre_fiscal_month_start(l_SYSDATE - 1, l_org_id);
284: l_fiscal_qtr := bim_set_of_books.get_fiscal_qtr(l_SYSDATE - 1, l_org_id);

Line 281: l_fiscal_month_start := bim_set_of_books.get_fiscal_month_start(l_SYSDATE - 1, l_org_id);

277: CLOSE chk_history_data;
278: l_org_id := 0;
279: l_fiscal_month := bim_set_of_books.get_fiscal_month(l_SYSDATE - 1, l_org_id);
280: l_fiscal_month_end := bim_set_of_books.get_fiscal_month_end(l_SYSDATE - 1, l_org_id);
281: l_fiscal_month_start := bim_set_of_books.get_fiscal_month_start(l_SYSDATE - 1, l_org_id);
282: l_pre_fiscal_month_end := bim_set_of_books.get_fiscal_month_end(l_fiscal_month_start - 1,l_org_id);
283: l_pre_fiscal_month_start := bim_set_of_books.get_pre_fiscal_month_start(l_SYSDATE - 1, l_org_id);
284: l_fiscal_qtr := bim_set_of_books.get_fiscal_qtr(l_SYSDATE - 1, l_org_id);
285: l_fiscal_qtr_end := bim_set_of_books.get_fiscal_qtr_end(l_SYSDATE - 1, l_org_id);

Line 282: l_pre_fiscal_month_end := bim_set_of_books.get_fiscal_month_end(l_fiscal_month_start - 1,l_org_id);

278: l_org_id := 0;
279: l_fiscal_month := bim_set_of_books.get_fiscal_month(l_SYSDATE - 1, l_org_id);
280: l_fiscal_month_end := bim_set_of_books.get_fiscal_month_end(l_SYSDATE - 1, l_org_id);
281: l_fiscal_month_start := bim_set_of_books.get_fiscal_month_start(l_SYSDATE - 1, l_org_id);
282: l_pre_fiscal_month_end := bim_set_of_books.get_fiscal_month_end(l_fiscal_month_start - 1,l_org_id);
283: l_pre_fiscal_month_start := bim_set_of_books.get_pre_fiscal_month_start(l_SYSDATE - 1, l_org_id);
284: l_fiscal_qtr := bim_set_of_books.get_fiscal_qtr(l_SYSDATE - 1, l_org_id);
285: l_fiscal_qtr_end := bim_set_of_books.get_fiscal_qtr_end(l_SYSDATE - 1, l_org_id);
286: l_fiscal_qtr_start := bim_set_of_books.get_fiscal_qtr_start(l_SYSDATE - 1, l_org_id);

Line 283: l_pre_fiscal_month_start := bim_set_of_books.get_pre_fiscal_month_start(l_SYSDATE - 1, l_org_id);

279: l_fiscal_month := bim_set_of_books.get_fiscal_month(l_SYSDATE - 1, l_org_id);
280: l_fiscal_month_end := bim_set_of_books.get_fiscal_month_end(l_SYSDATE - 1, l_org_id);
281: l_fiscal_month_start := bim_set_of_books.get_fiscal_month_start(l_SYSDATE - 1, l_org_id);
282: l_pre_fiscal_month_end := bim_set_of_books.get_fiscal_month_end(l_fiscal_month_start - 1,l_org_id);
283: l_pre_fiscal_month_start := bim_set_of_books.get_pre_fiscal_month_start(l_SYSDATE - 1, l_org_id);
284: l_fiscal_qtr := bim_set_of_books.get_fiscal_qtr(l_SYSDATE - 1, l_org_id);
285: l_fiscal_qtr_end := bim_set_of_books.get_fiscal_qtr_end(l_SYSDATE - 1, l_org_id);
286: l_fiscal_qtr_start := bim_set_of_books.get_fiscal_qtr_start(l_SYSDATE - 1, l_org_id);
287: l_pre_fiscal_qtr_end := bim_set_of_books.get_fiscal_qtr_end(l_fiscal_qtr_start - 1, l_org_id);

Line 284: l_fiscal_qtr := bim_set_of_books.get_fiscal_qtr(l_SYSDATE - 1, l_org_id);

280: l_fiscal_month_end := bim_set_of_books.get_fiscal_month_end(l_SYSDATE - 1, l_org_id);
281: l_fiscal_month_start := bim_set_of_books.get_fiscal_month_start(l_SYSDATE - 1, l_org_id);
282: l_pre_fiscal_month_end := bim_set_of_books.get_fiscal_month_end(l_fiscal_month_start - 1,l_org_id);
283: l_pre_fiscal_month_start := bim_set_of_books.get_pre_fiscal_month_start(l_SYSDATE - 1, l_org_id);
284: l_fiscal_qtr := bim_set_of_books.get_fiscal_qtr(l_SYSDATE - 1, l_org_id);
285: l_fiscal_qtr_end := bim_set_of_books.get_fiscal_qtr_end(l_SYSDATE - 1, l_org_id);
286: l_fiscal_qtr_start := bim_set_of_books.get_fiscal_qtr_start(l_SYSDATE - 1, l_org_id);
287: l_pre_fiscal_qtr_end := bim_set_of_books.get_fiscal_qtr_end(l_fiscal_qtr_start - 1, l_org_id);
288: l_pre_fiscal_qtr_start := bim_set_of_books.get_pre_fiscal_qtr_start(l_SYSDATE - 1, l_org_id);

Line 285: l_fiscal_qtr_end := bim_set_of_books.get_fiscal_qtr_end(l_SYSDATE - 1, l_org_id);

281: l_fiscal_month_start := bim_set_of_books.get_fiscal_month_start(l_SYSDATE - 1, l_org_id);
282: l_pre_fiscal_month_end := bim_set_of_books.get_fiscal_month_end(l_fiscal_month_start - 1,l_org_id);
283: l_pre_fiscal_month_start := bim_set_of_books.get_pre_fiscal_month_start(l_SYSDATE - 1, l_org_id);
284: l_fiscal_qtr := bim_set_of_books.get_fiscal_qtr(l_SYSDATE - 1, l_org_id);
285: l_fiscal_qtr_end := bim_set_of_books.get_fiscal_qtr_end(l_SYSDATE - 1, l_org_id);
286: l_fiscal_qtr_start := bim_set_of_books.get_fiscal_qtr_start(l_SYSDATE - 1, l_org_id);
287: l_pre_fiscal_qtr_end := bim_set_of_books.get_fiscal_qtr_end(l_fiscal_qtr_start - 1, l_org_id);
288: l_pre_fiscal_qtr_start := bim_set_of_books.get_pre_fiscal_qtr_start(l_SYSDATE - 1, l_org_id);
289: l_fiscal_roll_year_start := bim_set_of_books.get_fiscal_roll_year_start(l_SYSDATE - 1, l_org_id);

Line 286: l_fiscal_qtr_start := bim_set_of_books.get_fiscal_qtr_start(l_SYSDATE - 1, l_org_id);

282: l_pre_fiscal_month_end := bim_set_of_books.get_fiscal_month_end(l_fiscal_month_start - 1,l_org_id);
283: l_pre_fiscal_month_start := bim_set_of_books.get_pre_fiscal_month_start(l_SYSDATE - 1, l_org_id);
284: l_fiscal_qtr := bim_set_of_books.get_fiscal_qtr(l_SYSDATE - 1, l_org_id);
285: l_fiscal_qtr_end := bim_set_of_books.get_fiscal_qtr_end(l_SYSDATE - 1, l_org_id);
286: l_fiscal_qtr_start := bim_set_of_books.get_fiscal_qtr_start(l_SYSDATE - 1, l_org_id);
287: l_pre_fiscal_qtr_end := bim_set_of_books.get_fiscal_qtr_end(l_fiscal_qtr_start - 1, l_org_id);
288: l_pre_fiscal_qtr_start := bim_set_of_books.get_pre_fiscal_qtr_start(l_SYSDATE - 1, l_org_id);
289: l_fiscal_roll_year_start := bim_set_of_books.get_fiscal_roll_year_start(l_SYSDATE - 1, l_org_id);
290: l_fiscal_year := bim_set_of_books.get_fiscal_year(l_SYSDATE - 1, l_org_id);

Line 287: l_pre_fiscal_qtr_end := bim_set_of_books.get_fiscal_qtr_end(l_fiscal_qtr_start - 1, l_org_id);

283: l_pre_fiscal_month_start := bim_set_of_books.get_pre_fiscal_month_start(l_SYSDATE - 1, l_org_id);
284: l_fiscal_qtr := bim_set_of_books.get_fiscal_qtr(l_SYSDATE - 1, l_org_id);
285: l_fiscal_qtr_end := bim_set_of_books.get_fiscal_qtr_end(l_SYSDATE - 1, l_org_id);
286: l_fiscal_qtr_start := bim_set_of_books.get_fiscal_qtr_start(l_SYSDATE - 1, l_org_id);
287: l_pre_fiscal_qtr_end := bim_set_of_books.get_fiscal_qtr_end(l_fiscal_qtr_start - 1, l_org_id);
288: l_pre_fiscal_qtr_start := bim_set_of_books.get_pre_fiscal_qtr_start(l_SYSDATE - 1, l_org_id);
289: l_fiscal_roll_year_start := bim_set_of_books.get_fiscal_roll_year_start(l_SYSDATE - 1, l_org_id);
290: l_fiscal_year := bim_set_of_books.get_fiscal_year(l_SYSDATE - 1, l_org_id);
291: l_fiscal_year_end := bim_set_of_books.get_fiscal_year_end(l_SYSDATE - 1, l_org_id);

Line 288: l_pre_fiscal_qtr_start := bim_set_of_books.get_pre_fiscal_qtr_start(l_SYSDATE - 1, l_org_id);

284: l_fiscal_qtr := bim_set_of_books.get_fiscal_qtr(l_SYSDATE - 1, l_org_id);
285: l_fiscal_qtr_end := bim_set_of_books.get_fiscal_qtr_end(l_SYSDATE - 1, l_org_id);
286: l_fiscal_qtr_start := bim_set_of_books.get_fiscal_qtr_start(l_SYSDATE - 1, l_org_id);
287: l_pre_fiscal_qtr_end := bim_set_of_books.get_fiscal_qtr_end(l_fiscal_qtr_start - 1, l_org_id);
288: l_pre_fiscal_qtr_start := bim_set_of_books.get_pre_fiscal_qtr_start(l_SYSDATE - 1, l_org_id);
289: l_fiscal_roll_year_start := bim_set_of_books.get_fiscal_roll_year_start(l_SYSDATE - 1, l_org_id);
290: l_fiscal_year := bim_set_of_books.get_fiscal_year(l_SYSDATE - 1, l_org_id);
291: l_fiscal_year_end := bim_set_of_books.get_fiscal_year_end(l_SYSDATE - 1, l_org_id);
292: l_fiscal_year_start := bim_set_of_books.get_fiscal_year_start(l_SYSDATE - 1, l_org_id);

Line 289: l_fiscal_roll_year_start := bim_set_of_books.get_fiscal_roll_year_start(l_SYSDATE - 1, l_org_id);

285: l_fiscal_qtr_end := bim_set_of_books.get_fiscal_qtr_end(l_SYSDATE - 1, l_org_id);
286: l_fiscal_qtr_start := bim_set_of_books.get_fiscal_qtr_start(l_SYSDATE - 1, l_org_id);
287: l_pre_fiscal_qtr_end := bim_set_of_books.get_fiscal_qtr_end(l_fiscal_qtr_start - 1, l_org_id);
288: l_pre_fiscal_qtr_start := bim_set_of_books.get_pre_fiscal_qtr_start(l_SYSDATE - 1, l_org_id);
289: l_fiscal_roll_year_start := bim_set_of_books.get_fiscal_roll_year_start(l_SYSDATE - 1, l_org_id);
290: l_fiscal_year := bim_set_of_books.get_fiscal_year(l_SYSDATE - 1, l_org_id);
291: l_fiscal_year_end := bim_set_of_books.get_fiscal_year_end(l_SYSDATE - 1, l_org_id);
292: l_fiscal_year_start := bim_set_of_books.get_fiscal_year_start(l_SYSDATE - 1, l_org_id);
293: l_pre_fiscal_roll_year_start := bim_set_of_books.get_pre_fiscal_roll_year_start(l_SYSDATE - 1,l_org_id);

Line 290: l_fiscal_year := bim_set_of_books.get_fiscal_year(l_SYSDATE - 1, l_org_id);

286: l_fiscal_qtr_start := bim_set_of_books.get_fiscal_qtr_start(l_SYSDATE - 1, l_org_id);
287: l_pre_fiscal_qtr_end := bim_set_of_books.get_fiscal_qtr_end(l_fiscal_qtr_start - 1, l_org_id);
288: l_pre_fiscal_qtr_start := bim_set_of_books.get_pre_fiscal_qtr_start(l_SYSDATE - 1, l_org_id);
289: l_fiscal_roll_year_start := bim_set_of_books.get_fiscal_roll_year_start(l_SYSDATE - 1, l_org_id);
290: l_fiscal_year := bim_set_of_books.get_fiscal_year(l_SYSDATE - 1, l_org_id);
291: l_fiscal_year_end := bim_set_of_books.get_fiscal_year_end(l_SYSDATE - 1, l_org_id);
292: l_fiscal_year_start := bim_set_of_books.get_fiscal_year_start(l_SYSDATE - 1, l_org_id);
293: l_pre_fiscal_roll_year_start := bim_set_of_books.get_pre_fiscal_roll_year_start(l_SYSDATE - 1,l_org_id);
294: -- EXECUTE IMMEDIATE 'TRUNCATE TABLE bim_r_camp_collection';

Line 291: l_fiscal_year_end := bim_set_of_books.get_fiscal_year_end(l_SYSDATE - 1, l_org_id);

287: l_pre_fiscal_qtr_end := bim_set_of_books.get_fiscal_qtr_end(l_fiscal_qtr_start - 1, l_org_id);
288: l_pre_fiscal_qtr_start := bim_set_of_books.get_pre_fiscal_qtr_start(l_SYSDATE - 1, l_org_id);
289: l_fiscal_roll_year_start := bim_set_of_books.get_fiscal_roll_year_start(l_SYSDATE - 1, l_org_id);
290: l_fiscal_year := bim_set_of_books.get_fiscal_year(l_SYSDATE - 1, l_org_id);
291: l_fiscal_year_end := bim_set_of_books.get_fiscal_year_end(l_SYSDATE - 1, l_org_id);
292: l_fiscal_year_start := bim_set_of_books.get_fiscal_year_start(l_SYSDATE - 1, l_org_id);
293: l_pre_fiscal_roll_year_start := bim_set_of_books.get_pre_fiscal_roll_year_start(l_SYSDATE - 1,l_org_id);
294: -- EXECUTE IMMEDIATE 'TRUNCATE TABLE bim_r_camp_collection';
295: /* START OF THE INCREMENT DATA INSERT */

Line 292: l_fiscal_year_start := bim_set_of_books.get_fiscal_year_start(l_SYSDATE - 1, l_org_id);

288: l_pre_fiscal_qtr_start := bim_set_of_books.get_pre_fiscal_qtr_start(l_SYSDATE - 1, l_org_id);
289: l_fiscal_roll_year_start := bim_set_of_books.get_fiscal_roll_year_start(l_SYSDATE - 1, l_org_id);
290: l_fiscal_year := bim_set_of_books.get_fiscal_year(l_SYSDATE - 1, l_org_id);
291: l_fiscal_year_end := bim_set_of_books.get_fiscal_year_end(l_SYSDATE - 1, l_org_id);
292: l_fiscal_year_start := bim_set_of_books.get_fiscal_year_start(l_SYSDATE - 1, l_org_id);
293: l_pre_fiscal_roll_year_start := bim_set_of_books.get_pre_fiscal_roll_year_start(l_SYSDATE - 1,l_org_id);
294: -- EXECUTE IMMEDIATE 'TRUNCATE TABLE bim_r_camp_collection';
295: /* START OF THE INCREMENT DATA INSERT */
296: ams_utility_pvt.write_conc_log('BIM_CAMP_COLLECTION: INCREMENT INSERT START');

Line 293: l_pre_fiscal_roll_year_start := bim_set_of_books.get_pre_fiscal_roll_year_start(l_SYSDATE - 1,l_org_id);

289: l_fiscal_roll_year_start := bim_set_of_books.get_fiscal_roll_year_start(l_SYSDATE - 1, l_org_id);
290: l_fiscal_year := bim_set_of_books.get_fiscal_year(l_SYSDATE - 1, l_org_id);
291: l_fiscal_year_end := bim_set_of_books.get_fiscal_year_end(l_SYSDATE - 1, l_org_id);
292: l_fiscal_year_start := bim_set_of_books.get_fiscal_year_start(l_SYSDATE - 1, l_org_id);
293: l_pre_fiscal_roll_year_start := bim_set_of_books.get_pre_fiscal_roll_year_start(l_SYSDATE - 1,l_org_id);
294: -- EXECUTE IMMEDIATE 'TRUNCATE TABLE bim_r_camp_collection';
295: /* START OF THE INCREMENT DATA INSERT */
296: ams_utility_pvt.write_conc_log('BIM_CAMP_COLLECTION: INCREMENT INSERT START');
297: INSERT INTO /*+ append parallel(i,5) */

Line 2879: l_fiscal_month := bim_set_of_books.get_fiscal_month(l_SYSDATE - 1, l_org_id);

2875: OPEN chk_history_data;
2876: FETCH chk_history_data INTO l_min_start_date;
2877: CLOSE chk_history_data;
2878: l_org_id := 0;
2879: l_fiscal_month := bim_set_of_books.get_fiscal_month(l_SYSDATE - 1, l_org_id);
2880: l_fiscal_month_end := bim_set_of_books.get_fiscal_month_end(l_SYSDATE - 1, l_org_id);
2881: l_fiscal_month_start := bim_set_of_books.get_fiscal_month_start(l_SYSDATE - 1, l_org_id);
2882: l_pre_fiscal_month_end := bim_set_of_books.get_fiscal_month_end(l_fiscal_month_start - 1,l_org_id);
2883: l_pre_fiscal_month_start :=bim_set_of_books.get_pre_fiscal_month_start(l_SYSDATE - 1, l_org_id);

Line 2880: l_fiscal_month_end := bim_set_of_books.get_fiscal_month_end(l_SYSDATE - 1, l_org_id);

2876: FETCH chk_history_data INTO l_min_start_date;
2877: CLOSE chk_history_data;
2878: l_org_id := 0;
2879: l_fiscal_month := bim_set_of_books.get_fiscal_month(l_SYSDATE - 1, l_org_id);
2880: l_fiscal_month_end := bim_set_of_books.get_fiscal_month_end(l_SYSDATE - 1, l_org_id);
2881: l_fiscal_month_start := bim_set_of_books.get_fiscal_month_start(l_SYSDATE - 1, l_org_id);
2882: l_pre_fiscal_month_end := bim_set_of_books.get_fiscal_month_end(l_fiscal_month_start - 1,l_org_id);
2883: l_pre_fiscal_month_start :=bim_set_of_books.get_pre_fiscal_month_start(l_SYSDATE - 1, l_org_id);
2884: l_fiscal_qtr := bim_set_of_books.get_fiscal_qtr(l_SYSDATE - 1, l_org_id);

Line 2881: l_fiscal_month_start := bim_set_of_books.get_fiscal_month_start(l_SYSDATE - 1, l_org_id);

2877: CLOSE chk_history_data;
2878: l_org_id := 0;
2879: l_fiscal_month := bim_set_of_books.get_fiscal_month(l_SYSDATE - 1, l_org_id);
2880: l_fiscal_month_end := bim_set_of_books.get_fiscal_month_end(l_SYSDATE - 1, l_org_id);
2881: l_fiscal_month_start := bim_set_of_books.get_fiscal_month_start(l_SYSDATE - 1, l_org_id);
2882: l_pre_fiscal_month_end := bim_set_of_books.get_fiscal_month_end(l_fiscal_month_start - 1,l_org_id);
2883: l_pre_fiscal_month_start :=bim_set_of_books.get_pre_fiscal_month_start(l_SYSDATE - 1, l_org_id);
2884: l_fiscal_qtr := bim_set_of_books.get_fiscal_qtr(l_SYSDATE - 1, l_org_id);
2885: l_fiscal_qtr_end :=bim_set_of_books.get_fiscal_qtr_end(l_SYSDATE - 1, l_org_id);

Line 2882: l_pre_fiscal_month_end := bim_set_of_books.get_fiscal_month_end(l_fiscal_month_start - 1,l_org_id);

2878: l_org_id := 0;
2879: l_fiscal_month := bim_set_of_books.get_fiscal_month(l_SYSDATE - 1, l_org_id);
2880: l_fiscal_month_end := bim_set_of_books.get_fiscal_month_end(l_SYSDATE - 1, l_org_id);
2881: l_fiscal_month_start := bim_set_of_books.get_fiscal_month_start(l_SYSDATE - 1, l_org_id);
2882: l_pre_fiscal_month_end := bim_set_of_books.get_fiscal_month_end(l_fiscal_month_start - 1,l_org_id);
2883: l_pre_fiscal_month_start :=bim_set_of_books.get_pre_fiscal_month_start(l_SYSDATE - 1, l_org_id);
2884: l_fiscal_qtr := bim_set_of_books.get_fiscal_qtr(l_SYSDATE - 1, l_org_id);
2885: l_fiscal_qtr_end :=bim_set_of_books.get_fiscal_qtr_end(l_SYSDATE - 1, l_org_id);
2886: l_fiscal_qtr_start :=bim_set_of_books.get_fiscal_qtr_start(l_SYSDATE - 1, l_org_id);

Line 2883: l_pre_fiscal_month_start :=bim_set_of_books.get_pre_fiscal_month_start(l_SYSDATE - 1, l_org_id);

2879: l_fiscal_month := bim_set_of_books.get_fiscal_month(l_SYSDATE - 1, l_org_id);
2880: l_fiscal_month_end := bim_set_of_books.get_fiscal_month_end(l_SYSDATE - 1, l_org_id);
2881: l_fiscal_month_start := bim_set_of_books.get_fiscal_month_start(l_SYSDATE - 1, l_org_id);
2882: l_pre_fiscal_month_end := bim_set_of_books.get_fiscal_month_end(l_fiscal_month_start - 1,l_org_id);
2883: l_pre_fiscal_month_start :=bim_set_of_books.get_pre_fiscal_month_start(l_SYSDATE - 1, l_org_id);
2884: l_fiscal_qtr := bim_set_of_books.get_fiscal_qtr(l_SYSDATE - 1, l_org_id);
2885: l_fiscal_qtr_end :=bim_set_of_books.get_fiscal_qtr_end(l_SYSDATE - 1, l_org_id);
2886: l_fiscal_qtr_start :=bim_set_of_books.get_fiscal_qtr_start(l_SYSDATE - 1, l_org_id);
2887: l_pre_fiscal_qtr_end :=bim_set_of_books.get_fiscal_qtr_end(l_fiscal_qtr_start - 1, l_org_id);

Line 2884: l_fiscal_qtr := bim_set_of_books.get_fiscal_qtr(l_SYSDATE - 1, l_org_id);

2880: l_fiscal_month_end := bim_set_of_books.get_fiscal_month_end(l_SYSDATE - 1, l_org_id);
2881: l_fiscal_month_start := bim_set_of_books.get_fiscal_month_start(l_SYSDATE - 1, l_org_id);
2882: l_pre_fiscal_month_end := bim_set_of_books.get_fiscal_month_end(l_fiscal_month_start - 1,l_org_id);
2883: l_pre_fiscal_month_start :=bim_set_of_books.get_pre_fiscal_month_start(l_SYSDATE - 1, l_org_id);
2884: l_fiscal_qtr := bim_set_of_books.get_fiscal_qtr(l_SYSDATE - 1, l_org_id);
2885: l_fiscal_qtr_end :=bim_set_of_books.get_fiscal_qtr_end(l_SYSDATE - 1, l_org_id);
2886: l_fiscal_qtr_start :=bim_set_of_books.get_fiscal_qtr_start(l_SYSDATE - 1, l_org_id);
2887: l_pre_fiscal_qtr_end :=bim_set_of_books.get_fiscal_qtr_end(l_fiscal_qtr_start - 1, l_org_id);
2888: l_pre_fiscal_qtr_start :=bim_set_of_books.get_pre_fiscal_qtr_start(l_SYSDATE - 1, l_org_id);

Line 2885: l_fiscal_qtr_end :=bim_set_of_books.get_fiscal_qtr_end(l_SYSDATE - 1, l_org_id);

2881: l_fiscal_month_start := bim_set_of_books.get_fiscal_month_start(l_SYSDATE - 1, l_org_id);
2882: l_pre_fiscal_month_end := bim_set_of_books.get_fiscal_month_end(l_fiscal_month_start - 1,l_org_id);
2883: l_pre_fiscal_month_start :=bim_set_of_books.get_pre_fiscal_month_start(l_SYSDATE - 1, l_org_id);
2884: l_fiscal_qtr := bim_set_of_books.get_fiscal_qtr(l_SYSDATE - 1, l_org_id);
2885: l_fiscal_qtr_end :=bim_set_of_books.get_fiscal_qtr_end(l_SYSDATE - 1, l_org_id);
2886: l_fiscal_qtr_start :=bim_set_of_books.get_fiscal_qtr_start(l_SYSDATE - 1, l_org_id);
2887: l_pre_fiscal_qtr_end :=bim_set_of_books.get_fiscal_qtr_end(l_fiscal_qtr_start - 1, l_org_id);
2888: l_pre_fiscal_qtr_start :=bim_set_of_books.get_pre_fiscal_qtr_start(l_SYSDATE - 1, l_org_id);
2889: l_fiscal_roll_year_start :=bim_set_of_books.get_fiscal_roll_year_start(l_SYSDATE - 1, l_org_id);

Line 2886: l_fiscal_qtr_start :=bim_set_of_books.get_fiscal_qtr_start(l_SYSDATE - 1, l_org_id);

2882: l_pre_fiscal_month_end := bim_set_of_books.get_fiscal_month_end(l_fiscal_month_start - 1,l_org_id);
2883: l_pre_fiscal_month_start :=bim_set_of_books.get_pre_fiscal_month_start(l_SYSDATE - 1, l_org_id);
2884: l_fiscal_qtr := bim_set_of_books.get_fiscal_qtr(l_SYSDATE - 1, l_org_id);
2885: l_fiscal_qtr_end :=bim_set_of_books.get_fiscal_qtr_end(l_SYSDATE - 1, l_org_id);
2886: l_fiscal_qtr_start :=bim_set_of_books.get_fiscal_qtr_start(l_SYSDATE - 1, l_org_id);
2887: l_pre_fiscal_qtr_end :=bim_set_of_books.get_fiscal_qtr_end(l_fiscal_qtr_start - 1, l_org_id);
2888: l_pre_fiscal_qtr_start :=bim_set_of_books.get_pre_fiscal_qtr_start(l_SYSDATE - 1, l_org_id);
2889: l_fiscal_roll_year_start :=bim_set_of_books.get_fiscal_roll_year_start(l_SYSDATE - 1, l_org_id);
2890: l_fiscal_year := bim_set_of_books.get_fiscal_year(l_SYSDATE - 1, l_org_id);

Line 2887: l_pre_fiscal_qtr_end :=bim_set_of_books.get_fiscal_qtr_end(l_fiscal_qtr_start - 1, l_org_id);

2883: l_pre_fiscal_month_start :=bim_set_of_books.get_pre_fiscal_month_start(l_SYSDATE - 1, l_org_id);
2884: l_fiscal_qtr := bim_set_of_books.get_fiscal_qtr(l_SYSDATE - 1, l_org_id);
2885: l_fiscal_qtr_end :=bim_set_of_books.get_fiscal_qtr_end(l_SYSDATE - 1, l_org_id);
2886: l_fiscal_qtr_start :=bim_set_of_books.get_fiscal_qtr_start(l_SYSDATE - 1, l_org_id);
2887: l_pre_fiscal_qtr_end :=bim_set_of_books.get_fiscal_qtr_end(l_fiscal_qtr_start - 1, l_org_id);
2888: l_pre_fiscal_qtr_start :=bim_set_of_books.get_pre_fiscal_qtr_start(l_SYSDATE - 1, l_org_id);
2889: l_fiscal_roll_year_start :=bim_set_of_books.get_fiscal_roll_year_start(l_SYSDATE - 1, l_org_id);
2890: l_fiscal_year := bim_set_of_books.get_fiscal_year(l_SYSDATE - 1, l_org_id);
2891: l_fiscal_year_end :=bim_set_of_books.get_fiscal_year_end(l_SYSDATE - 1, l_org_id);

Line 2888: l_pre_fiscal_qtr_start :=bim_set_of_books.get_pre_fiscal_qtr_start(l_SYSDATE - 1, l_org_id);

2884: l_fiscal_qtr := bim_set_of_books.get_fiscal_qtr(l_SYSDATE - 1, l_org_id);
2885: l_fiscal_qtr_end :=bim_set_of_books.get_fiscal_qtr_end(l_SYSDATE - 1, l_org_id);
2886: l_fiscal_qtr_start :=bim_set_of_books.get_fiscal_qtr_start(l_SYSDATE - 1, l_org_id);
2887: l_pre_fiscal_qtr_end :=bim_set_of_books.get_fiscal_qtr_end(l_fiscal_qtr_start - 1, l_org_id);
2888: l_pre_fiscal_qtr_start :=bim_set_of_books.get_pre_fiscal_qtr_start(l_SYSDATE - 1, l_org_id);
2889: l_fiscal_roll_year_start :=bim_set_of_books.get_fiscal_roll_year_start(l_SYSDATE - 1, l_org_id);
2890: l_fiscal_year := bim_set_of_books.get_fiscal_year(l_SYSDATE - 1, l_org_id);
2891: l_fiscal_year_end :=bim_set_of_books.get_fiscal_year_end(l_SYSDATE - 1, l_org_id);
2892: l_fiscal_year_start :=bim_set_of_books.get_fiscal_year_start(l_SYSDATE - 1, l_org_id);

Line 2889: l_fiscal_roll_year_start :=bim_set_of_books.get_fiscal_roll_year_start(l_SYSDATE - 1, l_org_id);

2885: l_fiscal_qtr_end :=bim_set_of_books.get_fiscal_qtr_end(l_SYSDATE - 1, l_org_id);
2886: l_fiscal_qtr_start :=bim_set_of_books.get_fiscal_qtr_start(l_SYSDATE - 1, l_org_id);
2887: l_pre_fiscal_qtr_end :=bim_set_of_books.get_fiscal_qtr_end(l_fiscal_qtr_start - 1, l_org_id);
2888: l_pre_fiscal_qtr_start :=bim_set_of_books.get_pre_fiscal_qtr_start(l_SYSDATE - 1, l_org_id);
2889: l_fiscal_roll_year_start :=bim_set_of_books.get_fiscal_roll_year_start(l_SYSDATE - 1, l_org_id);
2890: l_fiscal_year := bim_set_of_books.get_fiscal_year(l_SYSDATE - 1, l_org_id);
2891: l_fiscal_year_end :=bim_set_of_books.get_fiscal_year_end(l_SYSDATE - 1, l_org_id);
2892: l_fiscal_year_start :=bim_set_of_books.get_fiscal_year_start(l_SYSDATE - 1, l_org_id);
2893: l_pre_fiscal_roll_year_start :=bim_set_of_books.get_pre_fiscal_roll_year_start(l_SYSDATE - 1,l_org_id);

Line 2890: l_fiscal_year := bim_set_of_books.get_fiscal_year(l_SYSDATE - 1, l_org_id);

2886: l_fiscal_qtr_start :=bim_set_of_books.get_fiscal_qtr_start(l_SYSDATE - 1, l_org_id);
2887: l_pre_fiscal_qtr_end :=bim_set_of_books.get_fiscal_qtr_end(l_fiscal_qtr_start - 1, l_org_id);
2888: l_pre_fiscal_qtr_start :=bim_set_of_books.get_pre_fiscal_qtr_start(l_SYSDATE - 1, l_org_id);
2889: l_fiscal_roll_year_start :=bim_set_of_books.get_fiscal_roll_year_start(l_SYSDATE - 1, l_org_id);
2890: l_fiscal_year := bim_set_of_books.get_fiscal_year(l_SYSDATE - 1, l_org_id);
2891: l_fiscal_year_end :=bim_set_of_books.get_fiscal_year_end(l_SYSDATE - 1, l_org_id);
2892: l_fiscal_year_start :=bim_set_of_books.get_fiscal_year_start(l_SYSDATE - 1, l_org_id);
2893: l_pre_fiscal_roll_year_start :=bim_set_of_books.get_pre_fiscal_roll_year_start(l_SYSDATE - 1,l_org_id);
2894: --commit;

Line 2891: l_fiscal_year_end :=bim_set_of_books.get_fiscal_year_end(l_SYSDATE - 1, l_org_id);

2887: l_pre_fiscal_qtr_end :=bim_set_of_books.get_fiscal_qtr_end(l_fiscal_qtr_start - 1, l_org_id);
2888: l_pre_fiscal_qtr_start :=bim_set_of_books.get_pre_fiscal_qtr_start(l_SYSDATE - 1, l_org_id);
2889: l_fiscal_roll_year_start :=bim_set_of_books.get_fiscal_roll_year_start(l_SYSDATE - 1, l_org_id);
2890: l_fiscal_year := bim_set_of_books.get_fiscal_year(l_SYSDATE - 1, l_org_id);
2891: l_fiscal_year_end :=bim_set_of_books.get_fiscal_year_end(l_SYSDATE - 1, l_org_id);
2892: l_fiscal_year_start :=bim_set_of_books.get_fiscal_year_start(l_SYSDATE - 1, l_org_id);
2893: l_pre_fiscal_roll_year_start :=bim_set_of_books.get_pre_fiscal_roll_year_start(l_SYSDATE - 1,l_org_id);
2894: --commit;
2895: --EXECUTE IMMEDIATE 'TRUNCATE TABLE bim_r_camp_collection';

Line 2892: l_fiscal_year_start :=bim_set_of_books.get_fiscal_year_start(l_SYSDATE - 1, l_org_id);

2888: l_pre_fiscal_qtr_start :=bim_set_of_books.get_pre_fiscal_qtr_start(l_SYSDATE - 1, l_org_id);
2889: l_fiscal_roll_year_start :=bim_set_of_books.get_fiscal_roll_year_start(l_SYSDATE - 1, l_org_id);
2890: l_fiscal_year := bim_set_of_books.get_fiscal_year(l_SYSDATE - 1, l_org_id);
2891: l_fiscal_year_end :=bim_set_of_books.get_fiscal_year_end(l_SYSDATE - 1, l_org_id);
2892: l_fiscal_year_start :=bim_set_of_books.get_fiscal_year_start(l_SYSDATE - 1, l_org_id);
2893: l_pre_fiscal_roll_year_start :=bim_set_of_books.get_pre_fiscal_roll_year_start(l_SYSDATE - 1,l_org_id);
2894: --commit;
2895: --EXECUTE IMMEDIATE 'TRUNCATE TABLE bim_r_camp_collection';
2896: /* START OF THE INCREMENT DATA FIRST INSERT */

Line 2893: l_pre_fiscal_roll_year_start :=bim_set_of_books.get_pre_fiscal_roll_year_start(l_SYSDATE - 1,l_org_id);

2889: l_fiscal_roll_year_start :=bim_set_of_books.get_fiscal_roll_year_start(l_SYSDATE - 1, l_org_id);
2890: l_fiscal_year := bim_set_of_books.get_fiscal_year(l_SYSDATE - 1, l_org_id);
2891: l_fiscal_year_end :=bim_set_of_books.get_fiscal_year_end(l_SYSDATE - 1, l_org_id);
2892: l_fiscal_year_start :=bim_set_of_books.get_fiscal_year_start(l_SYSDATE - 1, l_org_id);
2893: l_pre_fiscal_roll_year_start :=bim_set_of_books.get_pre_fiscal_roll_year_start(l_SYSDATE - 1,l_org_id);
2894: --commit;
2895: --EXECUTE IMMEDIATE 'TRUNCATE TABLE bim_r_camp_collection';
2896: /* START OF THE INCREMENT DATA FIRST INSERT */
2897: ams_utility_pvt.write_conc_log('BIM_CAMP_COLLECTION: INCREMENT FIRST INSERT START');