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

Line 25: IF ( px_SECONDARY_TRANSFORM_ID IS NULL) OR (px_SECONDARY_TRANSFORM_ID = FND_API.G_MISS_NUM) THEN

21: l_success VARCHAR2(1) := 'N';
22: BEGIN
23: WHILE l_success = 'N' LOOP
24: BEGIN
25: IF ( px_SECONDARY_TRANSFORM_ID IS NULL) OR (px_SECONDARY_TRANSFORM_ID = FND_API.G_MISS_NUM) THEN
26: OPEN C2;
27: FETCH C2 INTO px_SECONDARY_TRANSFORM_ID;
28: CLOSE C2;
29: END IF;

Line 48: decode(p_SECONDARY_ATTRIBUTE_ID , FND_API.G_MISS_NUM , NULL, p_SECONDARY_ATTRIBUTE_ID),

44: OBJECT_VERSION_NUMBER
45: )
46: VALUES (
47: px_SECONDARY_TRANSFORM_ID,
48: decode(p_SECONDARY_ATTRIBUTE_ID , FND_API.G_MISS_NUM , NULL, p_SECONDARY_ATTRIBUTE_ID),
49: decode(p_FUNCTION_ID, FND_API.G_MISS_NUM , NULL, p_FUNCTION_ID),
50: decode(p_TRANSFORMATION_WEIGHT, FND_API.G_MISS_NUM , NULL, p_TRANSFORMATION_WEIGHT),
51: decode(p_SIMILARITY_CUTOFF, FND_API.G_MISS_NUM , NULL, p_SIMILARITY_CUTOFF),
52: decode(p_ACTIVE_FLAG, FND_API.G_MISS_CHAR ,NULL, p_ACTIVE_FLAG),

Line 49: decode(p_FUNCTION_ID, FND_API.G_MISS_NUM , NULL, p_FUNCTION_ID),

45: )
46: VALUES (
47: px_SECONDARY_TRANSFORM_ID,
48: decode(p_SECONDARY_ATTRIBUTE_ID , FND_API.G_MISS_NUM , NULL, p_SECONDARY_ATTRIBUTE_ID),
49: decode(p_FUNCTION_ID, FND_API.G_MISS_NUM , NULL, p_FUNCTION_ID),
50: decode(p_TRANSFORMATION_WEIGHT, FND_API.G_MISS_NUM , NULL, p_TRANSFORMATION_WEIGHT),
51: decode(p_SIMILARITY_CUTOFF, FND_API.G_MISS_NUM , NULL, p_SIMILARITY_CUTOFF),
52: decode(p_ACTIVE_FLAG, FND_API.G_MISS_CHAR ,NULL, p_ACTIVE_FLAG),
53: decode(p_USE_EXACT, FND_API.G_MISS_CHAR ,NULL, p_USE_EXACT),

Line 50: decode(p_TRANSFORMATION_WEIGHT, FND_API.G_MISS_NUM , NULL, p_TRANSFORMATION_WEIGHT),

46: VALUES (
47: px_SECONDARY_TRANSFORM_ID,
48: decode(p_SECONDARY_ATTRIBUTE_ID , FND_API.G_MISS_NUM , NULL, p_SECONDARY_ATTRIBUTE_ID),
49: decode(p_FUNCTION_ID, FND_API.G_MISS_NUM , NULL, p_FUNCTION_ID),
50: decode(p_TRANSFORMATION_WEIGHT, FND_API.G_MISS_NUM , NULL, p_TRANSFORMATION_WEIGHT),
51: decode(p_SIMILARITY_CUTOFF, FND_API.G_MISS_NUM , NULL, p_SIMILARITY_CUTOFF),
52: decode(p_ACTIVE_FLAG, FND_API.G_MISS_CHAR ,NULL, p_ACTIVE_FLAG),
53: decode(p_USE_EXACT, FND_API.G_MISS_CHAR ,NULL, p_USE_EXACT),
54: decode(p_created_by, FND_API.G_MISS_NUM , NULL, p_created_by),

Line 51: decode(p_SIMILARITY_CUTOFF, FND_API.G_MISS_NUM , NULL, p_SIMILARITY_CUTOFF),

47: px_SECONDARY_TRANSFORM_ID,
48: decode(p_SECONDARY_ATTRIBUTE_ID , FND_API.G_MISS_NUM , NULL, p_SECONDARY_ATTRIBUTE_ID),
49: decode(p_FUNCTION_ID, FND_API.G_MISS_NUM , NULL, p_FUNCTION_ID),
50: decode(p_TRANSFORMATION_WEIGHT, FND_API.G_MISS_NUM , NULL, p_TRANSFORMATION_WEIGHT),
51: decode(p_SIMILARITY_CUTOFF, FND_API.G_MISS_NUM , NULL, p_SIMILARITY_CUTOFF),
52: decode(p_ACTIVE_FLAG, FND_API.G_MISS_CHAR ,NULL, p_ACTIVE_FLAG),
53: decode(p_USE_EXACT, FND_API.G_MISS_CHAR ,NULL, p_USE_EXACT),
54: decode(p_created_by, FND_API.G_MISS_NUM , NULL, p_created_by),
55: decode(p_creation_date, FND_API.G_MISS_DATE ,to_date(NULL), p_creation_date),

Line 52: decode(p_ACTIVE_FLAG, FND_API.G_MISS_CHAR ,NULL, p_ACTIVE_FLAG),

48: decode(p_SECONDARY_ATTRIBUTE_ID , FND_API.G_MISS_NUM , NULL, p_SECONDARY_ATTRIBUTE_ID),
49: decode(p_FUNCTION_ID, FND_API.G_MISS_NUM , NULL, p_FUNCTION_ID),
50: decode(p_TRANSFORMATION_WEIGHT, FND_API.G_MISS_NUM , NULL, p_TRANSFORMATION_WEIGHT),
51: decode(p_SIMILARITY_CUTOFF, FND_API.G_MISS_NUM , NULL, p_SIMILARITY_CUTOFF),
52: decode(p_ACTIVE_FLAG, FND_API.G_MISS_CHAR ,NULL, p_ACTIVE_FLAG),
53: decode(p_USE_EXACT, FND_API.G_MISS_CHAR ,NULL, p_USE_EXACT),
54: decode(p_created_by, FND_API.G_MISS_NUM , NULL, p_created_by),
55: decode(p_creation_date, FND_API.G_MISS_DATE ,to_date(NULL), p_creation_date),
56: decode(p_last_update_login, FND_API.G_MISS_NUM , NULL, p_last_update_login),

Line 53: decode(p_USE_EXACT, FND_API.G_MISS_CHAR ,NULL, p_USE_EXACT),

49: decode(p_FUNCTION_ID, FND_API.G_MISS_NUM , NULL, p_FUNCTION_ID),
50: decode(p_TRANSFORMATION_WEIGHT, FND_API.G_MISS_NUM , NULL, p_TRANSFORMATION_WEIGHT),
51: decode(p_SIMILARITY_CUTOFF, FND_API.G_MISS_NUM , NULL, p_SIMILARITY_CUTOFF),
52: decode(p_ACTIVE_FLAG, FND_API.G_MISS_CHAR ,NULL, p_ACTIVE_FLAG),
53: decode(p_USE_EXACT, FND_API.G_MISS_CHAR ,NULL, p_USE_EXACT),
54: decode(p_created_by, FND_API.G_MISS_NUM , NULL, p_created_by),
55: decode(p_creation_date, FND_API.G_MISS_DATE ,to_date(NULL), p_creation_date),
56: decode(p_last_update_login, FND_API.G_MISS_NUM , NULL, p_last_update_login),
57: decode(p_last_update_date, FND_API.G_MISS_DATE ,to_date(NULL), p_last_update_date),

Line 54: decode(p_created_by, FND_API.G_MISS_NUM , NULL, p_created_by),

50: decode(p_TRANSFORMATION_WEIGHT, FND_API.G_MISS_NUM , NULL, p_TRANSFORMATION_WEIGHT),
51: decode(p_SIMILARITY_CUTOFF, FND_API.G_MISS_NUM , NULL, p_SIMILARITY_CUTOFF),
52: decode(p_ACTIVE_FLAG, FND_API.G_MISS_CHAR ,NULL, p_ACTIVE_FLAG),
53: decode(p_USE_EXACT, FND_API.G_MISS_CHAR ,NULL, p_USE_EXACT),
54: decode(p_created_by, FND_API.G_MISS_NUM , NULL, p_created_by),
55: decode(p_creation_date, FND_API.G_MISS_DATE ,to_date(NULL), p_creation_date),
56: decode(p_last_update_login, FND_API.G_MISS_NUM , NULL, p_last_update_login),
57: decode(p_last_update_date, FND_API.G_MISS_DATE ,to_date(NULL), p_last_update_date),
58: decode(p_last_updated_by, FND_API.G_MISS_NUM , NULL, p_last_updated_by),

Line 55: decode(p_creation_date, FND_API.G_MISS_DATE ,to_date(NULL), p_creation_date),

51: decode(p_SIMILARITY_CUTOFF, FND_API.G_MISS_NUM , NULL, p_SIMILARITY_CUTOFF),
52: decode(p_ACTIVE_FLAG, FND_API.G_MISS_CHAR ,NULL, p_ACTIVE_FLAG),
53: decode(p_USE_EXACT, FND_API.G_MISS_CHAR ,NULL, p_USE_EXACT),
54: decode(p_created_by, FND_API.G_MISS_NUM , NULL, p_created_by),
55: decode(p_creation_date, FND_API.G_MISS_DATE ,to_date(NULL), p_creation_date),
56: decode(p_last_update_login, FND_API.G_MISS_NUM , NULL, p_last_update_login),
57: decode(p_last_update_date, FND_API.G_MISS_DATE ,to_date(NULL), p_last_update_date),
58: decode(p_last_updated_by, FND_API.G_MISS_NUM , NULL, p_last_updated_by),
59: 1

Line 56: decode(p_last_update_login, FND_API.G_MISS_NUM , NULL, p_last_update_login),

52: decode(p_ACTIVE_FLAG, FND_API.G_MISS_CHAR ,NULL, p_ACTIVE_FLAG),
53: decode(p_USE_EXACT, FND_API.G_MISS_CHAR ,NULL, p_USE_EXACT),
54: decode(p_created_by, FND_API.G_MISS_NUM , NULL, p_created_by),
55: decode(p_creation_date, FND_API.G_MISS_DATE ,to_date(NULL), p_creation_date),
56: decode(p_last_update_login, FND_API.G_MISS_NUM , NULL, p_last_update_login),
57: decode(p_last_update_date, FND_API.G_MISS_DATE ,to_date(NULL), p_last_update_date),
58: decode(p_last_updated_by, FND_API.G_MISS_NUM , NULL, p_last_updated_by),
59: 1
60: );

Line 57: decode(p_last_update_date, FND_API.G_MISS_DATE ,to_date(NULL), p_last_update_date),

53: decode(p_USE_EXACT, FND_API.G_MISS_CHAR ,NULL, p_USE_EXACT),
54: decode(p_created_by, FND_API.G_MISS_NUM , NULL, p_created_by),
55: decode(p_creation_date, FND_API.G_MISS_DATE ,to_date(NULL), p_creation_date),
56: decode(p_last_update_login, FND_API.G_MISS_NUM , NULL, p_last_update_login),
57: decode(p_last_update_date, FND_API.G_MISS_DATE ,to_date(NULL), p_last_update_date),
58: decode(p_last_updated_by, FND_API.G_MISS_NUM , NULL, p_last_updated_by),
59: 1
60: );
61:

Line 58: decode(p_last_updated_by, FND_API.G_MISS_NUM , NULL, p_last_updated_by),

54: decode(p_created_by, FND_API.G_MISS_NUM , NULL, p_created_by),
55: decode(p_creation_date, FND_API.G_MISS_DATE ,to_date(NULL), p_creation_date),
56: decode(p_last_update_login, FND_API.G_MISS_NUM , NULL, p_last_update_login),
57: decode(p_last_update_date, FND_API.G_MISS_DATE ,to_date(NULL), p_last_update_date),
58: decode(p_last_updated_by, FND_API.G_MISS_NUM , NULL, p_last_updated_by),
59: 1
60: );
61:
62: l_success := 'Y';

Line 111: SECONDARY_ATTRIBUTE_ID = decode(p_SECONDARY_ATTRIBUTE_ID ,FND_API.G_MISS_NUM,SECONDARY_ATTRIBUTE_ID,

107: l_object_version_number := NVL(p_object_version_number, 1) + 1;
108:
109: UPDATE hz_SECONDARY_trans
110: SET
111: SECONDARY_ATTRIBUTE_ID = decode(p_SECONDARY_ATTRIBUTE_ID ,FND_API.G_MISS_NUM,SECONDARY_ATTRIBUTE_ID,
112: p_SECONDARY_ATTRIBUTE_ID),
113: FUNCTION_ID = decode(p_FUNCTION_ID ,FND_API.G_MISS_NUM,FUNCTION_ID,
114: p_FUNCTION_ID),
115: TRANSFORMATION_WEIGHT = decode(p_TRANSFORMATION_WEIGHT ,FND_API.G_MISS_NUM,TRANSFORMATION_WEIGHT,

Line 113: FUNCTION_ID = decode(p_FUNCTION_ID ,FND_API.G_MISS_NUM,FUNCTION_ID,

109: UPDATE hz_SECONDARY_trans
110: SET
111: SECONDARY_ATTRIBUTE_ID = decode(p_SECONDARY_ATTRIBUTE_ID ,FND_API.G_MISS_NUM,SECONDARY_ATTRIBUTE_ID,
112: p_SECONDARY_ATTRIBUTE_ID),
113: FUNCTION_ID = decode(p_FUNCTION_ID ,FND_API.G_MISS_NUM,FUNCTION_ID,
114: p_FUNCTION_ID),
115: TRANSFORMATION_WEIGHT = decode(p_TRANSFORMATION_WEIGHT ,FND_API.G_MISS_NUM,TRANSFORMATION_WEIGHT,
116: p_TRANSFORMATION_WEIGHT),
117: SIMILARITY_CUTOFF = decode(p_SIMILARITY_CUTOFF ,FND_API.G_MISS_NUM,SIMILARITY_CUTOFF,

Line 115: TRANSFORMATION_WEIGHT = decode(p_TRANSFORMATION_WEIGHT ,FND_API.G_MISS_NUM,TRANSFORMATION_WEIGHT,

111: SECONDARY_ATTRIBUTE_ID = decode(p_SECONDARY_ATTRIBUTE_ID ,FND_API.G_MISS_NUM,SECONDARY_ATTRIBUTE_ID,
112: p_SECONDARY_ATTRIBUTE_ID),
113: FUNCTION_ID = decode(p_FUNCTION_ID ,FND_API.G_MISS_NUM,FUNCTION_ID,
114: p_FUNCTION_ID),
115: TRANSFORMATION_WEIGHT = decode(p_TRANSFORMATION_WEIGHT ,FND_API.G_MISS_NUM,TRANSFORMATION_WEIGHT,
116: p_TRANSFORMATION_WEIGHT),
117: SIMILARITY_CUTOFF = decode(p_SIMILARITY_CUTOFF ,FND_API.G_MISS_NUM,SIMILARITY_CUTOFF,
118: p_SIMILARITY_CUTOFF),
119: ACTIVE_FLAG = decode(p_ACTIVE_FLAG ,FND_API.G_MISS_CHAR,ACTIVE_FLAG,

Line 117: SIMILARITY_CUTOFF = decode(p_SIMILARITY_CUTOFF ,FND_API.G_MISS_NUM,SIMILARITY_CUTOFF,

113: FUNCTION_ID = decode(p_FUNCTION_ID ,FND_API.G_MISS_NUM,FUNCTION_ID,
114: p_FUNCTION_ID),
115: TRANSFORMATION_WEIGHT = decode(p_TRANSFORMATION_WEIGHT ,FND_API.G_MISS_NUM,TRANSFORMATION_WEIGHT,
116: p_TRANSFORMATION_WEIGHT),
117: SIMILARITY_CUTOFF = decode(p_SIMILARITY_CUTOFF ,FND_API.G_MISS_NUM,SIMILARITY_CUTOFF,
118: p_SIMILARITY_CUTOFF),
119: ACTIVE_FLAG = decode(p_ACTIVE_FLAG ,FND_API.G_MISS_CHAR,ACTIVE_FLAG,
120: p_ACTIVE_FLAG),
121: USE_EXACT = decode(p_USE_EXACT ,FND_API.G_MISS_CHAR,USE_EXACT,

Line 119: ACTIVE_FLAG = decode(p_ACTIVE_FLAG ,FND_API.G_MISS_CHAR,ACTIVE_FLAG,

115: TRANSFORMATION_WEIGHT = decode(p_TRANSFORMATION_WEIGHT ,FND_API.G_MISS_NUM,TRANSFORMATION_WEIGHT,
116: p_TRANSFORMATION_WEIGHT),
117: SIMILARITY_CUTOFF = decode(p_SIMILARITY_CUTOFF ,FND_API.G_MISS_NUM,SIMILARITY_CUTOFF,
118: p_SIMILARITY_CUTOFF),
119: ACTIVE_FLAG = decode(p_ACTIVE_FLAG ,FND_API.G_MISS_CHAR,ACTIVE_FLAG,
120: p_ACTIVE_FLAG),
121: USE_EXACT = decode(p_USE_EXACT ,FND_API.G_MISS_CHAR,USE_EXACT,
122: p_USE_EXACT),
123: -- Bug 3032780

Line 121: USE_EXACT = decode(p_USE_EXACT ,FND_API.G_MISS_CHAR,USE_EXACT,

117: SIMILARITY_CUTOFF = decode(p_SIMILARITY_CUTOFF ,FND_API.G_MISS_NUM,SIMILARITY_CUTOFF,
118: p_SIMILARITY_CUTOFF),
119: ACTIVE_FLAG = decode(p_ACTIVE_FLAG ,FND_API.G_MISS_CHAR,ACTIVE_FLAG,
120: p_ACTIVE_FLAG),
121: USE_EXACT = decode(p_USE_EXACT ,FND_API.G_MISS_CHAR,USE_EXACT,
122: p_USE_EXACT),
123: -- Bug 3032780
124: /*
125: CREATED_BY = decode(p_created_by ,FND_API.G_MISS_NUM,CREATED_BY,

Line 125: CREATED_BY = decode(p_created_by ,FND_API.G_MISS_NUM,CREATED_BY,

121: USE_EXACT = decode(p_USE_EXACT ,FND_API.G_MISS_CHAR,USE_EXACT,
122: p_USE_EXACT),
123: -- Bug 3032780
124: /*
125: CREATED_BY = decode(p_created_by ,FND_API.G_MISS_NUM,CREATED_BY,
126: p_created_by),
127: CREATION_DATE = decode(p_CREATION_DATE ,FND_API.G_MISS_DATE,CREATION_DATE,
128: p_CREATION_DATE),
129: */

Line 127: CREATION_DATE = decode(p_CREATION_DATE ,FND_API.G_MISS_DATE,CREATION_DATE,

123: -- Bug 3032780
124: /*
125: CREATED_BY = decode(p_created_by ,FND_API.G_MISS_NUM,CREATED_BY,
126: p_created_by),
127: CREATION_DATE = decode(p_CREATION_DATE ,FND_API.G_MISS_DATE,CREATION_DATE,
128: p_CREATION_DATE),
129: */
130: LAST_UPDATE_LOGIN = decode(p_LAST_UPDATE_LOGIN ,FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,
131: p_LAST_UPDATE_LOGIN),

Line 130: LAST_UPDATE_LOGIN = decode(p_LAST_UPDATE_LOGIN ,FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,

126: p_created_by),
127: CREATION_DATE = decode(p_CREATION_DATE ,FND_API.G_MISS_DATE,CREATION_DATE,
128: p_CREATION_DATE),
129: */
130: LAST_UPDATE_LOGIN = decode(p_LAST_UPDATE_LOGIN ,FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,
131: p_LAST_UPDATE_LOGIN),
132: LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE ,FND_API.G_MISS_DATE,LAST_UPDATE_DATE,
133: p_LAST_UPDATE_DATE),
134: LAST_UPDATED_BY = decode(p_LAST_UPDATED_BY ,FND_API.G_MISS_NUM,LAST_UPDATED_BY,

Line 132: LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE ,FND_API.G_MISS_DATE,LAST_UPDATE_DATE,

128: p_CREATION_DATE),
129: */
130: LAST_UPDATE_LOGIN = decode(p_LAST_UPDATE_LOGIN ,FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,
131: p_LAST_UPDATE_LOGIN),
132: LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE ,FND_API.G_MISS_DATE,LAST_UPDATE_DATE,
133: p_LAST_UPDATE_DATE),
134: LAST_UPDATED_BY = decode(p_LAST_UPDATED_BY ,FND_API.G_MISS_NUM,LAST_UPDATED_BY,
135: p_LAST_UPDATED_BY),
136: OBJECT_VERSION_NUMBER = decode(l_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER,l_object_version_number)

Line 134: LAST_UPDATED_BY = decode(p_LAST_UPDATED_BY ,FND_API.G_MISS_NUM,LAST_UPDATED_BY,

130: LAST_UPDATE_LOGIN = decode(p_LAST_UPDATE_LOGIN ,FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,
131: p_LAST_UPDATE_LOGIN),
132: LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE ,FND_API.G_MISS_DATE,LAST_UPDATE_DATE,
133: p_LAST_UPDATE_DATE),
134: LAST_UPDATED_BY = decode(p_LAST_UPDATED_BY ,FND_API.G_MISS_NUM,LAST_UPDATED_BY,
135: p_LAST_UPDATED_BY),
136: OBJECT_VERSION_NUMBER = decode(l_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER,l_object_version_number)
137: WHERE SECONDARY_TRANSFORM_ID = p_SECONDARY_TRANSFORM_ID;
138:

Line 136: OBJECT_VERSION_NUMBER = decode(l_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER,l_object_version_number)

132: LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE ,FND_API.G_MISS_DATE,LAST_UPDATE_DATE,
133: p_LAST_UPDATE_DATE),
134: LAST_UPDATED_BY = decode(p_LAST_UPDATED_BY ,FND_API.G_MISS_NUM,LAST_UPDATED_BY,
135: p_LAST_UPDATED_BY),
136: OBJECT_VERSION_NUMBER = decode(l_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER,l_object_version_number)
137: WHERE SECONDARY_TRANSFORM_ID = p_SECONDARY_TRANSFORM_ID;
138:
139: p_OBJECT_VERSION_NUMBER := l_OBJECT_VERSION_NUMBER;
140: