913: ================ */
914: l_item_id ic_item_mst.item_id%TYPE;
915: l_lot_ctl ic_item_mst.lot_ctl%TYPE;
916: l_sublot_ctl ic_item_mst.sublot_ctl%TYPE;
917: l_lot_id ic_lots_mst.lot_id%TYPE;
918:
919:
920: CURSOR get_item_attributes IS
921: SELECT item_id, lot_ctl, sublot_ctl
924: AND delete_mark = 0;
925:
926: CURSOR validate_lot IS
927: SELECT lot_id
928: FROM ic_lots_mst
929: where item_id = l_item_id
930: AND lot_no = UPPER(plot_no)
931: AND delete_mark = 0;
932:
931: AND delete_mark = 0;
932:
933: CURSOR validate_sublot IS
934: SELECT lot_id
935: FROM ic_lots_mst
936: WHERE item_id = l_item_id
937: AND lot_no = UPPER(plot_no)
938: AND sublot_no = UPPER(psublot_no)
939: AND delete_mark = 0;
1057: ================ */
1058: l_item_id ic_item_mst.item_id%TYPE;
1059: l_lot_ctl ic_item_mst.lot_ctl%TYPE;
1060: l_sublot_ctl ic_item_mst.sublot_ctl%TYPE;
1061: l_lot_id ic_lots_mst.lot_id%TYPE;
1062: /* Cursor Definitions
1063:
1064:
1065: ================== */
1070: AND delete_mark = 0;
1071:
1072: CURSOR validate_lot IS
1073: SELECT lot_id
1074: FROM ic_lots_mst
1075: where item_id = pitem_id
1076: AND lot_id = plot_id
1077: AND delete_mark = 0;
1078: