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 603: select POS_BUS_CLASS_ATTR_S.NEXTVAL

599:
600: if ( l_po_status <> l_pos_status ) then
601: if( l_po_status = 'Y' ) then
602: x_modified := 'Y';
603: select POS_BUS_CLASS_ATTR_S.NEXTVAL
604: into l_id
605: from dual;
606:
607: insert into pos_bus_class_attr

Line 791: ( POS_BUS_CLASS_ATTR_S.NEXTVAL , p_cert_num,

787: party_id, lookup_type, lookup_code, start_date_active,
788: vendor_id, party_site_id
789: )
790: values
791: ( POS_BUS_CLASS_ATTR_S.NEXTVAL , p_cert_num,
792: p_cert_agency, p_exp_date,
793: 'APPROVED', 'A', fnd_global.user_id, sysdate,
794: p_ext_attr_1, null, null, null,
795: null, null, fnd_global.user_id,

Line 861: select pos_bus_class_attr_s.nextval

857: where classification_id = p_classification_id;
858:
859: else
860:
861: select pos_bus_class_attr_s.nextval
862: into l_class_id
863: from dual;
864:
865: -- approving pending data

Line 943: POS_BUS_CLASS_ATTR_S.NEXTVAL , p_cert_num,

939: vendor_id, party_site_id, vendor_site_id
940: )
941: values
942: (
943: POS_BUS_CLASS_ATTR_S.NEXTVAL , p_cert_num,
944: p_cert_agency, p_exp_date,
945: 'APPROVED', 'A', fnd_global.user_id, sysdate,
946: p_ext_attr_1, null, null, null,
947: null, null, fnd_global.user_id,

Line 992: ( POS_BUS_CLASS_ATTR_S.NEXTVAL , p_cert_num,

988: party_id, lookup_type, lookup_code, start_date_active,
989: vendor_id, party_site_id, vendor_site_id
990: )
991: values
992: ( POS_BUS_CLASS_ATTR_S.NEXTVAL , p_cert_num,
993: p_cert_agency, p_exp_date,
994: 'APPROVED', 'A', fnd_global.user_id, sysdate,
995: p_ext_attr_1, null, null, null,
996: null, null, fnd_global.user_id,

Line 1063: select pos_bus_class_attr_s.nextval

1059: where classification_id = p_classification_id;
1060:
1061: else
1062:
1063: select pos_bus_class_attr_s.nextval
1064: into l_class_id
1065: from dual;
1066:
1067: -- approving pending data