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_TRM_SCHEDULES_T

Line 77: || Insert values into jai_rgm_trm_schedules_t

73: END set_date ;
74:
75:
76: /**************************************************
77: || Insert values into jai_rgm_trm_schedules_t
78: || Private procedure
79: ***************************************************/
80:
81: PROCEDURE insert_jai_rgm_trm_schedules_t

Line 81: PROCEDURE insert_jai_rgm_trm_schedules_t

77: || Insert values into jai_rgm_trm_schedules_t
78: || Private procedure
79: ***************************************************/
80:
81: PROCEDURE insert_jai_rgm_trm_schedules_t
82: (
83: pn_schedule_id IN JAI_RGM_TRM_SCHEDULES_T.SCHEDULE_ID%TYPE ,
84: pn_instalment_no IN JAI_RGM_TRM_SCHEDULES_T.INSTALLMENT_NO%TYPE ,
85: pn_instalment_amt IN JAI_RGM_TRM_SCHEDULES_T.INSTALLMENT_AMOUNT%TYPE ,

Line 83: pn_schedule_id IN JAI_RGM_TRM_SCHEDULES_T.SCHEDULE_ID%TYPE ,

79: ***************************************************/
80:
81: PROCEDURE insert_jai_rgm_trm_schedules_t
82: (
83: pn_schedule_id IN JAI_RGM_TRM_SCHEDULES_T.SCHEDULE_ID%TYPE ,
84: pn_instalment_no IN JAI_RGM_TRM_SCHEDULES_T.INSTALLMENT_NO%TYPE ,
85: pn_instalment_amt IN JAI_RGM_TRM_SCHEDULES_T.INSTALLMENT_AMOUNT%TYPE ,
86: pd_instalment_date IN JAI_RGM_TRM_SCHEDULES_T.INSTALLMENT_DATE%TYPE
87: )

Line 84: pn_instalment_no IN JAI_RGM_TRM_SCHEDULES_T.INSTALLMENT_NO%TYPE ,

80:
81: PROCEDURE insert_jai_rgm_trm_schedules_t
82: (
83: pn_schedule_id IN JAI_RGM_TRM_SCHEDULES_T.SCHEDULE_ID%TYPE ,
84: pn_instalment_no IN JAI_RGM_TRM_SCHEDULES_T.INSTALLMENT_NO%TYPE ,
85: pn_instalment_amt IN JAI_RGM_TRM_SCHEDULES_T.INSTALLMENT_AMOUNT%TYPE ,
86: pd_instalment_date IN JAI_RGM_TRM_SCHEDULES_T.INSTALLMENT_DATE%TYPE
87: )
88: IS

Line 85: pn_instalment_amt IN JAI_RGM_TRM_SCHEDULES_T.INSTALLMENT_AMOUNT%TYPE ,

81: PROCEDURE insert_jai_rgm_trm_schedules_t
82: (
83: pn_schedule_id IN JAI_RGM_TRM_SCHEDULES_T.SCHEDULE_ID%TYPE ,
84: pn_instalment_no IN JAI_RGM_TRM_SCHEDULES_T.INSTALLMENT_NO%TYPE ,
85: pn_instalment_amt IN JAI_RGM_TRM_SCHEDULES_T.INSTALLMENT_AMOUNT%TYPE ,
86: pd_instalment_date IN JAI_RGM_TRM_SCHEDULES_T.INSTALLMENT_DATE%TYPE
87: )
88: IS
89:

Line 86: pd_instalment_date IN JAI_RGM_TRM_SCHEDULES_T.INSTALLMENT_DATE%TYPE

82: (
83: pn_schedule_id IN JAI_RGM_TRM_SCHEDULES_T.SCHEDULE_ID%TYPE ,
84: pn_instalment_no IN JAI_RGM_TRM_SCHEDULES_T.INSTALLMENT_NO%TYPE ,
85: pn_instalment_amt IN JAI_RGM_TRM_SCHEDULES_T.INSTALLMENT_AMOUNT%TYPE ,
86: pd_instalment_date IN JAI_RGM_TRM_SCHEDULES_T.INSTALLMENT_DATE%TYPE
87: )
88: IS
89:
90: /* Added by Ramananda for bug#4407165 */

Line 91: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rgm_terms_pkg.insert_jai_rgm_trm_schedules_t';

87: )
88: IS
89:
90: /* Added by Ramananda for bug#4407165 */
91: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rgm_terms_pkg.insert_jai_rgm_trm_schedules_t';
92:
93: BEGIN
94:
95: INSERT INTO jai_rgm_trm_schedules_t

Line 95: INSERT INTO jai_rgm_trm_schedules_t

91: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rgm_terms_pkg.insert_jai_rgm_trm_schedules_t';
92:
93: BEGIN
94:
95: INSERT INTO jai_rgm_trm_schedules_t
96: (
97: SCHEDULE_ID ,
98: INSTALLMENT_NO ,
99: INSTALLMENT_AMOUNT ,

Line 126: END insert_jai_rgm_trm_schedules_t ;

122: FND_MESSAGE.SET_NAME('JA','JAI_EXCEPTION_OCCURED');
123: FND_MESSAGE.SET_TOKEN('JAI_PROCESS_MSG', lv_object_name ||'. Err:'||sqlerrm );
124: app_exception.raise_exception;
125:
126: END insert_jai_rgm_trm_schedules_t ;
127:
128: /**************************************************
129: || Generate the payment schedule based upon
130: || the term defined

Line 137: p_schedule_id OUT NOCOPY JAI_RGM_TRM_SCHEDULES_T.SCHEDULE_ID%TYPE ,

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 ,
139: p_process_msg OUT NOCOPY VARCHAR2
140: )
141: IS

Line 164: jai_rgm_trm_schedules_t_s.nextval

160:
161: CURSOR cur_sequence
162: IS
163: SELECT
164: jai_rgm_trm_schedules_t_s.nextval
165: FROM
166: dual ;
167:
168: /*

Line 181: ln_instalment_amt JAI_RGM_TRM_SCHEDULES_T.INSTALLMENT_AMOUNT%TYPE ; /* Amount for each instalment */

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 */
184:
185: ln_interval_months NUMBER ; /* Based upon instalment_period */

Line 182: ld_start_date JAI_RGM_TRM_SCHEDULES_T.INSTALLMENT_DATE%TYPE ; /* Stores date for 1st instalment */

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 */
184:
185: ln_interval_months NUMBER ; /* Based upon instalment_period */
186: ln_st_interval_days NUMBER ; /* Based upon st_instalment_perio */

Line 183: ld_next_date JAI_RGM_TRM_SCHEDULES_T.INSTALLMENT_DATE%TYPE ; /* Date for subsequenct instalments */

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 */
184:
185: ln_interval_months NUMBER ; /* Based upon instalment_period */
186: ln_st_interval_days NUMBER ; /* Based upon st_instalment_perio */
187: ln_start_interval_months NUMBER ; /* Interval based upon start period */

Line 311: insert_jai_rgm_trm_schedules_t

307: /*
308: || Insert the first instalment
309: || on start_date
310: */
311: insert_jai_rgm_trm_schedules_t
312: (
313: p_schedule_id ,
314: 1 ,
315: ln_instalment_amt ,

Line 336: insert_jai_rgm_trm_schedules_t

332:
333: /*
334: || Insert the subsequent instalments
335: */
336: insert_jai_rgm_trm_schedules_t
337: (
338: p_schedule_id ,
339: cur_inst_no ,
340: ln_instalment_amt ,