APPS.FND_SIF_SETTINGS_PKG dependencies on FND_SIF_SETTINGS

Line 1: package body FND_SIF_SETTINGS_PKG as

1: package body FND_SIF_SETTINGS_PKG as
2: /* $Header: FNDSFSTB.pls 120.0.12020000.2 2013/04/09 18:10:58 alsosa noship $ */
3:
4: procedure INSERT_ROW (
5: X_DEFINITION_NAME in VARCHAR2,

Line 21: cursor C is select ROWID from FND_SIF_SETTINGS

17: ) is
18: l_ROWID VARCHAR2(100);
19: l_luby number := FND_LOAD_UTIL.OWNER_ID(X_OWNER);
20: l_ludate date := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
21: cursor C is select ROWID from FND_SIF_SETTINGS
22: where DEFINITION_NAME = X_DEFINITION_NAME;
23: begin
24: insert into FND_SIF_SETTINGS (
25: HANDLER_CLASS,

Line 24: insert into FND_SIF_SETTINGS (

20: l_ludate date := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
21: cursor C is select ROWID from FND_SIF_SETTINGS
22: where DEFINITION_NAME = X_DEFINITION_NAME;
23: begin
24: insert into FND_SIF_SETTINGS (
25: HANDLER_CLASS,
26: DEFINITION_NAME,
27: JAXB_INPUT,
28: JAXB_OUTPUT,

Line 63: raise_application_error (-20000, 'FND_SIF_SETTINGS_PKG.INSERT_ROW: unable to create SIF setting '||X_DEFINITION_NAME);

59: open c;
60: fetch c into l_ROWID;
61: if (c%notfound) then
62: close c;
63: raise_application_error (-20000, 'FND_SIF_SETTINGS_PKG.INSERT_ROW: unable to create SIF setting '||X_DEFINITION_NAME);
64: end if;
65: close c;
66:
67: end INSERT_ROW;

Line 86: update FND_SIF_SETTINGS set

82: ) is
83: l_luby number := FND_LOAD_UTIL.OWNER_ID(X_OWNER);
84: l_ludate date := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
85: begin
86: update FND_SIF_SETTINGS set
87: HANDLER_CLASS = X_HANDLER_CLASS,
88: JAXB_INPUT = X_JAXB_INPUT,
89: JAXB_OUTPUT = X_JAXB_OUTPUT,
90: CALLBACK_AGENT = X_CALLBACK_AGENT,

Line 116: end FND_SIF_SETTINGS_PKG;

112: X_LAST_UPDATE_DATE => UPDATE_ROW.X_LAST_UPDATE_DATE,
113: X_OWNER => UPDATE_ROW.X_OWNER);
114: end if;
115: end UPDATE_ROW;
116: end FND_SIF_SETTINGS_PKG;