DBA Data[Home] [Help]

APPS.LNS_DISB_HEADERS_PKG dependencies on LNS_UTILITY_PUB

Line 57: ,LNS_UTILITY_PUB.CREATION_DATE

53: ,DECODE(P_STATUS, FND_API.G_MISS_CHAR, NULL, P_STATUS)
54: ,DECODE(P_TARGET_DATE, FND_API.G_MISS_DATE, NULL, P_TARGET_DATE)
55: ,DECODE(P_PAYMENT_REQUEST_DATE, FND_API.G_MISS_DATE, NULL, P_PAYMENT_REQUEST_DATE)
56: ,DECODE(P_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, P_OBJECT_VERSION_NUMBER)
57: ,LNS_UTILITY_PUB.CREATION_DATE
58: ,LNS_UTILITY_PUB.CREATED_BY
59: ,LNS_UTILITY_PUB.LAST_UPDATE_DATE
60: ,LNS_UTILITY_PUB.LAST_UPDATED_BY
61: ,LNS_UTILITY_PUB.LAST_UPDATE_LOGIN

Line 58: ,LNS_UTILITY_PUB.CREATED_BY

54: ,DECODE(P_TARGET_DATE, FND_API.G_MISS_DATE, NULL, P_TARGET_DATE)
55: ,DECODE(P_PAYMENT_REQUEST_DATE, FND_API.G_MISS_DATE, NULL, P_PAYMENT_REQUEST_DATE)
56: ,DECODE(P_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, P_OBJECT_VERSION_NUMBER)
57: ,LNS_UTILITY_PUB.CREATION_DATE
58: ,LNS_UTILITY_PUB.CREATED_BY
59: ,LNS_UTILITY_PUB.LAST_UPDATE_DATE
60: ,LNS_UTILITY_PUB.LAST_UPDATED_BY
61: ,LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
62: ,DECODE(P_AUTOFUNDING_FLAG, FND_API.G_MISS_CHAR, NULL, P_AUTOFUNDING_FLAG)

Line 59: ,LNS_UTILITY_PUB.LAST_UPDATE_DATE

55: ,DECODE(P_PAYMENT_REQUEST_DATE, FND_API.G_MISS_DATE, NULL, P_PAYMENT_REQUEST_DATE)
56: ,DECODE(P_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, P_OBJECT_VERSION_NUMBER)
57: ,LNS_UTILITY_PUB.CREATION_DATE
58: ,LNS_UTILITY_PUB.CREATED_BY
59: ,LNS_UTILITY_PUB.LAST_UPDATE_DATE
60: ,LNS_UTILITY_PUB.LAST_UPDATED_BY
61: ,LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
62: ,DECODE(P_AUTOFUNDING_FLAG, FND_API.G_MISS_CHAR, NULL, P_AUTOFUNDING_FLAG)
63: ,DECODE(P_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, P_DESCRIPTION)

Line 60: ,LNS_UTILITY_PUB.LAST_UPDATED_BY

56: ,DECODE(P_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, P_OBJECT_VERSION_NUMBER)
57: ,LNS_UTILITY_PUB.CREATION_DATE
58: ,LNS_UTILITY_PUB.CREATED_BY
59: ,LNS_UTILITY_PUB.LAST_UPDATE_DATE
60: ,LNS_UTILITY_PUB.LAST_UPDATED_BY
61: ,LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
62: ,DECODE(P_AUTOFUNDING_FLAG, FND_API.G_MISS_CHAR, NULL, P_AUTOFUNDING_FLAG)
63: ,DECODE(P_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, P_DESCRIPTION)
64: ,DECODE(P_PHASE, FND_API.G_MISS_CHAR, NULL, P_PHASE)

Line 61: ,LNS_UTILITY_PUB.LAST_UPDATE_LOGIN

57: ,LNS_UTILITY_PUB.CREATION_DATE
58: ,LNS_UTILITY_PUB.CREATED_BY
59: ,LNS_UTILITY_PUB.LAST_UPDATE_DATE
60: ,LNS_UTILITY_PUB.LAST_UPDATED_BY
61: ,LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
62: ,DECODE(P_AUTOFUNDING_FLAG, FND_API.G_MISS_CHAR, NULL, P_AUTOFUNDING_FLAG)
63: ,DECODE(P_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, P_DESCRIPTION)
64: ,DECODE(P_PHASE, FND_API.G_MISS_CHAR, NULL, P_PHASE)
65: ) RETURNING

Line 101: ,LAST_UPDATE_DATE = LNS_UTILITY_PUB.LAST_UPDATE_DATE

97: ,STATUS = DECODE(P_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, NULL, P_STATUS)
98: ,TARGET_DATE = DECODE(P_TARGET_DATE, NULL, TARGET_DATE, FND_API.G_MISS_DATE, NULL, P_TARGET_DATE)
99: ,PAYMENT_REQUEST_DATE = DECODE(P_PAYMENT_REQUEST_DATE, NULL, PAYMENT_REQUEST_DATE, FND_API.G_MISS_DATE, NULL, P_PAYMENT_REQUEST_DATE)
100: ,OBJECT_VERSION_NUMBER = DECODE(P_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, P_OBJECT_VERSION_NUMBER)
101: ,LAST_UPDATE_DATE = LNS_UTILITY_PUB.LAST_UPDATE_DATE
102: ,LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY
103: ,LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
104: ,AUTOFUNDING_FLAG = DECODE(P_AUTOFUNDING_FLAG, NULL, AUTOFUNDING_FLAG, FND_API.G_MISS_CHAR, NULL, P_AUTOFUNDING_FLAG)
105: ,DESCRIPTION = DECODE(P_DESCRIPTION, NULL, DESCRIPTION, FND_API.G_MISS_CHAR, NULL, P_DESCRIPTION)

Line 102: ,LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY

98: ,TARGET_DATE = DECODE(P_TARGET_DATE, NULL, TARGET_DATE, FND_API.G_MISS_DATE, NULL, P_TARGET_DATE)
99: ,PAYMENT_REQUEST_DATE = DECODE(P_PAYMENT_REQUEST_DATE, NULL, PAYMENT_REQUEST_DATE, FND_API.G_MISS_DATE, NULL, P_PAYMENT_REQUEST_DATE)
100: ,OBJECT_VERSION_NUMBER = DECODE(P_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, P_OBJECT_VERSION_NUMBER)
101: ,LAST_UPDATE_DATE = LNS_UTILITY_PUB.LAST_UPDATE_DATE
102: ,LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY
103: ,LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
104: ,AUTOFUNDING_FLAG = DECODE(P_AUTOFUNDING_FLAG, NULL, AUTOFUNDING_FLAG, FND_API.G_MISS_CHAR, NULL, P_AUTOFUNDING_FLAG)
105: ,DESCRIPTION = DECODE(P_DESCRIPTION, NULL, DESCRIPTION, FND_API.G_MISS_CHAR, NULL, P_DESCRIPTION)
106: ,PHASE = DECODE(P_PHASE, NULL, PHASE, FND_API.G_MISS_CHAR, NULL, P_PHASE)

Line 103: ,LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN

99: ,PAYMENT_REQUEST_DATE = DECODE(P_PAYMENT_REQUEST_DATE, NULL, PAYMENT_REQUEST_DATE, FND_API.G_MISS_DATE, NULL, P_PAYMENT_REQUEST_DATE)
100: ,OBJECT_VERSION_NUMBER = DECODE(P_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, P_OBJECT_VERSION_NUMBER)
101: ,LAST_UPDATE_DATE = LNS_UTILITY_PUB.LAST_UPDATE_DATE
102: ,LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY
103: ,LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
104: ,AUTOFUNDING_FLAG = DECODE(P_AUTOFUNDING_FLAG, NULL, AUTOFUNDING_FLAG, FND_API.G_MISS_CHAR, NULL, P_AUTOFUNDING_FLAG)
105: ,DESCRIPTION = DECODE(P_DESCRIPTION, NULL, DESCRIPTION, FND_API.G_MISS_CHAR, NULL, P_DESCRIPTION)
106: ,PHASE = DECODE(P_PHASE, NULL, PHASE, FND_API.G_MISS_CHAR, NULL, P_PHASE)
107: WHERE DISB_HEADER_ID = P_DISB_HEADER_ID;