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

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

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

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

40: DISPLAY_ORDER
41: )
42: VALUES (
43: px_PRIMARY_ATTRIBUTE_ID,
44: decode(p_MATCH_RULE_ID, FND_API.G_MISS_NUM, NULL, p_MATCH_RULE_ID),
45: decode(p_ATTRIBUTE_ID, FND_API.G_MISS_NUM, NULL, p_ATTRIBUTE_ID),
46: decode(p_ACTIVE_FLAG, FND_API.G_MISS_CHAR, NULL, p_ACTIVE_FLAG),
47: decode(p_FILTER_FLAG, FND_API.G_MISS_CHAR, NULL, p_FILTER_FLAG),
48: decode(p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by),

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

41: )
42: VALUES (
43: px_PRIMARY_ATTRIBUTE_ID,
44: decode(p_MATCH_RULE_ID, FND_API.G_MISS_NUM, NULL, p_MATCH_RULE_ID),
45: decode(p_ATTRIBUTE_ID, FND_API.G_MISS_NUM, NULL, p_ATTRIBUTE_ID),
46: decode(p_ACTIVE_FLAG, FND_API.G_MISS_CHAR, NULL, p_ACTIVE_FLAG),
47: decode(p_FILTER_FLAG, FND_API.G_MISS_CHAR, NULL, p_FILTER_FLAG),
48: decode(p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by),
49: decode(p_creation_date, FND_API.G_MISS_DATE, to_date(NULL), p_creation_date),

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

42: VALUES (
43: px_PRIMARY_ATTRIBUTE_ID,
44: decode(p_MATCH_RULE_ID, FND_API.G_MISS_NUM, NULL, p_MATCH_RULE_ID),
45: decode(p_ATTRIBUTE_ID, FND_API.G_MISS_NUM, NULL, p_ATTRIBUTE_ID),
46: decode(p_ACTIVE_FLAG, FND_API.G_MISS_CHAR, NULL, p_ACTIVE_FLAG),
47: decode(p_FILTER_FLAG, FND_API.G_MISS_CHAR, NULL, p_FILTER_FLAG),
48: decode(p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by),
49: decode(p_creation_date, FND_API.G_MISS_DATE, to_date(NULL), p_creation_date),
50: decode(p_last_update_login,FND_API.G_MISS_NUM, NULL, p_last_update_login),

Line 47: decode(p_FILTER_FLAG, FND_API.G_MISS_CHAR, NULL, p_FILTER_FLAG),

43: px_PRIMARY_ATTRIBUTE_ID,
44: decode(p_MATCH_RULE_ID, FND_API.G_MISS_NUM, NULL, p_MATCH_RULE_ID),
45: decode(p_ATTRIBUTE_ID, FND_API.G_MISS_NUM, NULL, p_ATTRIBUTE_ID),
46: decode(p_ACTIVE_FLAG, FND_API.G_MISS_CHAR, NULL, p_ACTIVE_FLAG),
47: decode(p_FILTER_FLAG, FND_API.G_MISS_CHAR, NULL, p_FILTER_FLAG),
48: decode(p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by),
49: decode(p_creation_date, FND_API.G_MISS_DATE, to_date(NULL), p_creation_date),
50: decode(p_last_update_login,FND_API.G_MISS_NUM, NULL, p_last_update_login),
51: decode(p_last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),

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

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

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

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

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

46: decode(p_ACTIVE_FLAG, FND_API.G_MISS_CHAR, NULL, p_ACTIVE_FLAG),
47: decode(p_FILTER_FLAG, FND_API.G_MISS_CHAR, NULL, p_FILTER_FLAG),
48: decode(p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by),
49: decode(p_creation_date, FND_API.G_MISS_DATE, to_date(NULL), p_creation_date),
50: decode(p_last_update_login,FND_API.G_MISS_NUM, NULL, p_last_update_login),
51: decode(p_last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),
52: decode(p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by),
53: 1,
54: decode(p_DISPLAY_ORDER, FND_API.G_MISS_NUM, NULL, p_DISPLAY_ORDER)

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

47: decode(p_FILTER_FLAG, FND_API.G_MISS_CHAR, NULL, p_FILTER_FLAG),
48: decode(p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by),
49: decode(p_creation_date, FND_API.G_MISS_DATE, to_date(NULL), p_creation_date),
50: decode(p_last_update_login,FND_API.G_MISS_NUM, NULL, p_last_update_login),
51: decode(p_last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),
52: decode(p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by),
53: 1,
54: decode(p_DISPLAY_ORDER, FND_API.G_MISS_NUM, NULL, p_DISPLAY_ORDER)
55: );

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

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

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

50: decode(p_last_update_login,FND_API.G_MISS_NUM, NULL, p_last_update_login),
51: decode(p_last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),
52: decode(p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by),
53: 1,
54: decode(p_DISPLAY_ORDER, FND_API.G_MISS_NUM, NULL, p_DISPLAY_ORDER)
55: );
56: l_success := 'Y';
57: EXCEPTION WHEN DUP_VAL_ON_INDEX THEN
58: IF INSTRB( SQLERRM, 'HZ_MATCH_RULE_PRIMARY_U1' ) <> 0 THEN

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

101: l_object_version_number := NVL(p_object_version_number, 1) + 1;
102:
103: UPDATE hz_match_rule_primary
104: SET
105: MATCH_RULE_ID = decode(p_MATCH_RULE_ID, FND_API.G_MISS_NUM, MATCH_RULE_ID, p_MATCH_RULE_ID),
106: ATTRIBUTE_ID = decode(p_ATTRIBUTE_ID, FND_API.G_MISS_NUM, ATTRIBUTE_ID, p_ATTRIBUTE_ID),
107: ACTIVE_FLAG = decode(p_ACTIVE_FLAG, FND_API.G_MISS_CHAR, ACTIVE_FLAG, p_ACTIVE_FLAG),
108: FILTER_FLAG = decode(p_FILTER_FLAG, FND_API.G_MISS_CHAR, FILTER_FLAG, p_FILTER_FLAG),
109: -- Bug 3032780

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

102:
103: UPDATE hz_match_rule_primary
104: SET
105: MATCH_RULE_ID = decode(p_MATCH_RULE_ID, FND_API.G_MISS_NUM, MATCH_RULE_ID, p_MATCH_RULE_ID),
106: ATTRIBUTE_ID = decode(p_ATTRIBUTE_ID, FND_API.G_MISS_NUM, ATTRIBUTE_ID, p_ATTRIBUTE_ID),
107: ACTIVE_FLAG = decode(p_ACTIVE_FLAG, FND_API.G_MISS_CHAR, ACTIVE_FLAG, p_ACTIVE_FLAG),
108: FILTER_FLAG = decode(p_FILTER_FLAG, FND_API.G_MISS_CHAR, FILTER_FLAG, p_FILTER_FLAG),
109: -- Bug 3032780
110: /*

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

103: UPDATE hz_match_rule_primary
104: SET
105: MATCH_RULE_ID = decode(p_MATCH_RULE_ID, FND_API.G_MISS_NUM, MATCH_RULE_ID, p_MATCH_RULE_ID),
106: ATTRIBUTE_ID = decode(p_ATTRIBUTE_ID, FND_API.G_MISS_NUM, ATTRIBUTE_ID, p_ATTRIBUTE_ID),
107: ACTIVE_FLAG = decode(p_ACTIVE_FLAG, FND_API.G_MISS_CHAR, ACTIVE_FLAG, p_ACTIVE_FLAG),
108: FILTER_FLAG = decode(p_FILTER_FLAG, FND_API.G_MISS_CHAR, FILTER_FLAG, p_FILTER_FLAG),
109: -- Bug 3032780
110: /*
111: CREATED_BY = decode(p_created_by, FND_API.G_MISS_NUM, CREATED_BY, p_created_by),

Line 108: FILTER_FLAG = decode(p_FILTER_FLAG, FND_API.G_MISS_CHAR, FILTER_FLAG, p_FILTER_FLAG),

104: SET
105: MATCH_RULE_ID = decode(p_MATCH_RULE_ID, FND_API.G_MISS_NUM, MATCH_RULE_ID, p_MATCH_RULE_ID),
106: ATTRIBUTE_ID = decode(p_ATTRIBUTE_ID, FND_API.G_MISS_NUM, ATTRIBUTE_ID, p_ATTRIBUTE_ID),
107: ACTIVE_FLAG = decode(p_ACTIVE_FLAG, FND_API.G_MISS_CHAR, ACTIVE_FLAG, p_ACTIVE_FLAG),
108: FILTER_FLAG = decode(p_FILTER_FLAG, FND_API.G_MISS_CHAR, FILTER_FLAG, p_FILTER_FLAG),
109: -- Bug 3032780
110: /*
111: CREATED_BY = decode(p_created_by, FND_API.G_MISS_NUM, CREATED_BY, p_created_by),
112: CREATION_DATE = decode(p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE,p_CREATION_DATE),

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

107: ACTIVE_FLAG = decode(p_ACTIVE_FLAG, FND_API.G_MISS_CHAR, ACTIVE_FLAG, p_ACTIVE_FLAG),
108: FILTER_FLAG = decode(p_FILTER_FLAG, FND_API.G_MISS_CHAR, FILTER_FLAG, p_FILTER_FLAG),
109: -- Bug 3032780
110: /*
111: CREATED_BY = decode(p_created_by, FND_API.G_MISS_NUM, CREATED_BY, p_created_by),
112: CREATION_DATE = decode(p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE,p_CREATION_DATE),
113: */
114: LAST_UPDATE_LOGIN = decode(p_LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN,p_LAST_UPDATE_LOGIN),
115: LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,p_LAST_UPDATE_DATE),

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

108: FILTER_FLAG = decode(p_FILTER_FLAG, FND_API.G_MISS_CHAR, FILTER_FLAG, p_FILTER_FLAG),
109: -- Bug 3032780
110: /*
111: CREATED_BY = decode(p_created_by, FND_API.G_MISS_NUM, CREATED_BY, p_created_by),
112: CREATION_DATE = decode(p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE,p_CREATION_DATE),
113: */
114: LAST_UPDATE_LOGIN = decode(p_LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN,p_LAST_UPDATE_LOGIN),
115: LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,p_LAST_UPDATE_DATE),
116: LAST_UPDATED_BY = decode(p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY,p_LAST_UPDATED_BY),

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

110: /*
111: CREATED_BY = decode(p_created_by, FND_API.G_MISS_NUM, CREATED_BY, p_created_by),
112: CREATION_DATE = decode(p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE,p_CREATION_DATE),
113: */
114: LAST_UPDATE_LOGIN = decode(p_LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN,p_LAST_UPDATE_LOGIN),
115: LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,p_LAST_UPDATE_DATE),
116: LAST_UPDATED_BY = decode(p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY,p_LAST_UPDATED_BY),
117: OBJECT_VERSION_NUMBER = decode(l_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER,l_object_version_number),
118: DISPLAY_ORDER = decode(p_DISPLAY_ORDER, FND_API.G_MISS_NUM, DISPLAY_ORDER, p_DISPLAY_ORDER)

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

111: CREATED_BY = decode(p_created_by, FND_API.G_MISS_NUM, CREATED_BY, p_created_by),
112: CREATION_DATE = decode(p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE,p_CREATION_DATE),
113: */
114: LAST_UPDATE_LOGIN = decode(p_LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN,p_LAST_UPDATE_LOGIN),
115: LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,p_LAST_UPDATE_DATE),
116: LAST_UPDATED_BY = decode(p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY,p_LAST_UPDATED_BY),
117: OBJECT_VERSION_NUMBER = decode(l_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER,l_object_version_number),
118: DISPLAY_ORDER = decode(p_DISPLAY_ORDER, FND_API.G_MISS_NUM, DISPLAY_ORDER, p_DISPLAY_ORDER)
119: WHERE PRIMARY_ATTRIBUTE_ID = P_PRIMARY_ATTRIBUTE_ID;

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

112: CREATION_DATE = decode(p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE,p_CREATION_DATE),
113: */
114: LAST_UPDATE_LOGIN = decode(p_LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN,p_LAST_UPDATE_LOGIN),
115: LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,p_LAST_UPDATE_DATE),
116: LAST_UPDATED_BY = decode(p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY,p_LAST_UPDATED_BY),
117: OBJECT_VERSION_NUMBER = decode(l_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER,l_object_version_number),
118: DISPLAY_ORDER = decode(p_DISPLAY_ORDER, FND_API.G_MISS_NUM, DISPLAY_ORDER, p_DISPLAY_ORDER)
119: WHERE PRIMARY_ATTRIBUTE_ID = P_PRIMARY_ATTRIBUTE_ID;
120:

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

113: */
114: LAST_UPDATE_LOGIN = decode(p_LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN,p_LAST_UPDATE_LOGIN),
115: LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,p_LAST_UPDATE_DATE),
116: LAST_UPDATED_BY = decode(p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY,p_LAST_UPDATED_BY),
117: OBJECT_VERSION_NUMBER = decode(l_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER,l_object_version_number),
118: DISPLAY_ORDER = decode(p_DISPLAY_ORDER, FND_API.G_MISS_NUM, DISPLAY_ORDER, p_DISPLAY_ORDER)
119: WHERE PRIMARY_ATTRIBUTE_ID = P_PRIMARY_ATTRIBUTE_ID;
120:
121: p_OBJECT_VERSION_NUMBER := l_OBJECT_VERSION_NUMBER;

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

114: LAST_UPDATE_LOGIN = decode(p_LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN,p_LAST_UPDATE_LOGIN),
115: LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,p_LAST_UPDATE_DATE),
116: LAST_UPDATED_BY = decode(p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY,p_LAST_UPDATED_BY),
117: OBJECT_VERSION_NUMBER = decode(l_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER,l_object_version_number),
118: DISPLAY_ORDER = decode(p_DISPLAY_ORDER, FND_API.G_MISS_NUM, DISPLAY_ORDER, p_DISPLAY_ORDER)
119: WHERE PRIMARY_ATTRIBUTE_ID = P_PRIMARY_ATTRIBUTE_ID;
120:
121: p_OBJECT_VERSION_NUMBER := l_OBJECT_VERSION_NUMBER;
122: