APPS.STGLN_ASSG_PKG dependencies on WMS_STAGINGLANES_ASSIGNMENTS

Line 34: select ROWID from WMS_STAGINGLANES_ASSIGNMENTS

30: X_ATTRIBUTE14 in VARCHAR2,
31: X_ATTRIBUTE15 in VARCHAR2
32: ) is
33: cursor get_row is
34: select ROWID from WMS_STAGINGLANES_ASSIGNMENTS
35: where DOCK_DOOR_ID = X_DOCK_DOOR_ID
36: and DOCK_DOOR_ORGANIZATION_ID = X_DOCK_DOOR_ORGANIZATION_ID
37: AND STAGE_LANE_ID = X_STAGE_LANE_ID
38: and STAGING_LANE_ORGANIZATION_ID = X_STAGING_LANE_ORGANIZATION_ID

Line 41: insert into WMS_STAGINGLANES_ASSIGNMENTS (

37: AND STAGE_LANE_ID = X_STAGE_LANE_ID
38: and STAGING_LANE_ORGANIZATION_ID = X_STAGING_LANE_ORGANIZATION_ID
39: and ENTRY_SEQUENCE = X_ENTRY_SEQUENCE;
40: begin
41: insert into WMS_STAGINGLANES_ASSIGNMENTS (
42: DOCK_DOOR_ID,
43: STAGE_LANE_ID,
44: DOCK_DOOR_ORGANIZATION_ID,
45: STAGING_LANE_ORGANIZATION_ID,

Line 168: from WMS_STAGINGLANES_ASSIGNMENTS

164: ATTRIBUTE12,
165: ATTRIBUTE13,
166: ATTRIBUTE14,
167: ATTRIBUTE15
168: from WMS_STAGINGLANES_ASSIGNMENTS
169: where ROWID = X_ROWID
170: for update of DOCK_DOOR_ID nowait;
171: recinfo get_lock%rowtype;
172:

Line 260: update WMS_STAGINGLANES_ASSIGNMENTS set

256: X_ATTRIBUTE14 in VARCHAR2,
257: X_ATTRIBUTE15 in VARCHAR2)
258: is
259: begin
260: update WMS_STAGINGLANES_ASSIGNMENTS set
261: STAGE_LANE_ID = X_STAGE_LANE_ID,
262: STAGING_LANE_ORGANIZATION_ID = X_STAGING_LANE_ORGANIZATION_ID,
263: ENABLED = X_ENABLED,
264: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 301: delete from WMS_STAGINGLANES_ASSIGNMENTS

297: X_DOCK_DOOR_ORGANIZATION_ID in NUMBER,
298: X_ENTRY_SEQUENCE in NUMBER)
299: is
300: begin
301: delete from WMS_STAGINGLANES_ASSIGNMENTS
302: where DOCK_DOOR_ID = X_DOCK_DOOR_ID
303: and DOCK_DOOR_ORGANIZATION_ID = X_DOCK_DOOR_ORGANIZATION_ID
304: and ENTRY_SEQUENCE = X_ENTRY_SEQUENCE;
305: