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.

[Home] [Help]

APPS.LNS_COND_ASSIGNMENTS_PKG dependencies on FND_API

Line 57: DECODE(X_COND_ASSIGNMENT_ID, FND_API.G_MISS_NUM, LNS_COND_ASSIGNMENTS_S.NEXTVAL, NULL, LNS_COND_ASSIGNMENTS_S.NEXTVAL, X_COND_ASSIGNMENT_ID)

53: ,DELETE_DISABLED_FLAG
54: ,OWNER_OBJECT_ID
55: ,OWNER_TABLE
56: ) VALUES (
57: DECODE(X_COND_ASSIGNMENT_ID, FND_API.G_MISS_NUM, LNS_COND_ASSIGNMENTS_S.NEXTVAL, NULL, LNS_COND_ASSIGNMENTS_S.NEXTVAL, X_COND_ASSIGNMENT_ID)
58: ,DECODE(P_LOAN_ID, FND_API.G_MISS_NUM, NULL, P_LOAN_ID)
59: ,DECODE(P_CONDITION_ID, FND_API.G_MISS_NUM, NULL, P_CONDITION_ID)
60: ,DECODE(P_CONDITION_MET_FLAG, FND_API.G_MISS_CHAR, NULL, P_CONDITION_MET_FLAG)
61: ,DECODE(P_MANDATORY_FLAG, FND_API.G_MISS_CHAR, NULL, P_MANDATORY_FLAG)

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

54: ,OWNER_OBJECT_ID
55: ,OWNER_TABLE
56: ) VALUES (
57: DECODE(X_COND_ASSIGNMENT_ID, FND_API.G_MISS_NUM, LNS_COND_ASSIGNMENTS_S.NEXTVAL, NULL, LNS_COND_ASSIGNMENTS_S.NEXTVAL, X_COND_ASSIGNMENT_ID)
58: ,DECODE(P_LOAN_ID, FND_API.G_MISS_NUM, NULL, P_LOAN_ID)
59: ,DECODE(P_CONDITION_ID, FND_API.G_MISS_NUM, NULL, P_CONDITION_ID)
60: ,DECODE(P_CONDITION_MET_FLAG, FND_API.G_MISS_CHAR, NULL, P_CONDITION_MET_FLAG)
61: ,DECODE(P_MANDATORY_FLAG, FND_API.G_MISS_CHAR, NULL, P_MANDATORY_FLAG)
62: ,LNS_UTILITY_PUB.CREATED_BY

Line 59: ,DECODE(P_CONDITION_ID, FND_API.G_MISS_NUM, NULL, P_CONDITION_ID)

55: ,OWNER_TABLE
56: ) VALUES (
57: DECODE(X_COND_ASSIGNMENT_ID, FND_API.G_MISS_NUM, LNS_COND_ASSIGNMENTS_S.NEXTVAL, NULL, LNS_COND_ASSIGNMENTS_S.NEXTVAL, X_COND_ASSIGNMENT_ID)
58: ,DECODE(P_LOAN_ID, FND_API.G_MISS_NUM, NULL, P_LOAN_ID)
59: ,DECODE(P_CONDITION_ID, FND_API.G_MISS_NUM, NULL, P_CONDITION_ID)
60: ,DECODE(P_CONDITION_MET_FLAG, FND_API.G_MISS_CHAR, NULL, P_CONDITION_MET_FLAG)
61: ,DECODE(P_MANDATORY_FLAG, FND_API.G_MISS_CHAR, NULL, P_MANDATORY_FLAG)
62: ,LNS_UTILITY_PUB.CREATED_BY
63: ,LNS_UTILITY_PUB.CREATION_DATE

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

56: ) VALUES (
57: DECODE(X_COND_ASSIGNMENT_ID, FND_API.G_MISS_NUM, LNS_COND_ASSIGNMENTS_S.NEXTVAL, NULL, LNS_COND_ASSIGNMENTS_S.NEXTVAL, X_COND_ASSIGNMENT_ID)
58: ,DECODE(P_LOAN_ID, FND_API.G_MISS_NUM, NULL, P_LOAN_ID)
59: ,DECODE(P_CONDITION_ID, FND_API.G_MISS_NUM, NULL, P_CONDITION_ID)
60: ,DECODE(P_CONDITION_MET_FLAG, FND_API.G_MISS_CHAR, NULL, P_CONDITION_MET_FLAG)
61: ,DECODE(P_MANDATORY_FLAG, FND_API.G_MISS_CHAR, NULL, P_MANDATORY_FLAG)
62: ,LNS_UTILITY_PUB.CREATED_BY
63: ,LNS_UTILITY_PUB.CREATION_DATE
64: ,LNS_UTILITY_PUB.LAST_UPDATED_BY

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

57: DECODE(X_COND_ASSIGNMENT_ID, FND_API.G_MISS_NUM, LNS_COND_ASSIGNMENTS_S.NEXTVAL, NULL, LNS_COND_ASSIGNMENTS_S.NEXTVAL, X_COND_ASSIGNMENT_ID)
58: ,DECODE(P_LOAN_ID, FND_API.G_MISS_NUM, NULL, P_LOAN_ID)
59: ,DECODE(P_CONDITION_ID, FND_API.G_MISS_NUM, NULL, P_CONDITION_ID)
60: ,DECODE(P_CONDITION_MET_FLAG, FND_API.G_MISS_CHAR, NULL, P_CONDITION_MET_FLAG)
61: ,DECODE(P_MANDATORY_FLAG, FND_API.G_MISS_CHAR, NULL, P_MANDATORY_FLAG)
62: ,LNS_UTILITY_PUB.CREATED_BY
63: ,LNS_UTILITY_PUB.CREATION_DATE
64: ,LNS_UTILITY_PUB.LAST_UPDATED_BY
65: ,LNS_UTILITY_PUB.LAST_UPDATE_DATE

Line 67: ,DECODE(P_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, P_OBJECT_VERSION_NUMBER)

63: ,LNS_UTILITY_PUB.CREATION_DATE
64: ,LNS_UTILITY_PUB.LAST_UPDATED_BY
65: ,LNS_UTILITY_PUB.LAST_UPDATE_DATE
66: ,LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
67: ,DECODE(P_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, P_OBJECT_VERSION_NUMBER)
68: ,DECODE(P_FULFILLMENT_DATE, FND_API.G_MISS_DATE, NULL, P_FULFILLMENT_DATE)
69: ,DECODE(P_FULFILLMENT_UPDATED_BY, FND_API.G_MISS_NUM, NULL, P_FULFILLMENT_UPDATED_BY)
70: ,DECODE(P_START_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, P_START_DATE_ACTIVE)
71: ,DECODE(P_END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, P_END_DATE_ACTIVE)

Line 68: ,DECODE(P_FULFILLMENT_DATE, FND_API.G_MISS_DATE, NULL, P_FULFILLMENT_DATE)

64: ,LNS_UTILITY_PUB.LAST_UPDATED_BY
65: ,LNS_UTILITY_PUB.LAST_UPDATE_DATE
66: ,LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
67: ,DECODE(P_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, P_OBJECT_VERSION_NUMBER)
68: ,DECODE(P_FULFILLMENT_DATE, FND_API.G_MISS_DATE, NULL, P_FULFILLMENT_DATE)
69: ,DECODE(P_FULFILLMENT_UPDATED_BY, FND_API.G_MISS_NUM, NULL, P_FULFILLMENT_UPDATED_BY)
70: ,DECODE(P_START_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, P_START_DATE_ACTIVE)
71: ,DECODE(P_END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, P_END_DATE_ACTIVE)
72: ,DECODE(P_DISB_HEADER_ID, FND_API.G_MISS_NUM, NULL, P_DISB_HEADER_ID)

Line 69: ,DECODE(P_FULFILLMENT_UPDATED_BY, FND_API.G_MISS_NUM, NULL, P_FULFILLMENT_UPDATED_BY)

65: ,LNS_UTILITY_PUB.LAST_UPDATE_DATE
66: ,LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
67: ,DECODE(P_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, P_OBJECT_VERSION_NUMBER)
68: ,DECODE(P_FULFILLMENT_DATE, FND_API.G_MISS_DATE, NULL, P_FULFILLMENT_DATE)
69: ,DECODE(P_FULFILLMENT_UPDATED_BY, FND_API.G_MISS_NUM, NULL, P_FULFILLMENT_UPDATED_BY)
70: ,DECODE(P_START_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, P_START_DATE_ACTIVE)
71: ,DECODE(P_END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, P_END_DATE_ACTIVE)
72: ,DECODE(P_DISB_HEADER_ID, FND_API.G_MISS_NUM, NULL, P_DISB_HEADER_ID)
73: ,DECODE(P_DELETE_DISABLED_FLAG ,FND_API.G_MISS_CHAR, NULL, P_DELETE_DISABLED_FLAG)

Line 70: ,DECODE(P_START_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, P_START_DATE_ACTIVE)

66: ,LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
67: ,DECODE(P_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, P_OBJECT_VERSION_NUMBER)
68: ,DECODE(P_FULFILLMENT_DATE, FND_API.G_MISS_DATE, NULL, P_FULFILLMENT_DATE)
69: ,DECODE(P_FULFILLMENT_UPDATED_BY, FND_API.G_MISS_NUM, NULL, P_FULFILLMENT_UPDATED_BY)
70: ,DECODE(P_START_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, P_START_DATE_ACTIVE)
71: ,DECODE(P_END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, P_END_DATE_ACTIVE)
72: ,DECODE(P_DISB_HEADER_ID, FND_API.G_MISS_NUM, NULL, P_DISB_HEADER_ID)
73: ,DECODE(P_DELETE_DISABLED_FLAG ,FND_API.G_MISS_CHAR, NULL, P_DELETE_DISABLED_FLAG)
74: ,DECODE(P_OWNER_OBJECT_ID, FND_API.G_MISS_NUM, NULL, P_OWNER_OBJECT_ID)

Line 71: ,DECODE(P_END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, P_END_DATE_ACTIVE)

67: ,DECODE(P_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, P_OBJECT_VERSION_NUMBER)
68: ,DECODE(P_FULFILLMENT_DATE, FND_API.G_MISS_DATE, NULL, P_FULFILLMENT_DATE)
69: ,DECODE(P_FULFILLMENT_UPDATED_BY, FND_API.G_MISS_NUM, NULL, P_FULFILLMENT_UPDATED_BY)
70: ,DECODE(P_START_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, P_START_DATE_ACTIVE)
71: ,DECODE(P_END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, P_END_DATE_ACTIVE)
72: ,DECODE(P_DISB_HEADER_ID, FND_API.G_MISS_NUM, NULL, P_DISB_HEADER_ID)
73: ,DECODE(P_DELETE_DISABLED_FLAG ,FND_API.G_MISS_CHAR, NULL, P_DELETE_DISABLED_FLAG)
74: ,DECODE(P_OWNER_OBJECT_ID, FND_API.G_MISS_NUM, NULL, P_OWNER_OBJECT_ID)
75: ,DECODE(P_OWNER_TABLE ,FND_API.G_MISS_CHAR, NULL, P_OWNER_TABLE)

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

68: ,DECODE(P_FULFILLMENT_DATE, FND_API.G_MISS_DATE, NULL, P_FULFILLMENT_DATE)
69: ,DECODE(P_FULFILLMENT_UPDATED_BY, FND_API.G_MISS_NUM, NULL, P_FULFILLMENT_UPDATED_BY)
70: ,DECODE(P_START_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, P_START_DATE_ACTIVE)
71: ,DECODE(P_END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, P_END_DATE_ACTIVE)
72: ,DECODE(P_DISB_HEADER_ID, FND_API.G_MISS_NUM, NULL, P_DISB_HEADER_ID)
73: ,DECODE(P_DELETE_DISABLED_FLAG ,FND_API.G_MISS_CHAR, NULL, P_DELETE_DISABLED_FLAG)
74: ,DECODE(P_OWNER_OBJECT_ID, FND_API.G_MISS_NUM, NULL, P_OWNER_OBJECT_ID)
75: ,DECODE(P_OWNER_TABLE ,FND_API.G_MISS_CHAR, NULL, P_OWNER_TABLE)
76: ) RETURNING

Line 73: ,DECODE(P_DELETE_DISABLED_FLAG ,FND_API.G_MISS_CHAR, NULL, P_DELETE_DISABLED_FLAG)

69: ,DECODE(P_FULFILLMENT_UPDATED_BY, FND_API.G_MISS_NUM, NULL, P_FULFILLMENT_UPDATED_BY)
70: ,DECODE(P_START_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, P_START_DATE_ACTIVE)
71: ,DECODE(P_END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, P_END_DATE_ACTIVE)
72: ,DECODE(P_DISB_HEADER_ID, FND_API.G_MISS_NUM, NULL, P_DISB_HEADER_ID)
73: ,DECODE(P_DELETE_DISABLED_FLAG ,FND_API.G_MISS_CHAR, NULL, P_DELETE_DISABLED_FLAG)
74: ,DECODE(P_OWNER_OBJECT_ID, FND_API.G_MISS_NUM, NULL, P_OWNER_OBJECT_ID)
75: ,DECODE(P_OWNER_TABLE ,FND_API.G_MISS_CHAR, NULL, P_OWNER_TABLE)
76: ) RETURNING
77: COND_ASSIGNMENT_ID

Line 74: ,DECODE(P_OWNER_OBJECT_ID, FND_API.G_MISS_NUM, NULL, P_OWNER_OBJECT_ID)

70: ,DECODE(P_START_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, P_START_DATE_ACTIVE)
71: ,DECODE(P_END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, P_END_DATE_ACTIVE)
72: ,DECODE(P_DISB_HEADER_ID, FND_API.G_MISS_NUM, NULL, P_DISB_HEADER_ID)
73: ,DECODE(P_DELETE_DISABLED_FLAG ,FND_API.G_MISS_CHAR, NULL, P_DELETE_DISABLED_FLAG)
74: ,DECODE(P_OWNER_OBJECT_ID, FND_API.G_MISS_NUM, NULL, P_OWNER_OBJECT_ID)
75: ,DECODE(P_OWNER_TABLE ,FND_API.G_MISS_CHAR, NULL, P_OWNER_TABLE)
76: ) RETURNING
77: COND_ASSIGNMENT_ID
78: INTO

Line 75: ,DECODE(P_OWNER_TABLE ,FND_API.G_MISS_CHAR, NULL, P_OWNER_TABLE)

71: ,DECODE(P_END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, P_END_DATE_ACTIVE)
72: ,DECODE(P_DISB_HEADER_ID, FND_API.G_MISS_NUM, NULL, P_DISB_HEADER_ID)
73: ,DECODE(P_DELETE_DISABLED_FLAG ,FND_API.G_MISS_CHAR, NULL, P_DELETE_DISABLED_FLAG)
74: ,DECODE(P_OWNER_OBJECT_ID, FND_API.G_MISS_NUM, NULL, P_OWNER_OBJECT_ID)
75: ,DECODE(P_OWNER_TABLE ,FND_API.G_MISS_CHAR, NULL, P_OWNER_TABLE)
76: ) RETURNING
77: COND_ASSIGNMENT_ID
78: INTO
79: X_COND_ASSIGNMENT_ID;

Line 93: ,DECODE(P_CONDITION_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, P_CONDITION_DESCRIPTION)

89: ,LAST_UPDATED_BY
90: ,LAST_UPDATE_LOGIN
91: ) SELECT
92: X_COND_ASSIGNMENT_ID
93: ,DECODE(P_CONDITION_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, P_CONDITION_DESCRIPTION)
94: ,L.LANGUAGE_CODE
95: ,userenv('LANG')
96: ,fnd_global.user_id
97: ,sysdate

Line 180: -- So use LNS_NULL_DATE instead of FND_API.G_MISS_DATE

176: ,P_OWNER_OBJECT_ID IN NUMBER
177: ,P_OWNER_TABLE IN VARCHAR2
178: ) IS
179: -- It is not possible to pass negative Date values from Java.
180: -- So use LNS_NULL_DATE instead of FND_API.G_MISS_DATE
181: LNS_NULL_DATE CONSTANT DATE := TO_DATE('01/01/4711','DD/MM/YYYY');
182: --FND_API.G_MISS_NUM is large to fit into NUMBER(20) of FULFILLMENT_UPDATED_BY
183: --So using LNS_NULL_NUM
184: LNS_NULL_NUM CONSTANT NUMBER := -999999999;

Line 182: --FND_API.G_MISS_NUM is large to fit into NUMBER(20) of FULFILLMENT_UPDATED_BY

178: ) IS
179: -- It is not possible to pass negative Date values from Java.
180: -- So use LNS_NULL_DATE instead of FND_API.G_MISS_DATE
181: LNS_NULL_DATE CONSTANT DATE := TO_DATE('01/01/4711','DD/MM/YYYY');
182: --FND_API.G_MISS_NUM is large to fit into NUMBER(20) of FULFILLMENT_UPDATED_BY
183: --So using LNS_NULL_NUM
184: LNS_NULL_NUM CONSTANT NUMBER := -999999999;
185:
186: BEGIN

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

184: LNS_NULL_NUM CONSTANT NUMBER := -999999999;
185:
186: BEGIN
187: UPDATE LNS_COND_ASSIGNMENTS SET
188: LOAN_ID = DECODE(P_LOAN_ID, NULL, LOAN_ID, FND_API.G_MISS_NUM, NULL, P_LOAN_ID)
189: ,CONDITION_ID = DECODE(P_CONDITION_ID, NULL, CONDITION_ID, FND_API.G_MISS_NUM, NULL, P_CONDITION_ID)
190: ,CONDITION_MET_FLAG = DECODE(P_CONDITION_MET_FLAG, NULL, CONDITION_MET_FLAG, FND_API.G_MISS_CHAR, NULL, P_CONDITION_MET_FLAG)
191: ,MANDATORY_FLAG = DECODE(P_MANDATORY_FLAG, NULL, MANDATORY_FLAG, FND_API.G_MISS_CHAR, NULL, P_MANDATORY_FLAG)
192: ,LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY

Line 189: ,CONDITION_ID = DECODE(P_CONDITION_ID, NULL, CONDITION_ID, FND_API.G_MISS_NUM, NULL, P_CONDITION_ID)

185:
186: BEGIN
187: UPDATE LNS_COND_ASSIGNMENTS SET
188: LOAN_ID = DECODE(P_LOAN_ID, NULL, LOAN_ID, FND_API.G_MISS_NUM, NULL, P_LOAN_ID)
189: ,CONDITION_ID = DECODE(P_CONDITION_ID, NULL, CONDITION_ID, FND_API.G_MISS_NUM, NULL, P_CONDITION_ID)
190: ,CONDITION_MET_FLAG = DECODE(P_CONDITION_MET_FLAG, NULL, CONDITION_MET_FLAG, FND_API.G_MISS_CHAR, NULL, P_CONDITION_MET_FLAG)
191: ,MANDATORY_FLAG = DECODE(P_MANDATORY_FLAG, NULL, MANDATORY_FLAG, FND_API.G_MISS_CHAR, NULL, P_MANDATORY_FLAG)
192: ,LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY
193: ,LAST_UPDATE_DATE = LNS_UTILITY_PUB.LAST_UPDATE_DATE

Line 190: ,CONDITION_MET_FLAG = DECODE(P_CONDITION_MET_FLAG, NULL, CONDITION_MET_FLAG, FND_API.G_MISS_CHAR, NULL, P_CONDITION_MET_FLAG)

186: BEGIN
187: UPDATE LNS_COND_ASSIGNMENTS SET
188: LOAN_ID = DECODE(P_LOAN_ID, NULL, LOAN_ID, FND_API.G_MISS_NUM, NULL, P_LOAN_ID)
189: ,CONDITION_ID = DECODE(P_CONDITION_ID, NULL, CONDITION_ID, FND_API.G_MISS_NUM, NULL, P_CONDITION_ID)
190: ,CONDITION_MET_FLAG = DECODE(P_CONDITION_MET_FLAG, NULL, CONDITION_MET_FLAG, FND_API.G_MISS_CHAR, NULL, P_CONDITION_MET_FLAG)
191: ,MANDATORY_FLAG = DECODE(P_MANDATORY_FLAG, NULL, MANDATORY_FLAG, FND_API.G_MISS_CHAR, NULL, P_MANDATORY_FLAG)
192: ,LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY
193: ,LAST_UPDATE_DATE = LNS_UTILITY_PUB.LAST_UPDATE_DATE
194: ,LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN

Line 191: ,MANDATORY_FLAG = DECODE(P_MANDATORY_FLAG, NULL, MANDATORY_FLAG, FND_API.G_MISS_CHAR, NULL, P_MANDATORY_FLAG)

187: UPDATE LNS_COND_ASSIGNMENTS SET
188: LOAN_ID = DECODE(P_LOAN_ID, NULL, LOAN_ID, FND_API.G_MISS_NUM, NULL, P_LOAN_ID)
189: ,CONDITION_ID = DECODE(P_CONDITION_ID, NULL, CONDITION_ID, FND_API.G_MISS_NUM, NULL, P_CONDITION_ID)
190: ,CONDITION_MET_FLAG = DECODE(P_CONDITION_MET_FLAG, NULL, CONDITION_MET_FLAG, FND_API.G_MISS_CHAR, NULL, P_CONDITION_MET_FLAG)
191: ,MANDATORY_FLAG = DECODE(P_MANDATORY_FLAG, NULL, MANDATORY_FLAG, FND_API.G_MISS_CHAR, NULL, P_MANDATORY_FLAG)
192: ,LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY
193: ,LAST_UPDATE_DATE = LNS_UTILITY_PUB.LAST_UPDATE_DATE
194: ,LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
195: ,OBJECT_VERSION_NUMBER = DECODE(P_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, P_OBJECT_VERSION_NUMBER)

Line 195: ,OBJECT_VERSION_NUMBER = DECODE(P_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, P_OBJECT_VERSION_NUMBER)

191: ,MANDATORY_FLAG = DECODE(P_MANDATORY_FLAG, NULL, MANDATORY_FLAG, FND_API.G_MISS_CHAR, NULL, P_MANDATORY_FLAG)
192: ,LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY
193: ,LAST_UPDATE_DATE = LNS_UTILITY_PUB.LAST_UPDATE_DATE
194: ,LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
195: ,OBJECT_VERSION_NUMBER = DECODE(P_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, P_OBJECT_VERSION_NUMBER)
196: --,FULFILLMENT_DATE = DECODE(P_FULFILLMENT_DATE, NULL, FULFILLMENT_DATE, FND_API.G_MISS_DATE, NULL, P_FULFILLMENT_DATE)
197: ,FULFILLMENT_DATE = DECODE(P_FULFILLMENT_DATE, NULL, FULFILLMENT_DATE, LNS_NULL_DATE, NULL, P_FULFILLMENT_DATE)
198: ,FULFILLMENT_UPDATED_BY = DECODE(P_FULFILLMENT_UPDATED_BY, NULL, FULFILLMENT_UPDATED_BY, LNS_NULL_NUM, NULL, P_FULFILLMENT_UPDATED_BY)
199: ,START_DATE_ACTIVE = DECODE(P_START_DATE_ACTIVE, NULL, START_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, P_START_DATE_ACTIVE)

Line 196: --,FULFILLMENT_DATE = DECODE(P_FULFILLMENT_DATE, NULL, FULFILLMENT_DATE, FND_API.G_MISS_DATE, NULL, P_FULFILLMENT_DATE)

192: ,LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY
193: ,LAST_UPDATE_DATE = LNS_UTILITY_PUB.LAST_UPDATE_DATE
194: ,LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
195: ,OBJECT_VERSION_NUMBER = DECODE(P_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, P_OBJECT_VERSION_NUMBER)
196: --,FULFILLMENT_DATE = DECODE(P_FULFILLMENT_DATE, NULL, FULFILLMENT_DATE, FND_API.G_MISS_DATE, NULL, P_FULFILLMENT_DATE)
197: ,FULFILLMENT_DATE = DECODE(P_FULFILLMENT_DATE, NULL, FULFILLMENT_DATE, LNS_NULL_DATE, NULL, P_FULFILLMENT_DATE)
198: ,FULFILLMENT_UPDATED_BY = DECODE(P_FULFILLMENT_UPDATED_BY, NULL, FULFILLMENT_UPDATED_BY, LNS_NULL_NUM, NULL, P_FULFILLMENT_UPDATED_BY)
199: ,START_DATE_ACTIVE = DECODE(P_START_DATE_ACTIVE, NULL, START_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, P_START_DATE_ACTIVE)
200: ,END_DATE_ACTIVE = DECODE(P_END_DATE_ACTIVE, NULL, END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, P_END_DATE_ACTIVE)

Line 199: ,START_DATE_ACTIVE = DECODE(P_START_DATE_ACTIVE, NULL, START_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, P_START_DATE_ACTIVE)

195: ,OBJECT_VERSION_NUMBER = DECODE(P_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, P_OBJECT_VERSION_NUMBER)
196: --,FULFILLMENT_DATE = DECODE(P_FULFILLMENT_DATE, NULL, FULFILLMENT_DATE, FND_API.G_MISS_DATE, NULL, P_FULFILLMENT_DATE)
197: ,FULFILLMENT_DATE = DECODE(P_FULFILLMENT_DATE, NULL, FULFILLMENT_DATE, LNS_NULL_DATE, NULL, P_FULFILLMENT_DATE)
198: ,FULFILLMENT_UPDATED_BY = DECODE(P_FULFILLMENT_UPDATED_BY, NULL, FULFILLMENT_UPDATED_BY, LNS_NULL_NUM, NULL, P_FULFILLMENT_UPDATED_BY)
199: ,START_DATE_ACTIVE = DECODE(P_START_DATE_ACTIVE, NULL, START_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, P_START_DATE_ACTIVE)
200: ,END_DATE_ACTIVE = DECODE(P_END_DATE_ACTIVE, NULL, END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, P_END_DATE_ACTIVE)
201: ,DISB_HEADER_ID = DECODE(P_DISB_HEADER_ID, NULL, DISB_HEADER_ID, FND_API.G_MISS_NUM, NULL, P_DISB_HEADER_ID)
202: ,DELETE_DISABLED_FLAG = DECODE(P_DELETE_DISABLED_FLAG, NULL, DELETE_DISABLED_FLAG, FND_API.G_MISS_CHAR, NULL, P_DELETE_DISABLED_FLAG )
203: ,OWNER_OBJECT_ID = DECODE(P_OWNER_OBJECT_ID, NULL, OWNER_OBJECT_ID, FND_API.G_MISS_NUM, NULL, P_OWNER_OBJECT_ID)

Line 200: ,END_DATE_ACTIVE = DECODE(P_END_DATE_ACTIVE, NULL, END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, P_END_DATE_ACTIVE)

196: --,FULFILLMENT_DATE = DECODE(P_FULFILLMENT_DATE, NULL, FULFILLMENT_DATE, FND_API.G_MISS_DATE, NULL, P_FULFILLMENT_DATE)
197: ,FULFILLMENT_DATE = DECODE(P_FULFILLMENT_DATE, NULL, FULFILLMENT_DATE, LNS_NULL_DATE, NULL, P_FULFILLMENT_DATE)
198: ,FULFILLMENT_UPDATED_BY = DECODE(P_FULFILLMENT_UPDATED_BY, NULL, FULFILLMENT_UPDATED_BY, LNS_NULL_NUM, NULL, P_FULFILLMENT_UPDATED_BY)
199: ,START_DATE_ACTIVE = DECODE(P_START_DATE_ACTIVE, NULL, START_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, P_START_DATE_ACTIVE)
200: ,END_DATE_ACTIVE = DECODE(P_END_DATE_ACTIVE, NULL, END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, P_END_DATE_ACTIVE)
201: ,DISB_HEADER_ID = DECODE(P_DISB_HEADER_ID, NULL, DISB_HEADER_ID, FND_API.G_MISS_NUM, NULL, P_DISB_HEADER_ID)
202: ,DELETE_DISABLED_FLAG = DECODE(P_DELETE_DISABLED_FLAG, NULL, DELETE_DISABLED_FLAG, FND_API.G_MISS_CHAR, NULL, P_DELETE_DISABLED_FLAG )
203: ,OWNER_OBJECT_ID = DECODE(P_OWNER_OBJECT_ID, NULL, OWNER_OBJECT_ID, FND_API.G_MISS_NUM, NULL, P_OWNER_OBJECT_ID)
204: ,OWNER_TABLE = DECODE(P_OWNER_TABLE, NULL, OWNER_TABLE, FND_API.G_MISS_CHAR, NULL, P_OWNER_TABLE )

Line 201: ,DISB_HEADER_ID = DECODE(P_DISB_HEADER_ID, NULL, DISB_HEADER_ID, FND_API.G_MISS_NUM, NULL, P_DISB_HEADER_ID)

197: ,FULFILLMENT_DATE = DECODE(P_FULFILLMENT_DATE, NULL, FULFILLMENT_DATE, LNS_NULL_DATE, NULL, P_FULFILLMENT_DATE)
198: ,FULFILLMENT_UPDATED_BY = DECODE(P_FULFILLMENT_UPDATED_BY, NULL, FULFILLMENT_UPDATED_BY, LNS_NULL_NUM, NULL, P_FULFILLMENT_UPDATED_BY)
199: ,START_DATE_ACTIVE = DECODE(P_START_DATE_ACTIVE, NULL, START_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, P_START_DATE_ACTIVE)
200: ,END_DATE_ACTIVE = DECODE(P_END_DATE_ACTIVE, NULL, END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, P_END_DATE_ACTIVE)
201: ,DISB_HEADER_ID = DECODE(P_DISB_HEADER_ID, NULL, DISB_HEADER_ID, FND_API.G_MISS_NUM, NULL, P_DISB_HEADER_ID)
202: ,DELETE_DISABLED_FLAG = DECODE(P_DELETE_DISABLED_FLAG, NULL, DELETE_DISABLED_FLAG, FND_API.G_MISS_CHAR, NULL, P_DELETE_DISABLED_FLAG )
203: ,OWNER_OBJECT_ID = DECODE(P_OWNER_OBJECT_ID, NULL, OWNER_OBJECT_ID, FND_API.G_MISS_NUM, NULL, P_OWNER_OBJECT_ID)
204: ,OWNER_TABLE = DECODE(P_OWNER_TABLE, NULL, OWNER_TABLE, FND_API.G_MISS_CHAR, NULL, P_OWNER_TABLE )
205: WHERE COND_ASSIGNMENT_ID = P_COND_ASSIGNMENT_ID;

Line 202: ,DELETE_DISABLED_FLAG = DECODE(P_DELETE_DISABLED_FLAG, NULL, DELETE_DISABLED_FLAG, FND_API.G_MISS_CHAR, NULL, P_DELETE_DISABLED_FLAG )

198: ,FULFILLMENT_UPDATED_BY = DECODE(P_FULFILLMENT_UPDATED_BY, NULL, FULFILLMENT_UPDATED_BY, LNS_NULL_NUM, NULL, P_FULFILLMENT_UPDATED_BY)
199: ,START_DATE_ACTIVE = DECODE(P_START_DATE_ACTIVE, NULL, START_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, P_START_DATE_ACTIVE)
200: ,END_DATE_ACTIVE = DECODE(P_END_DATE_ACTIVE, NULL, END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, P_END_DATE_ACTIVE)
201: ,DISB_HEADER_ID = DECODE(P_DISB_HEADER_ID, NULL, DISB_HEADER_ID, FND_API.G_MISS_NUM, NULL, P_DISB_HEADER_ID)
202: ,DELETE_DISABLED_FLAG = DECODE(P_DELETE_DISABLED_FLAG, NULL, DELETE_DISABLED_FLAG, FND_API.G_MISS_CHAR, NULL, P_DELETE_DISABLED_FLAG )
203: ,OWNER_OBJECT_ID = DECODE(P_OWNER_OBJECT_ID, NULL, OWNER_OBJECT_ID, FND_API.G_MISS_NUM, NULL, P_OWNER_OBJECT_ID)
204: ,OWNER_TABLE = DECODE(P_OWNER_TABLE, NULL, OWNER_TABLE, FND_API.G_MISS_CHAR, NULL, P_OWNER_TABLE )
205: WHERE COND_ASSIGNMENT_ID = P_COND_ASSIGNMENT_ID;
206:

Line 203: ,OWNER_OBJECT_ID = DECODE(P_OWNER_OBJECT_ID, NULL, OWNER_OBJECT_ID, FND_API.G_MISS_NUM, NULL, P_OWNER_OBJECT_ID)

199: ,START_DATE_ACTIVE = DECODE(P_START_DATE_ACTIVE, NULL, START_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, P_START_DATE_ACTIVE)
200: ,END_DATE_ACTIVE = DECODE(P_END_DATE_ACTIVE, NULL, END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, P_END_DATE_ACTIVE)
201: ,DISB_HEADER_ID = DECODE(P_DISB_HEADER_ID, NULL, DISB_HEADER_ID, FND_API.G_MISS_NUM, NULL, P_DISB_HEADER_ID)
202: ,DELETE_DISABLED_FLAG = DECODE(P_DELETE_DISABLED_FLAG, NULL, DELETE_DISABLED_FLAG, FND_API.G_MISS_CHAR, NULL, P_DELETE_DISABLED_FLAG )
203: ,OWNER_OBJECT_ID = DECODE(P_OWNER_OBJECT_ID, NULL, OWNER_OBJECT_ID, FND_API.G_MISS_NUM, NULL, P_OWNER_OBJECT_ID)
204: ,OWNER_TABLE = DECODE(P_OWNER_TABLE, NULL, OWNER_TABLE, FND_API.G_MISS_CHAR, NULL, P_OWNER_TABLE )
205: WHERE COND_ASSIGNMENT_ID = P_COND_ASSIGNMENT_ID;
206:
207: if (sql%notfound) then

Line 204: ,OWNER_TABLE = DECODE(P_OWNER_TABLE, NULL, OWNER_TABLE, FND_API.G_MISS_CHAR, NULL, P_OWNER_TABLE )

200: ,END_DATE_ACTIVE = DECODE(P_END_DATE_ACTIVE, NULL, END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, P_END_DATE_ACTIVE)
201: ,DISB_HEADER_ID = DECODE(P_DISB_HEADER_ID, NULL, DISB_HEADER_ID, FND_API.G_MISS_NUM, NULL, P_DISB_HEADER_ID)
202: ,DELETE_DISABLED_FLAG = DECODE(P_DELETE_DISABLED_FLAG, NULL, DELETE_DISABLED_FLAG, FND_API.G_MISS_CHAR, NULL, P_DELETE_DISABLED_FLAG )
203: ,OWNER_OBJECT_ID = DECODE(P_OWNER_OBJECT_ID, NULL, OWNER_OBJECT_ID, FND_API.G_MISS_NUM, NULL, P_OWNER_OBJECT_ID)
204: ,OWNER_TABLE = DECODE(P_OWNER_TABLE, NULL, OWNER_TABLE, FND_API.G_MISS_CHAR, NULL, P_OWNER_TABLE )
205: WHERE COND_ASSIGNMENT_ID = P_COND_ASSIGNMENT_ID;
206:
207: if (sql%notfound) then
208: raise no_data_found;

Line 212: CONDITION_DESCRIPTION = DECODE(P_CONDITION_DESCRIPTION, NULL, CONDITION_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, P_CONDITION_DESCRIPTION)

208: raise no_data_found;
209: end if;
210:
211: UPDATE LNS_COND_ASSIGNMENTS_TL SET
212: CONDITION_DESCRIPTION = DECODE(P_CONDITION_DESCRIPTION, NULL, CONDITION_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, P_CONDITION_DESCRIPTION)
213: ,LAST_UPDATE_DATE = sysdate
214: ,LAST_UPDATED_BY = fnd_global.user_id
215: ,LAST_UPDATE_LOGIN = fnd_global.user_id
216: ,SOURCE_LANG = userenv('LANG')