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_FEE_SCHEDULES_PKG dependencies on FND_API

Line 51: DECODE(X_FEE_SCHEDULE_ID, FND_API.G_MISS_NUM,

47: ,OBJECT_VERSION_NUMBER
48: ,DISB_HEADER_ID
49: ,PHASE
50: ) VALUES (
51: DECODE(X_FEE_SCHEDULE_ID, FND_API.G_MISS_NUM,
52: LNS_FEE_SCHEDULE_S.NEXTVAL, NULL, LNS_FEE_SCHEDULE_S.NEXTVAL, X_FEE_SCHEDULE_ID)
53: ,DECODE(P_FEE_ID, FND_API.G_MISS_NUM, NULL, P_FEE_ID)
54: ,DECODE(P_LOAN_ID, FND_API.G_MISS_NUM, NULL, P_LOAN_ID)
55: ,DECODE(P_FEE_AMOUNT, FND_API.G_MISS_NUM, NULL, P_FEE_AMOUNT)

Line 53: ,DECODE(P_FEE_ID, FND_API.G_MISS_NUM, NULL, P_FEE_ID)

49: ,PHASE
50: ) VALUES (
51: DECODE(X_FEE_SCHEDULE_ID, FND_API.G_MISS_NUM,
52: LNS_FEE_SCHEDULE_S.NEXTVAL, NULL, LNS_FEE_SCHEDULE_S.NEXTVAL, X_FEE_SCHEDULE_ID)
53: ,DECODE(P_FEE_ID, FND_API.G_MISS_NUM, NULL, P_FEE_ID)
54: ,DECODE(P_LOAN_ID, FND_API.G_MISS_NUM, NULL, P_LOAN_ID)
55: ,DECODE(P_FEE_AMOUNT, FND_API.G_MISS_NUM, NULL, P_FEE_AMOUNT)
56: ,DECODE(P_FEE_INSTALLMENT, FND_API.G_MISS_NUM, NULL,
57: P_FEE_INSTALLMENT)

Line 54: ,DECODE(P_LOAN_ID, FND_API.G_MISS_NUM, NULL, P_LOAN_ID)

50: ) VALUES (
51: DECODE(X_FEE_SCHEDULE_ID, FND_API.G_MISS_NUM,
52: LNS_FEE_SCHEDULE_S.NEXTVAL, NULL, LNS_FEE_SCHEDULE_S.NEXTVAL, X_FEE_SCHEDULE_ID)
53: ,DECODE(P_FEE_ID, FND_API.G_MISS_NUM, NULL, P_FEE_ID)
54: ,DECODE(P_LOAN_ID, FND_API.G_MISS_NUM, NULL, P_LOAN_ID)
55: ,DECODE(P_FEE_AMOUNT, FND_API.G_MISS_NUM, NULL, P_FEE_AMOUNT)
56: ,DECODE(P_FEE_INSTALLMENT, FND_API.G_MISS_NUM, NULL,
57: P_FEE_INSTALLMENT)
58: ,DECODE(P_FEE_DESCRIPTION, FND_API.G_MISS_CHAR, NULL,

Line 55: ,DECODE(P_FEE_AMOUNT, FND_API.G_MISS_NUM, NULL, P_FEE_AMOUNT)

51: DECODE(X_FEE_SCHEDULE_ID, FND_API.G_MISS_NUM,
52: LNS_FEE_SCHEDULE_S.NEXTVAL, NULL, LNS_FEE_SCHEDULE_S.NEXTVAL, X_FEE_SCHEDULE_ID)
53: ,DECODE(P_FEE_ID, FND_API.G_MISS_NUM, NULL, P_FEE_ID)
54: ,DECODE(P_LOAN_ID, FND_API.G_MISS_NUM, NULL, P_LOAN_ID)
55: ,DECODE(P_FEE_AMOUNT, FND_API.G_MISS_NUM, NULL, P_FEE_AMOUNT)
56: ,DECODE(P_FEE_INSTALLMENT, FND_API.G_MISS_NUM, NULL,
57: P_FEE_INSTALLMENT)
58: ,DECODE(P_FEE_DESCRIPTION, FND_API.G_MISS_CHAR, NULL,
59: P_FEE_DESCRIPTION)

Line 56: ,DECODE(P_FEE_INSTALLMENT, FND_API.G_MISS_NUM, NULL,

52: LNS_FEE_SCHEDULE_S.NEXTVAL, NULL, LNS_FEE_SCHEDULE_S.NEXTVAL, X_FEE_SCHEDULE_ID)
53: ,DECODE(P_FEE_ID, FND_API.G_MISS_NUM, NULL, P_FEE_ID)
54: ,DECODE(P_LOAN_ID, FND_API.G_MISS_NUM, NULL, P_LOAN_ID)
55: ,DECODE(P_FEE_AMOUNT, FND_API.G_MISS_NUM, NULL, P_FEE_AMOUNT)
56: ,DECODE(P_FEE_INSTALLMENT, FND_API.G_MISS_NUM, NULL,
57: P_FEE_INSTALLMENT)
58: ,DECODE(P_FEE_DESCRIPTION, FND_API.G_MISS_CHAR, NULL,
59: P_FEE_DESCRIPTION)
60: ,DECODE(P_ACTIVE_FLAG, FND_API.G_MISS_CHAR, NULL, P_ACTIVE_FLAG)

Line 58: ,DECODE(P_FEE_DESCRIPTION, FND_API.G_MISS_CHAR, NULL,

54: ,DECODE(P_LOAN_ID, FND_API.G_MISS_NUM, NULL, P_LOAN_ID)
55: ,DECODE(P_FEE_AMOUNT, FND_API.G_MISS_NUM, NULL, P_FEE_AMOUNT)
56: ,DECODE(P_FEE_INSTALLMENT, FND_API.G_MISS_NUM, NULL,
57: P_FEE_INSTALLMENT)
58: ,DECODE(P_FEE_DESCRIPTION, FND_API.G_MISS_CHAR, NULL,
59: P_FEE_DESCRIPTION)
60: ,DECODE(P_ACTIVE_FLAG, FND_API.G_MISS_CHAR, NULL, P_ACTIVE_FLAG)
61: ,DECODE(P_BILLED_FLAG, FND_API.G_MISS_CHAR, NULL, P_BILLED_FLAG)
62: ,DECODE(P_FEE_WAIVABLE_FLAG, FND_API.G_MISS_CHAR, NULL,

Line 60: ,DECODE(P_ACTIVE_FLAG, FND_API.G_MISS_CHAR, NULL, P_ACTIVE_FLAG)

56: ,DECODE(P_FEE_INSTALLMENT, FND_API.G_MISS_NUM, NULL,
57: P_FEE_INSTALLMENT)
58: ,DECODE(P_FEE_DESCRIPTION, FND_API.G_MISS_CHAR, NULL,
59: P_FEE_DESCRIPTION)
60: ,DECODE(P_ACTIVE_FLAG, FND_API.G_MISS_CHAR, NULL, P_ACTIVE_FLAG)
61: ,DECODE(P_BILLED_FLAG, FND_API.G_MISS_CHAR, NULL, P_BILLED_FLAG)
62: ,DECODE(P_FEE_WAIVABLE_FLAG, FND_API.G_MISS_CHAR, NULL,
63: P_FEE_WAIVABLE_FLAG)
64: ,DECODE(P_WAIVED_AMOUNT, FND_API.G_MISS_NUM, NULL,

Line 61: ,DECODE(P_BILLED_FLAG, FND_API.G_MISS_CHAR, NULL, P_BILLED_FLAG)

57: P_FEE_INSTALLMENT)
58: ,DECODE(P_FEE_DESCRIPTION, FND_API.G_MISS_CHAR, NULL,
59: P_FEE_DESCRIPTION)
60: ,DECODE(P_ACTIVE_FLAG, FND_API.G_MISS_CHAR, NULL, P_ACTIVE_FLAG)
61: ,DECODE(P_BILLED_FLAG, FND_API.G_MISS_CHAR, NULL, P_BILLED_FLAG)
62: ,DECODE(P_FEE_WAIVABLE_FLAG, FND_API.G_MISS_CHAR, NULL,
63: P_FEE_WAIVABLE_FLAG)
64: ,DECODE(P_WAIVED_AMOUNT, FND_API.G_MISS_NUM, NULL,
65: P_WAIVED_AMOUNT)

Line 62: ,DECODE(P_FEE_WAIVABLE_FLAG, FND_API.G_MISS_CHAR, NULL,

58: ,DECODE(P_FEE_DESCRIPTION, FND_API.G_MISS_CHAR, NULL,
59: P_FEE_DESCRIPTION)
60: ,DECODE(P_ACTIVE_FLAG, FND_API.G_MISS_CHAR, NULL, P_ACTIVE_FLAG)
61: ,DECODE(P_BILLED_FLAG, FND_API.G_MISS_CHAR, NULL, P_BILLED_FLAG)
62: ,DECODE(P_FEE_WAIVABLE_FLAG, FND_API.G_MISS_CHAR, NULL,
63: P_FEE_WAIVABLE_FLAG)
64: ,DECODE(P_WAIVED_AMOUNT, FND_API.G_MISS_NUM, NULL,
65: P_WAIVED_AMOUNT)
66: ,LNS_UTILITY_PUB.CREATED_BY

Line 64: ,DECODE(P_WAIVED_AMOUNT, FND_API.G_MISS_NUM, NULL,

60: ,DECODE(P_ACTIVE_FLAG, FND_API.G_MISS_CHAR, NULL, P_ACTIVE_FLAG)
61: ,DECODE(P_BILLED_FLAG, FND_API.G_MISS_CHAR, NULL, P_BILLED_FLAG)
62: ,DECODE(P_FEE_WAIVABLE_FLAG, FND_API.G_MISS_CHAR, NULL,
63: P_FEE_WAIVABLE_FLAG)
64: ,DECODE(P_WAIVED_AMOUNT, FND_API.G_MISS_NUM, NULL,
65: P_WAIVED_AMOUNT)
66: ,LNS_UTILITY_PUB.CREATED_BY
67: ,LNS_UTILITY_PUB.CREATION_DATE
68: ,LNS_UTILITY_PUB.LAST_UPDATED_BY

Line 71: ,DECODE(P_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, P_PROGRAM_ID)

67: ,LNS_UTILITY_PUB.CREATION_DATE
68: ,LNS_UTILITY_PUB.LAST_UPDATED_BY
69: ,LNS_UTILITY_PUB.LAST_UPDATE_DATE
70: ,LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
71: ,DECODE(P_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, P_PROGRAM_ID)
72: ,DECODE(P_REQUEST_ID, FND_API.G_MISS_NUM, NULL, P_REQUEST_ID)
73: ,DECODE(P_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL,
74: P_OBJECT_VERSION_NUMBER)
75: ,DECODE(P_DISB_HEADER_ID, FND_API.G_MISS_NUM, NULL,

Line 72: ,DECODE(P_REQUEST_ID, FND_API.G_MISS_NUM, NULL, P_REQUEST_ID)

68: ,LNS_UTILITY_PUB.LAST_UPDATED_BY
69: ,LNS_UTILITY_PUB.LAST_UPDATE_DATE
70: ,LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
71: ,DECODE(P_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, P_PROGRAM_ID)
72: ,DECODE(P_REQUEST_ID, FND_API.G_MISS_NUM, NULL, P_REQUEST_ID)
73: ,DECODE(P_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL,
74: P_OBJECT_VERSION_NUMBER)
75: ,DECODE(P_DISB_HEADER_ID, FND_API.G_MISS_NUM, NULL,
76: P_DISB_HEADER_ID)

Line 73: ,DECODE(P_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL,

69: ,LNS_UTILITY_PUB.LAST_UPDATE_DATE
70: ,LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
71: ,DECODE(P_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, P_PROGRAM_ID)
72: ,DECODE(P_REQUEST_ID, FND_API.G_MISS_NUM, NULL, P_REQUEST_ID)
73: ,DECODE(P_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL,
74: P_OBJECT_VERSION_NUMBER)
75: ,DECODE(P_DISB_HEADER_ID, FND_API.G_MISS_NUM, NULL,
76: P_DISB_HEADER_ID)
77: ,DECODE(P_PHASE, FND_API.G_MISS_CHAR, NULL, P_PHASE)

Line 75: ,DECODE(P_DISB_HEADER_ID, FND_API.G_MISS_NUM, NULL,

71: ,DECODE(P_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, P_PROGRAM_ID)
72: ,DECODE(P_REQUEST_ID, FND_API.G_MISS_NUM, NULL, P_REQUEST_ID)
73: ,DECODE(P_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL,
74: P_OBJECT_VERSION_NUMBER)
75: ,DECODE(P_DISB_HEADER_ID, FND_API.G_MISS_NUM, NULL,
76: P_DISB_HEADER_ID)
77: ,DECODE(P_PHASE, FND_API.G_MISS_CHAR, NULL, P_PHASE)
78: ) RETURNING
79: FEE_SCHEDULE_ID

Line 77: ,DECODE(P_PHASE, FND_API.G_MISS_CHAR, NULL, P_PHASE)

73: ,DECODE(P_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL,
74: P_OBJECT_VERSION_NUMBER)
75: ,DECODE(P_DISB_HEADER_ID, FND_API.G_MISS_NUM, NULL,
76: P_DISB_HEADER_ID)
77: ,DECODE(P_PHASE, FND_API.G_MISS_CHAR, NULL, P_PHASE)
78: ) RETURNING
79: FEE_SCHEDULE_ID
80: INTO
81: X_FEE_SCHEDULE_ID;

Line 107: FEE_ID = DECODE(P_FEE_ID, NULL, FEE_ID, FND_API.G_MISS_NUM,

103: ,P_PHASE IN VARCHAR2
104: ) IS
105: BEGIN
106: UPDATE LNS_FEE_SCHEDULES SET
107: FEE_ID = DECODE(P_FEE_ID, NULL, FEE_ID, FND_API.G_MISS_NUM,
108: NULL, P_FEE_ID)
109: ,LOAN_ID = DECODE(P_LOAN_ID, NULL, LOAN_ID, FND_API.G_MISS_NUM,
110: NULL, P_LOAN_ID)
111: ,FEE_AMOUNT = DECODE(P_FEE_AMOUNT, NULL, FEE_AMOUNT,

Line 109: ,LOAN_ID = DECODE(P_LOAN_ID, NULL, LOAN_ID, FND_API.G_MISS_NUM,

105: BEGIN
106: UPDATE LNS_FEE_SCHEDULES SET
107: FEE_ID = DECODE(P_FEE_ID, NULL, FEE_ID, FND_API.G_MISS_NUM,
108: NULL, P_FEE_ID)
109: ,LOAN_ID = DECODE(P_LOAN_ID, NULL, LOAN_ID, FND_API.G_MISS_NUM,
110: NULL, P_LOAN_ID)
111: ,FEE_AMOUNT = DECODE(P_FEE_AMOUNT, NULL, FEE_AMOUNT,
112: FND_API.G_MISS_NUM, NULL, P_FEE_AMOUNT)
113: ,FEE_INSTALLMENT = DECODE(P_FEE_INSTALLMENT, NULL,

Line 112: FND_API.G_MISS_NUM, NULL, P_FEE_AMOUNT)

108: NULL, P_FEE_ID)
109: ,LOAN_ID = DECODE(P_LOAN_ID, NULL, LOAN_ID, FND_API.G_MISS_NUM,
110: NULL, P_LOAN_ID)
111: ,FEE_AMOUNT = DECODE(P_FEE_AMOUNT, NULL, FEE_AMOUNT,
112: FND_API.G_MISS_NUM, NULL, P_FEE_AMOUNT)
113: ,FEE_INSTALLMENT = DECODE(P_FEE_INSTALLMENT, NULL,
114: FEE_INSTALLMENT, FND_API.G_MISS_NUM, NULL, P_FEE_INSTALLMENT)
115: ,FEE_DESCRIPTION = DECODE(P_FEE_DESCRIPTION, NULL,
116: FEE_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, P_FEE_DESCRIPTION)

Line 114: FEE_INSTALLMENT, FND_API.G_MISS_NUM, NULL, P_FEE_INSTALLMENT)

110: NULL, P_LOAN_ID)
111: ,FEE_AMOUNT = DECODE(P_FEE_AMOUNT, NULL, FEE_AMOUNT,
112: FND_API.G_MISS_NUM, NULL, P_FEE_AMOUNT)
113: ,FEE_INSTALLMENT = DECODE(P_FEE_INSTALLMENT, NULL,
114: FEE_INSTALLMENT, FND_API.G_MISS_NUM, NULL, P_FEE_INSTALLMENT)
115: ,FEE_DESCRIPTION = DECODE(P_FEE_DESCRIPTION, NULL,
116: FEE_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, P_FEE_DESCRIPTION)
117: ,ACTIVE_FLAG = DECODE(P_ACTIVE_FLAG, NULL, ACTIVE_FLAG,
118: FND_API.G_MISS_CHAR, NULL, P_ACTIVE_FLAG)

Line 116: FEE_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, P_FEE_DESCRIPTION)

112: FND_API.G_MISS_NUM, NULL, P_FEE_AMOUNT)
113: ,FEE_INSTALLMENT = DECODE(P_FEE_INSTALLMENT, NULL,
114: FEE_INSTALLMENT, FND_API.G_MISS_NUM, NULL, P_FEE_INSTALLMENT)
115: ,FEE_DESCRIPTION = DECODE(P_FEE_DESCRIPTION, NULL,
116: FEE_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, P_FEE_DESCRIPTION)
117: ,ACTIVE_FLAG = DECODE(P_ACTIVE_FLAG, NULL, ACTIVE_FLAG,
118: FND_API.G_MISS_CHAR, NULL, P_ACTIVE_FLAG)
119: ,BILLED_FLAG = DECODE(P_BILLED_FLAG, NULL, BILLED_FLAG,
120: FND_API.G_MISS_CHAR, NULL, P_BILLED_FLAG)

Line 118: FND_API.G_MISS_CHAR, NULL, P_ACTIVE_FLAG)

114: FEE_INSTALLMENT, FND_API.G_MISS_NUM, NULL, P_FEE_INSTALLMENT)
115: ,FEE_DESCRIPTION = DECODE(P_FEE_DESCRIPTION, NULL,
116: FEE_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, P_FEE_DESCRIPTION)
117: ,ACTIVE_FLAG = DECODE(P_ACTIVE_FLAG, NULL, ACTIVE_FLAG,
118: FND_API.G_MISS_CHAR, NULL, P_ACTIVE_FLAG)
119: ,BILLED_FLAG = DECODE(P_BILLED_FLAG, NULL, BILLED_FLAG,
120: FND_API.G_MISS_CHAR, NULL, P_BILLED_FLAG)
121: ,FEE_WAIVABLE_FLAG = DECODE(P_FEE_WAIVABLE_FLAG, NULL,
122: FEE_WAIVABLE_FLAG, FND_API.G_MISS_CHAR, NULL, P_FEE_WAIVABLE_FLAG)

Line 120: FND_API.G_MISS_CHAR, NULL, P_BILLED_FLAG)

116: FEE_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, P_FEE_DESCRIPTION)
117: ,ACTIVE_FLAG = DECODE(P_ACTIVE_FLAG, NULL, ACTIVE_FLAG,
118: FND_API.G_MISS_CHAR, NULL, P_ACTIVE_FLAG)
119: ,BILLED_FLAG = DECODE(P_BILLED_FLAG, NULL, BILLED_FLAG,
120: FND_API.G_MISS_CHAR, NULL, P_BILLED_FLAG)
121: ,FEE_WAIVABLE_FLAG = DECODE(P_FEE_WAIVABLE_FLAG, NULL,
122: FEE_WAIVABLE_FLAG, FND_API.G_MISS_CHAR, NULL, P_FEE_WAIVABLE_FLAG)
123: ,WAIVED_AMOUNT = DECODE(P_WAIVED_AMOUNT, NULL, WAIVED_AMOUNT,
124: FND_API.G_MISS_NUM, NULL, P_WAIVED_AMOUNT)

Line 122: FEE_WAIVABLE_FLAG, FND_API.G_MISS_CHAR, NULL, P_FEE_WAIVABLE_FLAG)

118: FND_API.G_MISS_CHAR, NULL, P_ACTIVE_FLAG)
119: ,BILLED_FLAG = DECODE(P_BILLED_FLAG, NULL, BILLED_FLAG,
120: FND_API.G_MISS_CHAR, NULL, P_BILLED_FLAG)
121: ,FEE_WAIVABLE_FLAG = DECODE(P_FEE_WAIVABLE_FLAG, NULL,
122: FEE_WAIVABLE_FLAG, FND_API.G_MISS_CHAR, NULL, P_FEE_WAIVABLE_FLAG)
123: ,WAIVED_AMOUNT = DECODE(P_WAIVED_AMOUNT, NULL, WAIVED_AMOUNT,
124: FND_API.G_MISS_NUM, NULL, P_WAIVED_AMOUNT)
125: ,LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY
126: ,LAST_UPDATE_DATE = LNS_UTILITY_PUB.LAST_UPDATE_DATE

Line 124: FND_API.G_MISS_NUM, NULL, P_WAIVED_AMOUNT)

120: FND_API.G_MISS_CHAR, NULL, P_BILLED_FLAG)
121: ,FEE_WAIVABLE_FLAG = DECODE(P_FEE_WAIVABLE_FLAG, NULL,
122: FEE_WAIVABLE_FLAG, FND_API.G_MISS_CHAR, NULL, P_FEE_WAIVABLE_FLAG)
123: ,WAIVED_AMOUNT = DECODE(P_WAIVED_AMOUNT, NULL, WAIVED_AMOUNT,
124: FND_API.G_MISS_NUM, NULL, P_WAIVED_AMOUNT)
125: ,LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY
126: ,LAST_UPDATE_DATE = LNS_UTILITY_PUB.LAST_UPDATE_DATE
127: ,LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
128: ,PROGRAM_ID = DECODE(P_PROGRAM_ID, NULL, PROGRAM_ID,

Line 129: FND_API.G_MISS_NUM, NULL, P_PROGRAM_ID)

125: ,LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY
126: ,LAST_UPDATE_DATE = LNS_UTILITY_PUB.LAST_UPDATE_DATE
127: ,LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
128: ,PROGRAM_ID = DECODE(P_PROGRAM_ID, NULL, PROGRAM_ID,
129: FND_API.G_MISS_NUM, NULL, P_PROGRAM_ID)
130: ,REQUEST_ID = DECODE(P_REQUEST_ID, NULL, REQUEST_ID,
131: FND_API.G_MISS_NUM, NULL, P_REQUEST_ID)
132: ,OBJECT_VERSION_NUMBER = DECODE(P_OBJECT_VERSION_NUMBER, NULL,
133: OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, P_OBJECT_VERSION_NUMBER)

Line 131: FND_API.G_MISS_NUM, NULL, P_REQUEST_ID)

127: ,LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
128: ,PROGRAM_ID = DECODE(P_PROGRAM_ID, NULL, PROGRAM_ID,
129: FND_API.G_MISS_NUM, NULL, P_PROGRAM_ID)
130: ,REQUEST_ID = DECODE(P_REQUEST_ID, NULL, REQUEST_ID,
131: FND_API.G_MISS_NUM, NULL, P_REQUEST_ID)
132: ,OBJECT_VERSION_NUMBER = DECODE(P_OBJECT_VERSION_NUMBER, NULL,
133: OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, P_OBJECT_VERSION_NUMBER)
134: ,DISB_HEADER_ID = DECODE(P_DISB_HEADER_ID, NULL, DISB_HEADER_ID,
135: FND_API.G_MISS_NUM, NULL, P_DISB_HEADER_ID)

Line 133: OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, P_OBJECT_VERSION_NUMBER)

129: FND_API.G_MISS_NUM, NULL, P_PROGRAM_ID)
130: ,REQUEST_ID = DECODE(P_REQUEST_ID, NULL, REQUEST_ID,
131: FND_API.G_MISS_NUM, NULL, P_REQUEST_ID)
132: ,OBJECT_VERSION_NUMBER = DECODE(P_OBJECT_VERSION_NUMBER, NULL,
133: OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, P_OBJECT_VERSION_NUMBER)
134: ,DISB_HEADER_ID = DECODE(P_DISB_HEADER_ID, NULL, DISB_HEADER_ID,
135: FND_API.G_MISS_NUM, NULL, P_DISB_HEADER_ID)
136: ,PHASE = DECODE(P_PHASE, NULL, PHASE, FND_API.G_MISS_CHAR, NULL,
137: P_PHASE)

Line 135: FND_API.G_MISS_NUM, NULL, P_DISB_HEADER_ID)

131: FND_API.G_MISS_NUM, NULL, P_REQUEST_ID)
132: ,OBJECT_VERSION_NUMBER = DECODE(P_OBJECT_VERSION_NUMBER, NULL,
133: OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, P_OBJECT_VERSION_NUMBER)
134: ,DISB_HEADER_ID = DECODE(P_DISB_HEADER_ID, NULL, DISB_HEADER_ID,
135: FND_API.G_MISS_NUM, NULL, P_DISB_HEADER_ID)
136: ,PHASE = DECODE(P_PHASE, NULL, PHASE, FND_API.G_MISS_CHAR, NULL,
137: P_PHASE)
138: WHERE FEE_SCHEDULE_ID = P_FEE_SCHEDULE_ID;
139:

Line 136: ,PHASE = DECODE(P_PHASE, NULL, PHASE, FND_API.G_MISS_CHAR, NULL,

132: ,OBJECT_VERSION_NUMBER = DECODE(P_OBJECT_VERSION_NUMBER, NULL,
133: OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, P_OBJECT_VERSION_NUMBER)
134: ,DISB_HEADER_ID = DECODE(P_DISB_HEADER_ID, NULL, DISB_HEADER_ID,
135: FND_API.G_MISS_NUM, NULL, P_DISB_HEADER_ID)
136: ,PHASE = DECODE(P_PHASE, NULL, PHASE, FND_API.G_MISS_CHAR, NULL,
137: P_PHASE)
138: WHERE FEE_SCHEDULE_ID = P_FEE_SCHEDULE_ID;
139:
140: if (sql%notfound) then