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 2724: l_supplier_spec_vrs gmd_supplier_spec_vrs%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;
2727: l_manage_vr_ind VARCHAR2 (1);
2728: l_spec_type VARCHAR2 (1);

Line 2898: l_supplier_spec_vrs_in gmd_supplier_spec_vrs%ROWTYPE;

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;
2901: l_wip_spec_vrs_out gmd_wip_spec_vrs%ROWTYPE;
2902: l_supplier_spec_vrs_out gmd_supplier_spec_vrs%ROWTYPE;

Line 2902: l_supplier_spec_vrs_out gmd_supplier_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;
2905: l_manage_vr_ind VARCHAR2 (1);
2906: l_spec_type VARCHAR2 (1);

Line 2981: FROM gmd_supplier_spec_vrs

2977: default_log (' Created New WIP Validity Rule: ' || l_wip_spec_vrs_out.spec_vr_id);
2978: ELSIF l_spec_type = 'S' THEN
2979: SELECT *
2980: INTO l_supplier_spec_vrs_in
2981: FROM gmd_supplier_spec_vrs
2982: WHERE spec_vr_id = l_spec_vr_id;
2983:
2984: l_supplier_spec_vrs_in.spec_id := p_to_spec_id;
2985:

Line 2992: l_return := gmd_supplier_spec_vrs_pvt.insert_row

2988: END IF;
2989:
2990: l_supplier_spec_vrs_in.spec_vr_id := NULL;
2991: default_log (' Copy From Supplier Validity Rule: ' || l_spec_vr_id);
2992: l_return := gmd_supplier_spec_vrs_pvt.insert_row
2993: ( p_supplier_spec_vrs => l_supplier_spec_vrs_in
2994: , x_supplier_spec_vrs => l_supplier_spec_vrs_out);
2995:
2996: default_log (' Created New Supplier Validity Rule: ' || l_supplier_spec_vrs_out.spec_vr_id);

Line 3015: l_supplier_spec_vrs gmd_supplier_spec_vrs%ROWTYPE;

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;
3018: l_manage_vr_ind VARCHAR2 (1);
3019: l_spec_type VARCHAR2 (1);

Line 3046: UPDATE gmd_supplier_spec_vrs

3042: WHERE spec_vr_id = l_spec_vr_id;
3043:
3044: default_log (' End WIP Validity Rule: ' || l_spec_vr_id);
3045: ELSIF l_spec_type = 'S' THEN
3046: UPDATE gmd_supplier_spec_vrs
3047: SET end_date = SYSDATE
3048: WHERE spec_vr_id = l_spec_vr_id;
3049:
3050: default_log (' End Supplier Validity Rule: ' || l_spec_vr_id);

Line 3069: l_supplier_spec_vrs gmd_supplier_spec_vrs%ROWTYPE;

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;
3072: l_manage_vr_ind VARCHAR2 (1);
3073: l_spec_type VARCHAR2 (1);

Line 3100: UPDATE gmd_supplier_spec_vrs

3096: WHERE spec_vr_id = l_spec_vr_id;
3097:
3098: default_log (' Obsolete WIP Validity Rule: ' || l_spec_vr_id);
3099: ELSIF l_spec_type = 'S' THEN
3100: UPDATE gmd_supplier_spec_vrs
3101: SET spec_vr_status = 1000
3102: WHERE spec_vr_id = l_spec_vr_id;
3103:
3104: default_log (' Obsolete Supplier Validity Rule: ' || l_spec_vr_id);

Line 3126: l_supplier_spec_vrs gmd_supplier_spec_vrs%ROWTYPE;

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

Line 3214: UPDATE gmd_supplier_spec_vrs

3210:
3211: default_log (' Updated WIP Validity Rule: ' || l_spec_vr_id);
3212: ELSIF l_spec_type = 'S' THEN
3213: IF p_new_status IS NOT NULL THEN
3214: UPDATE gmd_supplier_spec_vrs
3215: SET spec_vr_status = p_new_status
3216: WHERE spec_vr_id = l_spec_vr_id;
3217: ELSIF p_start_date IS NOT NULL THEN
3218: UPDATE gmd_supplier_spec_vrs

Line 3218: UPDATE gmd_supplier_spec_vrs

3214: UPDATE gmd_supplier_spec_vrs
3215: SET spec_vr_status = p_new_status
3216: WHERE spec_vr_id = l_spec_vr_id;
3217: ELSIF p_start_date IS NOT NULL THEN
3218: UPDATE gmd_supplier_spec_vrs
3219: SET start_date = p_start_date
3220: WHERE spec_vr_id = l_spec_vr_id;
3221: ELSIF p_end_date IS NOT NULL THEN
3222: UPDATE gmd_supplier_spec_vrs

Line 3222: UPDATE gmd_supplier_spec_vrs

3218: UPDATE gmd_supplier_spec_vrs
3219: SET start_date = p_start_date
3220: WHERE spec_vr_id = l_spec_vr_id;
3221: ELSIF p_end_date IS NOT NULL THEN
3222: UPDATE gmd_supplier_spec_vrs
3223: SET end_date = p_end_date
3224: WHERE spec_vr_id = l_spec_vr_id;
3225: END IF;
3226: