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.JAI_CMN_RGM_TERMS_PKG dependencies on JAI_RGM_TERMS

Line 134: p_term_id IN JAI_RGM_TERMS.TERM_ID%TYPE ,

130: || the term defined
131: ***************************************************/
132: PROCEDURE generate_term_schedules
133: (
134: p_term_id IN JAI_RGM_TERMS.TERM_ID%TYPE ,
135: p_amount IN NUMBER ,
136: p_register_date IN DATE ,
137: p_schedule_id OUT NOCOPY JAI_RGM_TRM_SCHEDULES_T.SCHEDULE_ID%TYPE ,
138: p_process_flag OUT NOCOPY VARCHAR2 ,

Line 157: jai_rgm_terms

153: DECODE ( instalment_period, 'MONTH' , 1 , 'QRTR' , 3 , 'YEAR' , 12 ) ,
154: day_of_month ,
155: frequency_day
156: FROM
157: jai_rgm_terms
158: WHERE
159: term_id = p_rgm_term_id ;
160:
161: CURSOR cur_sequence

Line 172: lv_start_period JAI_RGM_TERMS.start_period %TYPE ;

168: /*
169: || Declare the rows to be extracted from table
170: || based upon cursor
171: */
172: lv_start_period JAI_RGM_TERMS.start_period %TYPE ;
173: lv_no_of_instalments JAI_RGM_TERMS.number_of_instalments %TYPE ;
174: lv_instalment_freq JAI_RGM_TERMS.instalment_frequency %TYPE ;
175: lv_instalment_period JAI_RGM_TERMS.instalment_period %TYPE ;
176: ln_day_of_month JAI_RGM_TERMS.day_of_month %TYPE ;

Line 173: lv_no_of_instalments JAI_RGM_TERMS.number_of_instalments %TYPE ;

169: || Declare the rows to be extracted from table
170: || based upon cursor
171: */
172: lv_start_period JAI_RGM_TERMS.start_period %TYPE ;
173: lv_no_of_instalments JAI_RGM_TERMS.number_of_instalments %TYPE ;
174: lv_instalment_freq JAI_RGM_TERMS.instalment_frequency %TYPE ;
175: lv_instalment_period JAI_RGM_TERMS.instalment_period %TYPE ;
176: ln_day_of_month JAI_RGM_TERMS.day_of_month %TYPE ;
177: lv_frequency_day JAI_RGM_TERMS.frequency_day %TYPE ;

Line 174: lv_instalment_freq JAI_RGM_TERMS.instalment_frequency %TYPE ;

170: || based upon cursor
171: */
172: lv_start_period JAI_RGM_TERMS.start_period %TYPE ;
173: lv_no_of_instalments JAI_RGM_TERMS.number_of_instalments %TYPE ;
174: lv_instalment_freq JAI_RGM_TERMS.instalment_frequency %TYPE ;
175: lv_instalment_period JAI_RGM_TERMS.instalment_period %TYPE ;
176: ln_day_of_month JAI_RGM_TERMS.day_of_month %TYPE ;
177: lv_frequency_day JAI_RGM_TERMS.frequency_day %TYPE ;
178: lv_st_day_of_month JAI_RGM_TERMS.start_day_of_month %TYPE ;

Line 175: lv_instalment_period JAI_RGM_TERMS.instalment_period %TYPE ;

171: */
172: lv_start_period JAI_RGM_TERMS.start_period %TYPE ;
173: lv_no_of_instalments JAI_RGM_TERMS.number_of_instalments %TYPE ;
174: lv_instalment_freq JAI_RGM_TERMS.instalment_frequency %TYPE ;
175: lv_instalment_period JAI_RGM_TERMS.instalment_period %TYPE ;
176: ln_day_of_month JAI_RGM_TERMS.day_of_month %TYPE ;
177: lv_frequency_day JAI_RGM_TERMS.frequency_day %TYPE ;
178: lv_st_day_of_month JAI_RGM_TERMS.start_day_of_month %TYPE ;
179: lv_st_frequency_day JAI_RGM_TERMS.start_frequency_day %TYPE ;

Line 176: ln_day_of_month JAI_RGM_TERMS.day_of_month %TYPE ;

172: lv_start_period JAI_RGM_TERMS.start_period %TYPE ;
173: lv_no_of_instalments JAI_RGM_TERMS.number_of_instalments %TYPE ;
174: lv_instalment_freq JAI_RGM_TERMS.instalment_frequency %TYPE ;
175: lv_instalment_period JAI_RGM_TERMS.instalment_period %TYPE ;
176: ln_day_of_month JAI_RGM_TERMS.day_of_month %TYPE ;
177: lv_frequency_day JAI_RGM_TERMS.frequency_day %TYPE ;
178: lv_st_day_of_month JAI_RGM_TERMS.start_day_of_month %TYPE ;
179: lv_st_frequency_day JAI_RGM_TERMS.start_frequency_day %TYPE ;
180:

Line 177: lv_frequency_day JAI_RGM_TERMS.frequency_day %TYPE ;

173: lv_no_of_instalments JAI_RGM_TERMS.number_of_instalments %TYPE ;
174: lv_instalment_freq JAI_RGM_TERMS.instalment_frequency %TYPE ;
175: lv_instalment_period JAI_RGM_TERMS.instalment_period %TYPE ;
176: ln_day_of_month JAI_RGM_TERMS.day_of_month %TYPE ;
177: lv_frequency_day JAI_RGM_TERMS.frequency_day %TYPE ;
178: lv_st_day_of_month JAI_RGM_TERMS.start_day_of_month %TYPE ;
179: lv_st_frequency_day JAI_RGM_TERMS.start_frequency_day %TYPE ;
180:
181: ln_instalment_amt JAI_RGM_TRM_SCHEDULES_T.INSTALLMENT_AMOUNT%TYPE ; /* Amount for each instalment */

Line 178: lv_st_day_of_month JAI_RGM_TERMS.start_day_of_month %TYPE ;

174: lv_instalment_freq JAI_RGM_TERMS.instalment_frequency %TYPE ;
175: lv_instalment_period JAI_RGM_TERMS.instalment_period %TYPE ;
176: ln_day_of_month JAI_RGM_TERMS.day_of_month %TYPE ;
177: lv_frequency_day JAI_RGM_TERMS.frequency_day %TYPE ;
178: lv_st_day_of_month JAI_RGM_TERMS.start_day_of_month %TYPE ;
179: lv_st_frequency_day JAI_RGM_TERMS.start_frequency_day %TYPE ;
180:
181: ln_instalment_amt JAI_RGM_TRM_SCHEDULES_T.INSTALLMENT_AMOUNT%TYPE ; /* Amount for each instalment */
182: ld_start_date JAI_RGM_TRM_SCHEDULES_T.INSTALLMENT_DATE%TYPE ; /* Stores date for 1st instalment */

Line 179: lv_st_frequency_day JAI_RGM_TERMS.start_frequency_day %TYPE ;

175: lv_instalment_period JAI_RGM_TERMS.instalment_period %TYPE ;
176: ln_day_of_month JAI_RGM_TERMS.day_of_month %TYPE ;
177: lv_frequency_day JAI_RGM_TERMS.frequency_day %TYPE ;
178: lv_st_day_of_month JAI_RGM_TERMS.start_day_of_month %TYPE ;
179: lv_st_frequency_day JAI_RGM_TERMS.start_frequency_day %TYPE ;
180:
181: ln_instalment_amt JAI_RGM_TRM_SCHEDULES_T.INSTALLMENT_AMOUNT%TYPE ; /* Amount for each instalment */
182: ld_start_date JAI_RGM_TRM_SCHEDULES_T.INSTALLMENT_DATE%TYPE ; /* Stores date for 1st instalment */
183: ld_next_date JAI_RGM_TRM_SCHEDULES_T.INSTALLMENT_DATE%TYPE ; /* Date for subsequenct instalments */

Line 231: p_process_msg := 'jai_rgm_claims_pkg.prepare_term_schedules => Term is not defined in jai_rgm_terms' ;

227:
228: IF NOT ( cur_term_details % FOUND ) THEN
229:
230: p_process_flag := jai_constants.expected_error ;
231: p_process_msg := 'jai_rgm_claims_pkg.prepare_term_schedules => Term is not defined in jai_rgm_terms' ;
232: return ;
233:
234: END IF ;
235:

Line 545: p_term_id IN JAI_RGM_TERMS.TERM_ID%TYPE ,

541: END get_term_id ;
542:
543: PROCEDURE set_term_in_use
544: (
545: p_term_id IN JAI_RGM_TERMS.TERM_ID%TYPE ,
546: p_process_flag OUT NOCOPY VARCHAR2 ,
547: p_process_msg OUT NOCOPY VARCHAR2
548: )
549: IS

Line 554: FROM jai_rgm_terms

550:
551: CURSOR cur_term_flag ( cp_term_id NUMBER )
552: IS
553: SELECT term_in_use_flag
554: FROM jai_rgm_terms
555: WHERE term_id = p_term_id ;
556:
557:
558: lv_term_in_use_flag VARCHAR2(1) ;

Line 588: UPDATE jai_rgm_terms

584: CLOSE cur_term_flag ;
585:
586: IF lv_term_in_use_flag <> 'Y' THEN
587:
588: UPDATE jai_rgm_terms
589: SET term_in_use_flag = 'Y' ,
590: last_update_date = sysdate ,
591: last_update_login = fnd_global.login_id ,
592: last_updated_by = fnd_global.user_id