APPS.HZ_CITIZENSHIP_PKG dependencies on HZ_UTILITY_V2PUB

Line 63: HZ_UTILITY_V2PUB.CREATED_BY,

59: decode( x_DATE_DISOWNED, FND_API.G_MISS_DATE, TO_DATE(NULL),x_DATE_DISOWNED),
60: decode( x_DATE_RECOGNIZED, FND_API.G_MISS_DATE, TO_DATE(NULL),x_DATE_RECOGNIZED),
61: decode( x_DOCUMENT_REFERENCE, FND_API.G_MISS_CHAR, NULL,x_DOCUMENT_REFERENCE),
62: decode( x_DOCUMENT_TYPE, FND_API.G_MISS_CHAR, NULL,x_DOCUMENT_TYPE),
63: HZ_UTILITY_V2PUB.CREATED_BY,
64: HZ_UTILITY_V2PUB.CREATION_DATE,
65: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
66: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
67: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,

Line 64: HZ_UTILITY_V2PUB.CREATION_DATE,

60: decode( x_DATE_RECOGNIZED, FND_API.G_MISS_DATE, TO_DATE(NULL),x_DATE_RECOGNIZED),
61: decode( x_DOCUMENT_REFERENCE, FND_API.G_MISS_CHAR, NULL,x_DOCUMENT_REFERENCE),
62: decode( x_DOCUMENT_TYPE, FND_API.G_MISS_CHAR, NULL,x_DOCUMENT_TYPE),
63: HZ_UTILITY_V2PUB.CREATED_BY,
64: HZ_UTILITY_V2PUB.CREATION_DATE,
65: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
66: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
67: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
68: HZ_UTILITY_V2PUB.REQUEST_ID,

Line 65: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

61: decode( x_DOCUMENT_REFERENCE, FND_API.G_MISS_CHAR, NULL,x_DOCUMENT_REFERENCE),
62: decode( x_DOCUMENT_TYPE, FND_API.G_MISS_CHAR, NULL,x_DOCUMENT_TYPE),
63: HZ_UTILITY_V2PUB.CREATED_BY,
64: HZ_UTILITY_V2PUB.CREATION_DATE,
65: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
66: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
67: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
68: HZ_UTILITY_V2PUB.REQUEST_ID,
69: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,

Line 66: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

62: decode( x_DOCUMENT_TYPE, FND_API.G_MISS_CHAR, NULL,x_DOCUMENT_TYPE),
63: HZ_UTILITY_V2PUB.CREATED_BY,
64: HZ_UTILITY_V2PUB.CREATION_DATE,
65: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
66: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
67: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
68: HZ_UTILITY_V2PUB.REQUEST_ID,
69: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
70: HZ_UTILITY_V2PUB.PROGRAM_ID,

Line 67: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,

63: HZ_UTILITY_V2PUB.CREATED_BY,
64: HZ_UTILITY_V2PUB.CREATION_DATE,
65: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
66: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
67: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
68: HZ_UTILITY_V2PUB.REQUEST_ID,
69: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
70: HZ_UTILITY_V2PUB.PROGRAM_ID,
71: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,

Line 68: HZ_UTILITY_V2PUB.REQUEST_ID,

64: HZ_UTILITY_V2PUB.CREATION_DATE,
65: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
66: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
67: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
68: HZ_UTILITY_V2PUB.REQUEST_ID,
69: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
70: HZ_UTILITY_V2PUB.PROGRAM_ID,
71: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
72: decode( x_END_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_END_DATE),

Line 69: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,

65: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
66: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
67: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
68: HZ_UTILITY_V2PUB.REQUEST_ID,
69: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
70: HZ_UTILITY_V2PUB.PROGRAM_ID,
71: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
72: decode( x_END_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_END_DATE),
73: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),

Line 70: HZ_UTILITY_V2PUB.PROGRAM_ID,

66: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
67: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
68: HZ_UTILITY_V2PUB.REQUEST_ID,
69: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
70: HZ_UTILITY_V2PUB.PROGRAM_ID,
71: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
72: decode( x_END_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_END_DATE),
73: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
74: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),

Line 71: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,

67: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
68: HZ_UTILITY_V2PUB.REQUEST_ID,
69: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
70: HZ_UTILITY_V2PUB.PROGRAM_ID,
71: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
72: decode( x_END_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_END_DATE),
73: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
74: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
75: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),

Line 76: HZ_UTILITY_V2PUB.APPLICATION_ID

72: decode( x_END_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_END_DATE),
73: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
74: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
75: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
76: HZ_UTILITY_V2PUB.APPLICATION_ID
77: )
78: RETURNING
79: CITIZENSHIP_ID
80: INTO

Line 161: -- CREATED_BY = HZ_UTILITY_V2PUB.CREATED_BY,

157: DATE_RECOGNIZED = decode( x_DATE_RECOGNIZED, NULL, DATE_RECOGNIZED, FND_API.G_MISS_DATE, NULL, x_DATE_RECOGNIZED),
158: DOCUMENT_REFERENCE = decode( x_DOCUMENT_REFERENCE, NULL, DOCUMENT_REFERENCE, FND_API.G_MISS_CHAR,NULL,x_DOCUMENT_REFERENCE),
159: DOCUMENT_TYPE = decode( x_DOCUMENT_TYPE, NULL, DOCUMENT_TYPE, FND_API.G_MISS_CHAR,NULL, x_DOCUMENT_TYPE),
160: -- Bug 3032780
161: -- CREATED_BY = HZ_UTILITY_V2PUB.CREATED_BY,
162: -- CREATION_DATE = HZ_UTILITY_V2PUB.CREATION_DATE,
163: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
164: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
165: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,

Line 162: -- CREATION_DATE = HZ_UTILITY_V2PUB.CREATION_DATE,

158: DOCUMENT_REFERENCE = decode( x_DOCUMENT_REFERENCE, NULL, DOCUMENT_REFERENCE, FND_API.G_MISS_CHAR,NULL,x_DOCUMENT_REFERENCE),
159: DOCUMENT_TYPE = decode( x_DOCUMENT_TYPE, NULL, DOCUMENT_TYPE, FND_API.G_MISS_CHAR,NULL, x_DOCUMENT_TYPE),
160: -- Bug 3032780
161: -- CREATED_BY = HZ_UTILITY_V2PUB.CREATED_BY,
162: -- CREATION_DATE = HZ_UTILITY_V2PUB.CREATION_DATE,
163: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
164: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
165: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
166: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,

Line 163: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

159: DOCUMENT_TYPE = decode( x_DOCUMENT_TYPE, NULL, DOCUMENT_TYPE, FND_API.G_MISS_CHAR,NULL, x_DOCUMENT_TYPE),
160: -- Bug 3032780
161: -- CREATED_BY = HZ_UTILITY_V2PUB.CREATED_BY,
162: -- CREATION_DATE = HZ_UTILITY_V2PUB.CREATION_DATE,
163: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
164: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
165: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
166: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
167: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,

Line 164: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

160: -- Bug 3032780
161: -- CREATED_BY = HZ_UTILITY_V2PUB.CREATED_BY,
162: -- CREATION_DATE = HZ_UTILITY_V2PUB.CREATION_DATE,
163: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
164: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
165: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
166: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
167: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
168: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,

Line 165: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,

161: -- CREATED_BY = HZ_UTILITY_V2PUB.CREATED_BY,
162: -- CREATION_DATE = HZ_UTILITY_V2PUB.CREATION_DATE,
163: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
164: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
165: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
166: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
167: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
168: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
169: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,

Line 166: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,

162: -- CREATION_DATE = HZ_UTILITY_V2PUB.CREATION_DATE,
163: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
164: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
165: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
166: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
167: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
168: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
169: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
170: END_DATE = decode( x_END_DATE, NULL, END_DATE, FND_API.G_MISS_DATE, NULL, x_END_DATE),

Line 167: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,

163: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
164: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
165: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
166: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
167: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
168: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
169: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
170: END_DATE = decode( x_END_DATE, NULL, END_DATE, FND_API.G_MISS_DATE, NULL, x_END_DATE),
171: STATUS=decode(x_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, NULL,x_STATUS),

Line 168: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,

164: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
165: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
166: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
167: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
168: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
169: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
170: END_DATE = decode( x_END_DATE, NULL, END_DATE, FND_API.G_MISS_DATE, NULL, x_END_DATE),
171: STATUS=decode(x_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, NULL,x_STATUS),
172: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),

Line 169: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,

165: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
166: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
167: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
168: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
169: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
170: END_DATE = decode( x_END_DATE, NULL, END_DATE, FND_API.G_MISS_DATE, NULL, x_END_DATE),
171: STATUS=decode(x_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, NULL,x_STATUS),
172: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
173: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),

Line 174: APPLICATION_ID=HZ_UTILITY_V2PUB.APPLICATION_ID

170: END_DATE = decode( x_END_DATE, NULL, END_DATE, FND_API.G_MISS_DATE, NULL, x_END_DATE),
171: STATUS=decode(x_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, NULL,x_STATUS),
172: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
173: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
174: APPLICATION_ID=HZ_UTILITY_V2PUB.APPLICATION_ID
175:
176: where rowid = X_RowId;
177:
178: If (SQL%NOTFOUND) then