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_CMN_RGM_SETTLEMENT_PKG dependencies on JAI_RGM_TRX_RECORDS

Line 648: FROM jai_rgm_trx_records

644: ln_location_id jai_rgm_stl_balances.location_id%TYPE,
645: lv_party_type jai_rgm_stl_balances.party_type%TYPE
646: ) IS
647: SELECT (NVL(credit_amount,0) - NVL(debit_amount,0) - NVL(settled_amount,0))*-1 debit_balance, organization_id party_id, rowid
648: FROM jai_rgm_trx_records
649: WHERE tax_type = lv_tax_type
650: AND organization_id = ln_party_id
651: AND nvl(location_id,-999) = nvl(ln_location_id,-999)
652: AND organization_type = lv_party_type

Line 668: FROM jai_rgm_trx_records

664: ln_location_id jai_rgm_stl_balances.location_id%TYPE,
665: lv_party_type jai_rgm_stl_balances.party_type%TYPE
666: ) IS
667: SELECT NVL(credit_amount,0) - NVL(debit_amount,0) - NVL(settled_amount,0) credit_balance, organization_id party_id, rowid
668: FROM jai_rgm_trx_records
669: WHERE tax_type = lv_tax_type
670: AND organization_id = ln_party_id
671: AND nvl(location_id,-999) = nvl(ln_location_id,-999)/*rchandan for Service Type FP*/
672: AND organization_type = lv_party_type

Line 729: FROM jai_rgm_trx_records

725: IS
726: -- || This cursor is used to get the total invoice amount paid
727: -- || when the last settlement was made
728: SELECT sum(credit_amount)
729: FROM jai_rgm_trx_records
730: WHERE regime_primary_regno = lp_regn_no
731: AND source_trx_type = 'Invoice Payment'
732: AND transaction_date = ( select max(settlement_date) + 1
733: from jai_rgm_stl_balances a

Line 771: FROM jai_rgm_trx_records

767: || This cursor is used to get the total invoice amount paid
768: || when the last settlement was made
769: */
770: SELECT sum(credit_amount)
771: FROM jai_rgm_trx_records
772: WHERE source_trx_type = 'Invoice Payment'
773: AND settlement_id = ( SELECT MAX(jbal.settlement_id)
774: FROM jai_rgm_stl_balances jbal,jai_rgm_settlements jstl
775: WHERE jbal.settlement_id = jstl.settlement_id

Line 868: ln_charge_accounting_id jai_rgm_trx_records.charge_account_id%type; /* added by ssawant for bug 6020629 */

864: lv_regime_code JAI_RGM_DEFINITIONS.regime_code%type;/* Ravi*/
865: lv_statement NUMBER;
866: ln_dist_dtl_id NUMBER;
867: ln_acct_amount NUMBER; /* added by ssawant for bug 6020629 */
868: ln_charge_accounting_id jai_rgm_trx_records.charge_account_id%type; /* added by ssawant for bug 6020629 */
869: lv_organization_type VARCHAR2(10); /* added by ssawant for bug 6020629 */
870: ln_invoice_amount jai_rgm_trx_records.credit_amount%type ; /* added by ssawant for bug 6020629 */
871: rec_balances cur_balances%ROWTYPE;/* added by ssawant for bug 6020629 */
872: lv_regn_no jai_rgm_settlements.primary_registration_no%type;

Line 870: ln_invoice_amount jai_rgm_trx_records.credit_amount%type ; /* added by ssawant for bug 6020629 */

866: ln_dist_dtl_id NUMBER;
867: ln_acct_amount NUMBER; /* added by ssawant for bug 6020629 */
868: ln_charge_accounting_id jai_rgm_trx_records.charge_account_id%type; /* added by ssawant for bug 6020629 */
869: lv_organization_type VARCHAR2(10); /* added by ssawant for bug 6020629 */
870: ln_invoice_amount jai_rgm_trx_records.credit_amount%type ; /* added by ssawant for bug 6020629 */
871: rec_balances cur_balances%ROWTYPE;/* added by ssawant for bug 6020629 */
872: lv_regn_no jai_rgm_settlements.primary_registration_no%type;
873: /*rchandan for bug#5642053 start*/
874: ln_organization_id jai_rgm_stl_balances.party_id%TYPE;

Line 1328: UPDATE jai_rgm_trx_records

1324: from jai_rgm_stl_balances
1325: where settlement_id = pn_settlement_id)
1326: LOOP
1327: IF NVL(i.debit_balance,0) = NVL(i.credit_balance,0) THEN
1328: UPDATE jai_rgm_trx_records
1329: SET settled_flag = 'Y',
1330: settled_amount = NULL
1331: WHERE tax_type = i.tax_type
1332: AND organization_id = i.party_id

Line 1344: FROM jai_rgm_trx_records

1340: ELSE
1341:
1342: SELECT count(*)
1343: INTO ln_debit_cnt
1344: FROM jai_rgm_trx_records
1345: WHERE tax_type = i.tax_type
1346: AND organization_id = i.party_id
1347: AND nvl(location_id,-999) = nvl(i.location_id,-999)
1348: AND organization_type = i.party_type

Line 1364: FROM jai_rgm_trx_records

1360: END IF;
1361:
1362: SELECT count(*)
1363: INTO ln_credit_cnt
1364: FROM jai_rgm_trx_records
1365: WHERE tax_type = i.tax_type
1366: AND organization_id = i.party_id
1367: AND nvl(location_id,-999) = nvl(i.location_id,-999)
1368: AND organization_type = i.party_type

Line 1400: UPDATE jai_rgm_trx_records

1396: END IF;
1397:
1398: /*Need to discuss how to update for TCS*/
1399:
1400: UPDATE jai_rgm_trx_records
1401: SET settled_amount = nvl(settled_amount, 0) -ln_transfer_amt,
1402: settled_flag = 'P'
1403: WHERE rowid = cur_debit.rowid;
1404: UPDATE jai_rgm_trx_records

Line 1404: UPDATE jai_rgm_trx_records

1400: UPDATE jai_rgm_trx_records
1401: SET settled_amount = nvl(settled_amount, 0) -ln_transfer_amt,
1402: settled_flag = 'P'
1403: WHERE rowid = cur_debit.rowid;
1404: UPDATE jai_rgm_trx_records
1405: SET settled_amount = nvl(settled_amount, 0) + ln_transfer_amt,
1406: settled_flag = 'P'
1407: WHERE rowid = cur_credit.rowid;
1408:

Line 1429: UPDATE jai_rgm_trx_records

1425: ln_transfer_amt := ln_credit_balance;
1426: ln_credit_balance := 0;
1427: END IF;
1428:
1429: UPDATE jai_rgm_trx_records
1430: SET settled_amount = NVL(settled_amount,0) - ln_transfer_amt,
1431: settled_flag = 'P'
1432: WHERE rowid = cur_debit.rowid;
1433:

Line 1434: UPDATE jai_rgm_trx_records

1430: SET settled_amount = NVL(settled_amount,0) - ln_transfer_amt,
1431: settled_flag = 'P'
1432: WHERE rowid = cur_debit.rowid;
1433:
1434: UPDATE jai_rgm_trx_records
1435: SET settled_amount = NVL(settled_amount,0) + ln_transfer_amt,
1436: settled_flag = 'P'
1437: WHERE rowid = cur_credit.rowid;
1438:

Line 1450: UPDATE jai_rgm_trx_records

1446: END IF;
1447:
1448: <>
1449:
1450: UPDATE jai_rgm_trx_records
1451: SET settled_flag = 'Y',
1452: settled_amount = debit_amount*-1
1453: WHERE settlement_id <= pn_settlement_id
1454: AND organization_id = i.party_id

Line 1465: UPDATE jai_rgm_trx_records

1461: AND ( (NVL(pv_reverse_charge_flag,'N')='N' AND source_trx_type NOT IN ('REVERSE_PAID_ACCOUNTING','REVERSE_AVOID_ACCOUNTING','REVERSE_APPLY_ACCOUNTING','REVERSE_UNAPPLY_ACCOUNTING'))
1462: OR (NVL(pv_reverse_charge_flag,'N')='Y' AND source_trx_type IN ('REVERSE_PAID_ACCOUNTING','REVERSE_AVOID_ACCOUNTING','REVERSE_APPLY_ACCOUNTING','REVERSE_UNAPPLY_ACCOUNTING'))
1463: );
1464:
1465: UPDATE jai_rgm_trx_records
1466: SET settled_flag = 'Y',
1467: settled_amount = credit_amount
1468: WHERE settlement_id <= pn_settlement_id
1469: AND organization_id = i.party_id

Line 1584: FROM JAI_RGM_trX_records

1580: level during the VAT settlement ,this cursor will retrieve the data if the VAT settlement is performed at the OU level.*/
1581: CURSOR cur_recovervat_fromorg (cp_org_id in number,cp_loc_id in number,cp_tax_type varchar2)
1582: IS
1583: SELECT sum(nvl(trx_credit_amount,0))
1584: FROM JAI_RGM_trX_records
1585: WHERE settlement_id = pn_settlement_id
1586: and source_trx_type='SETTLEMENT'
1587: and source_table_name='JAI_RGM_SETTLEMENTS'
1588: and nvl(trx_credit_amount,0)>0

Line 1595: ln_recovery_vat jai_rgm_trx_Records.credit_amount%type;

1591: and tax_type=cp_tax_type
1592: AND account_name = 'RECOVERY';/*Bug 13788285*/
1593:
1594:
1595: ln_recovery_vat jai_rgm_trx_Records.credit_amount%type;
1596: ln_line_amount AP_INVOICE_LINES_ALL.AMOUNT%TYPE;
1597: --end additions by vkaranam for bug#12706846
1598:
1599: /*Start additions by mmurtuza for bug12641455*/

Line 2386: ln_repository_id jai_rgm_trx_records.repository_id%TYPE;

2382: AND rownum = 1; */
2383:
2384: rec_settlement cur_settlement%ROWTYPE;
2385:
2386: ln_repository_id jai_rgm_trx_records.repository_id%TYPE;
2387:
2388: lv_tax_type1 jai_rgm_stl_balances.tax_type%TYPE;
2389: lv_tax_type2 jai_rgm_stl_balances.tax_type%TYPE;
2390: ln_amount1 jai_rgm_stl_balances.debit_balance%TYPE;

Line 2402: ln_charge_accounting_id jai_rgm_trx_records.charge_account_id%type;

2398: lv_regime cur_regime_code%rowtype ;/* 4245365*/
2399: org_io_rec cur_org_io%ROWTYPE;
2400: ln_credit_amount NUMBER;
2401: ln_debit_amount NUMBER;
2402: ln_charge_accounting_id jai_rgm_trx_records.charge_account_id%type;
2403:
2404: BEGIN
2405:
2406: pv_process_flag := 'SS';

Line 2455: UPDATE jai_rgm_trx_records

2451: IF pv_process_flag <> 'SS' THEN
2452: goto MAIN_EXIT;
2453: END IF;
2454:
2455: UPDATE jai_rgm_trx_records
2456: SET settlement_id = pn_settlement_id
2457: WHERE repository_id = ln_repository_id;
2458:
2459: ELSIF lv_regime.regime_code = 'VAT' THEN

Line 2508: UPDATE jai_rgm_trx_records

2504: IF pv_process_flag <> 'SS' THEN
2505: goto MAIN_EXIT;
2506: END IF;
2507:
2508: UPDATE jai_rgm_trx_records
2509: SET settlement_id = pn_settlement_id
2510: WHERE repository_id = ln_repository_id;
2511: END LOOP;
2512: