DBA Data[Home] [Help]

APPS.LNS_FEE_ASSIGNMENTS_PKG dependencies on LNS_FEE_ASSIGNMENTS_S

Line 57: 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)

53: ,END_DATE_ACTIVE
54: ,DISB_HEADER_ID
55: ,DELETE_DISABLED_FLAG
56: ) VALUES (
57: 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)
58: ,DECODE(P_LOAN_ID, FND_API.G_MISS_NUM, NULL, P_LOAN_ID)
59: ,DECODE(P_FEE_ID, FND_API.G_MISS_NUM, NULL, P_FEE_ID)
60: ,DECODE(P_FEE_TYPE, FND_API.G_MISS_CHAR, NULL, P_FEE_TYPE)
61: ,DECODE(P_FEE, FND_API.G_MISS_NUM, NULL, P_FEE)

Line 111: UPDATE LNS_FEE_ASSIGNMENTS SET

107: ,P_DISB_HEADER_ID IN NUMBER
108: ,P_DELETE_DISABLED_FLAG IN VARCHAR2
109: ) IS
110: BEGIN
111: UPDATE LNS_FEE_ASSIGNMENTS SET
112: LOAN_ID = DECODE(P_LOAN_ID, NULL, LOAN_ID, FND_API.G_MISS_NUM, NULL, P_LOAN_ID)
113: ,FEE_ID = DECODE(P_FEE_ID, NULL, FEE_ID, FND_API.G_MISS_NUM, NULL, P_FEE_ID)
114: ,FEE_TYPE = DECODE(P_FEE_TYPE, NULL, FEE_TYPE, FND_API.G_MISS_CHAR, NULL, P_FEE_TYPE)
115: ,FEE = DECODE(P_FEE, NULL, FEE, FND_API.G_MISS_NUM, NULL, P_FEE)