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_LOCALES_PKG dependencies on FND_API

Line 34: DECODE( X_STYLE_FMT_LOCALE_ID, FND_API.G_MISS_NUM, HZ_STYLE_FMT_LOCALES_S.NEXTVAL, NULL, HZ_STYLE_FMT_LOCALES_S.NEXTVAL, X_STYLE_FMT_LOCALE_ID ),

30: LAST_UPDATE_DATE,
31: LAST_UPDATED_BY,
32: OBJECT_VERSION_NUMBER
33: ) values (
34: DECODE( X_STYLE_FMT_LOCALE_ID, FND_API.G_MISS_NUM, HZ_STYLE_FMT_LOCALES_S.NEXTVAL, NULL, HZ_STYLE_FMT_LOCALES_S.NEXTVAL, X_STYLE_FMT_LOCALE_ID ),
35: DECODE( X_STYLE_FORMAT_CODE, FND_API.G_MISS_CHAR, NULL, X_STYLE_FORMAT_CODE ),
36: DECODE( X_LANGUAGE_CODE, FND_API.G_MISS_CHAR, NULL, X_LANGUAGE_CODE ),
37: DECODE( X_TERRITORY_CODE, FND_API.G_MISS_CHAR, NULL, X_TERRITORY_CODE ),
38: DECODE( X_START_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, X_START_DATE_ACTIVE ),

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

31: LAST_UPDATED_BY,
32: OBJECT_VERSION_NUMBER
33: ) values (
34: DECODE( X_STYLE_FMT_LOCALE_ID, FND_API.G_MISS_NUM, HZ_STYLE_FMT_LOCALES_S.NEXTVAL, NULL, HZ_STYLE_FMT_LOCALES_S.NEXTVAL, X_STYLE_FMT_LOCALE_ID ),
35: DECODE( X_STYLE_FORMAT_CODE, FND_API.G_MISS_CHAR, NULL, X_STYLE_FORMAT_CODE ),
36: DECODE( X_LANGUAGE_CODE, FND_API.G_MISS_CHAR, NULL, X_LANGUAGE_CODE ),
37: DECODE( X_TERRITORY_CODE, FND_API.G_MISS_CHAR, NULL, X_TERRITORY_CODE ),
38: DECODE( X_START_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, X_START_DATE_ACTIVE ),
39: DECODE( X_END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, X_END_DATE_ACTIVE ),

Line 36: DECODE( X_LANGUAGE_CODE, FND_API.G_MISS_CHAR, NULL, X_LANGUAGE_CODE ),

32: OBJECT_VERSION_NUMBER
33: ) values (
34: DECODE( X_STYLE_FMT_LOCALE_ID, FND_API.G_MISS_NUM, HZ_STYLE_FMT_LOCALES_S.NEXTVAL, NULL, HZ_STYLE_FMT_LOCALES_S.NEXTVAL, X_STYLE_FMT_LOCALE_ID ),
35: DECODE( X_STYLE_FORMAT_CODE, FND_API.G_MISS_CHAR, NULL, X_STYLE_FORMAT_CODE ),
36: DECODE( X_LANGUAGE_CODE, FND_API.G_MISS_CHAR, NULL, X_LANGUAGE_CODE ),
37: DECODE( X_TERRITORY_CODE, FND_API.G_MISS_CHAR, NULL, X_TERRITORY_CODE ),
38: DECODE( X_START_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, X_START_DATE_ACTIVE ),
39: DECODE( X_END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, X_END_DATE_ACTIVE ),
40: NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.CREATED_BY),

Line 37: DECODE( X_TERRITORY_CODE, FND_API.G_MISS_CHAR, NULL, X_TERRITORY_CODE ),

33: ) values (
34: DECODE( X_STYLE_FMT_LOCALE_ID, FND_API.G_MISS_NUM, HZ_STYLE_FMT_LOCALES_S.NEXTVAL, NULL, HZ_STYLE_FMT_LOCALES_S.NEXTVAL, X_STYLE_FMT_LOCALE_ID ),
35: DECODE( X_STYLE_FORMAT_CODE, FND_API.G_MISS_CHAR, NULL, X_STYLE_FORMAT_CODE ),
36: DECODE( X_LANGUAGE_CODE, FND_API.G_MISS_CHAR, NULL, X_LANGUAGE_CODE ),
37: DECODE( X_TERRITORY_CODE, FND_API.G_MISS_CHAR, NULL, X_TERRITORY_CODE ),
38: DECODE( X_START_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, X_START_DATE_ACTIVE ),
39: DECODE( X_END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, X_END_DATE_ACTIVE ),
40: NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.CREATED_BY),
41: HZ_UTILITY_V2PUB.CREATION_DATE,

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

34: DECODE( X_STYLE_FMT_LOCALE_ID, FND_API.G_MISS_NUM, HZ_STYLE_FMT_LOCALES_S.NEXTVAL, NULL, HZ_STYLE_FMT_LOCALES_S.NEXTVAL, X_STYLE_FMT_LOCALE_ID ),
35: DECODE( X_STYLE_FORMAT_CODE, FND_API.G_MISS_CHAR, NULL, X_STYLE_FORMAT_CODE ),
36: DECODE( X_LANGUAGE_CODE, FND_API.G_MISS_CHAR, NULL, X_LANGUAGE_CODE ),
37: DECODE( X_TERRITORY_CODE, FND_API.G_MISS_CHAR, NULL, X_TERRITORY_CODE ),
38: DECODE( X_START_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, X_START_DATE_ACTIVE ),
39: DECODE( X_END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, X_END_DATE_ACTIVE ),
40: NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.CREATED_BY),
41: HZ_UTILITY_V2PUB.CREATION_DATE,
42: NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN),

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

35: DECODE( X_STYLE_FORMAT_CODE, FND_API.G_MISS_CHAR, NULL, X_STYLE_FORMAT_CODE ),
36: DECODE( X_LANGUAGE_CODE, FND_API.G_MISS_CHAR, NULL, X_LANGUAGE_CODE ),
37: DECODE( X_TERRITORY_CODE, FND_API.G_MISS_CHAR, NULL, X_TERRITORY_CODE ),
38: DECODE( X_START_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, X_START_DATE_ACTIVE ),
39: DECODE( X_END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, X_END_DATE_ACTIVE ),
40: NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.CREATED_BY),
41: HZ_UTILITY_V2PUB.CREATION_DATE,
42: NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN),
43: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

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

41: HZ_UTILITY_V2PUB.CREATION_DATE,
42: NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN),
43: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
44: NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.LAST_UPDATED_BY),
45: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER )
46: ) RETURNING
47: STYLE_FMT_LOCALE_ID
48: INTO
49: X_STYLE_FMT_LOCALE_ID;

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

106: ) is
107: begin
108:
109: update HZ_STYLE_FMT_LOCALES set
110: STYLE_FORMAT_CODE = DECODE( X_STYLE_FORMAT_CODE, NULL, STYLE_FORMAT_CODE, FND_API.G_MISS_CHAR, NULL, X_STYLE_FORMAT_CODE ),
111: LANGUAGE_CODE = DECODE( X_LANGUAGE_CODE, NULL, LANGUAGE_CODE, FND_API.G_MISS_CHAR, NULL, X_LANGUAGE_CODE ),
112: TERRITORY_CODE = DECODE( X_TERRITORY_CODE, NULL, TERRITORY_CODE, FND_API.G_MISS_CHAR, NULL, X_TERRITORY_CODE ),
113: START_DATE_ACTIVE = DECODE( X_START_DATE_ACTIVE, NULL, START_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, X_START_DATE_ACTIVE ),
114: END_DATE_ACTIVE = DECODE( X_END_DATE_ACTIVE, NULL, END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, X_END_DATE_ACTIVE ),

Line 111: LANGUAGE_CODE = DECODE( X_LANGUAGE_CODE, NULL, LANGUAGE_CODE, FND_API.G_MISS_CHAR, NULL, X_LANGUAGE_CODE ),

107: begin
108:
109: update HZ_STYLE_FMT_LOCALES set
110: STYLE_FORMAT_CODE = DECODE( X_STYLE_FORMAT_CODE, NULL, STYLE_FORMAT_CODE, FND_API.G_MISS_CHAR, NULL, X_STYLE_FORMAT_CODE ),
111: LANGUAGE_CODE = DECODE( X_LANGUAGE_CODE, NULL, LANGUAGE_CODE, FND_API.G_MISS_CHAR, NULL, X_LANGUAGE_CODE ),
112: TERRITORY_CODE = DECODE( X_TERRITORY_CODE, NULL, TERRITORY_CODE, FND_API.G_MISS_CHAR, NULL, X_TERRITORY_CODE ),
113: START_DATE_ACTIVE = DECODE( X_START_DATE_ACTIVE, NULL, START_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, X_START_DATE_ACTIVE ),
114: END_DATE_ACTIVE = DECODE( X_END_DATE_ACTIVE, NULL, END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, X_END_DATE_ACTIVE ),
115: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

Line 112: TERRITORY_CODE = DECODE( X_TERRITORY_CODE, NULL, TERRITORY_CODE, FND_API.G_MISS_CHAR, NULL, X_TERRITORY_CODE ),

108:
109: update HZ_STYLE_FMT_LOCALES set
110: STYLE_FORMAT_CODE = DECODE( X_STYLE_FORMAT_CODE, NULL, STYLE_FORMAT_CODE, FND_API.G_MISS_CHAR, NULL, X_STYLE_FORMAT_CODE ),
111: LANGUAGE_CODE = DECODE( X_LANGUAGE_CODE, NULL, LANGUAGE_CODE, FND_API.G_MISS_CHAR, NULL, X_LANGUAGE_CODE ),
112: TERRITORY_CODE = DECODE( X_TERRITORY_CODE, NULL, TERRITORY_CODE, FND_API.G_MISS_CHAR, NULL, X_TERRITORY_CODE ),
113: START_DATE_ACTIVE = DECODE( X_START_DATE_ACTIVE, NULL, START_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, X_START_DATE_ACTIVE ),
114: END_DATE_ACTIVE = DECODE( X_END_DATE_ACTIVE, NULL, END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, X_END_DATE_ACTIVE ),
115: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
116: LAST_UPDATED_BY = NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.LAST_UPDATED_BY),

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

109: update HZ_STYLE_FMT_LOCALES set
110: STYLE_FORMAT_CODE = DECODE( X_STYLE_FORMAT_CODE, NULL, STYLE_FORMAT_CODE, FND_API.G_MISS_CHAR, NULL, X_STYLE_FORMAT_CODE ),
111: LANGUAGE_CODE = DECODE( X_LANGUAGE_CODE, NULL, LANGUAGE_CODE, FND_API.G_MISS_CHAR, NULL, X_LANGUAGE_CODE ),
112: TERRITORY_CODE = DECODE( X_TERRITORY_CODE, NULL, TERRITORY_CODE, FND_API.G_MISS_CHAR, NULL, X_TERRITORY_CODE ),
113: START_DATE_ACTIVE = DECODE( X_START_DATE_ACTIVE, NULL, START_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, X_START_DATE_ACTIVE ),
114: END_DATE_ACTIVE = DECODE( X_END_DATE_ACTIVE, NULL, END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, X_END_DATE_ACTIVE ),
115: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
116: LAST_UPDATED_BY = NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.LAST_UPDATED_BY),
117: LAST_UPDATE_LOGIN = NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN),

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

110: STYLE_FORMAT_CODE = DECODE( X_STYLE_FORMAT_CODE, NULL, STYLE_FORMAT_CODE, FND_API.G_MISS_CHAR, NULL, X_STYLE_FORMAT_CODE ),
111: LANGUAGE_CODE = DECODE( X_LANGUAGE_CODE, NULL, LANGUAGE_CODE, FND_API.G_MISS_CHAR, NULL, X_LANGUAGE_CODE ),
112: TERRITORY_CODE = DECODE( X_TERRITORY_CODE, NULL, TERRITORY_CODE, FND_API.G_MISS_CHAR, NULL, X_TERRITORY_CODE ),
113: START_DATE_ACTIVE = DECODE( X_START_DATE_ACTIVE, NULL, START_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, X_START_DATE_ACTIVE ),
114: END_DATE_ACTIVE = DECODE( X_END_DATE_ACTIVE, NULL, END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, X_END_DATE_ACTIVE ),
115: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
116: LAST_UPDATED_BY = NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.LAST_UPDATED_BY),
117: LAST_UPDATE_LOGIN = NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN),
118: OBJECT_VERSION_NUMBER = DECODE(X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER,

Line 119: FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER)

115: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
116: LAST_UPDATED_BY = NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.LAST_UPDATED_BY),
117: LAST_UPDATE_LOGIN = NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN),
118: OBJECT_VERSION_NUMBER = DECODE(X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER,
119: FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER)
120: where STYLE_FMT_LOCALE_ID = X_STYLE_FMT_LOCALE_ID;
121:
122: if (sql%notfound) then
123: raise no_data_found;

Line 138: NVL( STYLE_FMT_LOCALE_ID, FND_API.G_MISS_NUM ),

134: X_END_DATE_ACTIVE OUT NOCOPY DATE
135: ) IS
136: BEGIN
137: SELECT
138: NVL( STYLE_FMT_LOCALE_ID, FND_API.G_MISS_NUM ),
139: NVL( STYLE_FORMAT_CODE, FND_API.G_MISS_CHAR ),
140: NVL( LANGUAGE_CODE, FND_API.G_MISS_CHAR ),
141: NVL( TERRITORY_CODE, FND_API.G_MISS_CHAR ),
142: NVL( START_DATE_ACTIVE, FND_API.G_MISS_DATE ),

Line 139: NVL( STYLE_FORMAT_CODE, FND_API.G_MISS_CHAR ),

135: ) IS
136: BEGIN
137: SELECT
138: NVL( STYLE_FMT_LOCALE_ID, FND_API.G_MISS_NUM ),
139: NVL( STYLE_FORMAT_CODE, FND_API.G_MISS_CHAR ),
140: NVL( LANGUAGE_CODE, FND_API.G_MISS_CHAR ),
141: NVL( TERRITORY_CODE, FND_API.G_MISS_CHAR ),
142: NVL( START_DATE_ACTIVE, FND_API.G_MISS_DATE ),
143: NVL( END_DATE_ACTIVE, FND_API.G_MISS_DATE )

Line 140: NVL( LANGUAGE_CODE, FND_API.G_MISS_CHAR ),

136: BEGIN
137: SELECT
138: NVL( STYLE_FMT_LOCALE_ID, FND_API.G_MISS_NUM ),
139: NVL( STYLE_FORMAT_CODE, FND_API.G_MISS_CHAR ),
140: NVL( LANGUAGE_CODE, FND_API.G_MISS_CHAR ),
141: NVL( TERRITORY_CODE, FND_API.G_MISS_CHAR ),
142: NVL( START_DATE_ACTIVE, FND_API.G_MISS_DATE ),
143: NVL( END_DATE_ACTIVE, FND_API.G_MISS_DATE )
144: INTO X_STYLE_FMT_LOCALE_ID,

Line 141: NVL( TERRITORY_CODE, FND_API.G_MISS_CHAR ),

137: SELECT
138: NVL( STYLE_FMT_LOCALE_ID, FND_API.G_MISS_NUM ),
139: NVL( STYLE_FORMAT_CODE, FND_API.G_MISS_CHAR ),
140: NVL( LANGUAGE_CODE, FND_API.G_MISS_CHAR ),
141: NVL( TERRITORY_CODE, FND_API.G_MISS_CHAR ),
142: NVL( START_DATE_ACTIVE, FND_API.G_MISS_DATE ),
143: NVL( END_DATE_ACTIVE, FND_API.G_MISS_DATE )
144: INTO X_STYLE_FMT_LOCALE_ID,
145: X_STYLE_FORMAT_CODE,

Line 142: NVL( START_DATE_ACTIVE, FND_API.G_MISS_DATE ),

138: NVL( STYLE_FMT_LOCALE_ID, FND_API.G_MISS_NUM ),
139: NVL( STYLE_FORMAT_CODE, FND_API.G_MISS_CHAR ),
140: NVL( LANGUAGE_CODE, FND_API.G_MISS_CHAR ),
141: NVL( TERRITORY_CODE, FND_API.G_MISS_CHAR ),
142: NVL( START_DATE_ACTIVE, FND_API.G_MISS_DATE ),
143: NVL( END_DATE_ACTIVE, FND_API.G_MISS_DATE )
144: INTO X_STYLE_FMT_LOCALE_ID,
145: X_STYLE_FORMAT_CODE,
146: X_LANGUAGE_CODE,

Line 143: NVL( END_DATE_ACTIVE, FND_API.G_MISS_DATE )

139: NVL( STYLE_FORMAT_CODE, FND_API.G_MISS_CHAR ),
140: NVL( LANGUAGE_CODE, FND_API.G_MISS_CHAR ),
141: NVL( TERRITORY_CODE, FND_API.G_MISS_CHAR ),
142: NVL( START_DATE_ACTIVE, FND_API.G_MISS_DATE ),
143: NVL( END_DATE_ACTIVE, FND_API.G_MISS_DATE )
144: INTO X_STYLE_FMT_LOCALE_ID,
145: X_STYLE_FORMAT_CODE,
146: X_LANGUAGE_CODE,
147: X_TERRITORY_CODE,

Line 159: RAISE FND_API.G_EXC_ERROR;

155: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
156: FND_MESSAGE.SET_TOKEN( 'RECORD', 'style_fmt_locale_rec');
157: FND_MESSAGE.SET_TOKEN( 'VALUE', 'STYLE_FMT_LOCALE_ID' );
158: FND_MSG_PUB.ADD;
159: RAISE FND_API.G_EXC_ERROR;
160:
161: END SELECT_ROW;
162:
163: