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

Line 65: /* IF (px_org_id IS NULL OR px_org_id = FND_API.G_MISS_NUM) THEN

61: BEGIN
62:
63: -- R12 Enhancements
64: -- Fix for bug 4534945
65: /* IF (px_org_id IS NULL OR px_org_id = FND_API.G_MISS_NUM) THEN
66: SELECT NVL(TO_NUMBER(SUBSTRB(USERENV('CLIENT_INFO'),1,10)),-99)
67: INTO px_org_id
68: FROM DUAL;
69: END IF;

Line 107: DECODE( px_time_allocation_id, FND_API.G_MISS_NUM, NULL, px_time_allocation_id),

103: attribute15,
104: org_id)
105: VALUES
106: (
107: DECODE( px_time_allocation_id, FND_API.G_MISS_NUM, NULL, px_time_allocation_id),
108: DECODE( p_allocation_for, FND_API.g_miss_char, NULL, p_allocation_for),
109: DECODE( p_allocation_for_id, FND_API.G_MISS_NUM, NULL, p_allocation_for_id),
110: DECODE( p_time_id, FND_API.G_MISS_NUM, NULL, p_time_id),
111: DECODE( p_period_type_id, FND_API.G_MISS_NUM, NULL, p_period_type_id),

Line 108: DECODE( p_allocation_for, FND_API.g_miss_char, NULL, p_allocation_for),

104: org_id)
105: VALUES
106: (
107: DECODE( px_time_allocation_id, FND_API.G_MISS_NUM, NULL, px_time_allocation_id),
108: DECODE( p_allocation_for, FND_API.g_miss_char, NULL, p_allocation_for),
109: DECODE( p_allocation_for_id, FND_API.G_MISS_NUM, NULL, p_allocation_for_id),
110: DECODE( p_time_id, FND_API.G_MISS_NUM, NULL, p_time_id),
111: DECODE( p_period_type_id, FND_API.G_MISS_NUM, NULL, p_period_type_id),
112: DECODE( p_target, FND_API.G_MISS_NUM, NULL, p_target),

Line 109: DECODE( p_allocation_for_id, FND_API.G_MISS_NUM, NULL, p_allocation_for_id),

105: VALUES
106: (
107: DECODE( px_time_allocation_id, FND_API.G_MISS_NUM, NULL, px_time_allocation_id),
108: DECODE( p_allocation_for, FND_API.g_miss_char, NULL, p_allocation_for),
109: DECODE( p_allocation_for_id, FND_API.G_MISS_NUM, NULL, p_allocation_for_id),
110: DECODE( p_time_id, FND_API.G_MISS_NUM, NULL, p_time_id),
111: DECODE( p_period_type_id, FND_API.G_MISS_NUM, NULL, p_period_type_id),
112: DECODE( p_target, FND_API.G_MISS_NUM, NULL, p_target),
113: DECODE( p_lysp_sales, FND_API.G_MISS_NUM, NULL, p_lysp_sales),

Line 110: DECODE( p_time_id, FND_API.G_MISS_NUM, NULL, p_time_id),

106: (
107: DECODE( px_time_allocation_id, FND_API.G_MISS_NUM, NULL, px_time_allocation_id),
108: DECODE( p_allocation_for, FND_API.g_miss_char, NULL, p_allocation_for),
109: DECODE( p_allocation_for_id, FND_API.G_MISS_NUM, NULL, p_allocation_for_id),
110: DECODE( p_time_id, FND_API.G_MISS_NUM, NULL, p_time_id),
111: DECODE( p_period_type_id, FND_API.G_MISS_NUM, NULL, p_period_type_id),
112: DECODE( p_target, FND_API.G_MISS_NUM, NULL, p_target),
113: DECODE( p_lysp_sales, FND_API.G_MISS_NUM, NULL, p_lysp_sales),
114: px_object_version_number,

Line 111: DECODE( p_period_type_id, FND_API.G_MISS_NUM, NULL, p_period_type_id),

107: DECODE( px_time_allocation_id, FND_API.G_MISS_NUM, NULL, px_time_allocation_id),
108: DECODE( p_allocation_for, FND_API.g_miss_char, NULL, p_allocation_for),
109: DECODE( p_allocation_for_id, FND_API.G_MISS_NUM, NULL, p_allocation_for_id),
110: DECODE( p_time_id, FND_API.G_MISS_NUM, NULL, p_time_id),
111: DECODE( p_period_type_id, FND_API.G_MISS_NUM, NULL, p_period_type_id),
112: DECODE( p_target, FND_API.G_MISS_NUM, NULL, p_target),
113: DECODE( p_lysp_sales, FND_API.G_MISS_NUM, NULL, p_lysp_sales),
114: px_object_version_number,
115: DECODE( p_creation_date, to_date(NULL), SYSDATE, p_creation_date),

Line 112: DECODE( p_target, FND_API.G_MISS_NUM, NULL, p_target),

108: DECODE( p_allocation_for, FND_API.g_miss_char, NULL, p_allocation_for),
109: DECODE( p_allocation_for_id, FND_API.G_MISS_NUM, NULL, p_allocation_for_id),
110: DECODE( p_time_id, FND_API.G_MISS_NUM, NULL, p_time_id),
111: DECODE( p_period_type_id, FND_API.G_MISS_NUM, NULL, p_period_type_id),
112: DECODE( p_target, FND_API.G_MISS_NUM, NULL, p_target),
113: DECODE( p_lysp_sales, FND_API.G_MISS_NUM, NULL, p_lysp_sales),
114: px_object_version_number,
115: DECODE( p_creation_date, to_date(NULL), SYSDATE, p_creation_date),
116: DECODE( p_created_by, null, FND_GLOBAL.USER_ID, p_created_by),

Line 113: DECODE( p_lysp_sales, FND_API.G_MISS_NUM, NULL, p_lysp_sales),

109: DECODE( p_allocation_for_id, FND_API.G_MISS_NUM, NULL, p_allocation_for_id),
110: DECODE( p_time_id, FND_API.G_MISS_NUM, NULL, p_time_id),
111: DECODE( p_period_type_id, FND_API.G_MISS_NUM, NULL, p_period_type_id),
112: DECODE( p_target, FND_API.G_MISS_NUM, NULL, p_target),
113: DECODE( p_lysp_sales, FND_API.G_MISS_NUM, NULL, p_lysp_sales),
114: px_object_version_number,
115: DECODE( p_creation_date, to_date(NULL), SYSDATE, p_creation_date),
116: DECODE( p_created_by, null, FND_GLOBAL.USER_ID, p_created_by),
117: DECODE( p_last_update_date, to_date(NULL), SYSDATE, p_last_update_date),

Line 120: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),

116: DECODE( p_created_by, null, FND_GLOBAL.USER_ID, p_created_by),
117: DECODE( p_last_update_date, to_date(NULL), SYSDATE, p_last_update_date),
118: DECODE( p_last_updated_by, null, FND_GLOBAL.USER_ID, p_last_updated_by),
119: DECODE( p_last_update_login, null, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
120: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
121: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
122: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
123: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
124: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),

Line 121: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),

117: DECODE( p_last_update_date, to_date(NULL), SYSDATE, p_last_update_date),
118: DECODE( p_last_updated_by, null, FND_GLOBAL.USER_ID, p_last_updated_by),
119: DECODE( p_last_update_login, null, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
120: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
121: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
122: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
123: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
124: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
125: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),

Line 122: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),

118: DECODE( p_last_updated_by, null, FND_GLOBAL.USER_ID, p_last_updated_by),
119: DECODE( p_last_update_login, null, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
120: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
121: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
122: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
123: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
124: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
125: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
126: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),

Line 123: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),

119: DECODE( p_last_update_login, null, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
120: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
121: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
122: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
123: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
124: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
125: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
126: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
127: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),

Line 124: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),

120: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
121: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
122: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
123: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
124: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
125: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
126: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
127: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
128: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),

Line 125: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),

121: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
122: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
123: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
124: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
125: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
126: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
127: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
128: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
129: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),

Line 126: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),

122: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
123: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
124: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
125: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
126: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
127: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
128: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
129: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
130: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),

Line 127: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),

123: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
124: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
125: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
126: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
127: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
128: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
129: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
130: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
131: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),

Line 128: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),

124: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
125: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
126: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
127: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
128: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
129: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
130: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
131: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
132: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),

Line 129: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),

125: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
126: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
127: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
128: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
129: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
130: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
131: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
132: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
133: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),

Line 130: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),

126: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
127: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
128: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
129: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
130: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
131: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
132: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
133: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
134: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),

Line 131: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),

127: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
128: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
129: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
130: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
131: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
132: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
133: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
134: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
135: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15),

Line 132: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),

128: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
129: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
130: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
131: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
132: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
133: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
134: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
135: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15),
136: px_org_id

Line 133: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),

129: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
130: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
131: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
132: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
133: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
134: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
135: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15),
136: px_org_id
137: );

Line 134: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),

130: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
131: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
132: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
133: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
134: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
135: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15),
136: px_org_id
137: );
138:

Line 135: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15),

131: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
132: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
133: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
134: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
135: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15),
136: px_org_id
137: );
138:
139: END Insert_Row;

Line 189: allocation_for = DECODE( p_allocation_for, null, allocation_for, FND_API.g_miss_char, null, p_allocation_for),

185: IS
186: BEGIN
187: Update ozf_time_allocations
188: SET
189: allocation_for = DECODE( p_allocation_for, null, allocation_for, FND_API.g_miss_char, null, p_allocation_for),
190: allocation_for_id = DECODE( p_allocation_for_id, null, allocation_for_id, FND_API.G_MISS_NUM, null, p_allocation_for_id),
191: time_id = DECODE( p_time_id, null, time_id, FND_API.G_MISS_NUM, null, p_time_id),
192: period_type_id = DECODE( p_period_type_id, null, period_type_id, FND_API.G_MISS_NUM, null, p_period_type_id),
193: target = DECODE( p_target, null, target, FND_API.G_MISS_NUM, null, p_target),

Line 190: allocation_for_id = DECODE( p_allocation_for_id, null, allocation_for_id, FND_API.G_MISS_NUM, null, p_allocation_for_id),

186: BEGIN
187: Update ozf_time_allocations
188: SET
189: allocation_for = DECODE( p_allocation_for, null, allocation_for, FND_API.g_miss_char, null, p_allocation_for),
190: allocation_for_id = DECODE( p_allocation_for_id, null, allocation_for_id, FND_API.G_MISS_NUM, null, p_allocation_for_id),
191: time_id = DECODE( p_time_id, null, time_id, FND_API.G_MISS_NUM, null, p_time_id),
192: period_type_id = DECODE( p_period_type_id, null, period_type_id, FND_API.G_MISS_NUM, null, p_period_type_id),
193: target = DECODE( p_target, null, target, FND_API.G_MISS_NUM, null, p_target),
194: lysp_sales = DECODE( p_lysp_sales, null, lysp_sales, FND_API.G_MISS_NUM, null, p_lysp_sales),

Line 191: time_id = DECODE( p_time_id, null, time_id, FND_API.G_MISS_NUM, null, p_time_id),

187: Update ozf_time_allocations
188: SET
189: allocation_for = DECODE( p_allocation_for, null, allocation_for, FND_API.g_miss_char, null, p_allocation_for),
190: allocation_for_id = DECODE( p_allocation_for_id, null, allocation_for_id, FND_API.G_MISS_NUM, null, p_allocation_for_id),
191: time_id = DECODE( p_time_id, null, time_id, FND_API.G_MISS_NUM, null, p_time_id),
192: period_type_id = DECODE( p_period_type_id, null, period_type_id, FND_API.G_MISS_NUM, null, p_period_type_id),
193: target = DECODE( p_target, null, target, FND_API.G_MISS_NUM, null, p_target),
194: lysp_sales = DECODE( p_lysp_sales, null, lysp_sales, FND_API.G_MISS_NUM, null, p_lysp_sales),
195: object_version_number = nvl(p_object_version_number, object_version_number) + 1 ,

Line 192: period_type_id = DECODE( p_period_type_id, null, period_type_id, FND_API.G_MISS_NUM, null, p_period_type_id),

188: SET
189: allocation_for = DECODE( p_allocation_for, null, allocation_for, FND_API.g_miss_char, null, p_allocation_for),
190: allocation_for_id = DECODE( p_allocation_for_id, null, allocation_for_id, FND_API.G_MISS_NUM, null, p_allocation_for_id),
191: time_id = DECODE( p_time_id, null, time_id, FND_API.G_MISS_NUM, null, p_time_id),
192: period_type_id = DECODE( p_period_type_id, null, period_type_id, FND_API.G_MISS_NUM, null, p_period_type_id),
193: target = DECODE( p_target, null, target, FND_API.G_MISS_NUM, null, p_target),
194: lysp_sales = DECODE( p_lysp_sales, null, lysp_sales, FND_API.G_MISS_NUM, null, p_lysp_sales),
195: object_version_number = nvl(p_object_version_number, object_version_number) + 1 ,
196: last_update_date = DECODE( p_last_update_date, to_date(NULL), SYSDATE, p_last_update_date),

Line 193: target = DECODE( p_target, null, target, FND_API.G_MISS_NUM, null, p_target),

189: allocation_for = DECODE( p_allocation_for, null, allocation_for, FND_API.g_miss_char, null, p_allocation_for),
190: allocation_for_id = DECODE( p_allocation_for_id, null, allocation_for_id, FND_API.G_MISS_NUM, null, p_allocation_for_id),
191: time_id = DECODE( p_time_id, null, time_id, FND_API.G_MISS_NUM, null, p_time_id),
192: period_type_id = DECODE( p_period_type_id, null, period_type_id, FND_API.G_MISS_NUM, null, p_period_type_id),
193: target = DECODE( p_target, null, target, FND_API.G_MISS_NUM, null, p_target),
194: lysp_sales = DECODE( p_lysp_sales, null, lysp_sales, FND_API.G_MISS_NUM, null, p_lysp_sales),
195: object_version_number = nvl(p_object_version_number, object_version_number) + 1 ,
196: last_update_date = DECODE( p_last_update_date, to_date(NULL), SYSDATE, p_last_update_date),
197: last_updated_by = DECODE( p_last_updated_by, null, FND_GLOBAL.USER_ID, p_last_updated_by),

Line 194: lysp_sales = DECODE( p_lysp_sales, null, lysp_sales, FND_API.G_MISS_NUM, null, p_lysp_sales),

190: allocation_for_id = DECODE( p_allocation_for_id, null, allocation_for_id, FND_API.G_MISS_NUM, null, p_allocation_for_id),
191: time_id = DECODE( p_time_id, null, time_id, FND_API.G_MISS_NUM, null, p_time_id),
192: period_type_id = DECODE( p_period_type_id, null, period_type_id, FND_API.G_MISS_NUM, null, p_period_type_id),
193: target = DECODE( p_target, null, target, FND_API.G_MISS_NUM, null, p_target),
194: lysp_sales = DECODE( p_lysp_sales, null, lysp_sales, FND_API.G_MISS_NUM, null, p_lysp_sales),
195: object_version_number = nvl(p_object_version_number, object_version_number) + 1 ,
196: last_update_date = DECODE( p_last_update_date, to_date(NULL), SYSDATE, p_last_update_date),
197: last_updated_by = DECODE( p_last_updated_by, null, FND_GLOBAL.USER_ID, p_last_updated_by),
198: last_update_login = DECODE( p_last_update_login, null, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),

Line 199: attribute_category = DECODE( p_attribute_category, null, attribute_category, FND_API.g_miss_char, null, p_attribute_category),

195: object_version_number = nvl(p_object_version_number, object_version_number) + 1 ,
196: last_update_date = DECODE( p_last_update_date, to_date(NULL), SYSDATE, p_last_update_date),
197: last_updated_by = DECODE( p_last_updated_by, null, FND_GLOBAL.USER_ID, p_last_updated_by),
198: last_update_login = DECODE( p_last_update_login, null, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
199: attribute_category = DECODE( p_attribute_category, null, attribute_category, FND_API.g_miss_char, null, p_attribute_category),
200: attribute1 = DECODE( p_attribute1, null, attribute1, FND_API.g_miss_char, null, p_attribute1),
201: attribute2 = DECODE( p_attribute2, null, attribute2, FND_API.g_miss_char, null, p_attribute2),
202: attribute3 = DECODE( p_attribute3, null, attribute3, FND_API.g_miss_char, null, p_attribute3),
203: attribute4 = DECODE( p_attribute4, null, attribute4, FND_API.g_miss_char, null, p_attribute4),

Line 200: attribute1 = DECODE( p_attribute1, null, attribute1, FND_API.g_miss_char, null, p_attribute1),

196: last_update_date = DECODE( p_last_update_date, to_date(NULL), SYSDATE, p_last_update_date),
197: last_updated_by = DECODE( p_last_updated_by, null, FND_GLOBAL.USER_ID, p_last_updated_by),
198: last_update_login = DECODE( p_last_update_login, null, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
199: attribute_category = DECODE( p_attribute_category, null, attribute_category, FND_API.g_miss_char, null, p_attribute_category),
200: attribute1 = DECODE( p_attribute1, null, attribute1, FND_API.g_miss_char, null, p_attribute1),
201: attribute2 = DECODE( p_attribute2, null, attribute2, FND_API.g_miss_char, null, p_attribute2),
202: attribute3 = DECODE( p_attribute3, null, attribute3, FND_API.g_miss_char, null, p_attribute3),
203: attribute4 = DECODE( p_attribute4, null, attribute4, FND_API.g_miss_char, null, p_attribute4),
204: attribute5 = DECODE( p_attribute5, null, attribute5, FND_API.g_miss_char, null, p_attribute5),

Line 201: attribute2 = DECODE( p_attribute2, null, attribute2, FND_API.g_miss_char, null, p_attribute2),

197: last_updated_by = DECODE( p_last_updated_by, null, FND_GLOBAL.USER_ID, p_last_updated_by),
198: last_update_login = DECODE( p_last_update_login, null, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
199: attribute_category = DECODE( p_attribute_category, null, attribute_category, FND_API.g_miss_char, null, p_attribute_category),
200: attribute1 = DECODE( p_attribute1, null, attribute1, FND_API.g_miss_char, null, p_attribute1),
201: attribute2 = DECODE( p_attribute2, null, attribute2, FND_API.g_miss_char, null, p_attribute2),
202: attribute3 = DECODE( p_attribute3, null, attribute3, FND_API.g_miss_char, null, p_attribute3),
203: attribute4 = DECODE( p_attribute4, null, attribute4, FND_API.g_miss_char, null, p_attribute4),
204: attribute5 = DECODE( p_attribute5, null, attribute5, FND_API.g_miss_char, null, p_attribute5),
205: attribute6 = DECODE( p_attribute6, null, attribute6, FND_API.g_miss_char, null, p_attribute6),

Line 202: attribute3 = DECODE( p_attribute3, null, attribute3, FND_API.g_miss_char, null, p_attribute3),

198: last_update_login = DECODE( p_last_update_login, null, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
199: attribute_category = DECODE( p_attribute_category, null, attribute_category, FND_API.g_miss_char, null, p_attribute_category),
200: attribute1 = DECODE( p_attribute1, null, attribute1, FND_API.g_miss_char, null, p_attribute1),
201: attribute2 = DECODE( p_attribute2, null, attribute2, FND_API.g_miss_char, null, p_attribute2),
202: attribute3 = DECODE( p_attribute3, null, attribute3, FND_API.g_miss_char, null, p_attribute3),
203: attribute4 = DECODE( p_attribute4, null, attribute4, FND_API.g_miss_char, null, p_attribute4),
204: attribute5 = DECODE( p_attribute5, null, attribute5, FND_API.g_miss_char, null, p_attribute5),
205: attribute6 = DECODE( p_attribute6, null, attribute6, FND_API.g_miss_char, null, p_attribute6),
206: attribute7 = DECODE( p_attribute7, null, attribute7, FND_API.g_miss_char, null, p_attribute7),

Line 203: attribute4 = DECODE( p_attribute4, null, attribute4, FND_API.g_miss_char, null, p_attribute4),

199: attribute_category = DECODE( p_attribute_category, null, attribute_category, FND_API.g_miss_char, null, p_attribute_category),
200: attribute1 = DECODE( p_attribute1, null, attribute1, FND_API.g_miss_char, null, p_attribute1),
201: attribute2 = DECODE( p_attribute2, null, attribute2, FND_API.g_miss_char, null, p_attribute2),
202: attribute3 = DECODE( p_attribute3, null, attribute3, FND_API.g_miss_char, null, p_attribute3),
203: attribute4 = DECODE( p_attribute4, null, attribute4, FND_API.g_miss_char, null, p_attribute4),
204: attribute5 = DECODE( p_attribute5, null, attribute5, FND_API.g_miss_char, null, p_attribute5),
205: attribute6 = DECODE( p_attribute6, null, attribute6, FND_API.g_miss_char, null, p_attribute6),
206: attribute7 = DECODE( p_attribute7, null, attribute7, FND_API.g_miss_char, null, p_attribute7),
207: attribute8 = DECODE( p_attribute8, null, attribute8, FND_API.g_miss_char, null, p_attribute8),

Line 204: attribute5 = DECODE( p_attribute5, null, attribute5, FND_API.g_miss_char, null, p_attribute5),

200: attribute1 = DECODE( p_attribute1, null, attribute1, FND_API.g_miss_char, null, p_attribute1),
201: attribute2 = DECODE( p_attribute2, null, attribute2, FND_API.g_miss_char, null, p_attribute2),
202: attribute3 = DECODE( p_attribute3, null, attribute3, FND_API.g_miss_char, null, p_attribute3),
203: attribute4 = DECODE( p_attribute4, null, attribute4, FND_API.g_miss_char, null, p_attribute4),
204: attribute5 = DECODE( p_attribute5, null, attribute5, FND_API.g_miss_char, null, p_attribute5),
205: attribute6 = DECODE( p_attribute6, null, attribute6, FND_API.g_miss_char, null, p_attribute6),
206: attribute7 = DECODE( p_attribute7, null, attribute7, FND_API.g_miss_char, null, p_attribute7),
207: attribute8 = DECODE( p_attribute8, null, attribute8, FND_API.g_miss_char, null, p_attribute8),
208: attribute9 = DECODE( p_attribute9, null, attribute9, FND_API.g_miss_char, null, p_attribute9),

Line 205: attribute6 = DECODE( p_attribute6, null, attribute6, FND_API.g_miss_char, null, p_attribute6),

201: attribute2 = DECODE( p_attribute2, null, attribute2, FND_API.g_miss_char, null, p_attribute2),
202: attribute3 = DECODE( p_attribute3, null, attribute3, FND_API.g_miss_char, null, p_attribute3),
203: attribute4 = DECODE( p_attribute4, null, attribute4, FND_API.g_miss_char, null, p_attribute4),
204: attribute5 = DECODE( p_attribute5, null, attribute5, FND_API.g_miss_char, null, p_attribute5),
205: attribute6 = DECODE( p_attribute6, null, attribute6, FND_API.g_miss_char, null, p_attribute6),
206: attribute7 = DECODE( p_attribute7, null, attribute7, FND_API.g_miss_char, null, p_attribute7),
207: attribute8 = DECODE( p_attribute8, null, attribute8, FND_API.g_miss_char, null, p_attribute8),
208: attribute9 = DECODE( p_attribute9, null, attribute9, FND_API.g_miss_char, null, p_attribute9),
209: attribute10 = DECODE( p_attribute10, null, attribute10, FND_API.g_miss_char, null, p_attribute10),

Line 206: attribute7 = DECODE( p_attribute7, null, attribute7, FND_API.g_miss_char, null, p_attribute7),

202: attribute3 = DECODE( p_attribute3, null, attribute3, FND_API.g_miss_char, null, p_attribute3),
203: attribute4 = DECODE( p_attribute4, null, attribute4, FND_API.g_miss_char, null, p_attribute4),
204: attribute5 = DECODE( p_attribute5, null, attribute5, FND_API.g_miss_char, null, p_attribute5),
205: attribute6 = DECODE( p_attribute6, null, attribute6, FND_API.g_miss_char, null, p_attribute6),
206: attribute7 = DECODE( p_attribute7, null, attribute7, FND_API.g_miss_char, null, p_attribute7),
207: attribute8 = DECODE( p_attribute8, null, attribute8, FND_API.g_miss_char, null, p_attribute8),
208: attribute9 = DECODE( p_attribute9, null, attribute9, FND_API.g_miss_char, null, p_attribute9),
209: attribute10 = DECODE( p_attribute10, null, attribute10, FND_API.g_miss_char, null, p_attribute10),
210: attribute11 = DECODE( p_attribute11, null, attribute11, FND_API.g_miss_char, null, p_attribute11),

Line 207: attribute8 = DECODE( p_attribute8, null, attribute8, FND_API.g_miss_char, null, p_attribute8),

203: attribute4 = DECODE( p_attribute4, null, attribute4, FND_API.g_miss_char, null, p_attribute4),
204: attribute5 = DECODE( p_attribute5, null, attribute5, FND_API.g_miss_char, null, p_attribute5),
205: attribute6 = DECODE( p_attribute6, null, attribute6, FND_API.g_miss_char, null, p_attribute6),
206: attribute7 = DECODE( p_attribute7, null, attribute7, FND_API.g_miss_char, null, p_attribute7),
207: attribute8 = DECODE( p_attribute8, null, attribute8, FND_API.g_miss_char, null, p_attribute8),
208: attribute9 = DECODE( p_attribute9, null, attribute9, FND_API.g_miss_char, null, p_attribute9),
209: attribute10 = DECODE( p_attribute10, null, attribute10, FND_API.g_miss_char, null, p_attribute10),
210: attribute11 = DECODE( p_attribute11, null, attribute11, FND_API.g_miss_char, null, p_attribute11),
211: attribute12 = DECODE( p_attribute12, null, attribute12, FND_API.g_miss_char, null, p_attribute12),

Line 208: attribute9 = DECODE( p_attribute9, null, attribute9, FND_API.g_miss_char, null, p_attribute9),

204: attribute5 = DECODE( p_attribute5, null, attribute5, FND_API.g_miss_char, null, p_attribute5),
205: attribute6 = DECODE( p_attribute6, null, attribute6, FND_API.g_miss_char, null, p_attribute6),
206: attribute7 = DECODE( p_attribute7, null, attribute7, FND_API.g_miss_char, null, p_attribute7),
207: attribute8 = DECODE( p_attribute8, null, attribute8, FND_API.g_miss_char, null, p_attribute8),
208: attribute9 = DECODE( p_attribute9, null, attribute9, FND_API.g_miss_char, null, p_attribute9),
209: attribute10 = DECODE( p_attribute10, null, attribute10, FND_API.g_miss_char, null, p_attribute10),
210: attribute11 = DECODE( p_attribute11, null, attribute11, FND_API.g_miss_char, null, p_attribute11),
211: attribute12 = DECODE( p_attribute12, null, attribute12, FND_API.g_miss_char, null, p_attribute12),
212: attribute13 = DECODE( p_attribute13, null, attribute13, FND_API.g_miss_char, null, p_attribute13),

Line 209: attribute10 = DECODE( p_attribute10, null, attribute10, FND_API.g_miss_char, null, p_attribute10),

205: attribute6 = DECODE( p_attribute6, null, attribute6, FND_API.g_miss_char, null, p_attribute6),
206: attribute7 = DECODE( p_attribute7, null, attribute7, FND_API.g_miss_char, null, p_attribute7),
207: attribute8 = DECODE( p_attribute8, null, attribute8, FND_API.g_miss_char, null, p_attribute8),
208: attribute9 = DECODE( p_attribute9, null, attribute9, FND_API.g_miss_char, null, p_attribute9),
209: attribute10 = DECODE( p_attribute10, null, attribute10, FND_API.g_miss_char, null, p_attribute10),
210: attribute11 = DECODE( p_attribute11, null, attribute11, FND_API.g_miss_char, null, p_attribute11),
211: attribute12 = DECODE( p_attribute12, null, attribute12, FND_API.g_miss_char, null, p_attribute12),
212: attribute13 = DECODE( p_attribute13, null, attribute13, FND_API.g_miss_char, null, p_attribute13),
213: attribute14 = DECODE( p_attribute14, null, attribute14, FND_API.g_miss_char, null, p_attribute14),

Line 210: attribute11 = DECODE( p_attribute11, null, attribute11, FND_API.g_miss_char, null, p_attribute11),

206: attribute7 = DECODE( p_attribute7, null, attribute7, FND_API.g_miss_char, null, p_attribute7),
207: attribute8 = DECODE( p_attribute8, null, attribute8, FND_API.g_miss_char, null, p_attribute8),
208: attribute9 = DECODE( p_attribute9, null, attribute9, FND_API.g_miss_char, null, p_attribute9),
209: attribute10 = DECODE( p_attribute10, null, attribute10, FND_API.g_miss_char, null, p_attribute10),
210: attribute11 = DECODE( p_attribute11, null, attribute11, FND_API.g_miss_char, null, p_attribute11),
211: attribute12 = DECODE( p_attribute12, null, attribute12, FND_API.g_miss_char, null, p_attribute12),
212: attribute13 = DECODE( p_attribute13, null, attribute13, FND_API.g_miss_char, null, p_attribute13),
213: attribute14 = DECODE( p_attribute14, null, attribute14, FND_API.g_miss_char, null, p_attribute14),
214: attribute15 = DECODE( p_attribute15, null, attribute15, FND_API.g_miss_char, null, p_attribute15)

Line 211: attribute12 = DECODE( p_attribute12, null, attribute12, FND_API.g_miss_char, null, p_attribute12),

207: attribute8 = DECODE( p_attribute8, null, attribute8, FND_API.g_miss_char, null, p_attribute8),
208: attribute9 = DECODE( p_attribute9, null, attribute9, FND_API.g_miss_char, null, p_attribute9),
209: attribute10 = DECODE( p_attribute10, null, attribute10, FND_API.g_miss_char, null, p_attribute10),
210: attribute11 = DECODE( p_attribute11, null, attribute11, FND_API.g_miss_char, null, p_attribute11),
211: attribute12 = DECODE( p_attribute12, null, attribute12, FND_API.g_miss_char, null, p_attribute12),
212: attribute13 = DECODE( p_attribute13, null, attribute13, FND_API.g_miss_char, null, p_attribute13),
213: attribute14 = DECODE( p_attribute14, null, attribute14, FND_API.g_miss_char, null, p_attribute14),
214: attribute15 = DECODE( p_attribute15, null, attribute15, FND_API.g_miss_char, null, p_attribute15)
215: WHERE time_allocation_id = p_time_allocation_id;

Line 212: attribute13 = DECODE( p_attribute13, null, attribute13, FND_API.g_miss_char, null, p_attribute13),

208: attribute9 = DECODE( p_attribute9, null, attribute9, FND_API.g_miss_char, null, p_attribute9),
209: attribute10 = DECODE( p_attribute10, null, attribute10, FND_API.g_miss_char, null, p_attribute10),
210: attribute11 = DECODE( p_attribute11, null, attribute11, FND_API.g_miss_char, null, p_attribute11),
211: attribute12 = DECODE( p_attribute12, null, attribute12, FND_API.g_miss_char, null, p_attribute12),
212: attribute13 = DECODE( p_attribute13, null, attribute13, FND_API.g_miss_char, null, p_attribute13),
213: attribute14 = DECODE( p_attribute14, null, attribute14, FND_API.g_miss_char, null, p_attribute14),
214: attribute15 = DECODE( p_attribute15, null, attribute15, FND_API.g_miss_char, null, p_attribute15)
215: WHERE time_allocation_id = p_time_allocation_id;
216: -- AND object_version_number = p_object_version_number;

Line 213: attribute14 = DECODE( p_attribute14, null, attribute14, FND_API.g_miss_char, null, p_attribute14),

209: attribute10 = DECODE( p_attribute10, null, attribute10, FND_API.g_miss_char, null, p_attribute10),
210: attribute11 = DECODE( p_attribute11, null, attribute11, FND_API.g_miss_char, null, p_attribute11),
211: attribute12 = DECODE( p_attribute12, null, attribute12, FND_API.g_miss_char, null, p_attribute12),
212: attribute13 = DECODE( p_attribute13, null, attribute13, FND_API.g_miss_char, null, p_attribute13),
213: attribute14 = DECODE( p_attribute14, null, attribute14, FND_API.g_miss_char, null, p_attribute14),
214: attribute15 = DECODE( p_attribute15, null, attribute15, FND_API.g_miss_char, null, p_attribute15)
215: WHERE time_allocation_id = p_time_allocation_id;
216: -- AND object_version_number = p_object_version_number;
217:

Line 214: attribute15 = DECODE( p_attribute15, null, attribute15, FND_API.g_miss_char, null, p_attribute15)

210: attribute11 = DECODE( p_attribute11, null, attribute11, FND_API.g_miss_char, null, p_attribute11),
211: attribute12 = DECODE( p_attribute12, null, attribute12, FND_API.g_miss_char, null, p_attribute12),
212: attribute13 = DECODE( p_attribute13, null, attribute13, FND_API.g_miss_char, null, p_attribute13),
213: attribute14 = DECODE( p_attribute14, null, attribute14, FND_API.g_miss_char, null, p_attribute14),
214: attribute15 = DECODE( p_attribute15, null, attribute15, FND_API.g_miss_char, null, p_attribute15)
215: WHERE time_allocation_id = p_time_allocation_id;
216: -- AND object_version_number = p_object_version_number;
217:
218:

Line 220: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

216: -- AND object_version_number = p_object_version_number;
217:
218:
219: IF (SQL%NOTFOUND) THEN
220: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
221: END IF;
222:
223:
224: END Update_Row;

Line 250: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

246: DELETE FROM ozf_time_allocations
247: WHERE time_allocation_id = p_time_allocation_id
248: AND object_version_number = p_object_version_number;
249: If (SQL%NOTFOUND) then
250: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
251: End If;
252: END Delete_Row ;
253:
254:

Line 288: RAISE FND_API.g_exc_error;

284: FETCH c INTO Recinfo;
285: IF (c%NOTFOUND) THEN
286: CLOSE c;
287: AMS_Utility_PVT.error_message ('AMS_API_RECORD_NOT_FOUND');
288: RAISE FND_API.g_exc_error;
289: END IF;
290: CLOSE c;
291: END Lock_Row;
292: