DBA Data[Home] [Help]

APPS.LNS_FEE_ASSIGNMENTS_PKG dependencies on LNS_FEE_ASSIGNMENTS_S

Line 63: DECODE(X_FEE_ASSIGNMENT_ID, FND_API.G_MISS_NUM, LNS_FEE_ASSIGNMENTS_S.NEXTVAL, NULL, LNS_FEE_ASSIGNMENTS_S.NEXTVAL, X_FEE_ASSIGNMENT_ID)

59: ,OPEN_PHASE_FLAG
60: ,PHASE
61: ,CUSTOM_PROCEDURE
62: ) VALUES (
63: DECODE(X_FEE_ASSIGNMENT_ID, FND_API.G_MISS_NUM, LNS_FEE_ASSIGNMENTS_S.NEXTVAL, NULL, LNS_FEE_ASSIGNMENTS_S.NEXTVAL, X_FEE_ASSIGNMENT_ID)
64: ,DECODE(P_LOAN_ID, FND_API.G_MISS_NUM, NULL, P_LOAN_ID)
65: ,DECODE(P_FEE_ID, FND_API.G_MISS_NUM, NULL, P_FEE_ID)
66: ,DECODE(P_FEE_TYPE, FND_API.G_MISS_CHAR, NULL, P_FEE_TYPE)
67: ,DECODE(P_FEE, FND_API.G_MISS_NUM, NULL, P_FEE)

Line 123: UPDATE LNS_FEE_ASSIGNMENTS SET

119: ,P_PHASE IN VARCHAR2
120: ,P_CUSTOM_PROCEDURE IN VARCHAR2
121: ) IS
122: BEGIN
123: UPDATE LNS_FEE_ASSIGNMENTS SET
124: LOAN_ID = DECODE(P_LOAN_ID, NULL, LOAN_ID, FND_API.G_MISS_NUM, NULL, P_LOAN_ID)
125: ,FEE_ID = DECODE(P_FEE_ID, NULL, FEE_ID, FND_API.G_MISS_NUM, NULL, P_FEE_ID)
126: ,FEE_TYPE = DECODE(P_FEE_TYPE, NULL, FEE_TYPE, FND_API.G_MISS_CHAR, NULL, P_FEE_TYPE)
127: ,FEE = DECODE(P_FEE, NULL, FEE, FND_API.G_MISS_NUM, NULL, P_FEE)