DBA Data[Home] [Help]

APPS.JAI_RCV_RGM_CLAIMS_PKG dependencies on RCV_SHIPMENT_LINES

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 358: p_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE DEFAULT NULL,

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,
362: p_override IN VARCHAR2, --File.Sql.35 Cbabu DEFAULT 'N',

Line 371: cp_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE)

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
375: WHERE shipment_header_id = NVL(cp_shipment_header_id, shipment_header_id)

Line 379: CURSOR cur_txns(cp_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE,

375: WHERE shipment_header_id = NVL(cp_shipment_header_id, shipment_header_id)
376: AND shipment_line_id = NVL(cp_shipment_line_id, shipment_line_id)
377: ORDER BY shipment_line_id;
378:
379: CURSOR cur_txns(cp_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE,
380: cp_transaction_id IN rcv_transactions.transaction_id%TYPE)
381: IS
382: SELECT transaction_id,
383: transaction_type,

Line 428: CURSOR cur_term(cp_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE)

424: AND a.modvat_flag = 'Y'
425: --Added for Bug#4950914
426: AND NVL(a.tax_amount,0) <> 0;
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;

Line 652: p_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE,

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',
656: p_process_status OUT NOCOPY VARCHAR2,

Line 680: CURSOR c_tax_amount (cp_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE)

676: lv_item_class jai_rgm_lookups.attribute_code%TYPE;
677: ln_term_id NUMBER;
678: ln_location_id NUMBER(15);
679:
680: CURSOR c_tax_amount (cp_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE)
681: IS
682: SELECT nvl(rtl.tax_amount, 0) tax_amount,
683: nvl(rtl.modvat_flag, 'N') modvat_flag,
684: nvl(rtl.currency, jai_constants.func_curr) currency,

Line 697: cp_shipment_line_id IN rcv_shipment_lines.shipment_line_id%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
701: FROM JAI_RCV_LINES a,

Line 702: rcv_shipment_lines b

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
701: FROM JAI_RCV_LINES a,
702: rcv_shipment_lines b
703: WHERE a.shipment_header_id = b.shipment_header_id
704: AND a.shipment_line_id = b.shipment_line_id
705: AND a.shipment_header_id = NVL(cp_shipment_header_id,a.shipment_header_id)
706: AND a.shipment_line_id = NVL(cp_shipment_line_id, a.shipment_line_id);

Line 722: cp_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE)

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,
726: rcv_shipment_lines b

Line 726: rcv_shipment_lines b

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;
730:

Line 1027: p_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE DEFAULT NULL,

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,
1031: p_term_id IN jai_rgm_terms.term_id%TYPE DEFAULT -999,

Line 1047: cp_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE)

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
1051: FROM jai_rcv_rgm_claims

Line 1181: CURSOR c_rcv_rgm_lines(cp_shipment_line_id rcv_shipment_lines.shipment_line_id%TYPE)

1177: * Removed cursor c_org_info and variable r_org_info
1178: * and implemented caching logic.
1179: */
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;

Line 1749: p_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE DEFAULT NULL,

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,
1753: p_invoice_date IN JAI_RCV_TRANSACTIONS.vat_invoice_date%TYPE,

Line 1811: cp_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE,

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
1815: SELECT MIN(claim_schedule_id) claim_schedule_id

Line 2244: p_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE DEFAULT NULL,

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)*/
2248: --commented the above for Bug#4950914

Line 2251: p_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE DEFAULT NULL,

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,
2255: p_location_id IN hr_locations_all.location_id%TYPE DEFAULT NULL,

Line 2261: cp_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE,

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,
2265: shipment_line_id,

Line 2342: cp_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE)

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,
2346: location_id,

Line 2372: cp_shipment_line_id IN rcv_shipment_lines.shipment_line_id%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
2376: FROM JAI_RCV_TRANSACTIONS

Line 2387: cp_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE) /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/

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,
2391: SIGN(quantity) quantity_multiplier

Line 2681: p_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE DEFAULT NULL,

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,
2685: p_invoice_no IN JAI_RCV_TRANSACTIONS.vat_invoice_no%TYPE,

Line 2788: p_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE,

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,
2792: p_invoice_date IN JAI_RCV_TRANSACTIONS.vat_invoice_date%TYPE,

Line 2813: cp_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE,

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
2817: FROM jai_rcv_rgm_claims

Line 2824: cp_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE,

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)
2828: IS

Line 2852: cp_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE,

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
2856: SELECT MIN(claim_schedule_id) claim_schedule_id