APPS.WF_WL_RULES_PKG dependencies on FND_LOAD_UTIL

Line 31: l_luby number := FND_LOAD_UTIL.OWNER_ID(X_OWNER);

27: --cursor c_newrow is select ROWID from WF_WL_RULES
28: cursor c_newrow is select ROWID from WF_WL_RULES
29: where RULE_KEY = X_RULE_KEY;
30: l_rowid VARCHAR2(30);
31: l_luby number := FND_LOAD_UTIL.OWNER_ID(X_OWNER);
32: l_ludate date := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
33: begin
34: insert into WF_WL_RULES (RULE_ID,
35: RULE_KEY,

Line 140: l_luby number := FND_LOAD_UTIL.OWNER_ID(X_OWNER);

136: X_RULE_NAME in VARCHAR2,
137: X_OWNER IN VARCHAR2,
138: X_LAST_UPDATE_DATE IN VARCHAR2) is
139: l_rule_id number := FIND_RULE_ID(X_RULE_KEY);
140: l_luby number := FND_LOAD_UTIL.OWNER_ID(X_OWNER);
141: l_ludate date := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
142: BEGIN
143: UPDATE WF_WL_RULES_TL TL
144: SET TL.RULE_NAME = X_RULE_NAME,

Line 167: l_luby number := FND_LOAD_UTIL.OWNER_ID(X_OWNER);

163: X_OPERAND in VARCHAR2,
164: X_OWNER IN VARCHAR2,
165: X_LAST_UPDATE_DATE IN VARCHAR2)
166: is
167: l_luby number := FND_LOAD_UTIL.OWNER_ID(X_OWNER);
168: l_ludate date := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
169: begin
170: update WF_WL_RULES B
171: set --ITEM_TYPE = X_ITEM_TYPE,

Line 205: l_luby number := FND_LOAD_UTIL.OWNER_ID(X_OWNER);

201: X_OWNER IN VARCHAR2,
202: X_LAST_UPDATE_DATE IN VARCHAR2) is
203: l_region_id number := WF_WL_REGIONS_PKG.FIND_REGION_ID(X_REGION_KEY);
204: l_rule_id number := WF_WL_RULES_PKG.FIND_RULE_ID(X_RULE_KEY);
205: l_luby number := FND_LOAD_UTIL.OWNER_ID(X_OWNER);
206: l_ludate date := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
207: begin
208: begin
209: insert into WF_WL_REGION_RULES (REGION_ID,