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_RCV_RGM_CLAIMS_PKG dependencies on JAI_RCV_RGM_LINES

Line 431: FROM jai_rcv_rgm_lines

427:
428: CURSOR cur_term(cp_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE)
429: IS
430: SELECT term_id, rcv_rgm_line_id, receipt_date
431: FROM jai_rcv_rgm_lines
432: WHERE shipment_line_id = cp_shipment_line_id;
433:
434: CURSOR cur_sum_schedules(cp_schedule_id IN NUMBER)
435: IS

Line 800: from jai_rcv_rgm_lines

796: IF r_trx.transaction_type IN ('RECEIVE', 'MATCH') THEN
797:
798: select count(1)
799: into ln_dup_chk
800: from jai_rcv_rgm_lines
801: where transaction_id = r_trx.transaction_id;
802:
803: IF gv_debug THEN
804: fnd_file.put_line(fnd_file.log, '2 insert_rcv_lines:ln_dup_chk:'||ln_dup_chk);

Line 954: INTO jai_rcv_rgm_lines

950: END IF;
951: /*bduvarag Bug 5899383 End*/
952:
953: INSERT
954: INTO jai_rcv_rgm_lines
955: (
956: RCV_RGM_LINE_ID,
957: SHIPMENT_HEADER_ID,
958: SHIPMENT_LINE_ID,

Line 988: jai_rcv_rgm_lines_s.NEXTVAL,

984: LAST_UPDATE_LOGIN
985: )
986: VALUES
987: (
988: jai_rcv_rgm_lines_s.NEXTVAL,
989: r_base_trx.shipment_header_id,
990: r_base_trx.shipment_line_id,
991: r_base_trx.organization_id,
992: ln_location_id,

Line 1029: p_recoverable_amount IN jai_rcv_rgm_lines.recoverable_amount%TYPE DEFAULT NULL,

1025: PROCEDURE update_rcv_lines(
1026: p_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE,
1027: p_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE DEFAULT NULL,
1028: p_receipt_num IN JAI_RCV_LINES.receipt_num%TYPE DEFAULT NULL,
1029: p_recoverable_amount IN jai_rcv_rgm_lines.recoverable_amount%TYPE DEFAULT NULL,
1030: p_recovered_amount IN jai_rcv_rgm_lines.recovered_amount%TYPE DEFAULT NULL,
1031: p_term_id IN jai_rgm_terms.term_id%TYPE DEFAULT -999,
1032: p_invoice_no IN JAI_RCV_TRANSACTIONS.vat_invoice_no%TYPE, --File.Sql.35 Cbabu DEFAULT '-X9X',
1033: p_invoice_date IN JAI_RCV_TRANSACTIONS.vat_invoice_date%TYPE, --File.Sql.35 Cbabu DEFAULT TO_DATE('01/01/1900','DD/MM/YYYY'),

Line 1030: p_recovered_amount IN jai_rcv_rgm_lines.recovered_amount%TYPE DEFAULT NULL,

1026: p_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE,
1027: p_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE DEFAULT NULL,
1028: p_receipt_num IN JAI_RCV_LINES.receipt_num%TYPE DEFAULT NULL,
1029: p_recoverable_amount IN jai_rcv_rgm_lines.recoverable_amount%TYPE DEFAULT NULL,
1030: p_recovered_amount IN jai_rcv_rgm_lines.recovered_amount%TYPE DEFAULT NULL,
1031: p_term_id IN jai_rgm_terms.term_id%TYPE DEFAULT -999,
1032: p_invoice_no IN JAI_RCV_TRANSACTIONS.vat_invoice_no%TYPE, --File.Sql.35 Cbabu DEFAULT '-X9X',
1033: p_invoice_date IN JAI_RCV_TRANSACTIONS.vat_invoice_date%TYPE, --File.Sql.35 Cbabu DEFAULT TO_DATE('01/01/1900','DD/MM/YYYY'),
1034: p_vendor_id IN po_vendors.vendor_id%TYPE DEFAULT -999,

Line 1036: p_correct_receive_qty IN jai_rcv_rgm_lines.correct_receive_qty%TYPE DEFAULT NULL,

1032: p_invoice_no IN JAI_RCV_TRANSACTIONS.vat_invoice_no%TYPE, --File.Sql.35 Cbabu DEFAULT '-X9X',
1033: p_invoice_date IN JAI_RCV_TRANSACTIONS.vat_invoice_date%TYPE, --File.Sql.35 Cbabu DEFAULT TO_DATE('01/01/1900','DD/MM/YYYY'),
1034: p_vendor_id IN po_vendors.vendor_id%TYPE DEFAULT -999,
1035: p_vendor_site_id IN po_vendor_sites_all.vendor_site_id%TYPE DEFAULT NULL,
1036: p_correct_receive_qty IN jai_rcv_rgm_lines.correct_receive_qty%TYPE DEFAULT NULL,
1037: p_rtv_qty IN jai_rcv_rgm_lines.rtv_qty%TYPE DEFAULT NULL,
1038: p_correct_rtv_qty IN jai_rcv_rgm_lines.correct_rtv_qty%TYPE DEFAULT NULL,
1039: p_process_status OUT NOCOPY VARCHAR2,
1040: p_process_message OUT NOCOPY VARCHAR2)

Line 1037: p_rtv_qty IN jai_rcv_rgm_lines.rtv_qty%TYPE DEFAULT NULL,

1033: p_invoice_date IN JAI_RCV_TRANSACTIONS.vat_invoice_date%TYPE, --File.Sql.35 Cbabu DEFAULT TO_DATE('01/01/1900','DD/MM/YYYY'),
1034: p_vendor_id IN po_vendors.vendor_id%TYPE DEFAULT -999,
1035: p_vendor_site_id IN po_vendor_sites_all.vendor_site_id%TYPE DEFAULT NULL,
1036: p_correct_receive_qty IN jai_rcv_rgm_lines.correct_receive_qty%TYPE DEFAULT NULL,
1037: p_rtv_qty IN jai_rcv_rgm_lines.rtv_qty%TYPE DEFAULT NULL,
1038: p_correct_rtv_qty IN jai_rcv_rgm_lines.correct_rtv_qty%TYPE DEFAULT NULL,
1039: p_process_status OUT NOCOPY VARCHAR2,
1040: p_process_message OUT NOCOPY VARCHAR2)
1041: IS

Line 1038: p_correct_rtv_qty IN jai_rcv_rgm_lines.correct_rtv_qty%TYPE DEFAULT NULL,

1034: p_vendor_id IN po_vendors.vendor_id%TYPE DEFAULT -999,
1035: p_vendor_site_id IN po_vendor_sites_all.vendor_site_id%TYPE DEFAULT NULL,
1036: p_correct_receive_qty IN jai_rcv_rgm_lines.correct_receive_qty%TYPE DEFAULT NULL,
1037: p_rtv_qty IN jai_rcv_rgm_lines.rtv_qty%TYPE DEFAULT NULL,
1038: p_correct_rtv_qty IN jai_rcv_rgm_lines.correct_rtv_qty%TYPE DEFAULT NULL,
1039: p_process_status OUT NOCOPY VARCHAR2,
1040: p_process_message OUT NOCOPY VARCHAR2)
1041: IS
1042: ln_recoverable_amount NUMBER;

Line 1070: UPDATE JAI_RCV_RGM_LINES

1066: OPEN c_total_amount(p_shipment_header_id, p_shipment_line_id);
1067: FETCH c_total_amount INTO r_total_amount;
1068: CLOSE c_total_amount;
1069:
1070: UPDATE JAI_RCV_RGM_LINES
1071: SET recoverable_amount = r_total_amount.recoverable_amount,
1072: recovered_amount = r_total_amount.recovered_amount,
1073: correct_receive_qty = NVL(correct_receive_qty,0) + NVL(p_correct_receive_qty,0),
1074: rtv_qty = NVL(rtv_qty,0) + NVL(p_rtv_qty,0),

Line 1088: UPDATE JAI_RCV_RGM_LINES

1084: ELSIF ln_recovered_amount > 0 THEN
1085: lv_process_status_flag := 'P';
1086: END IF;
1087:
1088: UPDATE JAI_RCV_RGM_LINES
1089: SET process_status_flag = lv_process_status_flag
1090: WHERE shipment_line_id = NVL(p_shipment_line_id,shipment_line_id)
1091: AND receipt_num = NVL(p_receipt_num, receipt_num);
1092: END IF;

Line 1184: FROM jai_rcv_rgm_lines

1180: --cursor added by Ramananda for Bug#4530112
1181: CURSOR c_rcv_rgm_lines(cp_shipment_line_id rcv_shipment_lines.shipment_line_id%TYPE)
1182: IS
1183: SELECT *
1184: FROM jai_rcv_rgm_lines
1185: WHERE shipment_line_id = cp_shipment_line_id;
1186:
1187: r_rcv_rgm_lines c_rcv_rgm_lines%ROWTYPE;
1188:

Line 1313: --to Update the jai_rcv_rgm_lines table for the Schedule generated above

1309: ln_correct_rtv_qty := r_base_trx.quantity;
1310: END IF;
1311: END IF;
1312:
1313: --to Update the jai_rcv_rgm_lines table for the Schedule generated above
1314: update_rcv_lines(p_shipment_header_id => r_base_trx.shipment_header_id,
1315: p_shipment_line_id => r_base_trx.shipment_line_id,
1316: p_rtv_qty => ln_rtv_qty,
1317: p_correct_receive_qty => ln_correct_receive_qty,

Line 1750: p_batch_id IN JAI_RCV_RGM_LINES.BATCH_NUM%TYPE DEFAULT NULL,

1746: p_organization_id IN hr_all_organization_units.organization_id%TYPE DEFAULT NULL,
1747: p_location_id IN hr_locations_all.location_id%TYPE DEFAULT NULL,
1748: p_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE DEFAULT NULL,
1749: p_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE DEFAULT NULL,
1750: p_batch_id IN JAI_RCV_RGM_LINES.BATCH_NUM%TYPE DEFAULT NULL,
1751: p_force IN VARCHAR2 DEFAULT NULL,
1752: p_invoice_no IN JAI_RCV_TRANSACTIONS.vat_invoice_no%TYPE,
1753: p_invoice_date IN JAI_RCV_TRANSACTIONS.vat_invoice_date%TYPE,
1754: p_called_from IN VARCHAR2,

Line 1862: lv_invoice_no JAI_RCV_RGM_LINES.invoice_no%TYPE;

1858: ln_interim_recovery_account NUMBER;
1859: r_vat_invoice c_vat_invoice%ROWTYPE;
1860: lv_source_trx_type VARCHAR2(50);
1861: lv_account_name VARCHAR2(50);
1862: lv_invoice_no JAI_RCV_RGM_LINES.invoice_no%TYPE;
1863: ld_invoice_date JAI_RCV_RGM_LINES.invoice_date%TYPE;
1864: /*bduvarag Bug 5899383 Start*/
1865: lv_default_invoice_setup VARCHAR2(100);
1866: ld_excise_invoice_Date DATE;

Line 1863: ld_invoice_date JAI_RCV_RGM_LINES.invoice_date%TYPE;

1859: r_vat_invoice c_vat_invoice%ROWTYPE;
1860: lv_source_trx_type VARCHAR2(50);
1861: lv_account_name VARCHAR2(50);
1862: lv_invoice_no JAI_RCV_RGM_LINES.invoice_no%TYPE;
1863: ld_invoice_date JAI_RCV_RGM_LINES.invoice_date%TYPE;
1864: /*bduvarag Bug 5899383 Start*/
1865: lv_default_invoice_setup VARCHAR2(100);
1866: ld_excise_invoice_Date DATE;
1867: /*bduvarag Bug 5899383 End*/

Line 2245: p_batch_id IN jai_rcv_rgm_lines.batch_id%TYPE DEFAULT NULL,

2241:
2242: /*PROCEDURE process_no_claim(
2243: p_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE DEFAULT NULL,
2244: p_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE DEFAULT NULL,
2245: p_batch_id IN jai_rcv_rgm_lines.batch_id%TYPE DEFAULT NULL,
2246: p_process_status OUT NOCOPY VARCHAR2,
2247: p_process_message OUT NOCOPY VARCHAR2)*/
2248: --commented the above for Bug#4950914
2249: PROCEDURE process_no_claim(

Line 2252: p_batch_id IN jai_rcv_rgm_lines.batch_num%TYPE DEFAULT NULL,

2248: --commented the above for Bug#4950914
2249: PROCEDURE process_no_claim(
2250: p_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE DEFAULT NULL,
2251: p_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE DEFAULT NULL,
2252: p_batch_id IN jai_rcv_rgm_lines.batch_num%TYPE DEFAULT NULL,
2253: p_regime_regno IN VARCHAR2 DEFAULT NULL,
2254: p_organization_id IN hr_all_organization_units.organization_id%TYPE DEFAULT NULL,
2255: p_location_id IN hr_locations_all.location_id%TYPE DEFAULT NULL,
2256: p_process_status OUT NOCOPY VARCHAR2,

Line 2262: cp_batch_id IN jai_rcv_rgm_lines.batch_id%TYPE)

2258: p_regime_id IN JAI_RGM_DEFINITIONS.regime_id%TYPE DEFAULT NULL )
2259: IS
2260: /*CURSOR c_shipment_lines(cp_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE,
2261: cp_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE,
2262: cp_batch_id IN jai_rcv_rgm_lines.batch_id%TYPE)
2263: IS
2264: SELECT shipment_header_id,
2265: shipment_line_id,
2266: receipt_num,

Line 2268: FROM jai_rcv_rgm_lines

2264: SELECT shipment_header_id,
2265: shipment_line_id,
2266: receipt_num,
2267: transaction_id
2268: FROM jai_rcv_rgm_lines
2269: WHERE (( NVL(cp_batch_id,0) = 0
2270: AND shipment_header_id = NVL(cp_shipment_header_id, shipment_header_id)
2271: AND shipment_line_id = NVL(cp_shipment_line_id, shipment_line_id))
2272: OR ( NVL(cp_batch_id,0) <> 0

Line 2295: jai_rcv_rgm_lines b,

2291: b.transaction_id,
2292: b.receipt_num,
2293: b.rcv_rgm_line_id
2294: FROM JAI_RGM_ORG_REGNS_V a,
2295: jai_rcv_rgm_lines b,
2296: JAI_RGM_DEFINITIONS c
2297: WHERE a.regime_code = c.regime_code
2298: AND c.regime_id = cp_regime_id
2299: AND a.attribute_value = NVL(cp_regime_regno, a.attribute_value)

Line 2652: UPDATE jai_rcv_rgm_lines

2648: where regime_code = jai_constants.vat_regime)
2649: AND modvat_flag = 'Y';
2650:
2651: --To update the Status, so that It should not be considered for claiming
2652: UPDATE jai_rcv_rgm_lines
2653: SET process_status_flag = 'U',
2654: recoverable_amount = 0,
2655: recovered_amount = 0
2656: WHERE shipment_header_id = r_shipment_lines.shipment_header_id

Line 2682: p_batch_id IN JAI_RCV_RGM_LINES.BATCH_NUM%TYPE DEFAULT NULL,

2678: p_organization_id IN hr_all_organization_units.organization_id%TYPE DEFAULT NULL,
2679: p_location_id IN hr_locations_all.location_id%TYPE DEFAULT NULL,
2680: p_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE DEFAULT NULL,
2681: p_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE DEFAULT NULL,
2682: p_batch_id IN JAI_RCV_RGM_LINES.BATCH_NUM%TYPE DEFAULT NULL,
2683: p_force IN VARCHAR2 DEFAULT NULL,
2684: p_commit_switch IN VARCHAR2,
2685: p_invoice_no IN JAI_RCV_TRANSACTIONS.vat_invoice_no%TYPE,
2686: pv_invoice_date IN VARCHAR2, /* rallamse bug#4336482 changed to VARCHAR2 from DATE */

Line 2804: jai_rcv_rgm_lines b

2800: b.receipt_num,
2801: a.tax_type,
2802: (NVL(SUM(a.installment_amount),0) - NVL(SUM(a.claimed_amount),0))*-1 installment_amount
2803: FROM jai_rcv_rgm_claims a,
2804: jai_rcv_rgm_lines b
2805: WHERE a.rcv_rgm_line_id = b.rcv_rgm_line_id
2806: AND a.transaction_id = cp_transaction_id
2807: GROUP BY b.organization_id,
2808: b.location_id,