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

Line 55: DECODE( x_PERSON_INTEREST_ID, FND_API.G_MISS_NUM, HZ_PERSON_INTEREST_S.NEXTVAL, NULL, HZ_PERSON_INTEREST_S.NEXTVAL, X_PERSON_INTEREST_ID ),

51: CREATED_BY_MODULE,
52: APPLICATION_ID
53:
54: ) VALUES (
55: DECODE( x_PERSON_INTEREST_ID, FND_API.G_MISS_NUM, HZ_PERSON_INTEREST_S.NEXTVAL, NULL, HZ_PERSON_INTEREST_S.NEXTVAL, X_PERSON_INTEREST_ID ),
56: decode( x_LEVEL_OF_INTEREST, FND_API.G_MISS_CHAR, NULL,x_LEVEL_OF_INTEREST),
57: decode( x_PARTY_ID, FND_API.G_MISS_NUM, NULL,x_PARTY_ID),
58: decode( x_LEVEL_OF_PARTICIPATION, FND_API.G_MISS_CHAR, NULL,x_LEVEL_OF_PARTICIPATION),
59: decode( x_INTEREST_TYPE_CODE, FND_API.G_MISS_CHAR, NULL,x_INTEREST_TYPE_CODE),

Line 56: decode( x_LEVEL_OF_INTEREST, FND_API.G_MISS_CHAR, NULL,x_LEVEL_OF_INTEREST),

52: APPLICATION_ID
53:
54: ) VALUES (
55: DECODE( x_PERSON_INTEREST_ID, FND_API.G_MISS_NUM, HZ_PERSON_INTEREST_S.NEXTVAL, NULL, HZ_PERSON_INTEREST_S.NEXTVAL, X_PERSON_INTEREST_ID ),
56: decode( x_LEVEL_OF_INTEREST, FND_API.G_MISS_CHAR, NULL,x_LEVEL_OF_INTEREST),
57: decode( x_PARTY_ID, FND_API.G_MISS_NUM, NULL,x_PARTY_ID),
58: decode( x_LEVEL_OF_PARTICIPATION, FND_API.G_MISS_CHAR, NULL,x_LEVEL_OF_PARTICIPATION),
59: decode( x_INTEREST_TYPE_CODE, FND_API.G_MISS_CHAR, NULL,x_INTEREST_TYPE_CODE),
60: decode( x_SPORT_INDICATOR, FND_API.G_MISS_CHAR, NULL,x_SPORT_INDICATOR),

Line 57: decode( x_PARTY_ID, FND_API.G_MISS_NUM, NULL,x_PARTY_ID),

53:
54: ) VALUES (
55: DECODE( x_PERSON_INTEREST_ID, FND_API.G_MISS_NUM, HZ_PERSON_INTEREST_S.NEXTVAL, NULL, HZ_PERSON_INTEREST_S.NEXTVAL, X_PERSON_INTEREST_ID ),
56: decode( x_LEVEL_OF_INTEREST, FND_API.G_MISS_CHAR, NULL,x_LEVEL_OF_INTEREST),
57: decode( x_PARTY_ID, FND_API.G_MISS_NUM, NULL,x_PARTY_ID),
58: decode( x_LEVEL_OF_PARTICIPATION, FND_API.G_MISS_CHAR, NULL,x_LEVEL_OF_PARTICIPATION),
59: decode( x_INTEREST_TYPE_CODE, FND_API.G_MISS_CHAR, NULL,x_INTEREST_TYPE_CODE),
60: decode( x_SPORT_INDICATOR, FND_API.G_MISS_CHAR, NULL,x_SPORT_INDICATOR),
61: decode( x_INTEREST_NAME, FND_API.G_MISS_CHAR, NULL,x_INTEREST_NAME),

Line 58: decode( x_LEVEL_OF_PARTICIPATION, FND_API.G_MISS_CHAR, NULL,x_LEVEL_OF_PARTICIPATION),

54: ) VALUES (
55: DECODE( x_PERSON_INTEREST_ID, FND_API.G_MISS_NUM, HZ_PERSON_INTEREST_S.NEXTVAL, NULL, HZ_PERSON_INTEREST_S.NEXTVAL, X_PERSON_INTEREST_ID ),
56: decode( x_LEVEL_OF_INTEREST, FND_API.G_MISS_CHAR, NULL,x_LEVEL_OF_INTEREST),
57: decode( x_PARTY_ID, FND_API.G_MISS_NUM, NULL,x_PARTY_ID),
58: decode( x_LEVEL_OF_PARTICIPATION, FND_API.G_MISS_CHAR, NULL,x_LEVEL_OF_PARTICIPATION),
59: decode( x_INTEREST_TYPE_CODE, FND_API.G_MISS_CHAR, NULL,x_INTEREST_TYPE_CODE),
60: decode( x_SPORT_INDICATOR, FND_API.G_MISS_CHAR, NULL,x_SPORT_INDICATOR),
61: decode( x_INTEREST_NAME, FND_API.G_MISS_CHAR, NULL,x_INTEREST_NAME),
62: HZ_UTILITY_V2PUB.CREATED_BY,

Line 59: decode( x_INTEREST_TYPE_CODE, FND_API.G_MISS_CHAR, NULL,x_INTEREST_TYPE_CODE),

55: DECODE( x_PERSON_INTEREST_ID, FND_API.G_MISS_NUM, HZ_PERSON_INTEREST_S.NEXTVAL, NULL, HZ_PERSON_INTEREST_S.NEXTVAL, X_PERSON_INTEREST_ID ),
56: decode( x_LEVEL_OF_INTEREST, FND_API.G_MISS_CHAR, NULL,x_LEVEL_OF_INTEREST),
57: decode( x_PARTY_ID, FND_API.G_MISS_NUM, NULL,x_PARTY_ID),
58: decode( x_LEVEL_OF_PARTICIPATION, FND_API.G_MISS_CHAR, NULL,x_LEVEL_OF_PARTICIPATION),
59: decode( x_INTEREST_TYPE_CODE, FND_API.G_MISS_CHAR, NULL,x_INTEREST_TYPE_CODE),
60: decode( x_SPORT_INDICATOR, FND_API.G_MISS_CHAR, NULL,x_SPORT_INDICATOR),
61: decode( x_INTEREST_NAME, FND_API.G_MISS_CHAR, NULL,x_INTEREST_NAME),
62: HZ_UTILITY_V2PUB.CREATED_BY,
63: HZ_UTILITY_V2PUB.CREATION_DATE,

Line 60: decode( x_SPORT_INDICATOR, FND_API.G_MISS_CHAR, NULL,x_SPORT_INDICATOR),

56: decode( x_LEVEL_OF_INTEREST, FND_API.G_MISS_CHAR, NULL,x_LEVEL_OF_INTEREST),
57: decode( x_PARTY_ID, FND_API.G_MISS_NUM, NULL,x_PARTY_ID),
58: decode( x_LEVEL_OF_PARTICIPATION, FND_API.G_MISS_CHAR, NULL,x_LEVEL_OF_PARTICIPATION),
59: decode( x_INTEREST_TYPE_CODE, FND_API.G_MISS_CHAR, NULL,x_INTEREST_TYPE_CODE),
60: decode( x_SPORT_INDICATOR, FND_API.G_MISS_CHAR, NULL,x_SPORT_INDICATOR),
61: decode( x_INTEREST_NAME, FND_API.G_MISS_CHAR, NULL,x_INTEREST_NAME),
62: HZ_UTILITY_V2PUB.CREATED_BY,
63: HZ_UTILITY_V2PUB.CREATION_DATE,
64: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

Line 61: decode( x_INTEREST_NAME, FND_API.G_MISS_CHAR, NULL,x_INTEREST_NAME),

57: decode( x_PARTY_ID, FND_API.G_MISS_NUM, NULL,x_PARTY_ID),
58: decode( x_LEVEL_OF_PARTICIPATION, FND_API.G_MISS_CHAR, NULL,x_LEVEL_OF_PARTICIPATION),
59: decode( x_INTEREST_TYPE_CODE, FND_API.G_MISS_CHAR, NULL,x_INTEREST_TYPE_CODE),
60: decode( x_SPORT_INDICATOR, FND_API.G_MISS_CHAR, NULL,x_SPORT_INDICATOR),
61: decode( x_INTEREST_NAME, FND_API.G_MISS_CHAR, NULL,x_INTEREST_NAME),
62: HZ_UTILITY_V2PUB.CREATED_BY,
63: HZ_UTILITY_V2PUB.CREATION_DATE,
64: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
65: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

Line 71: decode( x_COMMENTS, FND_API.G_MISS_CHAR, NULL,x_COMMENTS),

67: HZ_UTILITY_V2PUB.REQUEST_ID,
68: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
69: HZ_UTILITY_V2PUB.PROGRAM_ID,
70: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
71: decode( x_COMMENTS, FND_API.G_MISS_CHAR, NULL,x_COMMENTS),
72: decode( x_SUB_INTEREST_TYPE_CODE, FND_API.G_MISS_CHAR, NULL,x_SUB_INTEREST_TYPE_CODE),
73: decode( x_TEAM, FND_API.G_MISS_CHAR, NULL,x_TEAM),
74: decode( x_SINCE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_SINCE),
75: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),

Line 72: decode( x_SUB_INTEREST_TYPE_CODE, FND_API.G_MISS_CHAR, NULL,x_SUB_INTEREST_TYPE_CODE),

68: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
69: HZ_UTILITY_V2PUB.PROGRAM_ID,
70: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
71: decode( x_COMMENTS, FND_API.G_MISS_CHAR, NULL,x_COMMENTS),
72: decode( x_SUB_INTEREST_TYPE_CODE, FND_API.G_MISS_CHAR, NULL,x_SUB_INTEREST_TYPE_CODE),
73: decode( x_TEAM, FND_API.G_MISS_CHAR, NULL,x_TEAM),
74: decode( x_SINCE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_SINCE),
75: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
76: decode( x_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, x_OBJECT_VERSION_NUMBER ),

Line 73: decode( x_TEAM, FND_API.G_MISS_CHAR, NULL,x_TEAM),

69: HZ_UTILITY_V2PUB.PROGRAM_ID,
70: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
71: decode( x_COMMENTS, FND_API.G_MISS_CHAR, NULL,x_COMMENTS),
72: decode( x_SUB_INTEREST_TYPE_CODE, FND_API.G_MISS_CHAR, NULL,x_SUB_INTEREST_TYPE_CODE),
73: decode( x_TEAM, FND_API.G_MISS_CHAR, NULL,x_TEAM),
74: decode( x_SINCE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_SINCE),
75: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
76: decode( x_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, x_OBJECT_VERSION_NUMBER ),
77: decode( x_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, x_CREATED_BY_MODULE ),

Line 74: decode( x_SINCE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_SINCE),

70: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
71: decode( x_COMMENTS, FND_API.G_MISS_CHAR, NULL,x_COMMENTS),
72: decode( x_SUB_INTEREST_TYPE_CODE, FND_API.G_MISS_CHAR, NULL,x_SUB_INTEREST_TYPE_CODE),
73: decode( x_TEAM, FND_API.G_MISS_CHAR, NULL,x_TEAM),
74: decode( x_SINCE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_SINCE),
75: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
76: decode( x_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, x_OBJECT_VERSION_NUMBER ),
77: decode( x_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, x_CREATED_BY_MODULE ),
78: HZ_UTILITY_V2PUB.APPLICATION_ID

Line 75: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),

71: decode( x_COMMENTS, FND_API.G_MISS_CHAR, NULL,x_COMMENTS),
72: decode( x_SUB_INTEREST_TYPE_CODE, FND_API.G_MISS_CHAR, NULL,x_SUB_INTEREST_TYPE_CODE),
73: decode( x_TEAM, FND_API.G_MISS_CHAR, NULL,x_TEAM),
74: decode( x_SINCE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_SINCE),
75: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
76: decode( x_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, x_OBJECT_VERSION_NUMBER ),
77: decode( x_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, x_CREATED_BY_MODULE ),
78: HZ_UTILITY_V2PUB.APPLICATION_ID
79:

Line 76: decode( x_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, x_OBJECT_VERSION_NUMBER ),

72: decode( x_SUB_INTEREST_TYPE_CODE, FND_API.G_MISS_CHAR, NULL,x_SUB_INTEREST_TYPE_CODE),
73: decode( x_TEAM, FND_API.G_MISS_CHAR, NULL,x_TEAM),
74: decode( x_SINCE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_SINCE),
75: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
76: decode( x_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, x_OBJECT_VERSION_NUMBER ),
77: decode( x_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, x_CREATED_BY_MODULE ),
78: HZ_UTILITY_V2PUB.APPLICATION_ID
79:
80: ) RETURNING

Line 77: decode( x_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, x_CREATED_BY_MODULE ),

73: decode( x_TEAM, FND_API.G_MISS_CHAR, NULL,x_TEAM),
74: decode( x_SINCE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_SINCE),
75: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
76: decode( x_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, x_OBJECT_VERSION_NUMBER ),
77: decode( x_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, x_CREATED_BY_MODULE ),
78: HZ_UTILITY_V2PUB.APPLICATION_ID
79:
80: ) RETURNING
81: PERSON_INTEREST_ID

Line 154: PERSON_INTEREST_ID = decode( x_PERSON_INTEREST_ID, NULL, PERSON_INTEREST_ID, FND_API.G_MISS_NUM, NULL, x_PERSON_INTEREST_ID),

150: ) IS
151: BEGIN
152: Update HZ_PERSON_INTEREST
153: SET
154: PERSON_INTEREST_ID = decode( x_PERSON_INTEREST_ID, NULL, PERSON_INTEREST_ID, FND_API.G_MISS_NUM, NULL, x_PERSON_INTEREST_ID),
155: LEVEL_OF_INTEREST = decode( x_LEVEL_OF_INTEREST, NULL , LEVEL_OF_INTEREST, FND_API.G_MISS_CHAR, NULL, x_LEVEL_OF_INTEREST),
156: PARTY_ID = decode( x_PARTY_ID, NULL, PARTY_ID, FND_API.G_MISS_NUM, NULL, x_PARTY_ID),
157: LEVEL_OF_PARTICIPATION = decode( x_LEVEL_OF_PARTICIPATION, NULL, LEVEL_OF_PARTICIPATION, FND_API.G_MISS_CHAR, NULL, x_LEVEL_OF_PARTICIPATION),
158: INTEREST_TYPE_CODE = decode( x_INTEREST_TYPE_CODE, NULL, INTEREST_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, x_INTEREST_TYPE_CODE),

Line 155: LEVEL_OF_INTEREST = decode( x_LEVEL_OF_INTEREST, NULL , LEVEL_OF_INTEREST, FND_API.G_MISS_CHAR, NULL, x_LEVEL_OF_INTEREST),

151: BEGIN
152: Update HZ_PERSON_INTEREST
153: SET
154: PERSON_INTEREST_ID = decode( x_PERSON_INTEREST_ID, NULL, PERSON_INTEREST_ID, FND_API.G_MISS_NUM, NULL, x_PERSON_INTEREST_ID),
155: LEVEL_OF_INTEREST = decode( x_LEVEL_OF_INTEREST, NULL , LEVEL_OF_INTEREST, FND_API.G_MISS_CHAR, NULL, x_LEVEL_OF_INTEREST),
156: PARTY_ID = decode( x_PARTY_ID, NULL, PARTY_ID, FND_API.G_MISS_NUM, NULL, x_PARTY_ID),
157: LEVEL_OF_PARTICIPATION = decode( x_LEVEL_OF_PARTICIPATION, NULL, LEVEL_OF_PARTICIPATION, FND_API.G_MISS_CHAR, NULL, x_LEVEL_OF_PARTICIPATION),
158: INTEREST_TYPE_CODE = decode( x_INTEREST_TYPE_CODE, NULL, INTEREST_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, x_INTEREST_TYPE_CODE),
159: SPORT_INDICATOR = decode( x_SPORT_INDICATOR, NULL, SPORT_INDICATOR, FND_API.G_MISS_CHAR, NULL, x_SPORT_INDICATOR),

Line 156: PARTY_ID = decode( x_PARTY_ID, NULL, PARTY_ID, FND_API.G_MISS_NUM, NULL, x_PARTY_ID),

152: Update HZ_PERSON_INTEREST
153: SET
154: PERSON_INTEREST_ID = decode( x_PERSON_INTEREST_ID, NULL, PERSON_INTEREST_ID, FND_API.G_MISS_NUM, NULL, x_PERSON_INTEREST_ID),
155: LEVEL_OF_INTEREST = decode( x_LEVEL_OF_INTEREST, NULL , LEVEL_OF_INTEREST, FND_API.G_MISS_CHAR, NULL, x_LEVEL_OF_INTEREST),
156: PARTY_ID = decode( x_PARTY_ID, NULL, PARTY_ID, FND_API.G_MISS_NUM, NULL, x_PARTY_ID),
157: LEVEL_OF_PARTICIPATION = decode( x_LEVEL_OF_PARTICIPATION, NULL, LEVEL_OF_PARTICIPATION, FND_API.G_MISS_CHAR, NULL, x_LEVEL_OF_PARTICIPATION),
158: INTEREST_TYPE_CODE = decode( x_INTEREST_TYPE_CODE, NULL, INTEREST_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, x_INTEREST_TYPE_CODE),
159: SPORT_INDICATOR = decode( x_SPORT_INDICATOR, NULL, SPORT_INDICATOR, FND_API.G_MISS_CHAR, NULL, x_SPORT_INDICATOR),
160: INTEREST_NAME = decode( x_INTEREST_NAME, NULL, INTEREST_NAME, FND_API.G_MISS_CHAR, NULL, x_INTEREST_NAME),

Line 157: LEVEL_OF_PARTICIPATION = decode( x_LEVEL_OF_PARTICIPATION, NULL, LEVEL_OF_PARTICIPATION, FND_API.G_MISS_CHAR, NULL, x_LEVEL_OF_PARTICIPATION),

153: SET
154: PERSON_INTEREST_ID = decode( x_PERSON_INTEREST_ID, NULL, PERSON_INTEREST_ID, FND_API.G_MISS_NUM, NULL, x_PERSON_INTEREST_ID),
155: LEVEL_OF_INTEREST = decode( x_LEVEL_OF_INTEREST, NULL , LEVEL_OF_INTEREST, FND_API.G_MISS_CHAR, NULL, x_LEVEL_OF_INTEREST),
156: PARTY_ID = decode( x_PARTY_ID, NULL, PARTY_ID, FND_API.G_MISS_NUM, NULL, x_PARTY_ID),
157: LEVEL_OF_PARTICIPATION = decode( x_LEVEL_OF_PARTICIPATION, NULL, LEVEL_OF_PARTICIPATION, FND_API.G_MISS_CHAR, NULL, x_LEVEL_OF_PARTICIPATION),
158: INTEREST_TYPE_CODE = decode( x_INTEREST_TYPE_CODE, NULL, INTEREST_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, x_INTEREST_TYPE_CODE),
159: SPORT_INDICATOR = decode( x_SPORT_INDICATOR, NULL, SPORT_INDICATOR, FND_API.G_MISS_CHAR, NULL, x_SPORT_INDICATOR),
160: INTEREST_NAME = decode( x_INTEREST_NAME, NULL, INTEREST_NAME, FND_API.G_MISS_CHAR, NULL, x_INTEREST_NAME),
161: -- Bug 3032780

Line 158: INTEREST_TYPE_CODE = decode( x_INTEREST_TYPE_CODE, NULL, INTEREST_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, x_INTEREST_TYPE_CODE),

154: PERSON_INTEREST_ID = decode( x_PERSON_INTEREST_ID, NULL, PERSON_INTEREST_ID, FND_API.G_MISS_NUM, NULL, x_PERSON_INTEREST_ID),
155: LEVEL_OF_INTEREST = decode( x_LEVEL_OF_INTEREST, NULL , LEVEL_OF_INTEREST, FND_API.G_MISS_CHAR, NULL, x_LEVEL_OF_INTEREST),
156: PARTY_ID = decode( x_PARTY_ID, NULL, PARTY_ID, FND_API.G_MISS_NUM, NULL, x_PARTY_ID),
157: LEVEL_OF_PARTICIPATION = decode( x_LEVEL_OF_PARTICIPATION, NULL, LEVEL_OF_PARTICIPATION, FND_API.G_MISS_CHAR, NULL, x_LEVEL_OF_PARTICIPATION),
158: INTEREST_TYPE_CODE = decode( x_INTEREST_TYPE_CODE, NULL, INTEREST_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, x_INTEREST_TYPE_CODE),
159: SPORT_INDICATOR = decode( x_SPORT_INDICATOR, NULL, SPORT_INDICATOR, FND_API.G_MISS_CHAR, NULL, x_SPORT_INDICATOR),
160: INTEREST_NAME = decode( x_INTEREST_NAME, NULL, INTEREST_NAME, FND_API.G_MISS_CHAR, NULL, x_INTEREST_NAME),
161: -- Bug 3032780
162: -- CREATED_BY = HZ_UTILITY_V2PUB.CREATED_BY,

Line 159: SPORT_INDICATOR = decode( x_SPORT_INDICATOR, NULL, SPORT_INDICATOR, FND_API.G_MISS_CHAR, NULL, x_SPORT_INDICATOR),

155: LEVEL_OF_INTEREST = decode( x_LEVEL_OF_INTEREST, NULL , LEVEL_OF_INTEREST, FND_API.G_MISS_CHAR, NULL, x_LEVEL_OF_INTEREST),
156: PARTY_ID = decode( x_PARTY_ID, NULL, PARTY_ID, FND_API.G_MISS_NUM, NULL, x_PARTY_ID),
157: LEVEL_OF_PARTICIPATION = decode( x_LEVEL_OF_PARTICIPATION, NULL, LEVEL_OF_PARTICIPATION, FND_API.G_MISS_CHAR, NULL, x_LEVEL_OF_PARTICIPATION),
158: INTEREST_TYPE_CODE = decode( x_INTEREST_TYPE_CODE, NULL, INTEREST_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, x_INTEREST_TYPE_CODE),
159: SPORT_INDICATOR = decode( x_SPORT_INDICATOR, NULL, SPORT_INDICATOR, FND_API.G_MISS_CHAR, NULL, x_SPORT_INDICATOR),
160: INTEREST_NAME = decode( x_INTEREST_NAME, NULL, INTEREST_NAME, FND_API.G_MISS_CHAR, NULL, x_INTEREST_NAME),
161: -- Bug 3032780
162: -- CREATED_BY = HZ_UTILITY_V2PUB.CREATED_BY,
163: -- CREATION_DATE = HZ_UTILITY_V2PUB.CREATION_DATE,

Line 160: INTEREST_NAME = decode( x_INTEREST_NAME, NULL, INTEREST_NAME, FND_API.G_MISS_CHAR, NULL, x_INTEREST_NAME),

156: PARTY_ID = decode( x_PARTY_ID, NULL, PARTY_ID, FND_API.G_MISS_NUM, NULL, x_PARTY_ID),
157: LEVEL_OF_PARTICIPATION = decode( x_LEVEL_OF_PARTICIPATION, NULL, LEVEL_OF_PARTICIPATION, FND_API.G_MISS_CHAR, NULL, x_LEVEL_OF_PARTICIPATION),
158: INTEREST_TYPE_CODE = decode( x_INTEREST_TYPE_CODE, NULL, INTEREST_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, x_INTEREST_TYPE_CODE),
159: SPORT_INDICATOR = decode( x_SPORT_INDICATOR, NULL, SPORT_INDICATOR, FND_API.G_MISS_CHAR, NULL, x_SPORT_INDICATOR),
160: INTEREST_NAME = decode( x_INTEREST_NAME, NULL, INTEREST_NAME, FND_API.G_MISS_CHAR, NULL, x_INTEREST_NAME),
161: -- Bug 3032780
162: -- CREATED_BY = HZ_UTILITY_V2PUB.CREATED_BY,
163: -- CREATION_DATE = HZ_UTILITY_V2PUB.CREATION_DATE,
164: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

Line 171: COMMENTS = decode( x_COMMENTS, NULL, COMMENTS, FND_API.G_MISS_CHAR, NULL, x_COMMENTS),

167: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
168: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
169: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
170: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
171: COMMENTS = decode( x_COMMENTS, NULL, COMMENTS, FND_API.G_MISS_CHAR, NULL, x_COMMENTS),
172: SUB_INTEREST_TYPE_CODE = decode( x_SUB_INTEREST_TYPE_CODE, NULL, SUB_INTEREST_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, x_SUB_INTEREST_TYPE_CODE),
173: TEAM = decode( x_TEAM, NULL, TEAM, FND_API.G_MISS_CHAR, null, x_TEAM),
174: SINCE = decode( x_SINCE, NULL, SINCE, FND_API.G_MISS_DATE, NULL, x_SINCE),
175: STATUS = decode(x_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR,NULL,x_STATUS),

Line 172: SUB_INTEREST_TYPE_CODE = decode( x_SUB_INTEREST_TYPE_CODE, NULL, SUB_INTEREST_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, x_SUB_INTEREST_TYPE_CODE),

168: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
169: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
170: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
171: COMMENTS = decode( x_COMMENTS, NULL, COMMENTS, FND_API.G_MISS_CHAR, NULL, x_COMMENTS),
172: SUB_INTEREST_TYPE_CODE = decode( x_SUB_INTEREST_TYPE_CODE, NULL, SUB_INTEREST_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, x_SUB_INTEREST_TYPE_CODE),
173: TEAM = decode( x_TEAM, NULL, TEAM, FND_API.G_MISS_CHAR, null, x_TEAM),
174: SINCE = decode( x_SINCE, NULL, SINCE, FND_API.G_MISS_DATE, NULL, x_SINCE),
175: STATUS = decode(x_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR,NULL,x_STATUS),
176: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),

Line 173: TEAM = decode( x_TEAM, NULL, TEAM, FND_API.G_MISS_CHAR, null, x_TEAM),

169: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
170: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
171: COMMENTS = decode( x_COMMENTS, NULL, COMMENTS, FND_API.G_MISS_CHAR, NULL, x_COMMENTS),
172: SUB_INTEREST_TYPE_CODE = decode( x_SUB_INTEREST_TYPE_CODE, NULL, SUB_INTEREST_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, x_SUB_INTEREST_TYPE_CODE),
173: TEAM = decode( x_TEAM, NULL, TEAM, FND_API.G_MISS_CHAR, null, x_TEAM),
174: SINCE = decode( x_SINCE, NULL, SINCE, FND_API.G_MISS_DATE, NULL, x_SINCE),
175: STATUS = decode(x_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR,NULL,x_STATUS),
176: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
177: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),

Line 174: SINCE = decode( x_SINCE, NULL, SINCE, FND_API.G_MISS_DATE, NULL, x_SINCE),

170: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
171: COMMENTS = decode( x_COMMENTS, NULL, COMMENTS, FND_API.G_MISS_CHAR, NULL, x_COMMENTS),
172: SUB_INTEREST_TYPE_CODE = decode( x_SUB_INTEREST_TYPE_CODE, NULL, SUB_INTEREST_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, x_SUB_INTEREST_TYPE_CODE),
173: TEAM = decode( x_TEAM, NULL, TEAM, FND_API.G_MISS_CHAR, null, x_TEAM),
174: SINCE = decode( x_SINCE, NULL, SINCE, FND_API.G_MISS_DATE, NULL, x_SINCE),
175: STATUS = decode(x_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR,NULL,x_STATUS),
176: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
177: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
178: APPLICATION_ID = HZ_UTILITY_V2PUB.APPLICATION_ID

Line 175: STATUS = decode(x_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR,NULL,x_STATUS),

171: COMMENTS = decode( x_COMMENTS, NULL, COMMENTS, FND_API.G_MISS_CHAR, NULL, x_COMMENTS),
172: SUB_INTEREST_TYPE_CODE = decode( x_SUB_INTEREST_TYPE_CODE, NULL, SUB_INTEREST_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, x_SUB_INTEREST_TYPE_CODE),
173: TEAM = decode( x_TEAM, NULL, TEAM, FND_API.G_MISS_CHAR, null, x_TEAM),
174: SINCE = decode( x_SINCE, NULL, SINCE, FND_API.G_MISS_DATE, NULL, x_SINCE),
175: STATUS = decode(x_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR,NULL,x_STATUS),
176: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
177: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
178: APPLICATION_ID = HZ_UTILITY_V2PUB.APPLICATION_ID
179:

Line 176: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),

172: SUB_INTEREST_TYPE_CODE = decode( x_SUB_INTEREST_TYPE_CODE, NULL, SUB_INTEREST_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, x_SUB_INTEREST_TYPE_CODE),
173: TEAM = decode( x_TEAM, NULL, TEAM, FND_API.G_MISS_CHAR, null, x_TEAM),
174: SINCE = decode( x_SINCE, NULL, SINCE, FND_API.G_MISS_DATE, NULL, x_SINCE),
175: STATUS = decode(x_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR,NULL,x_STATUS),
176: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
177: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
178: APPLICATION_ID = HZ_UTILITY_V2PUB.APPLICATION_ID
179:
180:

Line 177: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),

173: TEAM = decode( x_TEAM, NULL, TEAM, FND_API.G_MISS_CHAR, null, x_TEAM),
174: SINCE = decode( x_SINCE, NULL, SINCE, FND_API.G_MISS_DATE, NULL, x_SINCE),
175: STATUS = decode(x_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR,NULL,x_STATUS),
176: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
177: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
178: APPLICATION_ID = HZ_UTILITY_V2PUB.APPLICATION_ID
179:
180:
181: where rowid = X_RowId;

Line 324: NVL(person_interest_id, FND_API.G_MISS_NUM),

320: ) IS
321: BEGIN
322:
323: SELECT
324: NVL(person_interest_id, FND_API.G_MISS_NUM),
325: NVL(level_of_interest, FND_API.G_MISS_CHAR),
326: NVL(party_id, FND_API.G_MISS_NUM),
327: NVL(level_of_participation, FND_API.G_MISS_CHAR),
328: NVL(interest_type_code, FND_API.G_MISS_CHAR),

Line 325: NVL(level_of_interest, FND_API.G_MISS_CHAR),

321: BEGIN
322:
323: SELECT
324: NVL(person_interest_id, FND_API.G_MISS_NUM),
325: NVL(level_of_interest, FND_API.G_MISS_CHAR),
326: NVL(party_id, FND_API.G_MISS_NUM),
327: NVL(level_of_participation, FND_API.G_MISS_CHAR),
328: NVL(interest_type_code, FND_API.G_MISS_CHAR),
329: NVL(comments, FND_API.G_MISS_CHAR),

Line 326: NVL(party_id, FND_API.G_MISS_NUM),

322:
323: SELECT
324: NVL(person_interest_id, FND_API.G_MISS_NUM),
325: NVL(level_of_interest, FND_API.G_MISS_CHAR),
326: NVL(party_id, FND_API.G_MISS_NUM),
327: NVL(level_of_participation, FND_API.G_MISS_CHAR),
328: NVL(interest_type_code, FND_API.G_MISS_CHAR),
329: NVL(comments, FND_API.G_MISS_CHAR),
330: NVL(sport_indicator, FND_API.G_MISS_CHAR),

Line 327: NVL(level_of_participation, FND_API.G_MISS_CHAR),

323: SELECT
324: NVL(person_interest_id, FND_API.G_MISS_NUM),
325: NVL(level_of_interest, FND_API.G_MISS_CHAR),
326: NVL(party_id, FND_API.G_MISS_NUM),
327: NVL(level_of_participation, FND_API.G_MISS_CHAR),
328: NVL(interest_type_code, FND_API.G_MISS_CHAR),
329: NVL(comments, FND_API.G_MISS_CHAR),
330: NVL(sport_indicator, FND_API.G_MISS_CHAR),
331: NVL(sub_interest_type_code, FND_API.G_MISS_CHAR),

Line 328: NVL(interest_type_code, FND_API.G_MISS_CHAR),

324: NVL(person_interest_id, FND_API.G_MISS_NUM),
325: NVL(level_of_interest, FND_API.G_MISS_CHAR),
326: NVL(party_id, FND_API.G_MISS_NUM),
327: NVL(level_of_participation, FND_API.G_MISS_CHAR),
328: NVL(interest_type_code, FND_API.G_MISS_CHAR),
329: NVL(comments, FND_API.G_MISS_CHAR),
330: NVL(sport_indicator, FND_API.G_MISS_CHAR),
331: NVL(sub_interest_type_code, FND_API.G_MISS_CHAR),
332: NVL(interest_name, FND_API.G_MISS_CHAR),

Line 329: NVL(comments, FND_API.G_MISS_CHAR),

325: NVL(level_of_interest, FND_API.G_MISS_CHAR),
326: NVL(party_id, FND_API.G_MISS_NUM),
327: NVL(level_of_participation, FND_API.G_MISS_CHAR),
328: NVL(interest_type_code, FND_API.G_MISS_CHAR),
329: NVL(comments, FND_API.G_MISS_CHAR),
330: NVL(sport_indicator, FND_API.G_MISS_CHAR),
331: NVL(sub_interest_type_code, FND_API.G_MISS_CHAR),
332: NVL(interest_name, FND_API.G_MISS_CHAR),
333: NVL(team, FND_API.G_MISS_CHAR),

Line 330: NVL(sport_indicator, FND_API.G_MISS_CHAR),

326: NVL(party_id, FND_API.G_MISS_NUM),
327: NVL(level_of_participation, FND_API.G_MISS_CHAR),
328: NVL(interest_type_code, FND_API.G_MISS_CHAR),
329: NVL(comments, FND_API.G_MISS_CHAR),
330: NVL(sport_indicator, FND_API.G_MISS_CHAR),
331: NVL(sub_interest_type_code, FND_API.G_MISS_CHAR),
332: NVL(interest_name, FND_API.G_MISS_CHAR),
333: NVL(team, FND_API.G_MISS_CHAR),
334: NVL(since, FND_API.G_MISS_DATE),

Line 331: NVL(sub_interest_type_code, FND_API.G_MISS_CHAR),

327: NVL(level_of_participation, FND_API.G_MISS_CHAR),
328: NVL(interest_type_code, FND_API.G_MISS_CHAR),
329: NVL(comments, FND_API.G_MISS_CHAR),
330: NVL(sport_indicator, FND_API.G_MISS_CHAR),
331: NVL(sub_interest_type_code, FND_API.G_MISS_CHAR),
332: NVL(interest_name, FND_API.G_MISS_CHAR),
333: NVL(team, FND_API.G_MISS_CHAR),
334: NVL(since, FND_API.G_MISS_DATE),
335: NVL(status, FND_API.G_MISS_CHAR),

Line 332: NVL(interest_name, FND_API.G_MISS_CHAR),

328: NVL(interest_type_code, FND_API.G_MISS_CHAR),
329: NVL(comments, FND_API.G_MISS_CHAR),
330: NVL(sport_indicator, FND_API.G_MISS_CHAR),
331: NVL(sub_interest_type_code, FND_API.G_MISS_CHAR),
332: NVL(interest_name, FND_API.G_MISS_CHAR),
333: NVL(team, FND_API.G_MISS_CHAR),
334: NVL(since, FND_API.G_MISS_DATE),
335: NVL(status, FND_API.G_MISS_CHAR),
336: NVL(application_id, FND_API.G_MISS_NUM),

Line 333: NVL(team, FND_API.G_MISS_CHAR),

329: NVL(comments, FND_API.G_MISS_CHAR),
330: NVL(sport_indicator, FND_API.G_MISS_CHAR),
331: NVL(sub_interest_type_code, FND_API.G_MISS_CHAR),
332: NVL(interest_name, FND_API.G_MISS_CHAR),
333: NVL(team, FND_API.G_MISS_CHAR),
334: NVL(since, FND_API.G_MISS_DATE),
335: NVL(status, FND_API.G_MISS_CHAR),
336: NVL(application_id, FND_API.G_MISS_NUM),
337: NVL(created_by_module, FND_API.G_MISS_CHAR)

Line 334: NVL(since, FND_API.G_MISS_DATE),

330: NVL(sport_indicator, FND_API.G_MISS_CHAR),
331: NVL(sub_interest_type_code, FND_API.G_MISS_CHAR),
332: NVL(interest_name, FND_API.G_MISS_CHAR),
333: NVL(team, FND_API.G_MISS_CHAR),
334: NVL(since, FND_API.G_MISS_DATE),
335: NVL(status, FND_API.G_MISS_CHAR),
336: NVL(application_id, FND_API.G_MISS_NUM),
337: NVL(created_by_module, FND_API.G_MISS_CHAR)
338: INTO

Line 335: NVL(status, FND_API.G_MISS_CHAR),

331: NVL(sub_interest_type_code, FND_API.G_MISS_CHAR),
332: NVL(interest_name, FND_API.G_MISS_CHAR),
333: NVL(team, FND_API.G_MISS_CHAR),
334: NVL(since, FND_API.G_MISS_DATE),
335: NVL(status, FND_API.G_MISS_CHAR),
336: NVL(application_id, FND_API.G_MISS_NUM),
337: NVL(created_by_module, FND_API.G_MISS_CHAR)
338: INTO
339: x_person_interest_id,

Line 336: NVL(application_id, FND_API.G_MISS_NUM),

332: NVL(interest_name, FND_API.G_MISS_CHAR),
333: NVL(team, FND_API.G_MISS_CHAR),
334: NVL(since, FND_API.G_MISS_DATE),
335: NVL(status, FND_API.G_MISS_CHAR),
336: NVL(application_id, FND_API.G_MISS_NUM),
337: NVL(created_by_module, FND_API.G_MISS_CHAR)
338: INTO
339: x_person_interest_id,
340: x_level_of_interest,

Line 337: NVL(created_by_module, FND_API.G_MISS_CHAR)

333: NVL(team, FND_API.G_MISS_CHAR),
334: NVL(since, FND_API.G_MISS_DATE),
335: NVL(status, FND_API.G_MISS_CHAR),
336: NVL(application_id, FND_API.G_MISS_NUM),
337: NVL(created_by_module, FND_API.G_MISS_CHAR)
338: INTO
339: x_person_interest_id,
340: x_level_of_interest,
341: x_party_id,

Line 363: RAISE FND_API.G_EXC_ERROR;

359: --2890664, Changed this message token
360: FND_MESSAGE.SET_TOKEN('RECORD', 'PERSON_INTEREST_REC');
361: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(x_person_interest_id));
362: FND_MSG_PUB.ADD;
363: RAISE FND_API.G_EXC_ERROR;
364:
365: END Select_Row;
366:
367: