70: DECODE( X_BLANK_LINES_BEFORE, FND_API.G_MISS_NUM, NULL, X_BLANK_LINES_BEFORE ),
71: DECODE( X_BLANK_LINES_AFTER, FND_API.G_MISS_NUM, NULL, X_BLANK_LINES_AFTER ),
72: DECODE( X_START_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, X_START_DATE_ACTIVE ),
73: DECODE( X_END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, X_END_DATE_ACTIVE ),
74: NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.CREATED_BY),
75: HZ_UTILITY_V2PUB.CREATION_DATE,
76: NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN),
77: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
78: NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.LAST_UPDATED_BY),
71: DECODE( X_BLANK_LINES_AFTER, FND_API.G_MISS_NUM, NULL, X_BLANK_LINES_AFTER ),
72: DECODE( X_START_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, X_START_DATE_ACTIVE ),
73: DECODE( X_END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, X_END_DATE_ACTIVE ),
74: NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.CREATED_BY),
75: HZ_UTILITY_V2PUB.CREATION_DATE,
76: NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN),
77: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
78: NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.LAST_UPDATED_BY),
79: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER )
72: DECODE( X_START_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, X_START_DATE_ACTIVE ),
73: DECODE( X_END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, X_END_DATE_ACTIVE ),
74: NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.CREATED_BY),
75: HZ_UTILITY_V2PUB.CREATION_DATE,
76: NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN),
77: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
78: NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.LAST_UPDATED_BY),
79: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER )
80: ) RETURNING
73: DECODE( X_END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, X_END_DATE_ACTIVE ),
74: NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.CREATED_BY),
75: HZ_UTILITY_V2PUB.CREATION_DATE,
76: NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN),
77: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
78: NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.LAST_UPDATED_BY),
79: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER )
80: ) RETURNING
81: STYLE_FMT_LAYOUT_ID
74: NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.CREATED_BY),
75: HZ_UTILITY_V2PUB.CREATION_DATE,
76: NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN),
77: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
78: NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.LAST_UPDATED_BY),
79: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER )
80: ) RETURNING
81: STYLE_FMT_LAYOUT_ID
82: INTO
94: SOURCE_LANG
95: ) select
96: X_STYLE_FMT_LAYOUT_ID,
97: DECODE( X_PROMPT, FND_API.G_MISS_CHAR, NULL, X_PROMPT ),
98: NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.CREATED_BY),
99: HZ_UTILITY_V2PUB.CREATION_DATE,
100: NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN),
101: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
102: NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.LAST_UPDATED_BY),
95: ) select
96: X_STYLE_FMT_LAYOUT_ID,
97: DECODE( X_PROMPT, FND_API.G_MISS_CHAR, NULL, X_PROMPT ),
98: NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.CREATED_BY),
99: HZ_UTILITY_V2PUB.CREATION_DATE,
100: NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN),
101: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
102: NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.LAST_UPDATED_BY),
103: L.LANGUAGE_CODE,
96: X_STYLE_FMT_LAYOUT_ID,
97: DECODE( X_PROMPT, FND_API.G_MISS_CHAR, NULL, X_PROMPT ),
98: NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.CREATED_BY),
99: HZ_UTILITY_V2PUB.CREATION_DATE,
100: NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN),
101: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
102: NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.LAST_UPDATED_BY),
103: L.LANGUAGE_CODE,
104: userenv('LANG')
97: DECODE( X_PROMPT, FND_API.G_MISS_CHAR, NULL, X_PROMPT ),
98: NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.CREATED_BY),
99: HZ_UTILITY_V2PUB.CREATION_DATE,
100: NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN),
101: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
102: NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.LAST_UPDATED_BY),
103: L.LANGUAGE_CODE,
104: userenv('LANG')
105: from FND_LANGUAGES L
98: NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.CREATED_BY),
99: HZ_UTILITY_V2PUB.CREATION_DATE,
100: NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN),
101: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
102: NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.LAST_UPDATED_BY),
103: L.LANGUAGE_CODE,
104: userenv('LANG')
105: from FND_LANGUAGES L
106: where L.INSTALLED_FLAG in ('I', 'B')
253: BLANK_LINES_BEFORE = DECODE( X_BLANK_LINES_BEFORE, NULL, BLANK_LINES_BEFORE, FND_API.G_MISS_NUM, NULL, X_BLANK_LINES_BEFORE ),
254: BLANK_LINES_AFTER = DECODE( X_BLANK_LINES_AFTER, NULL, BLANK_LINES_AFTER, FND_API.G_MISS_NUM, NULL, X_BLANK_LINES_AFTER ),
255: START_DATE_ACTIVE = DECODE( X_START_DATE_ACTIVE, NULL, START_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, X_START_DATE_ACTIVE ),
256: END_DATE_ACTIVE = DECODE( X_END_DATE_ACTIVE, NULL, END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, X_END_DATE_ACTIVE ),
257: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
258: LAST_UPDATED_BY = NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.LAST_UPDATED_BY),
259: LAST_UPDATE_LOGIN = NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN),
260: OBJECT_VERSION_NUMBER = DECODE(X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER,
261: FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER)
254: BLANK_LINES_AFTER = DECODE( X_BLANK_LINES_AFTER, NULL, BLANK_LINES_AFTER, FND_API.G_MISS_NUM, NULL, X_BLANK_LINES_AFTER ),
255: START_DATE_ACTIVE = DECODE( X_START_DATE_ACTIVE, NULL, START_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, X_START_DATE_ACTIVE ),
256: END_DATE_ACTIVE = DECODE( X_END_DATE_ACTIVE, NULL, END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, X_END_DATE_ACTIVE ),
257: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
258: LAST_UPDATED_BY = NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.LAST_UPDATED_BY),
259: LAST_UPDATE_LOGIN = NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN),
260: OBJECT_VERSION_NUMBER = DECODE(X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER,
261: FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER)
262: where STYLE_FMT_LAYOUT_ID = X_STYLE_FMT_LAYOUT_ID;
255: START_DATE_ACTIVE = DECODE( X_START_DATE_ACTIVE, NULL, START_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, X_START_DATE_ACTIVE ),
256: END_DATE_ACTIVE = DECODE( X_END_DATE_ACTIVE, NULL, END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, X_END_DATE_ACTIVE ),
257: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
258: LAST_UPDATED_BY = NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.LAST_UPDATED_BY),
259: LAST_UPDATE_LOGIN = NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN),
260: OBJECT_VERSION_NUMBER = DECODE(X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER,
261: FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER)
262: where STYLE_FMT_LAYOUT_ID = X_STYLE_FMT_LAYOUT_ID;
263:
266: end if;
267:
268: update HZ_STYLE_FMT_LAYOUTS_TL set
269: PROMPT = DECODE( X_PROMPT, NULL, PROMPT, FND_API.G_MISS_CHAR, NULL, X_PROMPT ),
270: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
271: LAST_UPDATED_BY = NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.LAST_UPDATED_BY),
272: LAST_UPDATE_LOGIN = NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN),
273: SOURCE_LANG = userenv('LANG')
274: where STYLE_FMT_LAYOUT_ID = X_STYLE_FMT_LAYOUT_ID
267:
268: update HZ_STYLE_FMT_LAYOUTS_TL set
269: PROMPT = DECODE( X_PROMPT, NULL, PROMPT, FND_API.G_MISS_CHAR, NULL, X_PROMPT ),
270: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
271: LAST_UPDATED_BY = NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.LAST_UPDATED_BY),
272: LAST_UPDATE_LOGIN = NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN),
273: SOURCE_LANG = userenv('LANG')
274: where STYLE_FMT_LAYOUT_ID = X_STYLE_FMT_LAYOUT_ID
275: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
268: update HZ_STYLE_FMT_LAYOUTS_TL set
269: PROMPT = DECODE( X_PROMPT, NULL, PROMPT, FND_API.G_MISS_CHAR, NULL, X_PROMPT ),
270: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
271: LAST_UPDATED_BY = NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.LAST_UPDATED_BY),
272: LAST_UPDATE_LOGIN = NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN),
273: SOURCE_LANG = userenv('LANG')
274: where STYLE_FMT_LAYOUT_ID = X_STYLE_FMT_LAYOUT_ID
275: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
276: