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_RGM_GST_ACCOUNTING_PKG dependencies on JAI_CONSTANTS

Line 57: pv_currency_code IN VARCHAR2 DEFAULT jai_constants.func_curr,

53: pn_balancing_orgn_id IN NUMBER DEFAULT NULL,
54: pn_balancing_location_id IN NUMBER DEFAULT NULL,
55: pv_balancing_tax_type IN VARCHAR2 DEFAULT NULL,
56: pv_balancing_accnt_name IN VARCHAR2 DEFAULT NULL,
57: pv_currency_code IN VARCHAR2 DEFAULT jai_constants.func_curr,
58: pd_curr_conv_date IN DATE DEFAULT NULL,
59: pv_curr_conv_type IN VARCHAR2 DEFAULT NULL,
60: pn_curr_conv_rate IN VARCHAR2 DEFAULT NULL,
61: pn_trx_amount IN NUMBER DEFAULT NULL,

Line 112: AND registration_type = jai_constants.regn_type_others

108: FROM jai_rgm_org_regns_v
109: WHERE regime_id = pn_regime_id
110: AND organization_id = pn_organization_id
111: AND organization_type = pv_organization_type
112: AND registration_type = jai_constants.regn_type_others
113: AND attribute_Type_code = 'PRIMARY';
114:
115: CURSOR cur_fetch_ou(cpn_organization_id NUMBER)
116: IS

Line 149: ln_amount := round(pn_amount, jai_constants.service_rgm_rnd_factor);

145:
146: lv_statement := '1';
147:
148: -- Rounding of Service Tax that is hitting repository
149: ln_amount := round(pn_amount, jai_constants.service_rgm_rnd_factor);
150:
151: IF pn_trx_amount = 0 OR pn_trx_amount IS NULL THEN
152: ln_trx_amount := NULL;
153: ELSE

Line 154: ln_trx_amount := round(pn_trx_amount, jai_constants.service_rgm_rnd_factor);

150:
151: IF pn_trx_amount = 0 OR pn_trx_amount IS NULL THEN
152: ln_trx_amount := NULL;
153: ELSE
154: ln_trx_amount := round(pn_trx_amount, jai_constants.service_rgm_rnd_factor);
155: END IF;
156:
157: lv_statement := '2';
158:

Line 163: IF pv_source = jai_constants.source_ap THEN

159: lv_codepath := jai_general_pkg.plot_codepath(2.1, lv_codepath);
160:
161: lv_statement := '2.1';
162:
163: IF pv_source = jai_constants.source_ap THEN
164: lv_statement := '3';
165: lv_codepath := jai_general_pkg.plot_codepath(3, lv_codepath);
166: lv_register_entry_type := jai_constants.credit;
167: lv_account_name := jai_constants.recovery;

Line 166: lv_register_entry_type := jai_constants.credit;

162:
163: IF pv_source = jai_constants.source_ap THEN
164: lv_statement := '3';
165: lv_codepath := jai_general_pkg.plot_codepath(3, lv_codepath);
166: lv_register_entry_type := jai_constants.credit;
167: lv_account_name := jai_constants.recovery;
168: lv_balancing_accnt_name := jai_constants.recovery_interim;
169:
170:

Line 167: lv_account_name := jai_constants.recovery;

163: IF pv_source = jai_constants.source_ap THEN
164: lv_statement := '3';
165: lv_codepath := jai_general_pkg.plot_codepath(3, lv_codepath);
166: lv_register_entry_type := jai_constants.credit;
167: lv_account_name := jai_constants.recovery;
168: lv_balancing_accnt_name := jai_constants.recovery_interim;
169:
170:
171: ELSIF pv_source = jai_constants.source_ar THEN

Line 168: lv_balancing_accnt_name := jai_constants.recovery_interim;

164: lv_statement := '3';
165: lv_codepath := jai_general_pkg.plot_codepath(3, lv_codepath);
166: lv_register_entry_type := jai_constants.credit;
167: lv_account_name := jai_constants.recovery;
168: lv_balancing_accnt_name := jai_constants.recovery_interim;
169:
170:
171: ELSIF pv_source = jai_constants.source_ar THEN
172: lv_statement := '4';

Line 171: ELSIF pv_source = jai_constants.source_ar THEN

167: lv_account_name := jai_constants.recovery;
168: lv_balancing_accnt_name := jai_constants.recovery_interim;
169:
170:
171: ELSIF pv_source = jai_constants.source_ar THEN
172: lv_statement := '4';
173: lv_codepath := jai_general_pkg.plot_codepath(4, lv_codepath);
174: lv_register_entry_type := jai_constants.debit;
175: lv_account_name := jai_constants.liability;

Line 174: lv_register_entry_type := jai_constants.debit;

170:
171: ELSIF pv_source = jai_constants.source_ar THEN
172: lv_statement := '4';
173: lv_codepath := jai_general_pkg.plot_codepath(4, lv_codepath);
174: lv_register_entry_type := jai_constants.debit;
175: lv_account_name := jai_constants.liability;
176: lv_balancing_accnt_name := jai_constants.liability_interim;
177:
178:

Line 175: lv_account_name := jai_constants.liability;

171: ELSIF pv_source = jai_constants.source_ar THEN
172: lv_statement := '4';
173: lv_codepath := jai_general_pkg.plot_codepath(4, lv_codepath);
174: lv_register_entry_type := jai_constants.debit;
175: lv_account_name := jai_constants.liability;
176: lv_balancing_accnt_name := jai_constants.liability_interim;
177:
178:
179: ELSIF pv_source = jai_constants.source_manual_entry THEN

Line 176: lv_balancing_accnt_name := jai_constants.liability_interim;

172: lv_statement := '4';
173: lv_codepath := jai_general_pkg.plot_codepath(4, lv_codepath);
174: lv_register_entry_type := jai_constants.debit;
175: lv_account_name := jai_constants.liability;
176: lv_balancing_accnt_name := jai_constants.liability_interim;
177:
178:
179: ELSIF pv_source = jai_constants.source_manual_entry THEN
180: lv_statement := '5';

Line 179: ELSIF pv_source = jai_constants.source_manual_entry THEN

175: lv_account_name := jai_constants.liability;
176: lv_balancing_accnt_name := jai_constants.liability_interim;
177:
178:
179: ELSIF pv_source = jai_constants.source_manual_entry THEN
180: lv_statement := '5';
181: lv_codepath := jai_general_pkg.plot_codepath(5, lv_codepath);
182: lv_account_name := pv_account_name;
183: IF lv_account_name IN (jai_constants.recovery, jai_constants.recovery_interim) THEN

Line 183: IF lv_account_name IN (jai_constants.recovery, jai_constants.recovery_interim) THEN

179: ELSIF pv_source = jai_constants.source_manual_entry THEN
180: lv_statement := '5';
181: lv_codepath := jai_general_pkg.plot_codepath(5, lv_codepath);
182: lv_account_name := pv_account_name;
183: IF lv_account_name IN (jai_constants.recovery, jai_constants.recovery_interim) THEN
184: lv_codepath := jai_general_pkg.plot_codepath(6, lv_codepath);
185: lv_register_entry_type := jai_constants.credit;
186: ELSIF lv_account_name IN (jai_constants.liability, jai_constants.liability_interim) THEN
187: lv_codepath := jai_general_pkg.plot_codepath(7, lv_codepath);

Line 185: lv_register_entry_type := jai_constants.credit;

181: lv_codepath := jai_general_pkg.plot_codepath(5, lv_codepath);
182: lv_account_name := pv_account_name;
183: IF lv_account_name IN (jai_constants.recovery, jai_constants.recovery_interim) THEN
184: lv_codepath := jai_general_pkg.plot_codepath(6, lv_codepath);
185: lv_register_entry_type := jai_constants.credit;
186: ELSIF lv_account_name IN (jai_constants.liability, jai_constants.liability_interim) THEN
187: lv_codepath := jai_general_pkg.plot_codepath(7, lv_codepath);
188: lv_register_entry_type := jai_constants.debit;
189: END IF;

Line 186: ELSIF lv_account_name IN (jai_constants.liability, jai_constants.liability_interim) THEN

182: lv_account_name := pv_account_name;
183: IF lv_account_name IN (jai_constants.recovery, jai_constants.recovery_interim) THEN
184: lv_codepath := jai_general_pkg.plot_codepath(6, lv_codepath);
185: lv_register_entry_type := jai_constants.credit;
186: ELSIF lv_account_name IN (jai_constants.liability, jai_constants.liability_interim) THEN
187: lv_codepath := jai_general_pkg.plot_codepath(7, lv_codepath);
188: lv_register_entry_type := jai_constants.debit;
189: END IF;
190:

Line 188: lv_register_entry_type := jai_constants.debit;

184: lv_codepath := jai_general_pkg.plot_codepath(6, lv_codepath);
185: lv_register_entry_type := jai_constants.credit;
186: ELSIF lv_account_name IN (jai_constants.liability, jai_constants.liability_interim) THEN
187: lv_codepath := jai_general_pkg.plot_codepath(7, lv_codepath);
188: lv_register_entry_type := jai_constants.debit;
189: END IF;
190:
191: /* Incase of Distributions and settlements, we hit only recovery account and decrease/increase
192: repository amounts as per _OUT/_IN trxns*/

Line 193: ELSIF (pv_source IN (jai_constants.service_src_distribute_out) AND nvl(pv_distribution_type,'X')='S-S'

189: END IF;
190:
191: /* Incase of Distributions and settlements, we hit only recovery account and decrease/increase
192: repository amounts as per _OUT/_IN trxns*/
193: ELSIF (pv_source IN (jai_constants.service_src_distribute_out) AND nvl(pv_distribution_type,'X')='S-S'
194: AND nvl(ln_org_id,0)=nvl(ln_bal_org_id,0)) or (pv_source in( jai_constants.source_settle_out,jai_constants.service_src_distribute_out)
195: AND nvl(pv_distribution_type,'X')='X' )
196: THEN
197: lv_statement := '6';

Line 194: AND nvl(ln_org_id,0)=nvl(ln_bal_org_id,0)) or (pv_source in( jai_constants.source_settle_out,jai_constants.service_src_distribute_out)

190:
191: /* Incase of Distributions and settlements, we hit only recovery account and decrease/increase
192: repository amounts as per _OUT/_IN trxns*/
193: ELSIF (pv_source IN (jai_constants.service_src_distribute_out) AND nvl(pv_distribution_type,'X')='S-S'
194: AND nvl(ln_org_id,0)=nvl(ln_bal_org_id,0)) or (pv_source in( jai_constants.source_settle_out,jai_constants.service_src_distribute_out)
195: AND nvl(pv_distribution_type,'X')='X' )
196: THEN
197: lv_statement := '6';
198: lv_codepath := jai_general_pkg.plot_codepath(8, lv_codepath);

Line 199: lv_register_entry_type := jai_constants.debit;

195: AND nvl(pv_distribution_type,'X')='X' )
196: THEN
197: lv_statement := '6';
198: lv_codepath := jai_general_pkg.plot_codepath(8, lv_codepath);
199: lv_register_entry_type := jai_constants.debit;
200: lv_account_name := jai_constants.recovery;
201: lv_balancing_accnt_name := jai_constants.recovery;
202:
203: IF (pv_source = jai_constants.source_settle_out) THEN

Line 200: lv_account_name := jai_constants.recovery;

196: THEN
197: lv_statement := '6';
198: lv_codepath := jai_general_pkg.plot_codepath(8, lv_codepath);
199: lv_register_entry_type := jai_constants.debit;
200: lv_account_name := jai_constants.recovery;
201: lv_balancing_accnt_name := jai_constants.recovery;
202:
203: IF (pv_source = jai_constants.source_settle_out) THEN
204: lv_balancing_accnt_name := jai_constants.liability;

Line 201: lv_balancing_accnt_name := jai_constants.recovery;

197: lv_statement := '6';
198: lv_codepath := jai_general_pkg.plot_codepath(8, lv_codepath);
199: lv_register_entry_type := jai_constants.debit;
200: lv_account_name := jai_constants.recovery;
201: lv_balancing_accnt_name := jai_constants.recovery;
202:
203: IF (pv_source = jai_constants.source_settle_out) THEN
204: lv_balancing_accnt_name := jai_constants.liability;
205: END IF;

Line 203: IF (pv_source = jai_constants.source_settle_out) THEN

199: lv_register_entry_type := jai_constants.debit;
200: lv_account_name := jai_constants.recovery;
201: lv_balancing_accnt_name := jai_constants.recovery;
202:
203: IF (pv_source = jai_constants.source_settle_out) THEN
204: lv_balancing_accnt_name := jai_constants.liability;
205: END IF;
206:
207: ELSIF (pv_source IN (jai_constants.service_src_distribute_in)

Line 204: lv_balancing_accnt_name := jai_constants.liability;

200: lv_account_name := jai_constants.recovery;
201: lv_balancing_accnt_name := jai_constants.recovery;
202:
203: IF (pv_source = jai_constants.source_settle_out) THEN
204: lv_balancing_accnt_name := jai_constants.liability;
205: END IF;
206:
207: ELSIF (pv_source IN (jai_constants.service_src_distribute_in)
208: AND NVL(pv_distribution_type,'X')='S-S'

Line 207: ELSIF (pv_source IN (jai_constants.service_src_distribute_in)

203: IF (pv_source = jai_constants.source_settle_out) THEN
204: lv_balancing_accnt_name := jai_constants.liability;
205: END IF;
206:
207: ELSIF (pv_source IN (jai_constants.service_src_distribute_in)
208: AND NVL(pv_distribution_type,'X')='S-S'
209: AND nvl(ln_org_id,0)=nvl(ln_bal_org_id,0)) OR (pv_source in( jai_constants.source_settle_in,jai_constants.service_src_distribute_in)
210: AND nvl(pv_distribution_type,'X')='X')
211: THEN

Line 209: AND nvl(ln_org_id,0)=nvl(ln_bal_org_id,0)) OR (pv_source in( jai_constants.source_settle_in,jai_constants.service_src_distribute_in)

205: END IF;
206:
207: ELSIF (pv_source IN (jai_constants.service_src_distribute_in)
208: AND NVL(pv_distribution_type,'X')='S-S'
209: AND nvl(ln_org_id,0)=nvl(ln_bal_org_id,0)) OR (pv_source in( jai_constants.source_settle_in,jai_constants.service_src_distribute_in)
210: AND nvl(pv_distribution_type,'X')='X')
211: THEN
212: lv_statement := '7';
213: lv_codepath := jai_general_pkg.plot_codepath(9, lv_codepath);

Line 214: lv_register_entry_type := jai_constants.credit;

210: AND nvl(pv_distribution_type,'X')='X')
211: THEN
212: lv_statement := '7';
213: lv_codepath := jai_general_pkg.plot_codepath(9, lv_codepath);
214: lv_register_entry_type := jai_constants.credit;
215: lv_account_name := jai_constants.recovery;
216: lv_balancing_accnt_name := jai_constants.recovery;
217: IF (pv_source = jai_constants.source_settle_in) THEN
218: lv_account_name := jai_constants.liability;

Line 215: lv_account_name := jai_constants.recovery;

211: THEN
212: lv_statement := '7';
213: lv_codepath := jai_general_pkg.plot_codepath(9, lv_codepath);
214: lv_register_entry_type := jai_constants.credit;
215: lv_account_name := jai_constants.recovery;
216: lv_balancing_accnt_name := jai_constants.recovery;
217: IF (pv_source = jai_constants.source_settle_in) THEN
218: lv_account_name := jai_constants.liability;
219: END IF;

Line 216: lv_balancing_accnt_name := jai_constants.recovery;

212: lv_statement := '7';
213: lv_codepath := jai_general_pkg.plot_codepath(9, lv_codepath);
214: lv_register_entry_type := jai_constants.credit;
215: lv_account_name := jai_constants.recovery;
216: lv_balancing_accnt_name := jai_constants.recovery;
217: IF (pv_source = jai_constants.source_settle_in) THEN
218: lv_account_name := jai_constants.liability;
219: END IF;
220:

Line 217: IF (pv_source = jai_constants.source_settle_in) THEN

213: lv_codepath := jai_general_pkg.plot_codepath(9, lv_codepath);
214: lv_register_entry_type := jai_constants.credit;
215: lv_account_name := jai_constants.recovery;
216: lv_balancing_accnt_name := jai_constants.recovery;
217: IF (pv_source = jai_constants.source_settle_in) THEN
218: lv_account_name := jai_constants.liability;
219: END IF;
220:
221: ELSIF ( pv_source IN (jai_constants.service_src_distribute_out)

Line 218: lv_account_name := jai_constants.liability;

214: lv_register_entry_type := jai_constants.credit;
215: lv_account_name := jai_constants.recovery;
216: lv_balancing_accnt_name := jai_constants.recovery;
217: IF (pv_source = jai_constants.source_settle_in) THEN
218: lv_account_name := jai_constants.liability;
219: END IF;
220:
221: ELSIF ( pv_source IN (jai_constants.service_src_distribute_out)
222: AND NVL(pv_distribution_type,'X')='S-S'

Line 221: ELSIF ( pv_source IN (jai_constants.service_src_distribute_out)

217: IF (pv_source = jai_constants.source_settle_in) THEN
218: lv_account_name := jai_constants.liability;
219: END IF;
220:
221: ELSIF ( pv_source IN (jai_constants.service_src_distribute_out)
222: AND NVL(pv_distribution_type,'X')='S-S'
223: AND nvl(ln_org_id,0)<>nvl(ln_bal_org_id,0) )
224: THEN
225:

Line 232: lv_register_entry_type := jai_constants.debit;

228: CLOSE cur_interorg_accts;
229:
230: lv_statement := '8';
231: lv_codepath := jai_general_pkg.plot_codepath(10, lv_codepath);
232: lv_register_entry_type := jai_constants.debit;
233: lv_account_name := jai_constants.recovery;
234: lv_balancing_accnt_name :='InterOrg Receivable Account';
235: ln_balancing_account_id :=r_interorg_accts.interorg_receivables_account;
236:

Line 233: lv_account_name := jai_constants.recovery;

229:
230: lv_statement := '8';
231: lv_codepath := jai_general_pkg.plot_codepath(10, lv_codepath);
232: lv_register_entry_type := jai_constants.debit;
233: lv_account_name := jai_constants.recovery;
234: lv_balancing_accnt_name :='InterOrg Receivable Account';
235: ln_balancing_account_id :=r_interorg_accts.interorg_receivables_account;
236:
237: ELSIF ( pv_source IN (jai_constants.service_src_distribute_in)

Line 237: ELSIF ( pv_source IN (jai_constants.service_src_distribute_in)

233: lv_account_name := jai_constants.recovery;
234: lv_balancing_accnt_name :='InterOrg Receivable Account';
235: ln_balancing_account_id :=r_interorg_accts.interorg_receivables_account;
236:
237: ELSIF ( pv_source IN (jai_constants.service_src_distribute_in)
238: AND NVL(pv_distribution_type,'X')='S-S'
239: AND nvl(ln_org_id,0)<>nvl(ln_bal_org_id,0) ) THEN
240:
241: open cur_interorg_accts(pn_organization_id);

Line 246: lv_register_entry_type := jai_constants.credit;

242: fetch cur_interorg_accts into r_interorg_accts;
243: close cur_interorg_accts;
244: lv_statement := '9';
245: lv_codepath := jai_general_pkg.plot_codepath(11, lv_codepath);
246: lv_register_entry_type := jai_constants.credit;
247: lv_account_name := jai_constants.recovery;
248:
249: lv_balancing_accnt_name := 'Interorg Payable Account';
250: ln_balancing_account_id :=r_interorg_accts.interorg_payables_account;

Line 247: lv_account_name := jai_constants.recovery;

243: close cur_interorg_accts;
244: lv_statement := '9';
245: lv_codepath := jai_general_pkg.plot_codepath(11, lv_codepath);
246: lv_register_entry_type := jai_constants.credit;
247: lv_account_name := jai_constants.recovery;
248:
249: lv_balancing_accnt_name := 'Interorg Payable Account';
250: ln_balancing_account_id :=r_interorg_accts.interorg_payables_account;
251: END IF;

Line 253: IF lv_register_entry_type = jai_constants.debit THEN

249: lv_balancing_accnt_name := 'Interorg Payable Account';
250: ln_balancing_account_id :=r_interorg_accts.interorg_payables_account;
251: END IF;
252:
253: IF lv_register_entry_type = jai_constants.debit THEN
254: lv_statement := '10';
255: lv_codepath := jai_general_pkg.plot_codepath(10, lv_codepath);
256: ln_debit := ln_amount;
257: ln_credit := NULL;

Line 420: pv_process_flag := jai_constants.successful;

416: pv_service_type_code /* service_type_code */
417: ) RETURNING repository_id INTO pn_repository_id;
418:
419: lv_statement := '18';
420: pv_process_flag := jai_constants.successful;
421: pv_process_message := 'Successful';
422:
423: EXCEPTION
424: WHEN OTHERS THEN

Line 425: pv_process_flag := jai_constants.unexpected_error;

421: pv_process_message := 'Successful';
422:
423: EXCEPTION
424: WHEN OTHERS THEN
425: pv_process_flag := jai_constants.unexpected_error;
426: pv_process_message := 'Repository Error(Stmt:'||lv_statement||') Occured:'||SQLERRM;
427: lv_codepath := jai_general_pkg.plot_codepath(-999, lv_codepath);
428:
429: END create_repository_entry;