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.HZ_PARTY_PREFERENCES_PKG dependencies on FND_API

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

51: LAST_UPDATE_LOGIN
52: )
53: VALUES
54: ( X_PARTY_PREFERENCE_ID
55: , DECODE(X_PARTY_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_ID)
56: , DECODE(X_MODULE, FND_API.G_MISS_CHAR, NULL, X_MODULE)
57: , DECODE(X_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_CATEGORY)
58: , DECODE(X_PREFERENCE_CODE, FND_API.G_MISS_CHAR, NULL, X_PREFERENCE_CODE)
59: , DECODE(X_VALUE_VARCHAR2, FND_API.G_MISS_CHAR, NULL, X_VALUE_VARCHAR2)

Line 56: , DECODE(X_MODULE, FND_API.G_MISS_CHAR, NULL, X_MODULE)

52: )
53: VALUES
54: ( X_PARTY_PREFERENCE_ID
55: , DECODE(X_PARTY_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_ID)
56: , DECODE(X_MODULE, FND_API.G_MISS_CHAR, NULL, X_MODULE)
57: , DECODE(X_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_CATEGORY)
58: , DECODE(X_PREFERENCE_CODE, FND_API.G_MISS_CHAR, NULL, X_PREFERENCE_CODE)
59: , DECODE(X_VALUE_VARCHAR2, FND_API.G_MISS_CHAR, NULL, X_VALUE_VARCHAR2)
60: , DECODE(X_VALUE_NUMBER, FND_API.G_MISS_NUM, NULL, X_VALUE_NUMBER)

Line 57: , DECODE(X_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_CATEGORY)

53: VALUES
54: ( X_PARTY_PREFERENCE_ID
55: , DECODE(X_PARTY_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_ID)
56: , DECODE(X_MODULE, FND_API.G_MISS_CHAR, NULL, X_MODULE)
57: , DECODE(X_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_CATEGORY)
58: , DECODE(X_PREFERENCE_CODE, FND_API.G_MISS_CHAR, NULL, X_PREFERENCE_CODE)
59: , DECODE(X_VALUE_VARCHAR2, FND_API.G_MISS_CHAR, NULL, X_VALUE_VARCHAR2)
60: , DECODE(X_VALUE_NUMBER, FND_API.G_MISS_NUM, NULL, X_VALUE_NUMBER)
61: , DECODE(X_VALUE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), X_VALUE_DATE)

Line 58: , DECODE(X_PREFERENCE_CODE, FND_API.G_MISS_CHAR, NULL, X_PREFERENCE_CODE)

54: ( X_PARTY_PREFERENCE_ID
55: , DECODE(X_PARTY_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_ID)
56: , DECODE(X_MODULE, FND_API.G_MISS_CHAR, NULL, X_MODULE)
57: , DECODE(X_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_CATEGORY)
58: , DECODE(X_PREFERENCE_CODE, FND_API.G_MISS_CHAR, NULL, X_PREFERENCE_CODE)
59: , DECODE(X_VALUE_VARCHAR2, FND_API.G_MISS_CHAR, NULL, X_VALUE_VARCHAR2)
60: , DECODE(X_VALUE_NUMBER, FND_API.G_MISS_NUM, NULL, X_VALUE_NUMBER)
61: , DECODE(X_VALUE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), X_VALUE_DATE)
62: , DECODE(X_VALUE_NAME, FND_API.G_MISS_CHAR, NULL, X_VALUE_NAME)

Line 59: , DECODE(X_VALUE_VARCHAR2, FND_API.G_MISS_CHAR, NULL, X_VALUE_VARCHAR2)

55: , DECODE(X_PARTY_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_ID)
56: , DECODE(X_MODULE, FND_API.G_MISS_CHAR, NULL, X_MODULE)
57: , DECODE(X_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_CATEGORY)
58: , DECODE(X_PREFERENCE_CODE, FND_API.G_MISS_CHAR, NULL, X_PREFERENCE_CODE)
59: , DECODE(X_VALUE_VARCHAR2, FND_API.G_MISS_CHAR, NULL, X_VALUE_VARCHAR2)
60: , DECODE(X_VALUE_NUMBER, FND_API.G_MISS_NUM, NULL, X_VALUE_NUMBER)
61: , DECODE(X_VALUE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), X_VALUE_DATE)
62: , DECODE(X_VALUE_NAME, FND_API.G_MISS_CHAR, NULL, X_VALUE_NAME)
63: , DECODE(X_ADDITIONAL_VALUE1, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_VALUE1)

Line 60: , DECODE(X_VALUE_NUMBER, FND_API.G_MISS_NUM, NULL, X_VALUE_NUMBER)

56: , DECODE(X_MODULE, FND_API.G_MISS_CHAR, NULL, X_MODULE)
57: , DECODE(X_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_CATEGORY)
58: , DECODE(X_PREFERENCE_CODE, FND_API.G_MISS_CHAR, NULL, X_PREFERENCE_CODE)
59: , DECODE(X_VALUE_VARCHAR2, FND_API.G_MISS_CHAR, NULL, X_VALUE_VARCHAR2)
60: , DECODE(X_VALUE_NUMBER, FND_API.G_MISS_NUM, NULL, X_VALUE_NUMBER)
61: , DECODE(X_VALUE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), X_VALUE_DATE)
62: , DECODE(X_VALUE_NAME, FND_API.G_MISS_CHAR, NULL, X_VALUE_NAME)
63: , DECODE(X_ADDITIONAL_VALUE1, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_VALUE1)
64: , DECODE(X_ADDITIONAL_VALUE2, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_VALUE2)

Line 61: , DECODE(X_VALUE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), X_VALUE_DATE)

57: , DECODE(X_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_CATEGORY)
58: , DECODE(X_PREFERENCE_CODE, FND_API.G_MISS_CHAR, NULL, X_PREFERENCE_CODE)
59: , DECODE(X_VALUE_VARCHAR2, FND_API.G_MISS_CHAR, NULL, X_VALUE_VARCHAR2)
60: , DECODE(X_VALUE_NUMBER, FND_API.G_MISS_NUM, NULL, X_VALUE_NUMBER)
61: , DECODE(X_VALUE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), X_VALUE_DATE)
62: , DECODE(X_VALUE_NAME, FND_API.G_MISS_CHAR, NULL, X_VALUE_NAME)
63: , DECODE(X_ADDITIONAL_VALUE1, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_VALUE1)
64: , DECODE(X_ADDITIONAL_VALUE2, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_VALUE2)
65: , DECODE(X_ADDITIONAL_VALUE3, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_VALUE3)

Line 62: , DECODE(X_VALUE_NAME, FND_API.G_MISS_CHAR, NULL, X_VALUE_NAME)

58: , DECODE(X_PREFERENCE_CODE, FND_API.G_MISS_CHAR, NULL, X_PREFERENCE_CODE)
59: , DECODE(X_VALUE_VARCHAR2, FND_API.G_MISS_CHAR, NULL, X_VALUE_VARCHAR2)
60: , DECODE(X_VALUE_NUMBER, FND_API.G_MISS_NUM, NULL, X_VALUE_NUMBER)
61: , DECODE(X_VALUE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), X_VALUE_DATE)
62: , DECODE(X_VALUE_NAME, FND_API.G_MISS_CHAR, NULL, X_VALUE_NAME)
63: , DECODE(X_ADDITIONAL_VALUE1, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_VALUE1)
64: , DECODE(X_ADDITIONAL_VALUE2, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_VALUE2)
65: , DECODE(X_ADDITIONAL_VALUE3, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_VALUE3)
66: , DECODE(X_ADDITIONAL_VALUE4, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_VALUE4)

Line 63: , DECODE(X_ADDITIONAL_VALUE1, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_VALUE1)

59: , DECODE(X_VALUE_VARCHAR2, FND_API.G_MISS_CHAR, NULL, X_VALUE_VARCHAR2)
60: , DECODE(X_VALUE_NUMBER, FND_API.G_MISS_NUM, NULL, X_VALUE_NUMBER)
61: , DECODE(X_VALUE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), X_VALUE_DATE)
62: , DECODE(X_VALUE_NAME, FND_API.G_MISS_CHAR, NULL, X_VALUE_NAME)
63: , DECODE(X_ADDITIONAL_VALUE1, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_VALUE1)
64: , DECODE(X_ADDITIONAL_VALUE2, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_VALUE2)
65: , DECODE(X_ADDITIONAL_VALUE3, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_VALUE3)
66: , DECODE(X_ADDITIONAL_VALUE4, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_VALUE4)
67: , DECODE(X_ADDITIONAL_VALUE5, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_VALUE5)

Line 64: , DECODE(X_ADDITIONAL_VALUE2, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_VALUE2)

60: , DECODE(X_VALUE_NUMBER, FND_API.G_MISS_NUM, NULL, X_VALUE_NUMBER)
61: , DECODE(X_VALUE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), X_VALUE_DATE)
62: , DECODE(X_VALUE_NAME, FND_API.G_MISS_CHAR, NULL, X_VALUE_NAME)
63: , DECODE(X_ADDITIONAL_VALUE1, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_VALUE1)
64: , DECODE(X_ADDITIONAL_VALUE2, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_VALUE2)
65: , DECODE(X_ADDITIONAL_VALUE3, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_VALUE3)
66: , DECODE(X_ADDITIONAL_VALUE4, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_VALUE4)
67: , DECODE(X_ADDITIONAL_VALUE5, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_VALUE5)
68: , DECODE(X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER)

Line 65: , DECODE(X_ADDITIONAL_VALUE3, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_VALUE3)

61: , DECODE(X_VALUE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), X_VALUE_DATE)
62: , DECODE(X_VALUE_NAME, FND_API.G_MISS_CHAR, NULL, X_VALUE_NAME)
63: , DECODE(X_ADDITIONAL_VALUE1, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_VALUE1)
64: , DECODE(X_ADDITIONAL_VALUE2, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_VALUE2)
65: , DECODE(X_ADDITIONAL_VALUE3, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_VALUE3)
66: , DECODE(X_ADDITIONAL_VALUE4, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_VALUE4)
67: , DECODE(X_ADDITIONAL_VALUE5, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_VALUE5)
68: , DECODE(X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER)
69: , DECODE(X_CREATED_BY, FND_API.G_MISS_NUM, NULL, X_CREATED_BY)

Line 66: , DECODE(X_ADDITIONAL_VALUE4, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_VALUE4)

62: , DECODE(X_VALUE_NAME, FND_API.G_MISS_CHAR, NULL, X_VALUE_NAME)
63: , DECODE(X_ADDITIONAL_VALUE1, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_VALUE1)
64: , DECODE(X_ADDITIONAL_VALUE2, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_VALUE2)
65: , DECODE(X_ADDITIONAL_VALUE3, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_VALUE3)
66: , DECODE(X_ADDITIONAL_VALUE4, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_VALUE4)
67: , DECODE(X_ADDITIONAL_VALUE5, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_VALUE5)
68: , DECODE(X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER)
69: , DECODE(X_CREATED_BY, FND_API.G_MISS_NUM, NULL, X_CREATED_BY)
70: , DECODE(x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), x_CREATION_DATE)

Line 67: , DECODE(X_ADDITIONAL_VALUE5, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_VALUE5)

63: , DECODE(X_ADDITIONAL_VALUE1, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_VALUE1)
64: , DECODE(X_ADDITIONAL_VALUE2, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_VALUE2)
65: , DECODE(X_ADDITIONAL_VALUE3, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_VALUE3)
66: , DECODE(X_ADDITIONAL_VALUE4, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_VALUE4)
67: , DECODE(X_ADDITIONAL_VALUE5, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_VALUE5)
68: , DECODE(X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER)
69: , DECODE(X_CREATED_BY, FND_API.G_MISS_NUM, NULL, X_CREATED_BY)
70: , DECODE(x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), x_CREATION_DATE)
71: , DECODE(x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, x_LAST_UPDATED_BY)

Line 68: , DECODE(X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER)

64: , DECODE(X_ADDITIONAL_VALUE2, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_VALUE2)
65: , DECODE(X_ADDITIONAL_VALUE3, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_VALUE3)
66: , DECODE(X_ADDITIONAL_VALUE4, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_VALUE4)
67: , DECODE(X_ADDITIONAL_VALUE5, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_VALUE5)
68: , DECODE(X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER)
69: , DECODE(X_CREATED_BY, FND_API.G_MISS_NUM, NULL, X_CREATED_BY)
70: , DECODE(x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), x_CREATION_DATE)
71: , DECODE(x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, x_LAST_UPDATED_BY)
72: , DECODE(x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), x_LAST_UPDATE_DATE)

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

65: , DECODE(X_ADDITIONAL_VALUE3, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_VALUE3)
66: , DECODE(X_ADDITIONAL_VALUE4, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_VALUE4)
67: , DECODE(X_ADDITIONAL_VALUE5, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_VALUE5)
68: , DECODE(X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER)
69: , DECODE(X_CREATED_BY, FND_API.G_MISS_NUM, NULL, X_CREATED_BY)
70: , DECODE(x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), x_CREATION_DATE)
71: , DECODE(x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, x_LAST_UPDATED_BY)
72: , DECODE(x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), x_LAST_UPDATE_DATE)
73: , DECODE(x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, x_LAST_UPDATE_LOGIN)

Line 70: , DECODE(x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), x_CREATION_DATE)

66: , DECODE(X_ADDITIONAL_VALUE4, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_VALUE4)
67: , DECODE(X_ADDITIONAL_VALUE5, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_VALUE5)
68: , DECODE(X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER)
69: , DECODE(X_CREATED_BY, FND_API.G_MISS_NUM, NULL, X_CREATED_BY)
70: , DECODE(x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), x_CREATION_DATE)
71: , DECODE(x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, x_LAST_UPDATED_BY)
72: , DECODE(x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), x_LAST_UPDATE_DATE)
73: , DECODE(x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, x_LAST_UPDATE_LOGIN)
74: ) returning ROWID into X_ROWID;

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

67: , DECODE(X_ADDITIONAL_VALUE5, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_VALUE5)
68: , DECODE(X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER)
69: , DECODE(X_CREATED_BY, FND_API.G_MISS_NUM, NULL, X_CREATED_BY)
70: , DECODE(x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), x_CREATION_DATE)
71: , DECODE(x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, x_LAST_UPDATED_BY)
72: , DECODE(x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), x_LAST_UPDATE_DATE)
73: , DECODE(x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, x_LAST_UPDATE_LOGIN)
74: ) returning ROWID into X_ROWID;
75:

Line 72: , DECODE(x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), x_LAST_UPDATE_DATE)

68: , DECODE(X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER)
69: , DECODE(X_CREATED_BY, FND_API.G_MISS_NUM, NULL, X_CREATED_BY)
70: , DECODE(x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), x_CREATION_DATE)
71: , DECODE(x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, x_LAST_UPDATED_BY)
72: , DECODE(x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), x_LAST_UPDATE_DATE)
73: , DECODE(x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, x_LAST_UPDATE_LOGIN)
74: ) returning ROWID into X_ROWID;
75:
76: -- Following is an old standard we used to use.

Line 73: , DECODE(x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, x_LAST_UPDATE_LOGIN)

69: , DECODE(X_CREATED_BY, FND_API.G_MISS_NUM, NULL, X_CREATED_BY)
70: , DECODE(x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), x_CREATION_DATE)
71: , DECODE(x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, x_LAST_UPDATED_BY)
72: , DECODE(x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), x_LAST_UPDATE_DATE)
73: , DECODE(x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, x_LAST_UPDATE_LOGIN)
74: ) returning ROWID into X_ROWID;
75:
76: -- Following is an old standard we used to use.
77: -- Now we are trying to use returning rowid clause

Line 188: PARTY_ID = DECODE(X_PARTY_ID, FND_API.G_MISS_NUM, PARTY_ID, X_PARTY_ID),

184: X_LAST_UPDATE_LOGIN in NUMBER
185: ) is
186: begin
187: update HZ_PARTY_PREFERENCES set
188: PARTY_ID = DECODE(X_PARTY_ID, FND_API.G_MISS_NUM, PARTY_ID, X_PARTY_ID),
189: MODULE = DECODE(X_MODULE, FND_API.G_MISS_CHAR, MODULE, X_MODULE),
190: CATEGORY = DECODE(X_CATEGORY, FND_API.G_MISS_CHAR, CATEGORY, X_CATEGORY),
191: PREFERENCE_CODE = DECODE(X_PREFERENCE_CODE,FND_API.G_MISS_CHAR, PREFERENCE_CODE, X_PREFERENCE_CODE),
192: VALUE_VARCHAR2 = DECODE(X_VALUE_VARCHAR2, FND_API.G_MISS_CHAR, VALUE_VARCHAR2, X_VALUE_VARCHAR2),

Line 189: MODULE = DECODE(X_MODULE, FND_API.G_MISS_CHAR, MODULE, X_MODULE),

185: ) is
186: begin
187: update HZ_PARTY_PREFERENCES set
188: PARTY_ID = DECODE(X_PARTY_ID, FND_API.G_MISS_NUM, PARTY_ID, X_PARTY_ID),
189: MODULE = DECODE(X_MODULE, FND_API.G_MISS_CHAR, MODULE, X_MODULE),
190: CATEGORY = DECODE(X_CATEGORY, FND_API.G_MISS_CHAR, CATEGORY, X_CATEGORY),
191: PREFERENCE_CODE = DECODE(X_PREFERENCE_CODE,FND_API.G_MISS_CHAR, PREFERENCE_CODE, X_PREFERENCE_CODE),
192: VALUE_VARCHAR2 = DECODE(X_VALUE_VARCHAR2, FND_API.G_MISS_CHAR, VALUE_VARCHAR2, X_VALUE_VARCHAR2),
193: VALUE_NUMBER = DECODE(X_VALUE_NUMBER, FND_API.G_MISS_NUM, VALUE_NUMBER, X_VALUE_NUMBER),

Line 190: CATEGORY = DECODE(X_CATEGORY, FND_API.G_MISS_CHAR, CATEGORY, X_CATEGORY),

186: begin
187: update HZ_PARTY_PREFERENCES set
188: PARTY_ID = DECODE(X_PARTY_ID, FND_API.G_MISS_NUM, PARTY_ID, X_PARTY_ID),
189: MODULE = DECODE(X_MODULE, FND_API.G_MISS_CHAR, MODULE, X_MODULE),
190: CATEGORY = DECODE(X_CATEGORY, FND_API.G_MISS_CHAR, CATEGORY, X_CATEGORY),
191: PREFERENCE_CODE = DECODE(X_PREFERENCE_CODE,FND_API.G_MISS_CHAR, PREFERENCE_CODE, X_PREFERENCE_CODE),
192: VALUE_VARCHAR2 = DECODE(X_VALUE_VARCHAR2, FND_API.G_MISS_CHAR, VALUE_VARCHAR2, X_VALUE_VARCHAR2),
193: VALUE_NUMBER = DECODE(X_VALUE_NUMBER, FND_API.G_MISS_NUM, VALUE_NUMBER, X_VALUE_NUMBER),
194: VALUE_DATE = DECODE(X_VALUE_DATE, FND_API.G_MISS_DATE, VALUE_DATE, X_VALUE_DATE),

Line 191: PREFERENCE_CODE = DECODE(X_PREFERENCE_CODE,FND_API.G_MISS_CHAR, PREFERENCE_CODE, X_PREFERENCE_CODE),

187: update HZ_PARTY_PREFERENCES set
188: PARTY_ID = DECODE(X_PARTY_ID, FND_API.G_MISS_NUM, PARTY_ID, X_PARTY_ID),
189: MODULE = DECODE(X_MODULE, FND_API.G_MISS_CHAR, MODULE, X_MODULE),
190: CATEGORY = DECODE(X_CATEGORY, FND_API.G_MISS_CHAR, CATEGORY, X_CATEGORY),
191: PREFERENCE_CODE = DECODE(X_PREFERENCE_CODE,FND_API.G_MISS_CHAR, PREFERENCE_CODE, X_PREFERENCE_CODE),
192: VALUE_VARCHAR2 = DECODE(X_VALUE_VARCHAR2, FND_API.G_MISS_CHAR, VALUE_VARCHAR2, X_VALUE_VARCHAR2),
193: VALUE_NUMBER = DECODE(X_VALUE_NUMBER, FND_API.G_MISS_NUM, VALUE_NUMBER, X_VALUE_NUMBER),
194: VALUE_DATE = DECODE(X_VALUE_DATE, FND_API.G_MISS_DATE, VALUE_DATE, X_VALUE_DATE),
195: VALUE_NAME = DECODE(X_VALUE_NAME, FND_API.G_MISS_CHAR, VALUE_NAME, X_VALUE_NAME),

Line 192: VALUE_VARCHAR2 = DECODE(X_VALUE_VARCHAR2, FND_API.G_MISS_CHAR, VALUE_VARCHAR2, X_VALUE_VARCHAR2),

188: PARTY_ID = DECODE(X_PARTY_ID, FND_API.G_MISS_NUM, PARTY_ID, X_PARTY_ID),
189: MODULE = DECODE(X_MODULE, FND_API.G_MISS_CHAR, MODULE, X_MODULE),
190: CATEGORY = DECODE(X_CATEGORY, FND_API.G_MISS_CHAR, CATEGORY, X_CATEGORY),
191: PREFERENCE_CODE = DECODE(X_PREFERENCE_CODE,FND_API.G_MISS_CHAR, PREFERENCE_CODE, X_PREFERENCE_CODE),
192: VALUE_VARCHAR2 = DECODE(X_VALUE_VARCHAR2, FND_API.G_MISS_CHAR, VALUE_VARCHAR2, X_VALUE_VARCHAR2),
193: VALUE_NUMBER = DECODE(X_VALUE_NUMBER, FND_API.G_MISS_NUM, VALUE_NUMBER, X_VALUE_NUMBER),
194: VALUE_DATE = DECODE(X_VALUE_DATE, FND_API.G_MISS_DATE, VALUE_DATE, X_VALUE_DATE),
195: VALUE_NAME = DECODE(X_VALUE_NAME, FND_API.G_MISS_CHAR, VALUE_NAME, X_VALUE_NAME),
196: ADDITIONAL_VALUE1 = DECODE(X_ADDITIONAL_VALUE1, FND_API.G_MISS_CHAR, ADDITIONAL_VALUE1, X_ADDITIONAL_VALUE1),

Line 193: VALUE_NUMBER = DECODE(X_VALUE_NUMBER, FND_API.G_MISS_NUM, VALUE_NUMBER, X_VALUE_NUMBER),

189: MODULE = DECODE(X_MODULE, FND_API.G_MISS_CHAR, MODULE, X_MODULE),
190: CATEGORY = DECODE(X_CATEGORY, FND_API.G_MISS_CHAR, CATEGORY, X_CATEGORY),
191: PREFERENCE_CODE = DECODE(X_PREFERENCE_CODE,FND_API.G_MISS_CHAR, PREFERENCE_CODE, X_PREFERENCE_CODE),
192: VALUE_VARCHAR2 = DECODE(X_VALUE_VARCHAR2, FND_API.G_MISS_CHAR, VALUE_VARCHAR2, X_VALUE_VARCHAR2),
193: VALUE_NUMBER = DECODE(X_VALUE_NUMBER, FND_API.G_MISS_NUM, VALUE_NUMBER, X_VALUE_NUMBER),
194: VALUE_DATE = DECODE(X_VALUE_DATE, FND_API.G_MISS_DATE, VALUE_DATE, X_VALUE_DATE),
195: VALUE_NAME = DECODE(X_VALUE_NAME, FND_API.G_MISS_CHAR, VALUE_NAME, X_VALUE_NAME),
196: ADDITIONAL_VALUE1 = DECODE(X_ADDITIONAL_VALUE1, FND_API.G_MISS_CHAR, ADDITIONAL_VALUE1, X_ADDITIONAL_VALUE1),
197: ADDITIONAL_VALUE2 = DECODE(X_ADDITIONAL_VALUE2, FND_API.G_MISS_CHAR, ADDITIONAL_VALUE2, X_ADDITIONAL_VALUE2),

Line 194: VALUE_DATE = DECODE(X_VALUE_DATE, FND_API.G_MISS_DATE, VALUE_DATE, X_VALUE_DATE),

190: CATEGORY = DECODE(X_CATEGORY, FND_API.G_MISS_CHAR, CATEGORY, X_CATEGORY),
191: PREFERENCE_CODE = DECODE(X_PREFERENCE_CODE,FND_API.G_MISS_CHAR, PREFERENCE_CODE, X_PREFERENCE_CODE),
192: VALUE_VARCHAR2 = DECODE(X_VALUE_VARCHAR2, FND_API.G_MISS_CHAR, VALUE_VARCHAR2, X_VALUE_VARCHAR2),
193: VALUE_NUMBER = DECODE(X_VALUE_NUMBER, FND_API.G_MISS_NUM, VALUE_NUMBER, X_VALUE_NUMBER),
194: VALUE_DATE = DECODE(X_VALUE_DATE, FND_API.G_MISS_DATE, VALUE_DATE, X_VALUE_DATE),
195: VALUE_NAME = DECODE(X_VALUE_NAME, FND_API.G_MISS_CHAR, VALUE_NAME, X_VALUE_NAME),
196: ADDITIONAL_VALUE1 = DECODE(X_ADDITIONAL_VALUE1, FND_API.G_MISS_CHAR, ADDITIONAL_VALUE1, X_ADDITIONAL_VALUE1),
197: ADDITIONAL_VALUE2 = DECODE(X_ADDITIONAL_VALUE2, FND_API.G_MISS_CHAR, ADDITIONAL_VALUE2, X_ADDITIONAL_VALUE2),
198: ADDITIONAL_VALUE3 = DECODE(X_ADDITIONAL_VALUE3, FND_API.G_MISS_CHAR, ADDITIONAL_VALUE3, X_ADDITIONAL_VALUE3),

Line 195: VALUE_NAME = DECODE(X_VALUE_NAME, FND_API.G_MISS_CHAR, VALUE_NAME, X_VALUE_NAME),

191: PREFERENCE_CODE = DECODE(X_PREFERENCE_CODE,FND_API.G_MISS_CHAR, PREFERENCE_CODE, X_PREFERENCE_CODE),
192: VALUE_VARCHAR2 = DECODE(X_VALUE_VARCHAR2, FND_API.G_MISS_CHAR, VALUE_VARCHAR2, X_VALUE_VARCHAR2),
193: VALUE_NUMBER = DECODE(X_VALUE_NUMBER, FND_API.G_MISS_NUM, VALUE_NUMBER, X_VALUE_NUMBER),
194: VALUE_DATE = DECODE(X_VALUE_DATE, FND_API.G_MISS_DATE, VALUE_DATE, X_VALUE_DATE),
195: VALUE_NAME = DECODE(X_VALUE_NAME, FND_API.G_MISS_CHAR, VALUE_NAME, X_VALUE_NAME),
196: ADDITIONAL_VALUE1 = DECODE(X_ADDITIONAL_VALUE1, FND_API.G_MISS_CHAR, ADDITIONAL_VALUE1, X_ADDITIONAL_VALUE1),
197: ADDITIONAL_VALUE2 = DECODE(X_ADDITIONAL_VALUE2, FND_API.G_MISS_CHAR, ADDITIONAL_VALUE2, X_ADDITIONAL_VALUE2),
198: ADDITIONAL_VALUE3 = DECODE(X_ADDITIONAL_VALUE3, FND_API.G_MISS_CHAR, ADDITIONAL_VALUE3, X_ADDITIONAL_VALUE3),
199: ADDITIONAL_VALUE4 = DECODE(X_ADDITIONAL_VALUE4, FND_API.G_MISS_CHAR, ADDITIONAL_VALUE4, X_ADDITIONAL_VALUE4),

Line 196: ADDITIONAL_VALUE1 = DECODE(X_ADDITIONAL_VALUE1, FND_API.G_MISS_CHAR, ADDITIONAL_VALUE1, X_ADDITIONAL_VALUE1),

192: VALUE_VARCHAR2 = DECODE(X_VALUE_VARCHAR2, FND_API.G_MISS_CHAR, VALUE_VARCHAR2, X_VALUE_VARCHAR2),
193: VALUE_NUMBER = DECODE(X_VALUE_NUMBER, FND_API.G_MISS_NUM, VALUE_NUMBER, X_VALUE_NUMBER),
194: VALUE_DATE = DECODE(X_VALUE_DATE, FND_API.G_MISS_DATE, VALUE_DATE, X_VALUE_DATE),
195: VALUE_NAME = DECODE(X_VALUE_NAME, FND_API.G_MISS_CHAR, VALUE_NAME, X_VALUE_NAME),
196: ADDITIONAL_VALUE1 = DECODE(X_ADDITIONAL_VALUE1, FND_API.G_MISS_CHAR, ADDITIONAL_VALUE1, X_ADDITIONAL_VALUE1),
197: ADDITIONAL_VALUE2 = DECODE(X_ADDITIONAL_VALUE2, FND_API.G_MISS_CHAR, ADDITIONAL_VALUE2, X_ADDITIONAL_VALUE2),
198: ADDITIONAL_VALUE3 = DECODE(X_ADDITIONAL_VALUE3, FND_API.G_MISS_CHAR, ADDITIONAL_VALUE3, X_ADDITIONAL_VALUE3),
199: ADDITIONAL_VALUE4 = DECODE(X_ADDITIONAL_VALUE4, FND_API.G_MISS_CHAR, ADDITIONAL_VALUE4, X_ADDITIONAL_VALUE4),
200: ADDITIONAL_VALUE5 = DECODE(X_ADDITIONAL_VALUE5, FND_API.G_MISS_CHAR, ADDITIONAL_VALUE5, X_ADDITIONAL_VALUE5),

Line 197: ADDITIONAL_VALUE2 = DECODE(X_ADDITIONAL_VALUE2, FND_API.G_MISS_CHAR, ADDITIONAL_VALUE2, X_ADDITIONAL_VALUE2),

193: VALUE_NUMBER = DECODE(X_VALUE_NUMBER, FND_API.G_MISS_NUM, VALUE_NUMBER, X_VALUE_NUMBER),
194: VALUE_DATE = DECODE(X_VALUE_DATE, FND_API.G_MISS_DATE, VALUE_DATE, X_VALUE_DATE),
195: VALUE_NAME = DECODE(X_VALUE_NAME, FND_API.G_MISS_CHAR, VALUE_NAME, X_VALUE_NAME),
196: ADDITIONAL_VALUE1 = DECODE(X_ADDITIONAL_VALUE1, FND_API.G_MISS_CHAR, ADDITIONAL_VALUE1, X_ADDITIONAL_VALUE1),
197: ADDITIONAL_VALUE2 = DECODE(X_ADDITIONAL_VALUE2, FND_API.G_MISS_CHAR, ADDITIONAL_VALUE2, X_ADDITIONAL_VALUE2),
198: ADDITIONAL_VALUE3 = DECODE(X_ADDITIONAL_VALUE3, FND_API.G_MISS_CHAR, ADDITIONAL_VALUE3, X_ADDITIONAL_VALUE3),
199: ADDITIONAL_VALUE4 = DECODE(X_ADDITIONAL_VALUE4, FND_API.G_MISS_CHAR, ADDITIONAL_VALUE4, X_ADDITIONAL_VALUE4),
200: ADDITIONAL_VALUE5 = DECODE(X_ADDITIONAL_VALUE5, FND_API.G_MISS_CHAR, ADDITIONAL_VALUE5, X_ADDITIONAL_VALUE5),
201: OBJECT_VERSION_NUMBER = DECODE(X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, X_OBJECT_VERSION_NUMBER),

Line 198: ADDITIONAL_VALUE3 = DECODE(X_ADDITIONAL_VALUE3, FND_API.G_MISS_CHAR, ADDITIONAL_VALUE3, X_ADDITIONAL_VALUE3),

194: VALUE_DATE = DECODE(X_VALUE_DATE, FND_API.G_MISS_DATE, VALUE_DATE, X_VALUE_DATE),
195: VALUE_NAME = DECODE(X_VALUE_NAME, FND_API.G_MISS_CHAR, VALUE_NAME, X_VALUE_NAME),
196: ADDITIONAL_VALUE1 = DECODE(X_ADDITIONAL_VALUE1, FND_API.G_MISS_CHAR, ADDITIONAL_VALUE1, X_ADDITIONAL_VALUE1),
197: ADDITIONAL_VALUE2 = DECODE(X_ADDITIONAL_VALUE2, FND_API.G_MISS_CHAR, ADDITIONAL_VALUE2, X_ADDITIONAL_VALUE2),
198: ADDITIONAL_VALUE3 = DECODE(X_ADDITIONAL_VALUE3, FND_API.G_MISS_CHAR, ADDITIONAL_VALUE3, X_ADDITIONAL_VALUE3),
199: ADDITIONAL_VALUE4 = DECODE(X_ADDITIONAL_VALUE4, FND_API.G_MISS_CHAR, ADDITIONAL_VALUE4, X_ADDITIONAL_VALUE4),
200: ADDITIONAL_VALUE5 = DECODE(X_ADDITIONAL_VALUE5, FND_API.G_MISS_CHAR, ADDITIONAL_VALUE5, X_ADDITIONAL_VALUE5),
201: OBJECT_VERSION_NUMBER = DECODE(X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, X_OBJECT_VERSION_NUMBER),
202: LAST_UPDATE_DATE = DECODE(X_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, X_LAST_UPDATE_DATE),

Line 199: ADDITIONAL_VALUE4 = DECODE(X_ADDITIONAL_VALUE4, FND_API.G_MISS_CHAR, ADDITIONAL_VALUE4, X_ADDITIONAL_VALUE4),

195: VALUE_NAME = DECODE(X_VALUE_NAME, FND_API.G_MISS_CHAR, VALUE_NAME, X_VALUE_NAME),
196: ADDITIONAL_VALUE1 = DECODE(X_ADDITIONAL_VALUE1, FND_API.G_MISS_CHAR, ADDITIONAL_VALUE1, X_ADDITIONAL_VALUE1),
197: ADDITIONAL_VALUE2 = DECODE(X_ADDITIONAL_VALUE2, FND_API.G_MISS_CHAR, ADDITIONAL_VALUE2, X_ADDITIONAL_VALUE2),
198: ADDITIONAL_VALUE3 = DECODE(X_ADDITIONAL_VALUE3, FND_API.G_MISS_CHAR, ADDITIONAL_VALUE3, X_ADDITIONAL_VALUE3),
199: ADDITIONAL_VALUE4 = DECODE(X_ADDITIONAL_VALUE4, FND_API.G_MISS_CHAR, ADDITIONAL_VALUE4, X_ADDITIONAL_VALUE4),
200: ADDITIONAL_VALUE5 = DECODE(X_ADDITIONAL_VALUE5, FND_API.G_MISS_CHAR, ADDITIONAL_VALUE5, X_ADDITIONAL_VALUE5),
201: OBJECT_VERSION_NUMBER = DECODE(X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, X_OBJECT_VERSION_NUMBER),
202: LAST_UPDATE_DATE = DECODE(X_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, X_LAST_UPDATE_DATE),
203: LAST_UPDATED_BY = DECODE(X_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, X_LAST_UPDATED_BY),

Line 200: ADDITIONAL_VALUE5 = DECODE(X_ADDITIONAL_VALUE5, FND_API.G_MISS_CHAR, ADDITIONAL_VALUE5, X_ADDITIONAL_VALUE5),

196: ADDITIONAL_VALUE1 = DECODE(X_ADDITIONAL_VALUE1, FND_API.G_MISS_CHAR, ADDITIONAL_VALUE1, X_ADDITIONAL_VALUE1),
197: ADDITIONAL_VALUE2 = DECODE(X_ADDITIONAL_VALUE2, FND_API.G_MISS_CHAR, ADDITIONAL_VALUE2, X_ADDITIONAL_VALUE2),
198: ADDITIONAL_VALUE3 = DECODE(X_ADDITIONAL_VALUE3, FND_API.G_MISS_CHAR, ADDITIONAL_VALUE3, X_ADDITIONAL_VALUE3),
199: ADDITIONAL_VALUE4 = DECODE(X_ADDITIONAL_VALUE4, FND_API.G_MISS_CHAR, ADDITIONAL_VALUE4, X_ADDITIONAL_VALUE4),
200: ADDITIONAL_VALUE5 = DECODE(X_ADDITIONAL_VALUE5, FND_API.G_MISS_CHAR, ADDITIONAL_VALUE5, X_ADDITIONAL_VALUE5),
201: OBJECT_VERSION_NUMBER = DECODE(X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, X_OBJECT_VERSION_NUMBER),
202: LAST_UPDATE_DATE = DECODE(X_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, X_LAST_UPDATE_DATE),
203: LAST_UPDATED_BY = DECODE(X_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, X_LAST_UPDATED_BY),
204: LAST_UPDATE_LOGIN = DECODE(X_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, X_LAST_UPDATE_LOGIN)

Line 201: OBJECT_VERSION_NUMBER = DECODE(X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, X_OBJECT_VERSION_NUMBER),

197: ADDITIONAL_VALUE2 = DECODE(X_ADDITIONAL_VALUE2, FND_API.G_MISS_CHAR, ADDITIONAL_VALUE2, X_ADDITIONAL_VALUE2),
198: ADDITIONAL_VALUE3 = DECODE(X_ADDITIONAL_VALUE3, FND_API.G_MISS_CHAR, ADDITIONAL_VALUE3, X_ADDITIONAL_VALUE3),
199: ADDITIONAL_VALUE4 = DECODE(X_ADDITIONAL_VALUE4, FND_API.G_MISS_CHAR, ADDITIONAL_VALUE4, X_ADDITIONAL_VALUE4),
200: ADDITIONAL_VALUE5 = DECODE(X_ADDITIONAL_VALUE5, FND_API.G_MISS_CHAR, ADDITIONAL_VALUE5, X_ADDITIONAL_VALUE5),
201: OBJECT_VERSION_NUMBER = DECODE(X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, X_OBJECT_VERSION_NUMBER),
202: LAST_UPDATE_DATE = DECODE(X_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, X_LAST_UPDATE_DATE),
203: LAST_UPDATED_BY = DECODE(X_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, X_LAST_UPDATED_BY),
204: LAST_UPDATE_LOGIN = DECODE(X_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, X_LAST_UPDATE_LOGIN)
205: where PARTY_PREFERENCE_ID = X_PARTY_PREFERENCE_ID;

Line 202: LAST_UPDATE_DATE = DECODE(X_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, X_LAST_UPDATE_DATE),

198: ADDITIONAL_VALUE3 = DECODE(X_ADDITIONAL_VALUE3, FND_API.G_MISS_CHAR, ADDITIONAL_VALUE3, X_ADDITIONAL_VALUE3),
199: ADDITIONAL_VALUE4 = DECODE(X_ADDITIONAL_VALUE4, FND_API.G_MISS_CHAR, ADDITIONAL_VALUE4, X_ADDITIONAL_VALUE4),
200: ADDITIONAL_VALUE5 = DECODE(X_ADDITIONAL_VALUE5, FND_API.G_MISS_CHAR, ADDITIONAL_VALUE5, X_ADDITIONAL_VALUE5),
201: OBJECT_VERSION_NUMBER = DECODE(X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, X_OBJECT_VERSION_NUMBER),
202: LAST_UPDATE_DATE = DECODE(X_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, X_LAST_UPDATE_DATE),
203: LAST_UPDATED_BY = DECODE(X_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, X_LAST_UPDATED_BY),
204: LAST_UPDATE_LOGIN = DECODE(X_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, X_LAST_UPDATE_LOGIN)
205: where PARTY_PREFERENCE_ID = X_PARTY_PREFERENCE_ID;
206:

Line 203: LAST_UPDATED_BY = DECODE(X_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, X_LAST_UPDATED_BY),

199: ADDITIONAL_VALUE4 = DECODE(X_ADDITIONAL_VALUE4, FND_API.G_MISS_CHAR, ADDITIONAL_VALUE4, X_ADDITIONAL_VALUE4),
200: ADDITIONAL_VALUE5 = DECODE(X_ADDITIONAL_VALUE5, FND_API.G_MISS_CHAR, ADDITIONAL_VALUE5, X_ADDITIONAL_VALUE5),
201: OBJECT_VERSION_NUMBER = DECODE(X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, X_OBJECT_VERSION_NUMBER),
202: LAST_UPDATE_DATE = DECODE(X_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, X_LAST_UPDATE_DATE),
203: LAST_UPDATED_BY = DECODE(X_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, X_LAST_UPDATED_BY),
204: LAST_UPDATE_LOGIN = DECODE(X_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, X_LAST_UPDATE_LOGIN)
205: where PARTY_PREFERENCE_ID = X_PARTY_PREFERENCE_ID;
206:
207: if (sql%notfound) then

Line 204: LAST_UPDATE_LOGIN = DECODE(X_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, X_LAST_UPDATE_LOGIN)

200: ADDITIONAL_VALUE5 = DECODE(X_ADDITIONAL_VALUE5, FND_API.G_MISS_CHAR, ADDITIONAL_VALUE5, X_ADDITIONAL_VALUE5),
201: OBJECT_VERSION_NUMBER = DECODE(X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, X_OBJECT_VERSION_NUMBER),
202: LAST_UPDATE_DATE = DECODE(X_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, X_LAST_UPDATE_DATE),
203: LAST_UPDATED_BY = DECODE(X_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, X_LAST_UPDATED_BY),
204: LAST_UPDATE_LOGIN = DECODE(X_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, X_LAST_UPDATE_LOGIN)
205: where PARTY_PREFERENCE_ID = X_PARTY_PREFERENCE_ID;
206:
207: if (sql%notfound) then
208: raise no_data_found;