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 498: FROM jai_rcv_rgm_lines

494:
495: CURSOR cur_term(cp_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE)
496: IS
497: SELECT term_id, rcv_rgm_line_id, receipt_date
498: FROM jai_rcv_rgm_lines
499: WHERE shipment_line_id = cp_shipment_line_id;
500:
501: CURSOR cur_sum_schedules(cp_schedule_id IN NUMBER)
502: IS

Line 870: from jai_rcv_rgm_lines

866: IF r_trx.transaction_type IN ('RECEIVE', 'MATCH') THEN
867:
868: select count(1)
869: into ln_dup_chk
870: from jai_rcv_rgm_lines
871: where transaction_id = r_trx.transaction_id;
872:
873: IF gv_debug THEN
874: fnd_file.put_line(fnd_file.log, '2 insert_rcv_lines:ln_dup_chk:'||ln_dup_chk);

Line 1024: INTO jai_rcv_rgm_lines

1020: END IF;
1021: /*bduvarag Bug 5899383 End*/
1022:
1023: INSERT
1024: INTO jai_rcv_rgm_lines
1025: (
1026: RCV_RGM_LINE_ID,
1027: SHIPMENT_HEADER_ID,
1028: SHIPMENT_LINE_ID,

Line 1058: jai_rcv_rgm_lines_s.NEXTVAL,

1054: LAST_UPDATE_LOGIN
1055: )
1056: VALUES
1057: (
1058: jai_rcv_rgm_lines_s.NEXTVAL,
1059: r_base_trx.shipment_header_id,
1060: r_base_trx.shipment_line_id,
1061: r_base_trx.organization_id,
1062: ln_location_id,

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

1095: PROCEDURE update_rcv_lines(
1096: p_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE,
1097: p_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE DEFAULT NULL,
1098: p_receipt_num IN JAI_RCV_LINES.receipt_num%TYPE DEFAULT NULL,
1099: p_recoverable_amount IN jai_rcv_rgm_lines.recoverable_amount%TYPE DEFAULT NULL,
1100: p_recovered_amount IN jai_rcv_rgm_lines.recovered_amount%TYPE DEFAULT NULL,
1101: p_term_id IN jai_rgm_terms.term_id%TYPE DEFAULT -999,
1102: p_invoice_no IN JAI_RCV_TRANSACTIONS.vat_invoice_no%TYPE, --File.Sql.35 Cbabu DEFAULT '-X9X',
1103: 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 1100: p_recovered_amount IN jai_rcv_rgm_lines.recovered_amount%TYPE DEFAULT NULL,

1096: p_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE,
1097: p_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE DEFAULT NULL,
1098: p_receipt_num IN JAI_RCV_LINES.receipt_num%TYPE DEFAULT NULL,
1099: p_recoverable_amount IN jai_rcv_rgm_lines.recoverable_amount%TYPE DEFAULT NULL,
1100: p_recovered_amount IN jai_rcv_rgm_lines.recovered_amount%TYPE DEFAULT NULL,
1101: p_term_id IN jai_rgm_terms.term_id%TYPE DEFAULT -999,
1102: p_invoice_no IN JAI_RCV_TRANSACTIONS.vat_invoice_no%TYPE, --File.Sql.35 Cbabu DEFAULT '-X9X',
1103: p_invoice_date IN JAI_RCV_TRANSACTIONS.vat_invoice_date%TYPE, --File.Sql.35 Cbabu DEFAULT TO_DATE('01/01/1900','DD/MM/YYYY'),
1104: p_vendor_id IN po_vendors.vendor_id%TYPE DEFAULT -999,

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

1102: p_invoice_no IN JAI_RCV_TRANSACTIONS.vat_invoice_no%TYPE, --File.Sql.35 Cbabu DEFAULT '-X9X',
1103: p_invoice_date IN JAI_RCV_TRANSACTIONS.vat_invoice_date%TYPE, --File.Sql.35 Cbabu DEFAULT TO_DATE('01/01/1900','DD/MM/YYYY'),
1104: p_vendor_id IN po_vendors.vendor_id%TYPE DEFAULT -999,
1105: p_vendor_site_id IN po_vendor_sites_all.vendor_site_id%TYPE DEFAULT NULL,
1106: p_correct_receive_qty IN jai_rcv_rgm_lines.correct_receive_qty%TYPE DEFAULT NULL,
1107: p_rtv_qty IN jai_rcv_rgm_lines.rtv_qty%TYPE DEFAULT NULL,
1108: p_correct_rtv_qty IN jai_rcv_rgm_lines.correct_rtv_qty%TYPE DEFAULT NULL,
1109: p_process_status OUT NOCOPY VARCHAR2,
1110: p_process_message OUT NOCOPY VARCHAR2)

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

1103: p_invoice_date IN JAI_RCV_TRANSACTIONS.vat_invoice_date%TYPE, --File.Sql.35 Cbabu DEFAULT TO_DATE('01/01/1900','DD/MM/YYYY'),
1104: p_vendor_id IN po_vendors.vendor_id%TYPE DEFAULT -999,
1105: p_vendor_site_id IN po_vendor_sites_all.vendor_site_id%TYPE DEFAULT NULL,
1106: p_correct_receive_qty IN jai_rcv_rgm_lines.correct_receive_qty%TYPE DEFAULT NULL,
1107: p_rtv_qty IN jai_rcv_rgm_lines.rtv_qty%TYPE DEFAULT NULL,
1108: p_correct_rtv_qty IN jai_rcv_rgm_lines.correct_rtv_qty%TYPE DEFAULT NULL,
1109: p_process_status OUT NOCOPY VARCHAR2,
1110: p_process_message OUT NOCOPY VARCHAR2)
1111: IS

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

1104: p_vendor_id IN po_vendors.vendor_id%TYPE DEFAULT -999,
1105: p_vendor_site_id IN po_vendor_sites_all.vendor_site_id%TYPE DEFAULT NULL,
1106: p_correct_receive_qty IN jai_rcv_rgm_lines.correct_receive_qty%TYPE DEFAULT NULL,
1107: p_rtv_qty IN jai_rcv_rgm_lines.rtv_qty%TYPE DEFAULT NULL,
1108: p_correct_rtv_qty IN jai_rcv_rgm_lines.correct_rtv_qty%TYPE DEFAULT NULL,
1109: p_process_status OUT NOCOPY VARCHAR2,
1110: p_process_message OUT NOCOPY VARCHAR2)
1111: IS
1112: ln_recoverable_amount NUMBER;

Line 1140: UPDATE JAI_RCV_RGM_LINES

1136: OPEN c_total_amount(p_shipment_header_id, p_shipment_line_id);
1137: FETCH c_total_amount INTO r_total_amount;
1138: CLOSE c_total_amount;
1139:
1140: UPDATE JAI_RCV_RGM_LINES
1141: SET recoverable_amount = r_total_amount.recoverable_amount,
1142: recovered_amount = r_total_amount.recovered_amount,
1143: correct_receive_qty = NVL(correct_receive_qty,0) + NVL(p_correct_receive_qty,0),
1144: rtv_qty = NVL(rtv_qty,0) + NVL(p_rtv_qty,0),

Line 1159: UPDATE JAI_RCV_RGM_LINES

1155: ELSIF ln_recovered_amount > 0 THEN
1156: lv_process_status_flag := 'P';
1157: END IF;
1158:
1159: UPDATE JAI_RCV_RGM_LINES
1160: SET process_status_flag = nvl(lv_process_status_flag,process_status_flag) --added nvl process_status_flag condition for bug#9970962
1161: WHERE shipment_line_id = NVL(p_shipment_line_id,shipment_line_id)
1162: AND receipt_num = NVL(p_receipt_num, receipt_num);
1163: END IF;

Line 1255: FROM jai_rcv_rgm_lines

1251: --cursor added by Ramananda for Bug#4530112
1252: CURSOR c_rcv_rgm_lines(cp_shipment_line_id rcv_shipment_lines.shipment_line_id%TYPE)
1253: IS
1254: SELECT *
1255: FROM jai_rcv_rgm_lines
1256: WHERE shipment_line_id = cp_shipment_line_id;
1257:
1258: r_rcv_rgm_lines c_rcv_rgm_lines%ROWTYPE;
1259:

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

1380: ln_correct_rtv_qty := r_base_trx.quantity;
1381: END IF;
1382: END IF;
1383:
1384: --to Update the jai_rcv_rgm_lines table for the Schedule generated above
1385: update_rcv_lines(p_shipment_header_id => r_base_trx.shipment_header_id,
1386: p_shipment_line_id => r_base_trx.shipment_line_id,
1387: p_rtv_qty => ln_rtv_qty,
1388: p_correct_receive_qty => ln_correct_receive_qty,

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

1817: p_organization_id IN hr_all_organization_units.organization_id%TYPE DEFAULT NULL,
1818: p_location_id IN hr_locations_all.location_id%TYPE DEFAULT NULL,
1819: p_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE DEFAULT NULL,
1820: p_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE DEFAULT NULL,
1821: p_batch_id IN JAI_RCV_RGM_LINES.BATCH_NUM%TYPE DEFAULT NULL,
1822: p_force IN VARCHAR2 DEFAULT NULL,
1823: p_invoice_no IN JAI_RCV_TRANSACTIONS.vat_invoice_no%TYPE,
1824: p_invoice_date IN JAI_RCV_TRANSACTIONS.vat_invoice_date%TYPE,
1825: p_called_from IN VARCHAR2,

Line 1934: lv_invoice_no JAI_RCV_RGM_LINES.invoice_no%TYPE;

1930: ln_interim_recovery_account NUMBER;
1931: r_vat_invoice c_vat_invoice%ROWTYPE;
1932: lv_source_trx_type VARCHAR2(50);
1933: lv_account_name VARCHAR2(50);
1934: lv_invoice_no JAI_RCV_RGM_LINES.invoice_no%TYPE;
1935: ld_invoice_date JAI_RCV_RGM_LINES.invoice_date%TYPE;
1936: /*bduvarag Bug 5899383 Start*/
1937: lv_default_invoice_setup VARCHAR2(100);
1938: ld_excise_invoice_Date DATE;

Line 1935: ld_invoice_date JAI_RCV_RGM_LINES.invoice_date%TYPE;

1931: r_vat_invoice c_vat_invoice%ROWTYPE;
1932: lv_source_trx_type VARCHAR2(50);
1933: lv_account_name VARCHAR2(50);
1934: lv_invoice_no JAI_RCV_RGM_LINES.invoice_no%TYPE;
1935: ld_invoice_date JAI_RCV_RGM_LINES.invoice_date%TYPE;
1936: /*bduvarag Bug 5899383 Start*/
1937: lv_default_invoice_setup VARCHAR2(100);
1938: ld_excise_invoice_Date DATE;
1939: /*bduvarag Bug 5899383 End*/

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

2321:
2322: /*PROCEDURE process_no_claim(
2323: p_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE DEFAULT NULL,
2324: p_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE DEFAULT NULL,
2325: p_batch_id IN jai_rcv_rgm_lines.batch_id%TYPE DEFAULT NULL,
2326: p_process_status OUT NOCOPY VARCHAR2,
2327: p_process_message OUT NOCOPY VARCHAR2)*/
2328: --commented the above for Bug#4950914
2329: PROCEDURE process_no_claim(

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

2328: --commented the above for Bug#4950914
2329: PROCEDURE process_no_claim(
2330: p_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE DEFAULT NULL,
2331: p_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE DEFAULT NULL,
2332: p_batch_id IN jai_rcv_rgm_lines.batch_num%TYPE DEFAULT NULL,
2333: p_regime_regno IN VARCHAR2 DEFAULT NULL,
2334: p_organization_id IN hr_all_organization_units.organization_id%TYPE DEFAULT NULL,
2335: p_location_id IN hr_locations_all.location_id%TYPE DEFAULT NULL,
2336: p_process_status OUT NOCOPY VARCHAR2,

Line 2342: cp_batch_id IN jai_rcv_rgm_lines.batch_id%TYPE)

2338: p_regime_id IN JAI_RGM_DEFINITIONS.regime_id%TYPE DEFAULT NULL )
2339: IS
2340: /*CURSOR c_shipment_lines(cp_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE,
2341: cp_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE,
2342: cp_batch_id IN jai_rcv_rgm_lines.batch_id%TYPE)
2343: IS
2344: SELECT shipment_header_id,
2345: shipment_line_id,
2346: receipt_num,

Line 2348: FROM jai_rcv_rgm_lines

2344: SELECT shipment_header_id,
2345: shipment_line_id,
2346: receipt_num,
2347: transaction_id
2348: FROM jai_rcv_rgm_lines
2349: WHERE (( NVL(cp_batch_id,0) = 0
2350: AND shipment_header_id = NVL(cp_shipment_header_id, shipment_header_id)
2351: AND shipment_line_id = NVL(cp_shipment_line_id, shipment_line_id))
2352: OR ( NVL(cp_batch_id,0) <> 0

Line 2375: jai_rcv_rgm_lines b,

2371: b.transaction_id,
2372: b.receipt_num,
2373: b.rcv_rgm_line_id
2374: FROM JAI_RGM_ORG_REGNS_V a,
2375: jai_rcv_rgm_lines b,
2376: JAI_RGM_DEFINITIONS c
2377: WHERE a.regime_code = c.regime_code
2378: AND c.regime_id = cp_regime_id
2379: AND a.attribute_value = NVL(cp_regime_regno, a.attribute_value)

Line 2842: UPDATE jai_rcv_rgm_lines

2838: where regime_code = jai_constants.vat_regime)
2839: AND modvat_flag = 'Y';
2840:
2841: --To update the Status, so that It should not be considered for claiming
2842: UPDATE jai_rcv_rgm_lines
2843: SET process_status_flag = 'U',
2844: recoverable_amount = 0,
2845: recovered_amount = 0
2846: WHERE shipment_header_id = r_shipment_lines.shipment_header_id

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

2891: p_organization_id IN hr_all_organization_units.organization_id%TYPE DEFAULT NULL,
2892: p_location_id IN hr_locations_all.location_id%TYPE DEFAULT NULL,
2893: p_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE DEFAULT NULL,
2894: p_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE DEFAULT NULL,
2895: p_batch_id IN JAI_RCV_RGM_LINES.BATCH_NUM%TYPE DEFAULT NULL,
2896: p_force IN VARCHAR2 DEFAULT NULL,
2897: p_commit_switch IN VARCHAR2,
2898: p_invoice_no IN JAI_RCV_TRANSACTIONS.vat_invoice_no%TYPE,
2899: pv_invoice_date IN VARCHAR2, /* rallamse bug#4336482 changed to VARCHAR2 from DATE */

Line 3017: jai_rcv_rgm_lines b

3013: b.receipt_num,
3014: a.tax_type,
3015: (NVL(SUM(a.installment_amount),0) - NVL(SUM(a.claimed_amount),0))*-1 installment_amount
3016: FROM jai_rcv_rgm_claims a,
3017: jai_rcv_rgm_lines b
3018: WHERE a.rcv_rgm_line_id = b.rcv_rgm_line_id
3019: AND a.transaction_id = cp_transaction_id
3020: GROUP BY b.organization_id,
3021: b.location_id,