[Home] [Help]
122: ln_debit_amount NUMBER;
123: lv_statement NUMBER;
124:
125: BEGIN
126: lv_source := jai_constants.source_settle_out;
127: ln_credit_amount:= NULL; --- these amounts are with respect to repository not w.r.t accounting
128: ln_debit_amount := p_to_trx_amount; --- its is reverse w.r.t accounting
129:
130:
133: p_organization_type => p_from_party_type,
134: p_organization_id => p_from_party_id,
135: p_location_id => p_from_locn_id,
136: p_tax_type => p_from_tax_type,
137: p_account_name => jai_constants.recovery
138: );
139:
140: ln_balance_accounting_id := jai_cmn_rgm_recording_pkg.get_account(
141: p_regime_id => p_regime_id,
142: p_organization_type => p_to_party_type,
143: p_organization_id => p_to_party_id,
144: p_location_id => p_to_locn_id,
145: p_tax_type => p_to_tax_type,
146: p_account_name => jai_constants.recovery
147: );
148:
149:
150: jai_cmn_rgm_recording_pkg.insert_vat_repository_entry(
158: pv_source_trx_type => p_source_trx_type ,
159: pv_source_table_name => p_source_table_name,
160: pn_source_id => p_source_doc_id ,
161: pd_transaction_date => p_trx_date,
162: pv_account_name => jai_constants.recovery,
163: pn_charge_account_id => ln_charge_accounting_id,
164: pn_balancing_account_id => ln_balance_accounting_id,
165: pn_credit_amount => ln_credit_amount,
166: pn_debit_amount => ln_debit_amount,
203: pv_source => lv_source,
204: pv_source_trx_type => p_source_trx_type,
205: pv_source_table_name => p_source_table_name,
206: pn_source_id => p_source_doc_id,
207: pv_reference_name => jai_constants.repository_name,
208: pn_reference_id => ln_repository_id
209: );
210:
211: IF p_process_flag <> 'SS' THEN
216:
217: /*for destination*/
218:
219:
220: lv_source := jai_constants.source_settle_in ;
221: ln_credit_amount := p_from_trx_amount; --- these amounts are with respect to repository not w.r.t accounting
222: ln_debit_amount := NULL; --- its is reverse w.r.t accounting
223:
224: ln_charge_accounting_id := jai_cmn_rgm_recording_pkg.get_account(
226: p_organization_type => p_to_party_type,
227: p_organization_id => p_to_party_id,
228: p_location_id => p_to_locn_id,
229: p_tax_type => p_to_tax_type,
230: p_account_name => jai_constants.recovery
231: );
232:
233: ln_balance_accounting_id := jai_cmn_rgm_recording_pkg.get_account(
234: p_regime_id => p_regime_id,
235: p_organization_type => p_from_party_type,
236: p_organization_id => p_from_party_id,
237: p_location_id => p_from_locn_id,
238: p_tax_type => p_from_tax_type,
239: p_account_name => jai_constants.recovery
240: );
241:
242:
243: jai_cmn_rgm_recording_pkg.insert_vat_repository_entry(
251: pv_source_trx_type => p_source_trx_type ,
252: pv_source_table_name => p_source_table_name,
253: pn_source_id => p_source_doc_id ,
254: pd_transaction_date => p_trx_date,
255: pv_account_name => jai_constants.recovery,
256: pn_charge_account_id => ln_charge_accounting_id,
257: pn_balancing_account_id => ln_balance_accounting_id,
258: pn_credit_amount => ln_credit_amount,
259: pn_debit_amount => ln_debit_amount,
296: pv_source => lv_source,
297: pv_source_trx_type => p_source_trx_type,
298: pv_source_table_name => p_source_table_name,
299: pn_source_id => p_source_doc_id,
300: pv_reference_name => jai_constants.repository_name,
301: pn_reference_id => ln_repository_id
302: );
303:
304:
609: END IF;
610:
611: END IF;
612:
613: IF lv_regime_code = jai_constants.service_regime THEN
614: lv_organization_type := jai_constants.orgn_type_io;/* added by ssawant for bug 5879769 */
615: ln_acct_amount := ROUND(ln_acct_amount, jai_constants.service_rgm_rnd_factor);
616: ELSIF lv_regime_code = jai_constants.vat_regime THEN
617: lv_organization_type := jai_constants.orgn_type_io;
610:
611: END IF;
612:
613: IF lv_regime_code = jai_constants.service_regime THEN
614: lv_organization_type := jai_constants.orgn_type_io;/* added by ssawant for bug 5879769 */
615: ln_acct_amount := ROUND(ln_acct_amount, jai_constants.service_rgm_rnd_factor);
616: ELSIF lv_regime_code = jai_constants.vat_regime THEN
617: lv_organization_type := jai_constants.orgn_type_io;
618: ln_acct_amount := ROUND(ln_acct_amount, jai_constants.vat_rgm_rnd_factor);
611: END IF;
612:
613: IF lv_regime_code = jai_constants.service_regime THEN
614: lv_organization_type := jai_constants.orgn_type_io;/* added by ssawant for bug 5879769 */
615: ln_acct_amount := ROUND(ln_acct_amount, jai_constants.service_rgm_rnd_factor);
616: ELSIF lv_regime_code = jai_constants.vat_regime THEN
617: lv_organization_type := jai_constants.orgn_type_io;
618: ln_acct_amount := ROUND(ln_acct_amount, jai_constants.vat_rgm_rnd_factor);
619: END IF;
612:
613: IF lv_regime_code = jai_constants.service_regime THEN
614: lv_organization_type := jai_constants.orgn_type_io;/* added by ssawant for bug 5879769 */
615: ln_acct_amount := ROUND(ln_acct_amount, jai_constants.service_rgm_rnd_factor);
616: ELSIF lv_regime_code = jai_constants.vat_regime THEN
617: lv_organization_type := jai_constants.orgn_type_io;
618: ln_acct_amount := ROUND(ln_acct_amount, jai_constants.vat_rgm_rnd_factor);
619: END IF;
620:
613: IF lv_regime_code = jai_constants.service_regime THEN
614: lv_organization_type := jai_constants.orgn_type_io;/* added by ssawant for bug 5879769 */
615: ln_acct_amount := ROUND(ln_acct_amount, jai_constants.service_rgm_rnd_factor);
616: ELSIF lv_regime_code = jai_constants.vat_regime THEN
617: lv_organization_type := jai_constants.orgn_type_io;
618: ln_acct_amount := ROUND(ln_acct_amount, jai_constants.vat_rgm_rnd_factor);
619: END IF;
620:
621: IF ln_acct_amount <> 0 THEN /* added by ssawant for bug 6020629 */
614: lv_organization_type := jai_constants.orgn_type_io;/* added by ssawant for bug 5879769 */
615: ln_acct_amount := ROUND(ln_acct_amount, jai_constants.service_rgm_rnd_factor);
616: ELSIF lv_regime_code = jai_constants.vat_regime THEN
617: lv_organization_type := jai_constants.orgn_type_io;
618: ln_acct_amount := ROUND(ln_acct_amount, jai_constants.vat_rgm_rnd_factor);
619: END IF;
620:
621: IF ln_acct_amount <> 0 THEN /* added by ssawant for bug 6020629 */
622: ln_charge_accounting_id :=
624: p_organization_type => lv_organization_type,
625: p_organization_id => r_acct_balances.party_id,
626: p_location_id => r_acct_balances.location_id,
627: p_tax_type => r_acct_balances.tax_type,
628: p_account_name => jai_constants.liability);
629:
630:
631: jai_cmn_rgm_recording_pkg.post_accounting(
632: p_regime_code => lv_regime_code,
632: p_regime_code => lv_regime_code,
633: p_tax_type => r_acct_balances.tax_type,
634: p_organization_type => lv_organization_type,
635: p_organization_id => r_acct_balances.party_id,
636: p_source => jai_constants.source_settle_in,
637: p_source_trx_type => 'Invoice Payment',
638: p_source_table_name => 'JAI_RGM_SETTLEMENTS',
639: p_source_document_id => pn_settlement_id,
640: p_code_combination_id => ln_charge_accounting_id,
645: -- p_accounting_date => SYSDATE, commented by anujsax for bug #6126142
646: p_accounting_date => r_acct_balances.settlement_date, --added by anujsax for Bug#6126142
647: p_transaction_date => r_acct_balances.settlement_date,
648: p_calling_object => 'JAIRGMSP',
649: p_repository_name => jai_constants.repository_name,
650: p_repository_id => NULL,
651: p_reference_name => NULL,
652: p_reference_id => NULL,
653: p_currency_code => jai_constants.func_curr);
649: p_repository_name => jai_constants.repository_name,
650: p_repository_id => NULL,
651: p_reference_name => NULL,
652: p_reference_id => NULL,
653: p_currency_code => jai_constants.func_curr);
654:
655: IF pv_process_flag <> 'SS' THEN
656: goto MAIN_EXIT;
657: END IF;
665: p_organization_type => lv_organization_type,
666: p_organization_id => r_acct_balances.party_id,
667: p_location_id => r_acct_balances.location_id,
668: p_tax_type => r_acct_balances.tax_type,
669: p_account_name => jai_constants.recovery);
670:
671: jai_cmn_rgm_recording_pkg.post_accounting(
672: p_regime_code => lv_regime_code,
673: p_tax_type => r_acct_balances.tax_type,
672: p_regime_code => lv_regime_code,
673: p_tax_type => r_acct_balances.tax_type,
674: p_organization_type => lv_organization_type,
675: p_organization_id => r_acct_balances.party_id,
676: p_source => jai_constants.source_settle_in,
677: p_source_trx_type => 'Invoice Payment',
678: p_source_table_name => 'JAI_RGM_SETTLEMENTS',
679: p_source_document_id => pn_settlement_id,
680: p_code_combination_id => ln_charge_accounting_id,
685: -- p_accounting_date => SYSDATE, commented by anujsax for bug #6126142
686: p_accounting_date => r_acct_balances.settlement_date, --added by anujsax for Bug#6126142
687: p_transaction_date => r_acct_balances.settlement_date,
688: p_calling_object => 'JAIRGMSP',
689: p_repository_name => jai_constants.repository_name,
690: p_repository_id => NULL,
691: p_reference_name => NULL,
692: p_reference_id => NULL,
693: p_currency_code => jai_constants.func_curr);
689: p_repository_name => jai_constants.repository_name,
690: p_repository_id => NULL,
691: p_reference_name => NULL,
692: p_reference_id => NULL,
693: p_currency_code => jai_constants.func_curr);
694:
695: IF pv_process_flag <> 'SS' THEN
696: goto MAIN_EXIT;
697: END IF;
758: FETCH cur_regime_code INTO lv_regime_code;
759: CLOSE cur_regime_code;
760:
761:
762: IF lv_regime_code = jai_constants.service_regime THEN /* 4245365*/
763:
764:
765: jai_cmn_rgm_tax_dist_pkg.insert_records_into_register
766: (p_repository_id => ln_repository_id,
778: p_to_service_type => cur_debit.service_type_code,/* added by ssawant for bug 5879769 */
779: p_to_trx_amount => ln_transfer_amt,
780: p_called_from => 'SETTLEMENT',
781: p_trx_date => i.settlement_date,
782: p_acct_req => jai_constants.yes,
783: p_source => 'SETTLEMENT',
784: p_source_trx_type => 'SETTLEMENT',
785: p_source_table_name => 'JAI_RGM_SETTLEMENTS',
786: p_source_doc_id => pn_settlement_id,
793: IF pv_process_flag <> 'SS' THEN
794: goto MAIN_EXIT;
795: END IF;
796:
797: ELSIF lv_regime_code = jai_constants.vat_regime THEN /* 4245365*/
798:
799:
800: OPEN cur_dist_detail;
801: FETCH cur_dist_detail INTO ln_dist_dtl_id;
814: p_to_tax_type => i.tax_type,
815: p_to_trx_amount => ln_transfer_amt,
816: p_called_from => 'SETTLEMENT',
817: p_trx_date => i.settlement_date,
818: p_acct_req => jai_constants.yes,
819: p_source => 'SETTLEMENT',
820: p_source_trx_type => 'SETTLEMENT',
821: p_source_table_name => 'JAI_RGM_SETTLEMENTS',
822: p_source_doc_id => ln_dist_dtl_id,
1234: FOR i IN cur_distributions_SERVICE LOOP /* added by ssawant for bug 5879769 */
1235:
1236: ln_dist_code_combination_id := jai_cmn_rgm_recording_pkg.get_account(
1237: p_regime_id => pn_regime_id,
1238: p_organization_type => jai_constants.orgn_type_io,/* added by ssawant for bug 5879769 */
1239: p_organization_id => i.party_id,/* added by ssawant for bug 5879769 */
1240: p_location_id => i.location_id,/* added by ssawant for bug 5879769 */
1241: p_tax_type => i.tax_type,
1242: p_account_name => jai_constants.liability);
1238: p_organization_type => jai_constants.orgn_type_io,/* added by ssawant for bug 5879769 */
1239: p_organization_id => i.party_id,/* added by ssawant for bug 5879769 */
1240: p_location_id => i.location_id,/* added by ssawant for bug 5879769 */
1241: p_tax_type => i.tax_type,
1242: p_account_name => jai_constants.liability);
1243:
1244: IF ln_dist_code_combination_id IS NULL THEN
1245: pv_process_flag := 'EE';
1246: pv_process_message := 'There is no account defined for AP Invoice creation. Can''t proceed';
1276: FOR i IN cur_distributions_VAT LOOP
1277:
1278: ln_dist_code_combination_id := jai_cmn_rgm_recording_pkg.get_account(
1279: p_regime_id => pn_regime_id,
1280: p_organization_type => jai_constants.orgn_type_io,
1281: p_organization_id => i.party_id,
1282: p_location_id => i.location_id,
1283: p_tax_type => i.tax_type,
1284: p_account_name => jai_constants.liability);
1280: p_organization_type => jai_constants.orgn_type_io,
1281: p_organization_id => i.party_id,
1282: p_location_id => i.location_id,
1283: p_tax_type => i.tax_type,
1284: p_account_name => jai_constants.liability);
1285:
1286:
1287: IF ln_dist_code_combination_id IS NULL THEN
1288: pv_process_flag := 'EE';
1313: END IF;
1314: END LOOP;
1315:
1316: /*Added By CSahoo, BUG#5631784*/
1317: ELSIF upper(lv_regime.regime_code) = jai_constants.tcs_regime THEN
1318:
1319: FOR i IN cur_distributions_TCS LOOP
1320:
1321: ln_dist_code_combination_id := jai_cmn_rgm_recording_pkg.get_account(
1319: FOR i IN cur_distributions_TCS LOOP
1320:
1321: ln_dist_code_combination_id := jai_cmn_rgm_recording_pkg.get_account(
1322: p_regime_id => pn_regime_id,
1323: p_organization_type => jai_constants.orgn_type_io,
1324: p_organization_id => i.party_id,
1325: p_location_id => i.location_id,
1326: p_tax_type => i.tax_type,
1327: p_account_name => jai_constants.liability);
1323: p_organization_type => jai_constants.orgn_type_io,
1324: p_organization_id => i.party_id,
1325: p_location_id => i.location_id,
1326: p_tax_type => i.tax_type,
1327: p_account_name => jai_constants.liability);
1328:
1329:
1330: IF ln_dist_code_combination_id IS NULL THEN
1331: pv_process_flag := 'EE';
1385:
1386:
1387: ln_dist_code_combination_id := jai_cmn_rgm_recording_pkg.get_account(
1388: p_regime_id => pn_regime_id,
1389: p_organization_type => jai_constants.orgn_type_ou,
1390: p_organization_id => pn_org_id,
1391: p_location_id => NULL,
1392: p_tax_type => lv_tax_type1,
1393: p_account_name => jai_constants.liability);
1389: p_organization_type => jai_constants.orgn_type_ou,
1390: p_organization_id => pn_org_id,
1391: p_location_id => NULL,
1392: p_tax_type => lv_tax_type1,
1393: p_account_name => jai_constants.liability);
1394:
1395: IF ln_dist_code_combination_id IS NULL THEN
1396: pv_process_flag := 'EE';
1397: pv_process_message := 'There is no account defined for AP Invoice creation. Cannot proceed';
1420:
1421: IF ln_amount2 <> 0 THEN
1422: ln_dist_code_combination_id := jai_cmn_rgm_recording_pkg.get_account(
1423: p_regime_id => pn_regime_id,
1424: p_organization_type => jai_constants.orgn_type_ou,
1425: p_organization_id => pn_org_id,
1426: p_location_id => NULL,
1427: p_tax_type => lv_tax_type2,
1428: p_account_name => jai_constants.liability);
1424: p_organization_type => jai_constants.orgn_type_ou,
1425: p_organization_id => pn_org_id,
1426: p_location_id => NULL,
1427: p_tax_type => lv_tax_type2,
1428: p_account_name => jai_constants.liability);
1429:
1430: IF ln_dist_code_combination_id IS NULL THEN
1431: pv_process_flag := 'EE';
1432: pv_process_message := 'There is no account defined for AP Invoice creation. Cannot proceed';
1467:
1468: IF nvl(ln_amount,0) <> 0 THEN
1469: ln_dist_code_combination_id := jai_cmn_rgm_recording_pkg.get_account(
1470: p_regime_id => pn_regime_id,
1471: p_organization_type => jai_constants.orgn_type_io,
1472: p_organization_id => org_io_rec.party_id,
1473: p_location_id => org_io_rec.location_id,
1474: p_tax_type => lv_tax_type,
1475: p_account_name => jai_constants.liability);
1471: p_organization_type => jai_constants.orgn_type_io,
1472: p_organization_id => org_io_rec.party_id,
1473: p_location_id => org_io_rec.location_id,
1474: p_tax_type => lv_tax_type,
1475: p_account_name => jai_constants.liability);
1476:
1477: IF ln_dist_code_combination_id IS NULL THEN
1478: pv_process_flag := 'EE';
1479: pv_process_message := 'There is no account defined for AP Invoice creation. Cannot proceed';
1812: jai_cmn_rgm_recording_pkg.insert_repository_entry(
1813: p_repository_id => ln_repository_id,
1814: p_regime_id => pn_regime_id,
1815: p_tax_type => i.tax_type,
1816: p_organization_type => jai_constants.orgn_type_io, /* added by ssawant for bug 5879769 */
1817: p_organization_id => i.party_id,
1818: p_location_id => i.location_id , /* added by ssawant for bug 5879769 */
1819: p_source => jai_constants.source_settle_in,
1820: p_source_trx_type => 'Invoice Payment',
1815: p_tax_type => i.tax_type,
1816: p_organization_type => jai_constants.orgn_type_io, /* added by ssawant for bug 5879769 */
1817: p_organization_id => i.party_id,
1818: p_location_id => i.location_id , /* added by ssawant for bug 5879769 */
1819: p_source => jai_constants.source_settle_in,
1820: p_source_trx_type => 'Invoice Payment',
1821: p_source_table_name => 'JAI_RGM_SETTLEMENTS',
1822: p_source_document_id => pn_settlement_id,
1823: p_transaction_date => pd_transaction_date,/* +1 is removed by ssawant for bug 5662296 */
1830: p_tax_rate => NULL,
1831: p_reference_id => NULL,
1832: p_batch_id => NULL,
1833: p_called_from => 'JAIRGMSP',
1834: p_accntg_required_flag => jai_constants.no,
1835: p_process_flag => pv_process_flag,
1836: p_process_message => pv_process_message,
1837: p_accounting_date => pd_transaction_date,
1838: p_currency_code => jai_constants.func_curr, --File.Sql.35 Cbabu
1834: p_accntg_required_flag => jai_constants.no,
1835: p_process_flag => pv_process_flag,
1836: p_process_message => pv_process_message,
1837: p_accounting_date => pd_transaction_date,
1838: p_currency_code => jai_constants.func_curr, --File.Sql.35 Cbabu
1839: p_service_type_code => i.service_type_code /* added by ssawant for bug 5879769 */
1840: );
1841:
1842:
1855:
1856:
1857: ln_charge_accounting_id :=
1858: jai_cmn_rgm_recording_pkg.get_account(p_regime_id => pn_regime_id,
1859: p_organization_type => jai_constants.orgn_type_io,
1860: p_organization_id => i.party_id,
1861: p_location_id => i.location_id,
1862: p_tax_type => i.tax_type,
1863: p_account_name => jai_constants.recovery);
1859: p_organization_type => jai_constants.orgn_type_io,
1860: p_organization_id => i.party_id,
1861: p_location_id => i.location_id,
1862: p_tax_type => i.tax_type,
1863: p_account_name => jai_constants.recovery);
1864:
1865: jai_cmn_rgm_recording_pkg.insert_vat_repository_entry(
1866: pn_repository_id => ln_repository_id,
1867: pn_regime_id => pn_regime_id,
1865: jai_cmn_rgm_recording_pkg.insert_vat_repository_entry(
1866: pn_repository_id => ln_repository_id,
1867: pn_regime_id => pn_regime_id,
1868: pv_tax_type => i.tax_type,
1869: pv_organization_type => jai_constants.orgn_type_io,
1870: pn_organization_id => i.party_id,
1871: pn_location_id => i.location_id,
1872: pv_source => jai_constants.source_settle_in,
1873: pv_source_trx_type => 'Invoice Payment',
1868: pv_tax_type => i.tax_type,
1869: pv_organization_type => jai_constants.orgn_type_io,
1870: pn_organization_id => i.party_id,
1871: pn_location_id => i.location_id,
1872: pv_source => jai_constants.source_settle_in,
1873: pv_source_trx_type => 'Invoice Payment',
1874: pv_source_table_name => 'JAI_RGM_SETTLEMENTS',
1875: pn_source_id => pn_settlement_id,
1876: pd_transaction_date => pd_transaction_date,/* +1 is removed by ssawant for bug 5662296 */
1873: pv_source_trx_type => 'Invoice Payment',
1874: pv_source_table_name => 'JAI_RGM_SETTLEMENTS',
1875: pn_source_id => pn_settlement_id,
1876: pd_transaction_date => pd_transaction_date,/* +1 is removed by ssawant for bug 5662296 */
1877: pv_account_name => jai_constants.recovery,
1878: pn_charge_account_id => ln_charge_accounting_id,
1879: pn_balancing_account_id => NULL,
1880: pn_credit_amount => ln_credit_amount,
1881: pn_debit_amount => ln_debit_amount,
1933: jai_cmn_rgm_recording_pkg.insert_repository_entry(
1934: p_repository_id => ln_repository_id,
1935: p_regime_id => pn_regime_id,
1936: p_tax_type => lv_tax_type1,
1937: p_organization_type => jai_constants.orgn_type_ou,
1938: p_organization_id => ln_org_id,
1939: p_location_id => NULL,
1940: p_source => jai_constants.source_settle_in,
1941: p_source_trx_type => 'Invoice Payment',
1936: p_tax_type => lv_tax_type1,
1937: p_organization_type => jai_constants.orgn_type_ou,
1938: p_organization_id => ln_org_id,
1939: p_location_id => NULL,
1940: p_source => jai_constants.source_settle_in,
1941: p_source_trx_type => 'Invoice Payment',
1942: p_source_table_name => 'JAI_RGM_SETTLEMENTS',
1943: p_source_document_id => pn_settlement_id,
1944: p_transaction_date => pd_transaction_date,/* +1 is removed by ssawant for bug 5662296 */
1951: p_tax_rate => NULL,
1952: p_reference_id => NULL,
1953: p_batch_id => NULL,
1954: p_called_from => 'JAIRGMSP',
1955: p_accntg_required_flag => jai_constants.no,
1956: p_process_flag => pv_process_flag,
1957: p_process_message => pv_process_message,
1958: p_accounting_date => pd_transaction_date
1959: , p_currency_code => jai_constants.func_curr --File.Sql.35 Cbabu
1955: p_accntg_required_flag => jai_constants.no,
1956: p_process_flag => pv_process_flag,
1957: p_process_message => pv_process_message,
1958: p_accounting_date => pd_transaction_date
1959: , p_currency_code => jai_constants.func_curr --File.Sql.35 Cbabu
1960: );
1961: IF pv_process_flag <> 'SS' THEN
1962: goto MAIN_EXIT;
1963: END IF;
1967: jai_cmn_rgm_recording_pkg.insert_repository_entry(
1968: p_repository_id => ln_repository_id,
1969: p_regime_id => pn_regime_id,
1970: p_tax_type => lv_tax_type2,
1971: p_organization_type => jai_constants.orgn_type_ou,
1972: p_organization_id => ln_org_id,
1973: p_location_id => NULL,
1974: p_source => jai_constants.source_settle_in,
1975: p_source_trx_type => 'Invoice Payment',
1970: p_tax_type => lv_tax_type2,
1971: p_organization_type => jai_constants.orgn_type_ou,
1972: p_organization_id => ln_org_id,
1973: p_location_id => NULL,
1974: p_source => jai_constants.source_settle_in,
1975: p_source_trx_type => 'Invoice Payment',
1976: p_source_table_name => 'JAI_RGM_SETTLEMENTS',
1977: p_source_document_id => pn_settlement_id,
1978: p_transaction_date => pd_transaction_date, /* +1 is removed by ssawant for bug 5662296 */
1985: p_tax_rate => NULL,
1986: p_reference_id => NULL,
1987: p_batch_id => NULL,
1988: p_called_from => 'JAIRGMSP',
1989: p_accntg_required_flag => jai_constants.no,
1990: p_process_flag => pv_process_flag,
1991: p_process_message => pv_process_message,
1992: p_accounting_date => pd_transaction_date
1993: , p_currency_code => jai_constants.func_curr --File.Sql.35 Cbabu
1989: p_accntg_required_flag => jai_constants.no,
1990: p_process_flag => pv_process_flag,
1991: p_process_message => pv_process_message,
1992: p_accounting_date => pd_transaction_date
1993: , p_currency_code => jai_constants.func_curr --File.Sql.35 Cbabu
1994: );
1995: IF pv_process_flag <> 'SS' THEN
1996: goto MAIN_EXIT;
1997: END IF;
2021: jai_cmn_rgm_recording_pkg.insert_vat_repository_entry(
2022: pn_repository_id => ln_repository_id,
2023: pn_regime_id => pn_regime_id,
2024: pv_tax_type => lv_tax_type,
2025: pv_organization_type => jai_constants.orgn_type_io,
2026: pn_organization_id => org_io_rec.party_id,
2027: pn_location_id => org_io_rec.location_id,
2028: pv_source => jai_constants.source_settle_in,
2029: pv_source_trx_type => 'Invoice Payment',
2024: pv_tax_type => lv_tax_type,
2025: pv_organization_type => jai_constants.orgn_type_io,
2026: pn_organization_id => org_io_rec.party_id,
2027: pn_location_id => org_io_rec.location_id,
2028: pv_source => jai_constants.source_settle_in,
2029: pv_source_trx_type => 'Invoice Payment',
2030: pv_source_table_name => 'JAI_RGM_SETTLEMENTS',
2031: pn_source_id => pn_settlement_id,
2032: pd_transaction_date => pd_transaction_date, /* +1 is removed by ssawant for bug 5662296 */