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,
256: ,l_rsrc_instances(j).next_calibration_date
257: ,l_rsrc_instances(j).last_certification_date
258: ,l_rsrc_instances(j).certified_by
259: ,sysdate
260: ,FND_GLOBAL.user_id /* Bug 6412180 */
261: ,sysdate
262: ,FND_GLOBAL.user_id /* Bug 6412180 */
263: ,FND_GLOBAL.user_id /* Bug 6412180 */
264: ) ;
258: ,l_rsrc_instances(j).certified_by
259: ,sysdate
260: ,FND_GLOBAL.user_id /* Bug 6412180 */
261: ,sysdate
262: ,FND_GLOBAL.user_id /* Bug 6412180 */
263: ,FND_GLOBAL.user_id /* Bug 6412180 */
264: ) ;
265: END IF; /* Instance return status */
266: END LOOP ; /* Instance loop */
259: ,sysdate
260: ,FND_GLOBAL.user_id /* Bug 6412180 */
261: ,sysdate
262: ,FND_GLOBAL.user_id /* Bug 6412180 */
263: ,FND_GLOBAL.user_id /* Bug 6412180 */
264: ) ;
265: END IF; /* Instance return status */
266: END LOOP ; /* Instance loop */
267: END IF; /* Insert Resource Instance only if Schedule Ind = 2 */
1081: p_resources.usage_uom, /* B4724360 - INVCONV */
1082: p_resources.nominal_cost,
1083: p_resources.inactive_ind,
1084: sysdate,
1085: FND_GLOBAL.user_id, /* Bug 6412180 */
1086: sysdate,
1087: FND_GLOBAL.user_id, /* Bug 6412180 */
1088: FND_GLOBAL.user_id, /* Bug 6412180 */
1089: p_resources.trans_cnt,
1083: p_resources.inactive_ind,
1084: sysdate,
1085: FND_GLOBAL.user_id, /* Bug 6412180 */
1086: sysdate,
1087: FND_GLOBAL.user_id, /* Bug 6412180 */
1088: FND_GLOBAL.user_id, /* Bug 6412180 */
1089: p_resources.trans_cnt,
1090: p_resources.delete_mark,
1091: p_resources.text_code,
1084: sysdate,
1085: FND_GLOBAL.user_id, /* Bug 6412180 */
1086: sysdate,
1087: FND_GLOBAL.user_id, /* Bug 6412180 */
1088: FND_GLOBAL.user_id, /* Bug 6412180 */
1089: p_resources.trans_cnt,
1090: p_resources.delete_mark,
1091: p_resources.text_code,
1092: p_resources.ideal_capacity,
1404: ,p_instances.next_calibration_date
1405: ,p_instances.last_certification_date
1406: ,p_instances.certified_by
1407: ,sysdate
1408: ,FND_GLOBAL.user_id /* Bug 6412180 */
1409: ,sysdate
1410: ,FND_GLOBAL.user_id /* Bug 6412180 */
1411: ,FND_GLOBAL.user_id /* Bug 6412180 */
1412: ,g_return_status
1406: ,p_instances.certified_by
1407: ,sysdate
1408: ,FND_GLOBAL.user_id /* Bug 6412180 */
1409: ,sysdate
1410: ,FND_GLOBAL.user_id /* Bug 6412180 */
1411: ,FND_GLOBAL.user_id /* Bug 6412180 */
1412: ,g_return_status
1413: );
1414: x_return_status := g_return_status ;
1407: ,sysdate
1408: ,FND_GLOBAL.user_id /* Bug 6412180 */
1409: ,sysdate
1410: ,FND_GLOBAL.user_id /* Bug 6412180 */
1411: ,FND_GLOBAL.user_id /* Bug 6412180 */
1412: ,g_return_status
1413: );
1414: x_return_status := g_return_status ;
1415: END IF;