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 2833: l_cust_spec_vrs gmd_customer_spec_vrs%ROWTYPE;

2829: , x_return_status OUT NOCOPY VARCHAR2
2830: ) IS
2831: l_old_spec_rec gmd_specifications_b%ROWTYPE;
2832: l_new_spec_rec gmd_specifications_b%ROWTYPE;
2833: l_cust_spec_vrs gmd_customer_spec_vrs%ROWTYPE;
2834: l_inv_spec_vrs gmd_inventory_spec_vrs%ROWTYPE;
2835: l_wip_spec_vrs gmd_wip_spec_vrs%ROWTYPE;
2836: l_supplier_spec_vrs gmd_supplier_spec_vrs%ROWTYPE;
2837: l_row_id VARCHAR2 (200);

Line 3007: l_cust_spec_vrs_in gmd_customer_spec_vrs%ROWTYPE;

3003: , p_spec_type IN VARCHAR2
3004: , p_create_mode IN VARCHAR2
3005: , x_return_status OUT NOCOPY VARCHAR2
3006: ) IS
3007: l_cust_spec_vrs_in gmd_customer_spec_vrs%ROWTYPE;
3008: l_inv_spec_vrs_in gmd_inventory_spec_vrs%ROWTYPE;
3009: l_wip_spec_vrs_in gmd_wip_spec_vrs%ROWTYPE;
3010: l_supplier_spec_vrs_in gmd_supplier_spec_vrs%ROWTYPE;
3011: l_cust_spec_vrs_out gmd_customer_spec_vrs%ROWTYPE;

Line 3011: l_cust_spec_vrs_out gmd_customer_spec_vrs%ROWTYPE;

3007: l_cust_spec_vrs_in gmd_customer_spec_vrs%ROWTYPE;
3008: l_inv_spec_vrs_in gmd_inventory_spec_vrs%ROWTYPE;
3009: l_wip_spec_vrs_in gmd_wip_spec_vrs%ROWTYPE;
3010: l_supplier_spec_vrs_in gmd_supplier_spec_vrs%ROWTYPE;
3011: l_cust_spec_vrs_out gmd_customer_spec_vrs%ROWTYPE;
3012: l_inv_spec_vrs_out gmd_inventory_spec_vrs%ROWTYPE;
3013: l_wip_spec_vrs_out gmd_wip_spec_vrs%ROWTYPE;
3014: l_supplier_spec_vrs_out gmd_supplier_spec_vrs%ROWTYPE;
3015: l_row_id VARCHAR2 (200);

Line 3033: FROM gmd_customer_spec_vrs

3029:
3030: IF l_spec_type = 'C' THEN
3031: SELECT *
3032: INTO l_cust_spec_vrs_in
3033: FROM gmd_customer_spec_vrs
3034: WHERE spec_vr_id = l_spec_vr_id;
3035:
3036: l_cust_spec_vrs_in.spec_id := p_to_spec_id;
3037:

Line 3044: l_return := gmd_customer_spec_vrs_pvt.insert_row

3040: END IF;
3041:
3042: l_cust_spec_vrs_in.spec_vr_id := NULL;
3043: default_log (' Copy From Cusotmer Validity Rule: ' || l_spec_vr_id);
3044: l_return := gmd_customer_spec_vrs_pvt.insert_row
3045: ( p_customer_spec_vrs => l_cust_spec_vrs_in
3046: , x_customer_spec_vrs => l_cust_spec_vrs_out );
3047:
3048: default_log (' Created New Cusotmer Validity Rule: ' || l_cust_spec_vrs_out.spec_vr_id);

Line 3124: l_cust_spec_vrs gmd_customer_spec_vrs%ROWTYPE;

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

Line 3140: UPDATE gmd_customer_spec_vrs

3136: l_spec_vr_id := p_vr_id;
3137: DEBUG ('in End_old_validity_rule, spec_Type ' || l_spec_type);
3138:
3139: IF l_spec_type = 'C' THEN
3140: UPDATE gmd_customer_spec_vrs
3141: SET end_date = SYSDATE
3142: WHERE spec_vr_id = l_spec_vr_id;
3143:
3144: default_log (' End Customer Validity Rule: ' || l_spec_vr_id);

Line 3178: l_cust_spec_vrs gmd_customer_spec_vrs%ROWTYPE;

3174: p_vr_id IN NUMBER
3175: , p_spec_type IN VARCHAR2
3176: , x_return_status OUT NOCOPY VARCHAR2
3177: ) IS
3178: l_cust_spec_vrs gmd_customer_spec_vrs%ROWTYPE;
3179: l_inv_spec_vrs gmd_inventory_spec_vrs%ROWTYPE;
3180: l_wip_spec_vrs gmd_wip_spec_vrs%ROWTYPE;
3181: l_supplier_spec_vrs gmd_supplier_spec_vrs%ROWTYPE;
3182: l_row_id VARCHAR2 (200);

Line 3194: UPDATE gmd_customer_spec_vrs

3190: l_spec_vr_id := p_vr_id;
3191: DEBUG ('in Obsolete_old_validity_rule, spec_Type ' || l_spec_type);
3192:
3193: IF l_spec_type = 'C' THEN
3194: UPDATE gmd_customer_spec_vrs
3195: SET spec_vr_status = 1000
3196: WHERE spec_vr_id = l_spec_vr_id;
3197:
3198: default_log (' Obsolete Customer Validity Rule: ' || l_spec_vr_id);

Line 3235: l_cust_spec_vrs gmd_customer_spec_vrs%ROWTYPE;

3231: , p_start_date IN DATE
3232: , p_new_status IN NUMBER
3233: , x_return_status OUT NOCOPY VARCHAR2
3234: ) IS
3235: l_cust_spec_vrs gmd_customer_spec_vrs%ROWTYPE;
3236: l_inv_spec_vrs gmd_inventory_spec_vrs%ROWTYPE;
3237: l_wip_spec_vrs gmd_wip_spec_vrs%ROWTYPE;
3238: l_supplier_spec_vrs gmd_supplier_spec_vrs%ROWTYPE;
3239: l_row_id VARCHAR2 (200);

Line 3283: UPDATE gmd_customer_spec_vrs

3279: END IF;
3280:
3281: IF l_spec_type = 'C' THEN
3282: IF p_new_status IS NOT NULL THEN
3283: UPDATE gmd_customer_spec_vrs
3284: SET spec_vr_status = p_new_status
3285: WHERE spec_vr_id = l_spec_vr_id;
3286: ELSIF p_start_date IS NOT NULL THEN
3287: UPDATE gmd_customer_spec_vrs

Line 3287: UPDATE gmd_customer_spec_vrs

3283: UPDATE gmd_customer_spec_vrs
3284: SET spec_vr_status = p_new_status
3285: WHERE spec_vr_id = l_spec_vr_id;
3286: ELSIF p_start_date IS NOT NULL THEN
3287: UPDATE gmd_customer_spec_vrs
3288: SET start_date = p_start_date
3289: WHERE spec_vr_id = l_spec_vr_id;
3290: ELSIF p_end_date IS NOT NULL THEN
3291: UPDATE gmd_customer_spec_vrs

Line 3291: UPDATE gmd_customer_spec_vrs

3287: UPDATE gmd_customer_spec_vrs
3288: SET start_date = p_start_date
3289: WHERE spec_vr_id = l_spec_vr_id;
3290: ELSIF p_end_date IS NOT NULL THEN
3291: UPDATE gmd_customer_spec_vrs
3292: SET end_date = p_end_date
3293: WHERE spec_vr_id = l_spec_vr_id;
3294: END IF;
3295: