DBA Data[Home] [Help]

APPS.LNS_LOAN_HISTORIES_H_PKG dependencies on LNS_UTILITY_PUB

Line 53: ,LNS_UTILITY_PUB.CREATED_BY

49: ,DECODE(P_TABLE_NAME, FND_API.G_MISS_CHAR, NULL, P_TABLE_NAME)
50: ,DECODE(P_COLUMN_NAME, FND_API.G_MISS_CHAR, NULL, P_COLUMN_NAME)
51: ,DECODE(P_OLD_VALUE, FND_API.G_MISS_CHAR, NULL, P_OLD_VALUE)
52: ,DECODE(P_NEW_VALUE, FND_API.G_MISS_CHAR, NULL, P_NEW_VALUE)
53: ,LNS_UTILITY_PUB.CREATED_BY
54: ,LNS_UTILITY_PUB.CREATION_DATE
55: ,LNS_UTILITY_PUB.LAST_UPDATED_BY
56: ,LNS_UTILITY_PUB.LAST_UPDATE_DATE
57: ,LNS_UTILITY_PUB.LAST_UPDATE_LOGIN

Line 54: ,LNS_UTILITY_PUB.CREATION_DATE

50: ,DECODE(P_COLUMN_NAME, FND_API.G_MISS_CHAR, NULL, P_COLUMN_NAME)
51: ,DECODE(P_OLD_VALUE, FND_API.G_MISS_CHAR, NULL, P_OLD_VALUE)
52: ,DECODE(P_NEW_VALUE, FND_API.G_MISS_CHAR, NULL, P_NEW_VALUE)
53: ,LNS_UTILITY_PUB.CREATED_BY
54: ,LNS_UTILITY_PUB.CREATION_DATE
55: ,LNS_UTILITY_PUB.LAST_UPDATED_BY
56: ,LNS_UTILITY_PUB.LAST_UPDATE_DATE
57: ,LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
58: ,DECODE(P_DATA_TYPE, FND_API.G_MISS_CHAR, NULL, P_DATA_TYPE)

Line 55: ,LNS_UTILITY_PUB.LAST_UPDATED_BY

51: ,DECODE(P_OLD_VALUE, FND_API.G_MISS_CHAR, NULL, P_OLD_VALUE)
52: ,DECODE(P_NEW_VALUE, FND_API.G_MISS_CHAR, NULL, P_NEW_VALUE)
53: ,LNS_UTILITY_PUB.CREATED_BY
54: ,LNS_UTILITY_PUB.CREATION_DATE
55: ,LNS_UTILITY_PUB.LAST_UPDATED_BY
56: ,LNS_UTILITY_PUB.LAST_UPDATE_DATE
57: ,LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
58: ,DECODE(P_DATA_TYPE, FND_API.G_MISS_CHAR, NULL, P_DATA_TYPE)
59: ,DECODE(P_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, P_OBJECT_VERSION_NUMBER)

Line 56: ,LNS_UTILITY_PUB.LAST_UPDATE_DATE

52: ,DECODE(P_NEW_VALUE, FND_API.G_MISS_CHAR, NULL, P_NEW_VALUE)
53: ,LNS_UTILITY_PUB.CREATED_BY
54: ,LNS_UTILITY_PUB.CREATION_DATE
55: ,LNS_UTILITY_PUB.LAST_UPDATED_BY
56: ,LNS_UTILITY_PUB.LAST_UPDATE_DATE
57: ,LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
58: ,DECODE(P_DATA_TYPE, FND_API.G_MISS_CHAR, NULL, P_DATA_TYPE)
59: ,DECODE(P_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, P_OBJECT_VERSION_NUMBER)
60: ,DECODE(P_PRIMARY_KEY_ID, FND_API.G_MISS_NUM, NULL, P_PRIMARY_KEY_ID)

Line 57: ,LNS_UTILITY_PUB.LAST_UPDATE_LOGIN

53: ,LNS_UTILITY_PUB.CREATED_BY
54: ,LNS_UTILITY_PUB.CREATION_DATE
55: ,LNS_UTILITY_PUB.LAST_UPDATED_BY
56: ,LNS_UTILITY_PUB.LAST_UPDATE_DATE
57: ,LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
58: ,DECODE(P_DATA_TYPE, FND_API.G_MISS_CHAR, NULL, P_DATA_TYPE)
59: ,DECODE(P_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, P_OBJECT_VERSION_NUMBER)
60: ,DECODE(P_PRIMARY_KEY_ID, FND_API.G_MISS_NUM, NULL, P_PRIMARY_KEY_ID)
61: ) RETURNING

Line 89: ,LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY

85: ,TABLE_NAME = DECODE(P_TABLE_NAME, NULL, TABLE_NAME, FND_API.G_MISS_CHAR, NULL, P_TABLE_NAME)
86: ,COLUMN_NAME = DECODE(P_COLUMN_NAME, NULL, COLUMN_NAME, FND_API.G_MISS_CHAR, NULL, P_COLUMN_NAME)
87: ,OLD_VALUE = DECODE(P_OLD_VALUE, NULL, OLD_VALUE, FND_API.G_MISS_CHAR, NULL, P_OLD_VALUE)
88: ,NEW_VALUE = DECODE(P_NEW_VALUE, NULL, NEW_VALUE, FND_API.G_MISS_CHAR, NULL, P_NEW_VALUE)
89: ,LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY
90: ,LAST_UPDATE_DATE = LNS_UTILITY_PUB.LAST_UPDATE_DATE
91: ,LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
92: ,DATA_TYPE = DECODE(P_DATA_TYPE, NULL, DATA_TYPE, FND_API.G_MISS_CHAR, NULL, P_DATA_TYPE)
93: ,OBJECT_VERSION_NUMBER = DECODE(P_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, P_OBJECT_VERSION_NUMBER)

Line 90: ,LAST_UPDATE_DATE = LNS_UTILITY_PUB.LAST_UPDATE_DATE

86: ,COLUMN_NAME = DECODE(P_COLUMN_NAME, NULL, COLUMN_NAME, FND_API.G_MISS_CHAR, NULL, P_COLUMN_NAME)
87: ,OLD_VALUE = DECODE(P_OLD_VALUE, NULL, OLD_VALUE, FND_API.G_MISS_CHAR, NULL, P_OLD_VALUE)
88: ,NEW_VALUE = DECODE(P_NEW_VALUE, NULL, NEW_VALUE, FND_API.G_MISS_CHAR, NULL, P_NEW_VALUE)
89: ,LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY
90: ,LAST_UPDATE_DATE = LNS_UTILITY_PUB.LAST_UPDATE_DATE
91: ,LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
92: ,DATA_TYPE = DECODE(P_DATA_TYPE, NULL, DATA_TYPE, FND_API.G_MISS_CHAR, NULL, P_DATA_TYPE)
93: ,OBJECT_VERSION_NUMBER = DECODE(P_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, P_OBJECT_VERSION_NUMBER)
94: ,PRIMARY_KEY_ID = DECODE(P_PRIMARY_KEY_ID, NULL, PRIMARY_KEY_ID, FND_API.G_MISS_NUM, NULL, P_PRIMARY_KEY_ID)

Line 91: ,LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN

87: ,OLD_VALUE = DECODE(P_OLD_VALUE, NULL, OLD_VALUE, FND_API.G_MISS_CHAR, NULL, P_OLD_VALUE)
88: ,NEW_VALUE = DECODE(P_NEW_VALUE, NULL, NEW_VALUE, FND_API.G_MISS_CHAR, NULL, P_NEW_VALUE)
89: ,LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY
90: ,LAST_UPDATE_DATE = LNS_UTILITY_PUB.LAST_UPDATE_DATE
91: ,LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
92: ,DATA_TYPE = DECODE(P_DATA_TYPE, NULL, DATA_TYPE, FND_API.G_MISS_CHAR, NULL, P_DATA_TYPE)
93: ,OBJECT_VERSION_NUMBER = DECODE(P_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, P_OBJECT_VERSION_NUMBER)
94: ,PRIMARY_KEY_ID = DECODE(P_PRIMARY_KEY_ID, NULL, PRIMARY_KEY_ID, FND_API.G_MISS_NUM, NULL, P_PRIMARY_KEY_ID)
95: WHERE LOAN_HISTORY_ID = P_LOAN_HISTORY_ID;