APPS.GMD_QC_MIG12 dependencies on IC_LOTS_STS

Line 593: FROM ic_lots_sts

589:
590:
591: CURSOR get_status_id IS
592: SELECT status_id
593: FROM ic_lots_sts
594: WHERE lot_status = p_lot_status;
595:
596: l_status_id ic_lots_sts.status_id%TYPE;
597:

Line 596: l_status_id ic_lots_sts.status_id%TYPE;

592: SELECT status_id
593: FROM ic_lots_sts
594: WHERE lot_status = p_lot_status;
595:
596: l_status_id ic_lots_sts.status_id%TYPE;
597:
598: BEGIN
599:
600: OPEN get_status_id;

Line 1169: l_in_spec_status_id ic_lots_sts.status_id%TYPE;

1165: /*=================================
1166: General Placeholders.
1167: =================================*/
1168:
1169: l_in_spec_status_id ic_lots_sts.status_id%TYPE;
1170: l_out_spec_status_id ic_lots_sts.status_id%TYPE;
1171:
1172: l_reason_id NUMBER;
1173: l_text_code NUMBER;

Line 1170: l_out_spec_status_id ic_lots_sts.status_id%TYPE;

1166: General Placeholders.
1167: =================================*/
1168:
1169: l_in_spec_status_id ic_lots_sts.status_id%TYPE;
1170: l_out_spec_status_id ic_lots_sts.status_id%TYPE;
1171:
1172: l_reason_id NUMBER;
1173: l_text_code NUMBER;
1174:

Line 3975: l_in_spec_status_id ic_lots_sts.status_id%TYPE;

3971: l_lot_number gmd_samples.lot_number%TYPE;
3972: l_get_parent_only NUMBER := 0;
3973: l_failure_count NUMBER;
3974: l_return_status NUMBER;
3975: l_in_spec_status_id ic_lots_sts.status_id%TYPE;
3976: l_out_spec_status_id ic_lots_sts.status_id%TYPE;
3977: l_clone NUMBER;
3978: l_text_code NUMBER;
3979:

Line 3976: l_out_spec_status_id ic_lots_sts.status_id%TYPE;

3972: l_get_parent_only NUMBER := 0;
3973: l_failure_count NUMBER;
3974: l_return_status NUMBER;
3975: l_in_spec_status_id ic_lots_sts.status_id%TYPE;
3976: l_out_spec_status_id ic_lots_sts.status_id%TYPE;
3977: l_clone NUMBER;
3978: l_text_code NUMBER;
3979:
3980: -- Bug# 5482253