8: pitem_no OUT NOCOPY VARCHAR2) IS
9:
10: CURSOR get_item_number IS
11: SELECT item_no
12: FROM ic_item_mst
13: WHERE item_id = pitem_id;
14:
15: BEGIN
16:
28: pitem_um OUT NOCOPY VARCHAR2) IS
29:
30: CURSOR get_item_um IS
31: SELECT item_um
32: FROM ic_item_mst
33: WHERE item_id = pitem_id;
34:
35: BEGIN
36:
49: pitem_desc OUT NOCOPY VARCHAR2) IS
50:
51: CURSOR get_item_desc IS
52: SELECT item_desc1
53: FROM ic_item_mst
54: WHERE item_id = pitem_id;
55:
56: BEGIN
57:
113: pum_type OUT NOCOPY VARCHAR2) IS
114:
115: CURSOR get_item_info IS
116: SELECT m.item_um, s.um_type
117: FROM ic_item_mst m, sy_uoms_mst s
118: WHERE m.item_id = pitem_id AND
119: m.item_um = s.um_code;
120:
121: BEGIN
277:
278: BEGIN
279:
280: IF (EDR_PSIG_PAGE_FLOW.SIGNATURE_STATUS = 'SUCCESS') THEN
281: UPDATE ic_item_mst_b
282: SET inactive_ind = 0,
283: trans_cnt = -99
284: WHERE item_id = pitem_id;
285: /*==================
499: IS
500:
501: CURSOR get_itemattr is
502: SELECT *
503: FROM ic_item_mst_b
504: WHERE item_id = pitem_id;
505:
506: x_item_rec get_itemattr%ROWTYPE;
507: