APPS.HZ_ORG_CONTACT_ROLES_PKG dependencies on FND_API

Line 47: DECODE( X_ORG_CONTACT_ROLE_ID, FND_API.G_MISS_NUM, HZ_ORG_CONTACT_ROLES_S.NEXTVAL, NULL, HZ_ORG_CONTACT_ROLES_S.NEXTVAL, X_ORG_CONTACT_ROLE_ID ),

43: CREATED_BY_MODULE,
44: APPLICATION_ID
45: )
46: VALUES (
47: DECODE( X_ORG_CONTACT_ROLE_ID, FND_API.G_MISS_NUM, HZ_ORG_CONTACT_ROLES_S.NEXTVAL, NULL, HZ_ORG_CONTACT_ROLES_S.NEXTVAL, X_ORG_CONTACT_ROLE_ID ),
48: DECODE( X_ORG_CONTACT_ID, FND_API.G_MISS_NUM, NULL, X_ORG_CONTACT_ID ),
49: DECODE( X_ROLE_TYPE, FND_API.G_MISS_CHAR, NULL, X_ROLE_TYPE ),
50: HZ_UTILITY_V2PUB.CREATED_BY,
51: DECODE( X_ROLE_LEVEL, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_ROLE_LEVEL ),

Line 48: DECODE( X_ORG_CONTACT_ID, FND_API.G_MISS_NUM, NULL, X_ORG_CONTACT_ID ),

44: APPLICATION_ID
45: )
46: VALUES (
47: DECODE( X_ORG_CONTACT_ROLE_ID, FND_API.G_MISS_NUM, HZ_ORG_CONTACT_ROLES_S.NEXTVAL, NULL, HZ_ORG_CONTACT_ROLES_S.NEXTVAL, X_ORG_CONTACT_ROLE_ID ),
48: DECODE( X_ORG_CONTACT_ID, FND_API.G_MISS_NUM, NULL, X_ORG_CONTACT_ID ),
49: DECODE( X_ROLE_TYPE, FND_API.G_MISS_CHAR, NULL, X_ROLE_TYPE ),
50: HZ_UTILITY_V2PUB.CREATED_BY,
51: DECODE( X_ROLE_LEVEL, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_ROLE_LEVEL ),
52: DECODE( X_PRIMARY_FLAG, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_PRIMARY_FLAG ),

Line 49: DECODE( X_ROLE_TYPE, FND_API.G_MISS_CHAR, NULL, X_ROLE_TYPE ),

45: )
46: VALUES (
47: DECODE( X_ORG_CONTACT_ROLE_ID, FND_API.G_MISS_NUM, HZ_ORG_CONTACT_ROLES_S.NEXTVAL, NULL, HZ_ORG_CONTACT_ROLES_S.NEXTVAL, X_ORG_CONTACT_ROLE_ID ),
48: DECODE( X_ORG_CONTACT_ID, FND_API.G_MISS_NUM, NULL, X_ORG_CONTACT_ID ),
49: DECODE( X_ROLE_TYPE, FND_API.G_MISS_CHAR, NULL, X_ROLE_TYPE ),
50: HZ_UTILITY_V2PUB.CREATED_BY,
51: DECODE( X_ROLE_LEVEL, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_ROLE_LEVEL ),
52: DECODE( X_PRIMARY_FLAG, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_PRIMARY_FLAG ),
53: HZ_UTILITY_V2PUB.CREATION_DATE,

Line 51: DECODE( X_ROLE_LEVEL, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_ROLE_LEVEL ),

47: DECODE( X_ORG_CONTACT_ROLE_ID, FND_API.G_MISS_NUM, HZ_ORG_CONTACT_ROLES_S.NEXTVAL, NULL, HZ_ORG_CONTACT_ROLES_S.NEXTVAL, X_ORG_CONTACT_ROLE_ID ),
48: DECODE( X_ORG_CONTACT_ID, FND_API.G_MISS_NUM, NULL, X_ORG_CONTACT_ID ),
49: DECODE( X_ROLE_TYPE, FND_API.G_MISS_CHAR, NULL, X_ROLE_TYPE ),
50: HZ_UTILITY_V2PUB.CREATED_BY,
51: DECODE( X_ROLE_LEVEL, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_ROLE_LEVEL ),
52: DECODE( X_PRIMARY_FLAG, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_PRIMARY_FLAG ),
53: HZ_UTILITY_V2PUB.CREATION_DATE,
54: DECODE( X_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(NVL(X_ORG_CONTACT_ROLE_ID,HZ_ORG_CONTACT_ROLES_S.CURRVAL)), NULL, TO_CHAR(NVL(X_ORG_CONTACT_ROLE_ID,HZ_ORG_CONTACT_ROLES_S.CURRVAL)), X_ORIG_SYSTEM_REFERENCE ),
55: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

Line 52: DECODE( X_PRIMARY_FLAG, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_PRIMARY_FLAG ),

48: DECODE( X_ORG_CONTACT_ID, FND_API.G_MISS_NUM, NULL, X_ORG_CONTACT_ID ),
49: DECODE( X_ROLE_TYPE, FND_API.G_MISS_CHAR, NULL, X_ROLE_TYPE ),
50: HZ_UTILITY_V2PUB.CREATED_BY,
51: DECODE( X_ROLE_LEVEL, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_ROLE_LEVEL ),
52: DECODE( X_PRIMARY_FLAG, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_PRIMARY_FLAG ),
53: HZ_UTILITY_V2PUB.CREATION_DATE,
54: DECODE( X_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(NVL(X_ORG_CONTACT_ROLE_ID,HZ_ORG_CONTACT_ROLES_S.CURRVAL)), NULL, TO_CHAR(NVL(X_ORG_CONTACT_ROLE_ID,HZ_ORG_CONTACT_ROLES_S.CURRVAL)), X_ORIG_SYSTEM_REFERENCE ),
55: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
56: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

Line 54: DECODE( X_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(NVL(X_ORG_CONTACT_ROLE_ID,HZ_ORG_CONTACT_ROLES_S.CURRVAL)), NULL, TO_CHAR(NVL(X_ORG_CONTACT_ROLE_ID,HZ_ORG_CONTACT_ROLES_S.CURRVAL)), X_ORIG_SYSTEM_REFERENCE ),

50: HZ_UTILITY_V2PUB.CREATED_BY,
51: DECODE( X_ROLE_LEVEL, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_ROLE_LEVEL ),
52: DECODE( X_PRIMARY_FLAG, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_PRIMARY_FLAG ),
53: HZ_UTILITY_V2PUB.CREATION_DATE,
54: DECODE( X_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(NVL(X_ORG_CONTACT_ROLE_ID,HZ_ORG_CONTACT_ROLES_S.CURRVAL)), NULL, TO_CHAR(NVL(X_ORG_CONTACT_ROLE_ID,HZ_ORG_CONTACT_ROLES_S.CURRVAL)), X_ORIG_SYSTEM_REFERENCE ),
55: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
56: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
57: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
58: HZ_UTILITY_V2PUB.REQUEST_ID,

Line 62: DECODE( X_PRIMARY_CON_PER_ROLE_TYPE, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_PRIMARY_CON_PER_ROLE_TYPE ),

58: HZ_UTILITY_V2PUB.REQUEST_ID,
59: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
60: HZ_UTILITY_V2PUB.PROGRAM_ID,
61: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
62: DECODE( X_PRIMARY_CON_PER_ROLE_TYPE, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_PRIMARY_CON_PER_ROLE_TYPE ),
63: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
64: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
65: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
66: DECODE( X_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )

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

59: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
60: HZ_UTILITY_V2PUB.PROGRAM_ID,
61: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
62: DECODE( X_PRIMARY_CON_PER_ROLE_TYPE, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_PRIMARY_CON_PER_ROLE_TYPE ),
63: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
64: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
65: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
66: DECODE( X_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )
67: ) RETURNING

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

60: HZ_UTILITY_V2PUB.PROGRAM_ID,
61: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
62: DECODE( X_PRIMARY_CON_PER_ROLE_TYPE, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_PRIMARY_CON_PER_ROLE_TYPE ),
63: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
64: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
65: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
66: DECODE( X_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )
67: ) RETURNING
68: ORG_CONTACT_ROLE_ID

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

61: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
62: DECODE( X_PRIMARY_CON_PER_ROLE_TYPE, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_PRIMARY_CON_PER_ROLE_TYPE ),
63: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
64: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
65: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
66: DECODE( X_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )
67: ) RETURNING
68: ORG_CONTACT_ROLE_ID
69: INTO

Line 66: DECODE( X_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )

62: DECODE( X_PRIMARY_CON_PER_ROLE_TYPE, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_PRIMARY_CON_PER_ROLE_TYPE ),
63: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
64: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
65: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
66: DECODE( X_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )
67: ) RETURNING
68: ORG_CONTACT_ROLE_ID
69: INTO
70: X_ORG_CONTACT_ROLE_ID;

Line 125: ORG_CONTACT_ROLE_ID = DECODE( X_ORG_CONTACT_ROLE_ID, NULL, ORG_CONTACT_ROLE_ID, FND_API.G_MISS_NUM, NULL, X_ORG_CONTACT_ROLE_ID ),

121:
122: BEGIN
123:
124: UPDATE HZ_ORG_CONTACT_ROLES SET
125: ORG_CONTACT_ROLE_ID = DECODE( X_ORG_CONTACT_ROLE_ID, NULL, ORG_CONTACT_ROLE_ID, FND_API.G_MISS_NUM, NULL, X_ORG_CONTACT_ROLE_ID ),
126: ORG_CONTACT_ID = DECODE( X_ORG_CONTACT_ID, NULL, ORG_CONTACT_ID, FND_API.G_MISS_NUM, NULL, X_ORG_CONTACT_ID ),
127: ROLE_TYPE = DECODE( X_ROLE_TYPE, NULL, ROLE_TYPE, FND_API.G_MISS_CHAR, NULL, X_ROLE_TYPE ),
128: CREATED_BY = CREATED_BY,
129: ROLE_LEVEL = DECODE( X_ROLE_LEVEL, NULL, ROLE_LEVEL, FND_API.G_MISS_CHAR, 'N', X_ROLE_LEVEL ),

Line 126: ORG_CONTACT_ID = DECODE( X_ORG_CONTACT_ID, NULL, ORG_CONTACT_ID, FND_API.G_MISS_NUM, NULL, X_ORG_CONTACT_ID ),

122: BEGIN
123:
124: UPDATE HZ_ORG_CONTACT_ROLES SET
125: ORG_CONTACT_ROLE_ID = DECODE( X_ORG_CONTACT_ROLE_ID, NULL, ORG_CONTACT_ROLE_ID, FND_API.G_MISS_NUM, NULL, X_ORG_CONTACT_ROLE_ID ),
126: ORG_CONTACT_ID = DECODE( X_ORG_CONTACT_ID, NULL, ORG_CONTACT_ID, FND_API.G_MISS_NUM, NULL, X_ORG_CONTACT_ID ),
127: ROLE_TYPE = DECODE( X_ROLE_TYPE, NULL, ROLE_TYPE, FND_API.G_MISS_CHAR, NULL, X_ROLE_TYPE ),
128: CREATED_BY = CREATED_BY,
129: ROLE_LEVEL = DECODE( X_ROLE_LEVEL, NULL, ROLE_LEVEL, FND_API.G_MISS_CHAR, 'N', X_ROLE_LEVEL ),
130: PRIMARY_FLAG = DECODE( X_PRIMARY_FLAG, NULL, PRIMARY_FLAG, FND_API.G_MISS_CHAR, 'N', X_PRIMARY_FLAG ),

Line 127: ROLE_TYPE = DECODE( X_ROLE_TYPE, NULL, ROLE_TYPE, FND_API.G_MISS_CHAR, NULL, X_ROLE_TYPE ),

123:
124: UPDATE HZ_ORG_CONTACT_ROLES SET
125: ORG_CONTACT_ROLE_ID = DECODE( X_ORG_CONTACT_ROLE_ID, NULL, ORG_CONTACT_ROLE_ID, FND_API.G_MISS_NUM, NULL, X_ORG_CONTACT_ROLE_ID ),
126: ORG_CONTACT_ID = DECODE( X_ORG_CONTACT_ID, NULL, ORG_CONTACT_ID, FND_API.G_MISS_NUM, NULL, X_ORG_CONTACT_ID ),
127: ROLE_TYPE = DECODE( X_ROLE_TYPE, NULL, ROLE_TYPE, FND_API.G_MISS_CHAR, NULL, X_ROLE_TYPE ),
128: CREATED_BY = CREATED_BY,
129: ROLE_LEVEL = DECODE( X_ROLE_LEVEL, NULL, ROLE_LEVEL, FND_API.G_MISS_CHAR, 'N', X_ROLE_LEVEL ),
130: PRIMARY_FLAG = DECODE( X_PRIMARY_FLAG, NULL, PRIMARY_FLAG, FND_API.G_MISS_CHAR, 'N', X_PRIMARY_FLAG ),
131: CREATION_DATE = CREATION_DATE,

Line 129: ROLE_LEVEL = DECODE( X_ROLE_LEVEL, NULL, ROLE_LEVEL, FND_API.G_MISS_CHAR, 'N', X_ROLE_LEVEL ),

125: ORG_CONTACT_ROLE_ID = DECODE( X_ORG_CONTACT_ROLE_ID, NULL, ORG_CONTACT_ROLE_ID, FND_API.G_MISS_NUM, NULL, X_ORG_CONTACT_ROLE_ID ),
126: ORG_CONTACT_ID = DECODE( X_ORG_CONTACT_ID, NULL, ORG_CONTACT_ID, FND_API.G_MISS_NUM, NULL, X_ORG_CONTACT_ID ),
127: ROLE_TYPE = DECODE( X_ROLE_TYPE, NULL, ROLE_TYPE, FND_API.G_MISS_CHAR, NULL, X_ROLE_TYPE ),
128: CREATED_BY = CREATED_BY,
129: ROLE_LEVEL = DECODE( X_ROLE_LEVEL, NULL, ROLE_LEVEL, FND_API.G_MISS_CHAR, 'N', X_ROLE_LEVEL ),
130: PRIMARY_FLAG = DECODE( X_PRIMARY_FLAG, NULL, PRIMARY_FLAG, FND_API.G_MISS_CHAR, 'N', X_PRIMARY_FLAG ),
131: CREATION_DATE = CREATION_DATE,
132: ORIG_SYSTEM_REFERENCE = DECODE( X_ORIG_SYSTEM_REFERENCE, NULL, ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, ORIG_SYSTEM_REFERENCE, X_ORIG_SYSTEM_REFERENCE ),
133: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

Line 130: PRIMARY_FLAG = DECODE( X_PRIMARY_FLAG, NULL, PRIMARY_FLAG, FND_API.G_MISS_CHAR, 'N', X_PRIMARY_FLAG ),

126: ORG_CONTACT_ID = DECODE( X_ORG_CONTACT_ID, NULL, ORG_CONTACT_ID, FND_API.G_MISS_NUM, NULL, X_ORG_CONTACT_ID ),
127: ROLE_TYPE = DECODE( X_ROLE_TYPE, NULL, ROLE_TYPE, FND_API.G_MISS_CHAR, NULL, X_ROLE_TYPE ),
128: CREATED_BY = CREATED_BY,
129: ROLE_LEVEL = DECODE( X_ROLE_LEVEL, NULL, ROLE_LEVEL, FND_API.G_MISS_CHAR, 'N', X_ROLE_LEVEL ),
130: PRIMARY_FLAG = DECODE( X_PRIMARY_FLAG, NULL, PRIMARY_FLAG, FND_API.G_MISS_CHAR, 'N', X_PRIMARY_FLAG ),
131: CREATION_DATE = CREATION_DATE,
132: ORIG_SYSTEM_REFERENCE = DECODE( X_ORIG_SYSTEM_REFERENCE, NULL, ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, ORIG_SYSTEM_REFERENCE, X_ORIG_SYSTEM_REFERENCE ),
133: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
134: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

Line 132: ORIG_SYSTEM_REFERENCE = DECODE( X_ORIG_SYSTEM_REFERENCE, NULL, ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, ORIG_SYSTEM_REFERENCE, X_ORIG_SYSTEM_REFERENCE ),

128: CREATED_BY = CREATED_BY,
129: ROLE_LEVEL = DECODE( X_ROLE_LEVEL, NULL, ROLE_LEVEL, FND_API.G_MISS_CHAR, 'N', X_ROLE_LEVEL ),
130: PRIMARY_FLAG = DECODE( X_PRIMARY_FLAG, NULL, PRIMARY_FLAG, FND_API.G_MISS_CHAR, 'N', X_PRIMARY_FLAG ),
131: CREATION_DATE = CREATION_DATE,
132: ORIG_SYSTEM_REFERENCE = DECODE( X_ORIG_SYSTEM_REFERENCE, NULL, ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, ORIG_SYSTEM_REFERENCE, X_ORIG_SYSTEM_REFERENCE ),
133: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
134: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
135: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
136: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,

Line 140: PRIMARY_CONTACT_PER_ROLE_TYPE = DECODE( X_PRIMARY_CON_PER_ROLE_TYPE, NULL, PRIMARY_CONTACT_PER_ROLE_TYPE, FND_API.G_MISS_CHAR, 'N', X_PRIMARY_CON_PER_ROLE_TYPE ),

136: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
137: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
138: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
139: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
140: PRIMARY_CONTACT_PER_ROLE_TYPE = DECODE( X_PRIMARY_CON_PER_ROLE_TYPE, NULL, PRIMARY_CONTACT_PER_ROLE_TYPE, FND_API.G_MISS_CHAR, 'N', X_PRIMARY_CON_PER_ROLE_TYPE ),
141: STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, 'A', X_STATUS ),
142: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
143: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
144: APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )

Line 141: STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, 'A', X_STATUS ),

137: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
138: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
139: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
140: PRIMARY_CONTACT_PER_ROLE_TYPE = DECODE( X_PRIMARY_CON_PER_ROLE_TYPE, NULL, PRIMARY_CONTACT_PER_ROLE_TYPE, FND_API.G_MISS_CHAR, 'N', X_PRIMARY_CON_PER_ROLE_TYPE ),
141: STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, 'A', X_STATUS ),
142: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
143: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
144: APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )
145: WHERE ROWID = X_RowId;

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

138: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
139: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
140: PRIMARY_CONTACT_PER_ROLE_TYPE = DECODE( X_PRIMARY_CON_PER_ROLE_TYPE, NULL, PRIMARY_CONTACT_PER_ROLE_TYPE, FND_API.G_MISS_CHAR, 'N', X_PRIMARY_CON_PER_ROLE_TYPE ),
141: STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, 'A', X_STATUS ),
142: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
143: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
144: APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )
145: WHERE ROWID = X_RowId;
146:

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

139: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
140: PRIMARY_CONTACT_PER_ROLE_TYPE = DECODE( X_PRIMARY_CON_PER_ROLE_TYPE, NULL, PRIMARY_CONTACT_PER_ROLE_TYPE, FND_API.G_MISS_CHAR, 'N', X_PRIMARY_CON_PER_ROLE_TYPE ),
141: STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, 'A', X_STATUS ),
142: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
143: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
144: APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )
145: WHERE ROWID = X_RowId;
146:
147: IF ( SQL%NOTFOUND ) THEN

Line 144: APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )

140: PRIMARY_CONTACT_PER_ROLE_TYPE = DECODE( X_PRIMARY_CON_PER_ROLE_TYPE, NULL, PRIMARY_CONTACT_PER_ROLE_TYPE, FND_API.G_MISS_CHAR, 'N', X_PRIMARY_CON_PER_ROLE_TYPE ),
141: STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, 'A', X_STATUS ),
142: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
143: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
144: APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )
145: WHERE ROWID = X_RowId;
146:
147: IF ( SQL%NOTFOUND ) THEN
148: RAISE NO_DATA_FOUND;

Line 280: NVL( ORG_CONTACT_ROLE_ID, FND_API.G_MISS_NUM ),

276:
277: BEGIN
278:
279: SELECT
280: NVL( ORG_CONTACT_ROLE_ID, FND_API.G_MISS_NUM ),
281: NVL( ORG_CONTACT_ID, FND_API.G_MISS_NUM ),
282: NVL( ROLE_TYPE, FND_API.G_MISS_CHAR ),
283: NVL( ROLE_LEVEL, FND_API.G_MISS_CHAR ),
284: NVL( PRIMARY_FLAG, FND_API.G_MISS_CHAR ),

Line 281: NVL( ORG_CONTACT_ID, FND_API.G_MISS_NUM ),

277: BEGIN
278:
279: SELECT
280: NVL( ORG_CONTACT_ROLE_ID, FND_API.G_MISS_NUM ),
281: NVL( ORG_CONTACT_ID, FND_API.G_MISS_NUM ),
282: NVL( ROLE_TYPE, FND_API.G_MISS_CHAR ),
283: NVL( ROLE_LEVEL, FND_API.G_MISS_CHAR ),
284: NVL( PRIMARY_FLAG, FND_API.G_MISS_CHAR ),
285: NVL( ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR ),

Line 282: NVL( ROLE_TYPE, FND_API.G_MISS_CHAR ),

278:
279: SELECT
280: NVL( ORG_CONTACT_ROLE_ID, FND_API.G_MISS_NUM ),
281: NVL( ORG_CONTACT_ID, FND_API.G_MISS_NUM ),
282: NVL( ROLE_TYPE, FND_API.G_MISS_CHAR ),
283: NVL( ROLE_LEVEL, FND_API.G_MISS_CHAR ),
284: NVL( PRIMARY_FLAG, FND_API.G_MISS_CHAR ),
285: NVL( ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR ),
286: NVL( PRIMARY_CONTACT_PER_ROLE_TYPE, FND_API.G_MISS_CHAR ),

Line 283: NVL( ROLE_LEVEL, FND_API.G_MISS_CHAR ),

279: SELECT
280: NVL( ORG_CONTACT_ROLE_ID, FND_API.G_MISS_NUM ),
281: NVL( ORG_CONTACT_ID, FND_API.G_MISS_NUM ),
282: NVL( ROLE_TYPE, FND_API.G_MISS_CHAR ),
283: NVL( ROLE_LEVEL, FND_API.G_MISS_CHAR ),
284: NVL( PRIMARY_FLAG, FND_API.G_MISS_CHAR ),
285: NVL( ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR ),
286: NVL( PRIMARY_CONTACT_PER_ROLE_TYPE, FND_API.G_MISS_CHAR ),
287: NVL( STATUS, FND_API.G_MISS_CHAR ),

Line 284: NVL( PRIMARY_FLAG, FND_API.G_MISS_CHAR ),

280: NVL( ORG_CONTACT_ROLE_ID, FND_API.G_MISS_NUM ),
281: NVL( ORG_CONTACT_ID, FND_API.G_MISS_NUM ),
282: NVL( ROLE_TYPE, FND_API.G_MISS_CHAR ),
283: NVL( ROLE_LEVEL, FND_API.G_MISS_CHAR ),
284: NVL( PRIMARY_FLAG, FND_API.G_MISS_CHAR ),
285: NVL( ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR ),
286: NVL( PRIMARY_CONTACT_PER_ROLE_TYPE, FND_API.G_MISS_CHAR ),
287: NVL( STATUS, FND_API.G_MISS_CHAR ),
288: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),

Line 285: NVL( ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR ),

281: NVL( ORG_CONTACT_ID, FND_API.G_MISS_NUM ),
282: NVL( ROLE_TYPE, FND_API.G_MISS_CHAR ),
283: NVL( ROLE_LEVEL, FND_API.G_MISS_CHAR ),
284: NVL( PRIMARY_FLAG, FND_API.G_MISS_CHAR ),
285: NVL( ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR ),
286: NVL( PRIMARY_CONTACT_PER_ROLE_TYPE, FND_API.G_MISS_CHAR ),
287: NVL( STATUS, FND_API.G_MISS_CHAR ),
288: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
289: NVL( APPLICATION_ID, FND_API.G_MISS_NUM )

Line 286: NVL( PRIMARY_CONTACT_PER_ROLE_TYPE, FND_API.G_MISS_CHAR ),

282: NVL( ROLE_TYPE, FND_API.G_MISS_CHAR ),
283: NVL( ROLE_LEVEL, FND_API.G_MISS_CHAR ),
284: NVL( PRIMARY_FLAG, FND_API.G_MISS_CHAR ),
285: NVL( ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR ),
286: NVL( PRIMARY_CONTACT_PER_ROLE_TYPE, FND_API.G_MISS_CHAR ),
287: NVL( STATUS, FND_API.G_MISS_CHAR ),
288: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
289: NVL( APPLICATION_ID, FND_API.G_MISS_NUM )
290: INTO

Line 287: NVL( STATUS, FND_API.G_MISS_CHAR ),

283: NVL( ROLE_LEVEL, FND_API.G_MISS_CHAR ),
284: NVL( PRIMARY_FLAG, FND_API.G_MISS_CHAR ),
285: NVL( ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR ),
286: NVL( PRIMARY_CONTACT_PER_ROLE_TYPE, FND_API.G_MISS_CHAR ),
287: NVL( STATUS, FND_API.G_MISS_CHAR ),
288: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
289: NVL( APPLICATION_ID, FND_API.G_MISS_NUM )
290: INTO
291: X_ORG_CONTACT_ROLE_ID,

Line 288: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),

284: NVL( PRIMARY_FLAG, FND_API.G_MISS_CHAR ),
285: NVL( ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR ),
286: NVL( PRIMARY_CONTACT_PER_ROLE_TYPE, FND_API.G_MISS_CHAR ),
287: NVL( STATUS, FND_API.G_MISS_CHAR ),
288: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
289: NVL( APPLICATION_ID, FND_API.G_MISS_NUM )
290: INTO
291: X_ORG_CONTACT_ROLE_ID,
292: X_ORG_CONTACT_ID,

Line 289: NVL( APPLICATION_ID, FND_API.G_MISS_NUM )

285: NVL( ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR ),
286: NVL( PRIMARY_CONTACT_PER_ROLE_TYPE, FND_API.G_MISS_CHAR ),
287: NVL( STATUS, FND_API.G_MISS_CHAR ),
288: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
289: NVL( APPLICATION_ID, FND_API.G_MISS_NUM )
290: INTO
291: X_ORG_CONTACT_ROLE_ID,
292: X_ORG_CONTACT_ID,
293: X_ROLE_TYPE,

Line 310: RAISE FND_API.G_EXC_ERROR;

306: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
307: FND_MESSAGE.SET_TOKEN( 'RECORD', 'org_contact_role_rec');
308: FND_MESSAGE.SET_TOKEN( 'VALUE', TO_CHAR( X_ORG_CONTACT_ROLE_ID ) );
309: FND_MSG_PUB.ADD;
310: RAISE FND_API.G_EXC_ERROR;
311:
312: END Select_Row;
313:
314: PROCEDURE Delete_Row (