APPS.FND_SIF_POLICY_PROPS_PKG dependencies on FND_SIF_POLICY_PROPS

Line 1: package body FND_SIF_POLICY_PROPS_PKG as

1: package body FND_SIF_POLICY_PROPS_PKG as
2: /* $Header: FNDSFPPB.pls 120.0.12020000.2 2013/05/03 21:37:35 alsosa noship $ */
3:
4: procedure INSERT_ROW (
5: X_DEFINITION_NAME in VARCHAR2,

Line 15: cursor C is select ROWID from FND_SIF_POLICY_PROPS

11: ) is
12: l_ROWID VARCHAR2(100);
13: l_luby number := FND_LOAD_UTIL.OWNER_ID(X_OWNER);
14: l_ludate date := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
15: cursor C is select ROWID from FND_SIF_POLICY_PROPS
16: where DEFINITION_NAME = X_DEFINITION_NAME
17: and POLICY_NAME = X_POLICY_NAME;
18: begin
19: insert into FND_SIF_POLICY_PROPS (

Line 19: insert into FND_SIF_POLICY_PROPS (

15: cursor C is select ROWID from FND_SIF_POLICY_PROPS
16: where DEFINITION_NAME = X_DEFINITION_NAME
17: and POLICY_NAME = X_POLICY_NAME;
18: begin
19: insert into FND_SIF_POLICY_PROPS (
20: PROP_NAME,
21: PROP_VALUE,
22: POLICY_NAME,
23: DEFINITION_NAME,

Line 46: raise_application_error (-20000, 'FND_SIF_POLICY_PROPS_PKG.INSERT_ROW: unable to create property '||X_PROP_NAME||' for policy '||X_POLICY_NAME);

42: open c;
43: fetch c into l_ROWID;
44: if (c%notfound) then
45: close c;
46: raise_application_error (-20000, 'FND_SIF_POLICY_PROPS_PKG.INSERT_ROW: unable to create property '||X_PROP_NAME||' for policy '||X_POLICY_NAME);
47: end if;
48: close c;
49:
50: end INSERT_ROW;

Line 63: update FND_SIF_POLICY_PROPS set

59: ) is
60: l_luby number := FND_LOAD_UTIL.OWNER_ID(X_OWNER);
61: l_ludate date := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
62: begin
63: update FND_SIF_POLICY_PROPS set
64: PROP_NAME = X_PROP_NAME,
65: PROP_VALUE = X_PROP_VALUE,
66: POLICY_NAME = X_POLICY_NAME,
67: LAST_UPDATE_DATE = l_ludate,

Line 89: from FND_SIF_POLICY_PROPS

85: l_password_set VARCHAR2(1) := 'Y';
86: l_row_cnt number;
87: begin
88: select count(1) into l_row_cnt
89: from FND_SIF_POLICY_PROPS
90: where DEFINITION_NAME=X_DEFINITION_NAME
91: and POLICY_NAME='UsernameToken'
92: and PROP_NAME in ('username','passwordKey', 'passwordMod')
93: and PROP_VALUE is not null;

Line 100: end FND_SIF_POLICY_PROPS_PKG;

96: l_password_set := 'N';
97: end if;
98: return l_password_set;
99: end IS_PASSWORD_DEFINED;
100: end FND_SIF_POLICY_PROPS_PKG;