eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.LNS_APPROVAL_ACTIONS_PKG dependencies on LNS_UTILITY_PUB

Line 76: ,LNS_UTILITY_PUB.LAST_UPDATE_DATE

72: ,ATTRIBUTE19
73: ,ATTRIBUTE20
74: ) VALUES (
75: DECODE(X_ACTION_ID, FND_API.G_MISS_NUM, LNS_APPROVAL_ACTIONS_S.NEXTVAL, NULL, LNS_APPROVAL_ACTIONS_S.NEXTVAL, X_ACTION_ID)
76: ,LNS_UTILITY_PUB.LAST_UPDATE_DATE
77: ,LNS_UTILITY_PUB.LAST_UPDATED_BY
78: ,LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
79: ,LNS_UTILITY_PUB.CREATION_DATE
80: ,LNS_UTILITY_PUB.CREATED_BY

Line 77: ,LNS_UTILITY_PUB.LAST_UPDATED_BY

73: ,ATTRIBUTE20
74: ) VALUES (
75: DECODE(X_ACTION_ID, FND_API.G_MISS_NUM, LNS_APPROVAL_ACTIONS_S.NEXTVAL, NULL, LNS_APPROVAL_ACTIONS_S.NEXTVAL, X_ACTION_ID)
76: ,LNS_UTILITY_PUB.LAST_UPDATE_DATE
77: ,LNS_UTILITY_PUB.LAST_UPDATED_BY
78: ,LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
79: ,LNS_UTILITY_PUB.CREATION_DATE
80: ,LNS_UTILITY_PUB.CREATED_BY
81: ,DECODE(P_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, P_OBJECT_VERSION_NUMBER)

Line 78: ,LNS_UTILITY_PUB.LAST_UPDATE_LOGIN

74: ) VALUES (
75: DECODE(X_ACTION_ID, FND_API.G_MISS_NUM, LNS_APPROVAL_ACTIONS_S.NEXTVAL, NULL, LNS_APPROVAL_ACTIONS_S.NEXTVAL, X_ACTION_ID)
76: ,LNS_UTILITY_PUB.LAST_UPDATE_DATE
77: ,LNS_UTILITY_PUB.LAST_UPDATED_BY
78: ,LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
79: ,LNS_UTILITY_PUB.CREATION_DATE
80: ,LNS_UTILITY_PUB.CREATED_BY
81: ,DECODE(P_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, P_OBJECT_VERSION_NUMBER)
82: ,DECODE(P_LOAN_ID, FND_API.G_MISS_NUM, NULL, P_LOAN_ID)

Line 79: ,LNS_UTILITY_PUB.CREATION_DATE

75: DECODE(X_ACTION_ID, FND_API.G_MISS_NUM, LNS_APPROVAL_ACTIONS_S.NEXTVAL, NULL, LNS_APPROVAL_ACTIONS_S.NEXTVAL, X_ACTION_ID)
76: ,LNS_UTILITY_PUB.LAST_UPDATE_DATE
77: ,LNS_UTILITY_PUB.LAST_UPDATED_BY
78: ,LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
79: ,LNS_UTILITY_PUB.CREATION_DATE
80: ,LNS_UTILITY_PUB.CREATED_BY
81: ,DECODE(P_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, P_OBJECT_VERSION_NUMBER)
82: ,DECODE(P_LOAN_ID, FND_API.G_MISS_NUM, NULL, P_LOAN_ID)
83: ,DECODE(P_ACTION_TYPE, FND_API.G_MISS_CHAR, NULL, P_ACTION_TYPE)

Line 80: ,LNS_UTILITY_PUB.CREATED_BY

76: ,LNS_UTILITY_PUB.LAST_UPDATE_DATE
77: ,LNS_UTILITY_PUB.LAST_UPDATED_BY
78: ,LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
79: ,LNS_UTILITY_PUB.CREATION_DATE
80: ,LNS_UTILITY_PUB.CREATED_BY
81: ,DECODE(P_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, P_OBJECT_VERSION_NUMBER)
82: ,DECODE(P_LOAN_ID, FND_API.G_MISS_NUM, NULL, P_LOAN_ID)
83: ,DECODE(P_ACTION_TYPE, FND_API.G_MISS_CHAR, NULL, P_ACTION_TYPE)
84: ,DECODE(P_AMOUNT, FND_API.G_MISS_NUM, NULL, P_AMOUNT)

Line 149: ,LAST_UPDATE_DATE = LNS_UTILITY_PUB.LAST_UPDATE_DATE

145: ) IS
146: BEGIN
147: UPDATE LNS_APPROVAL_ACTIONS SET
148: ACTION_ID = DECODE(X_ACTION_ID, NULL, ACTION_ID, FND_API.G_MISS_NUM, NULL, X_ACTION_ID)
149: ,LAST_UPDATE_DATE = LNS_UTILITY_PUB.LAST_UPDATE_DATE
150: ,LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY
151: ,LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
152: ,OBJECT_VERSION_NUMBER = DECODE(P_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, P_OBJECT_VERSION_NUMBER)
153: ,LOAN_ID = DECODE(P_LOAN_ID, NULL, LOAN_ID, FND_API.G_MISS_NUM, NULL, P_LOAN_ID)

Line 150: ,LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY

146: BEGIN
147: UPDATE LNS_APPROVAL_ACTIONS SET
148: ACTION_ID = DECODE(X_ACTION_ID, NULL, ACTION_ID, FND_API.G_MISS_NUM, NULL, X_ACTION_ID)
149: ,LAST_UPDATE_DATE = LNS_UTILITY_PUB.LAST_UPDATE_DATE
150: ,LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY
151: ,LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
152: ,OBJECT_VERSION_NUMBER = DECODE(P_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, P_OBJECT_VERSION_NUMBER)
153: ,LOAN_ID = DECODE(P_LOAN_ID, NULL, LOAN_ID, FND_API.G_MISS_NUM, NULL, P_LOAN_ID)
154: ,ACTION_TYPE = DECODE(P_ACTION_TYPE, NULL, ACTION_TYPE, FND_API.G_MISS_CHAR, NULL, P_ACTION_TYPE)

Line 151: ,LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN

147: UPDATE LNS_APPROVAL_ACTIONS SET
148: ACTION_ID = DECODE(X_ACTION_ID, NULL, ACTION_ID, FND_API.G_MISS_NUM, NULL, X_ACTION_ID)
149: ,LAST_UPDATE_DATE = LNS_UTILITY_PUB.LAST_UPDATE_DATE
150: ,LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY
151: ,LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
152: ,OBJECT_VERSION_NUMBER = DECODE(P_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, P_OBJECT_VERSION_NUMBER)
153: ,LOAN_ID = DECODE(P_LOAN_ID, NULL, LOAN_ID, FND_API.G_MISS_NUM, NULL, P_LOAN_ID)
154: ,ACTION_TYPE = DECODE(P_ACTION_TYPE, NULL, ACTION_TYPE, FND_API.G_MISS_CHAR, NULL, P_ACTION_TYPE)
155: ,AMOUNT = DECODE(P_AMOUNT, NULL, AMOUNT, FND_API.G_MISS_NUM, NULL, P_AMOUNT)