APPS.GMD_QC_MIG12 dependencies on IC_LOTS_STS

Line 585: FROM ic_lots_sts

581:
582:
583: CURSOR get_status_id IS
584: SELECT status_id
585: FROM ic_lots_sts
586: WHERE lot_status = p_lot_status;
587:
588: l_status_id ic_lots_sts.status_id%TYPE;
589:

Line 588: l_status_id ic_lots_sts.status_id%TYPE;

584: SELECT status_id
585: FROM ic_lots_sts
586: WHERE lot_status = p_lot_status;
587:
588: l_status_id ic_lots_sts.status_id%TYPE;
589:
590: BEGIN
591:
592: OPEN get_status_id;

Line 1161: l_in_spec_status_id ic_lots_sts.status_id%TYPE;

1157: /*=================================
1158: General Placeholders.
1159: =================================*/
1160:
1161: l_in_spec_status_id ic_lots_sts.status_id%TYPE;
1162: l_out_spec_status_id ic_lots_sts.status_id%TYPE;
1163:
1164: l_reason_id NUMBER;
1165: l_text_code NUMBER;

Line 1162: l_out_spec_status_id ic_lots_sts.status_id%TYPE;

1158: General Placeholders.
1159: =================================*/
1160:
1161: l_in_spec_status_id ic_lots_sts.status_id%TYPE;
1162: l_out_spec_status_id ic_lots_sts.status_id%TYPE;
1163:
1164: l_reason_id NUMBER;
1165: l_text_code NUMBER;
1166:

Line 3706: l_in_spec_status_id ic_lots_sts.status_id%TYPE;

3702: l_lot_number gmd_samples.lot_number%TYPE;
3703: l_get_parent_only NUMBER := 0;
3704: l_failure_count NUMBER;
3705: l_return_status NUMBER;
3706: l_in_spec_status_id ic_lots_sts.status_id%TYPE;
3707: l_out_spec_status_id ic_lots_sts.status_id%TYPE;
3708: l_clone NUMBER;
3709: l_text_code NUMBER;
3710:

Line 3707: l_out_spec_status_id ic_lots_sts.status_id%TYPE;

3703: l_get_parent_only NUMBER := 0;
3704: l_failure_count NUMBER;
3705: l_return_status NUMBER;
3706: l_in_spec_status_id ic_lots_sts.status_id%TYPE;
3707: l_out_spec_status_id ic_lots_sts.status_id%TYPE;
3708: l_clone NUMBER;
3709: l_text_code NUMBER;
3710:
3711: -- Bug# 5482253