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 2835: l_wip_spec_vrs gmd_wip_spec_vrs%ROWTYPE;

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);
2838: l_vr_id NUMBER;
2839: l_manage_vr_ind VARCHAR2 (1);

Line 3009: l_wip_spec_vrs_in gmd_wip_spec_vrs%ROWTYPE;

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;
3012: l_inv_spec_vrs_out gmd_inventory_spec_vrs%ROWTYPE;
3013: l_wip_spec_vrs_out gmd_wip_spec_vrs%ROWTYPE;

Line 3013: l_wip_spec_vrs_out gmd_wip_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);
3016: l_spec_vr_id NUMBER;
3017: l_manage_vr_ind VARCHAR2 (1);

Line 3074: FROM gmd_wip_spec_vrs

3070: default_log (' Created New Inventory Validity Rule: ' || l_inv_spec_vrs_out.spec_vr_id);
3071: ELSIF l_spec_type = 'W' THEN
3072: SELECT *
3073: INTO l_wip_spec_vrs_in
3074: FROM gmd_wip_spec_vrs
3075: WHERE spec_vr_id = l_spec_vr_id;
3076:
3077: l_wip_spec_vrs_in.spec_id := p_to_spec_id;
3078:

Line 3085: l_return := gmd_wip_spec_vrs_pvt.insert_row

3081: END IF;
3082:
3083: l_wip_spec_vrs_in.spec_vr_id := NULL;
3084: default_log (' Copy From WIP Validity Rule: ' || l_spec_vr_id);
3085: l_return := gmd_wip_spec_vrs_pvt.insert_row
3086: ( p_wip_spec_vrs => l_wip_spec_vrs_in
3087: , x_wip_spec_vrs => l_wip_spec_vrs_out );
3088:
3089: default_log (' Created New WIP Validity Rule: ' || l_wip_spec_vrs_out.spec_vr_id);

Line 3126: l_wip_spec_vrs gmd_wip_spec_vrs%ROWTYPE;

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

Line 3152: UPDATE gmd_wip_spec_vrs

3148: WHERE spec_vr_id = l_spec_vr_id;
3149:
3150: default_log (' End Inventory Validity Rule: ' || l_spec_vr_id);
3151: ELSIF l_spec_type = 'W' THEN
3152: UPDATE gmd_wip_spec_vrs
3153: SET end_date = SYSDATE
3154: WHERE spec_vr_id = l_spec_vr_id;
3155:
3156: default_log (' End WIP Validity Rule: ' || l_spec_vr_id);

Line 3180: l_wip_spec_vrs gmd_wip_spec_vrs%ROWTYPE;

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

Line 3206: UPDATE gmd_wip_spec_vrs

3202: WHERE spec_vr_id = l_spec_vr_id;
3203:
3204: default_log (' Obsolete Inventory Validity Rule: ' || l_spec_vr_id);
3205: ELSIF l_spec_type = 'W' THEN
3206: UPDATE gmd_wip_spec_vrs
3207: SET spec_vr_status = 1000
3208: WHERE spec_vr_id = l_spec_vr_id;
3209:
3210: default_log (' Obsolete WIP Validity Rule: ' || l_spec_vr_id);

Line 3237: l_wip_spec_vrs gmd_wip_spec_vrs%ROWTYPE;

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

Line 3315: UPDATE gmd_wip_spec_vrs

3311:
3312: default_log (' Updated Inventory Validity Rule: ' || l_spec_vr_id);
3313: ELSIF l_spec_type = 'W' THEN
3314: IF p_new_status IS NOT NULL THEN
3315: UPDATE gmd_wip_spec_vrs
3316: SET spec_vr_status = p_new_status
3317: WHERE spec_vr_id = l_spec_vr_id;
3318: ELSIF p_start_date IS NOT NULL THEN
3319: UPDATE gmd_wip_spec_vrs

Line 3319: UPDATE gmd_wip_spec_vrs

3315: UPDATE gmd_wip_spec_vrs
3316: SET spec_vr_status = p_new_status
3317: WHERE spec_vr_id = l_spec_vr_id;
3318: ELSIF p_start_date IS NOT NULL THEN
3319: UPDATE gmd_wip_spec_vrs
3320: SET start_date = p_start_date
3321: WHERE spec_vr_id = l_spec_vr_id;
3322: ELSIF p_end_date IS NOT NULL THEN
3323: UPDATE gmd_wip_spec_vrs

Line 3323: UPDATE gmd_wip_spec_vrs

3319: UPDATE gmd_wip_spec_vrs
3320: SET start_date = p_start_date
3321: WHERE spec_vr_id = l_spec_vr_id;
3322: ELSIF p_end_date IS NOT NULL THEN
3323: UPDATE gmd_wip_spec_vrs
3324: SET end_date = p_end_date
3325: WHERE spec_vr_id = l_spec_vr_id;
3326: END IF;
3327: