APPS.GMIVDBX dependencies on GMI_DISCRETE_TRANSFER_LINES

Line 279: | Sets up and insert records in gmi_discrete_transfer_lines |

275: | PROCEDURE NAME |
276: | line_insert |
277: | |
278: | USAGE |
279: | Sets up and insert records in gmi_discrete_transfer_lines |
280: | |
281: | RETURNS |
282: | Via x_ OUT parameters |
283: | |

Line 300: , x_line_row OUT NOCOPY gmi_discrete_transfer_lines%ROWTYPE

296: , x_msg_count OUT NOCOPY NUMBER
297: , x_msg_data OUT NOCOPY VARCHAR2
298: , p_hdr_row IN gmi_discrete_transfers%ROWTYPE
299: , p_line_rec IN GMIVDX.line_type
300: , x_line_row OUT NOCOPY gmi_discrete_transfer_lines%ROWTYPE
301: )
302: IS
303: l_api_name CONSTANT VARCHAR2(30) := 'line_insert' ;
304: l_api_version CONSTANT NUMBER := 1.0 ;

Line 399: INSERT INTO gmi_discrete_transfer_lines

395: x_line_row.delete_mark := 0;
396: x_line_row.text_code := NULL;
397:
398:
399: INSERT INTO gmi_discrete_transfer_lines
400: (
401: transfer_id
402: , line_id
403: , line_no

Line 543: log_msg('Inserted 1 record in gmi_discrete_transfer_lines');

539: , x_line_row.text_code
540: );
541:
542: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
543: log_msg('Inserted 1 record in gmi_discrete_transfer_lines');
544: END IF;
545:
546: FND_MSG_PUB.Count_AND_GET
547: (p_count => x_msg_count, p_data => x_msg_data);

Line 603: , p_line_row IN gmi_discrete_transfer_lines%ROWTYPE

599: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
600: , x_return_status OUT NOCOPY VARCHAR2
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' ;