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.PJI_PMV_ENGINE dependencies on FII_TIME_API

Line 68: RETURN to_char(FII_TIME_API.ent_sd_lyr_end(to_date(p_As_Of_Date,'j')),'j');

64: IF l_Calendar_Id IS NULL THEN
65: CASE p_Comparator
66: WHEN 'SEQUENTIAL' THEN
67: IF p_Period_Type LIKE '%YEAR%' THEN
68: RETURN to_char(FII_TIME_API.ent_sd_lyr_end(to_date(p_As_Of_Date,'j')),'j');
69: ELSIF p_Period_Type LIKE '%QTR%' THEN
70: RETURN to_char(FII_TIME_API.ent_sd_pqtr_end(to_date(p_As_Of_Date,'j')),'j');
71: ELSIF p_Period_Type LIKE '%PERIOD%' THEN
72: RETURN to_char(FII_TIME_API.ent_sd_pper_end(to_date(p_As_Of_Date,'j')),'j');

Line 70: RETURN to_char(FII_TIME_API.ent_sd_pqtr_end(to_date(p_As_Of_Date,'j')),'j');

66: WHEN 'SEQUENTIAL' THEN
67: IF p_Period_Type LIKE '%YEAR%' THEN
68: RETURN to_char(FII_TIME_API.ent_sd_lyr_end(to_date(p_As_Of_Date,'j')),'j');
69: ELSIF p_Period_Type LIKE '%QTR%' THEN
70: RETURN to_char(FII_TIME_API.ent_sd_pqtr_end(to_date(p_As_Of_Date,'j')),'j');
71: ELSIF p_Period_Type LIKE '%PERIOD%' THEN
72: RETURN to_char(FII_TIME_API.ent_sd_pper_end(to_date(p_As_Of_Date,'j')),'j');
73: ELSIF p_Period_Type LIKE '%WEEK%' THEN
74: RETURN to_char(FII_TIME_API.sd_pwk(to_date(p_As_Of_Date,'j')),'j');

Line 72: RETURN to_char(FII_TIME_API.ent_sd_pper_end(to_date(p_As_Of_Date,'j')),'j');

68: RETURN to_char(FII_TIME_API.ent_sd_lyr_end(to_date(p_As_Of_Date,'j')),'j');
69: ELSIF p_Period_Type LIKE '%QTR%' THEN
70: RETURN to_char(FII_TIME_API.ent_sd_pqtr_end(to_date(p_As_Of_Date,'j')),'j');
71: ELSIF p_Period_Type LIKE '%PERIOD%' THEN
72: RETURN to_char(FII_TIME_API.ent_sd_pper_end(to_date(p_As_Of_Date,'j')),'j');
73: ELSIF p_Period_Type LIKE '%WEEK%' THEN
74: RETURN to_char(FII_TIME_API.sd_pwk(to_date(p_As_Of_Date,'j')),'j');
75: END IF;
76: WHEN 'YEARLY' THEN

Line 74: RETURN to_char(FII_TIME_API.sd_pwk(to_date(p_As_Of_Date,'j')),'j');

70: RETURN to_char(FII_TIME_API.ent_sd_pqtr_end(to_date(p_As_Of_Date,'j')),'j');
71: ELSIF p_Period_Type LIKE '%PERIOD%' THEN
72: RETURN to_char(FII_TIME_API.ent_sd_pper_end(to_date(p_As_Of_Date,'j')),'j');
73: ELSIF p_Period_Type LIKE '%WEEK%' THEN
74: RETURN to_char(FII_TIME_API.sd_pwk(to_date(p_As_Of_Date,'j')),'j');
75: END IF;
76: WHEN 'YEARLY' THEN
77: IF p_Period_Type LIKE '%YEAR%' THEN
78: RETURN to_char(FII_TIME_API.ent_sd_lyr_end(to_date(p_As_Of_Date,'j')),'j');

Line 78: RETURN to_char(FII_TIME_API.ent_sd_lyr_end(to_date(p_As_Of_Date,'j')),'j');

74: RETURN to_char(FII_TIME_API.sd_pwk(to_date(p_As_Of_Date,'j')),'j');
75: END IF;
76: WHEN 'YEARLY' THEN
77: IF p_Period_Type LIKE '%YEAR%' THEN
78: RETURN to_char(FII_TIME_API.ent_sd_lyr_end(to_date(p_As_Of_Date,'j')),'j');
79: ELSIF p_Period_Type LIKE '%QTR%' THEN
80: RETURN to_char(FII_TIME_API.ent_sd_lysqtr_end(to_date(p_As_Of_Date,'j')),'j');
81: ELSIF p_Period_Type LIKE '%PERIOD%' THEN
82: RETURN to_char(FII_TIME_API.ent_sd_lysper_end(to_date(p_As_Of_Date,'j')),'j');

Line 80: RETURN to_char(FII_TIME_API.ent_sd_lysqtr_end(to_date(p_As_Of_Date,'j')),'j');

76: WHEN 'YEARLY' THEN
77: IF p_Period_Type LIKE '%YEAR%' THEN
78: RETURN to_char(FII_TIME_API.ent_sd_lyr_end(to_date(p_As_Of_Date,'j')),'j');
79: ELSIF p_Period_Type LIKE '%QTR%' THEN
80: RETURN to_char(FII_TIME_API.ent_sd_lysqtr_end(to_date(p_As_Of_Date,'j')),'j');
81: ELSIF p_Period_Type LIKE '%PERIOD%' THEN
82: RETURN to_char(FII_TIME_API.ent_sd_lysper_end(to_date(p_As_Of_Date,'j')),'j');
83: ELSIF p_Period_Type LIKE '%WEEK%' THEN
84: RETURN to_char(FII_TIME_API.sd_lyswk(to_date(p_As_Of_Date,'j')),'j');

Line 82: RETURN to_char(FII_TIME_API.ent_sd_lysper_end(to_date(p_As_Of_Date,'j')),'j');

78: RETURN to_char(FII_TIME_API.ent_sd_lyr_end(to_date(p_As_Of_Date,'j')),'j');
79: ELSIF p_Period_Type LIKE '%QTR%' THEN
80: RETURN to_char(FII_TIME_API.ent_sd_lysqtr_end(to_date(p_As_Of_Date,'j')),'j');
81: ELSIF p_Period_Type LIKE '%PERIOD%' THEN
82: RETURN to_char(FII_TIME_API.ent_sd_lysper_end(to_date(p_As_Of_Date,'j')),'j');
83: ELSIF p_Period_Type LIKE '%WEEK%' THEN
84: RETURN to_char(FII_TIME_API.sd_lyswk(to_date(p_As_Of_Date,'j')),'j');
85: END IF;
86: END CASE;

Line 84: RETURN to_char(FII_TIME_API.sd_lyswk(to_date(p_As_Of_Date,'j')),'j');

80: RETURN to_char(FII_TIME_API.ent_sd_lysqtr_end(to_date(p_As_Of_Date,'j')),'j');
81: ELSIF p_Period_Type LIKE '%PERIOD%' THEN
82: RETURN to_char(FII_TIME_API.ent_sd_lysper_end(to_date(p_As_Of_Date,'j')),'j');
83: ELSIF p_Period_Type LIKE '%WEEK%' THEN
84: RETURN to_char(FII_TIME_API.sd_lyswk(to_date(p_As_Of_Date,'j')),'j');
85: END IF;
86: END CASE;
87: ELSE
88: CASE p_Comparator

Line 91: RETURN to_char(FII_TIME_API.cal_sd_lyr_end(to_date(p_As_Of_Date,'j'), l_Calendar_ID),'j');

87: ELSE
88: CASE p_Comparator
89: WHEN 'SEQUENTIAL' THEN
90: IF p_Period_Type LIKE '%YEAR%' THEN
91: RETURN to_char(FII_TIME_API.cal_sd_lyr_end(to_date(p_As_Of_Date,'j'), l_Calendar_ID),'j');
92: ELSIF p_Period_Type LIKE '%QTR%' THEN
93: RETURN to_char(FII_TIME_API.cal_sd_pqtr_end(to_date(p_As_Of_Date,'j'), l_Calendar_ID),'j');
94: ELSIF p_Period_Type LIKE '%PERIOD%' THEN
95: RETURN to_char(FII_TIME_API.cal_sd_pper_end(to_date(p_As_Of_Date,'j'), l_Calendar_ID),'j');

Line 93: RETURN to_char(FII_TIME_API.cal_sd_pqtr_end(to_date(p_As_Of_Date,'j'), l_Calendar_ID),'j');

89: WHEN 'SEQUENTIAL' THEN
90: IF p_Period_Type LIKE '%YEAR%' THEN
91: RETURN to_char(FII_TIME_API.cal_sd_lyr_end(to_date(p_As_Of_Date,'j'), l_Calendar_ID),'j');
92: ELSIF p_Period_Type LIKE '%QTR%' THEN
93: RETURN to_char(FII_TIME_API.cal_sd_pqtr_end(to_date(p_As_Of_Date,'j'), l_Calendar_ID),'j');
94: ELSIF p_Period_Type LIKE '%PERIOD%' THEN
95: RETURN to_char(FII_TIME_API.cal_sd_pper_end(to_date(p_As_Of_Date,'j'), l_Calendar_ID),'j');
96: END IF;
97: WHEN 'YEARLY' THEN

Line 95: RETURN to_char(FII_TIME_API.cal_sd_pper_end(to_date(p_As_Of_Date,'j'), l_Calendar_ID),'j');

91: RETURN to_char(FII_TIME_API.cal_sd_lyr_end(to_date(p_As_Of_Date,'j'), l_Calendar_ID),'j');
92: ELSIF p_Period_Type LIKE '%QTR%' THEN
93: RETURN to_char(FII_TIME_API.cal_sd_pqtr_end(to_date(p_As_Of_Date,'j'), l_Calendar_ID),'j');
94: ELSIF p_Period_Type LIKE '%PERIOD%' THEN
95: RETURN to_char(FII_TIME_API.cal_sd_pper_end(to_date(p_As_Of_Date,'j'), l_Calendar_ID),'j');
96: END IF;
97: WHEN 'YEARLY' THEN
98: IF p_Period_Type LIKE '%YEAR%' THEN
99: RETURN to_char(FII_TIME_API.cal_sd_lyr_end(to_date(p_As_Of_Date,'j'), l_Calendar_ID),'j');

Line 99: RETURN to_char(FII_TIME_API.cal_sd_lyr_end(to_date(p_As_Of_Date,'j'), l_Calendar_ID),'j');

95: RETURN to_char(FII_TIME_API.cal_sd_pper_end(to_date(p_As_Of_Date,'j'), l_Calendar_ID),'j');
96: END IF;
97: WHEN 'YEARLY' THEN
98: IF p_Period_Type LIKE '%YEAR%' THEN
99: RETURN to_char(FII_TIME_API.cal_sd_lyr_end(to_date(p_As_Of_Date,'j'), l_Calendar_ID),'j');
100: ELSIF p_Period_Type LIKE '%QTR%' THEN
101: RETURN to_char(FII_TIME_API.cal_sd_lysqtr_end(to_date(p_As_Of_Date,'j'), l_Calendar_ID),'j');
102: ELSIF p_Period_Type LIKE '%PERIOD%' THEN
103: RETURN to_char(FII_TIME_API.cal_sd_lysper_end(to_date(p_As_Of_Date,'j'), l_Calendar_ID),'j');

Line 101: RETURN to_char(FII_TIME_API.cal_sd_lysqtr_end(to_date(p_As_Of_Date,'j'), l_Calendar_ID),'j');

97: WHEN 'YEARLY' THEN
98: IF p_Period_Type LIKE '%YEAR%' THEN
99: RETURN to_char(FII_TIME_API.cal_sd_lyr_end(to_date(p_As_Of_Date,'j'), l_Calendar_ID),'j');
100: ELSIF p_Period_Type LIKE '%QTR%' THEN
101: RETURN to_char(FII_TIME_API.cal_sd_lysqtr_end(to_date(p_As_Of_Date,'j'), l_Calendar_ID),'j');
102: ELSIF p_Period_Type LIKE '%PERIOD%' THEN
103: RETURN to_char(FII_TIME_API.cal_sd_lysper_end(to_date(p_As_Of_Date,'j'), l_Calendar_ID),'j');
104: END IF;
105: END CASE;

Line 103: RETURN to_char(FII_TIME_API.cal_sd_lysper_end(to_date(p_As_Of_Date,'j'), l_Calendar_ID),'j');

99: RETURN to_char(FII_TIME_API.cal_sd_lyr_end(to_date(p_As_Of_Date,'j'), l_Calendar_ID),'j');
100: ELSIF p_Period_Type LIKE '%QTR%' THEN
101: RETURN to_char(FII_TIME_API.cal_sd_lysqtr_end(to_date(p_As_Of_Date,'j'), l_Calendar_ID),'j');
102: ELSIF p_Period_Type LIKE '%PERIOD%' THEN
103: RETURN to_char(FII_TIME_API.cal_sd_lysper_end(to_date(p_As_Of_Date,'j'), l_Calendar_ID),'j');
104: END IF;
105: END CASE;
106: END IF;
107: IF p_PA_DEBUG_MODE = 'Y' THEN

Line 4084: l_Prior_As_Of_Date:=FII_TIME_API.ent_sd_lyr_beg(l_As_Of_Date);

4080:
4081: Write2FWKLog('Entering Convert_Expected_Time...','Convert_Expected_Time');
4082: BEGIN
4083: Write2FWKLog('Determining Prior Year...');
4084: l_Prior_As_Of_Date:=FII_TIME_API.ent_sd_lyr_beg(l_As_Of_Date);
4085: EXCEPTION
4086: WHEN NO_DATA_FOUND THEN
4087: Write2FWKLog('Unable to determine Prior Year, hence defaulting it...');
4088: l_Prior_As_Of_Date:=PJI_UTILS.GET_EXTRACTION_START_DATE;

Line 4105: l_prior_summ_date:=FII_TIME_API.ent_sd_lyr_beg(l_summ_date);

4101: end if;
4102:
4103: BEGIN
4104: Write2FWKLog('Determining Prior Year...');
4105: l_prior_summ_date:=FII_TIME_API.ent_sd_lyr_beg(l_summ_date);
4106: EXCEPTION
4107: WHEN NO_DATA_FOUND THEN
4108: Write2FWKLog('Unable to determine Prior Year, hence defaulting it...');
4109: l_prior_summ_date:=PJI_UTILS.GET_EXTRACTION_START_DATE;