APPS.GMIVDBX dependencies on GMI_DISCRETE_TRANSFER_LOTS

Line 585: | Sets up and insert records in gmi_discrete_transfer_lots |

581: | PROCEDURE NAME |
582: | lot_insert |
583: | |
584: | USAGE |
585: | Sets up and insert records in gmi_discrete_transfer_lots |
586: | |
587: | RETURNS |
588: | Via x_ OUT parameters |
589: | |

Line 605: , x_lot_row OUT NOCOPY gmi_discrete_transfer_lots%ROWTYPE

601: , x_msg_count OUT NOCOPY NUMBER
602: , x_msg_data OUT NOCOPY VARCHAR2
603: , p_line_row IN gmi_discrete_transfer_lines%ROWTYPE
604: , p_lot_rec IN GMIVDX.lot_type
605: , x_lot_row OUT NOCOPY gmi_discrete_transfer_lots%ROWTYPE
606: ) IS
607: l_api_name CONSTANT VARCHAR2(30) := 'lot_insert' ;
608: l_api_version CONSTANT NUMBER := 1.0 ;
609:

Line 655: INSERT INTO gmi_discrete_transfer_lots

651: x_lot_row.delete_mark := 0;
652: x_lot_row.text_code := NULL;
653:
654:
655: INSERT INTO gmi_discrete_transfer_lots
656: (
657: transfer_id
658: , line_id
659: , line_detail_id

Line 703: log_msg('Inserted 1 record in gmi_discrete_transfer_lots');

699: , x_lot_row.text_code
700: );
701:
702: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
703: log_msg('Inserted 1 record in gmi_discrete_transfer_lots');
704: END IF;
705:
706: FND_MSG_PUB.Count_AND_GET
707: (p_count => x_msg_count, p_data => x_msg_data);