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_RGM_DEFINITIONS

Line 724: p_regime_code IN JAI_RGM_DEFINITIONS.regime_code%TYPE,

720: PROCEDURE insert_rcv_lines(
721: p_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE,
722: p_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE,
723: p_transaction_id IN rcv_transactions.transaction_id%TYPE,
724: p_regime_code IN JAI_RGM_DEFINITIONS.regime_code%TYPE,
725: p_simulate_flag IN VARCHAR2, --File.Sql.35 Cbabu DEFAULT 'N',
726: p_process_status OUT NOCOPY VARCHAR2,
727: p_process_message OUT NOCOPY VARCHAR2)
728: IS

Line 778: CURSOR c_regime (cp_regime_id IN JAI_RGM_DEFINITIONS.regime_id%TYPE DEFAULT NULL,

774: AND a.shipment_line_id = b.shipment_line_id
775: AND a.shipment_header_id = NVL(cp_shipment_header_id,a.shipment_header_id)
776: AND a.shipment_line_id = NVL(cp_shipment_line_id, a.shipment_line_id);
777:
778: CURSOR c_regime (cp_regime_id IN JAI_RGM_DEFINITIONS.regime_id%TYPE DEFAULT NULL,
779: cp_regime_code IN JAI_RGM_DEFINITIONS.regime_code%TYPE DEFAULT NULL)
780: IS
781: SELECT *
782: FROM JAI_RGM_DEFINITIONS

Line 779: cp_regime_code IN JAI_RGM_DEFINITIONS.regime_code%TYPE DEFAULT NULL)

775: AND a.shipment_header_id = NVL(cp_shipment_header_id,a.shipment_header_id)
776: AND a.shipment_line_id = NVL(cp_shipment_line_id, a.shipment_line_id);
777:
778: CURSOR c_regime (cp_regime_id IN JAI_RGM_DEFINITIONS.regime_id%TYPE DEFAULT NULL,
779: cp_regime_code IN JAI_RGM_DEFINITIONS.regime_code%TYPE DEFAULT NULL)
780: IS
781: SELECT *
782: FROM JAI_RGM_DEFINITIONS
783: WHERE regime_id = NVL(cp_regime_id, regime_id)

Line 782: FROM JAI_RGM_DEFINITIONS

778: CURSOR c_regime (cp_regime_id IN JAI_RGM_DEFINITIONS.regime_id%TYPE DEFAULT NULL,
779: cp_regime_code IN JAI_RGM_DEFINITIONS.regime_code%TYPE DEFAULT NULL)
780: IS
781: SELECT *
782: FROM JAI_RGM_DEFINITIONS
783: WHERE regime_id = NVL(cp_regime_id, regime_id)
784: AND regime_code = NVL(cp_regime_code, regime_code);
785:
786: /* Bug 4929929. Added by Lakshmi Gopalsami

Line 1217: CURSOR c_regime (cp_regime_id IN JAI_RGM_DEFINITIONS.regime_id%TYPE DEFAULT NULL,

1213: from jai_regime_tax_types_v
1214: where regime_code = jai_constants.vat_regime)
1215: AND NVL(modvat_flag,'N') = 'Y';*/
1216:
1217: CURSOR c_regime (cp_regime_id IN JAI_RGM_DEFINITIONS.regime_id%TYPE DEFAULT NULL,
1218: cp_regime_code IN JAI_RGM_DEFINITIONS.regime_code%TYPE DEFAULT NULL)
1219: IS
1220: SELECT *
1221: FROM JAI_RGM_DEFINITIONS

Line 1218: cp_regime_code IN JAI_RGM_DEFINITIONS.regime_code%TYPE DEFAULT NULL)

1214: where regime_code = jai_constants.vat_regime)
1215: AND NVL(modvat_flag,'N') = 'Y';*/
1216:
1217: CURSOR c_regime (cp_regime_id IN JAI_RGM_DEFINITIONS.regime_id%TYPE DEFAULT NULL,
1218: cp_regime_code IN JAI_RGM_DEFINITIONS.regime_code%TYPE DEFAULT NULL)
1219: IS
1220: SELECT *
1221: FROM JAI_RGM_DEFINITIONS
1222: WHERE regime_id = NVL(cp_regime_id, regime_id)

Line 1221: FROM JAI_RGM_DEFINITIONS

1217: CURSOR c_regime (cp_regime_id IN JAI_RGM_DEFINITIONS.regime_id%TYPE DEFAULT NULL,
1218: cp_regime_code IN JAI_RGM_DEFINITIONS.regime_code%TYPE DEFAULT NULL)
1219: IS
1220: SELECT *
1221: FROM JAI_RGM_DEFINITIONS
1222: WHERE regime_id = NVL(cp_regime_id, regime_id)
1223: AND regime_code = NVL(cp_regime_code, regime_code);
1224:
1225: CURSOR c_vat_invoice(cp_transaction_id IN NUMBER)

Line 1815: p_regime_id IN JAI_RGM_DEFINITIONS.regime_id%TYPE,

1811:
1812: END process_vat;
1813:
1814: PROCEDURE process_claim(
1815: p_regime_id IN JAI_RGM_DEFINITIONS.regime_id%TYPE,
1816: p_regime_regno IN VARCHAR2 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,

Line 1853: JAI_RGM_DEFINITIONS c

1849: b.receipt_num,
1850: b.rcv_rgm_line_id
1851: FROM JAI_RGM_ORG_REGNS_V a,
1852: jai_rcv_rgm_txns_v b,
1853: JAI_RGM_DEFINITIONS c
1854: WHERE a.regime_code = c.regime_code
1855: AND c.regime_id = cp_regime_id
1856: AND a.attribute_value = NVL(cp_regime_regno, a.attribute_value)
1857: AND a.attribute_type_code = jai_constants.rgm_attr_type_code_primary --'PRIMARY'

Line 1873: CURSOR c_regime (cp_regime_id IN JAI_RGM_DEFINITIONS.regime_id%TYPE DEFAULT NULL,

1869: AND b.invoice_no IS NOT NULL
1870: AND b.process_status_flag NOT IN ('Z') /* 'Z' meaning the line is marked for UNCLAIM, but not yet processed*/
1871: AND NVL(b.installment_amount,0) <> 0;
1872:
1873: CURSOR c_regime (cp_regime_id IN JAI_RGM_DEFINITIONS.regime_id%TYPE DEFAULT NULL,
1874: cp_regime_code IN JAI_RGM_DEFINITIONS.regime_code%TYPE DEFAULT NULL)
1875: IS
1876: SELECT *
1877: FROM JAI_RGM_DEFINITIONS

Line 1874: cp_regime_code IN JAI_RGM_DEFINITIONS.regime_code%TYPE DEFAULT NULL)

1870: AND b.process_status_flag NOT IN ('Z') /* 'Z' meaning the line is marked for UNCLAIM, but not yet processed*/
1871: AND NVL(b.installment_amount,0) <> 0;
1872:
1873: CURSOR c_regime (cp_regime_id IN JAI_RGM_DEFINITIONS.regime_id%TYPE DEFAULT NULL,
1874: cp_regime_code IN JAI_RGM_DEFINITIONS.regime_code%TYPE DEFAULT NULL)
1875: IS
1876: SELECT *
1877: FROM JAI_RGM_DEFINITIONS
1878: WHERE regime_id = NVL(cp_regime_id, regime_id)

Line 1877: FROM JAI_RGM_DEFINITIONS

1873: CURSOR c_regime (cp_regime_id IN JAI_RGM_DEFINITIONS.regime_id%TYPE DEFAULT NULL,
1874: cp_regime_code IN JAI_RGM_DEFINITIONS.regime_code%TYPE DEFAULT NULL)
1875: IS
1876: SELECT *
1877: FROM JAI_RGM_DEFINITIONS
1878: WHERE regime_id = NVL(cp_regime_id, regime_id)
1879: AND regime_code = NVL(cp_regime_code, regime_code);
1880:
1881: CURSOR c_claim_schedule( cp_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE,

Line 2338: p_regime_id IN JAI_RGM_DEFINITIONS.regime_id%TYPE 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,
2337: p_process_message OUT NOCOPY VARCHAR2,
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)

Line 2376: JAI_RGM_DEFINITIONS c

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)
2380: AND a.attribute_type_code = jai_constants.rgm_attr_type_code_primary --'PRIMARY'

Line 2433: CURSOR c_regime (cp_regime_id IN JAI_RGM_DEFINITIONS.regime_id%TYPE DEFAULT NULL,

2429: WHERE shipment_header_id = cp_shipment_header_id
2430: AND shipment_line_id = cp_shipment_line_id
2431: AND transaction_type = 'RECEIVE';
2432:
2433: CURSOR c_regime (cp_regime_id IN JAI_RGM_DEFINITIONS.regime_id%TYPE DEFAULT NULL,
2434: cp_regime_code IN JAI_RGM_DEFINITIONS.regime_code%TYPE DEFAULT NULL)
2435: IS
2436: SELECT *
2437: FROM JAI_RGM_DEFINITIONS

Line 2434: cp_regime_code IN JAI_RGM_DEFINITIONS.regime_code%TYPE DEFAULT NULL)

2430: AND shipment_line_id = cp_shipment_line_id
2431: AND transaction_type = 'RECEIVE';
2432:
2433: CURSOR c_regime (cp_regime_id IN JAI_RGM_DEFINITIONS.regime_id%TYPE DEFAULT NULL,
2434: cp_regime_code IN JAI_RGM_DEFINITIONS.regime_code%TYPE DEFAULT NULL)
2435: IS
2436: SELECT *
2437: FROM JAI_RGM_DEFINITIONS
2438: WHERE regime_id = NVL(cp_regime_id, regime_id)

Line 2437: FROM JAI_RGM_DEFINITIONS

2433: CURSOR c_regime (cp_regime_id IN JAI_RGM_DEFINITIONS.regime_id%TYPE DEFAULT NULL,
2434: cp_regime_code IN JAI_RGM_DEFINITIONS.regime_code%TYPE DEFAULT NULL)
2435: IS
2436: SELECT *
2437: FROM JAI_RGM_DEFINITIONS
2438: WHERE regime_id = NVL(cp_regime_id, regime_id)
2439: AND regime_code = NVL(cp_regime_code, regime_code);
2440:
2441: CURSOR c_rcv_parameters(cp_organization_id number) IS

Line 2889: p_regime_id IN JAI_RGM_DEFINITIONS.regime_id%TYPE,

2885:
2886: PROCEDURE process_batch(
2887: errbuf OUT NOCOPY VARCHAR2,
2888: retcode OUT NOCOPY VARCHAR2,
2889: p_regime_id IN JAI_RGM_DEFINITIONS.regime_id%TYPE,
2890: p_regime_regno IN VARCHAR2 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,

Line 2913: CURSOR c_regime (cp_regime_id IN JAI_RGM_DEFINITIONS.regime_id%TYPE DEFAULT NULL,

2909:
2910: -- Date 29/05/2007 by sacsethi for bug 6078460
2911: -- Cursor where clause changed
2912:
2913: CURSOR c_regime (cp_regime_id IN JAI_RGM_DEFINITIONS.regime_id%TYPE DEFAULT NULL,
2914: cp_regime_code IN JAI_RGM_DEFINITIONS.regime_code%TYPE DEFAULT NULL)
2915: IS
2916: SELECT *
2917: FROM JAI_RGM_DEFINITIONS

Line 2914: cp_regime_code IN JAI_RGM_DEFINITIONS.regime_code%TYPE DEFAULT NULL)

2910: -- Date 29/05/2007 by sacsethi for bug 6078460
2911: -- Cursor where clause changed
2912:
2913: CURSOR c_regime (cp_regime_id IN JAI_RGM_DEFINITIONS.regime_id%TYPE DEFAULT NULL,
2914: cp_regime_code IN JAI_RGM_DEFINITIONS.regime_code%TYPE DEFAULT NULL)
2915: IS
2916: SELECT *
2917: FROM JAI_RGM_DEFINITIONS
2918: WHERE (regime_id is null OR ( cp_regime_id IS NULL OR regime_id = cp_regime_id )) /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/

Line 2917: FROM JAI_RGM_DEFINITIONS

2913: CURSOR c_regime (cp_regime_id IN JAI_RGM_DEFINITIONS.regime_id%TYPE DEFAULT NULL,
2914: cp_regime_code IN JAI_RGM_DEFINITIONS.regime_code%TYPE DEFAULT NULL)
2915: IS
2916: SELECT *
2917: FROM JAI_RGM_DEFINITIONS
2918: WHERE (regime_id is null OR ( cp_regime_id IS NULL OR regime_id = cp_regime_id )) /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
2919: AND (regime_code = cp_regime_code OR regime_code is null);
2920:
2921: --WHERE regime_id = NVL(cp_regime_id, regime_id)

Line 3053: CURSOR c_regime (cp_regime_id IN JAI_RGM_DEFINITIONS.regime_id%TYPE DEFAULT NULL,

3049:
3050: -- Date 29/05/2007 by sacsethi for bug 6078460
3051: -- Cursor where clause changed
3052:
3053: CURSOR c_regime (cp_regime_id IN JAI_RGM_DEFINITIONS.regime_id%TYPE DEFAULT NULL,
3054: cp_regime_code IN JAI_RGM_DEFINITIONS.regime_code%TYPE DEFAULT NULL)
3055: IS
3056: SELECT *
3057: FROM JAI_RGM_DEFINITIONS

Line 3054: cp_regime_code IN JAI_RGM_DEFINITIONS.regime_code%TYPE DEFAULT NULL)

3050: -- Date 29/05/2007 by sacsethi for bug 6078460
3051: -- Cursor where clause changed
3052:
3053: CURSOR c_regime (cp_regime_id IN JAI_RGM_DEFINITIONS.regime_id%TYPE DEFAULT NULL,
3054: cp_regime_code IN JAI_RGM_DEFINITIONS.regime_code%TYPE DEFAULT NULL)
3055: IS
3056: SELECT *
3057: FROM JAI_RGM_DEFINITIONS
3058: WHERE (regime_id is null OR ( cp_regime_id IS NULL OR regime_id = cp_regime_id )) /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/

Line 3057: FROM JAI_RGM_DEFINITIONS

3053: CURSOR c_regime (cp_regime_id IN JAI_RGM_DEFINITIONS.regime_id%TYPE DEFAULT NULL,
3054: cp_regime_code IN JAI_RGM_DEFINITIONS.regime_code%TYPE DEFAULT NULL)
3055: IS
3056: SELECT *
3057: FROM JAI_RGM_DEFINITIONS
3058: WHERE (regime_id is null OR ( cp_regime_id IS NULL OR regime_id = cp_regime_id )) /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
3059: AND (regime_code = cp_regime_code OR regime_code is null);
3060:
3061: --WHERE regime_id = NVL(cp_regime_id, regime_id)

Line 3536: CURSOR c_regime (cp_regime_id IN JAI_RGM_DEFINITIONS.regime_id%TYPE DEFAULT NULL,

3532:
3533: -- Date 29/05/2007 by sacsethi for bug 6078460
3534: -- Cursor where clause changed
3535:
3536: CURSOR c_regime (cp_regime_id IN JAI_RGM_DEFINITIONS.regime_id%TYPE DEFAULT NULL,
3537: cp_regime_code IN JAI_RGM_DEFINITIONS.regime_code%TYPE DEFAULT NULL)
3538: IS
3539: SELECT *
3540: FROM JAI_RGM_DEFINITIONS

Line 3537: cp_regime_code IN JAI_RGM_DEFINITIONS.regime_code%TYPE DEFAULT NULL)

3533: -- Date 29/05/2007 by sacsethi for bug 6078460
3534: -- Cursor where clause changed
3535:
3536: CURSOR c_regime (cp_regime_id IN JAI_RGM_DEFINITIONS.regime_id%TYPE DEFAULT NULL,
3537: cp_regime_code IN JAI_RGM_DEFINITIONS.regime_code%TYPE DEFAULT NULL)
3538: IS
3539: SELECT *
3540: FROM JAI_RGM_DEFINITIONS
3541: WHERE (regime_id is null OR ( cp_regime_id IS NULL OR regime_id = cp_regime_id )) /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/

Line 3540: FROM JAI_RGM_DEFINITIONS

3536: CURSOR c_regime (cp_regime_id IN JAI_RGM_DEFINITIONS.regime_id%TYPE DEFAULT NULL,
3537: cp_regime_code IN JAI_RGM_DEFINITIONS.regime_code%TYPE DEFAULT NULL)
3538: IS
3539: SELECT *
3540: FROM JAI_RGM_DEFINITIONS
3541: WHERE (regime_id is null OR ( cp_regime_id IS NULL OR regime_id = cp_regime_id )) /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
3542: AND (regime_code = cp_regime_code OR regime_code is null);
3543:
3544: --WHERE regime_id = NVL(cp_regime_id, regime_id)