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_TRM_SCHEDULES_T

Line 83: || Insert values into jai_rgm_trm_schedules_t

79: END set_date ;
80:
81:
82: /**************************************************
83: || Insert values into jai_rgm_trm_schedules_t
84: || Private procedure
85: ***************************************************/
86:
87: PROCEDURE insert_jai_rgm_trm_schedules_t

Line 87: PROCEDURE insert_jai_rgm_trm_schedules_t

83: || Insert values into jai_rgm_trm_schedules_t
84: || Private procedure
85: ***************************************************/
86:
87: PROCEDURE insert_jai_rgm_trm_schedules_t
88: (
89: pn_schedule_id IN JAI_RGM_TRM_SCHEDULES_T.SCHEDULE_ID%TYPE ,
90: pn_instalment_no IN JAI_RGM_TRM_SCHEDULES_T.INSTALLMENT_NO%TYPE ,
91: pn_instalment_amt IN JAI_RGM_TRM_SCHEDULES_T.INSTALLMENT_AMOUNT%TYPE ,

Line 89: pn_schedule_id IN JAI_RGM_TRM_SCHEDULES_T.SCHEDULE_ID%TYPE ,

85: ***************************************************/
86:
87: PROCEDURE insert_jai_rgm_trm_schedules_t
88: (
89: pn_schedule_id IN JAI_RGM_TRM_SCHEDULES_T.SCHEDULE_ID%TYPE ,
90: pn_instalment_no IN JAI_RGM_TRM_SCHEDULES_T.INSTALLMENT_NO%TYPE ,
91: pn_instalment_amt IN JAI_RGM_TRM_SCHEDULES_T.INSTALLMENT_AMOUNT%TYPE ,
92: pd_instalment_date IN JAI_RGM_TRM_SCHEDULES_T.INSTALLMENT_DATE%TYPE
93: )

Line 90: pn_instalment_no IN JAI_RGM_TRM_SCHEDULES_T.INSTALLMENT_NO%TYPE ,

86:
87: PROCEDURE insert_jai_rgm_trm_schedules_t
88: (
89: pn_schedule_id IN JAI_RGM_TRM_SCHEDULES_T.SCHEDULE_ID%TYPE ,
90: pn_instalment_no IN JAI_RGM_TRM_SCHEDULES_T.INSTALLMENT_NO%TYPE ,
91: pn_instalment_amt IN JAI_RGM_TRM_SCHEDULES_T.INSTALLMENT_AMOUNT%TYPE ,
92: pd_instalment_date IN JAI_RGM_TRM_SCHEDULES_T.INSTALLMENT_DATE%TYPE
93: )
94: IS

Line 91: pn_instalment_amt IN JAI_RGM_TRM_SCHEDULES_T.INSTALLMENT_AMOUNT%TYPE ,

87: PROCEDURE insert_jai_rgm_trm_schedules_t
88: (
89: pn_schedule_id IN JAI_RGM_TRM_SCHEDULES_T.SCHEDULE_ID%TYPE ,
90: pn_instalment_no IN JAI_RGM_TRM_SCHEDULES_T.INSTALLMENT_NO%TYPE ,
91: pn_instalment_amt IN JAI_RGM_TRM_SCHEDULES_T.INSTALLMENT_AMOUNT%TYPE ,
92: pd_instalment_date IN JAI_RGM_TRM_SCHEDULES_T.INSTALLMENT_DATE%TYPE
93: )
94: IS
95:

Line 92: pd_instalment_date IN JAI_RGM_TRM_SCHEDULES_T.INSTALLMENT_DATE%TYPE

88: (
89: pn_schedule_id IN JAI_RGM_TRM_SCHEDULES_T.SCHEDULE_ID%TYPE ,
90: pn_instalment_no IN JAI_RGM_TRM_SCHEDULES_T.INSTALLMENT_NO%TYPE ,
91: pn_instalment_amt IN JAI_RGM_TRM_SCHEDULES_T.INSTALLMENT_AMOUNT%TYPE ,
92: pd_instalment_date IN JAI_RGM_TRM_SCHEDULES_T.INSTALLMENT_DATE%TYPE
93: )
94: IS
95:
96: /* Added by Ramananda for bug#4407165 */

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

93: )
94: IS
95:
96: /* Added by Ramananda for bug#4407165 */
97: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rgm_terms_pkg.insert_jai_rgm_trm_schedules_t';
98:
99: BEGIN
100:
101: INSERT INTO jai_rgm_trm_schedules_t

Line 101: INSERT INTO jai_rgm_trm_schedules_t

97: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rgm_terms_pkg.insert_jai_rgm_trm_schedules_t';
98:
99: BEGIN
100:
101: INSERT INTO jai_rgm_trm_schedules_t
102: (
103: SCHEDULE_ID ,
104: INSTALLMENT_NO ,
105: INSTALLMENT_AMOUNT ,

Line 132: END insert_jai_rgm_trm_schedules_t ;

128: FND_MESSAGE.SET_NAME('JA','JAI_EXCEPTION_OCCURED');
129: FND_MESSAGE.SET_TOKEN('JAI_PROCESS_MSG', lv_object_name ||'. Err:'||sqlerrm );
130: app_exception.raise_exception;
131:
132: END insert_jai_rgm_trm_schedules_t ;
133:
134: /**************************************************
135: || Generate the payment schedule based upon
136: || the term defined

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

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 ,
145: p_process_msg OUT NOCOPY VARCHAR2
146: )
147: IS

Line 174: jai_rgm_trm_schedules_t_s.nextval

170:
171: CURSOR cur_sequence
172: IS
173: SELECT
174: jai_rgm_trm_schedules_t_s.nextval
175: FROM
176: dual ;
177:
178: --added by eric ma for VAT FLEX RECOVERY (Bug9494633) on Mar-09-2010,Begin

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

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

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

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 */
216:
217: ln_interval_months NUMBER ; /* Based upon instalment_period */
218: ln_st_interval_days NUMBER ; /* Based upon st_instalment_perio */

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

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 */
216:
217: ln_interval_months NUMBER ; /* Based upon instalment_period */
218: ln_st_interval_days NUMBER ; /* Based upon st_instalment_perio */
219: ln_start_interval_months NUMBER ; /* Interval based upon start period */

Line 559: insert_jai_rgm_trm_schedules_t( p_schedule_id

555: ld_register_date := ld_installment_date;
556:
557:
558: /* Insert into the temp table*/
559: insert_jai_rgm_trm_schedules_t( p_schedule_id
560: , ln_installment_number
561: , ln_installment_amount
562: , ld_installment_date
563: );