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.GMD_QM_CONC_REPLACE_PKG dependencies on GMD_INVENTORY_SPEC_VRS

Line 2722: l_inv_spec_vrs gmd_inventory_spec_vrs%ROWTYPE;

2718: ) IS
2719: l_old_spec_rec gmd_specifications_b%ROWTYPE;
2720: l_new_spec_rec gmd_specifications_b%ROWTYPE;
2721: l_cust_spec_vrs gmd_customer_spec_vrs%ROWTYPE;
2722: l_inv_spec_vrs gmd_inventory_spec_vrs%ROWTYPE;
2723: l_wip_spec_vrs gmd_wip_spec_vrs%ROWTYPE;
2724: l_supplier_spec_vrs gmd_supplier_spec_vrs%ROWTYPE;
2725: l_row_id VARCHAR2 (200);
2726: l_vr_id NUMBER;

Line 2896: l_inv_spec_vrs_in gmd_inventory_spec_vrs%ROWTYPE;

2892: , p_create_mode IN VARCHAR2
2893: , x_return_status OUT NOCOPY VARCHAR2
2894: ) IS
2895: l_cust_spec_vrs_in gmd_customer_spec_vrs%ROWTYPE;
2896: l_inv_spec_vrs_in gmd_inventory_spec_vrs%ROWTYPE;
2897: l_wip_spec_vrs_in gmd_wip_spec_vrs%ROWTYPE;
2898: l_supplier_spec_vrs_in gmd_supplier_spec_vrs%ROWTYPE;
2899: l_cust_spec_vrs_out gmd_customer_spec_vrs%ROWTYPE;
2900: l_inv_spec_vrs_out gmd_inventory_spec_vrs%ROWTYPE;

Line 2900: l_inv_spec_vrs_out gmd_inventory_spec_vrs%ROWTYPE;

2896: l_inv_spec_vrs_in gmd_inventory_spec_vrs%ROWTYPE;
2897: l_wip_spec_vrs_in gmd_wip_spec_vrs%ROWTYPE;
2898: l_supplier_spec_vrs_in gmd_supplier_spec_vrs%ROWTYPE;
2899: l_cust_spec_vrs_out gmd_customer_spec_vrs%ROWTYPE;
2900: l_inv_spec_vrs_out gmd_inventory_spec_vrs%ROWTYPE;
2901: l_wip_spec_vrs_out gmd_wip_spec_vrs%ROWTYPE;
2902: l_supplier_spec_vrs_out gmd_supplier_spec_vrs%ROWTYPE;
2903: l_row_id VARCHAR2 (200);
2904: l_spec_vr_id NUMBER;

Line 2940: FROM gmd_inventory_spec_vrs

2936: default_log (' Created New Cusotmer Validity Rule: ' || l_cust_spec_vrs_out.spec_vr_id);
2937: ELSIF l_spec_type = 'I' THEN
2938: SELECT *
2939: INTO l_inv_spec_vrs_in
2940: FROM gmd_inventory_spec_vrs
2941: WHERE spec_vr_id = l_spec_vr_id;
2942:
2943: l_inv_spec_vrs_in.spec_id := p_to_spec_id;
2944: DEBUG ('l_inv_spec_vrs.spec_id: ' || l_inv_spec_vrs_in.spec_id);

Line 2953: l_return := gmd_inventory_spec_vrs_pvt.insert_row

2949:
2950: l_inv_spec_vrs_in.spec_vr_id := NULL;
2951: DEBUG ('l_inv_spec_vrs.spec_vr_status: ' || l_inv_spec_vrs_in.spec_vr_status);
2952: default_log (' Copy From Inventory Validity Rule: ' || l_spec_vr_id);
2953: l_return := gmd_inventory_spec_vrs_pvt.insert_row
2954: ( p_inventory_spec_vrs => l_inv_spec_vrs_in
2955: , x_inventory_spec_vrs => l_inv_spec_vrs_out );
2956:
2957: --debug('call insert row for inventory validity rule, l_return '|| to_char(l_return));

Line 3013: l_inv_spec_vrs gmd_inventory_spec_vrs%ROWTYPE;

3009: , p_spec_type IN VARCHAR2
3010: , x_return_status OUT NOCOPY VARCHAR2
3011: ) IS
3012: l_cust_spec_vrs gmd_customer_spec_vrs%ROWTYPE;
3013: l_inv_spec_vrs gmd_inventory_spec_vrs%ROWTYPE;
3014: l_wip_spec_vrs gmd_wip_spec_vrs%ROWTYPE;
3015: l_supplier_spec_vrs gmd_supplier_spec_vrs%ROWTYPE;
3016: l_row_id VARCHAR2 (200);
3017: l_spec_vr_id NUMBER;

Line 3034: UPDATE gmd_inventory_spec_vrs

3030: WHERE spec_vr_id = l_spec_vr_id;
3031:
3032: default_log (' End Customer Validity Rule: ' || l_spec_vr_id);
3033: ELSIF l_spec_type = 'I' THEN
3034: UPDATE gmd_inventory_spec_vrs
3035: SET end_date = SYSDATE
3036: WHERE spec_vr_id = l_spec_vr_id;
3037:
3038: default_log (' End Inventory Validity Rule: ' || l_spec_vr_id);

Line 3067: l_inv_spec_vrs gmd_inventory_spec_vrs%ROWTYPE;

3063: , p_spec_type IN VARCHAR2
3064: , x_return_status OUT NOCOPY VARCHAR2
3065: ) IS
3066: l_cust_spec_vrs gmd_customer_spec_vrs%ROWTYPE;
3067: l_inv_spec_vrs gmd_inventory_spec_vrs%ROWTYPE;
3068: l_wip_spec_vrs gmd_wip_spec_vrs%ROWTYPE;
3069: l_supplier_spec_vrs gmd_supplier_spec_vrs%ROWTYPE;
3070: l_row_id VARCHAR2 (200);
3071: l_spec_vr_id NUMBER;

Line 3088: UPDATE gmd_inventory_spec_vrs

3084: WHERE spec_vr_id = l_spec_vr_id;
3085:
3086: default_log (' Obsolete Customer Validity Rule: ' || l_spec_vr_id);
3087: ELSIF l_spec_type = 'I' THEN
3088: UPDATE gmd_inventory_spec_vrs
3089: SET spec_vr_status = 1000
3090: WHERE spec_vr_id = l_spec_vr_id;
3091:
3092: default_log (' Obsolete Inventory Validity Rule: ' || l_spec_vr_id);

Line 3124: l_inv_spec_vrs gmd_inventory_spec_vrs%ROWTYPE;

3120: , p_new_status IN NUMBER
3121: , x_return_status OUT NOCOPY VARCHAR2
3122: ) IS
3123: l_cust_spec_vrs gmd_customer_spec_vrs%ROWTYPE;
3124: l_inv_spec_vrs gmd_inventory_spec_vrs%ROWTYPE;
3125: l_wip_spec_vrs gmd_wip_spec_vrs%ROWTYPE;
3126: l_supplier_spec_vrs gmd_supplier_spec_vrs%ROWTYPE;
3127: l_row_id VARCHAR2 (200);
3128: l_spec_vr_id NUMBER;

Line 3182: UPDATE gmd_inventory_spec_vrs

3178:
3179: default_log (' Updated Customer Validity Rule: ' || l_spec_vr_id);
3180: ELSIF l_spec_type = 'I' THEN
3181: IF p_new_status IS NOT NULL THEN
3182: UPDATE gmd_inventory_spec_vrs
3183: SET spec_vr_status = p_new_status
3184: WHERE spec_vr_id = l_spec_vr_id;
3185: ELSIF p_start_date IS NOT NULL THEN
3186: UPDATE gmd_inventory_spec_vrs

Line 3186: UPDATE gmd_inventory_spec_vrs

3182: UPDATE gmd_inventory_spec_vrs
3183: SET spec_vr_status = p_new_status
3184: WHERE spec_vr_id = l_spec_vr_id;
3185: ELSIF p_start_date IS NOT NULL THEN
3186: UPDATE gmd_inventory_spec_vrs
3187: SET start_date = p_start_date
3188: WHERE spec_vr_id = l_spec_vr_id;
3189: ELSIF p_end_date IS NOT NULL THEN
3190: UPDATE gmd_inventory_spec_vrs

Line 3190: UPDATE gmd_inventory_spec_vrs

3186: UPDATE gmd_inventory_spec_vrs
3187: SET start_date = p_start_date
3188: WHERE spec_vr_id = l_spec_vr_id;
3189: ELSIF p_end_date IS NOT NULL THEN
3190: UPDATE gmd_inventory_spec_vrs
3191: SET end_date = p_end_date
3192: WHERE spec_vr_id = l_spec_vr_id;
3193: END IF;
3194: