APPS.HZ_CITIZENSHIP_PKG dependencies on FND_API

Line 55: decode( X_CITIZENSHIP_ID, FND_API.G_MISS_NUM, HZ_CITIZENSHIP_S.NEXTVAL, NULL, HZ_CITIZENSHIP_S.NEXTVAL, X_CITIZENSHIP_ID ),

51: OBJECT_VERSION_NUMBER,
52: CREATED_BY_MODULE,
53: APPLICATION_ID
54: ) VALUES (
55: decode( X_CITIZENSHIP_ID, FND_API.G_MISS_NUM, HZ_CITIZENSHIP_S.NEXTVAL, NULL, HZ_CITIZENSHIP_S.NEXTVAL, X_CITIZENSHIP_ID ),
56: decode( x_BIRTH_OR_SELECTED, FND_API.G_MISS_CHAR, NULL,x_BIRTH_OR_SELECTED),
57: decode( x_PARTY_ID, FND_API.G_MISS_NUM, NULL,x_PARTY_ID),
58: decode( x_COUNTRY_CODE, FND_API.G_MISS_CHAR, NULL,x_COUNTRY_CODE),
59: decode( x_DATE_DISOWNED, FND_API.G_MISS_DATE, TO_DATE(NULL),x_DATE_DISOWNED),

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

52: CREATED_BY_MODULE,
53: APPLICATION_ID
54: ) VALUES (
55: decode( X_CITIZENSHIP_ID, FND_API.G_MISS_NUM, HZ_CITIZENSHIP_S.NEXTVAL, NULL, HZ_CITIZENSHIP_S.NEXTVAL, X_CITIZENSHIP_ID ),
56: decode( x_BIRTH_OR_SELECTED, FND_API.G_MISS_CHAR, NULL,x_BIRTH_OR_SELECTED),
57: decode( x_PARTY_ID, FND_API.G_MISS_NUM, NULL,x_PARTY_ID),
58: decode( x_COUNTRY_CODE, FND_API.G_MISS_CHAR, NULL,x_COUNTRY_CODE),
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),

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

53: APPLICATION_ID
54: ) VALUES (
55: decode( X_CITIZENSHIP_ID, FND_API.G_MISS_NUM, HZ_CITIZENSHIP_S.NEXTVAL, NULL, HZ_CITIZENSHIP_S.NEXTVAL, X_CITIZENSHIP_ID ),
56: decode( x_BIRTH_OR_SELECTED, FND_API.G_MISS_CHAR, NULL,x_BIRTH_OR_SELECTED),
57: decode( x_PARTY_ID, FND_API.G_MISS_NUM, NULL,x_PARTY_ID),
58: decode( x_COUNTRY_CODE, FND_API.G_MISS_CHAR, NULL,x_COUNTRY_CODE),
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),

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

54: ) VALUES (
55: decode( X_CITIZENSHIP_ID, FND_API.G_MISS_NUM, HZ_CITIZENSHIP_S.NEXTVAL, NULL, HZ_CITIZENSHIP_S.NEXTVAL, X_CITIZENSHIP_ID ),
56: decode( x_BIRTH_OR_SELECTED, FND_API.G_MISS_CHAR, NULL,x_BIRTH_OR_SELECTED),
57: decode( x_PARTY_ID, FND_API.G_MISS_NUM, NULL,x_PARTY_ID),
58: decode( x_COUNTRY_CODE, FND_API.G_MISS_CHAR, NULL,x_COUNTRY_CODE),
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),

Line 59: decode( x_DATE_DISOWNED, FND_API.G_MISS_DATE, TO_DATE(NULL),x_DATE_DISOWNED),

55: decode( X_CITIZENSHIP_ID, FND_API.G_MISS_NUM, HZ_CITIZENSHIP_S.NEXTVAL, NULL, HZ_CITIZENSHIP_S.NEXTVAL, X_CITIZENSHIP_ID ),
56: decode( x_BIRTH_OR_SELECTED, FND_API.G_MISS_CHAR, NULL,x_BIRTH_OR_SELECTED),
57: decode( x_PARTY_ID, FND_API.G_MISS_NUM, NULL,x_PARTY_ID),
58: decode( x_COUNTRY_CODE, FND_API.G_MISS_CHAR, NULL,x_COUNTRY_CODE),
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,

Line 60: decode( x_DATE_RECOGNIZED, FND_API.G_MISS_DATE, TO_DATE(NULL),x_DATE_RECOGNIZED),

56: decode( x_BIRTH_OR_SELECTED, FND_API.G_MISS_CHAR, NULL,x_BIRTH_OR_SELECTED),
57: decode( x_PARTY_ID, FND_API.G_MISS_NUM, NULL,x_PARTY_ID),
58: decode( x_COUNTRY_CODE, FND_API.G_MISS_CHAR, NULL,x_COUNTRY_CODE),
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,

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

57: decode( x_PARTY_ID, FND_API.G_MISS_NUM, NULL,x_PARTY_ID),
58: decode( x_COUNTRY_CODE, FND_API.G_MISS_CHAR, NULL,x_COUNTRY_CODE),
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,

Line 62: decode( x_DOCUMENT_TYPE, FND_API.G_MISS_CHAR, NULL,x_DOCUMENT_TYPE),

58: decode( x_COUNTRY_CODE, FND_API.G_MISS_CHAR, NULL,x_COUNTRY_CODE),
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,

Line 72: decode( x_END_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_END_DATE),

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 ),
76: HZ_UTILITY_V2PUB.APPLICATION_ID

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

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 ),
76: HZ_UTILITY_V2PUB.APPLICATION_ID
77: )

Line 74: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),

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 ),
76: HZ_UTILITY_V2PUB.APPLICATION_ID
77: )
78: RETURNING

Line 75: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),

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 ),
76: HZ_UTILITY_V2PUB.APPLICATION_ID
77: )
78: RETURNING
79: CITIZENSHIP_ID

Line 152: CITIZENSHIP_ID = decode( x_CITIZENSHIP_ID, NULL, CITIZENSHIP_ID, FND_API.G_MISS_NUM, NULL, X_CITIZENSHIP_ID ),

148: BEGIN
149: Update HZ_CITIZENSHIP
150: SET
151:
152: CITIZENSHIP_ID = decode( x_CITIZENSHIP_ID, NULL, CITIZENSHIP_ID, FND_API.G_MISS_NUM, NULL, X_CITIZENSHIP_ID ),
153: BIRTH_OR_SELECTED = decode( x_BIRTH_OR_SELECTED, NULL, BIRTH_OR_SELECTED, FND_API.G_MISS_CHAR, NULL, x_BIRTH_OR_SELECTED ),
154: PARTY_ID = DECODE( X_PARTY_ID, NULL, PARTY_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_ID ),
155: COUNTRY_CODE = DECODE( x_COUNTRY_CODE, NULL, COUNTRY_CODE, FND_API.G_MISS_CHAR, NULL, x_COUNTRY_CODE ),
156: DATE_DISOWNED = decode( x_DATE_DISOWNED, NULL, DATE_DISOWNED, FND_API.G_MISS_DATE,NULL ,x_DATE_DISOWNED),

Line 153: BIRTH_OR_SELECTED = decode( x_BIRTH_OR_SELECTED, NULL, BIRTH_OR_SELECTED, FND_API.G_MISS_CHAR, NULL, x_BIRTH_OR_SELECTED ),

149: Update HZ_CITIZENSHIP
150: SET
151:
152: CITIZENSHIP_ID = decode( x_CITIZENSHIP_ID, NULL, CITIZENSHIP_ID, FND_API.G_MISS_NUM, NULL, X_CITIZENSHIP_ID ),
153: BIRTH_OR_SELECTED = decode( x_BIRTH_OR_SELECTED, NULL, BIRTH_OR_SELECTED, FND_API.G_MISS_CHAR, NULL, x_BIRTH_OR_SELECTED ),
154: PARTY_ID = DECODE( X_PARTY_ID, NULL, PARTY_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_ID ),
155: COUNTRY_CODE = DECODE( x_COUNTRY_CODE, NULL, COUNTRY_CODE, FND_API.G_MISS_CHAR, NULL, x_COUNTRY_CODE ),
156: DATE_DISOWNED = decode( x_DATE_DISOWNED, NULL, DATE_DISOWNED, FND_API.G_MISS_DATE,NULL ,x_DATE_DISOWNED),
157: DATE_RECOGNIZED = decode( x_DATE_RECOGNIZED, NULL, DATE_RECOGNIZED, FND_API.G_MISS_DATE, NULL, x_DATE_RECOGNIZED),

Line 154: PARTY_ID = DECODE( X_PARTY_ID, NULL, PARTY_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_ID ),

150: SET
151:
152: CITIZENSHIP_ID = decode( x_CITIZENSHIP_ID, NULL, CITIZENSHIP_ID, FND_API.G_MISS_NUM, NULL, X_CITIZENSHIP_ID ),
153: BIRTH_OR_SELECTED = decode( x_BIRTH_OR_SELECTED, NULL, BIRTH_OR_SELECTED, FND_API.G_MISS_CHAR, NULL, x_BIRTH_OR_SELECTED ),
154: PARTY_ID = DECODE( X_PARTY_ID, NULL, PARTY_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_ID ),
155: COUNTRY_CODE = DECODE( x_COUNTRY_CODE, NULL, COUNTRY_CODE, FND_API.G_MISS_CHAR, NULL, x_COUNTRY_CODE ),
156: DATE_DISOWNED = decode( x_DATE_DISOWNED, NULL, DATE_DISOWNED, FND_API.G_MISS_DATE,NULL ,x_DATE_DISOWNED),
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),

Line 155: COUNTRY_CODE = DECODE( x_COUNTRY_CODE, NULL, COUNTRY_CODE, FND_API.G_MISS_CHAR, NULL, x_COUNTRY_CODE ),

151:
152: CITIZENSHIP_ID = decode( x_CITIZENSHIP_ID, NULL, CITIZENSHIP_ID, FND_API.G_MISS_NUM, NULL, X_CITIZENSHIP_ID ),
153: BIRTH_OR_SELECTED = decode( x_BIRTH_OR_SELECTED, NULL, BIRTH_OR_SELECTED, FND_API.G_MISS_CHAR, NULL, x_BIRTH_OR_SELECTED ),
154: PARTY_ID = DECODE( X_PARTY_ID, NULL, PARTY_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_ID ),
155: COUNTRY_CODE = DECODE( x_COUNTRY_CODE, NULL, COUNTRY_CODE, FND_API.G_MISS_CHAR, NULL, x_COUNTRY_CODE ),
156: DATE_DISOWNED = decode( x_DATE_DISOWNED, NULL, DATE_DISOWNED, FND_API.G_MISS_DATE,NULL ,x_DATE_DISOWNED),
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),

Line 156: DATE_DISOWNED = decode( x_DATE_DISOWNED, NULL, DATE_DISOWNED, FND_API.G_MISS_DATE,NULL ,x_DATE_DISOWNED),

152: CITIZENSHIP_ID = decode( x_CITIZENSHIP_ID, NULL, CITIZENSHIP_ID, FND_API.G_MISS_NUM, NULL, X_CITIZENSHIP_ID ),
153: BIRTH_OR_SELECTED = decode( x_BIRTH_OR_SELECTED, NULL, BIRTH_OR_SELECTED, FND_API.G_MISS_CHAR, NULL, x_BIRTH_OR_SELECTED ),
154: PARTY_ID = DECODE( X_PARTY_ID, NULL, PARTY_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_ID ),
155: COUNTRY_CODE = DECODE( x_COUNTRY_CODE, NULL, COUNTRY_CODE, FND_API.G_MISS_CHAR, NULL, x_COUNTRY_CODE ),
156: DATE_DISOWNED = decode( x_DATE_DISOWNED, NULL, DATE_DISOWNED, FND_API.G_MISS_DATE,NULL ,x_DATE_DISOWNED),
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

Line 157: DATE_RECOGNIZED = decode( x_DATE_RECOGNIZED, NULL, DATE_RECOGNIZED, FND_API.G_MISS_DATE, NULL, x_DATE_RECOGNIZED),

153: BIRTH_OR_SELECTED = decode( x_BIRTH_OR_SELECTED, NULL, BIRTH_OR_SELECTED, FND_API.G_MISS_CHAR, NULL, x_BIRTH_OR_SELECTED ),
154: PARTY_ID = DECODE( X_PARTY_ID, NULL, PARTY_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_ID ),
155: COUNTRY_CODE = DECODE( x_COUNTRY_CODE, NULL, COUNTRY_CODE, FND_API.G_MISS_CHAR, NULL, x_COUNTRY_CODE ),
156: DATE_DISOWNED = decode( x_DATE_DISOWNED, NULL, DATE_DISOWNED, FND_API.G_MISS_DATE,NULL ,x_DATE_DISOWNED),
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,

Line 158: DOCUMENT_REFERENCE = decode( x_DOCUMENT_REFERENCE, NULL, DOCUMENT_REFERENCE, FND_API.G_MISS_CHAR,NULL,x_DOCUMENT_REFERENCE),

154: PARTY_ID = DECODE( X_PARTY_ID, NULL, PARTY_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_ID ),
155: COUNTRY_CODE = DECODE( x_COUNTRY_CODE, NULL, COUNTRY_CODE, FND_API.G_MISS_CHAR, NULL, x_COUNTRY_CODE ),
156: DATE_DISOWNED = decode( x_DATE_DISOWNED, NULL, DATE_DISOWNED, FND_API.G_MISS_DATE,NULL ,x_DATE_DISOWNED),
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,

Line 159: DOCUMENT_TYPE = decode( x_DOCUMENT_TYPE, NULL, DOCUMENT_TYPE, FND_API.G_MISS_CHAR,NULL, x_DOCUMENT_TYPE),

155: COUNTRY_CODE = DECODE( x_COUNTRY_CODE, NULL, COUNTRY_CODE, FND_API.G_MISS_CHAR, NULL, x_COUNTRY_CODE ),
156: DATE_DISOWNED = decode( x_DATE_DISOWNED, NULL, DATE_DISOWNED, FND_API.G_MISS_DATE,NULL ,x_DATE_DISOWNED),
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,

Line 170: END_DATE = decode( x_END_DATE, NULL, END_DATE, FND_API.G_MISS_DATE, NULL, x_END_DATE),

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 ),
174: APPLICATION_ID=HZ_UTILITY_V2PUB.APPLICATION_ID

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

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 ),
174: APPLICATION_ID=HZ_UTILITY_V2PUB.APPLICATION_ID
175:

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

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 ),
174: APPLICATION_ID=HZ_UTILITY_V2PUB.APPLICATION_ID
175:
176: where rowid = X_RowId;

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

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 ),
174: APPLICATION_ID=HZ_UTILITY_V2PUB.APPLICATION_ID
175:
176: where rowid = X_RowId;
177:

Line 308: NVL(citizenship_id, FND_API.G_MISS_NUM),

304: ) IS
305: BEGIN
306:
307: SELECT
308: NVL(citizenship_id, FND_API.G_MISS_NUM),
309: NVL(birth_or_selected, FND_API.G_MISS_CHAR),
310: NVL(party_id, FND_API.G_MISS_NUM),
311: NVL(country_code, FND_API.G_MISS_CHAR),
312: NVL(date_disowned, FND_API.G_MISS_DATE),

Line 309: NVL(birth_or_selected, FND_API.G_MISS_CHAR),

305: BEGIN
306:
307: SELECT
308: NVL(citizenship_id, FND_API.G_MISS_NUM),
309: NVL(birth_or_selected, FND_API.G_MISS_CHAR),
310: NVL(party_id, FND_API.G_MISS_NUM),
311: NVL(country_code, FND_API.G_MISS_CHAR),
312: NVL(date_disowned, FND_API.G_MISS_DATE),
313: NVL(date_recognized, FND_API.G_MISS_DATE),

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

306:
307: SELECT
308: NVL(citizenship_id, FND_API.G_MISS_NUM),
309: NVL(birth_or_selected, FND_API.G_MISS_CHAR),
310: NVL(party_id, FND_API.G_MISS_NUM),
311: NVL(country_code, FND_API.G_MISS_CHAR),
312: NVL(date_disowned, FND_API.G_MISS_DATE),
313: NVL(date_recognized, FND_API.G_MISS_DATE),
314: NVL(document_reference, FND_API.G_MISS_CHAR),

Line 311: NVL(country_code, FND_API.G_MISS_CHAR),

307: SELECT
308: NVL(citizenship_id, FND_API.G_MISS_NUM),
309: NVL(birth_or_selected, FND_API.G_MISS_CHAR),
310: NVL(party_id, FND_API.G_MISS_NUM),
311: NVL(country_code, FND_API.G_MISS_CHAR),
312: NVL(date_disowned, FND_API.G_MISS_DATE),
313: NVL(date_recognized, FND_API.G_MISS_DATE),
314: NVL(document_reference, FND_API.G_MISS_CHAR),
315: NVL(end_date, FND_API.G_MISS_DATE),

Line 312: NVL(date_disowned, FND_API.G_MISS_DATE),

308: NVL(citizenship_id, FND_API.G_MISS_NUM),
309: NVL(birth_or_selected, FND_API.G_MISS_CHAR),
310: NVL(party_id, FND_API.G_MISS_NUM),
311: NVL(country_code, FND_API.G_MISS_CHAR),
312: NVL(date_disowned, FND_API.G_MISS_DATE),
313: NVL(date_recognized, FND_API.G_MISS_DATE),
314: NVL(document_reference, FND_API.G_MISS_CHAR),
315: NVL(end_date, FND_API.G_MISS_DATE),
316: NVL(document_type, FND_API.G_MISS_CHAR),

Line 313: NVL(date_recognized, FND_API.G_MISS_DATE),

309: NVL(birth_or_selected, FND_API.G_MISS_CHAR),
310: NVL(party_id, FND_API.G_MISS_NUM),
311: NVL(country_code, FND_API.G_MISS_CHAR),
312: NVL(date_disowned, FND_API.G_MISS_DATE),
313: NVL(date_recognized, FND_API.G_MISS_DATE),
314: NVL(document_reference, FND_API.G_MISS_CHAR),
315: NVL(end_date, FND_API.G_MISS_DATE),
316: NVL(document_type, FND_API.G_MISS_CHAR),
317: NVL(status, FND_API.G_MISS_CHAR),

Line 314: NVL(document_reference, FND_API.G_MISS_CHAR),

310: NVL(party_id, FND_API.G_MISS_NUM),
311: NVL(country_code, FND_API.G_MISS_CHAR),
312: NVL(date_disowned, FND_API.G_MISS_DATE),
313: NVL(date_recognized, FND_API.G_MISS_DATE),
314: NVL(document_reference, FND_API.G_MISS_CHAR),
315: NVL(end_date, FND_API.G_MISS_DATE),
316: NVL(document_type, FND_API.G_MISS_CHAR),
317: NVL(status, FND_API.G_MISS_CHAR),
318: NVL(application_id, FND_API.G_MISS_NUM),

Line 315: NVL(end_date, FND_API.G_MISS_DATE),

311: NVL(country_code, FND_API.G_MISS_CHAR),
312: NVL(date_disowned, FND_API.G_MISS_DATE),
313: NVL(date_recognized, FND_API.G_MISS_DATE),
314: NVL(document_reference, FND_API.G_MISS_CHAR),
315: NVL(end_date, FND_API.G_MISS_DATE),
316: NVL(document_type, FND_API.G_MISS_CHAR),
317: NVL(status, FND_API.G_MISS_CHAR),
318: NVL(application_id, FND_API.G_MISS_NUM),
319: NVL(created_by_module, FND_API.G_MISS_CHAR)

Line 316: NVL(document_type, FND_API.G_MISS_CHAR),

312: NVL(date_disowned, FND_API.G_MISS_DATE),
313: NVL(date_recognized, FND_API.G_MISS_DATE),
314: NVL(document_reference, FND_API.G_MISS_CHAR),
315: NVL(end_date, FND_API.G_MISS_DATE),
316: NVL(document_type, FND_API.G_MISS_CHAR),
317: NVL(status, FND_API.G_MISS_CHAR),
318: NVL(application_id, FND_API.G_MISS_NUM),
319: NVL(created_by_module, FND_API.G_MISS_CHAR)
320: INTO

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

313: NVL(date_recognized, FND_API.G_MISS_DATE),
314: NVL(document_reference, FND_API.G_MISS_CHAR),
315: NVL(end_date, FND_API.G_MISS_DATE),
316: NVL(document_type, FND_API.G_MISS_CHAR),
317: NVL(status, FND_API.G_MISS_CHAR),
318: NVL(application_id, FND_API.G_MISS_NUM),
319: NVL(created_by_module, FND_API.G_MISS_CHAR)
320: INTO
321: x_citizenship_id,

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

314: NVL(document_reference, FND_API.G_MISS_CHAR),
315: NVL(end_date, FND_API.G_MISS_DATE),
316: NVL(document_type, FND_API.G_MISS_CHAR),
317: NVL(status, FND_API.G_MISS_CHAR),
318: NVL(application_id, FND_API.G_MISS_NUM),
319: NVL(created_by_module, FND_API.G_MISS_CHAR)
320: INTO
321: x_citizenship_id,
322: x_birth_or_selected,

Line 319: NVL(created_by_module, FND_API.G_MISS_CHAR)

315: NVL(end_date, FND_API.G_MISS_DATE),
316: NVL(document_type, FND_API.G_MISS_CHAR),
317: NVL(status, FND_API.G_MISS_CHAR),
318: NVL(application_id, FND_API.G_MISS_NUM),
319: NVL(created_by_module, FND_API.G_MISS_CHAR)
320: INTO
321: x_citizenship_id,
322: x_birth_or_selected,
323: x_party_id,

Line 342: RAISE FND_API.G_EXC_ERROR;

338: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
339: FND_MESSAGE.SET_TOKEN('RECORD', 'citizenship_rec');
340: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(x_citizenship_id));
341: FND_MSG_PUB.ADD;
342: RAISE FND_API.G_EXC_ERROR;
343:
344: END Select_Row;
345:
346: END HZ_CITIZENSHIP_PKG;