DBA Data[Home] [Help]

APPS.LNS_DISB_HEADERS_PKG dependencies on LNS_UTILITY_PUB

Line 53: ,LNS_UTILITY_PUB.CREATION_DATE

49: ,DECODE(P_STATUS, FND_API.G_MISS_CHAR, NULL, P_STATUS)
50: ,DECODE(P_TARGET_DATE, FND_API.G_MISS_DATE, NULL, P_TARGET_DATE)
51: ,DECODE(P_PAYMENT_REQUEST_DATE, FND_API.G_MISS_DATE, NULL, P_PAYMENT_REQUEST_DATE)
52: ,DECODE(P_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, P_OBJECT_VERSION_NUMBER)
53: ,LNS_UTILITY_PUB.CREATION_DATE
54: ,LNS_UTILITY_PUB.CREATED_BY
55: ,LNS_UTILITY_PUB.LAST_UPDATE_DATE
56: ,LNS_UTILITY_PUB.LAST_UPDATED_BY
57: ,LNS_UTILITY_PUB.LAST_UPDATE_LOGIN

Line 54: ,LNS_UTILITY_PUB.CREATED_BY

50: ,DECODE(P_TARGET_DATE, FND_API.G_MISS_DATE, NULL, P_TARGET_DATE)
51: ,DECODE(P_PAYMENT_REQUEST_DATE, FND_API.G_MISS_DATE, NULL, P_PAYMENT_REQUEST_DATE)
52: ,DECODE(P_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, P_OBJECT_VERSION_NUMBER)
53: ,LNS_UTILITY_PUB.CREATION_DATE
54: ,LNS_UTILITY_PUB.CREATED_BY
55: ,LNS_UTILITY_PUB.LAST_UPDATE_DATE
56: ,LNS_UTILITY_PUB.LAST_UPDATED_BY
57: ,LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
58: ,DECODE(P_AUTOFUNDING_FLAG, FND_API.G_MISS_CHAR, NULL, P_AUTOFUNDING_FLAG)

Line 55: ,LNS_UTILITY_PUB.LAST_UPDATE_DATE

51: ,DECODE(P_PAYMENT_REQUEST_DATE, FND_API.G_MISS_DATE, NULL, P_PAYMENT_REQUEST_DATE)
52: ,DECODE(P_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, P_OBJECT_VERSION_NUMBER)
53: ,LNS_UTILITY_PUB.CREATION_DATE
54: ,LNS_UTILITY_PUB.CREATED_BY
55: ,LNS_UTILITY_PUB.LAST_UPDATE_DATE
56: ,LNS_UTILITY_PUB.LAST_UPDATED_BY
57: ,LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
58: ,DECODE(P_AUTOFUNDING_FLAG, FND_API.G_MISS_CHAR, NULL, P_AUTOFUNDING_FLAG)
59: ) RETURNING

Line 56: ,LNS_UTILITY_PUB.LAST_UPDATED_BY

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

Line 57: ,LNS_UTILITY_PUB.LAST_UPDATE_LOGIN

53: ,LNS_UTILITY_PUB.CREATION_DATE
54: ,LNS_UTILITY_PUB.CREATED_BY
55: ,LNS_UTILITY_PUB.LAST_UPDATE_DATE
56: ,LNS_UTILITY_PUB.LAST_UPDATED_BY
57: ,LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
58: ,DECODE(P_AUTOFUNDING_FLAG, FND_API.G_MISS_CHAR, NULL, P_AUTOFUNDING_FLAG)
59: ) RETURNING
60: DISB_HEADER_ID
61: INTO

Line 93: ,LAST_UPDATE_DATE = LNS_UTILITY_PUB.LAST_UPDATE_DATE

89: ,STATUS = DECODE(P_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, NULL, P_STATUS)
90: ,TARGET_DATE = DECODE(P_TARGET_DATE, NULL, TARGET_DATE, FND_API.G_MISS_DATE, NULL, P_TARGET_DATE)
91: ,PAYMENT_REQUEST_DATE = DECODE(P_PAYMENT_REQUEST_DATE, NULL, PAYMENT_REQUEST_DATE, FND_API.G_MISS_DATE, NULL, P_PAYMENT_REQUEST_DATE)
92: ,OBJECT_VERSION_NUMBER = DECODE(P_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, P_OBJECT_VERSION_NUMBER)
93: ,LAST_UPDATE_DATE = LNS_UTILITY_PUB.LAST_UPDATE_DATE
94: ,LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY
95: ,LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
96: ,AUTOFUNDING_FLAG = DECODE(P_AUTOFUNDING_FLAG, NULL, AUTOFUNDING_FLAG, FND_API.G_MISS_CHAR, NULL, P_AUTOFUNDING_FLAG)
97: WHERE DISB_HEADER_ID = P_DISB_HEADER_ID;

Line 94: ,LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY

90: ,TARGET_DATE = DECODE(P_TARGET_DATE, NULL, TARGET_DATE, FND_API.G_MISS_DATE, NULL, P_TARGET_DATE)
91: ,PAYMENT_REQUEST_DATE = DECODE(P_PAYMENT_REQUEST_DATE, NULL, PAYMENT_REQUEST_DATE, FND_API.G_MISS_DATE, NULL, P_PAYMENT_REQUEST_DATE)
92: ,OBJECT_VERSION_NUMBER = DECODE(P_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, P_OBJECT_VERSION_NUMBER)
93: ,LAST_UPDATE_DATE = LNS_UTILITY_PUB.LAST_UPDATE_DATE
94: ,LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY
95: ,LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
96: ,AUTOFUNDING_FLAG = DECODE(P_AUTOFUNDING_FLAG, NULL, AUTOFUNDING_FLAG, FND_API.G_MISS_CHAR, NULL, P_AUTOFUNDING_FLAG)
97: WHERE DISB_HEADER_ID = P_DISB_HEADER_ID;
98:

Line 95: ,LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN

91: ,PAYMENT_REQUEST_DATE = DECODE(P_PAYMENT_REQUEST_DATE, NULL, PAYMENT_REQUEST_DATE, FND_API.G_MISS_DATE, NULL, P_PAYMENT_REQUEST_DATE)
92: ,OBJECT_VERSION_NUMBER = DECODE(P_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, P_OBJECT_VERSION_NUMBER)
93: ,LAST_UPDATE_DATE = LNS_UTILITY_PUB.LAST_UPDATE_DATE
94: ,LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY
95: ,LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
96: ,AUTOFUNDING_FLAG = DECODE(P_AUTOFUNDING_FLAG, NULL, AUTOFUNDING_FLAG, FND_API.G_MISS_CHAR, NULL, P_AUTOFUNDING_FLAG)
97: WHERE DISB_HEADER_ID = P_DISB_HEADER_ID;
98:
99: if (sql%notfound) then