74: /* Initially let us assign the return status to success */
75: x_return_status := FND_API.g_ret_sts_success;
76:
77: /* get values for row who cols */
78: IF NOT gmd_api_grp.setup_done THEN
79: gmd_api_grp.setup_done := gmd_api_grp.setup;
80: END IF;
81: IF NOT gmd_api_grp.setup_done THEN
82: RAISE setup_failure;
75: x_return_status := FND_API.g_ret_sts_success;
76:
77: /* get values for row who cols */
78: IF NOT gmd_api_grp.setup_done THEN
79: gmd_api_grp.setup_done := gmd_api_grp.setup;
80: END IF;
81: IF NOT gmd_api_grp.setup_done THEN
82: RAISE setup_failure;
83: END IF;
77: /* get values for row who cols */
78: IF NOT gmd_api_grp.setup_done THEN
79: gmd_api_grp.setup_done := gmd_api_grp.setup;
80: END IF;
81: IF NOT gmd_api_grp.setup_done THEN
82: RAISE setup_failure;
83: END IF;
84:
85: /* insert operation activities */
177: p_oprn_activity.ATTRIBUTE22,
178: p_oprn_activity.ATTRIBUTE23,
179: p_oprn_activity.ATTRIBUTE24,
180: sysdate,
181: gmd_api_grp.user_id,
182: sysdate,
183: gmd_api_grp.user_id,
184: gmd_api_grp.user_id);
185:
179: p_oprn_activity.ATTRIBUTE24,
180: sysdate,
181: gmd_api_grp.user_id,
182: sysdate,
183: gmd_api_grp.user_id,
184: gmd_api_grp.user_id);
185:
186: IF (l_debug = 'Y') THEN
187: gmd_debug.put_line('End insert_operation_activity private');
180: sysdate,
181: gmd_api_grp.user_id,
182: sysdate,
183: gmd_api_grp.user_id,
184: gmd_api_grp.user_id);
185:
186: IF (l_debug = 'Y') THEN
187: gmd_debug.put_line('End insert_operation_activity private');
188: END IF;
328: END LOOP;
329:
330: IF x_return_status = 'S' THEN
331: /* Set row who columns */
332: IF NOT gmd_api_grp.setup_done THEN
333: gmd_api_grp.setup_done := gmd_api_grp.setup;
334: END IF;
335: IF NOT gmd_api_grp.setup_done THEN
336: RAISE setup_failure;
329:
330: IF x_return_status = 'S' THEN
331: /* Set row who columns */
332: IF NOT gmd_api_grp.setup_done THEN
333: gmd_api_grp.setup_done := gmd_api_grp.setup;
334: END IF;
335: IF NOT gmd_api_grp.setup_done THEN
336: RAISE setup_failure;
337: END IF;
331: /* Set row who columns */
332: IF NOT gmd_api_grp.setup_done THEN
333: gmd_api_grp.setup_done := gmd_api_grp.setup;
334: END IF;
335: IF NOT gmd_api_grp.setup_done THEN
336: RAISE setup_failure;
337: END IF;
338:
339: IF (l_debug = 'Y') THEN
380: ATTRIBUTE22 = v_oprn_actv_update_rec.attribute22,
381: ATTRIBUTE23 = v_oprn_actv_update_rec.attribute23,
382: ATTRIBUTE24 = v_oprn_actv_update_rec.attribute24,
383: LAST_UPDATE_DATE = sysdate,
384: LAST_UPDATED_BY = gmd_api_grp.user_id,
385: LAST_UPDATE_LOGIN = gmd_api_grp.user_id
386: where oprn_line_id = p_oprn_line_id;
387: END IF;
388:
381: ATTRIBUTE23 = v_oprn_actv_update_rec.attribute23,
382: ATTRIBUTE24 = v_oprn_actv_update_rec.attribute24,
383: LAST_UPDATE_DATE = sysdate,
384: LAST_UPDATED_BY = gmd_api_grp.user_id,
385: LAST_UPDATE_LOGIN = gmd_api_grp.user_id
386: where oprn_line_id = p_oprn_line_id;
387: END IF;
388:
389: IF (l_debug = 'Y') THEN