[Home] [Help]
428: /*Lets initialize the gme variables */
429: gme_common_pvt.set_timestamp;
430: IF NOT gme_common_pvt.setup(P_org_id => l_batch_row.organization_id) THEN
431: RAISE error_setup;
432: END IF; /* IF NOT gme_api_pub.setup_done */
433:
434: gmd_api_grp.fetch_parm_values(P_orgn_id => l_batch_row.organization_id,
435: P_parm_name => 'FM$DEFAULT_RELEASE_TYPE',
436: P_parm_value => l_default_release_type,
539: -- Bug# 3927768 Kapil M
540: -- Those lots which are not found in gmd_material_details_gtmp should be deleted.
541: l_pending_in_rec.pending_product_lot_id := l_del_rec.pending_product_lot_id;
542:
543: gme_api_pub.delete_pending_product_lot (p_api_version => 2.0,
544: x_message_count => l_message_count,
545: x_message_list => l_message_list,
546: x_return_status => l_return_status,
547: p_batch_header_rec => l_batch_rec,
578: -- Bug# 3927768 Kapil M
579: -- If Quantity in a lot has been changed then, update is performed.
580: IF l_labrec.qty <> l_temp THEN
581: l_pending_in_rec.pending_product_lot_id := l_labrec.trans_id;
582: gme_api_pub.update_pending_product_lot (p_api_version => 2.0,
583: x_message_count => l_message_count,
584: x_message_list => l_message_list,
585: x_return_status => l_return_status,
586: p_batch_header_rec => l_batch_rec,
596: END IF;
597: ELSE
598: /* Let us check the lab batch lot is already existing if not insert the new line */
599: l_pending_in_rec.pending_product_lot_id := NULL;
600: gme_api_pub.create_pending_product_lot (p_api_version => 2.0,
601: x_message_count => l_message_count,
602: x_message_list => l_message_list,
603: x_return_status => l_return_status,
604: p_batch_header_rec => l_batch_rec,