APPS.WMS_XDOCK_SRC_ASSIGN_PKG dependencies on WMS_XDOCK_SOURCE_ASSIGNMENTS

Line 15: insert into WMS_XDOCK_SOURCE_ASSIGNMENTS (

11: X_LAST_UPDATED_BY in NUMBER,
12: X_LAST_UPDATE_LOGIN in NUMBER
13: ) is
14: begin
15: insert into WMS_XDOCK_SOURCE_ASSIGNMENTS (
16: CRITERION_ID,
17: SOURCE_TYPE,
18: SOURCE_CODE,
19: PRIORITY,

Line 47: from WMS_XDOCK_SOURCE_ASSIGNMENTS

43: X_PRIORITY in NUMBER
44: ) is
45: cursor c is select
46: PRIORITY
47: from WMS_XDOCK_SOURCE_ASSIGNMENTS
48: where CRITERION_ID = X_CRITERION_ID
49: and SOURCE_TYPE = X_SOURCE_TYPE
50: and SOURCE_CODE = X_SOURCE_CODE
51: for update nowait;

Line 83: update WMS_XDOCK_SOURCE_ASSIGNMENTS set

79: X_LAST_UPDATED_BY in NUMBER,
80: X_LAST_UPDATE_LOGIN in NUMBER
81: ) is
82: begin
83: update WMS_XDOCK_SOURCE_ASSIGNMENTS set
84: PRIORITY = X_PRIORITY,
85: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
86: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
87: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN

Line 104: delete from WMS_XDOCK_SOURCE_ASSIGNMENTS

100: X_SOURCE_TYPE in NUMBER,
101: X_SOURCE_CODE in NUMBER
102: ) is
103: begin
104: delete from WMS_XDOCK_SOURCE_ASSIGNMENTS
105: where CRITERION_ID = X_CRITERION_ID
106: and SOURCE_TYPE = X_SOURCE_TYPE
107: and SOURCE_CODE = X_SOURCE_CODE;
108: