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

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

35: LAST_UPDATE_DATE,
36: LAST_UPDATED_BY,
37: OBJECT_VERSION_NUMBER
38: ) values (
39: DECODE( X_STYLE_FORMAT_CODE, FND_API.G_MISS_CHAR, NULL, X_STYLE_FORMAT_CODE ),
40: DECODE( X_VARIATION_NUMBER, FND_API.G_MISS_NUM, NULL, X_VARIATION_NUMBER ),
41: DECODE( X_VARIATION_RANK, FND_API.G_MISS_NUM, NULL, X_VARIATION_RANK ),
42: DECODE( X_SELECTION_CONDITION, FND_API.G_MISS_CHAR, NULL, X_SELECTION_CONDITION ),
43: DECODE( X_START_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, X_START_DATE_ACTIVE ),

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

36: LAST_UPDATED_BY,
37: OBJECT_VERSION_NUMBER
38: ) values (
39: DECODE( X_STYLE_FORMAT_CODE, FND_API.G_MISS_CHAR, NULL, X_STYLE_FORMAT_CODE ),
40: DECODE( X_VARIATION_NUMBER, FND_API.G_MISS_NUM, NULL, X_VARIATION_NUMBER ),
41: DECODE( X_VARIATION_RANK, FND_API.G_MISS_NUM, NULL, X_VARIATION_RANK ),
42: DECODE( X_SELECTION_CONDITION, FND_API.G_MISS_CHAR, NULL, X_SELECTION_CONDITION ),
43: DECODE( X_START_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, X_START_DATE_ACTIVE ),
44: DECODE( X_END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, X_END_DATE_ACTIVE ),

Line 41: DECODE( X_VARIATION_RANK, FND_API.G_MISS_NUM, NULL, X_VARIATION_RANK ),

37: OBJECT_VERSION_NUMBER
38: ) values (
39: DECODE( X_STYLE_FORMAT_CODE, FND_API.G_MISS_CHAR, NULL, X_STYLE_FORMAT_CODE ),
40: DECODE( X_VARIATION_NUMBER, FND_API.G_MISS_NUM, NULL, X_VARIATION_NUMBER ),
41: DECODE( X_VARIATION_RANK, FND_API.G_MISS_NUM, NULL, X_VARIATION_RANK ),
42: DECODE( X_SELECTION_CONDITION, FND_API.G_MISS_CHAR, NULL, X_SELECTION_CONDITION ),
43: DECODE( X_START_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, X_START_DATE_ACTIVE ),
44: DECODE( X_END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, X_END_DATE_ACTIVE ),
45: NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.CREATED_BY),

Line 42: DECODE( X_SELECTION_CONDITION, FND_API.G_MISS_CHAR, NULL, X_SELECTION_CONDITION ),

38: ) values (
39: DECODE( X_STYLE_FORMAT_CODE, FND_API.G_MISS_CHAR, NULL, X_STYLE_FORMAT_CODE ),
40: DECODE( X_VARIATION_NUMBER, FND_API.G_MISS_NUM, NULL, X_VARIATION_NUMBER ),
41: DECODE( X_VARIATION_RANK, FND_API.G_MISS_NUM, NULL, X_VARIATION_RANK ),
42: DECODE( X_SELECTION_CONDITION, FND_API.G_MISS_CHAR, NULL, X_SELECTION_CONDITION ),
43: DECODE( X_START_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, X_START_DATE_ACTIVE ),
44: DECODE( X_END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, X_END_DATE_ACTIVE ),
45: NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.CREATED_BY),
46: HZ_UTILITY_V2PUB.CREATION_DATE,

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

39: DECODE( X_STYLE_FORMAT_CODE, FND_API.G_MISS_CHAR, NULL, X_STYLE_FORMAT_CODE ),
40: DECODE( X_VARIATION_NUMBER, FND_API.G_MISS_NUM, NULL, X_VARIATION_NUMBER ),
41: DECODE( X_VARIATION_RANK, FND_API.G_MISS_NUM, NULL, X_VARIATION_RANK ),
42: DECODE( X_SELECTION_CONDITION, FND_API.G_MISS_CHAR, NULL, X_SELECTION_CONDITION ),
43: DECODE( X_START_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, X_START_DATE_ACTIVE ),
44: DECODE( X_END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, X_END_DATE_ACTIVE ),
45: NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.CREATED_BY),
46: HZ_UTILITY_V2PUB.CREATION_DATE,
47: NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN),

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

40: DECODE( X_VARIATION_NUMBER, FND_API.G_MISS_NUM, NULL, X_VARIATION_NUMBER ),
41: DECODE( X_VARIATION_RANK, FND_API.G_MISS_NUM, NULL, X_VARIATION_RANK ),
42: DECODE( X_SELECTION_CONDITION, FND_API.G_MISS_CHAR, NULL, X_SELECTION_CONDITION ),
43: DECODE( X_START_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, X_START_DATE_ACTIVE ),
44: DECODE( X_END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, X_END_DATE_ACTIVE ),
45: NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.CREATED_BY),
46: HZ_UTILITY_V2PUB.CREATION_DATE,
47: NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN),
48: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

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

46: HZ_UTILITY_V2PUB.CREATION_DATE,
47: NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN),
48: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
49: NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.LAST_UPDATED_BY),
50: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER )
51: );
52:
53: open c;
54: fetch c into X_ROWID;

Line 111: VARIATION_RANK = DECODE( X_VARIATION_RANK, NULL, VARIATION_RANK, FND_API.G_MISS_CHAR, NULL, X_VARIATION_RANK ),

107: ) is
108: begin
109:
110: update HZ_STYLE_FMT_VARIATIONS set
111: VARIATION_RANK = DECODE( X_VARIATION_RANK, NULL, VARIATION_RANK, FND_API.G_MISS_CHAR, NULL, X_VARIATION_RANK ),
112: SELECTION_CONDITION = DECODE( X_SELECTION_CONDITION, NULL, SELECTION_CONDITION, FND_API.G_MISS_CHAR, NULL, X_SELECTION_CONDITION ),
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: SELECTION_CONDITION = DECODE( X_SELECTION_CONDITION, NULL, SELECTION_CONDITION, FND_API.G_MISS_CHAR, NULL, X_SELECTION_CONDITION ),

108: begin
109:
110: update HZ_STYLE_FMT_VARIATIONS set
111: VARIATION_RANK = DECODE( X_VARIATION_RANK, NULL, VARIATION_RANK, FND_API.G_MISS_CHAR, NULL, X_VARIATION_RANK ),
112: SELECTION_CONDITION = DECODE( X_SELECTION_CONDITION, NULL, SELECTION_CONDITION, FND_API.G_MISS_CHAR, NULL, X_SELECTION_CONDITION ),
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:
110: update HZ_STYLE_FMT_VARIATIONS set
111: VARIATION_RANK = DECODE( X_VARIATION_RANK, NULL, VARIATION_RANK, FND_API.G_MISS_CHAR, NULL, X_VARIATION_RANK ),
112: SELECTION_CONDITION = DECODE( X_SELECTION_CONDITION, NULL, SELECTION_CONDITION, FND_API.G_MISS_CHAR, NULL, X_SELECTION_CONDITION ),
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: update HZ_STYLE_FMT_VARIATIONS set
111: VARIATION_RANK = DECODE( X_VARIATION_RANK, NULL, VARIATION_RANK, FND_API.G_MISS_CHAR, NULL, X_VARIATION_RANK ),
112: SELECTION_CONDITION = DECODE( X_SELECTION_CONDITION, NULL, SELECTION_CONDITION, FND_API.G_MISS_CHAR, NULL, X_SELECTION_CONDITION ),
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
121: STYLE_FORMAT_CODE = X_STYLE_FORMAT_CODE and
122: VARIATION_NUMBER = X_VARIATION_NUMBER;
123:

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

136: X_END_DATE_ACTIVE OUT NOCOPY DATE
137: ) IS
138: BEGIN
139: SELECT
140: NVL( STYLE_FORMAT_CODE, FND_API.G_MISS_CHAR ),
141: NVL( VARIATION_NUMBER, FND_API.G_MISS_NUM ),
142: NVL( VARIATION_RANK, FND_API.G_MISS_NUM ),
143: NVL( SELECTION_CONDITION, FND_API.G_MISS_CHAR ),
144: NVL( START_DATE_ACTIVE, FND_API.G_MISS_DATE ),

Line 141: NVL( VARIATION_NUMBER, FND_API.G_MISS_NUM ),

137: ) IS
138: BEGIN
139: SELECT
140: NVL( STYLE_FORMAT_CODE, FND_API.G_MISS_CHAR ),
141: NVL( VARIATION_NUMBER, FND_API.G_MISS_NUM ),
142: NVL( VARIATION_RANK, FND_API.G_MISS_NUM ),
143: NVL( SELECTION_CONDITION, FND_API.G_MISS_CHAR ),
144: NVL( START_DATE_ACTIVE, FND_API.G_MISS_DATE ),
145: NVL( END_DATE_ACTIVE, FND_API.G_MISS_DATE )

Line 142: NVL( VARIATION_RANK, FND_API.G_MISS_NUM ),

138: BEGIN
139: SELECT
140: NVL( STYLE_FORMAT_CODE, FND_API.G_MISS_CHAR ),
141: NVL( VARIATION_NUMBER, FND_API.G_MISS_NUM ),
142: NVL( VARIATION_RANK, FND_API.G_MISS_NUM ),
143: NVL( SELECTION_CONDITION, FND_API.G_MISS_CHAR ),
144: NVL( START_DATE_ACTIVE, FND_API.G_MISS_DATE ),
145: NVL( END_DATE_ACTIVE, FND_API.G_MISS_DATE )
146: INTO X_STYLE_FORMAT_CODE,

Line 143: NVL( SELECTION_CONDITION, FND_API.G_MISS_CHAR ),

139: SELECT
140: NVL( STYLE_FORMAT_CODE, FND_API.G_MISS_CHAR ),
141: NVL( VARIATION_NUMBER, FND_API.G_MISS_NUM ),
142: NVL( VARIATION_RANK, FND_API.G_MISS_NUM ),
143: NVL( SELECTION_CONDITION, FND_API.G_MISS_CHAR ),
144: NVL( START_DATE_ACTIVE, FND_API.G_MISS_DATE ),
145: NVL( END_DATE_ACTIVE, FND_API.G_MISS_DATE )
146: INTO X_STYLE_FORMAT_CODE,
147: X_VARIATION_NUMBER,

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

140: NVL( STYLE_FORMAT_CODE, FND_API.G_MISS_CHAR ),
141: NVL( VARIATION_NUMBER, FND_API.G_MISS_NUM ),
142: NVL( VARIATION_RANK, FND_API.G_MISS_NUM ),
143: NVL( SELECTION_CONDITION, FND_API.G_MISS_CHAR ),
144: NVL( START_DATE_ACTIVE, FND_API.G_MISS_DATE ),
145: NVL( END_DATE_ACTIVE, FND_API.G_MISS_DATE )
146: INTO X_STYLE_FORMAT_CODE,
147: X_VARIATION_NUMBER,
148: X_VARIATION_RANK,

Line 145: NVL( END_DATE_ACTIVE, FND_API.G_MISS_DATE )

141: NVL( VARIATION_NUMBER, FND_API.G_MISS_NUM ),
142: NVL( VARIATION_RANK, FND_API.G_MISS_NUM ),
143: NVL( SELECTION_CONDITION, FND_API.G_MISS_CHAR ),
144: NVL( START_DATE_ACTIVE, FND_API.G_MISS_DATE ),
145: NVL( END_DATE_ACTIVE, FND_API.G_MISS_DATE )
146: INTO X_STYLE_FORMAT_CODE,
147: X_VARIATION_NUMBER,
148: X_VARIATION_RANK,
149: X_SELECTION_CONDITION,

Line 162: RAISE FND_API.G_EXC_ERROR;

158: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
159: FND_MESSAGE.SET_TOKEN( 'RECORD', 'style_fmt_variation_rec');
160: FND_MESSAGE.SET_TOKEN( 'VALUE', 'STYLE_FORMAT_CODE, VARIATION_NUMBER' );
161: FND_MSG_PUB.ADD;
162: RAISE FND_API.G_EXC_ERROR;
163:
164: END SELECT_ROW;
165:
166: