eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_STYLE_FMT_LAYOUTS_PKG dependencies on FND_API

Line 57: DECODE( X_STYLE_FMT_LAYOUT_ID, FND_API.G_MISS_NUM, HZ_STYLE_FMT_LAYOUTS_S.NEXTVAL, NULL, HZ_STYLE_FMT_LAYOUTS_S.NEXTVAL, X_STYLE_FMT_LAYOUT_ID ),

53: LAST_UPDATE_DATE,
54: LAST_UPDATED_BY,
55: OBJECT_VERSION_NUMBER
56: ) values (
57: DECODE( X_STYLE_FMT_LAYOUT_ID, FND_API.G_MISS_NUM, HZ_STYLE_FMT_LAYOUTS_S.NEXTVAL, NULL, HZ_STYLE_FMT_LAYOUTS_S.NEXTVAL, X_STYLE_FMT_LAYOUT_ID ),
58: DECODE( X_STYLE_FORMAT_CODE, FND_API.G_MISS_CHAR, NULL, X_STYLE_FORMAT_CODE ),
59: DECODE( X_VARIATION_NUMBER, FND_API.G_MISS_NUM, NULL, X_VARIATION_NUMBER ),
60: DECODE( X_ATTRIBUTE_CODE, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CODE ),
61: DECODE( X_ATTRIBUTE_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_ATTRIBUTE_APPLICATION_ID ),

Line 58: DECODE( X_STYLE_FORMAT_CODE, FND_API.G_MISS_CHAR, NULL, X_STYLE_FORMAT_CODE ),

54: LAST_UPDATED_BY,
55: OBJECT_VERSION_NUMBER
56: ) values (
57: DECODE( X_STYLE_FMT_LAYOUT_ID, FND_API.G_MISS_NUM, HZ_STYLE_FMT_LAYOUTS_S.NEXTVAL, NULL, HZ_STYLE_FMT_LAYOUTS_S.NEXTVAL, X_STYLE_FMT_LAYOUT_ID ),
58: DECODE( X_STYLE_FORMAT_CODE, FND_API.G_MISS_CHAR, NULL, X_STYLE_FORMAT_CODE ),
59: DECODE( X_VARIATION_NUMBER, FND_API.G_MISS_NUM, NULL, X_VARIATION_NUMBER ),
60: DECODE( X_ATTRIBUTE_CODE, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CODE ),
61: DECODE( X_ATTRIBUTE_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_ATTRIBUTE_APPLICATION_ID ),
62: DECODE( X_LINE_NUMBER, FND_API.G_MISS_NUM, NULL, X_LINE_NUMBER ),

Line 59: DECODE( X_VARIATION_NUMBER, FND_API.G_MISS_NUM, NULL, X_VARIATION_NUMBER ),

55: OBJECT_VERSION_NUMBER
56: ) values (
57: DECODE( X_STYLE_FMT_LAYOUT_ID, FND_API.G_MISS_NUM, HZ_STYLE_FMT_LAYOUTS_S.NEXTVAL, NULL, HZ_STYLE_FMT_LAYOUTS_S.NEXTVAL, X_STYLE_FMT_LAYOUT_ID ),
58: DECODE( X_STYLE_FORMAT_CODE, FND_API.G_MISS_CHAR, NULL, X_STYLE_FORMAT_CODE ),
59: DECODE( X_VARIATION_NUMBER, FND_API.G_MISS_NUM, NULL, X_VARIATION_NUMBER ),
60: DECODE( X_ATTRIBUTE_CODE, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CODE ),
61: DECODE( X_ATTRIBUTE_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_ATTRIBUTE_APPLICATION_ID ),
62: DECODE( X_LINE_NUMBER, FND_API.G_MISS_NUM, NULL, X_LINE_NUMBER ),
63: DECODE( X_POSITION, FND_API.G_MISS_NUM, NULL, X_POSITION ),

Line 60: DECODE( X_ATTRIBUTE_CODE, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CODE ),

56: ) values (
57: DECODE( X_STYLE_FMT_LAYOUT_ID, FND_API.G_MISS_NUM, HZ_STYLE_FMT_LAYOUTS_S.NEXTVAL, NULL, HZ_STYLE_FMT_LAYOUTS_S.NEXTVAL, X_STYLE_FMT_LAYOUT_ID ),
58: DECODE( X_STYLE_FORMAT_CODE, FND_API.G_MISS_CHAR, NULL, X_STYLE_FORMAT_CODE ),
59: DECODE( X_VARIATION_NUMBER, FND_API.G_MISS_NUM, NULL, X_VARIATION_NUMBER ),
60: DECODE( X_ATTRIBUTE_CODE, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CODE ),
61: DECODE( X_ATTRIBUTE_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_ATTRIBUTE_APPLICATION_ID ),
62: DECODE( X_LINE_NUMBER, FND_API.G_MISS_NUM, NULL, X_LINE_NUMBER ),
63: DECODE( X_POSITION, FND_API.G_MISS_NUM, NULL, X_POSITION ),
64: DECODE( X_MANDATORY_FLAG, FND_API.G_MISS_CHAR, NULL, X_MANDATORY_FLAG ),

Line 61: DECODE( X_ATTRIBUTE_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_ATTRIBUTE_APPLICATION_ID ),

57: DECODE( X_STYLE_FMT_LAYOUT_ID, FND_API.G_MISS_NUM, HZ_STYLE_FMT_LAYOUTS_S.NEXTVAL, NULL, HZ_STYLE_FMT_LAYOUTS_S.NEXTVAL, X_STYLE_FMT_LAYOUT_ID ),
58: DECODE( X_STYLE_FORMAT_CODE, FND_API.G_MISS_CHAR, NULL, X_STYLE_FORMAT_CODE ),
59: DECODE( X_VARIATION_NUMBER, FND_API.G_MISS_NUM, NULL, X_VARIATION_NUMBER ),
60: DECODE( X_ATTRIBUTE_CODE, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CODE ),
61: DECODE( X_ATTRIBUTE_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_ATTRIBUTE_APPLICATION_ID ),
62: DECODE( X_LINE_NUMBER, FND_API.G_MISS_NUM, NULL, X_LINE_NUMBER ),
63: DECODE( X_POSITION, FND_API.G_MISS_NUM, NULL, X_POSITION ),
64: DECODE( X_MANDATORY_FLAG, FND_API.G_MISS_CHAR, NULL, X_MANDATORY_FLAG ),
65: DECODE( X_USE_INITIAL_FLAG, FND_API.G_MISS_CHAR, NULL, X_USE_INITIAL_FLAG ),

Line 62: DECODE( X_LINE_NUMBER, FND_API.G_MISS_NUM, NULL, X_LINE_NUMBER ),

58: DECODE( X_STYLE_FORMAT_CODE, FND_API.G_MISS_CHAR, NULL, X_STYLE_FORMAT_CODE ),
59: DECODE( X_VARIATION_NUMBER, FND_API.G_MISS_NUM, NULL, X_VARIATION_NUMBER ),
60: DECODE( X_ATTRIBUTE_CODE, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CODE ),
61: DECODE( X_ATTRIBUTE_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_ATTRIBUTE_APPLICATION_ID ),
62: DECODE( X_LINE_NUMBER, FND_API.G_MISS_NUM, NULL, X_LINE_NUMBER ),
63: DECODE( X_POSITION, FND_API.G_MISS_NUM, NULL, X_POSITION ),
64: DECODE( X_MANDATORY_FLAG, FND_API.G_MISS_CHAR, NULL, X_MANDATORY_FLAG ),
65: DECODE( X_USE_INITIAL_FLAG, FND_API.G_MISS_CHAR, NULL, X_USE_INITIAL_FLAG ),
66: DECODE( X_UPPERCASE_FLAG, FND_API.G_MISS_CHAR, NULL, X_UPPERCASE_FLAG ),

Line 63: DECODE( X_POSITION, FND_API.G_MISS_NUM, NULL, X_POSITION ),

59: DECODE( X_VARIATION_NUMBER, FND_API.G_MISS_NUM, NULL, X_VARIATION_NUMBER ),
60: DECODE( X_ATTRIBUTE_CODE, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CODE ),
61: DECODE( X_ATTRIBUTE_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_ATTRIBUTE_APPLICATION_ID ),
62: DECODE( X_LINE_NUMBER, FND_API.G_MISS_NUM, NULL, X_LINE_NUMBER ),
63: DECODE( X_POSITION, FND_API.G_MISS_NUM, NULL, X_POSITION ),
64: DECODE( X_MANDATORY_FLAG, FND_API.G_MISS_CHAR, NULL, X_MANDATORY_FLAG ),
65: DECODE( X_USE_INITIAL_FLAG, FND_API.G_MISS_CHAR, NULL, X_USE_INITIAL_FLAG ),
66: DECODE( X_UPPERCASE_FLAG, FND_API.G_MISS_CHAR, NULL, X_UPPERCASE_FLAG ),
67: DECODE( X_TRANSFORM_FUNCTION, FND_API.G_MISS_CHAR, NULL, X_TRANSFORM_FUNCTION ),

Line 64: DECODE( X_MANDATORY_FLAG, FND_API.G_MISS_CHAR, NULL, X_MANDATORY_FLAG ),

60: DECODE( X_ATTRIBUTE_CODE, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CODE ),
61: DECODE( X_ATTRIBUTE_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_ATTRIBUTE_APPLICATION_ID ),
62: DECODE( X_LINE_NUMBER, FND_API.G_MISS_NUM, NULL, X_LINE_NUMBER ),
63: DECODE( X_POSITION, FND_API.G_MISS_NUM, NULL, X_POSITION ),
64: DECODE( X_MANDATORY_FLAG, FND_API.G_MISS_CHAR, NULL, X_MANDATORY_FLAG ),
65: DECODE( X_USE_INITIAL_FLAG, FND_API.G_MISS_CHAR, NULL, X_USE_INITIAL_FLAG ),
66: DECODE( X_UPPERCASE_FLAG, FND_API.G_MISS_CHAR, NULL, X_UPPERCASE_FLAG ),
67: DECODE( X_TRANSFORM_FUNCTION, FND_API.G_MISS_CHAR, NULL, X_TRANSFORM_FUNCTION ),
68: DECODE( X_DELIMITER_BEFORE, FND_API.G_MISS_CHAR, NULL, X_DELIMITER_BEFORE ),

Line 65: DECODE( X_USE_INITIAL_FLAG, FND_API.G_MISS_CHAR, NULL, X_USE_INITIAL_FLAG ),

61: DECODE( X_ATTRIBUTE_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_ATTRIBUTE_APPLICATION_ID ),
62: DECODE( X_LINE_NUMBER, FND_API.G_MISS_NUM, NULL, X_LINE_NUMBER ),
63: DECODE( X_POSITION, FND_API.G_MISS_NUM, NULL, X_POSITION ),
64: DECODE( X_MANDATORY_FLAG, FND_API.G_MISS_CHAR, NULL, X_MANDATORY_FLAG ),
65: DECODE( X_USE_INITIAL_FLAG, FND_API.G_MISS_CHAR, NULL, X_USE_INITIAL_FLAG ),
66: DECODE( X_UPPERCASE_FLAG, FND_API.G_MISS_CHAR, NULL, X_UPPERCASE_FLAG ),
67: DECODE( X_TRANSFORM_FUNCTION, FND_API.G_MISS_CHAR, NULL, X_TRANSFORM_FUNCTION ),
68: DECODE( X_DELIMITER_BEFORE, FND_API.G_MISS_CHAR, NULL, X_DELIMITER_BEFORE ),
69: DECODE( X_DELIMITER_AFTER, FND_API.G_MISS_CHAR, NULL, X_DELIMITER_AFTER ),

Line 66: DECODE( X_UPPERCASE_FLAG, FND_API.G_MISS_CHAR, NULL, X_UPPERCASE_FLAG ),

62: DECODE( X_LINE_NUMBER, FND_API.G_MISS_NUM, NULL, X_LINE_NUMBER ),
63: DECODE( X_POSITION, FND_API.G_MISS_NUM, NULL, X_POSITION ),
64: DECODE( X_MANDATORY_FLAG, FND_API.G_MISS_CHAR, NULL, X_MANDATORY_FLAG ),
65: DECODE( X_USE_INITIAL_FLAG, FND_API.G_MISS_CHAR, NULL, X_USE_INITIAL_FLAG ),
66: DECODE( X_UPPERCASE_FLAG, FND_API.G_MISS_CHAR, NULL, X_UPPERCASE_FLAG ),
67: DECODE( X_TRANSFORM_FUNCTION, FND_API.G_MISS_CHAR, NULL, X_TRANSFORM_FUNCTION ),
68: DECODE( X_DELIMITER_BEFORE, FND_API.G_MISS_CHAR, NULL, X_DELIMITER_BEFORE ),
69: DECODE( X_DELIMITER_AFTER, FND_API.G_MISS_CHAR, NULL, X_DELIMITER_AFTER ),
70: DECODE( X_BLANK_LINES_BEFORE, FND_API.G_MISS_NUM, NULL, X_BLANK_LINES_BEFORE ),

Line 67: DECODE( X_TRANSFORM_FUNCTION, FND_API.G_MISS_CHAR, NULL, X_TRANSFORM_FUNCTION ),

63: DECODE( X_POSITION, FND_API.G_MISS_NUM, NULL, X_POSITION ),
64: DECODE( X_MANDATORY_FLAG, FND_API.G_MISS_CHAR, NULL, X_MANDATORY_FLAG ),
65: DECODE( X_USE_INITIAL_FLAG, FND_API.G_MISS_CHAR, NULL, X_USE_INITIAL_FLAG ),
66: DECODE( X_UPPERCASE_FLAG, FND_API.G_MISS_CHAR, NULL, X_UPPERCASE_FLAG ),
67: DECODE( X_TRANSFORM_FUNCTION, FND_API.G_MISS_CHAR, NULL, X_TRANSFORM_FUNCTION ),
68: DECODE( X_DELIMITER_BEFORE, FND_API.G_MISS_CHAR, NULL, X_DELIMITER_BEFORE ),
69: DECODE( X_DELIMITER_AFTER, FND_API.G_MISS_CHAR, NULL, X_DELIMITER_AFTER ),
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 ),

Line 68: DECODE( X_DELIMITER_BEFORE, FND_API.G_MISS_CHAR, NULL, X_DELIMITER_BEFORE ),

64: DECODE( X_MANDATORY_FLAG, FND_API.G_MISS_CHAR, NULL, X_MANDATORY_FLAG ),
65: DECODE( X_USE_INITIAL_FLAG, FND_API.G_MISS_CHAR, NULL, X_USE_INITIAL_FLAG ),
66: DECODE( X_UPPERCASE_FLAG, FND_API.G_MISS_CHAR, NULL, X_UPPERCASE_FLAG ),
67: DECODE( X_TRANSFORM_FUNCTION, FND_API.G_MISS_CHAR, NULL, X_TRANSFORM_FUNCTION ),
68: DECODE( X_DELIMITER_BEFORE, FND_API.G_MISS_CHAR, NULL, X_DELIMITER_BEFORE ),
69: DECODE( X_DELIMITER_AFTER, FND_API.G_MISS_CHAR, NULL, X_DELIMITER_AFTER ),
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 ),

Line 69: DECODE( X_DELIMITER_AFTER, FND_API.G_MISS_CHAR, NULL, X_DELIMITER_AFTER ),

65: DECODE( X_USE_INITIAL_FLAG, FND_API.G_MISS_CHAR, NULL, X_USE_INITIAL_FLAG ),
66: DECODE( X_UPPERCASE_FLAG, FND_API.G_MISS_CHAR, NULL, X_UPPERCASE_FLAG ),
67: DECODE( X_TRANSFORM_FUNCTION, FND_API.G_MISS_CHAR, NULL, X_TRANSFORM_FUNCTION ),
68: DECODE( X_DELIMITER_BEFORE, FND_API.G_MISS_CHAR, NULL, X_DELIMITER_BEFORE ),
69: DECODE( X_DELIMITER_AFTER, FND_API.G_MISS_CHAR, NULL, X_DELIMITER_AFTER ),
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 ),

Line 70: DECODE( X_BLANK_LINES_BEFORE, FND_API.G_MISS_NUM, NULL, X_BLANK_LINES_BEFORE ),

66: DECODE( X_UPPERCASE_FLAG, FND_API.G_MISS_CHAR, NULL, X_UPPERCASE_FLAG ),
67: DECODE( X_TRANSFORM_FUNCTION, FND_API.G_MISS_CHAR, NULL, X_TRANSFORM_FUNCTION ),
68: DECODE( X_DELIMITER_BEFORE, FND_API.G_MISS_CHAR, NULL, X_DELIMITER_BEFORE ),
69: DECODE( X_DELIMITER_AFTER, FND_API.G_MISS_CHAR, NULL, X_DELIMITER_AFTER ),
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),

Line 71: DECODE( X_BLANK_LINES_AFTER, FND_API.G_MISS_NUM, NULL, X_BLANK_LINES_AFTER ),

67: DECODE( X_TRANSFORM_FUNCTION, FND_API.G_MISS_CHAR, NULL, X_TRANSFORM_FUNCTION ),
68: DECODE( X_DELIMITER_BEFORE, FND_API.G_MISS_CHAR, NULL, X_DELIMITER_BEFORE ),
69: DECODE( X_DELIMITER_AFTER, FND_API.G_MISS_CHAR, NULL, X_DELIMITER_AFTER ),
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,

Line 72: DECODE( X_START_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, X_START_DATE_ACTIVE ),

68: DECODE( X_DELIMITER_BEFORE, FND_API.G_MISS_CHAR, NULL, X_DELIMITER_BEFORE ),
69: DECODE( X_DELIMITER_AFTER, FND_API.G_MISS_CHAR, NULL, X_DELIMITER_AFTER ),
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),

Line 73: DECODE( X_END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, X_END_DATE_ACTIVE ),

69: DECODE( X_DELIMITER_AFTER, FND_API.G_MISS_CHAR, NULL, X_DELIMITER_AFTER ),
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,

Line 79: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER )

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
83: X_STYLE_FMT_LAYOUT_ID;

Line 97: DECODE( X_PROMPT, FND_API.G_MISS_CHAR, NULL, X_PROMPT ),

93: LANGUAGE,
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,

Line 241: STYLE_FORMAT_CODE = DECODE( X_STYLE_FORMAT_CODE, NULL, STYLE_FORMAT_CODE, FND_API.G_MISS_CHAR, NULL, X_STYLE_FORMAT_CODE ),

237: X_OBJECT_VERSION_NUMBER IN NUMBER
238: ) is
239: begin
240: update HZ_STYLE_FMT_LAYOUTS_B set
241: STYLE_FORMAT_CODE = DECODE( X_STYLE_FORMAT_CODE, NULL, STYLE_FORMAT_CODE, FND_API.G_MISS_CHAR, NULL, X_STYLE_FORMAT_CODE ),
242: VARIATION_NUMBER = DECODE( X_VARIATION_NUMBER, NULL, VARIATION_NUMBER, FND_API.G_MISS_NUM, NULL, X_VARIATION_NUMBER ),
243: ATTRIBUTE_CODE = DECODE( X_ATTRIBUTE_CODE, NULL, ATTRIBUTE_CODE, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CODE ),
244: ATTRIBUTE_APPLICATION_ID = DECODE( X_ATTRIBUTE_APPLICATION_ID, NULL, ATTRIBUTE_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_ATTRIBUTE_APPLICATION_ID ),
245: LINE_NUMBER = DECODE( X_LINE_NUMBER, NULL, LINE_NUMBER, FND_API.G_MISS_NUM, NULL, X_LINE_NUMBER ),

Line 242: VARIATION_NUMBER = DECODE( X_VARIATION_NUMBER, NULL, VARIATION_NUMBER, FND_API.G_MISS_NUM, NULL, X_VARIATION_NUMBER ),

238: ) is
239: begin
240: update HZ_STYLE_FMT_LAYOUTS_B set
241: STYLE_FORMAT_CODE = DECODE( X_STYLE_FORMAT_CODE, NULL, STYLE_FORMAT_CODE, FND_API.G_MISS_CHAR, NULL, X_STYLE_FORMAT_CODE ),
242: VARIATION_NUMBER = DECODE( X_VARIATION_NUMBER, NULL, VARIATION_NUMBER, FND_API.G_MISS_NUM, NULL, X_VARIATION_NUMBER ),
243: ATTRIBUTE_CODE = DECODE( X_ATTRIBUTE_CODE, NULL, ATTRIBUTE_CODE, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CODE ),
244: ATTRIBUTE_APPLICATION_ID = DECODE( X_ATTRIBUTE_APPLICATION_ID, NULL, ATTRIBUTE_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_ATTRIBUTE_APPLICATION_ID ),
245: LINE_NUMBER = DECODE( X_LINE_NUMBER, NULL, LINE_NUMBER, FND_API.G_MISS_NUM, NULL, X_LINE_NUMBER ),
246: POSITION = DECODE( X_POSITION, NULL, POSITION, FND_API.G_MISS_NUM, NULL, X_POSITION ),

Line 243: ATTRIBUTE_CODE = DECODE( X_ATTRIBUTE_CODE, NULL, ATTRIBUTE_CODE, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CODE ),

239: begin
240: update HZ_STYLE_FMT_LAYOUTS_B set
241: STYLE_FORMAT_CODE = DECODE( X_STYLE_FORMAT_CODE, NULL, STYLE_FORMAT_CODE, FND_API.G_MISS_CHAR, NULL, X_STYLE_FORMAT_CODE ),
242: VARIATION_NUMBER = DECODE( X_VARIATION_NUMBER, NULL, VARIATION_NUMBER, FND_API.G_MISS_NUM, NULL, X_VARIATION_NUMBER ),
243: ATTRIBUTE_CODE = DECODE( X_ATTRIBUTE_CODE, NULL, ATTRIBUTE_CODE, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CODE ),
244: ATTRIBUTE_APPLICATION_ID = DECODE( X_ATTRIBUTE_APPLICATION_ID, NULL, ATTRIBUTE_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_ATTRIBUTE_APPLICATION_ID ),
245: LINE_NUMBER = DECODE( X_LINE_NUMBER, NULL, LINE_NUMBER, FND_API.G_MISS_NUM, NULL, X_LINE_NUMBER ),
246: POSITION = DECODE( X_POSITION, NULL, POSITION, FND_API.G_MISS_NUM, NULL, X_POSITION ),
247: MANDATORY_FLAG = DECODE( X_MANDATORY_FLAG, NULL, MANDATORY_FLAG, FND_API.G_MISS_CHAR, NULL, X_MANDATORY_FLAG ),

Line 244: ATTRIBUTE_APPLICATION_ID = DECODE( X_ATTRIBUTE_APPLICATION_ID, NULL, ATTRIBUTE_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_ATTRIBUTE_APPLICATION_ID ),

240: update HZ_STYLE_FMT_LAYOUTS_B set
241: STYLE_FORMAT_CODE = DECODE( X_STYLE_FORMAT_CODE, NULL, STYLE_FORMAT_CODE, FND_API.G_MISS_CHAR, NULL, X_STYLE_FORMAT_CODE ),
242: VARIATION_NUMBER = DECODE( X_VARIATION_NUMBER, NULL, VARIATION_NUMBER, FND_API.G_MISS_NUM, NULL, X_VARIATION_NUMBER ),
243: ATTRIBUTE_CODE = DECODE( X_ATTRIBUTE_CODE, NULL, ATTRIBUTE_CODE, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CODE ),
244: ATTRIBUTE_APPLICATION_ID = DECODE( X_ATTRIBUTE_APPLICATION_ID, NULL, ATTRIBUTE_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_ATTRIBUTE_APPLICATION_ID ),
245: LINE_NUMBER = DECODE( X_LINE_NUMBER, NULL, LINE_NUMBER, FND_API.G_MISS_NUM, NULL, X_LINE_NUMBER ),
246: POSITION = DECODE( X_POSITION, NULL, POSITION, FND_API.G_MISS_NUM, NULL, X_POSITION ),
247: MANDATORY_FLAG = DECODE( X_MANDATORY_FLAG, NULL, MANDATORY_FLAG, FND_API.G_MISS_CHAR, NULL, X_MANDATORY_FLAG ),
248: USE_INITIAL_FLAG = DECODE( X_USE_INITIAL_FLAG, NULL, USE_INITIAL_FLAG, FND_API.G_MISS_CHAR, NULL, X_USE_INITIAL_FLAG ),

Line 245: LINE_NUMBER = DECODE( X_LINE_NUMBER, NULL, LINE_NUMBER, FND_API.G_MISS_NUM, NULL, X_LINE_NUMBER ),

241: STYLE_FORMAT_CODE = DECODE( X_STYLE_FORMAT_CODE, NULL, STYLE_FORMAT_CODE, FND_API.G_MISS_CHAR, NULL, X_STYLE_FORMAT_CODE ),
242: VARIATION_NUMBER = DECODE( X_VARIATION_NUMBER, NULL, VARIATION_NUMBER, FND_API.G_MISS_NUM, NULL, X_VARIATION_NUMBER ),
243: ATTRIBUTE_CODE = DECODE( X_ATTRIBUTE_CODE, NULL, ATTRIBUTE_CODE, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CODE ),
244: ATTRIBUTE_APPLICATION_ID = DECODE( X_ATTRIBUTE_APPLICATION_ID, NULL, ATTRIBUTE_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_ATTRIBUTE_APPLICATION_ID ),
245: LINE_NUMBER = DECODE( X_LINE_NUMBER, NULL, LINE_NUMBER, FND_API.G_MISS_NUM, NULL, X_LINE_NUMBER ),
246: POSITION = DECODE( X_POSITION, NULL, POSITION, FND_API.G_MISS_NUM, NULL, X_POSITION ),
247: MANDATORY_FLAG = DECODE( X_MANDATORY_FLAG, NULL, MANDATORY_FLAG, FND_API.G_MISS_CHAR, NULL, X_MANDATORY_FLAG ),
248: USE_INITIAL_FLAG = DECODE( X_USE_INITIAL_FLAG, NULL, USE_INITIAL_FLAG, FND_API.G_MISS_CHAR, NULL, X_USE_INITIAL_FLAG ),
249: UPPERCASE_FLAG = DECODE( X_UPPERCASE_FLAG, NULL, UPPERCASE_FLAG, FND_API.G_MISS_CHAR, NULL, X_UPPERCASE_FLAG ),

Line 246: POSITION = DECODE( X_POSITION, NULL, POSITION, FND_API.G_MISS_NUM, NULL, X_POSITION ),

242: VARIATION_NUMBER = DECODE( X_VARIATION_NUMBER, NULL, VARIATION_NUMBER, FND_API.G_MISS_NUM, NULL, X_VARIATION_NUMBER ),
243: ATTRIBUTE_CODE = DECODE( X_ATTRIBUTE_CODE, NULL, ATTRIBUTE_CODE, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CODE ),
244: ATTRIBUTE_APPLICATION_ID = DECODE( X_ATTRIBUTE_APPLICATION_ID, NULL, ATTRIBUTE_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_ATTRIBUTE_APPLICATION_ID ),
245: LINE_NUMBER = DECODE( X_LINE_NUMBER, NULL, LINE_NUMBER, FND_API.G_MISS_NUM, NULL, X_LINE_NUMBER ),
246: POSITION = DECODE( X_POSITION, NULL, POSITION, FND_API.G_MISS_NUM, NULL, X_POSITION ),
247: MANDATORY_FLAG = DECODE( X_MANDATORY_FLAG, NULL, MANDATORY_FLAG, FND_API.G_MISS_CHAR, NULL, X_MANDATORY_FLAG ),
248: USE_INITIAL_FLAG = DECODE( X_USE_INITIAL_FLAG, NULL, USE_INITIAL_FLAG, FND_API.G_MISS_CHAR, NULL, X_USE_INITIAL_FLAG ),
249: UPPERCASE_FLAG = DECODE( X_UPPERCASE_FLAG, NULL, UPPERCASE_FLAG, FND_API.G_MISS_CHAR, NULL, X_UPPERCASE_FLAG ),
250: TRANSFORM_FUNCTION = DECODE( X_TRANSFORM_FUNCTION, NULL, TRANSFORM_FUNCTION, FND_API.G_MISS_CHAR, NULL, X_TRANSFORM_FUNCTION ),

Line 247: MANDATORY_FLAG = DECODE( X_MANDATORY_FLAG, NULL, MANDATORY_FLAG, FND_API.G_MISS_CHAR, NULL, X_MANDATORY_FLAG ),

243: ATTRIBUTE_CODE = DECODE( X_ATTRIBUTE_CODE, NULL, ATTRIBUTE_CODE, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CODE ),
244: ATTRIBUTE_APPLICATION_ID = DECODE( X_ATTRIBUTE_APPLICATION_ID, NULL, ATTRIBUTE_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_ATTRIBUTE_APPLICATION_ID ),
245: LINE_NUMBER = DECODE( X_LINE_NUMBER, NULL, LINE_NUMBER, FND_API.G_MISS_NUM, NULL, X_LINE_NUMBER ),
246: POSITION = DECODE( X_POSITION, NULL, POSITION, FND_API.G_MISS_NUM, NULL, X_POSITION ),
247: MANDATORY_FLAG = DECODE( X_MANDATORY_FLAG, NULL, MANDATORY_FLAG, FND_API.G_MISS_CHAR, NULL, X_MANDATORY_FLAG ),
248: USE_INITIAL_FLAG = DECODE( X_USE_INITIAL_FLAG, NULL, USE_INITIAL_FLAG, FND_API.G_MISS_CHAR, NULL, X_USE_INITIAL_FLAG ),
249: UPPERCASE_FLAG = DECODE( X_UPPERCASE_FLAG, NULL, UPPERCASE_FLAG, FND_API.G_MISS_CHAR, NULL, X_UPPERCASE_FLAG ),
250: TRANSFORM_FUNCTION = DECODE( X_TRANSFORM_FUNCTION, NULL, TRANSFORM_FUNCTION, FND_API.G_MISS_CHAR, NULL, X_TRANSFORM_FUNCTION ),
251: DELIMITER_BEFORE = DECODE( X_DELIMITER_BEFORE, NULL, DELIMITER_BEFORE, FND_API.G_MISS_CHAR, NULL, X_DELIMITER_BEFORE ),

Line 248: USE_INITIAL_FLAG = DECODE( X_USE_INITIAL_FLAG, NULL, USE_INITIAL_FLAG, FND_API.G_MISS_CHAR, NULL, X_USE_INITIAL_FLAG ),

244: ATTRIBUTE_APPLICATION_ID = DECODE( X_ATTRIBUTE_APPLICATION_ID, NULL, ATTRIBUTE_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_ATTRIBUTE_APPLICATION_ID ),
245: LINE_NUMBER = DECODE( X_LINE_NUMBER, NULL, LINE_NUMBER, FND_API.G_MISS_NUM, NULL, X_LINE_NUMBER ),
246: POSITION = DECODE( X_POSITION, NULL, POSITION, FND_API.G_MISS_NUM, NULL, X_POSITION ),
247: MANDATORY_FLAG = DECODE( X_MANDATORY_FLAG, NULL, MANDATORY_FLAG, FND_API.G_MISS_CHAR, NULL, X_MANDATORY_FLAG ),
248: USE_INITIAL_FLAG = DECODE( X_USE_INITIAL_FLAG, NULL, USE_INITIAL_FLAG, FND_API.G_MISS_CHAR, NULL, X_USE_INITIAL_FLAG ),
249: UPPERCASE_FLAG = DECODE( X_UPPERCASE_FLAG, NULL, UPPERCASE_FLAG, FND_API.G_MISS_CHAR, NULL, X_UPPERCASE_FLAG ),
250: TRANSFORM_FUNCTION = DECODE( X_TRANSFORM_FUNCTION, NULL, TRANSFORM_FUNCTION, FND_API.G_MISS_CHAR, NULL, X_TRANSFORM_FUNCTION ),
251: DELIMITER_BEFORE = DECODE( X_DELIMITER_BEFORE, NULL, DELIMITER_BEFORE, FND_API.G_MISS_CHAR, NULL, X_DELIMITER_BEFORE ),
252: DELIMITER_AFTER = DECODE( X_DELIMITER_AFTER, NULL, DELIMITER_AFTER, FND_API.G_MISS_CHAR, NULL, X_DELIMITER_AFTER ),

Line 249: UPPERCASE_FLAG = DECODE( X_UPPERCASE_FLAG, NULL, UPPERCASE_FLAG, FND_API.G_MISS_CHAR, NULL, X_UPPERCASE_FLAG ),

245: LINE_NUMBER = DECODE( X_LINE_NUMBER, NULL, LINE_NUMBER, FND_API.G_MISS_NUM, NULL, X_LINE_NUMBER ),
246: POSITION = DECODE( X_POSITION, NULL, POSITION, FND_API.G_MISS_NUM, NULL, X_POSITION ),
247: MANDATORY_FLAG = DECODE( X_MANDATORY_FLAG, NULL, MANDATORY_FLAG, FND_API.G_MISS_CHAR, NULL, X_MANDATORY_FLAG ),
248: USE_INITIAL_FLAG = DECODE( X_USE_INITIAL_FLAG, NULL, USE_INITIAL_FLAG, FND_API.G_MISS_CHAR, NULL, X_USE_INITIAL_FLAG ),
249: UPPERCASE_FLAG = DECODE( X_UPPERCASE_FLAG, NULL, UPPERCASE_FLAG, FND_API.G_MISS_CHAR, NULL, X_UPPERCASE_FLAG ),
250: TRANSFORM_FUNCTION = DECODE( X_TRANSFORM_FUNCTION, NULL, TRANSFORM_FUNCTION, FND_API.G_MISS_CHAR, NULL, X_TRANSFORM_FUNCTION ),
251: DELIMITER_BEFORE = DECODE( X_DELIMITER_BEFORE, NULL, DELIMITER_BEFORE, FND_API.G_MISS_CHAR, NULL, X_DELIMITER_BEFORE ),
252: DELIMITER_AFTER = DECODE( X_DELIMITER_AFTER, NULL, DELIMITER_AFTER, FND_API.G_MISS_CHAR, NULL, X_DELIMITER_AFTER ),
253: BLANK_LINES_BEFORE = DECODE( X_BLANK_LINES_BEFORE, NULL, BLANK_LINES_BEFORE, FND_API.G_MISS_NUM, NULL, X_BLANK_LINES_BEFORE ),

Line 250: TRANSFORM_FUNCTION = DECODE( X_TRANSFORM_FUNCTION, NULL, TRANSFORM_FUNCTION, FND_API.G_MISS_CHAR, NULL, X_TRANSFORM_FUNCTION ),

246: POSITION = DECODE( X_POSITION, NULL, POSITION, FND_API.G_MISS_NUM, NULL, X_POSITION ),
247: MANDATORY_FLAG = DECODE( X_MANDATORY_FLAG, NULL, MANDATORY_FLAG, FND_API.G_MISS_CHAR, NULL, X_MANDATORY_FLAG ),
248: USE_INITIAL_FLAG = DECODE( X_USE_INITIAL_FLAG, NULL, USE_INITIAL_FLAG, FND_API.G_MISS_CHAR, NULL, X_USE_INITIAL_FLAG ),
249: UPPERCASE_FLAG = DECODE( X_UPPERCASE_FLAG, NULL, UPPERCASE_FLAG, FND_API.G_MISS_CHAR, NULL, X_UPPERCASE_FLAG ),
250: TRANSFORM_FUNCTION = DECODE( X_TRANSFORM_FUNCTION, NULL, TRANSFORM_FUNCTION, FND_API.G_MISS_CHAR, NULL, X_TRANSFORM_FUNCTION ),
251: DELIMITER_BEFORE = DECODE( X_DELIMITER_BEFORE, NULL, DELIMITER_BEFORE, FND_API.G_MISS_CHAR, NULL, X_DELIMITER_BEFORE ),
252: DELIMITER_AFTER = DECODE( X_DELIMITER_AFTER, NULL, DELIMITER_AFTER, FND_API.G_MISS_CHAR, NULL, X_DELIMITER_AFTER ),
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 ),

Line 251: DELIMITER_BEFORE = DECODE( X_DELIMITER_BEFORE, NULL, DELIMITER_BEFORE, FND_API.G_MISS_CHAR, NULL, X_DELIMITER_BEFORE ),

247: MANDATORY_FLAG = DECODE( X_MANDATORY_FLAG, NULL, MANDATORY_FLAG, FND_API.G_MISS_CHAR, NULL, X_MANDATORY_FLAG ),
248: USE_INITIAL_FLAG = DECODE( X_USE_INITIAL_FLAG, NULL, USE_INITIAL_FLAG, FND_API.G_MISS_CHAR, NULL, X_USE_INITIAL_FLAG ),
249: UPPERCASE_FLAG = DECODE( X_UPPERCASE_FLAG, NULL, UPPERCASE_FLAG, FND_API.G_MISS_CHAR, NULL, X_UPPERCASE_FLAG ),
250: TRANSFORM_FUNCTION = DECODE( X_TRANSFORM_FUNCTION, NULL, TRANSFORM_FUNCTION, FND_API.G_MISS_CHAR, NULL, X_TRANSFORM_FUNCTION ),
251: DELIMITER_BEFORE = DECODE( X_DELIMITER_BEFORE, NULL, DELIMITER_BEFORE, FND_API.G_MISS_CHAR, NULL, X_DELIMITER_BEFORE ),
252: DELIMITER_AFTER = DECODE( X_DELIMITER_AFTER, NULL, DELIMITER_AFTER, FND_API.G_MISS_CHAR, NULL, X_DELIMITER_AFTER ),
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 ),

Line 252: DELIMITER_AFTER = DECODE( X_DELIMITER_AFTER, NULL, DELIMITER_AFTER, FND_API.G_MISS_CHAR, NULL, X_DELIMITER_AFTER ),

248: USE_INITIAL_FLAG = DECODE( X_USE_INITIAL_FLAG, NULL, USE_INITIAL_FLAG, FND_API.G_MISS_CHAR, NULL, X_USE_INITIAL_FLAG ),
249: UPPERCASE_FLAG = DECODE( X_UPPERCASE_FLAG, NULL, UPPERCASE_FLAG, FND_API.G_MISS_CHAR, NULL, X_UPPERCASE_FLAG ),
250: TRANSFORM_FUNCTION = DECODE( X_TRANSFORM_FUNCTION, NULL, TRANSFORM_FUNCTION, FND_API.G_MISS_CHAR, NULL, X_TRANSFORM_FUNCTION ),
251: DELIMITER_BEFORE = DECODE( X_DELIMITER_BEFORE, NULL, DELIMITER_BEFORE, FND_API.G_MISS_CHAR, NULL, X_DELIMITER_BEFORE ),
252: DELIMITER_AFTER = DECODE( X_DELIMITER_AFTER, NULL, DELIMITER_AFTER, FND_API.G_MISS_CHAR, NULL, X_DELIMITER_AFTER ),
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 ),

Line 253: BLANK_LINES_BEFORE = DECODE( X_BLANK_LINES_BEFORE, NULL, BLANK_LINES_BEFORE, FND_API.G_MISS_NUM, NULL, X_BLANK_LINES_BEFORE ),

249: UPPERCASE_FLAG = DECODE( X_UPPERCASE_FLAG, NULL, UPPERCASE_FLAG, FND_API.G_MISS_CHAR, NULL, X_UPPERCASE_FLAG ),
250: TRANSFORM_FUNCTION = DECODE( X_TRANSFORM_FUNCTION, NULL, TRANSFORM_FUNCTION, FND_API.G_MISS_CHAR, NULL, X_TRANSFORM_FUNCTION ),
251: DELIMITER_BEFORE = DECODE( X_DELIMITER_BEFORE, NULL, DELIMITER_BEFORE, FND_API.G_MISS_CHAR, NULL, X_DELIMITER_BEFORE ),
252: DELIMITER_AFTER = DECODE( X_DELIMITER_AFTER, NULL, DELIMITER_AFTER, FND_API.G_MISS_CHAR, NULL, X_DELIMITER_AFTER ),
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,

Line 254: BLANK_LINES_AFTER = DECODE( X_BLANK_LINES_AFTER, NULL, BLANK_LINES_AFTER, FND_API.G_MISS_NUM, NULL, X_BLANK_LINES_AFTER ),

250: TRANSFORM_FUNCTION = DECODE( X_TRANSFORM_FUNCTION, NULL, TRANSFORM_FUNCTION, FND_API.G_MISS_CHAR, NULL, X_TRANSFORM_FUNCTION ),
251: DELIMITER_BEFORE = DECODE( X_DELIMITER_BEFORE, NULL, DELIMITER_BEFORE, FND_API.G_MISS_CHAR, NULL, X_DELIMITER_BEFORE ),
252: DELIMITER_AFTER = DECODE( X_DELIMITER_AFTER, NULL, DELIMITER_AFTER, FND_API.G_MISS_CHAR, NULL, X_DELIMITER_AFTER ),
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),

Line 255: START_DATE_ACTIVE = DECODE( X_START_DATE_ACTIVE, NULL, START_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, X_START_DATE_ACTIVE ),

251: DELIMITER_BEFORE = DECODE( X_DELIMITER_BEFORE, NULL, DELIMITER_BEFORE, FND_API.G_MISS_CHAR, NULL, X_DELIMITER_BEFORE ),
252: DELIMITER_AFTER = DECODE( X_DELIMITER_AFTER, NULL, DELIMITER_AFTER, FND_API.G_MISS_CHAR, NULL, X_DELIMITER_AFTER ),
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),

Line 256: END_DATE_ACTIVE = DECODE( X_END_DATE_ACTIVE, NULL, END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, X_END_DATE_ACTIVE ),

252: DELIMITER_AFTER = DECODE( X_DELIMITER_AFTER, NULL, DELIMITER_AFTER, FND_API.G_MISS_CHAR, NULL, X_DELIMITER_AFTER ),
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,

Line 261: FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER)

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:
264: if (sql%notfound) then
265: raise no_data_found;

Line 269: PROMPT = DECODE( X_PROMPT, NULL, PROMPT, FND_API.G_MISS_CHAR, NULL, X_PROMPT ),

265: raise no_data_found;
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')

Line 305: NVL( B.STYLE_FMT_LAYOUT_ID, FND_API.G_MISS_NUM ),

301: ) IS
302: BEGIN
303:
304: SELECT
305: NVL( B.STYLE_FMT_LAYOUT_ID, FND_API.G_MISS_NUM ),
306: NVL( B.STYLE_FORMAT_CODE, FND_API.G_MISS_CHAR ),
307: NVL( B.VARIATION_NUMBER, FND_API.G_MISS_NUM ),
308: NVL( B.ATTRIBUTE_CODE, FND_API.G_MISS_CHAR ),
309: NVL( B.ATTRIBUTE_APPLICATION_ID, FND_API.G_MISS_NUM ),

Line 306: NVL( B.STYLE_FORMAT_CODE, FND_API.G_MISS_CHAR ),

302: BEGIN
303:
304: SELECT
305: NVL( B.STYLE_FMT_LAYOUT_ID, FND_API.G_MISS_NUM ),
306: NVL( B.STYLE_FORMAT_CODE, FND_API.G_MISS_CHAR ),
307: NVL( B.VARIATION_NUMBER, FND_API.G_MISS_NUM ),
308: NVL( B.ATTRIBUTE_CODE, FND_API.G_MISS_CHAR ),
309: NVL( B.ATTRIBUTE_APPLICATION_ID, FND_API.G_MISS_NUM ),
310: NVL( B.LINE_NUMBER, FND_API.G_MISS_NUM ),

Line 307: NVL( B.VARIATION_NUMBER, FND_API.G_MISS_NUM ),

303:
304: SELECT
305: NVL( B.STYLE_FMT_LAYOUT_ID, FND_API.G_MISS_NUM ),
306: NVL( B.STYLE_FORMAT_CODE, FND_API.G_MISS_CHAR ),
307: NVL( B.VARIATION_NUMBER, FND_API.G_MISS_NUM ),
308: NVL( B.ATTRIBUTE_CODE, FND_API.G_MISS_CHAR ),
309: NVL( B.ATTRIBUTE_APPLICATION_ID, FND_API.G_MISS_NUM ),
310: NVL( B.LINE_NUMBER, FND_API.G_MISS_NUM ),
311: NVL( B.POSITION, FND_API.G_MISS_NUM ),

Line 308: NVL( B.ATTRIBUTE_CODE, FND_API.G_MISS_CHAR ),

304: SELECT
305: NVL( B.STYLE_FMT_LAYOUT_ID, FND_API.G_MISS_NUM ),
306: NVL( B.STYLE_FORMAT_CODE, FND_API.G_MISS_CHAR ),
307: NVL( B.VARIATION_NUMBER, FND_API.G_MISS_NUM ),
308: NVL( B.ATTRIBUTE_CODE, FND_API.G_MISS_CHAR ),
309: NVL( B.ATTRIBUTE_APPLICATION_ID, FND_API.G_MISS_NUM ),
310: NVL( B.LINE_NUMBER, FND_API.G_MISS_NUM ),
311: NVL( B.POSITION, FND_API.G_MISS_NUM ),
312: NVL( B.MANDATORY_FLAG, FND_API.G_MISS_CHAR ),

Line 309: NVL( B.ATTRIBUTE_APPLICATION_ID, FND_API.G_MISS_NUM ),

305: NVL( B.STYLE_FMT_LAYOUT_ID, FND_API.G_MISS_NUM ),
306: NVL( B.STYLE_FORMAT_CODE, FND_API.G_MISS_CHAR ),
307: NVL( B.VARIATION_NUMBER, FND_API.G_MISS_NUM ),
308: NVL( B.ATTRIBUTE_CODE, FND_API.G_MISS_CHAR ),
309: NVL( B.ATTRIBUTE_APPLICATION_ID, FND_API.G_MISS_NUM ),
310: NVL( B.LINE_NUMBER, FND_API.G_MISS_NUM ),
311: NVL( B.POSITION, FND_API.G_MISS_NUM ),
312: NVL( B.MANDATORY_FLAG, FND_API.G_MISS_CHAR ),
313: NVL( B.USE_INITIAL_FLAG, FND_API.G_MISS_CHAR ),

Line 310: NVL( B.LINE_NUMBER, FND_API.G_MISS_NUM ),

306: NVL( B.STYLE_FORMAT_CODE, FND_API.G_MISS_CHAR ),
307: NVL( B.VARIATION_NUMBER, FND_API.G_MISS_NUM ),
308: NVL( B.ATTRIBUTE_CODE, FND_API.G_MISS_CHAR ),
309: NVL( B.ATTRIBUTE_APPLICATION_ID, FND_API.G_MISS_NUM ),
310: NVL( B.LINE_NUMBER, FND_API.G_MISS_NUM ),
311: NVL( B.POSITION, FND_API.G_MISS_NUM ),
312: NVL( B.MANDATORY_FLAG, FND_API.G_MISS_CHAR ),
313: NVL( B.USE_INITIAL_FLAG, FND_API.G_MISS_CHAR ),
314: NVL( B.UPPERCASE_FLAG, FND_API.G_MISS_CHAR ),

Line 311: NVL( B.POSITION, FND_API.G_MISS_NUM ),

307: NVL( B.VARIATION_NUMBER, FND_API.G_MISS_NUM ),
308: NVL( B.ATTRIBUTE_CODE, FND_API.G_MISS_CHAR ),
309: NVL( B.ATTRIBUTE_APPLICATION_ID, FND_API.G_MISS_NUM ),
310: NVL( B.LINE_NUMBER, FND_API.G_MISS_NUM ),
311: NVL( B.POSITION, FND_API.G_MISS_NUM ),
312: NVL( B.MANDATORY_FLAG, FND_API.G_MISS_CHAR ),
313: NVL( B.USE_INITIAL_FLAG, FND_API.G_MISS_CHAR ),
314: NVL( B.UPPERCASE_FLAG, FND_API.G_MISS_CHAR ),
315: NVL( B.TRANSFORM_FUNCTION, FND_API.G_MISS_CHAR ),

Line 312: NVL( B.MANDATORY_FLAG, FND_API.G_MISS_CHAR ),

308: NVL( B.ATTRIBUTE_CODE, FND_API.G_MISS_CHAR ),
309: NVL( B.ATTRIBUTE_APPLICATION_ID, FND_API.G_MISS_NUM ),
310: NVL( B.LINE_NUMBER, FND_API.G_MISS_NUM ),
311: NVL( B.POSITION, FND_API.G_MISS_NUM ),
312: NVL( B.MANDATORY_FLAG, FND_API.G_MISS_CHAR ),
313: NVL( B.USE_INITIAL_FLAG, FND_API.G_MISS_CHAR ),
314: NVL( B.UPPERCASE_FLAG, FND_API.G_MISS_CHAR ),
315: NVL( B.TRANSFORM_FUNCTION, FND_API.G_MISS_CHAR ),
316: NVL( B.DELIMITER_BEFORE, FND_API.G_MISS_CHAR ),

Line 313: NVL( B.USE_INITIAL_FLAG, FND_API.G_MISS_CHAR ),

309: NVL( B.ATTRIBUTE_APPLICATION_ID, FND_API.G_MISS_NUM ),
310: NVL( B.LINE_NUMBER, FND_API.G_MISS_NUM ),
311: NVL( B.POSITION, FND_API.G_MISS_NUM ),
312: NVL( B.MANDATORY_FLAG, FND_API.G_MISS_CHAR ),
313: NVL( B.USE_INITIAL_FLAG, FND_API.G_MISS_CHAR ),
314: NVL( B.UPPERCASE_FLAG, FND_API.G_MISS_CHAR ),
315: NVL( B.TRANSFORM_FUNCTION, FND_API.G_MISS_CHAR ),
316: NVL( B.DELIMITER_BEFORE, FND_API.G_MISS_CHAR ),
317: NVL( B.DELIMITER_AFTER, FND_API.G_MISS_CHAR ),

Line 314: NVL( B.UPPERCASE_FLAG, FND_API.G_MISS_CHAR ),

310: NVL( B.LINE_NUMBER, FND_API.G_MISS_NUM ),
311: NVL( B.POSITION, FND_API.G_MISS_NUM ),
312: NVL( B.MANDATORY_FLAG, FND_API.G_MISS_CHAR ),
313: NVL( B.USE_INITIAL_FLAG, FND_API.G_MISS_CHAR ),
314: NVL( B.UPPERCASE_FLAG, FND_API.G_MISS_CHAR ),
315: NVL( B.TRANSFORM_FUNCTION, FND_API.G_MISS_CHAR ),
316: NVL( B.DELIMITER_BEFORE, FND_API.G_MISS_CHAR ),
317: NVL( B.DELIMITER_AFTER, FND_API.G_MISS_CHAR ),
318: NVL( B.BLANK_LINES_BEFORE, FND_API.G_MISS_NUM ),

Line 315: NVL( B.TRANSFORM_FUNCTION, FND_API.G_MISS_CHAR ),

311: NVL( B.POSITION, FND_API.G_MISS_NUM ),
312: NVL( B.MANDATORY_FLAG, FND_API.G_MISS_CHAR ),
313: NVL( B.USE_INITIAL_FLAG, FND_API.G_MISS_CHAR ),
314: NVL( B.UPPERCASE_FLAG, FND_API.G_MISS_CHAR ),
315: NVL( B.TRANSFORM_FUNCTION, FND_API.G_MISS_CHAR ),
316: NVL( B.DELIMITER_BEFORE, FND_API.G_MISS_CHAR ),
317: NVL( B.DELIMITER_AFTER, FND_API.G_MISS_CHAR ),
318: NVL( B.BLANK_LINES_BEFORE, FND_API.G_MISS_NUM ),
319: NVL( B.BLANK_LINES_AFTER, FND_API.G_MISS_NUM ),

Line 316: NVL( B.DELIMITER_BEFORE, FND_API.G_MISS_CHAR ),

312: NVL( B.MANDATORY_FLAG, FND_API.G_MISS_CHAR ),
313: NVL( B.USE_INITIAL_FLAG, FND_API.G_MISS_CHAR ),
314: NVL( B.UPPERCASE_FLAG, FND_API.G_MISS_CHAR ),
315: NVL( B.TRANSFORM_FUNCTION, FND_API.G_MISS_CHAR ),
316: NVL( B.DELIMITER_BEFORE, FND_API.G_MISS_CHAR ),
317: NVL( B.DELIMITER_AFTER, FND_API.G_MISS_CHAR ),
318: NVL( B.BLANK_LINES_BEFORE, FND_API.G_MISS_NUM ),
319: NVL( B.BLANK_LINES_AFTER, FND_API.G_MISS_NUM ),
320: NVL( T.PROMPT, FND_API.G_MISS_CHAR ),

Line 317: NVL( B.DELIMITER_AFTER, FND_API.G_MISS_CHAR ),

313: NVL( B.USE_INITIAL_FLAG, FND_API.G_MISS_CHAR ),
314: NVL( B.UPPERCASE_FLAG, FND_API.G_MISS_CHAR ),
315: NVL( B.TRANSFORM_FUNCTION, FND_API.G_MISS_CHAR ),
316: NVL( B.DELIMITER_BEFORE, FND_API.G_MISS_CHAR ),
317: NVL( B.DELIMITER_AFTER, FND_API.G_MISS_CHAR ),
318: NVL( B.BLANK_LINES_BEFORE, FND_API.G_MISS_NUM ),
319: NVL( B.BLANK_LINES_AFTER, FND_API.G_MISS_NUM ),
320: NVL( T.PROMPT, FND_API.G_MISS_CHAR ),
321: NVL( B.START_DATE_ACTIVE, FND_API.G_MISS_DATE ),

Line 318: NVL( B.BLANK_LINES_BEFORE, FND_API.G_MISS_NUM ),

314: NVL( B.UPPERCASE_FLAG, FND_API.G_MISS_CHAR ),
315: NVL( B.TRANSFORM_FUNCTION, FND_API.G_MISS_CHAR ),
316: NVL( B.DELIMITER_BEFORE, FND_API.G_MISS_CHAR ),
317: NVL( B.DELIMITER_AFTER, FND_API.G_MISS_CHAR ),
318: NVL( B.BLANK_LINES_BEFORE, FND_API.G_MISS_NUM ),
319: NVL( B.BLANK_LINES_AFTER, FND_API.G_MISS_NUM ),
320: NVL( T.PROMPT, FND_API.G_MISS_CHAR ),
321: NVL( B.START_DATE_ACTIVE, FND_API.G_MISS_DATE ),
322: NVL( B.END_DATE_ACTIVE, FND_API.G_MISS_DATE )

Line 319: NVL( B.BLANK_LINES_AFTER, FND_API.G_MISS_NUM ),

315: NVL( B.TRANSFORM_FUNCTION, FND_API.G_MISS_CHAR ),
316: NVL( B.DELIMITER_BEFORE, FND_API.G_MISS_CHAR ),
317: NVL( B.DELIMITER_AFTER, FND_API.G_MISS_CHAR ),
318: NVL( B.BLANK_LINES_BEFORE, FND_API.G_MISS_NUM ),
319: NVL( B.BLANK_LINES_AFTER, FND_API.G_MISS_NUM ),
320: NVL( T.PROMPT, FND_API.G_MISS_CHAR ),
321: NVL( B.START_DATE_ACTIVE, FND_API.G_MISS_DATE ),
322: NVL( B.END_DATE_ACTIVE, FND_API.G_MISS_DATE )
323: INTO

Line 320: NVL( T.PROMPT, FND_API.G_MISS_CHAR ),

316: NVL( B.DELIMITER_BEFORE, FND_API.G_MISS_CHAR ),
317: NVL( B.DELIMITER_AFTER, FND_API.G_MISS_CHAR ),
318: NVL( B.BLANK_LINES_BEFORE, FND_API.G_MISS_NUM ),
319: NVL( B.BLANK_LINES_AFTER, FND_API.G_MISS_NUM ),
320: NVL( T.PROMPT, FND_API.G_MISS_CHAR ),
321: NVL( B.START_DATE_ACTIVE, FND_API.G_MISS_DATE ),
322: NVL( B.END_DATE_ACTIVE, FND_API.G_MISS_DATE )
323: INTO
324: X_STYLE_FMT_LAYOUT_ID ,

Line 321: NVL( B.START_DATE_ACTIVE, FND_API.G_MISS_DATE ),

317: NVL( B.DELIMITER_AFTER, FND_API.G_MISS_CHAR ),
318: NVL( B.BLANK_LINES_BEFORE, FND_API.G_MISS_NUM ),
319: NVL( B.BLANK_LINES_AFTER, FND_API.G_MISS_NUM ),
320: NVL( T.PROMPT, FND_API.G_MISS_CHAR ),
321: NVL( B.START_DATE_ACTIVE, FND_API.G_MISS_DATE ),
322: NVL( B.END_DATE_ACTIVE, FND_API.G_MISS_DATE )
323: INTO
324: X_STYLE_FMT_LAYOUT_ID ,
325: X_STYLE_FORMAT_CODE ,

Line 322: NVL( B.END_DATE_ACTIVE, FND_API.G_MISS_DATE )

318: NVL( B.BLANK_LINES_BEFORE, FND_API.G_MISS_NUM ),
319: NVL( B.BLANK_LINES_AFTER, FND_API.G_MISS_NUM ),
320: NVL( T.PROMPT, FND_API.G_MISS_CHAR ),
321: NVL( B.START_DATE_ACTIVE, FND_API.G_MISS_DATE ),
322: NVL( B.END_DATE_ACTIVE, FND_API.G_MISS_DATE )
323: INTO
324: X_STYLE_FMT_LAYOUT_ID ,
325: X_STYLE_FORMAT_CODE ,
326: X_VARIATION_NUMBER ,

Line 353: RAISE FND_API.G_EXC_ERROR;

349: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
350: FND_MESSAGE.SET_TOKEN( 'RECORD', 'style_fmt_layout_rec');
351: FND_MESSAGE.SET_TOKEN( 'VALUE', 'STYLE_FMT_LAYOUT_ID' );
352: FND_MSG_PUB.ADD;
353: RAISE FND_API.G_EXC_ERROR;
354: END SELECT_ROW;
355:
356:
357: procedure DELETE_ROW (