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

Line 24: IF ( px_SECONDARY_ATTRIBUTE_ID IS NULL) OR (px_SECONDARY_ATTRIBUTE_ID = FND_API.G_MISS_NUM) THEN

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

Line 46: decode(p_MATCH_RULE_ID, FND_API.G_MISS_NUM, NULL, p_MATCH_RULE_ID),

42: DISPLAY_ORDER
43: )
44: VALUES (
45: px_SECONDARY_ATTRIBUTE_ID,
46: decode(p_MATCH_RULE_ID, FND_API.G_MISS_NUM, NULL, p_MATCH_RULE_ID),
47: decode(p_ATTRIBUTE_ID, FND_API.G_MISS_NUM, NULL, p_ATTRIBUTE_ID),
48: decode(p_SCORE, FND_API.G_MISS_NUM, NULL, p_SCORE),
49: decode(p_ACTIVE_FLAG, FND_API.G_MISS_CHAR, NULL, p_ACTIVE_FLAG),
50: decode(p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by),

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

43: )
44: VALUES (
45: px_SECONDARY_ATTRIBUTE_ID,
46: decode(p_MATCH_RULE_ID, FND_API.G_MISS_NUM, NULL, p_MATCH_RULE_ID),
47: decode(p_ATTRIBUTE_ID, FND_API.G_MISS_NUM, NULL, p_ATTRIBUTE_ID),
48: decode(p_SCORE, FND_API.G_MISS_NUM, NULL, p_SCORE),
49: decode(p_ACTIVE_FLAG, FND_API.G_MISS_CHAR, NULL, p_ACTIVE_FLAG),
50: decode(p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by),
51: decode(p_creation_date, FND_API.G_MISS_DATE, NULL, p_creation_date),

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

44: VALUES (
45: px_SECONDARY_ATTRIBUTE_ID,
46: decode(p_MATCH_RULE_ID, FND_API.G_MISS_NUM, NULL, p_MATCH_RULE_ID),
47: decode(p_ATTRIBUTE_ID, FND_API.G_MISS_NUM, NULL, p_ATTRIBUTE_ID),
48: decode(p_SCORE, FND_API.G_MISS_NUM, NULL, p_SCORE),
49: decode(p_ACTIVE_FLAG, FND_API.G_MISS_CHAR, NULL, p_ACTIVE_FLAG),
50: decode(p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by),
51: decode(p_creation_date, FND_API.G_MISS_DATE, NULL, p_creation_date),
52: decode(p_last_update_login,FND_API.G_MISS_NUM, NULL, p_last_update_login),

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

45: px_SECONDARY_ATTRIBUTE_ID,
46: decode(p_MATCH_RULE_ID, FND_API.G_MISS_NUM, NULL, p_MATCH_RULE_ID),
47: decode(p_ATTRIBUTE_ID, FND_API.G_MISS_NUM, NULL, p_ATTRIBUTE_ID),
48: decode(p_SCORE, FND_API.G_MISS_NUM, NULL, p_SCORE),
49: decode(p_ACTIVE_FLAG, FND_API.G_MISS_CHAR, NULL, p_ACTIVE_FLAG),
50: decode(p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by),
51: decode(p_creation_date, FND_API.G_MISS_DATE, NULL, p_creation_date),
52: decode(p_last_update_login,FND_API.G_MISS_NUM, NULL, p_last_update_login),
53: decode(p_last_update_date, FND_API.G_MISS_DATE, NULL, p_last_update_date),

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

46: decode(p_MATCH_RULE_ID, FND_API.G_MISS_NUM, NULL, p_MATCH_RULE_ID),
47: decode(p_ATTRIBUTE_ID, FND_API.G_MISS_NUM, NULL, p_ATTRIBUTE_ID),
48: decode(p_SCORE, FND_API.G_MISS_NUM, NULL, p_SCORE),
49: decode(p_ACTIVE_FLAG, FND_API.G_MISS_CHAR, NULL, p_ACTIVE_FLAG),
50: decode(p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by),
51: decode(p_creation_date, FND_API.G_MISS_DATE, NULL, p_creation_date),
52: decode(p_last_update_login,FND_API.G_MISS_NUM, NULL, p_last_update_login),
53: decode(p_last_update_date, FND_API.G_MISS_DATE, NULL, p_last_update_date),
54: decode(p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by),

Line 51: decode(p_creation_date, FND_API.G_MISS_DATE, NULL, p_creation_date),

47: decode(p_ATTRIBUTE_ID, FND_API.G_MISS_NUM, NULL, p_ATTRIBUTE_ID),
48: decode(p_SCORE, FND_API.G_MISS_NUM, NULL, p_SCORE),
49: decode(p_ACTIVE_FLAG, FND_API.G_MISS_CHAR, NULL, p_ACTIVE_FLAG),
50: decode(p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by),
51: decode(p_creation_date, FND_API.G_MISS_DATE, NULL, p_creation_date),
52: decode(p_last_update_login,FND_API.G_MISS_NUM, NULL, p_last_update_login),
53: decode(p_last_update_date, FND_API.G_MISS_DATE, NULL, p_last_update_date),
54: decode(p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by),
55: 1,

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

48: decode(p_SCORE, FND_API.G_MISS_NUM, NULL, p_SCORE),
49: decode(p_ACTIVE_FLAG, FND_API.G_MISS_CHAR, NULL, p_ACTIVE_FLAG),
50: decode(p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by),
51: decode(p_creation_date, FND_API.G_MISS_DATE, NULL, p_creation_date),
52: decode(p_last_update_login,FND_API.G_MISS_NUM, NULL, p_last_update_login),
53: decode(p_last_update_date, FND_API.G_MISS_DATE, NULL, p_last_update_date),
54: decode(p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by),
55: 1,
56: decode(p_DISPLAY_ORDER, FND_API.G_MISS_NUM, NULL, p_DISPLAY_ORDER)

Line 53: decode(p_last_update_date, FND_API.G_MISS_DATE, NULL, p_last_update_date),

49: decode(p_ACTIVE_FLAG, FND_API.G_MISS_CHAR, NULL, p_ACTIVE_FLAG),
50: decode(p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by),
51: decode(p_creation_date, FND_API.G_MISS_DATE, NULL, p_creation_date),
52: decode(p_last_update_login,FND_API.G_MISS_NUM, NULL, p_last_update_login),
53: decode(p_last_update_date, FND_API.G_MISS_DATE, NULL, p_last_update_date),
54: decode(p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by),
55: 1,
56: decode(p_DISPLAY_ORDER, FND_API.G_MISS_NUM, NULL, p_DISPLAY_ORDER)
57: );

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

50: decode(p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by),
51: decode(p_creation_date, FND_API.G_MISS_DATE, NULL, p_creation_date),
52: decode(p_last_update_login,FND_API.G_MISS_NUM, NULL, p_last_update_login),
53: decode(p_last_update_date, FND_API.G_MISS_DATE, NULL, p_last_update_date),
54: decode(p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by),
55: 1,
56: decode(p_DISPLAY_ORDER, FND_API.G_MISS_NUM, NULL, p_DISPLAY_ORDER)
57: );
58:

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

52: decode(p_last_update_login,FND_API.G_MISS_NUM, NULL, p_last_update_login),
53: decode(p_last_update_date, FND_API.G_MISS_DATE, NULL, p_last_update_date),
54: decode(p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by),
55: 1,
56: decode(p_DISPLAY_ORDER, FND_API.G_MISS_NUM, NULL, p_DISPLAY_ORDER)
57: );
58:
59: l_success := 'Y';
60: EXCEPTION WHEN DUP_VAL_ON_INDEX THEN

Line 109: MATCH_RULE_ID = decode(p_MATCH_RULE_ID, FND_API.G_MISS_NUM, NULL, p_MATCH_RULE_ID),

105: l_object_version_number := NVL(p_object_version_number, 1) + 1;
106:
107: UPDATE hz_match_rule_SECONDARY
108: SET
109: MATCH_RULE_ID = decode(p_MATCH_RULE_ID, FND_API.G_MISS_NUM, NULL, p_MATCH_RULE_ID),
110: ATTRIBUTE_ID = decode(p_ATTRIBUTE_ID, FND_API.G_MISS_NUM, NULL, p_ATTRIBUTE_ID),
111: SCORE = decode(p_SCORE, FND_API.G_MISS_CHAR, NULL, p_SCORE),
112: ACTIVE_FLAG = decode(p_ACTIVE_FLAG, FND_API.G_MISS_CHAR, NULL, p_ACTIVE_FLAG),
113: -- Bug 3032780

Line 110: ATTRIBUTE_ID = decode(p_ATTRIBUTE_ID, FND_API.G_MISS_NUM, NULL, p_ATTRIBUTE_ID),

106:
107: UPDATE hz_match_rule_SECONDARY
108: SET
109: MATCH_RULE_ID = decode(p_MATCH_RULE_ID, FND_API.G_MISS_NUM, NULL, p_MATCH_RULE_ID),
110: ATTRIBUTE_ID = decode(p_ATTRIBUTE_ID, FND_API.G_MISS_NUM, NULL, p_ATTRIBUTE_ID),
111: SCORE = decode(p_SCORE, FND_API.G_MISS_CHAR, NULL, p_SCORE),
112: ACTIVE_FLAG = decode(p_ACTIVE_FLAG, FND_API.G_MISS_CHAR, NULL, p_ACTIVE_FLAG),
113: -- Bug 3032780
114: /*

Line 111: SCORE = decode(p_SCORE, FND_API.G_MISS_CHAR, NULL, p_SCORE),

107: UPDATE hz_match_rule_SECONDARY
108: SET
109: MATCH_RULE_ID = decode(p_MATCH_RULE_ID, FND_API.G_MISS_NUM, NULL, p_MATCH_RULE_ID),
110: ATTRIBUTE_ID = decode(p_ATTRIBUTE_ID, FND_API.G_MISS_NUM, NULL, p_ATTRIBUTE_ID),
111: SCORE = decode(p_SCORE, FND_API.G_MISS_CHAR, NULL, p_SCORE),
112: ACTIVE_FLAG = decode(p_ACTIVE_FLAG, FND_API.G_MISS_CHAR, NULL, p_ACTIVE_FLAG),
113: -- Bug 3032780
114: /*
115: CREATED_BY = decode(p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by),

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

108: SET
109: MATCH_RULE_ID = decode(p_MATCH_RULE_ID, FND_API.G_MISS_NUM, NULL, p_MATCH_RULE_ID),
110: ATTRIBUTE_ID = decode(p_ATTRIBUTE_ID, FND_API.G_MISS_NUM, NULL, p_ATTRIBUTE_ID),
111: SCORE = decode(p_SCORE, FND_API.G_MISS_CHAR, NULL, p_SCORE),
112: ACTIVE_FLAG = decode(p_ACTIVE_FLAG, FND_API.G_MISS_CHAR, NULL, p_ACTIVE_FLAG),
113: -- Bug 3032780
114: /*
115: CREATED_BY = decode(p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by),
116: CREATION_DATE = decode(p_CREATION_DATE, FND_API.G_MISS_DATE, NULL,p_CREATION_DATE),

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

111: SCORE = decode(p_SCORE, FND_API.G_MISS_CHAR, NULL, p_SCORE),
112: ACTIVE_FLAG = decode(p_ACTIVE_FLAG, FND_API.G_MISS_CHAR, NULL, p_ACTIVE_FLAG),
113: -- Bug 3032780
114: /*
115: CREATED_BY = decode(p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by),
116: CREATION_DATE = decode(p_CREATION_DATE, FND_API.G_MISS_DATE, NULL,p_CREATION_DATE),
117: */
118: LAST_UPDATE_LOGIN = decode(p_LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM, NULL,p_LAST_UPDATE_LOGIN),
119: LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL,p_LAST_UPDATE_DATE),

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

112: ACTIVE_FLAG = decode(p_ACTIVE_FLAG, FND_API.G_MISS_CHAR, NULL, p_ACTIVE_FLAG),
113: -- Bug 3032780
114: /*
115: CREATED_BY = decode(p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by),
116: CREATION_DATE = decode(p_CREATION_DATE, FND_API.G_MISS_DATE, NULL,p_CREATION_DATE),
117: */
118: LAST_UPDATE_LOGIN = decode(p_LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM, NULL,p_LAST_UPDATE_LOGIN),
119: LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL,p_LAST_UPDATE_DATE),
120: LAST_UPDATED_BY = decode(p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,p_LAST_UPDATED_BY),

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

114: /*
115: CREATED_BY = decode(p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by),
116: CREATION_DATE = decode(p_CREATION_DATE, FND_API.G_MISS_DATE, NULL,p_CREATION_DATE),
117: */
118: LAST_UPDATE_LOGIN = decode(p_LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM, NULL,p_LAST_UPDATE_LOGIN),
119: LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL,p_LAST_UPDATE_DATE),
120: LAST_UPDATED_BY = decode(p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,p_LAST_UPDATED_BY),
121: OBJECT_VERSION_NUMBER = decode(l_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER,l_object_version_number),
122: DISPLAY_ORDER = decode(p_DISPLAY_ORDER, FND_API.G_MISS_NUM, DISPLAY_ORDER,p_DISPLAY_ORDER)

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

115: CREATED_BY = decode(p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by),
116: CREATION_DATE = decode(p_CREATION_DATE, FND_API.G_MISS_DATE, NULL,p_CREATION_DATE),
117: */
118: LAST_UPDATE_LOGIN = decode(p_LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM, NULL,p_LAST_UPDATE_LOGIN),
119: LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL,p_LAST_UPDATE_DATE),
120: LAST_UPDATED_BY = decode(p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,p_LAST_UPDATED_BY),
121: OBJECT_VERSION_NUMBER = decode(l_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER,l_object_version_number),
122: DISPLAY_ORDER = decode(p_DISPLAY_ORDER, FND_API.G_MISS_NUM, DISPLAY_ORDER,p_DISPLAY_ORDER)
123: WHERE SECONDARY_attribute_id = p_SECONDARY_attribute_id;

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

116: CREATION_DATE = decode(p_CREATION_DATE, FND_API.G_MISS_DATE, NULL,p_CREATION_DATE),
117: */
118: LAST_UPDATE_LOGIN = decode(p_LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM, NULL,p_LAST_UPDATE_LOGIN),
119: LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL,p_LAST_UPDATE_DATE),
120: LAST_UPDATED_BY = decode(p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,p_LAST_UPDATED_BY),
121: OBJECT_VERSION_NUMBER = decode(l_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER,l_object_version_number),
122: DISPLAY_ORDER = decode(p_DISPLAY_ORDER, FND_API.G_MISS_NUM, DISPLAY_ORDER,p_DISPLAY_ORDER)
123: WHERE SECONDARY_attribute_id = p_SECONDARY_attribute_id;
124:

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

117: */
118: LAST_UPDATE_LOGIN = decode(p_LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM, NULL,p_LAST_UPDATE_LOGIN),
119: LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL,p_LAST_UPDATE_DATE),
120: LAST_UPDATED_BY = decode(p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,p_LAST_UPDATED_BY),
121: OBJECT_VERSION_NUMBER = decode(l_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER,l_object_version_number),
122: DISPLAY_ORDER = decode(p_DISPLAY_ORDER, FND_API.G_MISS_NUM, DISPLAY_ORDER,p_DISPLAY_ORDER)
123: WHERE SECONDARY_attribute_id = p_SECONDARY_attribute_id;
124:
125: p_OBJECT_VERSION_NUMBER := l_OBJECT_VERSION_NUMBER;

Line 122: DISPLAY_ORDER = decode(p_DISPLAY_ORDER, FND_API.G_MISS_NUM, DISPLAY_ORDER,p_DISPLAY_ORDER)

118: LAST_UPDATE_LOGIN = decode(p_LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM, NULL,p_LAST_UPDATE_LOGIN),
119: LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL,p_LAST_UPDATE_DATE),
120: LAST_UPDATED_BY = decode(p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,p_LAST_UPDATED_BY),
121: OBJECT_VERSION_NUMBER = decode(l_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER,l_object_version_number),
122: DISPLAY_ORDER = decode(p_DISPLAY_ORDER, FND_API.G_MISS_NUM, DISPLAY_ORDER,p_DISPLAY_ORDER)
123: WHERE SECONDARY_attribute_id = p_SECONDARY_attribute_id;
124:
125: p_OBJECT_VERSION_NUMBER := l_OBJECT_VERSION_NUMBER;
126: