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_CUSTOMER_SPEC_VRS

Line 2721: l_cust_spec_vrs gmd_customer_spec_vrs%ROWTYPE;

2717: , x_return_status OUT NOCOPY VARCHAR2
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);

Line 2895: l_cust_spec_vrs_in gmd_customer_spec_vrs%ROWTYPE;

2891: , p_spec_type IN VARCHAR2
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;

Line 2899: l_cust_spec_vrs_out gmd_customer_spec_vrs%ROWTYPE;

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;
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);

Line 2921: FROM gmd_customer_spec_vrs

2917:
2918: IF l_spec_type = 'C' THEN
2919: SELECT *
2920: INTO l_cust_spec_vrs_in
2921: FROM gmd_customer_spec_vrs
2922: WHERE spec_vr_id = l_spec_vr_id;
2923:
2924: l_cust_spec_vrs_in.spec_id := p_to_spec_id;
2925:

Line 2932: l_return := gmd_customer_spec_vrs_pvt.insert_row

2928: END IF;
2929:
2930: l_cust_spec_vrs_in.spec_vr_id := NULL;
2931: default_log (' Copy From Cusotmer Validity Rule: ' || l_spec_vr_id);
2932: l_return := gmd_customer_spec_vrs_pvt.insert_row
2933: ( p_customer_spec_vrs => l_cust_spec_vrs_in
2934: , x_customer_spec_vrs => l_cust_spec_vrs_out );
2935:
2936: default_log (' Created New Cusotmer Validity Rule: ' || l_cust_spec_vrs_out.spec_vr_id);

Line 3012: l_cust_spec_vrs gmd_customer_spec_vrs%ROWTYPE;

3008: p_vr_id IN NUMBER
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);

Line 3028: UPDATE gmd_customer_spec_vrs

3024: l_spec_vr_id := p_vr_id;
3025: DEBUG ('in End_old_validity_rule, spec_Type ' || l_spec_type);
3026:
3027: IF l_spec_type = 'C' THEN
3028: UPDATE gmd_customer_spec_vrs
3029: SET end_date = SYSDATE
3030: WHERE spec_vr_id = l_spec_vr_id;
3031:
3032: default_log (' End Customer Validity Rule: ' || l_spec_vr_id);

Line 3066: l_cust_spec_vrs gmd_customer_spec_vrs%ROWTYPE;

3062: p_vr_id IN NUMBER
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);

Line 3082: UPDATE gmd_customer_spec_vrs

3078: l_spec_vr_id := p_vr_id;
3079: DEBUG ('in Obsolete_old_validity_rule, spec_Type ' || l_spec_type);
3080:
3081: IF l_spec_type = 'C' THEN
3082: UPDATE gmd_customer_spec_vrs
3083: SET spec_vr_status = 1000
3084: WHERE spec_vr_id = l_spec_vr_id;
3085:
3086: default_log (' Obsolete Customer Validity Rule: ' || l_spec_vr_id);

Line 3123: l_cust_spec_vrs gmd_customer_spec_vrs%ROWTYPE;

3119: , p_start_date IN DATE
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);

Line 3166: UPDATE gmd_customer_spec_vrs

3162: END IF;
3163:
3164: IF l_spec_type = 'C' THEN
3165: IF p_new_status IS NOT NULL THEN
3166: UPDATE gmd_customer_spec_vrs
3167: SET spec_vr_status = p_new_status
3168: WHERE spec_vr_id = l_spec_vr_id;
3169: ELSIF p_start_date IS NOT NULL THEN
3170: UPDATE gmd_customer_spec_vrs

Line 3170: UPDATE gmd_customer_spec_vrs

3166: UPDATE gmd_customer_spec_vrs
3167: SET spec_vr_status = p_new_status
3168: WHERE spec_vr_id = l_spec_vr_id;
3169: ELSIF p_start_date IS NOT NULL THEN
3170: UPDATE gmd_customer_spec_vrs
3171: SET start_date = p_start_date
3172: WHERE spec_vr_id = l_spec_vr_id;
3173: ELSIF p_end_date IS NOT NULL THEN
3174: UPDATE gmd_customer_spec_vrs

Line 3174: UPDATE gmd_customer_spec_vrs

3170: UPDATE gmd_customer_spec_vrs
3171: SET start_date = p_start_date
3172: WHERE spec_vr_id = l_spec_vr_id;
3173: ELSIF p_end_date IS NOT NULL THEN
3174: UPDATE gmd_customer_spec_vrs
3175: SET end_date = p_end_date
3176: WHERE spec_vr_id = l_spec_vr_id;
3177: END IF;
3178: