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 654: p_regime_code IN JAI_RGM_DEFINITIONS.regime_code%TYPE,

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,
657: p_process_message OUT NOCOPY VARCHAR2)
658: IS

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

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);
707:
708: CURSOR c_regime (cp_regime_id IN JAI_RGM_DEFINITIONS.regime_id%TYPE DEFAULT NULL,
709: cp_regime_code IN JAI_RGM_DEFINITIONS.regime_code%TYPE DEFAULT NULL)
710: IS
711: SELECT *
712: FROM JAI_RGM_DEFINITIONS

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

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);
707:
708: CURSOR c_regime (cp_regime_id IN JAI_RGM_DEFINITIONS.regime_id%TYPE DEFAULT NULL,
709: cp_regime_code IN JAI_RGM_DEFINITIONS.regime_code%TYPE DEFAULT NULL)
710: IS
711: SELECT *
712: FROM JAI_RGM_DEFINITIONS
713: WHERE regime_id = NVL(cp_regime_id, regime_id)

Line 712: FROM JAI_RGM_DEFINITIONS

708: CURSOR c_regime (cp_regime_id IN JAI_RGM_DEFINITIONS.regime_id%TYPE DEFAULT NULL,
709: cp_regime_code IN JAI_RGM_DEFINITIONS.regime_code%TYPE DEFAULT NULL)
710: IS
711: SELECT *
712: FROM JAI_RGM_DEFINITIONS
713: WHERE regime_id = NVL(cp_regime_id, regime_id)
714: AND regime_code = NVL(cp_regime_code, regime_code);
715:
716: /* Bug 4929929. Added by Lakshmi Gopalsami

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

1142: from jai_regime_tax_types_v
1143: where regime_code = jai_constants.vat_regime)
1144: AND NVL(modvat_flag,'N') = 'Y';*/
1145:
1146: CURSOR c_regime (cp_regime_id IN JAI_RGM_DEFINITIONS.regime_id%TYPE DEFAULT NULL,
1147: cp_regime_code IN JAI_RGM_DEFINITIONS.regime_code%TYPE DEFAULT NULL)
1148: IS
1149: SELECT *
1150: FROM JAI_RGM_DEFINITIONS

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

1143: where regime_code = jai_constants.vat_regime)
1144: AND NVL(modvat_flag,'N') = 'Y';*/
1145:
1146: CURSOR c_regime (cp_regime_id IN JAI_RGM_DEFINITIONS.regime_id%TYPE DEFAULT NULL,
1147: cp_regime_code IN JAI_RGM_DEFINITIONS.regime_code%TYPE DEFAULT NULL)
1148: IS
1149: SELECT *
1150: FROM JAI_RGM_DEFINITIONS
1151: WHERE regime_id = NVL(cp_regime_id, regime_id)

Line 1150: FROM JAI_RGM_DEFINITIONS

1146: CURSOR c_regime (cp_regime_id IN JAI_RGM_DEFINITIONS.regime_id%TYPE DEFAULT NULL,
1147: cp_regime_code IN JAI_RGM_DEFINITIONS.regime_code%TYPE DEFAULT NULL)
1148: IS
1149: SELECT *
1150: FROM JAI_RGM_DEFINITIONS
1151: WHERE regime_id = NVL(cp_regime_id, regime_id)
1152: AND regime_code = NVL(cp_regime_code, regime_code);
1153:
1154: CURSOR c_vat_invoice(cp_transaction_id IN NUMBER)

Line 1744: p_regime_id IN JAI_RGM_DEFINITIONS.regime_id%TYPE,

1740:
1741: END process_vat;
1742:
1743: PROCEDURE process_claim(
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,

Line 1782: JAI_RGM_DEFINITIONS c

1778: b.receipt_num,
1779: b.rcv_rgm_line_id
1780: FROM JAI_RGM_ORG_REGNS_V a,
1781: jai_rcv_rgm_txns_v b,
1782: JAI_RGM_DEFINITIONS c
1783: WHERE a.regime_code = c.regime_code
1784: AND c.regime_id = cp_regime_id
1785: AND a.attribute_value = NVL(cp_regime_regno, a.attribute_value)
1786: AND a.attribute_type_code = jai_constants.rgm_attr_type_code_primary --'PRIMARY'

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

1798: AND b.invoice_no IS NOT NULL
1799: AND b.process_status_flag NOT IN ('Z') /* 'Z' meaning the line is marked for UNCLAIM, but not yet processed*/
1800: AND NVL(b.installment_amount,0) <> 0;
1801:
1802: CURSOR c_regime (cp_regime_id IN JAI_RGM_DEFINITIONS.regime_id%TYPE DEFAULT NULL,
1803: cp_regime_code IN JAI_RGM_DEFINITIONS.regime_code%TYPE DEFAULT NULL)
1804: IS
1805: SELECT *
1806: FROM JAI_RGM_DEFINITIONS

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

1799: AND b.process_status_flag NOT IN ('Z') /* 'Z' meaning the line is marked for UNCLAIM, but not yet processed*/
1800: AND NVL(b.installment_amount,0) <> 0;
1801:
1802: CURSOR c_regime (cp_regime_id IN JAI_RGM_DEFINITIONS.regime_id%TYPE DEFAULT NULL,
1803: cp_regime_code IN JAI_RGM_DEFINITIONS.regime_code%TYPE DEFAULT NULL)
1804: IS
1805: SELECT *
1806: FROM JAI_RGM_DEFINITIONS
1807: WHERE regime_id = NVL(cp_regime_id, regime_id)

Line 1806: FROM JAI_RGM_DEFINITIONS

1802: CURSOR c_regime (cp_regime_id IN JAI_RGM_DEFINITIONS.regime_id%TYPE DEFAULT NULL,
1803: cp_regime_code IN JAI_RGM_DEFINITIONS.regime_code%TYPE DEFAULT NULL)
1804: IS
1805: SELECT *
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,

Line 2258: p_regime_id IN JAI_RGM_DEFINITIONS.regime_id%TYPE 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,
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)

Line 2296: JAI_RGM_DEFINITIONS c

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

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

2349: WHERE shipment_header_id = cp_shipment_header_id
2350: AND shipment_line_id = cp_shipment_line_id
2351: AND transaction_type = 'RECEIVE';
2352:
2353: CURSOR c_regime (cp_regime_id IN JAI_RGM_DEFINITIONS.regime_id%TYPE DEFAULT NULL,
2354: cp_regime_code IN JAI_RGM_DEFINITIONS.regime_code%TYPE DEFAULT NULL)
2355: IS
2356: SELECT *
2357: FROM JAI_RGM_DEFINITIONS

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

2350: AND shipment_line_id = cp_shipment_line_id
2351: AND transaction_type = 'RECEIVE';
2352:
2353: CURSOR c_regime (cp_regime_id IN JAI_RGM_DEFINITIONS.regime_id%TYPE DEFAULT NULL,
2354: cp_regime_code IN JAI_RGM_DEFINITIONS.regime_code%TYPE DEFAULT NULL)
2355: IS
2356: SELECT *
2357: FROM JAI_RGM_DEFINITIONS
2358: WHERE regime_id = NVL(cp_regime_id, regime_id)

Line 2357: FROM JAI_RGM_DEFINITIONS

2353: CURSOR c_regime (cp_regime_id IN JAI_RGM_DEFINITIONS.regime_id%TYPE DEFAULT NULL,
2354: cp_regime_code IN JAI_RGM_DEFINITIONS.regime_code%TYPE DEFAULT NULL)
2355: IS
2356: SELECT *
2357: FROM JAI_RGM_DEFINITIONS
2358: WHERE regime_id = NVL(cp_regime_id, regime_id)
2359: AND regime_code = NVL(cp_regime_code, regime_code);
2360:
2361: CURSOR c_rcv_parameters(cp_organization_id number) IS

Line 2676: p_regime_id IN JAI_RGM_DEFINITIONS.regime_id%TYPE,

2672:
2673: PROCEDURE process_batch(
2674: errbuf OUT NOCOPY VARCHAR2,
2675: retcode OUT NOCOPY VARCHAR2,
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,

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

2696:
2697: -- Date 29/05/2007 by sacsethi for bug 6078460
2698: -- Cursor where clause changed
2699:
2700: CURSOR c_regime (cp_regime_id IN JAI_RGM_DEFINITIONS.regime_id%TYPE DEFAULT NULL,
2701: cp_regime_code IN JAI_RGM_DEFINITIONS.regime_code%TYPE DEFAULT NULL)
2702: IS
2703: SELECT *
2704: FROM JAI_RGM_DEFINITIONS

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

2697: -- Date 29/05/2007 by sacsethi for bug 6078460
2698: -- Cursor where clause changed
2699:
2700: CURSOR c_regime (cp_regime_id IN JAI_RGM_DEFINITIONS.regime_id%TYPE DEFAULT NULL,
2701: cp_regime_code IN JAI_RGM_DEFINITIONS.regime_code%TYPE DEFAULT NULL)
2702: IS
2703: SELECT *
2704: FROM JAI_RGM_DEFINITIONS
2705: 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 2704: FROM JAI_RGM_DEFINITIONS

2700: CURSOR c_regime (cp_regime_id IN JAI_RGM_DEFINITIONS.regime_id%TYPE DEFAULT NULL,
2701: cp_regime_code IN JAI_RGM_DEFINITIONS.regime_code%TYPE DEFAULT NULL)
2702: IS
2703: SELECT *
2704: FROM JAI_RGM_DEFINITIONS
2705: 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*/
2706: AND (regime_code = cp_regime_code OR regime_code is null);
2707:
2708: --WHERE regime_id = NVL(cp_regime_id, regime_id)

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

2836:
2837: -- Date 29/05/2007 by sacsethi for bug 6078460
2838: -- Cursor where clause changed
2839:
2840: CURSOR c_regime (cp_regime_id IN JAI_RGM_DEFINITIONS.regime_id%TYPE DEFAULT NULL,
2841: cp_regime_code IN JAI_RGM_DEFINITIONS.regime_code%TYPE DEFAULT NULL)
2842: IS
2843: SELECT *
2844: FROM JAI_RGM_DEFINITIONS

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

2837: -- Date 29/05/2007 by sacsethi for bug 6078460
2838: -- Cursor where clause changed
2839:
2840: CURSOR c_regime (cp_regime_id IN JAI_RGM_DEFINITIONS.regime_id%TYPE DEFAULT NULL,
2841: cp_regime_code IN JAI_RGM_DEFINITIONS.regime_code%TYPE DEFAULT NULL)
2842: IS
2843: SELECT *
2844: FROM JAI_RGM_DEFINITIONS
2845: 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 2844: FROM JAI_RGM_DEFINITIONS

2840: CURSOR c_regime (cp_regime_id IN JAI_RGM_DEFINITIONS.regime_id%TYPE DEFAULT NULL,
2841: cp_regime_code IN JAI_RGM_DEFINITIONS.regime_code%TYPE DEFAULT NULL)
2842: IS
2843: SELECT *
2844: FROM JAI_RGM_DEFINITIONS
2845: 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*/
2846: AND (regime_code = cp_regime_code OR regime_code is null);
2847:
2848: --WHERE regime_id = NVL(cp_regime_id, regime_id)

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

3285:
3286: -- Date 29/05/2007 by sacsethi for bug 6078460
3287: -- Cursor where clause changed
3288:
3289: CURSOR c_regime (cp_regime_id IN JAI_RGM_DEFINITIONS.regime_id%TYPE DEFAULT NULL,
3290: cp_regime_code IN JAI_RGM_DEFINITIONS.regime_code%TYPE DEFAULT NULL)
3291: IS
3292: SELECT *
3293: FROM JAI_RGM_DEFINITIONS

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

3286: -- Date 29/05/2007 by sacsethi for bug 6078460
3287: -- Cursor where clause changed
3288:
3289: CURSOR c_regime (cp_regime_id IN JAI_RGM_DEFINITIONS.regime_id%TYPE DEFAULT NULL,
3290: cp_regime_code IN JAI_RGM_DEFINITIONS.regime_code%TYPE DEFAULT NULL)
3291: IS
3292: SELECT *
3293: FROM JAI_RGM_DEFINITIONS
3294: 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 3293: FROM JAI_RGM_DEFINITIONS

3289: CURSOR c_regime (cp_regime_id IN JAI_RGM_DEFINITIONS.regime_id%TYPE DEFAULT NULL,
3290: cp_regime_code IN JAI_RGM_DEFINITIONS.regime_code%TYPE DEFAULT NULL)
3291: IS
3292: SELECT *
3293: FROM JAI_RGM_DEFINITIONS
3294: 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*/
3295: AND (regime_code = cp_regime_code OR regime_code is null);
3296:
3297: --WHERE regime_id = NVL(cp_regime_id, regime_id)