APPS.ISC_DBI_REV_CUM_TREND_PKG dependencies on FII_TIME_API

Line 98: l_curr_start := fii_time_api.ent_cyr_start(l_as_of_date);

94:
95: IF l_period_type = 'FII_TIME_ENT_YEAR' THEN
96: l_adjust1 := NULL;
97: l_adjust2 := NULL;
98: l_curr_start := fii_time_api.ent_cyr_start(l_as_of_date);
99: l_curr_end := fii_time_api.ent_cyr_end(l_as_of_date);
100: l_prior_start := fii_time_api.ent_cyr_start(l_prev_asof);
101: l_prior_end := fii_time_api.ent_cyr_end(l_prev_asof);
102: l_temp := fii_time_api.ent_cper_end(l_as_of_date);

Line 99: l_curr_end := fii_time_api.ent_cyr_end(l_as_of_date);

95: IF l_period_type = 'FII_TIME_ENT_YEAR' THEN
96: l_adjust1 := NULL;
97: l_adjust2 := NULL;
98: l_curr_start := fii_time_api.ent_cyr_start(l_as_of_date);
99: l_curr_end := fii_time_api.ent_cyr_end(l_as_of_date);
100: l_prior_start := fii_time_api.ent_cyr_start(l_prev_asof);
101: l_prior_end := fii_time_api.ent_cyr_end(l_prev_asof);
102: l_temp := fii_time_api.ent_cper_end(l_as_of_date);
103:

Line 100: l_prior_start := fii_time_api.ent_cyr_start(l_prev_asof);

96: l_adjust1 := NULL;
97: l_adjust2 := NULL;
98: l_curr_start := fii_time_api.ent_cyr_start(l_as_of_date);
99: l_curr_end := fii_time_api.ent_cyr_end(l_as_of_date);
100: l_prior_start := fii_time_api.ent_cyr_start(l_prev_asof);
101: l_prior_end := fii_time_api.ent_cyr_end(l_prev_asof);
102: l_temp := fii_time_api.ent_cper_end(l_as_of_date);
103:
104: ELSIF l_period_type = 'FII_TIME_ENT_QTR' THEN

Line 101: l_prior_end := fii_time_api.ent_cyr_end(l_prev_asof);

97: l_adjust2 := NULL;
98: l_curr_start := fii_time_api.ent_cyr_start(l_as_of_date);
99: l_curr_end := fii_time_api.ent_cyr_end(l_as_of_date);
100: l_prior_start := fii_time_api.ent_cyr_start(l_prev_asof);
101: l_prior_end := fii_time_api.ent_cyr_end(l_prev_asof);
102: l_temp := fii_time_api.ent_cper_end(l_as_of_date);
103:
104: ELSIF l_period_type = 'FII_TIME_ENT_QTR' THEN
105: l_adjust1 := ':ISC_CURR_START-:ISC_CURR_END';

Line 102: l_temp := fii_time_api.ent_cper_end(l_as_of_date);

98: l_curr_start := fii_time_api.ent_cyr_start(l_as_of_date);
99: l_curr_end := fii_time_api.ent_cyr_end(l_as_of_date);
100: l_prior_start := fii_time_api.ent_cyr_start(l_prev_asof);
101: l_prior_end := fii_time_api.ent_cyr_end(l_prev_asof);
102: l_temp := fii_time_api.ent_cper_end(l_as_of_date);
103:
104: ELSIF l_period_type = 'FII_TIME_ENT_QTR' THEN
105: l_adjust1 := ':ISC_CURR_START-:ISC_CURR_END';
106: l_adjust2 := ':ISC_PRIOR_START-:ISC_PRIOR_END';

Line 107: l_curr_start := fii_time_api.ent_cqtr_start(l_as_of_date);

103:
104: ELSIF l_period_type = 'FII_TIME_ENT_QTR' THEN
105: l_adjust1 := ':ISC_CURR_START-:ISC_CURR_END';
106: l_adjust2 := ':ISC_PRIOR_START-:ISC_PRIOR_END';
107: l_curr_start := fii_time_api.ent_cqtr_start(l_as_of_date);
108: l_curr_end := fii_time_api.ent_cqtr_end(l_as_of_date);
109: l_prior_start := fii_time_api.ent_cqtr_start(l_prev_asof);
110: l_prior_end := fii_time_api.ent_cqtr_end(l_prev_asof);
111: l_temp := NULL;

Line 108: l_curr_end := fii_time_api.ent_cqtr_end(l_as_of_date);

104: ELSIF l_period_type = 'FII_TIME_ENT_QTR' THEN
105: l_adjust1 := ':ISC_CURR_START-:ISC_CURR_END';
106: l_adjust2 := ':ISC_PRIOR_START-:ISC_PRIOR_END';
107: l_curr_start := fii_time_api.ent_cqtr_start(l_as_of_date);
108: l_curr_end := fii_time_api.ent_cqtr_end(l_as_of_date);
109: l_prior_start := fii_time_api.ent_cqtr_start(l_prev_asof);
110: l_prior_end := fii_time_api.ent_cqtr_end(l_prev_asof);
111: l_temp := NULL;
112:

Line 109: l_prior_start := fii_time_api.ent_cqtr_start(l_prev_asof);

105: l_adjust1 := ':ISC_CURR_START-:ISC_CURR_END';
106: l_adjust2 := ':ISC_PRIOR_START-:ISC_PRIOR_END';
107: l_curr_start := fii_time_api.ent_cqtr_start(l_as_of_date);
108: l_curr_end := fii_time_api.ent_cqtr_end(l_as_of_date);
109: l_prior_start := fii_time_api.ent_cqtr_start(l_prev_asof);
110: l_prior_end := fii_time_api.ent_cqtr_end(l_prev_asof);
111: l_temp := NULL;
112:
113: ELSIF l_period_type = 'FII_TIME_ENT_PERIOD' THEN

Line 110: l_prior_end := fii_time_api.ent_cqtr_end(l_prev_asof);

106: l_adjust2 := ':ISC_PRIOR_START-:ISC_PRIOR_END';
107: l_curr_start := fii_time_api.ent_cqtr_start(l_as_of_date);
108: l_curr_end := fii_time_api.ent_cqtr_end(l_as_of_date);
109: l_prior_start := fii_time_api.ent_cqtr_start(l_prev_asof);
110: l_prior_end := fii_time_api.ent_cqtr_end(l_prev_asof);
111: l_temp := NULL;
112:
113: ELSIF l_period_type = 'FII_TIME_ENT_PERIOD' THEN
114: l_adjust1 := '1';

Line 116: l_curr_start := fii_time_api.ent_cper_start(l_as_of_date);

112:
113: ELSIF l_period_type = 'FII_TIME_ENT_PERIOD' THEN
114: l_adjust1 := '1';
115: l_adjust2 := '1';
116: l_curr_start := fii_time_api.ent_cper_start(l_as_of_date);
117: l_curr_end := fii_time_api.ent_cper_end(l_as_of_date);
118: l_prior_start := fii_time_api.ent_cper_start(l_prev_asof);
119: l_prior_end := fii_time_api.ent_cper_end(l_prev_asof);
120: l_temp := NULL;

Line 117: l_curr_end := fii_time_api.ent_cper_end(l_as_of_date);

113: ELSIF l_period_type = 'FII_TIME_ENT_PERIOD' THEN
114: l_adjust1 := '1';
115: l_adjust2 := '1';
116: l_curr_start := fii_time_api.ent_cper_start(l_as_of_date);
117: l_curr_end := fii_time_api.ent_cper_end(l_as_of_date);
118: l_prior_start := fii_time_api.ent_cper_start(l_prev_asof);
119: l_prior_end := fii_time_api.ent_cper_end(l_prev_asof);
120: l_temp := NULL;
121:

Line 118: l_prior_start := fii_time_api.ent_cper_start(l_prev_asof);

114: l_adjust1 := '1';
115: l_adjust2 := '1';
116: l_curr_start := fii_time_api.ent_cper_start(l_as_of_date);
117: l_curr_end := fii_time_api.ent_cper_end(l_as_of_date);
118: l_prior_start := fii_time_api.ent_cper_start(l_prev_asof);
119: l_prior_end := fii_time_api.ent_cper_end(l_prev_asof);
120: l_temp := NULL;
121:
122: ELSE -- l_period_type = 'FII_TIME_WEEK'

Line 119: l_prior_end := fii_time_api.ent_cper_end(l_prev_asof);

115: l_adjust2 := '1';
116: l_curr_start := fii_time_api.ent_cper_start(l_as_of_date);
117: l_curr_end := fii_time_api.ent_cper_end(l_as_of_date);
118: l_prior_start := fii_time_api.ent_cper_start(l_prev_asof);
119: l_prior_end := fii_time_api.ent_cper_end(l_prev_asof);
120: l_temp := NULL;
121:
122: ELSE -- l_period_type = 'FII_TIME_WEEK'
123: l_adjust1 := '1';

Line 125: l_curr_start := fii_time_api.cwk_start(l_as_of_date);

121:
122: ELSE -- l_period_type = 'FII_TIME_WEEK'
123: l_adjust1 := '1';
124: l_adjust2 := '1';
125: l_curr_start := fii_time_api.cwk_start(l_as_of_date);
126: l_curr_end := fii_time_api.cwk_end(l_as_of_date);
127: l_prior_start := fii_time_api.cwk_start(l_prev_asof);
128: l_prior_end := fii_time_api.cwk_end(l_prev_asof);
129: l_temp := NULL;

Line 126: l_curr_end := fii_time_api.cwk_end(l_as_of_date);

122: ELSE -- l_period_type = 'FII_TIME_WEEK'
123: l_adjust1 := '1';
124: l_adjust2 := '1';
125: l_curr_start := fii_time_api.cwk_start(l_as_of_date);
126: l_curr_end := fii_time_api.cwk_end(l_as_of_date);
127: l_prior_start := fii_time_api.cwk_start(l_prev_asof);
128: l_prior_end := fii_time_api.cwk_end(l_prev_asof);
129: l_temp := NULL;
130:

Line 127: l_prior_start := fii_time_api.cwk_start(l_prev_asof);

123: l_adjust1 := '1';
124: l_adjust2 := '1';
125: l_curr_start := fii_time_api.cwk_start(l_as_of_date);
126: l_curr_end := fii_time_api.cwk_end(l_as_of_date);
127: l_prior_start := fii_time_api.cwk_start(l_prev_asof);
128: l_prior_end := fii_time_api.cwk_end(l_prev_asof);
129: l_temp := NULL;
130:
131: END IF;

Line 128: l_prior_end := fii_time_api.cwk_end(l_prev_asof);

124: l_adjust2 := '1';
125: l_curr_start := fii_time_api.cwk_start(l_as_of_date);
126: l_curr_end := fii_time_api.cwk_end(l_as_of_date);
127: l_prior_start := fii_time_api.cwk_start(l_prev_asof);
128: l_prior_end := fii_time_api.cwk_end(l_prev_asof);
129: l_temp := NULL;
130:
131: END IF;
132: