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.GL_PERIODS_PKG dependencies on AR_PERIODS

Line 97: PROCEDURE fix_ar_periods(call_mode VARCHAR2,

93: END IF;
94: END fix_max_len;
95:
96:
97: PROCEDURE fix_ar_periods(call_mode VARCHAR2,
98: cal_name VARCHAR2,
99: per_type VARCHAR2,
100: new_start_date DATE,
101: new_end_date DATE,

Line 107: FROM ar_periods

103: old_per_name VARCHAR2,
104: old_start_date DATE) IS
105: CURSOR get_new_pos IS
106: SELECT nvl(max(new_period_num + 1), 1)
107: FROM ar_periods
108: WHERE period_set_name = cal_name
109: AND period_type = per_type
110: AND start_date < new_start_date;
111:

Line 114: FROM ar_periods

110: AND start_date < new_start_date;
111:
112: CURSOR get_old_pos IS
113: SELECT new_period_num
114: FROM ar_periods
115: WHERE period_set_name = cal_name
116: AND period_type = per_type
117: AND period_name = old_per_name;
118:

Line 134: UPDATE ar_periods

130: CLOSE get_new_pos;
131:
132: -- Increase the AR period number of all
133: -- periods after it
134: UPDATE ar_periods
135: SET new_period_num = new_period_num + 1
136: WHERE period_set_name = cal_name
137: AND period_type = per_type
138: AND new_period_num >= new_pos;

Line 141: INSERT INTO ar_periods

137: AND period_type = per_type
138: AND new_period_num >= new_pos;
139:
140: -- Insert the new period
141: INSERT INTO ar_periods
142: (period_set_name, period_type, start_date, end_date,
143: new_period_num, period_name)
144: VALUES
145: (cal_name, per_type, new_start_date, new_end_date,

Line 191: UPDATE ar_periods

187: IF (old_pos <> new_pos) THEN
188:
189: -- Update the changed periods AR period number to null, so that
190: -- we can change the AR period number of the other periods
191: UPDATE ar_periods
192: SET new_period_num = NULL
193: WHERE period_set_name = cal_name
194: AND period_type = per_type
195: AND period_name = old_per_name;

Line 199: UPDATE ar_periods

195: AND period_name = old_per_name;
196:
197: IF (new_pos < old_pos) THEN
198: -- Moving the period earlier
199: UPDATE ar_periods
200: SET new_period_num = new_period_num + 1
201: WHERE period_set_name = cal_name
202: AND period_type = per_type
203: AND new_period_num BETWEEN new_pos AND old_pos;

Line 207: UPDATE ar_periods

203: AND new_period_num BETWEEN new_pos AND old_pos;
204:
205: ELSE
206: -- Moving the period later
207: UPDATE ar_periods
208: SET new_period_num = new_period_num - 1
209: WHERE period_set_name = cal_name
210: AND period_type = per_type
211: AND new_period_num BETWEEN old_pos AND new_pos;

Line 216: UPDATE ar_periods

212: END IF;
213:
214: -- Move the period to its new position. Also fix everything
215: -- else
216: UPDATE ar_periods
217: SET start_date = new_start_date,
218: end_date = new_end_date,
219: period_name = new_per_name,
220: new_period_num = new_pos

Line 227: UPDATE ar_periods

223: AND period_name = old_per_name;
224:
225: ELSE
226: -- The AR period number isn't changing, but fix everything else
227: UPDATE ar_periods
228: SET start_date = new_start_date,
229: end_date = new_end_date,
230: period_name = new_per_name
231: WHERE period_set_name = cal_name

Line 249: DELETE ar_periods

245: CLOSE get_old_pos;
246: END IF;
247:
248: -- Delete the old period
249: DELETE ar_periods
250: WHERE period_set_name = cal_name
251: AND period_type = per_type
252: AND period_name = old_per_name;
253:

Line 256: UPDATE ar_periods

252: AND period_name = old_per_name;
253:
254: -- Decrease the AR period number of all
255: -- periods after it
256: UPDATE ar_periods
257: SET new_period_num = new_period_num - 1
258: WHERE period_set_name = cal_name
259: AND period_type = per_type
260: AND new_period_num > old_pos;

Line 264: END fix_ar_periods;

260: AND new_period_num > old_pos;
261:
262: END IF;
263:
264: END fix_ar_periods;
265:
266:
267: --
268: -- PUBLIC FUNCTIONS

Line 758: -- Insert the new row into ar_periods

754:
755: -- Reset the maximum length, if necessary
756: fix_max_len('I', X_Period_Type, NULL, NULL, X_End_Date - X_Start_Date + 1);
757:
758: -- Insert the new row into ar_periods
759: fix_ar_periods('I', X_Period_Set_Name, X_Period_Type, X_Start_Date,
760: X_End_Date, X_Period_Name, NULL, NULL);
761:
762: END IF;

Line 759: fix_ar_periods('I', X_Period_Set_Name, X_Period_Type, X_Start_Date,

755: -- Reset the maximum length, if necessary
756: fix_max_len('I', X_Period_Type, NULL, NULL, X_End_Date - X_Start_Date + 1);
757:
758: -- Insert the new row into ar_periods
759: fix_ar_periods('I', X_Period_Set_Name, X_Period_Type, X_Start_Date,
760: X_End_Date, X_Period_Name, NULL, NULL);
761:
762: END IF;
763:

Line 1080: -- Update the row in ar_periods

1076: -- Reset the maximum length, if necessary
1077: fix_max_len('U', X_Period_Type, X_rowid,
1078: x_end_date_old - x_start_date_old + 1,
1079: X_End_Date - X_Start_Date + 1);
1080: -- Update the row in ar_periods
1081: fix_ar_periods('U', X_Period_Set_Name, X_Period_Type, X_Start_Date,
1082: X_End_Date, X_Period_Name, X_period_name_old,
1083: x_start_date_old);
1084: ELSE

Line 1081: fix_ar_periods('U', X_Period_Set_Name, X_Period_Type, X_Start_Date,

1077: fix_max_len('U', X_Period_Type, X_rowid,
1078: x_end_date_old - x_start_date_old + 1,
1079: X_End_Date - X_Start_Date + 1);
1080: -- Update the row in ar_periods
1081: fix_ar_periods('U', X_Period_Set_Name, X_Period_Type, X_Start_Date,
1082: X_End_Date, X_Period_Name, X_period_name_old,
1083: x_start_date_old);
1084: ELSE
1085: -- Reset the maximum length, if necessary

Line 1087: -- Insert the row into ar_periods

1083: x_start_date_old);
1084: ELSE
1085: -- Reset the maximum length, if necessary
1086: fix_max_len('I', X_Period_Type, NULL,NULL, X_End_Date - X_Start_Date + 1);
1087: -- Insert the row into ar_periods
1088: fix_ar_periods('I', X_Period_Set_Name, X_Period_Type, X_Start_Date,
1089: X_End_Date, X_Period_Name, NULL, NULL);
1090: END IF;
1091: ELSE

Line 1088: fix_ar_periods('I', X_Period_Set_Name, X_Period_Type, X_Start_Date,

1084: ELSE
1085: -- Reset the maximum length, if necessary
1086: fix_max_len('I', X_Period_Type, NULL,NULL, X_End_Date - X_Start_Date + 1);
1087: -- Insert the row into ar_periods
1088: fix_ar_periods('I', X_Period_Set_Name, X_Period_Type, X_Start_Date,
1089: X_End_Date, X_Period_Name, NULL, NULL);
1090: END IF;
1091: ELSE
1092: IF (x_adj_flag_old = 'N') THEN

Line 1097: -- Delete the row from ar_periods

1093: -- Reset the maximum length, if necessary
1094: fix_max_len('D', X_Period_Type, X_rowid,
1095: x_end_date_old - x_start_date_old + 1,
1096: NULL);
1097: -- Delete the row from ar_periods
1098: fix_ar_periods('D', X_Period_Set_Name, X_Period_Type, NULL, NULL, NULL,
1099: x_period_name_old, x_start_date_old);
1100: END IF;
1101: END IF;

Line 1098: fix_ar_periods('D', X_Period_Set_Name, X_Period_Type, NULL, NULL, NULL,

1094: fix_max_len('D', X_Period_Type, X_rowid,
1095: x_end_date_old - x_start_date_old + 1,
1096: NULL);
1097: -- Delete the row from ar_periods
1098: fix_ar_periods('D', X_Period_Set_Name, X_Period_Type, NULL, NULL, NULL,
1099: x_period_name_old, x_start_date_old);
1100: END IF;
1101: END IF;
1102:

Line 1223: -- Delete the row from ar_periods

1219: -- Reset the maximum length, if necessary
1220: fix_max_len('D', X_Period_Type, x_rowid,
1221: x_end_date_old - x_start_date_old + 1,
1222: NULL);
1223: -- Delete the row from ar_periods
1224: fix_ar_periods('D', X_Period_Set_Name, X_Period_Type, NULL, NULL, NULL,
1225: x_period_name_old, x_start_date_old);
1226: END IF;
1227:

Line 1224: fix_ar_periods('D', X_Period_Set_Name, X_Period_Type, NULL, NULL, NULL,

1220: fix_max_len('D', X_Period_Type, x_rowid,
1221: x_end_date_old - x_start_date_old + 1,
1222: NULL);
1223: -- Delete the row from ar_periods
1224: fix_ar_periods('D', X_Period_Set_Name, X_Period_Type, NULL, NULL, NULL,
1225: x_period_name_old, x_start_date_old);
1226: END IF;
1227:
1228: DELETE FROM GL_PERIODS