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.XTR_RATE_CHANGE dependencies on XTR_DEBUG_PKG

Line 92: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

88:
89:
90: BEGIN
91: --cep_standard.enable_debug;
92: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
93: xtr_debug_pkg.debug('XTR_RATE_CHANGE.PRODUCT_RATE_CHANGE');
94: xtr_debug_pkg.debug('PRODUCT_RATE_CHANGE: ' || 'p_effective_from_date = ' ||p_effective_from_date );
95: xtr_debug_pkg.debug('PRODUCT_RATE_CHANGE: ' || 'p_deal_subtype = ' ||p_deal_subtype );
96: xtr_debug_pkg.debug('PRODUCT_RATE_CHANGE: ' || 'p_payment_schedule_code = ' ||p_payment_schedule_code );

Line 93: xtr_debug_pkg.debug('XTR_RATE_CHANGE.PRODUCT_RATE_CHANGE');

89:
90: BEGIN
91: --cep_standard.enable_debug;
92: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
93: xtr_debug_pkg.debug('XTR_RATE_CHANGE.PRODUCT_RATE_CHANGE');
94: xtr_debug_pkg.debug('PRODUCT_RATE_CHANGE: ' || 'p_effective_from_date = ' ||p_effective_from_date );
95: xtr_debug_pkg.debug('PRODUCT_RATE_CHANGE: ' || 'p_deal_subtype = ' ||p_deal_subtype );
96: xtr_debug_pkg.debug('PRODUCT_RATE_CHANGE: ' || 'p_payment_schedule_code = ' ||p_payment_schedule_code );
97: xtr_debug_pkg.debug('PRODUCT_RATE_CHANGE: ' || 'p_currency = ' ||p_currency );

Line 94: xtr_debug_pkg.debug('PRODUCT_RATE_CHANGE: ' || 'p_effective_from_date = ' ||p_effective_from_date );

90: BEGIN
91: --cep_standard.enable_debug;
92: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
93: xtr_debug_pkg.debug('XTR_RATE_CHANGE.PRODUCT_RATE_CHANGE');
94: xtr_debug_pkg.debug('PRODUCT_RATE_CHANGE: ' || 'p_effective_from_date = ' ||p_effective_from_date );
95: xtr_debug_pkg.debug('PRODUCT_RATE_CHANGE: ' || 'p_deal_subtype = ' ||p_deal_subtype );
96: xtr_debug_pkg.debug('PRODUCT_RATE_CHANGE: ' || 'p_payment_schedule_code = ' ||p_payment_schedule_code );
97: xtr_debug_pkg.debug('PRODUCT_RATE_CHANGE: ' || 'p_currency = ' ||p_currency );
98: xtr_debug_pkg.debug('PRODUCT_RATE_CHANGE: ' || 'p_min_balance = ' ||p_min_balance );

Line 95: xtr_debug_pkg.debug('PRODUCT_RATE_CHANGE: ' || 'p_deal_subtype = ' ||p_deal_subtype );

91: --cep_standard.enable_debug;
92: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
93: xtr_debug_pkg.debug('XTR_RATE_CHANGE.PRODUCT_RATE_CHANGE');
94: xtr_debug_pkg.debug('PRODUCT_RATE_CHANGE: ' || 'p_effective_from_date = ' ||p_effective_from_date );
95: xtr_debug_pkg.debug('PRODUCT_RATE_CHANGE: ' || 'p_deal_subtype = ' ||p_deal_subtype );
96: xtr_debug_pkg.debug('PRODUCT_RATE_CHANGE: ' || 'p_payment_schedule_code = ' ||p_payment_schedule_code );
97: xtr_debug_pkg.debug('PRODUCT_RATE_CHANGE: ' || 'p_currency = ' ||p_currency );
98: xtr_debug_pkg.debug('PRODUCT_RATE_CHANGE: ' || 'p_min_balance = ' ||p_min_balance );
99: xtr_debug_pkg.debug('PRODUCT_RATE_CHANGE: ' || 'p_max_balance = ' ||p_max_balance );

Line 96: xtr_debug_pkg.debug('PRODUCT_RATE_CHANGE: ' || 'p_payment_schedule_code = ' ||p_payment_schedule_code );

92: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
93: xtr_debug_pkg.debug('XTR_RATE_CHANGE.PRODUCT_RATE_CHANGE');
94: xtr_debug_pkg.debug('PRODUCT_RATE_CHANGE: ' || 'p_effective_from_date = ' ||p_effective_from_date );
95: xtr_debug_pkg.debug('PRODUCT_RATE_CHANGE: ' || 'p_deal_subtype = ' ||p_deal_subtype );
96: xtr_debug_pkg.debug('PRODUCT_RATE_CHANGE: ' || 'p_payment_schedule_code = ' ||p_payment_schedule_code );
97: xtr_debug_pkg.debug('PRODUCT_RATE_CHANGE: ' || 'p_currency = ' ||p_currency );
98: xtr_debug_pkg.debug('PRODUCT_RATE_CHANGE: ' || 'p_min_balance = ' ||p_min_balance );
99: xtr_debug_pkg.debug('PRODUCT_RATE_CHANGE: ' || 'p_max_balance = ' ||p_max_balance );
100: xtr_debug_pkg.debug('PRODUCT_RATE_CHANGE: ' || 'p_change_pi_yn = ' ||p_change_pi_yn );

Line 97: xtr_debug_pkg.debug('PRODUCT_RATE_CHANGE: ' || 'p_currency = ' ||p_currency );

93: xtr_debug_pkg.debug('XTR_RATE_CHANGE.PRODUCT_RATE_CHANGE');
94: xtr_debug_pkg.debug('PRODUCT_RATE_CHANGE: ' || 'p_effective_from_date = ' ||p_effective_from_date );
95: xtr_debug_pkg.debug('PRODUCT_RATE_CHANGE: ' || 'p_deal_subtype = ' ||p_deal_subtype );
96: xtr_debug_pkg.debug('PRODUCT_RATE_CHANGE: ' || 'p_payment_schedule_code = ' ||p_payment_schedule_code );
97: xtr_debug_pkg.debug('PRODUCT_RATE_CHANGE: ' || 'p_currency = ' ||p_currency );
98: xtr_debug_pkg.debug('PRODUCT_RATE_CHANGE: ' || 'p_min_balance = ' ||p_min_balance );
99: xtr_debug_pkg.debug('PRODUCT_RATE_CHANGE: ' || 'p_max_balance = ' ||p_max_balance );
100: xtr_debug_pkg.debug('PRODUCT_RATE_CHANGE: ' || 'p_change_pi_yn = ' ||p_change_pi_yn );
101: xtr_debug_pkg.debug('PRODUCT_RATE_CHANGE: ' || 'p_change_pi_yn = ' ||p_change_pi_yn );

Line 98: xtr_debug_pkg.debug('PRODUCT_RATE_CHANGE: ' || 'p_min_balance = ' ||p_min_balance );

94: xtr_debug_pkg.debug('PRODUCT_RATE_CHANGE: ' || 'p_effective_from_date = ' ||p_effective_from_date );
95: xtr_debug_pkg.debug('PRODUCT_RATE_CHANGE: ' || 'p_deal_subtype = ' ||p_deal_subtype );
96: xtr_debug_pkg.debug('PRODUCT_RATE_CHANGE: ' || 'p_payment_schedule_code = ' ||p_payment_schedule_code );
97: xtr_debug_pkg.debug('PRODUCT_RATE_CHANGE: ' || 'p_currency = ' ||p_currency );
98: xtr_debug_pkg.debug('PRODUCT_RATE_CHANGE: ' || 'p_min_balance = ' ||p_min_balance );
99: xtr_debug_pkg.debug('PRODUCT_RATE_CHANGE: ' || 'p_max_balance = ' ||p_max_balance );
100: xtr_debug_pkg.debug('PRODUCT_RATE_CHANGE: ' || 'p_change_pi_yn = ' ||p_change_pi_yn );
101: xtr_debug_pkg.debug('PRODUCT_RATE_CHANGE: ' || 'p_change_pi_yn = ' ||p_change_pi_yn );
102: xtr_debug_pkg.debug('PRODUCT_RATE_CHANGE: ' || 'p_new_interest_rate = ' ||p_new_interest_rate );

Line 99: xtr_debug_pkg.debug('PRODUCT_RATE_CHANGE: ' || 'p_max_balance = ' ||p_max_balance );

95: xtr_debug_pkg.debug('PRODUCT_RATE_CHANGE: ' || 'p_deal_subtype = ' ||p_deal_subtype );
96: xtr_debug_pkg.debug('PRODUCT_RATE_CHANGE: ' || 'p_payment_schedule_code = ' ||p_payment_schedule_code );
97: xtr_debug_pkg.debug('PRODUCT_RATE_CHANGE: ' || 'p_currency = ' ||p_currency );
98: xtr_debug_pkg.debug('PRODUCT_RATE_CHANGE: ' || 'p_min_balance = ' ||p_min_balance );
99: xtr_debug_pkg.debug('PRODUCT_RATE_CHANGE: ' || 'p_max_balance = ' ||p_max_balance );
100: xtr_debug_pkg.debug('PRODUCT_RATE_CHANGE: ' || 'p_change_pi_yn = ' ||p_change_pi_yn );
101: xtr_debug_pkg.debug('PRODUCT_RATE_CHANGE: ' || 'p_change_pi_yn = ' ||p_change_pi_yn );
102: xtr_debug_pkg.debug('PRODUCT_RATE_CHANGE: ' || 'p_new_interest_rate = ' ||p_new_interest_rate );
103: END IF;

Line 100: xtr_debug_pkg.debug('PRODUCT_RATE_CHANGE: ' || 'p_change_pi_yn = ' ||p_change_pi_yn );

96: xtr_debug_pkg.debug('PRODUCT_RATE_CHANGE: ' || 'p_payment_schedule_code = ' ||p_payment_schedule_code );
97: xtr_debug_pkg.debug('PRODUCT_RATE_CHANGE: ' || 'p_currency = ' ||p_currency );
98: xtr_debug_pkg.debug('PRODUCT_RATE_CHANGE: ' || 'p_min_balance = ' ||p_min_balance );
99: xtr_debug_pkg.debug('PRODUCT_RATE_CHANGE: ' || 'p_max_balance = ' ||p_max_balance );
100: xtr_debug_pkg.debug('PRODUCT_RATE_CHANGE: ' || 'p_change_pi_yn = ' ||p_change_pi_yn );
101: xtr_debug_pkg.debug('PRODUCT_RATE_CHANGE: ' || 'p_change_pi_yn = ' ||p_change_pi_yn );
102: xtr_debug_pkg.debug('PRODUCT_RATE_CHANGE: ' || 'p_new_interest_rate = ' ||p_new_interest_rate );
103: END IF;
104:

Line 101: xtr_debug_pkg.debug('PRODUCT_RATE_CHANGE: ' || 'p_change_pi_yn = ' ||p_change_pi_yn );

97: xtr_debug_pkg.debug('PRODUCT_RATE_CHANGE: ' || 'p_currency = ' ||p_currency );
98: xtr_debug_pkg.debug('PRODUCT_RATE_CHANGE: ' || 'p_min_balance = ' ||p_min_balance );
99: xtr_debug_pkg.debug('PRODUCT_RATE_CHANGE: ' || 'p_max_balance = ' ||p_max_balance );
100: xtr_debug_pkg.debug('PRODUCT_RATE_CHANGE: ' || 'p_change_pi_yn = ' ||p_change_pi_yn );
101: xtr_debug_pkg.debug('PRODUCT_RATE_CHANGE: ' || 'p_change_pi_yn = ' ||p_change_pi_yn );
102: xtr_debug_pkg.debug('PRODUCT_RATE_CHANGE: ' || 'p_new_interest_rate = ' ||p_new_interest_rate );
103: END IF;
104:
105: open DEALER;

Line 102: xtr_debug_pkg.debug('PRODUCT_RATE_CHANGE: ' || 'p_new_interest_rate = ' ||p_new_interest_rate );

98: xtr_debug_pkg.debug('PRODUCT_RATE_CHANGE: ' || 'p_min_balance = ' ||p_min_balance );
99: xtr_debug_pkg.debug('PRODUCT_RATE_CHANGE: ' || 'p_max_balance = ' ||p_max_balance );
100: xtr_debug_pkg.debug('PRODUCT_RATE_CHANGE: ' || 'p_change_pi_yn = ' ||p_change_pi_yn );
101: xtr_debug_pkg.debug('PRODUCT_RATE_CHANGE: ' || 'p_change_pi_yn = ' ||p_change_pi_yn );
102: xtr_debug_pkg.debug('PRODUCT_RATE_CHANGE: ' || 'p_new_interest_rate = ' ||p_new_interest_rate );
103: END IF;
104:
105: open DEALER;
106: fetch DEALER into p_created_by;

Line 116: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

112:
113: l_effective_from_date := to_date(
114: to_date(p_effective_from_date, 'YYYY/MM/DD HH24:MI:SS'), 'DD-MON-RR');
115:
116: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
117: xtr_debug_pkg.debug('PRODUCT_RATE_CHANGE: ' || 'l_effective_from_date = ' ||l_effective_from_date );
118: END IF;
119:
120: FOR deal in DEAL_CUR LOOP

Line 117: xtr_debug_pkg.debug('PRODUCT_RATE_CHANGE: ' || 'l_effective_from_date = ' ||l_effective_from_date );

113: l_effective_from_date := to_date(
114: to_date(p_effective_from_date, 'YYYY/MM/DD HH24:MI:SS'), 'DD-MON-RR');
115:
116: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
117: xtr_debug_pkg.debug('PRODUCT_RATE_CHANGE: ' || 'l_effective_from_date = ' ||l_effective_from_date );
118: END IF;
119:
120: FOR deal in DEAL_CUR LOOP
121: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

Line 121: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

117: xtr_debug_pkg.debug('PRODUCT_RATE_CHANGE: ' || 'l_effective_from_date = ' ||l_effective_from_date );
118: END IF;
119:
120: FOR deal in DEAL_CUR LOOP
121: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
122: xtr_debug_pkg.debug('PRODUCT_RATE_CHANGE: ' || 'deal_no = ' ||deal.DEAL_NO );
123: END IF;
124:
125: ----IF deal.DEAL_NO = 13135 THEN ----------------------------

Line 122: xtr_debug_pkg.debug('PRODUCT_RATE_CHANGE: ' || 'deal_no = ' ||deal.DEAL_NO );

118: END IF;
119:
120: FOR deal in DEAL_CUR LOOP
121: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
122: xtr_debug_pkg.debug('PRODUCT_RATE_CHANGE: ' || 'deal_no = ' ||deal.DEAL_NO );
123: END IF;
124:
125: ----IF deal.DEAL_NO = 13135 THEN ----------------------------
126: