APPS.GL_PERIODS_PKG dependencies on AR_PERIOD_TYPES

Line 15: FROM ar_period_types

11: old_len NUMBER,
12: new_len NUMBER) IS
13: CURSOR get_max IS
14: SELECT nvl(max_regular_period_length,0)
15: FROM ar_period_types
16: WHERE period_type = per_type;
17: max_len NUMBER;
18: tmp_len NUMBER;
19:

Line 37: INSERT into ar_period_types

33: IF get_max%NOTFOUND THEN
34: CLOSE get_max;
35:
36: max_len := new_len;
37: INSERT into ar_period_types
38: (period_type, max_regular_period_length)
39: VALUES (per_type, max_len);
40:
41: -- Not the first period

Line 50: UPDATE ar_period_types

46: IF ( (call_mode IN ('I', 'U'))
47: AND (max_len < new_len)) THEN
48:
49: max_len := new_len;
50: UPDATE ar_period_types
51: SET max_regular_period_length = max_len
52: WHERE period_type = per_type;
53: END IF;
54:

Line 81: UPDATE ar_period_types pt

77: -- No other periods with this maximum length.
78: -- Thus, we give up and search for the new maximum
79: -- Note that if there are no other periods, the max
80: -- will be set to null
81: UPDATE ar_period_types pt
82: SET pt.max_regular_period_length =
83: (SELECT decode(call_mode,
84: 'D',max(end_date - start_date) + 1,
85: 'U',greatest(new_len, nvl(max(end_date-start_date)+1,0)))