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_SAMPLES_GRP dependencies on GME_BATCH_STEPS

Line 1619: p_batch_step_rec GME_BATCH_STEPS%ROWTYPE;

1615: x_message_count NUMBER;
1616: x_message_list VARCHAR2(2000);
1617: xx_return_status VARCHAR2(1);
1618: l_exception_material_tbl GME_COMMON_PVT.exceptions_tab;
1619: p_batch_step_rec GME_BATCH_STEPS%ROWTYPE;
1620: x_batch_step_rec GME_BATCH_STEPS%ROWTYPE;
1621:
1622: l_ch_final_disp VARCHAR2(4); /* Added in Bug No.8679485 */
1623:

Line 1620: x_batch_step_rec GME_BATCH_STEPS%ROWTYPE;

1616: x_message_list VARCHAR2(2000);
1617: xx_return_status VARCHAR2(1);
1618: l_exception_material_tbl GME_COMMON_PVT.exceptions_tab;
1619: p_batch_step_rec GME_BATCH_STEPS%ROWTYPE;
1620: x_batch_step_rec GME_BATCH_STEPS%ROWTYPE;
1621:
1622: l_ch_final_disp VARCHAR2(4); /* Added in Bug No.8679485 */
1623:
1624: --Bug# 5440347 end

Line 2554: p_batch_step_rec GME_BATCH_STEPS%ROWTYPE;

2550: x_message_count NUMBER;
2551: x_message_list VARCHAR2(2000);
2552: xx_return_status VARCHAR2(1);
2553: l_exception_material_tbl GME_COMMON_PVT.exceptions_tab;
2554: p_batch_step_rec GME_BATCH_STEPS%ROWTYPE;
2555: x_batch_step_rec GME_BATCH_STEPS%ROWTYPE;
2556: l_step_status NUMBER;
2557: -- Variable added for retrieving the profile value Bug#10170611
2558: l_lot_update_profile VARCHAR2(3);

Line 2555: x_batch_step_rec GME_BATCH_STEPS%ROWTYPE;

2551: x_message_list VARCHAR2(2000);
2552: xx_return_status VARCHAR2(1);
2553: l_exception_material_tbl GME_COMMON_PVT.exceptions_tab;
2554: p_batch_step_rec GME_BATCH_STEPS%ROWTYPE;
2555: x_batch_step_rec GME_BATCH_STEPS%ROWTYPE;
2556: l_step_status NUMBER;
2557: -- Variable added for retrieving the profile value Bug#10170611
2558: l_lot_update_profile VARCHAR2(3);
2559: l_debug VARCHAR2(1) := 'Y'; -- plowe

Line 3394: FROM gme_batch_steps

3390: WHERE batch_id = l_batch_id; */
3391:
3392: -- Bug# 5440347
3393: SELECT step_status INTO l_step_status
3394: FROM gme_batch_steps
3395: WHERE batch_id = l_batch_id
3396: AND batchstep_no = l_step_no;
3397:
3398:

Line 3402: FROM GME_BATCH_STEPS

3398:
3399: --IF l_batch_status <> 4 THEN
3400: IF l_step_status < 3 THEN -- Bug# 5440347
3401: SELECT quality_status,rowid, batchstep_id INTO l_curr_qc_status,l_rowid, l_bstep_id -- Bug# 5440347 Added batchstep_id
3402: FROM GME_BATCH_STEPS
3403: WHERE BATCH_ID = l_batch_id
3404: AND batchstep_no = l_step_no
3405: FOR UPDATE OF quality_status NOWAIT ;
3406:

Line 3408: gmd_debug.put_line('about to UPDATE GME_BATCH_STEPS quality status with p_to_qc_status :'||p_to_qc_status);

3404: AND batchstep_no = l_step_no
3405: FOR UPDATE OF quality_status NOWAIT ;
3406:
3407: IF (l_debug = 'Y') THEN
3408: gmd_debug.put_line('about to UPDATE GME_BATCH_STEPS quality status with p_to_qc_status :'||p_to_qc_status);
3409: END IF;
3410:
3411:
3412: IF l_curr_qc_status = 3 THEN -- Results Required

Line 3413: UPDATE GME_BATCH_STEPS

3409: END IF;
3410:
3411:
3412: IF l_curr_qc_status = 3 THEN -- Results Required
3413: UPDATE GME_BATCH_STEPS
3414: SET quality_status = p_to_qc_status -- NO ACTION BUT could be here too 8252179
3415: ,last_updated_by = FND_GLOBAL.USER_ID
3416: ,last_update_date = SYSDATE
3417: ,last_update_login = FND_GLOBAL.LOGIN_ID

Line 3690: FROM gme_batch_steps

3686:
3687:
3688: CURSOR c_batchstep IS
3689: SELECT 1
3690: FROM gme_batch_steps
3691: WHERE batch_id = p_sample.batch_id
3692: AND batchstep_no = p_sample.step_no
3693: ;
3694:

Line 6128: FROM gme_batch_steps bs,

6124: CURSOR Cur_vstep IS
6125: SELECT bs.batchstep_no,
6126: o.oprn_no,
6127: o.oprn_vers
6128: FROM gme_batch_steps bs,
6129: gmd_operations o
6130: WHERE bs.oprn_id = o.oprn_id
6131: AND bs.batch_id = p_batch_id
6132: AND bs.batchstep_id = p_step_id