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 RCV_SHIPMENT_HEADERS

Line 211: 1. Removed update of ATTRIBUTE (DFF) columns of RCV_SHIPMENT_HEADERS and RCV_SHIPMENT_LINES table

207: Problem - Cursor c_regime where clause was wrongly specified which
208: resulting in failure in generation of rtv accounting .....
209:
210: 18. 21/06/2007 brathod, for bug# 6109941, File Version 120.12, 120.13
211: 1. Removed update of ATTRIBUTE (DFF) columns of RCV_SHIPMENT_HEADERS and RCV_SHIPMENT_LINES table
212: 2. added excise_invoice_no and excise_invoice_date in cursor c_shipment_lines
213: 3. Changed reference of r_trx.excise_invoice_no and r_trx.excise_invoice_date to
214: rec_lines.excise_invoice_no and rec_lines.excise_invoice_date resp.
215:

Line 357: p_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE DEFAULT NULL,

353: END get_location;
354:
355: PROCEDURE generate_schedule(
356: p_term_id IN jai_rgm_terms.term_id%TYPE DEFAULT NULL,
357: p_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE DEFAULT NULL,
358: p_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE DEFAULT NULL,
359: p_transaction_id IN rcv_transactions.transaction_id%TYPE DEFAULT NULL,
360: p_tax_type IN JAI_CMN_TAXES_ALL.tax_type%TYPE DEFAULT NULL,
361: p_tax_id IN JAI_CMN_TAXES_ALL.tax_id%TYPE DEFAULT NULL,

Line 370: CURSOR cur_lines(cp_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE,

366: /*Bug 5096787. Added by Lakshmi Gopalsami */
367: p_simulate_flag IN VARCHAR2 DEFAULT 'N' -- Date 28/05/2007 sacsethi for bug 6071533 Change default value from null to N
368: )
369: IS
370: CURSOR cur_lines(cp_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE,
371: cp_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE)
372: IS
373: SELECT shipment_header_id, shipment_line_id
374: FROM JAI_RCV_LINES

Line 651: p_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE,

647: fnd_file.put_line(fnd_file.log, 'gone into error ');
648: END generate_schedule;
649:
650: PROCEDURE insert_rcv_lines(
651: p_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE,
652: p_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE,
653: p_transaction_id IN rcv_transactions.transaction_id%TYPE,
654: p_regime_code IN JAI_RGM_DEFINITIONS.regime_code%TYPE,
655: p_simulate_flag IN VARCHAR2, --File.Sql.35 Cbabu DEFAULT 'N',

Line 696: CURSOR c_shipment_lines(cp_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE,

692: AND jtc.tax_type IN (select tax_type
693: from jai_regime_tax_types_v
694: where regime_code = jai_constants.vat_regime);
695:
696: CURSOR c_shipment_lines(cp_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE,
697: cp_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE)
698: IS
699: SELECT a.shipment_line_id, a.transaction_id, a.inventory_item_id, a.receipt_num, b.line_num
700: , excise_invoice_no, excise_invoice_date -- brathod, Bug# 6109941

Line 721: CURSOR c_receipt_source_code(cp_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE,

717: Removed the NVL as shipment_header_id and shipment_line_id
718: cannot be null.
719: */
720:
721: CURSOR c_receipt_source_code(cp_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE,
722: cp_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE)
723: IS
724: SELECT receipt_source_code
725: FROM rcv_shipment_headers a,

Line 725: FROM rcv_shipment_headers a,

721: CURSOR c_receipt_source_code(cp_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE,
722: cp_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE)
723: IS
724: SELECT receipt_source_code
725: FROM rcv_shipment_headers a,
726: rcv_shipment_lines b
727: WHERE a.shipment_header_id = b.shipment_header_id
728: AND a.shipment_header_id = cp_shipment_header_id
729: AND b.shipment_line_id = cp_shipment_line_id;

Line 1026: p_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE,

1022: p_process_message := SUBSTR(SQLERRM,1,200);
1023: END insert_rcv_lines;
1024:
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,

Line 1046: CURSOR c_total_amount(cp_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE,

1042: ln_recoverable_amount NUMBER;
1043: ln_recovered_amount NUMBER;
1044: lv_process_status_flag VARCHAR2(2);
1045:
1046: CURSOR c_total_amount(cp_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE,
1047: cp_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE)
1048: IS
1049: SELECT NVL(SUM(installment_amount),0) recoverable_amount,
1050: NVL(SUM(claimed_amount),0) recovered_amount

Line 1748: p_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE DEFAULT NULL,

1744: p_regime_id IN JAI_RGM_DEFINITIONS.regime_id%TYPE,
1745: p_regime_regno IN VARCHAR2 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,

Line 1810: CURSOR c_claim_schedule( cp_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE,

1806: FROM JAI_RGM_DEFINITIONS
1807: WHERE regime_id = NVL(cp_regime_id, regime_id)
1808: AND regime_code = NVL(cp_regime_code, regime_code);
1809:
1810: CURSOR c_claim_schedule( cp_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE,
1811: cp_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE,
1812: cp_tax_type IN JAI_CMN_TAXES_ALL.tax_type%TYPE,
1813: cp_installment_no IN jai_rcv_rgm_claims.installment_no%TYPE)
1814: IS

Line 1949: -- RCV_SHIPMENT_HEADERS and RCV_TRASACTIONS tables

1945: IF rec_claims.invoice_no is not NULL and r_vat_invoice.excise_invoice_no is null THEN
1946:
1947: --
1948: -- Bug 6109941, Removed update statement of dff attribute columns of
1949: -- RCV_SHIPMENT_HEADERS and RCV_TRASACTIONS tables
1950: --
1951:
1952: UPDATE JAI_RCV_LINES
1953: SET excise_invoice_no = rec_claims.invoice_no,

Line 2243: p_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE DEFAULT NULL,

2239: p_process_message := SUBSTR('jai_rcv_rgm_claims_pkg.process_claim Error:'||SQLERRM,1,200);
2240: END process_claim;
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)*/

Line 2250: p_shipment_header_id IN rcv_shipment_headers.shipment_header_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(
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,

Line 2260: /*CURSOR c_shipment_lines(cp_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE,

2256: p_process_status OUT NOCOPY VARCHAR2,
2257: p_process_message OUT NOCOPY VARCHAR2,
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,

Line 2341: CURSOR c_receive_transaction(cp_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE,

2337: where regime_code = jai_constants.vat_regime)
2338: AND a.tax_id = b.tax_id
2339: AND NVL(a.modvat_flag,'N') = 'Y';
2340:
2341: CURSOR c_receive_transaction(cp_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE,
2342: cp_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE)
2343: IS
2344: SELECT transaction_id,
2345: organization_id,

Line 2371: CURSOR c_receive_correct_txns(cp_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE, /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/

2367: lv_ttype_correct JAI_RCV_TRANSACTIONS.transaction_type%type;
2368: lv_ttype_deliver JAI_RCV_TRANSACTIONS.transaction_type%type;
2369: lv_ttype_rtr JAI_RCV_TRANSACTIONS.transaction_type%type;
2370:
2371: CURSOR c_receive_correct_txns(cp_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE, /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
2372: cp_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE)
2373: IS
2374: SELECT transaction_id,
2375: tax_transaction_id

Line 2386: CURSOR c_deliver_rtr_txns(cp_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE,

2382: AND parent_transaction_type = lv_ttype_receive )--'RECEIVE')
2383: )
2384: ORDER BY transaction_id;
2385:
2386: CURSOR c_deliver_rtr_txns(cp_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE,
2387: cp_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE) /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
2388: IS
2389: SELECT transaction_id,
2390: tax_transaction_id,

Line 2680: p_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE DEFAULT NULL,

2676: p_regime_id IN JAI_RGM_DEFINITIONS.regime_id%TYPE,
2677: p_regime_regno IN VARCHAR2 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,

Line 2787: p_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE,

2783: lv_codepath := jai_general_pkg.plot_codepath(1, lv_codepath, 'jai_rcv_rgm_claims_pkg.process_batch', 'END');
2784: END process_batch;
2785:
2786: PROCEDURE do_rtv_accounting(
2787: p_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE,
2788: p_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE,
2789: p_transaction_id IN rcv_transactions.transaction_id%TYPE,
2790: p_called_from IN VARCHAR2,
2791: p_invoice_no IN JAI_RCV_TRANSACTIONS.vat_invoice_no%TYPE,

Line 2812: CURSOR c_min_installment_no(cp_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE,

2808: b.location_id,
2809: b.receipt_num,
2810: a.tax_type;
2811:
2812: CURSOR c_min_installment_no(cp_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE,
2813: cp_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE,
2814: cp_transaction_type jai_rcv_rgm_claims.transaction_type%type)
2815: IS
2816: SELECT NVL(max(installment_no),0) installment_no --for Bug #4279050, changed from min to max

Line 2823: CURSOR c_total_reversal_amount(cp_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE,

2819: AND shipment_line_id = cp_shipment_line_id
2820: AND transaction_type = cp_transaction_type --'RECEIVE' /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
2821: AND claimed_date IS NOT NULL;
2822:
2823: CURSOR c_total_reversal_amount(cp_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE,
2824: cp_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE,
2825: cp_transaction_id IN rcv_transactions.transaction_id%TYPE,
2826: cp_tax_type IN VARCHAR2,
2827: cp_installment_no IN NUMBER)

Line 2851: CURSOR c_claim_schedule(cp_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE,

2847:
2848: --WHERE regime_id = NVL(cp_regime_id, regime_id)
2849: --AND regime_code = NVL(cp_regime_code, regime_code);
2850:
2851: CURSOR c_claim_schedule(cp_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE,
2852: cp_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE,
2853: cp_transaction_id IN rcv_transactions.transaction_id%TYPE,
2854: cp_tax_type IN JAI_CMN_TAXES_ALL.tax_type%TYPE)
2855: IS