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_SUPPLIER_SPEC_VRS

Line 2836: l_supplier_spec_vrs gmd_supplier_spec_vrs%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);
2838: l_vr_id NUMBER;
2839: l_manage_vr_ind VARCHAR2 (1);
2840: l_spec_type VARCHAR2 (1);

Line 3010: l_supplier_spec_vrs_in gmd_supplier_spec_vrs%ROWTYPE;

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

Line 3014: l_supplier_spec_vrs_out gmd_supplier_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);
3016: l_spec_vr_id NUMBER;
3017: l_manage_vr_ind VARCHAR2 (1);
3018: l_spec_type VARCHAR2 (1);

Line 3093: FROM gmd_supplier_spec_vrs

3089: default_log (' Created New WIP Validity Rule: ' || l_wip_spec_vrs_out.spec_vr_id);
3090: ELSIF l_spec_type = 'S' THEN
3091: SELECT *
3092: INTO l_supplier_spec_vrs_in
3093: FROM gmd_supplier_spec_vrs
3094: WHERE spec_vr_id = l_spec_vr_id;
3095:
3096: l_supplier_spec_vrs_in.spec_id := p_to_spec_id;
3097:

Line 3104: l_return := gmd_supplier_spec_vrs_pvt.insert_row

3100: END IF;
3101:
3102: l_supplier_spec_vrs_in.spec_vr_id := NULL;
3103: default_log (' Copy From Supplier Validity Rule: ' || l_spec_vr_id);
3104: l_return := gmd_supplier_spec_vrs_pvt.insert_row
3105: ( p_supplier_spec_vrs => l_supplier_spec_vrs_in
3106: , x_supplier_spec_vrs => l_supplier_spec_vrs_out);
3107:
3108: default_log (' Created New Supplier Validity Rule: ' || l_supplier_spec_vrs_out.spec_vr_id);

Line 3127: l_supplier_spec_vrs gmd_supplier_spec_vrs%ROWTYPE;

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);
3129: l_spec_vr_id NUMBER;
3130: l_manage_vr_ind VARCHAR2 (1);
3131: l_spec_type VARCHAR2 (1);

Line 3158: UPDATE gmd_supplier_spec_vrs

3154: WHERE spec_vr_id = l_spec_vr_id;
3155:
3156: default_log (' End WIP Validity Rule: ' || l_spec_vr_id);
3157: ELSIF l_spec_type = 'S' THEN
3158: UPDATE gmd_supplier_spec_vrs
3159: SET end_date = SYSDATE
3160: WHERE spec_vr_id = l_spec_vr_id;
3161:
3162: default_log (' End Supplier Validity Rule: ' || l_spec_vr_id);

Line 3181: l_supplier_spec_vrs gmd_supplier_spec_vrs%ROWTYPE;

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);
3183: l_spec_vr_id NUMBER;
3184: l_manage_vr_ind VARCHAR2 (1);
3185: l_spec_type VARCHAR2 (1);

Line 3212: UPDATE gmd_supplier_spec_vrs

3208: WHERE spec_vr_id = l_spec_vr_id;
3209:
3210: default_log (' Obsolete WIP Validity Rule: ' || l_spec_vr_id);
3211: ELSIF l_spec_type = 'S' THEN
3212: UPDATE gmd_supplier_spec_vrs
3213: SET spec_vr_status = 1000
3214: WHERE spec_vr_id = l_spec_vr_id;
3215:
3216: default_log (' Obsolete Supplier Validity Rule: ' || l_spec_vr_id);

Line 3238: l_supplier_spec_vrs gmd_supplier_spec_vrs%ROWTYPE;

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);
3240: l_spec_vr_id NUMBER;
3241: l_manage_vr_ind VARCHAR2 (1);
3242: l_spec_type VARCHAR2 (1);

Line 3331: UPDATE gmd_supplier_spec_vrs

3327:
3328: default_log (' Updated WIP Validity Rule: ' || l_spec_vr_id);
3329: ELSIF l_spec_type = 'S' THEN
3330: IF p_new_status IS NOT NULL THEN
3331: UPDATE gmd_supplier_spec_vrs
3332: SET spec_vr_status = p_new_status
3333: WHERE spec_vr_id = l_spec_vr_id;
3334: ELSIF p_start_date IS NOT NULL THEN
3335: UPDATE gmd_supplier_spec_vrs

Line 3335: UPDATE gmd_supplier_spec_vrs

3331: UPDATE gmd_supplier_spec_vrs
3332: SET spec_vr_status = p_new_status
3333: WHERE spec_vr_id = l_spec_vr_id;
3334: ELSIF p_start_date IS NOT NULL THEN
3335: UPDATE gmd_supplier_spec_vrs
3336: SET start_date = p_start_date
3337: WHERE spec_vr_id = l_spec_vr_id;
3338: ELSIF p_end_date IS NOT NULL THEN
3339: UPDATE gmd_supplier_spec_vrs

Line 3339: UPDATE gmd_supplier_spec_vrs

3335: UPDATE gmd_supplier_spec_vrs
3336: SET start_date = p_start_date
3337: WHERE spec_vr_id = l_spec_vr_id;
3338: ELSIF p_end_date IS NOT NULL THEN
3339: UPDATE gmd_supplier_spec_vrs
3340: SET end_date = p_end_date
3341: WHERE spec_vr_id = l_spec_vr_id;
3342: END IF;
3343: