APPS.GMD_SAMPLES_GRP dependencies on GME_BATCH_STEPS

Line 1512: p_batch_step_rec GME_BATCH_STEPS%ROWTYPE;

1508: x_message_count NUMBER;
1509: x_message_list VARCHAR2(2000);
1510: xx_return_status VARCHAR2(1);
1511: l_exception_material_tbl GME_COMMON_PVT.exceptions_tab;
1512: p_batch_step_rec GME_BATCH_STEPS%ROWTYPE;
1513: x_batch_step_rec GME_BATCH_STEPS%ROWTYPE;
1514:
1515: --Bug# 5440347 end
1516:

Line 1513: x_batch_step_rec GME_BATCH_STEPS%ROWTYPE;

1509: x_message_list VARCHAR2(2000);
1510: xx_return_status VARCHAR2(1);
1511: l_exception_material_tbl GME_COMMON_PVT.exceptions_tab;
1512: p_batch_step_rec GME_BATCH_STEPS%ROWTYPE;
1513: x_batch_step_rec GME_BATCH_STEPS%ROWTYPE;
1514:
1515: --Bug# 5440347 end
1516:
1517: BEGIN

Line 2325: p_batch_step_rec GME_BATCH_STEPS%ROWTYPE;

2321: x_message_count NUMBER;
2322: x_message_list VARCHAR2(2000);
2323: xx_return_status VARCHAR2(1);
2324: l_exception_material_tbl GME_COMMON_PVT.exceptions_tab;
2325: p_batch_step_rec GME_BATCH_STEPS%ROWTYPE;
2326: x_batch_step_rec GME_BATCH_STEPS%ROWTYPE;
2327: l_step_status NUMBER;
2328:
2329: --Bug# 5440347 end

Line 2326: x_batch_step_rec GME_BATCH_STEPS%ROWTYPE;

2322: x_message_list VARCHAR2(2000);
2323: xx_return_status VARCHAR2(1);
2324: l_exception_material_tbl GME_COMMON_PVT.exceptions_tab;
2325: p_batch_step_rec GME_BATCH_STEPS%ROWTYPE;
2326: x_batch_step_rec GME_BATCH_STEPS%ROWTYPE;
2327: l_step_status NUMBER;
2328:
2329: --Bug# 5440347 end
2330:

Line 2810: FROM gme_batch_steps

2806: WHERE batch_id = l_batch_id; */
2807:
2808: -- Bug# 5440347
2809: SELECT step_status INTO l_step_status
2810: FROM gme_batch_steps
2811: WHERE batch_id = l_batch_id
2812: AND batchstep_no = l_step_no;
2813:
2814:

Line 2818: FROM GME_BATCH_STEPS

2814:
2815: --IF l_batch_status <> 4 THEN
2816: IF l_step_status < 3 THEN -- Bug# 5440347
2817: SELECT quality_status,rowid, batchstep_id INTO l_curr_qc_status,l_rowid, l_bstep_id -- Bug# 5440347 Added batchstep_id
2818: FROM GME_BATCH_STEPS
2819: WHERE BATCH_ID = l_batch_id
2820: AND batchstep_no = l_step_no
2821: FOR UPDATE OF quality_status NOWAIT ;
2822:

Line 2824: UPDATE GME_BATCH_STEPS

2820: AND batchstep_no = l_step_no
2821: FOR UPDATE OF quality_status NOWAIT ;
2822:
2823: IF l_curr_qc_status = 3 THEN -- Results Required
2824: UPDATE GME_BATCH_STEPS
2825: SET quality_status = p_to_qc_status
2826: ,last_updated_by = FND_GLOBAL.USER_ID
2827: ,last_update_date = SYSDATE
2828: ,last_update_login = FND_GLOBAL.LOGIN_ID

Line 3095: FROM gme_batch_steps

3091:
3092:
3093: CURSOR c_batchstep IS
3094: SELECT 1
3095: FROM gme_batch_steps
3096: WHERE batch_id = p_sample.batch_id
3097: AND batchstep_no = p_sample.step_no
3098: ;
3099:

Line 5460: FROM gme_batch_steps bs,

5456: CURSOR Cur_vstep IS
5457: SELECT bs.batchstep_no,
5458: o.oprn_no,
5459: o.oprn_vers
5460: FROM gme_batch_steps bs,
5461: gmd_operations o
5462: WHERE bs.oprn_id = o.oprn_id
5463: AND bs.batch_id = p_batch_id
5464: AND bs.batchstep_id = p_step_id