1: package body FND_SIF_ATTACHMENTS_PKG as
2: /* $Header: FNDSFATB.pls 120.0.12020000.1 2013/04/08 19:38:19 alsosa noship $ */
3:
4: procedure INSERT_ROW (
5: X_DEFINITION_NAME in VARCHAR2,
12: ) is
13: l_ROWID VARCHAR2(100);
14: l_luby number := FND_LOAD_UTIL.OWNER_ID(X_OWNER);
15: l_ludate date := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
16: cursor C is select ROWID from FND_SIF_ATTACHMENTS
17: where DEFINITION_NAME = X_DEFINITION_NAME
18: and ELEMENT_NAME = X_ELEMENT_NAME;
19: begin
20: insert into FND_SIF_ATTACHMENTS (
16: cursor C is select ROWID from FND_SIF_ATTACHMENTS
17: where DEFINITION_NAME = X_DEFINITION_NAME
18: and ELEMENT_NAME = X_ELEMENT_NAME;
19: begin
20: insert into FND_SIF_ATTACHMENTS (
21: DEFINITION_NAME,
22: ELEMENT_NAME,
23: ELEMENT_NS,
24: UNBOUNDED,
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_ATTACHMENTS set
64: UNBOUNDED = X_UNBOUNDED,
65: ELEMENT_NS = X_ELEMENT_NS,
66: LAST_UPDATE_DATE = l_ludate,
67: LAST_UPDATED_BY = l_luby
76: X_LAST_UPDATE_DATE => UPDATE_ROW.X_LAST_UPDATE_DATE,
77: X_OWNER => UPDATE_ROW.X_OWNER);
78: end if;
79: end UPDATE_ROW;
80: end FND_SIF_ATTACHMENTS_PKG;