[Home] [Help]
224: ln_debit_amount NUMBER;
225: lv_statement NUMBER;
226:
227: BEGIN
228: lv_source := jai_constants.source_settle_out;
229: ln_credit_amount:= NULL; --- these amounts are with respect to repository not w.r.t accounting
230: ln_debit_amount := p_to_trx_amount; --- its is reverse w.r.t accounting
231:
232:
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: ln_balance_accounting_id := jai_cmn_rgm_recording_pkg.get_account(
243: p_regime_id => p_regime_id,
244: p_organization_type => p_to_party_type,
245: p_organization_id => p_to_party_id,
246: p_location_id => p_to_locn_id,
247: p_tax_type => p_to_tax_type,
248: p_account_name => jai_constants.recovery
249: );
250:
251:
252: jai_cmn_rgm_recording_pkg.insert_vat_repository_entry(
260: pv_source_trx_type => p_source_trx_type ,
261: pv_source_table_name => p_source_table_name,
262: pn_source_id => p_source_doc_id ,
263: pd_transaction_date => p_trx_date,
264: pv_account_name => jai_constants.recovery,
265: pn_charge_account_id => ln_charge_accounting_id,
266: pn_balancing_account_id => ln_balance_accounting_id,
267: pn_credit_amount => ln_credit_amount,
268: pn_debit_amount => ln_debit_amount,
306: pv_source => lv_source,
307: pv_source_trx_type => p_source_trx_type,
308: pv_source_table_name => p_source_table_name,
309: pn_source_id => p_source_doc_id,
310: pv_reference_name => jai_constants.repository_name,
311: pn_reference_id => ln_repository_id
312: );
313:
314: IF p_process_flag <> 'SS' THEN
319:
320: /*for destination*/
321:
322:
323: lv_source := jai_constants.source_settle_in ;
324: ln_credit_amount := p_from_trx_amount; --- these amounts are with respect to repository not w.r.t accounting
325: ln_debit_amount := NULL; --- its is reverse w.r.t accounting
326:
327: ln_charge_accounting_id := jai_cmn_rgm_recording_pkg.get_account(
329: p_organization_type => p_to_party_type,
330: p_organization_id => p_to_party_id,
331: p_location_id => p_to_locn_id,
332: p_tax_type => p_to_tax_type,
333: p_account_name => jai_constants.recovery
334: );
335:
336: ln_balance_accounting_id := jai_cmn_rgm_recording_pkg.get_account(
337: p_regime_id => p_regime_id,
338: p_organization_type => p_from_party_type,
339: p_organization_id => p_from_party_id,
340: p_location_id => p_from_locn_id,
341: p_tax_type => p_from_tax_type,
342: p_account_name => jai_constants.recovery
343: );
344:
345:
346: jai_cmn_rgm_recording_pkg.insert_vat_repository_entry(
354: pv_source_trx_type => p_source_trx_type ,
355: pv_source_table_name => p_source_table_name,
356: pn_source_id => p_source_doc_id ,
357: pd_transaction_date => p_trx_date,
358: pv_account_name => jai_constants.recovery,
359: pn_charge_account_id => ln_charge_accounting_id,
360: pn_balancing_account_id => ln_balance_accounting_id,
361: pn_credit_amount => ln_credit_amount,
362: pn_debit_amount => ln_debit_amount,
400: pv_source => lv_source,
401: pv_source_trx_type => p_source_trx_type,
402: pv_source_table_name => p_source_table_name,
403: pn_source_id => p_source_doc_id,
404: pv_reference_name => jai_constants.repository_name,
405: pn_reference_id => ln_repository_id
406: );
407:
408:
426: But the Recovery form IN1 is not transferred to set off liability in IN1 (below entry is not generated)
427: Recovery IN1 - Cr 100
428: Libility IN1 - Dr 100
429: */
430: lv_source := jai_constants.source_settle_in;
431: ln_credit_amount := p_to_trx_amount;
432: ln_debit_amount := NULL;
433: ln_charge_accounting_id := jai_cmn_rgm_recording_pkg.get_account(
434: p_regime_id => p_regime_id,
435: p_organization_type => p_to_party_type,
436: p_organization_id => p_to_party_id,
437: p_location_id => p_to_locn_id,
438: p_tax_type => p_to_tax_type,
439: p_account_name => jai_constants.liability );
440:
441: ln_balance_accounting_id := jai_cmn_rgm_recording_pkg.get_account(
442: p_regime_id => p_regime_id,
443: p_organization_type => p_to_party_type,
443: p_organization_type => p_to_party_type,
444: p_organization_id => p_to_party_id,
445: p_location_id => p_to_locn_id,
446: p_tax_type => p_to_tax_type,
447: p_account_name => jai_constants.liability );
448:
449: jai_cmn_rgm_recording_pkg.insert_vat_repository_entry(
450: pn_repository_id => ln_repository_id,
451: pn_regime_id => p_regime_id,
457: pv_source_trx_type => p_source_trx_type,
458: pv_source_table_name => p_source_table_name,
459: pn_source_id => p_source_doc_id,
460: pd_transaction_date => p_trx_date,
461: pv_account_name => jai_constants.liability,
462: pn_charge_account_id => ln_charge_accounting_id,
463: pn_balancing_account_id => ln_balance_accounting_id,
464: pn_credit_amount => ln_credit_amount,
465: pn_debit_amount => ln_debit_amount,
500: pv_source => lv_source,
501: pv_source_trx_type => p_source_trx_type,
502: pv_source_table_name => p_source_table_name,
503: pn_source_id => p_source_doc_id,
504: pv_reference_name => jai_constants.repository_name,
505: pn_reference_id => ln_repository_id
506: );
507:
508: IF p_process_flag <> 'SS' THEN
509: ROLLBACK;
510: RETURN;
511: END IF;
512:
513: lv_source := jai_constants.source_settle_out ;
514: ln_credit_amount := NULL;
515: ln_debit_amount := p_to_trx_amount;
516:
517: ln_charge_accounting_id := jai_cmn_rgm_recording_pkg.get_account(
519: p_organization_type => p_to_party_type,
520: p_organization_id => p_to_party_id,
521: p_location_id => p_to_locn_id,
522: p_tax_type => p_to_tax_type,
523: p_account_name => jai_constants.recovery );
524:
525: ln_balance_accounting_id := jai_cmn_rgm_recording_pkg.get_account(
526: p_regime_id => p_regime_id,
527: p_organization_type => p_to_party_type,
527: p_organization_type => p_to_party_type,
528: p_organization_id => p_to_party_id,
529: p_location_id => p_to_locn_id,
530: p_tax_type => p_to_tax_type,
531: p_account_name => jai_constants.recovery );
532:
533: jai_cmn_rgm_recording_pkg.insert_vat_repository_entry(
534: pn_repository_id => ln_repository_id,
535: pn_regime_id => p_regime_id,
541: pv_source_trx_type => p_source_trx_type,
542: pv_source_table_name => p_source_table_name,
543: pn_source_id => p_source_doc_id,
544: pd_transaction_date => p_trx_date,
545: pv_account_name => jai_constants.recovery,
546: pn_charge_account_id => ln_charge_accounting_id,
547: pn_balancing_account_id => ln_balance_accounting_id,
548: pn_credit_amount => ln_credit_amount,
549: pn_debit_amount => ln_debit_amount,
584: pv_source => lv_source,
585: pv_source_trx_type => p_source_trx_type,
586: pv_source_table_name => p_source_table_name,
587: pn_source_id => p_source_doc_id,
588: pv_reference_name => jai_constants.repository_name,
589: pn_reference_id => ln_repository_id );
590:
591: IF p_process_flag <> 'SS' THEN
592: ROLLBACK;
982: END IF;
983: Commented out by Eric Ma for bug 7031751,end*/
984: END IF;
985:
986: IF lv_regime_code = jai_constants.service_regime THEN
987: lv_organization_type := jai_constants.orgn_type_io;/* added by ssawant for bug 5879769 */
988: ln_acct_amount := ROUND(ln_acct_amount, jai_constants.service_rgm_rnd_factor);
989: ELSIF lv_regime_code = jai_constants.vat_regime THEN
990: lv_organization_type := jai_constants.orgn_type_io;
983: Commented out by Eric Ma for bug 7031751,end*/
984: END IF;
985:
986: IF lv_regime_code = jai_constants.service_regime THEN
987: lv_organization_type := jai_constants.orgn_type_io;/* added by ssawant for bug 5879769 */
988: ln_acct_amount := ROUND(ln_acct_amount, jai_constants.service_rgm_rnd_factor);
989: ELSIF lv_regime_code = jai_constants.vat_regime THEN
990: lv_organization_type := jai_constants.orgn_type_io;
991: ln_acct_amount := ROUND(ln_acct_amount, jai_constants.vat_rgm_rnd_factor);
984: END IF;
985:
986: IF lv_regime_code = jai_constants.service_regime THEN
987: lv_organization_type := jai_constants.orgn_type_io;/* added by ssawant for bug 5879769 */
988: ln_acct_amount := ROUND(ln_acct_amount, jai_constants.service_rgm_rnd_factor);
989: ELSIF lv_regime_code = jai_constants.vat_regime THEN
990: lv_organization_type := jai_constants.orgn_type_io;
991: ln_acct_amount := ROUND(ln_acct_amount, jai_constants.vat_rgm_rnd_factor);
992:
985:
986: IF lv_regime_code = jai_constants.service_regime THEN
987: lv_organization_type := jai_constants.orgn_type_io;/* added by ssawant for bug 5879769 */
988: ln_acct_amount := ROUND(ln_acct_amount, jai_constants.service_rgm_rnd_factor);
989: ELSIF lv_regime_code = jai_constants.vat_regime THEN
990: lv_organization_type := jai_constants.orgn_type_io;
991: ln_acct_amount := ROUND(ln_acct_amount, jai_constants.vat_rgm_rnd_factor);
992:
993: ELSIF lv_regime_code = 'TCS' THEN /*Added code for tcs by mmurtuza for bug 12641455*/
986: IF lv_regime_code = jai_constants.service_regime THEN
987: lv_organization_type := jai_constants.orgn_type_io;/* added by ssawant for bug 5879769 */
988: ln_acct_amount := ROUND(ln_acct_amount, jai_constants.service_rgm_rnd_factor);
989: ELSIF lv_regime_code = jai_constants.vat_regime THEN
990: lv_organization_type := jai_constants.orgn_type_io;
991: ln_acct_amount := ROUND(ln_acct_amount, jai_constants.vat_rgm_rnd_factor);
992:
993: ELSIF lv_regime_code = 'TCS' THEN /*Added code for tcs by mmurtuza for bug 12641455*/
994: lv_organization_type := jai_constants.orgn_type_io;
987: lv_organization_type := jai_constants.orgn_type_io;/* added by ssawant for bug 5879769 */
988: ln_acct_amount := ROUND(ln_acct_amount, jai_constants.service_rgm_rnd_factor);
989: ELSIF lv_regime_code = jai_constants.vat_regime THEN
990: lv_organization_type := jai_constants.orgn_type_io;
991: ln_acct_amount := ROUND(ln_acct_amount, jai_constants.vat_rgm_rnd_factor);
992:
993: ELSIF lv_regime_code = 'TCS' THEN /*Added code for tcs by mmurtuza for bug 12641455*/
994: lv_organization_type := jai_constants.orgn_type_io;
995: /*ln_acct_amount := ROUND(ln_acct_amount, jai_constants.tcs_rgm_rnd_factor);*/ --Need to discuss
990: lv_organization_type := jai_constants.orgn_type_io;
991: ln_acct_amount := ROUND(ln_acct_amount, jai_constants.vat_rgm_rnd_factor);
992:
993: ELSIF lv_regime_code = 'TCS' THEN /*Added code for tcs by mmurtuza for bug 12641455*/
994: lv_organization_type := jai_constants.orgn_type_io;
995: /*ln_acct_amount := ROUND(ln_acct_amount, jai_constants.tcs_rgm_rnd_factor);*/ --Need to discuss
996:
997: END IF;
998:
991: ln_acct_amount := ROUND(ln_acct_amount, jai_constants.vat_rgm_rnd_factor);
992:
993: ELSIF lv_regime_code = 'TCS' THEN /*Added code for tcs by mmurtuza for bug 12641455*/
994: lv_organization_type := jai_constants.orgn_type_io;
995: /*ln_acct_amount := ROUND(ln_acct_amount, jai_constants.tcs_rgm_rnd_factor);*/ --Need to discuss
996:
997: END IF;
998:
999: IF ln_acct_amount <> 0 THEN /* added by ssawant for bug 6020629 */
1002: p_organization_type => lv_organization_type,
1003: p_organization_id => r_acct_balances.party_id,
1004: p_location_id => r_acct_balances.location_id,
1005: p_tax_type => r_acct_balances.tax_type,
1006: p_account_name => jai_constants.liability);
1007:
1008: /*Modifed call for jai_cmn_rgm_recording_pkg.post_accounting for post accounting*/
1009:
1010: if (lv_regime_code <> 'TCS') then
1012: p_regime_code => lv_regime_code,
1013: p_tax_type => r_acct_balances.tax_type,
1014: p_organization_type => lv_organization_type,
1015: p_organization_id => r_acct_balances.party_id,
1016: p_source => jai_constants.source_settle_in,
1017: p_source_trx_type => 'Invoice Payment',
1018: p_source_table_name => 'JAI_RGM_SETTLEMENTS',
1019: p_source_document_id => pn_settlement_id,
1020: p_code_combination_id => ln_charge_accounting_id,
1025: -- p_accounting_date => SYSDATE, commented by anujsax for bug #6126142
1026: p_accounting_date => r_acct_balances.settlement_date, --added by anujsax for Bug#6126142
1027: p_transaction_date => r_acct_balances.settlement_date,
1028: p_calling_object => 'JAIRGMSP',
1029: p_repository_name => jai_constants.repository_name,
1030: p_repository_id => NULL,
1031: p_reference_name => NULL,
1032: p_reference_id => NULL,
1033: p_currency_code => jai_constants.func_curr);
1029: p_repository_name => jai_constants.repository_name,
1030: p_repository_id => NULL,
1031: p_reference_name => NULL,
1032: p_reference_id => NULL,
1033: p_currency_code => jai_constants.func_curr);
1034: else
1035: jai_cmn_rgm_recording_pkg.post_accounting(
1036: p_regime_code => lv_regime_code,
1037: p_tax_type => r_acct_balances.tax_type,
1036: p_regime_code => lv_regime_code,
1037: p_tax_type => r_acct_balances.tax_type,
1038: p_organization_type => lv_organization_type,
1039: p_organization_id => r_acct_balances.party_id,
1040: p_source => jai_constants.source_settle_in,
1041: p_source_trx_type => 'Invoice Payment',
1042: p_source_table_name => 'JAI_RGM_SETTLEMENTS',
1043: p_source_document_id => pn_settlement_id,
1044: p_code_combination_id => ln_charge_accounting_id,
1053: p_repository_name => 'JAI_RGM_REFS_ALL',
1054: p_repository_id => NULL,
1055: p_reference_name => NULL,
1056: p_reference_id => NULL,
1057: p_currency_code => jai_constants.func_curr);
1058:
1059: end if;
1060:
1061:
1072: p_organization_type => lv_organization_type,
1073: p_organization_id => r_acct_balances.party_id,
1074: p_location_id => r_acct_balances.location_id,
1075: p_tax_type => r_acct_balances.tax_type,
1076: p_account_name => jai_constants.recovery);
1077:
1078: /*Modifed call for jai_cmn_rgm_recording_pkg.post_accounting for post accounting*/
1079:
1080: if (lv_regime_code <> 'TCS') then
1083: p_regime_code => lv_regime_code,
1084: p_tax_type => r_acct_balances.tax_type,
1085: p_organization_type => lv_organization_type,
1086: p_organization_id => r_acct_balances.party_id,
1087: p_source => jai_constants.source_settle_in,
1088: p_source_trx_type => 'Invoice Payment',
1089: p_source_table_name => 'JAI_RGM_SETTLEMENTS',
1090: p_source_document_id => pn_settlement_id,
1091: p_code_combination_id => ln_charge_accounting_id,
1096: -- p_accounting_date => SYSDATE, commented by anujsax for bug #6126142
1097: p_accounting_date => r_acct_balances.settlement_date, --added by anujsax for Bug#6126142
1098: p_transaction_date => r_acct_balances.settlement_date,
1099: p_calling_object => 'JAIRGMSP',
1100: p_repository_name => jai_constants.repository_name,
1101: p_repository_id => NULL,
1102: p_reference_name => NULL,
1103: p_reference_id => NULL,
1104: p_currency_code => jai_constants.func_curr);
1100: p_repository_name => jai_constants.repository_name,
1101: p_repository_id => NULL,
1102: p_reference_name => NULL,
1103: p_reference_id => NULL,
1104: p_currency_code => jai_constants.func_curr);
1105:
1106: else
1107: jai_cmn_rgm_recording_pkg.post_accounting(
1108: p_regime_code => lv_regime_code,
1108: p_regime_code => lv_regime_code,
1109: p_tax_type => r_acct_balances.tax_type,
1110: p_organization_type => lv_organization_type,
1111: p_organization_id => r_acct_balances.party_id,
1112: p_source => jai_constants.source_settle_in,
1113: p_source_trx_type => 'Invoice Payment',
1114: p_source_table_name => 'JAI_RGM_SETTLEMENTS',
1115: p_source_document_id => pn_settlement_id,
1116: p_code_combination_id => ln_charge_accounting_id,
1125: p_repository_name => 'JAI_RGM_REFS_ALL',
1126: p_repository_id => NULL,
1127: p_reference_name => NULL,
1128: p_reference_id => NULL,
1129: p_currency_code => jai_constants.func_curr);
1130: end if;
1131:
1132: IF pv_process_flag <> 'SS' THEN
1133: goto MAIN_EXIT;
1209: FETCH cur_regime_code INTO lv_regime_code;
1210: CLOSE cur_regime_code;
1211:
1212:
1213: IF lv_regime_code = jai_constants.service_regime THEN /* 4245365*/
1214:
1215: /**Observation :11821537 ,settle in ,settle out i.e distribution repository update is not required as the service tax is by IO and for settlement
1216: organization and location are mandatory ,hence commenting the below code**/
1217: /*
1231: p_to_service_type => cur_debit.service_type_code,
1232: p_to_trx_amount => ln_transfer_amt,
1233: p_called_from => 'SETTLEMENT',
1234: p_trx_date => i.settlement_date,
1235: p_acct_req => jai_constants.yes,
1236: p_source => 'SETTLEMENT',
1237: p_source_trx_type => 'SETTLEMENT',
1238: p_source_table_name => 'JAI_RGM_SETTLEMENTS',
1239: p_source_doc_id => pn_settlement_id,
1248: END IF;
1249: */
1250: null;
1251:
1252: ELSIF lv_regime_code = jai_constants.vat_regime THEN /* 4245365*/
1253:
1254:
1255: OPEN cur_dist_detail;
1256: FETCH cur_dist_detail INTO ln_dist_dtl_id;
1269: p_to_tax_type => i.tax_type,
1270: p_to_trx_amount => ln_transfer_amt,
1271: p_called_from => 'SETTLEMENT',
1272: p_trx_date => i.settlement_date,
1273: p_acct_req => jai_constants.yes,
1274: p_source => 'SETTLEMENT',
1275: p_source_trx_type => 'SETTLEMENT',
1276: p_source_table_name => 'JAI_RGM_SETTLEMENTS',
1277: p_source_doc_id => ln_dist_dtl_id,
1291: END IF;
1292:
1293: /*Start commenting by mmurtuza for bug 12641455*/
1294:
1295: /*IF lv_regime_code NOT IN (jai_constants.service_regime,jai_constants.vat_regime) THEN
1296: --added by vumaasha for bug 7606212
1297:
1298: update jai_rgm_stl_balances
1299: SET debit_balance = debit_balance - ln_transfer_amt
1800:
1801:
1802: ln_dist_code_combination_id := jai_cmn_rgm_recording_pkg.get_account(
1803: p_regime_id => pn_regime_id,
1804: p_organization_type => jai_constants.orgn_type_io,/* added by ssawant for bug 5879769 */
1805: p_organization_id => i.party_id,/* added by ssawant for bug 5879769 */
1806: p_location_id => i.location_id,/* added by ssawant for bug 5879769 */
1807: p_tax_type => i.tax_type,
1808: p_account_name => jai_constants.liability);
1804: p_organization_type => jai_constants.orgn_type_io,/* added by ssawant for bug 5879769 */
1805: p_organization_id => i.party_id,/* added by ssawant for bug 5879769 */
1806: p_location_id => i.location_id,/* added by ssawant for bug 5879769 */
1807: p_tax_type => i.tax_type,
1808: p_account_name => jai_constants.liability);
1809:
1810: IF ln_dist_code_combination_id IS NULL THEN
1811: pv_process_flag := 'EE';
1812: pv_process_message := 'There is no account defined for AP Invoice creation. Can''t proceed';
1860:
1861:
1862: ln_dist_code_combination_id := jai_cmn_rgm_recording_pkg.get_account(
1863: p_regime_id => pn_regime_id,
1864: p_organization_type => jai_constants.orgn_type_io,
1865: p_organization_id => i.party_id,
1866: p_location_id => i.location_id,
1867: p_tax_type => i.tax_type,
1868: p_account_name => jai_constants.liability);
1864: p_organization_type => jai_constants.orgn_type_io,
1865: p_organization_id => i.party_id,
1866: p_location_id => i.location_id,
1867: p_tax_type => i.tax_type,
1868: p_account_name => jai_constants.liability);
1869:
1870:
1871: IF ln_dist_code_combination_id IS NULL THEN
1872: pv_process_flag := 'EE';
1900: END IF;
1901: END LOOP;
1902:
1903: /*Added By CSahoo, BUG#5631784*/
1904: ELSIF upper(lv_regime.regime_code) = jai_constants.tcs_regime THEN
1905:
1906: FOR i IN cur_distributions_TCS LOOP
1907:
1908: /*Start Additions by mmurtuza for bug12641455*/
1918: /*End Additions by mmurtuza for bug12641455*/
1919:
1920: ln_dist_code_combination_id := jai_cmn_rgm_recording_pkg.get_account(
1921: p_regime_id => pn_regime_id,
1922: p_organization_type => jai_constants.orgn_type_io,
1923: p_organization_id => i.party_id,
1924: p_location_id => i.location_id,
1925: p_tax_type => i.tax_type,
1926: p_account_name => jai_constants.liability);
1922: p_organization_type => jai_constants.orgn_type_io,
1923: p_organization_id => i.party_id,
1924: p_location_id => i.location_id,
1925: p_tax_type => i.tax_type,
1926: p_account_name => jai_constants.liability);
1927:
1928:
1929: IF ln_dist_code_combination_id IS NULL THEN
1930: pv_process_flag := 'EE';
1984:
1985:
1986: ln_dist_code_combination_id := jai_cmn_rgm_recording_pkg.get_account(
1987: p_regime_id => pn_regime_id,
1988: p_organization_type => jai_constants.orgn_type_ou,
1989: p_organization_id => pn_org_id,
1990: p_location_id => NULL,
1991: p_tax_type => lv_tax_type1,
1992: p_account_name => jai_constants.liability);
1988: p_organization_type => jai_constants.orgn_type_ou,
1989: p_organization_id => pn_org_id,
1990: p_location_id => NULL,
1991: p_tax_type => lv_tax_type1,
1992: p_account_name => jai_constants.liability);
1993:
1994: IF ln_dist_code_combination_id IS NULL THEN
1995: pv_process_flag := 'EE';
1996: pv_process_message := 'There is no account defined for AP Invoice creation. Cannot proceed';
2019:
2020: IF ln_amount2 <> 0 THEN
2021: ln_dist_code_combination_id := jai_cmn_rgm_recording_pkg.get_account(
2022: p_regime_id => pn_regime_id,
2023: p_organization_type => jai_constants.orgn_type_ou,
2024: p_organization_id => pn_org_id,
2025: p_location_id => NULL,
2026: p_tax_type => lv_tax_type2,
2027: p_account_name => jai_constants.liability);
2023: p_organization_type => jai_constants.orgn_type_ou,
2024: p_organization_id => pn_org_id,
2025: p_location_id => NULL,
2026: p_tax_type => lv_tax_type2,
2027: p_account_name => jai_constants.liability);
2028:
2029: IF ln_dist_code_combination_id IS NULL THEN
2030: pv_process_flag := 'EE';
2031: pv_process_message := 'There is no account defined for AP Invoice creation. Cannot proceed';
2066:
2067: IF nvl(ln_amount,0) <> 0 THEN
2068: ln_dist_code_combination_id := jai_cmn_rgm_recording_pkg.get_account(
2069: p_regime_id => pn_regime_id,
2070: p_organization_type => jai_constants.orgn_type_io,
2071: p_organization_id => org_io_rec.party_id,
2072: p_location_id => org_io_rec.location_id,
2073: p_tax_type => lv_tax_type,
2074: p_account_name => jai_constants.liability);
2070: p_organization_type => jai_constants.orgn_type_io,
2071: p_organization_id => org_io_rec.party_id,
2072: p_location_id => org_io_rec.location_id,
2073: p_tax_type => lv_tax_type,
2074: p_account_name => jai_constants.liability);
2075:
2076: IF ln_dist_code_combination_id IS NULL THEN
2077: pv_process_flag := 'EE';
2078: pv_process_message := 'There is no account defined for AP Invoice creation. Cannot proceed';
2420: jai_cmn_rgm_recording_pkg.insert_repository_entry(
2421: p_repository_id => ln_repository_id,
2422: p_regime_id => pn_regime_id,
2423: p_tax_type => i.tax_type,
2424: p_organization_type => jai_constants.orgn_type_io, /* added by ssawant for bug 5879769 */
2425: p_organization_id => i.party_id,
2426: p_location_id => i.location_id , /* added by ssawant for bug 5879769 */
2427: p_source => jai_constants.source_settle_in,
2428: p_source_trx_type => 'Invoice Payment',
2423: p_tax_type => i.tax_type,
2424: p_organization_type => jai_constants.orgn_type_io, /* added by ssawant for bug 5879769 */
2425: p_organization_id => i.party_id,
2426: p_location_id => i.location_id , /* added by ssawant for bug 5879769 */
2427: p_source => jai_constants.source_settle_in,
2428: p_source_trx_type => 'Invoice Payment',
2429: p_source_table_name => 'JAI_RGM_SETTLEMENTS',
2430: p_source_document_id => pn_settlement_id,
2431: p_transaction_date => pd_transaction_date,/* +1 is removed by ssawant for bug 5662296 */
2438: p_tax_rate => NULL,
2439: p_reference_id => NULL,
2440: p_batch_id => NULL,
2441: p_called_from => 'JAIRGMSP',
2442: p_accntg_required_flag => jai_constants.no,
2443: p_process_flag => pv_process_flag,
2444: p_process_message => pv_process_message,
2445: p_accounting_date => pd_transaction_date,
2446: p_currency_code => jai_constants.func_curr, --File.Sql.35 Cbabu
2442: p_accntg_required_flag => jai_constants.no,
2443: p_process_flag => pv_process_flag,
2444: p_process_message => pv_process_message,
2445: p_accounting_date => pd_transaction_date,
2446: p_currency_code => jai_constants.func_curr, --File.Sql.35 Cbabu
2447: p_service_type_code => i.service_type_code /* added by ssawant for bug 5879769 */
2448: );
2449:
2450:
2463:
2464:
2465: ln_charge_accounting_id :=
2466: jai_cmn_rgm_recording_pkg.get_account(p_regime_id => pn_regime_id,
2467: p_organization_type => jai_constants.orgn_type_io,
2468: p_organization_id => i.party_id,
2469: p_location_id => i.location_id,
2470: p_tax_type => i.tax_type,
2471: p_account_name => jai_constants.recovery);
2467: p_organization_type => jai_constants.orgn_type_io,
2468: p_organization_id => i.party_id,
2469: p_location_id => i.location_id,
2470: p_tax_type => i.tax_type,
2471: p_account_name => jai_constants.recovery);
2472:
2473: jai_cmn_rgm_recording_pkg.insert_vat_repository_entry(
2474: pn_repository_id => ln_repository_id,
2475: pn_regime_id => pn_regime_id,
2473: jai_cmn_rgm_recording_pkg.insert_vat_repository_entry(
2474: pn_repository_id => ln_repository_id,
2475: pn_regime_id => pn_regime_id,
2476: pv_tax_type => i.tax_type,
2477: pv_organization_type => jai_constants.orgn_type_io,
2478: pn_organization_id => i.party_id,
2479: pn_location_id => i.location_id,
2480: pv_source => jai_constants.source_settle_in,
2481: pv_source_trx_type => 'Invoice Payment',
2476: pv_tax_type => i.tax_type,
2477: pv_organization_type => jai_constants.orgn_type_io,
2478: pn_organization_id => i.party_id,
2479: pn_location_id => i.location_id,
2480: pv_source => jai_constants.source_settle_in,
2481: pv_source_trx_type => 'Invoice Payment',
2482: pv_source_table_name => 'JAI_RGM_SETTLEMENTS',
2483: pn_source_id => pn_settlement_id,
2484: pd_transaction_date => pd_transaction_date,/* +1 is removed by ssawant for bug 5662296 */
2481: pv_source_trx_type => 'Invoice Payment',
2482: pv_source_table_name => 'JAI_RGM_SETTLEMENTS',
2483: pn_source_id => pn_settlement_id,
2484: pd_transaction_date => pd_transaction_date,/* +1 is removed by ssawant for bug 5662296 */
2485: pv_account_name => jai_constants.recovery,
2486: pn_charge_account_id => ln_charge_accounting_id,
2487: pn_balancing_account_id => NULL,
2488: pn_credit_amount => ln_credit_amount,
2489: pn_debit_amount => ln_debit_amount,
2541: jai_cmn_rgm_recording_pkg.insert_repository_entry(
2542: p_repository_id => ln_repository_id,
2543: p_regime_id => pn_regime_id,
2544: p_tax_type => lv_tax_type1,
2545: p_organization_type => jai_constants.orgn_type_ou,
2546: p_organization_id => ln_org_id,
2547: p_location_id => NULL,
2548: p_source => jai_constants.source_settle_in,
2549: p_source_trx_type => 'Invoice Payment',
2544: p_tax_type => lv_tax_type1,
2545: p_organization_type => jai_constants.orgn_type_ou,
2546: p_organization_id => ln_org_id,
2547: p_location_id => NULL,
2548: p_source => jai_constants.source_settle_in,
2549: p_source_trx_type => 'Invoice Payment',
2550: p_source_table_name => 'JAI_RGM_SETTLEMENTS',
2551: p_source_document_id => pn_settlement_id,
2552: p_transaction_date => pd_transaction_date,/* +1 is removed by ssawant for bug 5662296 */
2559: p_tax_rate => NULL,
2560: p_reference_id => NULL,
2561: p_batch_id => NULL,
2562: p_called_from => 'JAIRGMSP',
2563: p_accntg_required_flag => jai_constants.no,
2564: p_process_flag => pv_process_flag,
2565: p_process_message => pv_process_message,
2566: p_accounting_date => pd_transaction_date
2567: , p_currency_code => jai_constants.func_curr --File.Sql.35 Cbabu
2563: p_accntg_required_flag => jai_constants.no,
2564: p_process_flag => pv_process_flag,
2565: p_process_message => pv_process_message,
2566: p_accounting_date => pd_transaction_date
2567: , p_currency_code => jai_constants.func_curr --File.Sql.35 Cbabu
2568: );
2569: IF pv_process_flag <> 'SS' THEN
2570: goto MAIN_EXIT;
2571: END IF;
2575: jai_cmn_rgm_recording_pkg.insert_repository_entry(
2576: p_repository_id => ln_repository_id,
2577: p_regime_id => pn_regime_id,
2578: p_tax_type => lv_tax_type2,
2579: p_organization_type => jai_constants.orgn_type_ou,
2580: p_organization_id => ln_org_id,
2581: p_location_id => NULL,
2582: p_source => jai_constants.source_settle_in,
2583: p_source_trx_type => 'Invoice Payment',
2578: p_tax_type => lv_tax_type2,
2579: p_organization_type => jai_constants.orgn_type_ou,
2580: p_organization_id => ln_org_id,
2581: p_location_id => NULL,
2582: p_source => jai_constants.source_settle_in,
2583: p_source_trx_type => 'Invoice Payment',
2584: p_source_table_name => 'JAI_RGM_SETTLEMENTS',
2585: p_source_document_id => pn_settlement_id,
2586: p_transaction_date => pd_transaction_date, /* +1 is removed by ssawant for bug 5662296 */
2593: p_tax_rate => NULL,
2594: p_reference_id => NULL,
2595: p_batch_id => NULL,
2596: p_called_from => 'JAIRGMSP',
2597: p_accntg_required_flag => jai_constants.no,
2598: p_process_flag => pv_process_flag,
2599: p_process_message => pv_process_message,
2600: p_accounting_date => pd_transaction_date
2601: , p_currency_code => jai_constants.func_curr --File.Sql.35 Cbabu
2597: p_accntg_required_flag => jai_constants.no,
2598: p_process_flag => pv_process_flag,
2599: p_process_message => pv_process_message,
2600: p_accounting_date => pd_transaction_date
2601: , p_currency_code => jai_constants.func_curr --File.Sql.35 Cbabu
2602: );
2603: IF pv_process_flag <> 'SS' THEN
2604: goto MAIN_EXIT;
2605: END IF;
2629: jai_cmn_rgm_recording_pkg.insert_vat_repository_entry(
2630: pn_repository_id => ln_repository_id,
2631: pn_regime_id => pn_regime_id,
2632: pv_tax_type => lv_tax_type,
2633: pv_organization_type => jai_constants.orgn_type_io,
2634: pn_organization_id => org_io_rec.party_id,
2635: pn_location_id => org_io_rec.location_id,
2636: pv_source => jai_constants.source_settle_in,
2637: pv_source_trx_type => 'Invoice Payment',
2632: pv_tax_type => lv_tax_type,
2633: pv_organization_type => jai_constants.orgn_type_io,
2634: pn_organization_id => org_io_rec.party_id,
2635: pn_location_id => org_io_rec.location_id,
2636: pv_source => jai_constants.source_settle_in,
2637: pv_source_trx_type => 'Invoice Payment',
2638: pv_source_table_name => 'JAI_RGM_SETTLEMENTS',
2639: pn_source_id => pn_settlement_id,
2640: pd_transaction_date => pd_transaction_date, /* +1 is removed by ssawant for bug 5662296 */