The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE Insert_Row (
X_RELATIONSHIP_ID IN OUT NOCOPY NUMBER,
X_SUBJECT_ID IN NUMBER,
X_SUBJECT_TYPE IN VARCHAR2,
X_SUBJECT_TABLE_NAME IN VARCHAR2,
X_OBJECT_ID IN NUMBER,
X_OBJECT_TYPE IN VARCHAR2,
X_OBJECT_TABLE_NAME IN VARCHAR2,
X_PARTY_ID IN NUMBER,
X_RELATIONSHIP_CODE IN VARCHAR2,
X_DIRECTIONAL_FLAG IN VARCHAR2,
X_COMMENTS IN VARCHAR2,
X_START_DATE IN DATE,
X_END_DATE IN DATE,
X_STATUS IN VARCHAR2,
X_ATTRIBUTE_CATEGORY IN VARCHAR2,
X_ATTRIBUTE1 IN VARCHAR2,
X_ATTRIBUTE2 IN VARCHAR2,
X_ATTRIBUTE3 IN VARCHAR2,
X_ATTRIBUTE4 IN VARCHAR2,
X_ATTRIBUTE5 IN VARCHAR2,
X_ATTRIBUTE6 IN VARCHAR2,
X_ATTRIBUTE7 IN VARCHAR2,
X_ATTRIBUTE8 IN VARCHAR2,
X_ATTRIBUTE9 IN VARCHAR2,
X_ATTRIBUTE10 IN VARCHAR2,
X_ATTRIBUTE11 IN VARCHAR2,
X_ATTRIBUTE12 IN VARCHAR2,
X_ATTRIBUTE13 IN VARCHAR2,
X_ATTRIBUTE14 IN VARCHAR2,
X_ATTRIBUTE15 IN VARCHAR2,
X_ATTRIBUTE16 IN VARCHAR2,
X_ATTRIBUTE17 IN VARCHAR2,
X_ATTRIBUTE18 IN VARCHAR2,
X_ATTRIBUTE19 IN VARCHAR2,
X_ATTRIBUTE20 IN VARCHAR2,
X_CONTENT_SOURCE_TYPE IN VARCHAR2,
X_RELATIONSHIP_TYPE IN VARCHAR2,
X_OBJECT_VERSION_NUMBER IN NUMBER,
X_CREATED_BY_MODULE IN VARCHAR2,
X_APPLICATION_ID IN NUMBER,
X_ADDITIONAL_INFORMATION1 IN VARCHAR2,
X_ADDITIONAL_INFORMATION2 IN VARCHAR2,
X_ADDITIONAL_INFORMATION3 IN VARCHAR2,
X_ADDITIONAL_INFORMATION4 IN VARCHAR2,
X_ADDITIONAL_INFORMATION5 IN VARCHAR2,
X_ADDITIONAL_INFORMATION6 IN VARCHAR2,
X_ADDITIONAL_INFORMATION7 IN VARCHAR2,
X_ADDITIONAL_INFORMATION8 IN VARCHAR2,
X_ADDITIONAL_INFORMATION9 IN VARCHAR2,
X_ADDITIONAL_INFORMATION10 IN VARCHAR2,
X_ADDITIONAL_INFORMATION11 IN VARCHAR2,
X_ADDITIONAL_INFORMATION12 IN VARCHAR2,
X_ADDITIONAL_INFORMATION13 IN VARCHAR2,
X_ADDITIONAL_INFORMATION14 IN VARCHAR2,
X_ADDITIONAL_INFORMATION15 IN VARCHAR2,
X_ADDITIONAL_INFORMATION16 IN VARCHAR2,
X_ADDITIONAL_INFORMATION17 IN VARCHAR2,
X_ADDITIONAL_INFORMATION18 IN VARCHAR2,
X_ADDITIONAL_INFORMATION19 IN VARCHAR2,
X_ADDITIONAL_INFORMATION20 IN VARCHAR2,
X_ADDITIONAL_INFORMATION21 IN VARCHAR2,
X_ADDITIONAL_INFORMATION22 IN VARCHAR2,
X_ADDITIONAL_INFORMATION23 IN VARCHAR2,
X_ADDITIONAL_INFORMATION24 IN VARCHAR2,
X_ADDITIONAL_INFORMATION25 IN VARCHAR2,
X_ADDITIONAL_INFORMATION26 IN VARCHAR2,
X_ADDITIONAL_INFORMATION27 IN VARCHAR2,
X_ADDITIONAL_INFORMATION28 IN VARCHAR2,
X_ADDITIONAL_INFORMATION29 IN VARCHAR2,
X_ADDITIONAL_INFORMATION30 IN VARCHAR2,
X_DIRECTION_CODE IN VARCHAR2,
X_PERCENTAGE_OWNERSHIP IN NUMBER,
X_ACTUAL_CONTENT_SOURCE IN VARCHAR2
) IS
BEGIN
INSERT INTO HZ_RELATIONSHIPS (
RELATIONSHIP_ID,
SUBJECT_ID,
SUBJECT_TYPE,
SUBJECT_TABLE_NAME,
OBJECT_ID,
OBJECT_TYPE,
OBJECT_TABLE_NAME,
PARTY_ID,
RELATIONSHIP_CODE,
DIRECTIONAL_FLAG,
COMMENTS,
START_DATE,
END_DATE,
STATUS,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN,
REQUEST_ID,
PROGRAM_APPLICATION_ID,
PROGRAM_ID,
PROGRAM_UPDATE_DATE,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
ATTRIBUTE16,
ATTRIBUTE17,
ATTRIBUTE18,
ATTRIBUTE19,
ATTRIBUTE20,
CONTENT_SOURCE_TYPE,
RELATIONSHIP_TYPE,
OBJECT_VERSION_NUMBER,
CREATED_BY_MODULE,
APPLICATION_ID,
ADDITIONAL_INFORMATION1,
ADDITIONAL_INFORMATION2,
ADDITIONAL_INFORMATION3,
ADDITIONAL_INFORMATION4,
ADDITIONAL_INFORMATION5,
ADDITIONAL_INFORMATION6,
ADDITIONAL_INFORMATION7,
ADDITIONAL_INFORMATION8,
ADDITIONAL_INFORMATION9,
ADDITIONAL_INFORMATION10,
ADDITIONAL_INFORMATION11,
ADDITIONAL_INFORMATION12,
ADDITIONAL_INFORMATION13,
ADDITIONAL_INFORMATION14,
ADDITIONAL_INFORMATION15,
ADDITIONAL_INFORMATION16,
ADDITIONAL_INFORMATION17,
ADDITIONAL_INFORMATION18,
ADDITIONAL_INFORMATION19,
ADDITIONAL_INFORMATION20,
ADDITIONAL_INFORMATION21,
ADDITIONAL_INFORMATION22,
ADDITIONAL_INFORMATION23,
ADDITIONAL_INFORMATION24,
ADDITIONAL_INFORMATION25,
ADDITIONAL_INFORMATION26,
ADDITIONAL_INFORMATION27,
ADDITIONAL_INFORMATION28,
ADDITIONAL_INFORMATION29,
ADDITIONAL_INFORMATION30,
DIRECTION_CODE,
PERCENTAGE_OWNERSHIP,
ACTUAL_CONTENT_SOURCE
)
VALUES (
DECODE( X_RELATIONSHIP_ID, FND_API.G_MISS_NUM, NULL, X_RELATIONSHIP_ID ),
DECODE( X_SUBJECT_ID, FND_API.G_MISS_NUM, NULL, X_SUBJECT_ID ),
DECODE( X_SUBJECT_TYPE, FND_API.G_MISS_CHAR, NULL, X_SUBJECT_TYPE ),
DECODE( X_SUBJECT_TABLE_NAME, FND_API.G_MISS_CHAR, NULL, X_SUBJECT_TABLE_NAME ),
DECODE( X_OBJECT_ID, FND_API.G_MISS_NUM, NULL, X_OBJECT_ID ),
DECODE( X_OBJECT_TYPE, FND_API.G_MISS_CHAR, NULL, X_OBJECT_TYPE ),
DECODE( X_OBJECT_TABLE_NAME, FND_API.G_MISS_CHAR, NULL, X_OBJECT_TABLE_NAME ),
DECODE( X_PARTY_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_ID ),
DECODE( X_RELATIONSHIP_CODE, FND_API.G_MISS_CHAR, NULL, X_RELATIONSHIP_CODE ),
DECODE( X_DIRECTIONAL_FLAG, FND_API.G_MISS_CHAR, NULL, X_DIRECTIONAL_FLAG ),
DECODE( X_COMMENTS, FND_API.G_MISS_CHAR, NULL, X_COMMENTS ),
DECODE( X_START_DATE, FND_API.G_MISS_DATE, SYSDATE, NULL,SYSDATE,X_START_DATE ),
DECODE( X_END_DATE, FND_API.G_MISS_DATE, TO_DATE('31/12/4712 00:00:01','DD/MM/YYYY HH24:MI:SS'), NULL, TO_DATE('31/12/4712 00:00:01','DD/MM/YYYY HH24:MI:SS'), X_END_DATE ),
DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
HZ_UTILITY_V2PUB.CREATED_BY,
HZ_UTILITY_V2PUB.CREATION_DATE,
HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
HZ_UTILITY_V2PUB.REQUEST_ID,
HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
HZ_UTILITY_V2PUB.PROGRAM_ID,
HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
DECODE( X_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
DECODE( X_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
DECODE( X_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
DECODE( X_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
DECODE( X_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
DECODE( X_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
DECODE( X_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
DECODE( X_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
DECODE( X_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
DECODE( X_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
DECODE( X_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
DECODE( X_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
DECODE( X_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
DECODE( X_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
DECODE( X_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
DECODE( X_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
DECODE( X_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
DECODE( X_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
DECODE( X_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
DECODE( X_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
DECODE( X_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
DECODE( X_CONTENT_SOURCE_TYPE, FND_API.G_MISS_CHAR, G_MISS_CONTENT_SOURCE_TYPE, NULL, G_MISS_CONTENT_SOURCE_TYPE, X_CONTENT_SOURCE_TYPE ),
DECODE( X_RELATIONSHIP_TYPE, FND_API.G_MISS_CHAR, NULL, X_RELATIONSHIP_TYPE ),
DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
DECODE( X_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),
DECODE( X_ADDITIONAL_INFORMATION1, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION1 ),
DECODE( X_ADDITIONAL_INFORMATION2, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION2 ),
DECODE( X_ADDITIONAL_INFORMATION3, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION3 ),
DECODE( X_ADDITIONAL_INFORMATION4, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION4 ),
DECODE( X_ADDITIONAL_INFORMATION5, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION5 ),
DECODE( X_ADDITIONAL_INFORMATION6, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION6 ),
DECODE( X_ADDITIONAL_INFORMATION7, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION7 ),
DECODE( X_ADDITIONAL_INFORMATION8, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION8 ),
DECODE( X_ADDITIONAL_INFORMATION9, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION9 ),
DECODE( X_ADDITIONAL_INFORMATION10, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION10 ),
DECODE( X_ADDITIONAL_INFORMATION11, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION11 ),
DECODE( X_ADDITIONAL_INFORMATION12, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION12 ),
DECODE( X_ADDITIONAL_INFORMATION13, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION13 ),
DECODE( X_ADDITIONAL_INFORMATION14, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION14 ),
DECODE( X_ADDITIONAL_INFORMATION15, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION15 ),
DECODE( X_ADDITIONAL_INFORMATION16, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION16 ),
DECODE( X_ADDITIONAL_INFORMATION17, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION17 ),
DECODE( X_ADDITIONAL_INFORMATION18, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION18 ),
DECODE( X_ADDITIONAL_INFORMATION19, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION19 ),
DECODE( X_ADDITIONAL_INFORMATION20, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION20 ),
DECODE( X_ADDITIONAL_INFORMATION21, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION21 ),
DECODE( X_ADDITIONAL_INFORMATION22, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION22 ),
DECODE( X_ADDITIONAL_INFORMATION23, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION23 ),
DECODE( X_ADDITIONAL_INFORMATION24, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION24 ),
DECODE( X_ADDITIONAL_INFORMATION25, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION25 ),
DECODE( X_ADDITIONAL_INFORMATION26, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION26 ),
DECODE( X_ADDITIONAL_INFORMATION27, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION27 ),
DECODE( X_ADDITIONAL_INFORMATION28, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION28 ),
DECODE( X_ADDITIONAL_INFORMATION29, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION29 ),
DECODE( X_ADDITIONAL_INFORMATION30, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION30 ),
DECODE( X_DIRECTION_CODE, FND_API.G_MISS_CHAR, NULL, X_DIRECTION_CODE ),
DECODE( X_PERCENTAGE_OWNERSHIP, FND_API.G_MISS_NUM, NULL, X_PERCENTAGE_OWNERSHIP ),
DECODE( X_ACTUAL_CONTENT_SOURCE,
FND_API.G_MISS_CHAR, G_MISS_CONTENT_SOURCE_TYPE,
NULL, G_MISS_CONTENT_SOURCE_TYPE, X_ACTUAL_CONTENT_SOURCE )
) RETURNING
RELATIONSHIP_ID
INTO
X_RELATIONSHIP_ID;
END Insert_Row;
PROCEDURE Update_Row (
X_Rowid IN OUT NOCOPY VARCHAR2,
X_RELATIONSHIP_ID IN NUMBER,
X_SUBJECT_ID IN NUMBER,
X_SUBJECT_TYPE IN VARCHAR2,
X_SUBJECT_TABLE_NAME IN VARCHAR2,
X_OBJECT_ID IN NUMBER,
X_OBJECT_TYPE IN VARCHAR2,
X_OBJECT_TABLE_NAME IN VARCHAR2,
X_PARTY_ID IN NUMBER,
X_RELATIONSHIP_CODE IN VARCHAR2,
X_DIRECTIONAL_FLAG IN VARCHAR2,
X_COMMENTS IN VARCHAR2,
X_START_DATE IN DATE,
X_END_DATE IN DATE,
X_STATUS IN VARCHAR2,
X_ATTRIBUTE_CATEGORY IN VARCHAR2,
X_ATTRIBUTE1 IN VARCHAR2,
X_ATTRIBUTE2 IN VARCHAR2,
X_ATTRIBUTE3 IN VARCHAR2,
X_ATTRIBUTE4 IN VARCHAR2,
X_ATTRIBUTE5 IN VARCHAR2,
X_ATTRIBUTE6 IN VARCHAR2,
X_ATTRIBUTE7 IN VARCHAR2,
X_ATTRIBUTE8 IN VARCHAR2,
X_ATTRIBUTE9 IN VARCHAR2,
X_ATTRIBUTE10 IN VARCHAR2,
X_ATTRIBUTE11 IN VARCHAR2,
X_ATTRIBUTE12 IN VARCHAR2,
X_ATTRIBUTE13 IN VARCHAR2,
X_ATTRIBUTE14 IN VARCHAR2,
X_ATTRIBUTE15 IN VARCHAR2,
X_ATTRIBUTE16 IN VARCHAR2,
X_ATTRIBUTE17 IN VARCHAR2,
X_ATTRIBUTE18 IN VARCHAR2,
X_ATTRIBUTE19 IN VARCHAR2,
X_ATTRIBUTE20 IN VARCHAR2,
X_CONTENT_SOURCE_TYPE IN VARCHAR2,
X_RELATIONSHIP_TYPE IN VARCHAR2,
X_OBJECT_VERSION_NUMBER IN NUMBER,
X_CREATED_BY_MODULE IN VARCHAR2,
X_APPLICATION_ID IN NUMBER,
X_ADDITIONAL_INFORMATION1 IN VARCHAR2,
X_ADDITIONAL_INFORMATION2 IN VARCHAR2,
X_ADDITIONAL_INFORMATION3 IN VARCHAR2,
X_ADDITIONAL_INFORMATION4 IN VARCHAR2,
X_ADDITIONAL_INFORMATION5 IN VARCHAR2,
X_ADDITIONAL_INFORMATION6 IN VARCHAR2,
X_ADDITIONAL_INFORMATION7 IN VARCHAR2,
X_ADDITIONAL_INFORMATION8 IN VARCHAR2,
X_ADDITIONAL_INFORMATION9 IN VARCHAR2,
X_ADDITIONAL_INFORMATION10 IN VARCHAR2,
X_ADDITIONAL_INFORMATION11 IN VARCHAR2,
X_ADDITIONAL_INFORMATION12 IN VARCHAR2,
X_ADDITIONAL_INFORMATION13 IN VARCHAR2,
X_ADDITIONAL_INFORMATION14 IN VARCHAR2,
X_ADDITIONAL_INFORMATION15 IN VARCHAR2,
X_ADDITIONAL_INFORMATION16 IN VARCHAR2,
X_ADDITIONAL_INFORMATION17 IN VARCHAR2,
X_ADDITIONAL_INFORMATION18 IN VARCHAR2,
X_ADDITIONAL_INFORMATION19 IN VARCHAR2,
X_ADDITIONAL_INFORMATION20 IN VARCHAR2,
X_ADDITIONAL_INFORMATION21 IN VARCHAR2,
X_ADDITIONAL_INFORMATION22 IN VARCHAR2,
X_ADDITIONAL_INFORMATION23 IN VARCHAR2,
X_ADDITIONAL_INFORMATION24 IN VARCHAR2,
X_ADDITIONAL_INFORMATION25 IN VARCHAR2,
X_ADDITIONAL_INFORMATION26 IN VARCHAR2,
X_ADDITIONAL_INFORMATION27 IN VARCHAR2,
X_ADDITIONAL_INFORMATION28 IN VARCHAR2,
X_ADDITIONAL_INFORMATION29 IN VARCHAR2,
X_ADDITIONAL_INFORMATION30 IN VARCHAR2,
X_DIRECTION_CODE IN VARCHAR2,
X_PERCENTAGE_OWNERSHIP IN NUMBER,
X_ACTUAL_CONTENT_SOURCE IN VARCHAR2
) IS
BEGIN
UPDATE HZ_RELATIONSHIPS SET
RELATIONSHIP_ID = DECODE( X_RELATIONSHIP_ID, NULL, RELATIONSHIP_ID, FND_API.G_MISS_NUM, NULL, X_RELATIONSHIP_ID ),
SUBJECT_ID = DECODE( X_SUBJECT_ID, NULL, SUBJECT_ID, FND_API.G_MISS_NUM, NULL, X_SUBJECT_ID ),
SUBJECT_TYPE = DECODE( X_SUBJECT_TYPE, NULL, SUBJECT_TYPE, FND_API.G_MISS_CHAR, NULL, X_SUBJECT_TYPE ),
SUBJECT_TABLE_NAME = DECODE( X_SUBJECT_TABLE_NAME, NULL, SUBJECT_TABLE_NAME, FND_API.G_MISS_CHAR, NULL, X_SUBJECT_TABLE_NAME ),
OBJECT_ID = DECODE( X_OBJECT_ID, NULL, OBJECT_ID, FND_API.G_MISS_NUM, NULL, X_OBJECT_ID ),
OBJECT_TYPE = DECODE( X_OBJECT_TYPE, NULL, OBJECT_TYPE, FND_API.G_MISS_CHAR, NULL, X_OBJECT_TYPE ),
OBJECT_TABLE_NAME = DECODE( X_OBJECT_TABLE_NAME, NULL, OBJECT_TABLE_NAME, FND_API.G_MISS_CHAR, NULL, X_OBJECT_TABLE_NAME ),
PARTY_ID = DECODE( X_PARTY_ID, NULL, PARTY_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_ID ),
RELATIONSHIP_CODE = DECODE( X_RELATIONSHIP_CODE, NULL, RELATIONSHIP_CODE, FND_API.G_MISS_CHAR, NULL, X_RELATIONSHIP_CODE ),
DIRECTIONAL_FLAG = DECODE( X_DIRECTIONAL_FLAG, NULL, DIRECTIONAL_FLAG, FND_API.G_MISS_CHAR, NULL, X_DIRECTIONAL_FLAG ),
COMMENTS = DECODE( X_COMMENTS, NULL, COMMENTS, FND_API.G_MISS_CHAR, NULL, X_COMMENTS ),
START_DATE = DECODE( X_START_DATE, NULL, START_DATE, FND_API.G_MISS_DATE, NULL, X_START_DATE ),
END_DATE = DECODE( X_END_DATE, NULL, END_DATE, FND_API.G_MISS_DATE, TO_DATE('31/12/4712 00:00:01','DD/MM/YYYY HH24:MI:SS'), X_END_DATE ),
STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, 'A', X_STATUS ),
CREATED_BY = CREATED_BY,
CREATION_DATE = CREATION_DATE,
LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
ATTRIBUTE_CATEGORY = DECODE( X_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
ATTRIBUTE1 = DECODE( X_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
ATTRIBUTE2 = DECODE( X_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
ATTRIBUTE3 = DECODE( X_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
ATTRIBUTE4 = DECODE( X_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
ATTRIBUTE5 = DECODE( X_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
ATTRIBUTE6 = DECODE( X_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
ATTRIBUTE7 = DECODE( X_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
ATTRIBUTE8 = DECODE( X_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
ATTRIBUTE9 = DECODE( X_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
ATTRIBUTE10 = DECODE( X_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
ATTRIBUTE11 = DECODE( X_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
ATTRIBUTE12 = DECODE( X_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
ATTRIBUTE13 = DECODE( X_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
ATTRIBUTE14 = DECODE( X_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
ATTRIBUTE15 = DECODE( X_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
ATTRIBUTE16 = DECODE( X_ATTRIBUTE16, NULL, ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
ATTRIBUTE17 = DECODE( X_ATTRIBUTE17, NULL, ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
ATTRIBUTE18 = DECODE( X_ATTRIBUTE18, NULL, ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
ATTRIBUTE19 = DECODE( X_ATTRIBUTE19, NULL, ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
ATTRIBUTE20 = DECODE( X_ATTRIBUTE20, NULL, ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
CONTENT_SOURCE_TYPE = DECODE( X_CONTENT_SOURCE_TYPE, NULL, CONTENT_SOURCE_TYPE, FND_API.G_MISS_CHAR, NULL, X_CONTENT_SOURCE_TYPE ),
RELATIONSHIP_TYPE = DECODE( X_RELATIONSHIP_TYPE, NULL, RELATIONSHIP_TYPE, FND_API.G_MISS_CHAR, NULL, X_RELATIONSHIP_TYPE ),
OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),
ADDITIONAL_INFORMATION1 = DECODE( X_ADDITIONAL_INFORMATION1, NULL, ADDITIONAL_INFORMATION1, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION1 ),
ADDITIONAL_INFORMATION2 = DECODE( X_ADDITIONAL_INFORMATION2, NULL, ADDITIONAL_INFORMATION2, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION2 ),
ADDITIONAL_INFORMATION3 = DECODE( X_ADDITIONAL_INFORMATION3, NULL, ADDITIONAL_INFORMATION3, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION3 ),
ADDITIONAL_INFORMATION4 = DECODE( X_ADDITIONAL_INFORMATION4, NULL, ADDITIONAL_INFORMATION4, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION4 ),
ADDITIONAL_INFORMATION5 = DECODE( X_ADDITIONAL_INFORMATION5, NULL, ADDITIONAL_INFORMATION5, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION5 ),
ADDITIONAL_INFORMATION6 = DECODE( X_ADDITIONAL_INFORMATION6, NULL, ADDITIONAL_INFORMATION6, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION6 ),
ADDITIONAL_INFORMATION7 = DECODE( X_ADDITIONAL_INFORMATION7, NULL, ADDITIONAL_INFORMATION7, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION7 ),
ADDITIONAL_INFORMATION8 = DECODE( X_ADDITIONAL_INFORMATION8, NULL, ADDITIONAL_INFORMATION8, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION8 ),
ADDITIONAL_INFORMATION9 = DECODE( X_ADDITIONAL_INFORMATION9, NULL, ADDITIONAL_INFORMATION9, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION9 ),
ADDITIONAL_INFORMATION10 = DECODE( X_ADDITIONAL_INFORMATION10, NULL, ADDITIONAL_INFORMATION10, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION10 ),
ADDITIONAL_INFORMATION11 = DECODE( X_ADDITIONAL_INFORMATION11, NULL, ADDITIONAL_INFORMATION11, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION11 ),
ADDITIONAL_INFORMATION12 = DECODE( X_ADDITIONAL_INFORMATION12, NULL, ADDITIONAL_INFORMATION12, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION12 ),
ADDITIONAL_INFORMATION13 = DECODE( X_ADDITIONAL_INFORMATION13, NULL, ADDITIONAL_INFORMATION13, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION13 ),
ADDITIONAL_INFORMATION14 = DECODE( X_ADDITIONAL_INFORMATION14, NULL, ADDITIONAL_INFORMATION14, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION14 ),
ADDITIONAL_INFORMATION15 = DECODE( X_ADDITIONAL_INFORMATION15, NULL, ADDITIONAL_INFORMATION15, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION15 ),
ADDITIONAL_INFORMATION16 = DECODE( X_ADDITIONAL_INFORMATION16, NULL, ADDITIONAL_INFORMATION16, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION16 ),
ADDITIONAL_INFORMATION17 = DECODE( X_ADDITIONAL_INFORMATION17, NULL, ADDITIONAL_INFORMATION17, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION17 ),
ADDITIONAL_INFORMATION18 = DECODE( X_ADDITIONAL_INFORMATION18, NULL, ADDITIONAL_INFORMATION18, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION18 ),
ADDITIONAL_INFORMATION19 = DECODE( X_ADDITIONAL_INFORMATION19, NULL, ADDITIONAL_INFORMATION19, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION19 ),
ADDITIONAL_INFORMATION20 = DECODE( X_ADDITIONAL_INFORMATION20, NULL, ADDITIONAL_INFORMATION20, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION20 ),
ADDITIONAL_INFORMATION21 = DECODE( X_ADDITIONAL_INFORMATION21, NULL, ADDITIONAL_INFORMATION21, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION21 ),
ADDITIONAL_INFORMATION22 = DECODE( X_ADDITIONAL_INFORMATION22, NULL, ADDITIONAL_INFORMATION22, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION22 ),
ADDITIONAL_INFORMATION23 = DECODE( X_ADDITIONAL_INFORMATION23, NULL, ADDITIONAL_INFORMATION23, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION23 ),
ADDITIONAL_INFORMATION24 = DECODE( X_ADDITIONAL_INFORMATION24, NULL, ADDITIONAL_INFORMATION24, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION24 ),
ADDITIONAL_INFORMATION25 = DECODE( X_ADDITIONAL_INFORMATION25, NULL, ADDITIONAL_INFORMATION25, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION25 ),
ADDITIONAL_INFORMATION26 = DECODE( X_ADDITIONAL_INFORMATION26, NULL, ADDITIONAL_INFORMATION26, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION26 ),
ADDITIONAL_INFORMATION27 = DECODE( X_ADDITIONAL_INFORMATION27, NULL, ADDITIONAL_INFORMATION27, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION27 ),
ADDITIONAL_INFORMATION28 = DECODE( X_ADDITIONAL_INFORMATION28, NULL, ADDITIONAL_INFORMATION28, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION28 ),
ADDITIONAL_INFORMATION29 = DECODE( X_ADDITIONAL_INFORMATION29, NULL, ADDITIONAL_INFORMATION29, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION29 ),
ADDITIONAL_INFORMATION30 = DECODE( X_ADDITIONAL_INFORMATION30, NULL, ADDITIONAL_INFORMATION30, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION30 ),
DIRECTION_CODE = DECODE( X_DIRECTION_CODE, NULL, DIRECTION_CODE, FND_API.G_MISS_CHAR, NULL, X_DIRECTION_CODE ),
PERCENTAGE_OWNERSHIP = DECODE( X_PERCENTAGE_OWNERSHIP, NULL, PERCENTAGE_OWNERSHIP, FND_API.G_MISS_NUM, NULL, X_PERCENTAGE_OWNERSHIP )/*,
** SSM SST Integration and Extension
** actual_content_source will not be updateable for non-SSM enabled entities.
ACTUAL_CONTENT_SOURCE = DECODE( X_ACTUAL_CONTENT_SOURCE, NULL, ACTUAL_CONTENT_SOURCE, FND_API.G_MISS_CHAR, NULL, X_ACTUAL_CONTENT_SOURCE)*/
WHERE ROWID = X_RowId;
END Update_Row;
X_LAST_UPDATED_BY IN NUMBER,
X_LAST_UPDATE_DATE IN DATE,
X_LAST_UPDATE_LOGIN IN NUMBER,
X_REQUEST_ID IN NUMBER,
X_PROGRAM_APPLICATION_ID IN NUMBER,
X_PROGRAM_ID IN NUMBER,
X_PROGRAM_UPDATE_DATE IN DATE,
X_ATTRIBUTE_CATEGORY IN VARCHAR2,
X_ATTRIBUTE1 IN VARCHAR2,
X_ATTRIBUTE2 IN VARCHAR2,
X_ATTRIBUTE3 IN VARCHAR2,
X_ATTRIBUTE4 IN VARCHAR2,
X_ATTRIBUTE5 IN VARCHAR2,
X_ATTRIBUTE6 IN VARCHAR2,
X_ATTRIBUTE7 IN VARCHAR2,
X_ATTRIBUTE8 IN VARCHAR2,
X_ATTRIBUTE9 IN VARCHAR2,
X_ATTRIBUTE10 IN VARCHAR2,
X_ATTRIBUTE11 IN VARCHAR2,
X_ATTRIBUTE12 IN VARCHAR2,
X_ATTRIBUTE13 IN VARCHAR2,
X_ATTRIBUTE14 IN VARCHAR2,
X_ATTRIBUTE15 IN VARCHAR2,
X_ATTRIBUTE16 IN VARCHAR2,
X_ATTRIBUTE17 IN VARCHAR2,
X_ATTRIBUTE18 IN VARCHAR2,
X_ATTRIBUTE19 IN VARCHAR2,
X_ATTRIBUTE20 IN VARCHAR2,
X_CONTENT_SOURCE_TYPE IN VARCHAR2,
X_RELATIONSHIP_TYPE IN VARCHAR2,
X_OBJECT_VERSION_NUMBER IN NUMBER,
X_CREATED_BY_MODULE IN VARCHAR2,
X_APPLICATION_ID IN NUMBER,
X_ADDITIONAL_INFORMATION1 IN VARCHAR2,
X_ADDITIONAL_INFORMATION2 IN VARCHAR2,
X_ADDITIONAL_INFORMATION3 IN VARCHAR2,
X_ADDITIONAL_INFORMATION4 IN VARCHAR2,
X_ADDITIONAL_INFORMATION5 IN VARCHAR2,
X_ADDITIONAL_INFORMATION6 IN VARCHAR2,
X_ADDITIONAL_INFORMATION7 IN VARCHAR2,
X_ADDITIONAL_INFORMATION8 IN VARCHAR2,
X_ADDITIONAL_INFORMATION9 IN VARCHAR2,
X_ADDITIONAL_INFORMATION10 IN VARCHAR2,
X_ADDITIONAL_INFORMATION11 IN VARCHAR2,
X_ADDITIONAL_INFORMATION12 IN VARCHAR2,
X_ADDITIONAL_INFORMATION13 IN VARCHAR2,
X_ADDITIONAL_INFORMATION14 IN VARCHAR2,
X_ADDITIONAL_INFORMATION15 IN VARCHAR2,
X_ADDITIONAL_INFORMATION16 IN VARCHAR2,
X_ADDITIONAL_INFORMATION17 IN VARCHAR2,
X_ADDITIONAL_INFORMATION18 IN VARCHAR2,
X_ADDITIONAL_INFORMATION19 IN VARCHAR2,
X_ADDITIONAL_INFORMATION20 IN VARCHAR2,
X_ADDITIONAL_INFORMATION21 IN VARCHAR2,
X_ADDITIONAL_INFORMATION22 IN VARCHAR2,
X_ADDITIONAL_INFORMATION23 IN VARCHAR2,
X_ADDITIONAL_INFORMATION24 IN VARCHAR2,
X_ADDITIONAL_INFORMATION25 IN VARCHAR2,
X_ADDITIONAL_INFORMATION26 IN VARCHAR2,
X_ADDITIONAL_INFORMATION27 IN VARCHAR2,
X_ADDITIONAL_INFORMATION28 IN VARCHAR2,
X_ADDITIONAL_INFORMATION29 IN VARCHAR2,
X_ADDITIONAL_INFORMATION30 IN VARCHAR2,
X_DIRECTION_CODE IN VARCHAR2,
X_PERCENTAGE_OWNERSHIP IN NUMBER,
X_ACTUAL_CONTENT_SOURCE IN VARCHAR2
) IS
CURSOR C IS
SELECT * FROM HZ_RELATIONSHIPS
WHERE ROWID = x_Rowid
FOR UPDATE NOWAIT;
FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
AND ( ( Recinfo.LAST_UPDATED_BY = X_LAST_UPDATED_BY )
OR ( ( Recinfo.LAST_UPDATED_BY IS NULL )
AND ( X_LAST_UPDATED_BY IS NULL ) ) )
AND ( ( Recinfo.LAST_UPDATE_DATE = X_LAST_UPDATE_DATE )
OR ( ( Recinfo.LAST_UPDATE_DATE IS NULL )
AND ( X_LAST_UPDATE_DATE IS NULL ) ) )
AND ( ( Recinfo.LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN )
OR ( ( Recinfo.LAST_UPDATE_LOGIN IS NULL )
AND ( X_LAST_UPDATE_LOGIN IS NULL ) ) )
AND ( ( Recinfo.REQUEST_ID = X_REQUEST_ID )
OR ( ( Recinfo.REQUEST_ID IS NULL )
AND ( X_REQUEST_ID IS NULL ) ) )
AND ( ( Recinfo.PROGRAM_APPLICATION_ID = X_PROGRAM_APPLICATION_ID )
OR ( ( Recinfo.PROGRAM_APPLICATION_ID IS NULL )
AND ( X_PROGRAM_APPLICATION_ID IS NULL ) ) )
AND ( ( Recinfo.PROGRAM_ID = X_PROGRAM_ID )
OR ( ( Recinfo.PROGRAM_ID IS NULL )
AND ( X_PROGRAM_ID IS NULL ) ) )
AND ( ( Recinfo.PROGRAM_UPDATE_DATE = X_PROGRAM_UPDATE_DATE )
OR ( ( Recinfo.PROGRAM_UPDATE_DATE IS NULL )
AND ( X_PROGRAM_UPDATE_DATE IS NULL ) ) )
AND ( ( Recinfo.ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY )
OR ( ( Recinfo.ATTRIBUTE_CATEGORY IS NULL )
AND ( X_ATTRIBUTE_CATEGORY IS NULL ) ) )
AND ( ( Recinfo.ATTRIBUTE1 = X_ATTRIBUTE1 )
OR ( ( Recinfo.ATTRIBUTE1 IS NULL )
AND ( X_ATTRIBUTE1 IS NULL ) ) )
AND ( ( Recinfo.ATTRIBUTE2 = X_ATTRIBUTE2 )
OR ( ( Recinfo.ATTRIBUTE2 IS NULL )
AND ( X_ATTRIBUTE2 IS NULL ) ) )
AND ( ( Recinfo.ATTRIBUTE3 = X_ATTRIBUTE3 )
OR ( ( Recinfo.ATTRIBUTE3 IS NULL )
AND ( X_ATTRIBUTE3 IS NULL ) ) )
AND ( ( Recinfo.ATTRIBUTE4 = X_ATTRIBUTE4 )
OR ( ( Recinfo.ATTRIBUTE4 IS NULL )
AND ( X_ATTRIBUTE4 IS NULL ) ) )
AND ( ( Recinfo.ATTRIBUTE5 = X_ATTRIBUTE5 )
OR ( ( Recinfo.ATTRIBUTE5 IS NULL )
AND ( X_ATTRIBUTE5 IS NULL ) ) )
AND ( ( Recinfo.ATTRIBUTE6 = X_ATTRIBUTE6 )
OR ( ( Recinfo.ATTRIBUTE6 IS NULL )
AND ( X_ATTRIBUTE6 IS NULL ) ) )
AND ( ( Recinfo.ATTRIBUTE7 = X_ATTRIBUTE7 )
OR ( ( Recinfo.ATTRIBUTE7 IS NULL )
AND ( X_ATTRIBUTE7 IS NULL ) ) )
AND ( ( Recinfo.ATTRIBUTE8 = X_ATTRIBUTE8 )
OR ( ( Recinfo.ATTRIBUTE8 IS NULL )
AND ( X_ATTRIBUTE8 IS NULL ) ) )
AND ( ( Recinfo.ATTRIBUTE9 = X_ATTRIBUTE9 )
OR ( ( Recinfo.ATTRIBUTE9 IS NULL )
AND ( X_ATTRIBUTE9 IS NULL ) ) )
AND ( ( Recinfo.ATTRIBUTE10 = X_ATTRIBUTE10 )
OR ( ( Recinfo.ATTRIBUTE10 IS NULL )
AND ( X_ATTRIBUTE10 IS NULL ) ) )
AND ( ( Recinfo.ATTRIBUTE11 = X_ATTRIBUTE11 )
OR ( ( Recinfo.ATTRIBUTE11 IS NULL )
AND ( X_ATTRIBUTE11 IS NULL ) ) )
AND ( ( Recinfo.ATTRIBUTE12 = X_ATTRIBUTE12 )
OR ( ( Recinfo.ATTRIBUTE12 IS NULL )
AND ( X_ATTRIBUTE12 IS NULL ) ) )
AND ( ( Recinfo.ATTRIBUTE13 = X_ATTRIBUTE13 )
OR ( ( Recinfo.ATTRIBUTE13 IS NULL )
AND ( X_ATTRIBUTE13 IS NULL ) ) )
AND ( ( Recinfo.ATTRIBUTE14 = X_ATTRIBUTE14 )
OR ( ( Recinfo.ATTRIBUTE14 IS NULL )
AND ( X_ATTRIBUTE14 IS NULL ) ) )
AND ( ( Recinfo.ATTRIBUTE15 = X_ATTRIBUTE15 )
OR ( ( Recinfo.ATTRIBUTE15 IS NULL )
AND ( X_ATTRIBUTE15 IS NULL ) ) )
AND ( ( Recinfo.ATTRIBUTE16 = X_ATTRIBUTE16 )
OR ( ( Recinfo.ATTRIBUTE16 IS NULL )
AND ( X_ATTRIBUTE16 IS NULL ) ) )
AND ( ( Recinfo.ATTRIBUTE17 = X_ATTRIBUTE17 )
OR ( ( Recinfo.ATTRIBUTE17 IS NULL )
AND ( X_ATTRIBUTE17 IS NULL ) ) )
AND ( ( Recinfo.ATTRIBUTE18 = X_ATTRIBUTE18 )
OR ( ( Recinfo.ATTRIBUTE18 IS NULL )
AND ( X_ATTRIBUTE18 IS NULL ) ) )
AND ( ( Recinfo.ATTRIBUTE19 = X_ATTRIBUTE19 )
OR ( ( Recinfo.ATTRIBUTE19 IS NULL )
AND ( X_ATTRIBUTE19 IS NULL ) ) )
AND ( ( Recinfo.ATTRIBUTE20 = X_ATTRIBUTE20 )
OR ( ( Recinfo.ATTRIBUTE20 IS NULL )
AND ( X_ATTRIBUTE20 IS NULL ) ) )
AND ( ( Recinfo.CONTENT_SOURCE_TYPE = X_CONTENT_SOURCE_TYPE )
OR ( ( Recinfo.CONTENT_SOURCE_TYPE IS NULL )
AND ( X_CONTENT_SOURCE_TYPE IS NULL ) ) )
AND ( ( Recinfo.RELATIONSHIP_TYPE = X_RELATIONSHIP_TYPE )
OR ( ( Recinfo.RELATIONSHIP_TYPE IS NULL )
AND ( X_RELATIONSHIP_TYPE IS NULL ) ) )
AND ( ( Recinfo.OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER )
OR ( ( Recinfo.OBJECT_VERSION_NUMBER IS NULL )
AND ( X_OBJECT_VERSION_NUMBER IS NULL ) ) )
AND ( ( Recinfo.CREATED_BY_MODULE = X_CREATED_BY_MODULE )
OR ( ( Recinfo.CREATED_BY_MODULE IS NULL )
AND ( X_CREATED_BY_MODULE IS NULL ) ) )
AND ( ( Recinfo.APPLICATION_ID = X_APPLICATION_ID )
OR ( ( Recinfo.APPLICATION_ID IS NULL )
AND ( X_APPLICATION_ID IS NULL ) ) )
AND ( ( Recinfo.ADDITIONAL_INFORMATION1 = X_ADDITIONAL_INFORMATION1 )
OR ( ( Recinfo.ADDITIONAL_INFORMATION1 IS NULL )
AND ( X_ADDITIONAL_INFORMATION1 IS NULL ) ) )
AND ( ( Recinfo.ADDITIONAL_INFORMATION2 = X_ADDITIONAL_INFORMATION2 )
OR ( ( Recinfo.ADDITIONAL_INFORMATION2 IS NULL )
AND ( X_ADDITIONAL_INFORMATION2 IS NULL ) ) )
AND ( ( Recinfo.ADDITIONAL_INFORMATION3 = X_ADDITIONAL_INFORMATION3 )
OR ( ( Recinfo.ADDITIONAL_INFORMATION3 IS NULL )
AND ( X_ADDITIONAL_INFORMATION3 IS NULL ) ) )
AND ( ( Recinfo.ADDITIONAL_INFORMATION4 = X_ADDITIONAL_INFORMATION4 )
OR ( ( Recinfo.ADDITIONAL_INFORMATION4 IS NULL )
AND ( X_ADDITIONAL_INFORMATION4 IS NULL ) ) )
AND ( ( Recinfo.ADDITIONAL_INFORMATION5 = X_ADDITIONAL_INFORMATION5 )
OR ( ( Recinfo.ADDITIONAL_INFORMATION5 IS NULL )
AND ( X_ADDITIONAL_INFORMATION5 IS NULL ) ) )
AND ( ( Recinfo.ADDITIONAL_INFORMATION6 = X_ADDITIONAL_INFORMATION6 )
OR ( ( Recinfo.ADDITIONAL_INFORMATION6 IS NULL )
AND ( X_ADDITIONAL_INFORMATION6 IS NULL ) ) )
AND ( ( Recinfo.ADDITIONAL_INFORMATION7 = X_ADDITIONAL_INFORMATION7 )
OR ( ( Recinfo.ADDITIONAL_INFORMATION7 IS NULL )
AND ( X_ADDITIONAL_INFORMATION7 IS NULL ) ) )
AND ( ( Recinfo.ADDITIONAL_INFORMATION8 = X_ADDITIONAL_INFORMATION8 )
OR ( ( Recinfo.ADDITIONAL_INFORMATION8 IS NULL )
AND ( X_ADDITIONAL_INFORMATION8 IS NULL ) ) )
AND ( ( Recinfo.ADDITIONAL_INFORMATION9 = X_ADDITIONAL_INFORMATION9 )
OR ( ( Recinfo.ADDITIONAL_INFORMATION9 IS NULL )
AND ( X_ADDITIONAL_INFORMATION9 IS NULL ) ) )
AND ( ( Recinfo.ADDITIONAL_INFORMATION10 = X_ADDITIONAL_INFORMATION10 )
OR ( ( Recinfo.ADDITIONAL_INFORMATION10 IS NULL )
AND ( X_ADDITIONAL_INFORMATION10 IS NULL ) ) )
AND ( ( Recinfo.ADDITIONAL_INFORMATION11 = X_ADDITIONAL_INFORMATION11 )
OR ( ( Recinfo.ADDITIONAL_INFORMATION11 IS NULL )
AND ( X_ADDITIONAL_INFORMATION11 IS NULL ) ) )
AND ( ( Recinfo.ADDITIONAL_INFORMATION12 = X_ADDITIONAL_INFORMATION12 )
OR ( ( Recinfo.ADDITIONAL_INFORMATION12 IS NULL )
AND ( X_ADDITIONAL_INFORMATION12 IS NULL ) ) )
AND ( ( Recinfo.ADDITIONAL_INFORMATION13 = X_ADDITIONAL_INFORMATION13 )
OR ( ( Recinfo.ADDITIONAL_INFORMATION13 IS NULL )
AND ( X_ADDITIONAL_INFORMATION13 IS NULL ) ) )
AND ( ( Recinfo.ADDITIONAL_INFORMATION14 = X_ADDITIONAL_INFORMATION14 )
OR ( ( Recinfo.ADDITIONAL_INFORMATION14 IS NULL )
AND ( X_ADDITIONAL_INFORMATION14 IS NULL ) ) )
AND ( ( Recinfo.ADDITIONAL_INFORMATION15 = X_ADDITIONAL_INFORMATION15 )
OR ( ( Recinfo.ADDITIONAL_INFORMATION15 IS NULL )
AND ( X_ADDITIONAL_INFORMATION15 IS NULL ) ) )
AND ( ( Recinfo.ADDITIONAL_INFORMATION16 = X_ADDITIONAL_INFORMATION16 )
OR ( ( Recinfo.ADDITIONAL_INFORMATION16 IS NULL )
AND ( X_ADDITIONAL_INFORMATION16 IS NULL ) ) )
AND ( ( Recinfo.ADDITIONAL_INFORMATION17 = X_ADDITIONAL_INFORMATION17 )
OR ( ( Recinfo.ADDITIONAL_INFORMATION17 IS NULL )
AND ( X_ADDITIONAL_INFORMATION17 IS NULL ) ) )
AND ( ( Recinfo.ADDITIONAL_INFORMATION18 = X_ADDITIONAL_INFORMATION18 )
OR ( ( Recinfo.ADDITIONAL_INFORMATION18 IS NULL )
AND ( X_ADDITIONAL_INFORMATION18 IS NULL ) ) )
AND ( ( Recinfo.ADDITIONAL_INFORMATION19 = X_ADDITIONAL_INFORMATION19 )
OR ( ( Recinfo.ADDITIONAL_INFORMATION19 IS NULL )
AND ( X_ADDITIONAL_INFORMATION19 IS NULL ) ) )
AND ( ( Recinfo.ADDITIONAL_INFORMATION20 = X_ADDITIONAL_INFORMATION20 )
OR ( ( Recinfo.ADDITIONAL_INFORMATION20 IS NULL )
AND ( X_ADDITIONAL_INFORMATION20 IS NULL ) ) )
AND ( ( Recinfo.ADDITIONAL_INFORMATION21 = X_ADDITIONAL_INFORMATION21 )
OR ( ( Recinfo.ADDITIONAL_INFORMATION21 IS NULL )
AND ( X_ADDITIONAL_INFORMATION21 IS NULL ) ) )
AND ( ( Recinfo.ADDITIONAL_INFORMATION22 = X_ADDITIONAL_INFORMATION22 )
OR ( ( Recinfo.ADDITIONAL_INFORMATION22 IS NULL )
AND ( X_ADDITIONAL_INFORMATION22 IS NULL ) ) )
AND ( ( Recinfo.ADDITIONAL_INFORMATION23 = X_ADDITIONAL_INFORMATION23 )
OR ( ( Recinfo.ADDITIONAL_INFORMATION23 IS NULL )
AND ( X_ADDITIONAL_INFORMATION23 IS NULL ) ) )
AND ( ( Recinfo.ADDITIONAL_INFORMATION24 = X_ADDITIONAL_INFORMATION24 )
OR ( ( Recinfo.ADDITIONAL_INFORMATION24 IS NULL )
AND ( X_ADDITIONAL_INFORMATION24 IS NULL ) ) )
AND ( ( Recinfo.ADDITIONAL_INFORMATION25 = X_ADDITIONAL_INFORMATION25 )
OR ( ( Recinfo.ADDITIONAL_INFORMATION25 IS NULL )
AND ( X_ADDITIONAL_INFORMATION25 IS NULL ) ) )
AND ( ( Recinfo.ADDITIONAL_INFORMATION26 = X_ADDITIONAL_INFORMATION26 )
OR ( ( Recinfo.ADDITIONAL_INFORMATION26 IS NULL )
AND ( X_ADDITIONAL_INFORMATION26 IS NULL ) ) )
AND ( ( Recinfo.ADDITIONAL_INFORMATION27 = X_ADDITIONAL_INFORMATION27 )
OR ( ( Recinfo.ADDITIONAL_INFORMATION27 IS NULL )
AND ( X_ADDITIONAL_INFORMATION27 IS NULL ) ) )
AND ( ( Recinfo.ADDITIONAL_INFORMATION28 = X_ADDITIONAL_INFORMATION28 )
OR ( ( Recinfo.ADDITIONAL_INFORMATION28 IS NULL )
AND ( X_ADDITIONAL_INFORMATION28 IS NULL ) ) )
AND ( ( Recinfo.ADDITIONAL_INFORMATION29 = X_ADDITIONAL_INFORMATION29 )
OR ( ( Recinfo.ADDITIONAL_INFORMATION29 IS NULL )
AND ( X_ADDITIONAL_INFORMATION29 IS NULL ) ) )
AND ( ( Recinfo.ADDITIONAL_INFORMATION30 = X_ADDITIONAL_INFORMATION30 )
OR ( ( Recinfo.ADDITIONAL_INFORMATION30 IS NULL )
AND ( X_ADDITIONAL_INFORMATION30 IS NULL ) ) )
AND ( ( Recinfo.DIRECTION_CODE = X_DIRECTION_CODE )
OR ( ( Recinfo.DIRECTION_CODE IS NULL )
AND ( X_DIRECTION_CODE IS NULL ) ) )
AND ( ( Recinfo.PERCENTAGE_OWNERSHIP = X_PERCENTAGE_OWNERSHIP )
OR ( ( Recinfo.PERCENTAGE_OWNERSHIP IS NULL )
AND ( X_PERCENTAGE_OWNERSHIP IS NULL ) ) )
AND ( ( Recinfo.ACTUAL_CONTENT_SOURCE = X_ACTUAL_CONTENT_SOURCE )
OR ( ( Recinfo.ACTUAL_CONTENT_SOURCE IS NULL )
AND ( X_ACTUAL_CONTENT_SOURCE IS NULL ) ) )
) THEN
RETURN;
FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
PROCEDURE Select_Row (
X_RELATIONSHIP_ID IN OUT NOCOPY NUMBER,
X_DIRECTIONAL_FLAG IN OUT NOCOPY VARCHAR2,
X_SUBJECT_ID OUT NOCOPY NUMBER,
X_SUBJECT_TYPE OUT NOCOPY VARCHAR2,
X_SUBJECT_TABLE_NAME OUT NOCOPY VARCHAR2,
X_OBJECT_ID OUT NOCOPY NUMBER,
X_OBJECT_TYPE OUT NOCOPY VARCHAR2,
X_OBJECT_TABLE_NAME OUT NOCOPY VARCHAR2,
X_PARTY_ID OUT NOCOPY NUMBER,
X_RELATIONSHIP_CODE OUT NOCOPY VARCHAR2,
X_COMMENTS OUT NOCOPY VARCHAR2,
X_START_DATE OUT NOCOPY DATE,
X_END_DATE OUT NOCOPY DATE,
X_STATUS OUT NOCOPY VARCHAR2,
X_ATTRIBUTE_CATEGORY OUT NOCOPY VARCHAR2,
X_ATTRIBUTE1 OUT NOCOPY VARCHAR2,
X_ATTRIBUTE2 OUT NOCOPY VARCHAR2,
X_ATTRIBUTE3 OUT NOCOPY VARCHAR2,
X_ATTRIBUTE4 OUT NOCOPY VARCHAR2,
X_ATTRIBUTE5 OUT NOCOPY VARCHAR2,
X_ATTRIBUTE6 OUT NOCOPY VARCHAR2,
X_ATTRIBUTE7 OUT NOCOPY VARCHAR2,
X_ATTRIBUTE8 OUT NOCOPY VARCHAR2,
X_ATTRIBUTE9 OUT NOCOPY VARCHAR2,
X_ATTRIBUTE10 OUT NOCOPY VARCHAR2,
X_ATTRIBUTE11 OUT NOCOPY VARCHAR2,
X_ATTRIBUTE12 OUT NOCOPY VARCHAR2,
X_ATTRIBUTE13 OUT NOCOPY VARCHAR2,
X_ATTRIBUTE14 OUT NOCOPY VARCHAR2,
X_ATTRIBUTE15 OUT NOCOPY VARCHAR2,
X_ATTRIBUTE16 OUT NOCOPY VARCHAR2,
X_ATTRIBUTE17 OUT NOCOPY VARCHAR2,
X_ATTRIBUTE18 OUT NOCOPY VARCHAR2,
X_ATTRIBUTE19 OUT NOCOPY VARCHAR2,
X_ATTRIBUTE20 OUT NOCOPY VARCHAR2,
X_CONTENT_SOURCE_TYPE OUT NOCOPY VARCHAR2,
X_RELATIONSHIP_TYPE OUT NOCOPY VARCHAR2,
X_CREATED_BY_MODULE OUT NOCOPY VARCHAR2,
X_APPLICATION_ID OUT NOCOPY NUMBER,
X_ADDITIONAL_INFORMATION1 OUT NOCOPY VARCHAR2,
X_ADDITIONAL_INFORMATION2 OUT NOCOPY VARCHAR2,
X_ADDITIONAL_INFORMATION3 OUT NOCOPY VARCHAR2,
X_ADDITIONAL_INFORMATION4 OUT NOCOPY VARCHAR2,
X_ADDITIONAL_INFORMATION5 OUT NOCOPY VARCHAR2,
X_ADDITIONAL_INFORMATION6 OUT NOCOPY VARCHAR2,
X_ADDITIONAL_INFORMATION7 OUT NOCOPY VARCHAR2,
X_ADDITIONAL_INFORMATION8 OUT NOCOPY VARCHAR2,
X_ADDITIONAL_INFORMATION9 OUT NOCOPY VARCHAR2,
X_ADDITIONAL_INFORMATION10 OUT NOCOPY VARCHAR2,
X_ADDITIONAL_INFORMATION11 OUT NOCOPY VARCHAR2,
X_ADDITIONAL_INFORMATION12 OUT NOCOPY VARCHAR2,
X_ADDITIONAL_INFORMATION13 OUT NOCOPY VARCHAR2,
X_ADDITIONAL_INFORMATION14 OUT NOCOPY VARCHAR2,
X_ADDITIONAL_INFORMATION15 OUT NOCOPY VARCHAR2,
X_ADDITIONAL_INFORMATION16 OUT NOCOPY VARCHAR2,
X_ADDITIONAL_INFORMATION17 OUT NOCOPY VARCHAR2,
X_ADDITIONAL_INFORMATION18 OUT NOCOPY VARCHAR2,
X_ADDITIONAL_INFORMATION19 OUT NOCOPY VARCHAR2,
X_ADDITIONAL_INFORMATION20 OUT NOCOPY VARCHAR2,
X_ADDITIONAL_INFORMATION21 OUT NOCOPY VARCHAR2,
X_ADDITIONAL_INFORMATION22 OUT NOCOPY VARCHAR2,
X_ADDITIONAL_INFORMATION23 OUT NOCOPY VARCHAR2,
X_ADDITIONAL_INFORMATION24 OUT NOCOPY VARCHAR2,
X_ADDITIONAL_INFORMATION25 OUT NOCOPY VARCHAR2,
X_ADDITIONAL_INFORMATION26 OUT NOCOPY VARCHAR2,
X_ADDITIONAL_INFORMATION27 OUT NOCOPY VARCHAR2,
X_ADDITIONAL_INFORMATION28 OUT NOCOPY VARCHAR2,
X_ADDITIONAL_INFORMATION29 OUT NOCOPY VARCHAR2,
X_ADDITIONAL_INFORMATION30 OUT NOCOPY VARCHAR2,
X_DIRECTION_CODE OUT NOCOPY VARCHAR2,
X_PERCENTAGE_OWNERSHIP OUT NOCOPY NUMBER,
X_ACTUAL_CONTENT_SOURCE OUT NOCOPY VARCHAR2
) IS
BEGIN
SELECT
NVL( RELATIONSHIP_ID, FND_API.G_MISS_NUM ),
NVL( SUBJECT_ID, FND_API.G_MISS_NUM ),
NVL( SUBJECT_TYPE, FND_API.G_MISS_CHAR ),
NVL( SUBJECT_TABLE_NAME, FND_API.G_MISS_CHAR ),
NVL( OBJECT_ID, FND_API.G_MISS_NUM ),
NVL( OBJECT_TYPE, FND_API.G_MISS_CHAR ),
NVL( OBJECT_TABLE_NAME, FND_API.G_MISS_CHAR ),
NVL( PARTY_ID, FND_API.G_MISS_NUM ),
NVL( RELATIONSHIP_CODE, FND_API.G_MISS_CHAR ),
NVL( DIRECTIONAL_FLAG, FND_API.G_MISS_CHAR ),
NVL( COMMENTS, FND_API.G_MISS_CHAR ),
NVL( START_DATE, FND_API.G_MISS_DATE ),
NVL( END_DATE, FND_API.G_MISS_DATE ),
NVL( STATUS, FND_API.G_MISS_CHAR ),
NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),
NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),
NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),
NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),
NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),
NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),
NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),
NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),
NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),
NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),
NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),
NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),
NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),
NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),
NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),
NVL( ATTRIBUTE16, FND_API.G_MISS_CHAR ),
NVL( ATTRIBUTE17, FND_API.G_MISS_CHAR ),
NVL( ATTRIBUTE18, FND_API.G_MISS_CHAR ),
NVL( ATTRIBUTE19, FND_API.G_MISS_CHAR ),
NVL( ATTRIBUTE20, FND_API.G_MISS_CHAR ),
NVL( CONTENT_SOURCE_TYPE, FND_API.G_MISS_CHAR ),
NVL( RELATIONSHIP_TYPE, FND_API.G_MISS_CHAR ),
NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
NVL( APPLICATION_ID, FND_API.G_MISS_NUM ),
NVL( ADDITIONAL_INFORMATION1, FND_API.G_MISS_CHAR ),
NVL( ADDITIONAL_INFORMATION2, FND_API.G_MISS_CHAR ),
NVL( ADDITIONAL_INFORMATION3, FND_API.G_MISS_CHAR ),
NVL( ADDITIONAL_INFORMATION4, FND_API.G_MISS_CHAR ),
NVL( ADDITIONAL_INFORMATION5, FND_API.G_MISS_CHAR ),
NVL( ADDITIONAL_INFORMATION6, FND_API.G_MISS_CHAR ),
NVL( ADDITIONAL_INFORMATION7, FND_API.G_MISS_CHAR ),
NVL( ADDITIONAL_INFORMATION8, FND_API.G_MISS_CHAR ),
NVL( ADDITIONAL_INFORMATION9, FND_API.G_MISS_CHAR ),
NVL( ADDITIONAL_INFORMATION10, FND_API.G_MISS_CHAR ),
NVL( ADDITIONAL_INFORMATION11, FND_API.G_MISS_CHAR ),
NVL( ADDITIONAL_INFORMATION12, FND_API.G_MISS_CHAR ),
NVL( ADDITIONAL_INFORMATION13, FND_API.G_MISS_CHAR ),
NVL( ADDITIONAL_INFORMATION14, FND_API.G_MISS_CHAR ),
NVL( ADDITIONAL_INFORMATION15, FND_API.G_MISS_CHAR ),
NVL( ADDITIONAL_INFORMATION16, FND_API.G_MISS_CHAR ),
NVL( ADDITIONAL_INFORMATION17, FND_API.G_MISS_CHAR ),
NVL( ADDITIONAL_INFORMATION18, FND_API.G_MISS_CHAR ),
NVL( ADDITIONAL_INFORMATION19, FND_API.G_MISS_CHAR ),
NVL( ADDITIONAL_INFORMATION20, FND_API.G_MISS_CHAR ),
NVL( ADDITIONAL_INFORMATION21, FND_API.G_MISS_CHAR ),
NVL( ADDITIONAL_INFORMATION22, FND_API.G_MISS_CHAR ),
NVL( ADDITIONAL_INFORMATION23, FND_API.G_MISS_CHAR ),
NVL( ADDITIONAL_INFORMATION24, FND_API.G_MISS_CHAR ),
NVL( ADDITIONAL_INFORMATION25, FND_API.G_MISS_CHAR ),
NVL( ADDITIONAL_INFORMATION26, FND_API.G_MISS_CHAR ),
NVL( ADDITIONAL_INFORMATION27, FND_API.G_MISS_CHAR ),
NVL( ADDITIONAL_INFORMATION28, FND_API.G_MISS_CHAR ),
NVL( ADDITIONAL_INFORMATION29, FND_API.G_MISS_CHAR ),
NVL( ADDITIONAL_INFORMATION30, FND_API.G_MISS_CHAR ),
NVL( DIRECTION_CODE, FND_API.G_MISS_CHAR ),
NVL( PERCENTAGE_OWNERSHIP, FND_API.G_MISS_NUM ),
NVL( ACTUAL_CONTENT_SOURCE, FND_API.G_MISS_CHAR )
INTO
X_RELATIONSHIP_ID,
X_SUBJECT_ID,
X_SUBJECT_TYPE,
X_SUBJECT_TABLE_NAME,
X_OBJECT_ID,
X_OBJECT_TYPE,
X_OBJECT_TABLE_NAME,
X_PARTY_ID,
X_RELATIONSHIP_CODE,
X_DIRECTIONAL_FLAG,
X_COMMENTS,
X_START_DATE,
X_END_DATE,
X_STATUS,
X_ATTRIBUTE_CATEGORY,
X_ATTRIBUTE1,
X_ATTRIBUTE2,
X_ATTRIBUTE3,
X_ATTRIBUTE4,
X_ATTRIBUTE5,
X_ATTRIBUTE6,
X_ATTRIBUTE7,
X_ATTRIBUTE8,
X_ATTRIBUTE9,
X_ATTRIBUTE10,
X_ATTRIBUTE11,
X_ATTRIBUTE12,
X_ATTRIBUTE13,
X_ATTRIBUTE14,
X_ATTRIBUTE15,
X_ATTRIBUTE16,
X_ATTRIBUTE17,
X_ATTRIBUTE18,
X_ATTRIBUTE19,
X_ATTRIBUTE20,
X_CONTENT_SOURCE_TYPE,
X_RELATIONSHIP_TYPE,
X_CREATED_BY_MODULE,
X_APPLICATION_ID,
X_ADDITIONAL_INFORMATION1,
X_ADDITIONAL_INFORMATION2,
X_ADDITIONAL_INFORMATION3,
X_ADDITIONAL_INFORMATION4,
X_ADDITIONAL_INFORMATION5,
X_ADDITIONAL_INFORMATION6,
X_ADDITIONAL_INFORMATION7,
X_ADDITIONAL_INFORMATION8,
X_ADDITIONAL_INFORMATION9,
X_ADDITIONAL_INFORMATION10,
X_ADDITIONAL_INFORMATION11,
X_ADDITIONAL_INFORMATION12,
X_ADDITIONAL_INFORMATION13,
X_ADDITIONAL_INFORMATION14,
X_ADDITIONAL_INFORMATION15,
X_ADDITIONAL_INFORMATION16,
X_ADDITIONAL_INFORMATION17,
X_ADDITIONAL_INFORMATION18,
X_ADDITIONAL_INFORMATION19,
X_ADDITIONAL_INFORMATION20,
X_ADDITIONAL_INFORMATION21,
X_ADDITIONAL_INFORMATION22,
X_ADDITIONAL_INFORMATION23,
X_ADDITIONAL_INFORMATION24,
X_ADDITIONAL_INFORMATION25,
X_ADDITIONAL_INFORMATION26,
X_ADDITIONAL_INFORMATION27,
X_ADDITIONAL_INFORMATION28,
X_ADDITIONAL_INFORMATION29,
X_ADDITIONAL_INFORMATION30,
X_DIRECTION_CODE,
X_PERCENTAGE_OWNERSHIP,
X_ACTUAL_CONTENT_SOURCE
FROM HZ_RELATIONSHIPS
WHERE RELATIONSHIP_ID = X_RELATIONSHIP_ID
AND DIRECTIONAL_FLAG = X_DIRECTIONAL_FLAG;
END Select_Row;
PROCEDURE Delete_Row (
X_RELATIONSHIP_ID IN NUMBER
) IS
BEGIN
DELETE FROM HZ_RELATIONSHIPS
WHERE RELATIONSHIP_ID = X_RELATIONSHIP_ID;
END Delete_Row;