DBA Data[Home] [Help]

APPS.PA_PAGE_CONTENTS_PKG dependencies on FND_GLOBAL

Line 61: fnd_global.user_id,

57: P_PK4_VALUE,
58: P_PK5_VALUE,
59: empty_clob(),
60: 1,
61: fnd_global.user_id,
62: fnd_global.user_id,
63: sysdate,
64: sysdate,
65: fnd_global.user_id

Line 62: fnd_global.user_id,

58: P_PK5_VALUE,
59: empty_clob(),
60: 1,
61: fnd_global.user_id,
62: fnd_global.user_id,
63: sysdate,
64: sysdate,
65: fnd_global.user_id
66: );

Line 65: fnd_global.user_id

61: fnd_global.user_id,
62: fnd_global.user_id,
63: sysdate,
64: sysdate,
65: fnd_global.user_id
66: );
67:
68:
69: open c;

Line 103: LAST_UPDATED_BY = fnd_global.user_id,

99:
100: update PA_PAGE_CONTENTS set
101: PAGE_CONTENT = empty_clob(),
102: RECORD_VERSION_NUMBER = record_version_number +1,
103: LAST_UPDATED_BY = fnd_global.user_id,
104: LAST_UPDATE_DATE = sysdate,
105: LAST_UPDATE_LOGIN = fnd_global.login_id
106: where page_content_id = p_page_content_id;
107: --AND record_version_number = Nvl(p_record_version_number, record_version_number);

Line 105: LAST_UPDATE_LOGIN = fnd_global.login_id

101: PAGE_CONTENT = empty_clob(),
102: RECORD_VERSION_NUMBER = record_version_number +1,
103: LAST_UPDATED_BY = fnd_global.user_id,
104: LAST_UPDATE_DATE = sysdate,
105: LAST_UPDATE_LOGIN = fnd_global.login_id
106: where page_content_id = p_page_content_id;
107: --AND record_version_number = Nvl(p_record_version_number, record_version_number);
108:
109: if (sql%notfound) then

Line 147: LAST_UPDATED_BY = fnd_global.user_id,

143: PK4_VALUE = Nvl(P_PK4_VALUE, PK4_VALUE),
144: PK5_VALUE = Nvl(P_PK5_VALUE, PK5_VALUE),
145:
146: RECORD_VERSION_NUMBER = record_version_number +1,
147: LAST_UPDATED_BY = fnd_global.user_id,
148: LAST_UPDATE_DATE = sysdate,
149: LAST_UPDATE_LOGIN = fnd_global.login_id
150: where page_content_id = p_page_content_id
151: AND record_version_number = Nvl(p_record_version_number, record_version_number);

Line 149: LAST_UPDATE_LOGIN = fnd_global.login_id

145:
146: RECORD_VERSION_NUMBER = record_version_number +1,
147: LAST_UPDATED_BY = fnd_global.user_id,
148: LAST_UPDATE_DATE = sysdate,
149: LAST_UPDATE_LOGIN = fnd_global.login_id
150: where page_content_id = p_page_content_id
151: AND record_version_number = Nvl(p_record_version_number, record_version_number);
152:
153: if (sql%notfound) then