DBA Data[Home] [Help]

APPS.POS_SUPP_CLASSIFICATION_PKG dependencies on POS_BUS_CLASS_ATTR_S

Line 41: ( POS_BUS_CLASS_ATTR_S.NEXTVAL , p_cert_num,

37: party_id, lookup_type, lookup_code, start_date_active,
38: vendor_id
39: )
40: values
41: ( POS_BUS_CLASS_ATTR_S.NEXTVAL , p_cert_num,
42: p_cert_agency, p_exp_date,
43: 'APPROVED', 'A', fnd_global.user_id, sysdate,
44: p_ext_attr_1, null, null, null,
45: null, null, fnd_global.user_id,

Line 182: select pos_bus_class_attr_s.nextval

178: last_update_date = sysdate
179: where bus_class_request_id = p_request_id;
180: end if;
181: else
182: select pos_bus_class_attr_s.nextval
183: into l_class_id
184: from dual;
185:
186: -- approving pending data

Line 584: select POS_BUS_CLASS_ATTR_S.NEXTVAL

580:
581: if ( l_po_status <> l_pos_status ) then
582: if( l_po_status = 'Y' ) then
583: x_modified := 'Y';
584: select POS_BUS_CLASS_ATTR_S.NEXTVAL
585: into l_id
586: from dual;
587:
588: insert into pos_bus_class_attr