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

Line 23: IF ( px_PRIMARY_TRANSFORM_ID IS NULL) OR (px_PRIMARY_TRANSFORM_ID = FND_API.G_MISS_NUM) THEN

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

Line 42: decode(p_PRIMARY_ATTRIBUTE_ID, FND_API.G_MISS_NUM, NULL, p_PRIMARY_ATTRIBUTE_ID),

38: OBJECT_VERSION_NUMBER
39: )
40: VALUES (
41: px_PRIMARY_TRANSFORM_ID,
42: decode(p_PRIMARY_ATTRIBUTE_ID, FND_API.G_MISS_NUM, NULL, p_PRIMARY_ATTRIBUTE_ID),
43: decode(p_FUNCTION_ID, FND_API.G_MISS_NUM, NULL, p_FUNCTION_ID),
44: decode(p_ACTIVE_FLAG, FND_API.G_MISS_CHAR, NULL, p_ACTIVE_FLAG),
45: decode(p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by),
46: decode(p_creation_date, FND_API.G_MISS_DATE, to_date(NULL), p_creation_date),

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

39: )
40: VALUES (
41: px_PRIMARY_TRANSFORM_ID,
42: decode(p_PRIMARY_ATTRIBUTE_ID, FND_API.G_MISS_NUM, NULL, p_PRIMARY_ATTRIBUTE_ID),
43: decode(p_FUNCTION_ID, FND_API.G_MISS_NUM, NULL, p_FUNCTION_ID),
44: decode(p_ACTIVE_FLAG, FND_API.G_MISS_CHAR, NULL, p_ACTIVE_FLAG),
45: decode(p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by),
46: decode(p_creation_date, FND_API.G_MISS_DATE, to_date(NULL), p_creation_date),
47: decode(p_last_update_login, FND_API.G_MISS_NUM, NULL, p_last_update_login),

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

40: VALUES (
41: px_PRIMARY_TRANSFORM_ID,
42: decode(p_PRIMARY_ATTRIBUTE_ID, FND_API.G_MISS_NUM, NULL, p_PRIMARY_ATTRIBUTE_ID),
43: decode(p_FUNCTION_ID, FND_API.G_MISS_NUM, NULL, p_FUNCTION_ID),
44: decode(p_ACTIVE_FLAG, FND_API.G_MISS_CHAR, NULL, p_ACTIVE_FLAG),
45: decode(p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by),
46: decode(p_creation_date, FND_API.G_MISS_DATE, to_date(NULL), p_creation_date),
47: decode(p_last_update_login, FND_API.G_MISS_NUM, NULL, p_last_update_login),
48: decode(p_last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),

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

41: px_PRIMARY_TRANSFORM_ID,
42: decode(p_PRIMARY_ATTRIBUTE_ID, FND_API.G_MISS_NUM, NULL, p_PRIMARY_ATTRIBUTE_ID),
43: decode(p_FUNCTION_ID, FND_API.G_MISS_NUM, NULL, p_FUNCTION_ID),
44: decode(p_ACTIVE_FLAG, FND_API.G_MISS_CHAR, NULL, p_ACTIVE_FLAG),
45: decode(p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by),
46: decode(p_creation_date, FND_API.G_MISS_DATE, to_date(NULL), p_creation_date),
47: decode(p_last_update_login, FND_API.G_MISS_NUM, NULL, p_last_update_login),
48: decode(p_last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),
49: decode(p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by),

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

42: decode(p_PRIMARY_ATTRIBUTE_ID, FND_API.G_MISS_NUM, NULL, p_PRIMARY_ATTRIBUTE_ID),
43: decode(p_FUNCTION_ID, FND_API.G_MISS_NUM, NULL, p_FUNCTION_ID),
44: decode(p_ACTIVE_FLAG, FND_API.G_MISS_CHAR, NULL, p_ACTIVE_FLAG),
45: decode(p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by),
46: decode(p_creation_date, FND_API.G_MISS_DATE, to_date(NULL), p_creation_date),
47: decode(p_last_update_login, FND_API.G_MISS_NUM, NULL, p_last_update_login),
48: decode(p_last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),
49: decode(p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by),
50: 1

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

43: decode(p_FUNCTION_ID, FND_API.G_MISS_NUM, NULL, p_FUNCTION_ID),
44: decode(p_ACTIVE_FLAG, FND_API.G_MISS_CHAR, NULL, p_ACTIVE_FLAG),
45: decode(p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by),
46: decode(p_creation_date, FND_API.G_MISS_DATE, to_date(NULL), p_creation_date),
47: decode(p_last_update_login, FND_API.G_MISS_NUM, NULL, p_last_update_login),
48: decode(p_last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),
49: decode(p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by),
50: 1
51: );

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

44: decode(p_ACTIVE_FLAG, FND_API.G_MISS_CHAR, NULL, p_ACTIVE_FLAG),
45: decode(p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by),
46: decode(p_creation_date, FND_API.G_MISS_DATE, to_date(NULL), p_creation_date),
47: decode(p_last_update_login, FND_API.G_MISS_NUM, NULL, p_last_update_login),
48: decode(p_last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),
49: decode(p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by),
50: 1
51: );
52:

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

45: decode(p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by),
46: decode(p_creation_date, FND_API.G_MISS_DATE, to_date(NULL), p_creation_date),
47: decode(p_last_update_login, FND_API.G_MISS_NUM, NULL, p_last_update_login),
48: decode(p_last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),
49: decode(p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by),
50: 1
51: );
52:
53: l_success := 'Y';

Line 99: PRIMARY_ATTRIBUTE_ID= decode(p_PRIMARY_ATTRIBUTE_ID, FND_API.G_MISS_NUM, PRIMARY_ATTRIBUTE_ID,

95: l_object_version_number := NVL(p_object_version_number, 1) + 1;
96:
97: UPDATE hz_primary_trans
98: SET
99: PRIMARY_ATTRIBUTE_ID= decode(p_PRIMARY_ATTRIBUTE_ID, FND_API.G_MISS_NUM, PRIMARY_ATTRIBUTE_ID,
100: p_PRIMARY_ATTRIBUTE_ID),
101: FUNCTION_ID = decode(p_FUNCTION_ID, FND_API.G_MISS_NUM, FUNCTION_ID , p_FUNCTION_ID),
102: ACTIVE_FLAG = decode(p_ACTIVE_FLAG, FND_API.G_MISS_CHAR, ACTIVE_FLAG , p_ACTIVE_FLAG),
103: -- Bug 3032780

Line 101: FUNCTION_ID = decode(p_FUNCTION_ID, FND_API.G_MISS_NUM, FUNCTION_ID , p_FUNCTION_ID),

97: UPDATE hz_primary_trans
98: SET
99: PRIMARY_ATTRIBUTE_ID= decode(p_PRIMARY_ATTRIBUTE_ID, FND_API.G_MISS_NUM, PRIMARY_ATTRIBUTE_ID,
100: p_PRIMARY_ATTRIBUTE_ID),
101: FUNCTION_ID = decode(p_FUNCTION_ID, FND_API.G_MISS_NUM, FUNCTION_ID , p_FUNCTION_ID),
102: ACTIVE_FLAG = decode(p_ACTIVE_FLAG, FND_API.G_MISS_CHAR, ACTIVE_FLAG , p_ACTIVE_FLAG),
103: -- Bug 3032780
104: /*
105: CREATED_BY = decode(p_created_by, FND_API.G_MISS_NUM, CREATED_BY , p_created_by),

Line 102: ACTIVE_FLAG = decode(p_ACTIVE_FLAG, FND_API.G_MISS_CHAR, ACTIVE_FLAG , p_ACTIVE_FLAG),

98: SET
99: PRIMARY_ATTRIBUTE_ID= decode(p_PRIMARY_ATTRIBUTE_ID, FND_API.G_MISS_NUM, PRIMARY_ATTRIBUTE_ID,
100: p_PRIMARY_ATTRIBUTE_ID),
101: FUNCTION_ID = decode(p_FUNCTION_ID, FND_API.G_MISS_NUM, FUNCTION_ID , p_FUNCTION_ID),
102: ACTIVE_FLAG = decode(p_ACTIVE_FLAG, FND_API.G_MISS_CHAR, ACTIVE_FLAG , p_ACTIVE_FLAG),
103: -- Bug 3032780
104: /*
105: CREATED_BY = decode(p_created_by, FND_API.G_MISS_NUM, CREATED_BY , p_created_by),
106: CREATION_DATE = decode(p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE ,p_CREATION_DATE),

Line 105: CREATED_BY = decode(p_created_by, FND_API.G_MISS_NUM, CREATED_BY , p_created_by),

101: FUNCTION_ID = decode(p_FUNCTION_ID, FND_API.G_MISS_NUM, FUNCTION_ID , p_FUNCTION_ID),
102: ACTIVE_FLAG = decode(p_ACTIVE_FLAG, FND_API.G_MISS_CHAR, ACTIVE_FLAG , p_ACTIVE_FLAG),
103: -- Bug 3032780
104: /*
105: CREATED_BY = decode(p_created_by, FND_API.G_MISS_NUM, CREATED_BY , p_created_by),
106: CREATION_DATE = decode(p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE ,p_CREATION_DATE),
107: */
108: LAST_UPDATE_LOGIN = decode(p_LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN ,p_LAST_UPDATE_LOGIN),
109: LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE ,p_LAST_UPDATE_DATE),

Line 106: CREATION_DATE = decode(p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE ,p_CREATION_DATE),

102: ACTIVE_FLAG = decode(p_ACTIVE_FLAG, FND_API.G_MISS_CHAR, ACTIVE_FLAG , p_ACTIVE_FLAG),
103: -- Bug 3032780
104: /*
105: CREATED_BY = decode(p_created_by, FND_API.G_MISS_NUM, CREATED_BY , p_created_by),
106: CREATION_DATE = decode(p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE ,p_CREATION_DATE),
107: */
108: LAST_UPDATE_LOGIN = decode(p_LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN ,p_LAST_UPDATE_LOGIN),
109: LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE ,p_LAST_UPDATE_DATE),
110: LAST_UPDATED_BY = decode(p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY ,p_LAST_UPDATED_BY),

Line 108: LAST_UPDATE_LOGIN = decode(p_LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN ,p_LAST_UPDATE_LOGIN),

104: /*
105: CREATED_BY = decode(p_created_by, FND_API.G_MISS_NUM, CREATED_BY , p_created_by),
106: CREATION_DATE = decode(p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE ,p_CREATION_DATE),
107: */
108: LAST_UPDATE_LOGIN = decode(p_LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN ,p_LAST_UPDATE_LOGIN),
109: LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE ,p_LAST_UPDATE_DATE),
110: LAST_UPDATED_BY = decode(p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY ,p_LAST_UPDATED_BY),
111: OBJECT_VERSION_NUMBER = decode(l_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER,l_object_version_number)
112: WHERE PRIMARY_TRANSFORM_ID = p_PRIMARY_TRANSFORM_ID;

Line 109: LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE ,p_LAST_UPDATE_DATE),

105: CREATED_BY = decode(p_created_by, FND_API.G_MISS_NUM, CREATED_BY , p_created_by),
106: CREATION_DATE = decode(p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE ,p_CREATION_DATE),
107: */
108: LAST_UPDATE_LOGIN = decode(p_LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN ,p_LAST_UPDATE_LOGIN),
109: LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE ,p_LAST_UPDATE_DATE),
110: LAST_UPDATED_BY = decode(p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY ,p_LAST_UPDATED_BY),
111: OBJECT_VERSION_NUMBER = decode(l_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER,l_object_version_number)
112: WHERE PRIMARY_TRANSFORM_ID = p_PRIMARY_TRANSFORM_ID;
113:

Line 110: LAST_UPDATED_BY = decode(p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY ,p_LAST_UPDATED_BY),

106: CREATION_DATE = decode(p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE ,p_CREATION_DATE),
107: */
108: LAST_UPDATE_LOGIN = decode(p_LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN ,p_LAST_UPDATE_LOGIN),
109: LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE ,p_LAST_UPDATE_DATE),
110: LAST_UPDATED_BY = decode(p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY ,p_LAST_UPDATED_BY),
111: OBJECT_VERSION_NUMBER = decode(l_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER,l_object_version_number)
112: WHERE PRIMARY_TRANSFORM_ID = p_PRIMARY_TRANSFORM_ID;
113:
114: p_OBJECT_VERSION_NUMBER := l_OBJECT_VERSION_NUMBER;

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

107: */
108: LAST_UPDATE_LOGIN = decode(p_LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN ,p_LAST_UPDATE_LOGIN),
109: LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE ,p_LAST_UPDATE_DATE),
110: LAST_UPDATED_BY = decode(p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY ,p_LAST_UPDATED_BY),
111: OBJECT_VERSION_NUMBER = decode(l_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER,l_object_version_number)
112: WHERE PRIMARY_TRANSFORM_ID = p_PRIMARY_TRANSFORM_ID;
113:
114: p_OBJECT_VERSION_NUMBER := l_OBJECT_VERSION_NUMBER;
115: