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_WIP_SPEC_VRS

Line 2723: l_wip_spec_vrs gmd_wip_spec_vrs%ROWTYPE;

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;
2727: l_manage_vr_ind VARCHAR2 (1);

Line 2897: l_wip_spec_vrs_in gmd_wip_spec_vrs%ROWTYPE;

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

Line 2901: l_wip_spec_vrs_out gmd_wip_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;
2905: l_manage_vr_ind VARCHAR2 (1);

Line 2962: FROM gmd_wip_spec_vrs

2958: default_log (' Created New Inventory Validity Rule: ' || l_inv_spec_vrs_out.spec_vr_id);
2959: ELSIF l_spec_type = 'W' THEN
2960: SELECT *
2961: INTO l_wip_spec_vrs_in
2962: FROM gmd_wip_spec_vrs
2963: WHERE spec_vr_id = l_spec_vr_id;
2964:
2965: l_wip_spec_vrs_in.spec_id := p_to_spec_id;
2966:

Line 2973: l_return := gmd_wip_spec_vrs_pvt.insert_row

2969: END IF;
2970:
2971: l_wip_spec_vrs_in.spec_vr_id := NULL;
2972: default_log (' Copy From WIP Validity Rule: ' || l_spec_vr_id);
2973: l_return := gmd_wip_spec_vrs_pvt.insert_row
2974: ( p_wip_spec_vrs => l_wip_spec_vrs_in
2975: , x_wip_spec_vrs => l_wip_spec_vrs_out );
2976:
2977: default_log (' Created New WIP Validity Rule: ' || l_wip_spec_vrs_out.spec_vr_id);

Line 3014: l_wip_spec_vrs gmd_wip_spec_vrs%ROWTYPE;

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

Line 3040: UPDATE gmd_wip_spec_vrs

3036: WHERE spec_vr_id = l_spec_vr_id;
3037:
3038: default_log (' End Inventory Validity Rule: ' || l_spec_vr_id);
3039: ELSIF l_spec_type = 'W' THEN
3040: UPDATE gmd_wip_spec_vrs
3041: SET end_date = SYSDATE
3042: WHERE spec_vr_id = l_spec_vr_id;
3043:
3044: default_log (' End WIP Validity Rule: ' || l_spec_vr_id);

Line 3068: l_wip_spec_vrs gmd_wip_spec_vrs%ROWTYPE;

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

Line 3094: UPDATE gmd_wip_spec_vrs

3090: WHERE spec_vr_id = l_spec_vr_id;
3091:
3092: default_log (' Obsolete Inventory Validity Rule: ' || l_spec_vr_id);
3093: ELSIF l_spec_type = 'W' THEN
3094: UPDATE gmd_wip_spec_vrs
3095: SET spec_vr_status = 1000
3096: WHERE spec_vr_id = l_spec_vr_id;
3097:
3098: default_log (' Obsolete WIP Validity Rule: ' || l_spec_vr_id);

Line 3125: l_wip_spec_vrs gmd_wip_spec_vrs%ROWTYPE;

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

Line 3198: UPDATE gmd_wip_spec_vrs

3194:
3195: default_log (' Updated Inventory Validity Rule: ' || l_spec_vr_id);
3196: ELSIF l_spec_type = 'W' THEN
3197: IF p_new_status IS NOT NULL THEN
3198: UPDATE gmd_wip_spec_vrs
3199: SET spec_vr_status = p_new_status
3200: WHERE spec_vr_id = l_spec_vr_id;
3201: ELSIF p_start_date IS NOT NULL THEN
3202: UPDATE gmd_wip_spec_vrs

Line 3202: UPDATE gmd_wip_spec_vrs

3198: UPDATE gmd_wip_spec_vrs
3199: SET spec_vr_status = p_new_status
3200: WHERE spec_vr_id = l_spec_vr_id;
3201: ELSIF p_start_date IS NOT NULL THEN
3202: UPDATE gmd_wip_spec_vrs
3203: SET start_date = p_start_date
3204: WHERE spec_vr_id = l_spec_vr_id;
3205: ELSIF p_end_date IS NOT NULL THEN
3206: UPDATE gmd_wip_spec_vrs

Line 3206: UPDATE gmd_wip_spec_vrs

3202: UPDATE gmd_wip_spec_vrs
3203: SET start_date = p_start_date
3204: WHERE spec_vr_id = l_spec_vr_id;
3205: ELSIF p_end_date IS NOT NULL THEN
3206: UPDATE gmd_wip_spec_vrs
3207: SET end_date = p_end_date
3208: WHERE spec_vr_id = l_spec_vr_id;
3209: END IF;
3210: