175: v_std_usage_uom,
176: l_resources_rec.nominal_cost,
177: l_resources_rec.inactive_ind,
178: sysdate,
179: FND_GLOBAL.user_id, /* Bug 6412180 */
180: sysdate,
181: FND_GLOBAL.user_id, /* Bug 6412180 */
182: FND_GLOBAL.user_id, /* Bug 6412180 */
183: l_resources_rec.trans_cnt,
177: l_resources_rec.inactive_ind,
178: sysdate,
179: FND_GLOBAL.user_id, /* Bug 6412180 */
180: sysdate,
181: FND_GLOBAL.user_id, /* Bug 6412180 */
182: FND_GLOBAL.user_id, /* Bug 6412180 */
183: l_resources_rec.trans_cnt,
184: 0,
185: l_resources_rec.text_code,
178: sysdate,
179: FND_GLOBAL.user_id, /* Bug 6412180 */
180: sysdate,
181: FND_GLOBAL.user_id, /* Bug 6412180 */
182: FND_GLOBAL.user_id, /* Bug 6412180 */
183: l_resources_rec.trans_cnt,
184: 0,
185: l_resources_rec.text_code,
186: l_resources_rec.ideal_capacity,
255: ,l_rsrc_instances(j).next_calibration_date
256: ,l_rsrc_instances(j).last_certification_date
257: ,l_rsrc_instances(j).certified_by
258: ,sysdate
259: ,FND_GLOBAL.user_id /* Bug 6412180 */
260: ,sysdate
261: ,FND_GLOBAL.user_id /* Bug 6412180 */
262: ,FND_GLOBAL.user_id /* Bug 6412180 */
263: ) ;
257: ,l_rsrc_instances(j).certified_by
258: ,sysdate
259: ,FND_GLOBAL.user_id /* Bug 6412180 */
260: ,sysdate
261: ,FND_GLOBAL.user_id /* Bug 6412180 */
262: ,FND_GLOBAL.user_id /* Bug 6412180 */
263: ) ;
264: END IF; /* Instance return status */
265: END LOOP ; /* Instance loop */
258: ,sysdate
259: ,FND_GLOBAL.user_id /* Bug 6412180 */
260: ,sysdate
261: ,FND_GLOBAL.user_id /* Bug 6412180 */
262: ,FND_GLOBAL.user_id /* Bug 6412180 */
263: ) ;
264: END IF; /* Instance return status */
265: END LOOP ; /* Instance loop */
266: END IF; /* Insert Resource Instance only if Schedule Ind = 2 */
1059: p_resources.usage_uom, /* B4724360 - INVCONV */
1060: p_resources.nominal_cost,
1061: p_resources.inactive_ind,
1062: sysdate,
1063: FND_GLOBAL.user_id, /* Bug 6412180 */
1064: sysdate,
1065: FND_GLOBAL.user_id, /* Bug 6412180 */
1066: FND_GLOBAL.user_id, /* Bug 6412180 */
1067: p_resources.trans_cnt,
1061: p_resources.inactive_ind,
1062: sysdate,
1063: FND_GLOBAL.user_id, /* Bug 6412180 */
1064: sysdate,
1065: FND_GLOBAL.user_id, /* Bug 6412180 */
1066: FND_GLOBAL.user_id, /* Bug 6412180 */
1067: p_resources.trans_cnt,
1068: p_resources.delete_mark,
1069: p_resources.text_code,
1062: sysdate,
1063: FND_GLOBAL.user_id, /* Bug 6412180 */
1064: sysdate,
1065: FND_GLOBAL.user_id, /* Bug 6412180 */
1066: FND_GLOBAL.user_id, /* Bug 6412180 */
1067: p_resources.trans_cnt,
1068: p_resources.delete_mark,
1069: p_resources.text_code,
1070: p_resources.ideal_capacity,
1377: ,p_instances.next_calibration_date
1378: ,p_instances.last_certification_date
1379: ,p_instances.certified_by
1380: ,sysdate
1381: ,FND_GLOBAL.user_id /* Bug 6412180 */
1382: ,sysdate
1383: ,FND_GLOBAL.user_id /* Bug 6412180 */
1384: ,FND_GLOBAL.user_id /* Bug 6412180 */
1385: ,g_return_status
1379: ,p_instances.certified_by
1380: ,sysdate
1381: ,FND_GLOBAL.user_id /* Bug 6412180 */
1382: ,sysdate
1383: ,FND_GLOBAL.user_id /* Bug 6412180 */
1384: ,FND_GLOBAL.user_id /* Bug 6412180 */
1385: ,g_return_status
1386: );
1387: x_return_status := g_return_status ;
1380: ,sysdate
1381: ,FND_GLOBAL.user_id /* Bug 6412180 */
1382: ,sysdate
1383: ,FND_GLOBAL.user_id /* Bug 6412180 */
1384: ,FND_GLOBAL.user_id /* Bug 6412180 */
1385: ,g_return_status
1386: );
1387: x_return_status := g_return_status ;
1388: END IF;