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.

[Home] [Help]

APPS.JAI_CMN_RGM_TERMS_PKG dependencies on JAI_RGM_TERMS

Line 140: p_term_id IN JAI_RGM_TERMS.TERM_ID%TYPE ,

136: || the term defined
137: ***************************************************/
138: PROCEDURE generate_term_schedules
139: (
140: p_term_id IN JAI_RGM_TERMS.TERM_ID%TYPE ,
141: p_amount IN NUMBER ,
142: p_register_date IN DATE ,
143: p_schedule_id OUT NOCOPY JAI_RGM_TRM_SCHEDULES_T.SCHEDULE_ID%TYPE ,
144: p_process_flag OUT NOCOPY VARCHAR2 ,

Line 163: jai_rgm_terms rgtm

159: , rgci.month_of_claim
160: , rgci.day_of_month
161: , rgci.claim_percentage
162: FROM
163: jai_rgm_terms rgtm
164: , jai_rgm_term_installments rgci
165: WHERE rgtm.term_id = rgci.term_id
166: AND rgtm.term_id = pn_rgm_term_id
167: ORDER BY installment_number;

Line 204: lv_start_period JAI_RGM_TERMS.start_period %TYPE ;

200: /*
201: || Declare the rows to be extracted from table
202: || based upon cursor
203: */
204: lv_start_period JAI_RGM_TERMS.start_period %TYPE ;
205: lv_no_of_instalments JAI_RGM_TERMS.number_of_instalments %TYPE ;
206: lv_instalment_freq JAI_RGM_TERMS.instalment_frequency %TYPE ;
207: lv_instalment_period JAI_RGM_TERMS.instalment_period %TYPE ;
208: ln_day_of_month JAI_RGM_TERMS.day_of_month %TYPE ;

Line 205: lv_no_of_instalments JAI_RGM_TERMS.number_of_instalments %TYPE ;

201: || Declare the rows to be extracted from table
202: || based upon cursor
203: */
204: lv_start_period JAI_RGM_TERMS.start_period %TYPE ;
205: lv_no_of_instalments JAI_RGM_TERMS.number_of_instalments %TYPE ;
206: lv_instalment_freq JAI_RGM_TERMS.instalment_frequency %TYPE ;
207: lv_instalment_period JAI_RGM_TERMS.instalment_period %TYPE ;
208: ln_day_of_month JAI_RGM_TERMS.day_of_month %TYPE ;
209: lv_frequency_day JAI_RGM_TERMS.frequency_day %TYPE ;

Line 206: lv_instalment_freq JAI_RGM_TERMS.instalment_frequency %TYPE ;

202: || based upon cursor
203: */
204: lv_start_period JAI_RGM_TERMS.start_period %TYPE ;
205: lv_no_of_instalments JAI_RGM_TERMS.number_of_instalments %TYPE ;
206: lv_instalment_freq JAI_RGM_TERMS.instalment_frequency %TYPE ;
207: lv_instalment_period JAI_RGM_TERMS.instalment_period %TYPE ;
208: ln_day_of_month JAI_RGM_TERMS.day_of_month %TYPE ;
209: lv_frequency_day JAI_RGM_TERMS.frequency_day %TYPE ;
210: lv_st_day_of_month JAI_RGM_TERMS.start_day_of_month %TYPE ;

Line 207: lv_instalment_period JAI_RGM_TERMS.instalment_period %TYPE ;

203: */
204: lv_start_period JAI_RGM_TERMS.start_period %TYPE ;
205: lv_no_of_instalments JAI_RGM_TERMS.number_of_instalments %TYPE ;
206: lv_instalment_freq JAI_RGM_TERMS.instalment_frequency %TYPE ;
207: lv_instalment_period JAI_RGM_TERMS.instalment_period %TYPE ;
208: ln_day_of_month JAI_RGM_TERMS.day_of_month %TYPE ;
209: lv_frequency_day JAI_RGM_TERMS.frequency_day %TYPE ;
210: lv_st_day_of_month JAI_RGM_TERMS.start_day_of_month %TYPE ;
211: lv_st_frequency_day JAI_RGM_TERMS.start_frequency_day %TYPE ;

Line 208: ln_day_of_month JAI_RGM_TERMS.day_of_month %TYPE ;

204: lv_start_period JAI_RGM_TERMS.start_period %TYPE ;
205: lv_no_of_instalments JAI_RGM_TERMS.number_of_instalments %TYPE ;
206: lv_instalment_freq JAI_RGM_TERMS.instalment_frequency %TYPE ;
207: lv_instalment_period JAI_RGM_TERMS.instalment_period %TYPE ;
208: ln_day_of_month JAI_RGM_TERMS.day_of_month %TYPE ;
209: lv_frequency_day JAI_RGM_TERMS.frequency_day %TYPE ;
210: lv_st_day_of_month JAI_RGM_TERMS.start_day_of_month %TYPE ;
211: lv_st_frequency_day JAI_RGM_TERMS.start_frequency_day %TYPE ;
212:

Line 209: lv_frequency_day JAI_RGM_TERMS.frequency_day %TYPE ;

205: lv_no_of_instalments JAI_RGM_TERMS.number_of_instalments %TYPE ;
206: lv_instalment_freq JAI_RGM_TERMS.instalment_frequency %TYPE ;
207: lv_instalment_period JAI_RGM_TERMS.instalment_period %TYPE ;
208: ln_day_of_month JAI_RGM_TERMS.day_of_month %TYPE ;
209: lv_frequency_day JAI_RGM_TERMS.frequency_day %TYPE ;
210: lv_st_day_of_month JAI_RGM_TERMS.start_day_of_month %TYPE ;
211: lv_st_frequency_day JAI_RGM_TERMS.start_frequency_day %TYPE ;
212:
213: ln_instalment_amt JAI_RGM_TRM_SCHEDULES_T.INSTALLMENT_AMOUNT%TYPE ; /* Amount for each instalment */

Line 210: lv_st_day_of_month JAI_RGM_TERMS.start_day_of_month %TYPE ;

206: lv_instalment_freq JAI_RGM_TERMS.instalment_frequency %TYPE ;
207: lv_instalment_period JAI_RGM_TERMS.instalment_period %TYPE ;
208: ln_day_of_month JAI_RGM_TERMS.day_of_month %TYPE ;
209: lv_frequency_day JAI_RGM_TERMS.frequency_day %TYPE ;
210: lv_st_day_of_month JAI_RGM_TERMS.start_day_of_month %TYPE ;
211: lv_st_frequency_day JAI_RGM_TERMS.start_frequency_day %TYPE ;
212:
213: ln_instalment_amt JAI_RGM_TRM_SCHEDULES_T.INSTALLMENT_AMOUNT%TYPE ; /* Amount for each instalment */
214: ld_start_date JAI_RGM_TRM_SCHEDULES_T.INSTALLMENT_DATE%TYPE ; /* Stores date for 1st instalment */

Line 211: lv_st_frequency_day JAI_RGM_TERMS.start_frequency_day %TYPE ;

207: lv_instalment_period JAI_RGM_TERMS.instalment_period %TYPE ;
208: ln_day_of_month JAI_RGM_TERMS.day_of_month %TYPE ;
209: lv_frequency_day JAI_RGM_TERMS.frequency_day %TYPE ;
210: lv_st_day_of_month JAI_RGM_TERMS.start_day_of_month %TYPE ;
211: lv_st_frequency_day JAI_RGM_TERMS.start_frequency_day %TYPE ;
212:
213: ln_instalment_amt JAI_RGM_TRM_SCHEDULES_T.INSTALLMENT_AMOUNT%TYPE ; /* Amount for each instalment */
214: ld_start_date JAI_RGM_TRM_SCHEDULES_T.INSTALLMENT_DATE%TYPE ; /* Stores date for 1st instalment */
215: ld_next_date JAI_RGM_TRM_SCHEDULES_T.INSTALLMENT_DATE%TYPE ; /* Date for subsequenct instalments */

Line 768: p_term_id IN JAI_RGM_TERMS.TERM_ID%TYPE ,

764: END get_term_id ;
765:
766: PROCEDURE set_term_in_use
767: (
768: p_term_id IN JAI_RGM_TERMS.TERM_ID%TYPE ,
769: p_process_flag OUT NOCOPY VARCHAR2 ,
770: p_process_msg OUT NOCOPY VARCHAR2
771: )
772: IS

Line 777: FROM jai_rgm_terms

773:
774: CURSOR cur_term_flag ( cp_term_id NUMBER )
775: IS
776: SELECT term_in_use_flag
777: FROM jai_rgm_terms
778: WHERE term_id = p_term_id ;
779:
780:
781: lv_term_in_use_flag VARCHAR2(1) ;

Line 811: UPDATE jai_rgm_terms

807: CLOSE cur_term_flag ;
808:
809: IF lv_term_in_use_flag <> 'Y' THEN
810:
811: UPDATE jai_rgm_terms
812: SET term_in_use_flag = 'Y' ,
813: last_update_date = sysdate ,
814: last_update_login = fnd_global.login_id ,
815: last_updated_by = fnd_global.user_id