DBA Data[Home] [Help]

APPS.GMIVDBX dependencies on GMI_DISCRETE_TRANSFERS

Line 50: | Sets up and insert records in gmi_discrete_transfers |

46: | PROCEDURE NAME |
47: | header_insert |
48: | |
49: | USAGE |
50: | Sets up and insert records in gmi_discrete_transfers |
51: | |
52: | RETURNS |
53: | Via x_ OUT parameters |
54: | |

Line 68: , x_hdr_row OUT NOCOPY gmi_discrete_transfers%ROWTYPE

64: , x_return_status OUT NOCOPY VARCHAR2
65: , x_msg_count OUT NOCOPY NUMBER
66: , x_msg_data OUT NOCOPY VARCHAR2
67: , p_hdr_rec IN GMIVDX.hdr_type
68: , x_hdr_row OUT NOCOPY gmi_discrete_transfers%ROWTYPE
69: )
70: IS
71: l_api_name CONSTANT VARCHAR2(30) := 'header_insert' ;
72: l_api_version CONSTANT NUMBER := 1.0 ;

Line 143: INSERT INTO gmi_discrete_transfers

139: x_hdr_row.delete_mark := 0;
140: x_hdr_row.text_code := NULL;
141:
142:
143: INSERT INTO gmi_discrete_transfers
144: ( transfer_id
145: , orgn_code
146: , co_code
147: , transfer_number

Line 239: log_msg('Inserted 1 record in gmi_discrete_transfers');

235: , x_hdr_row.text_code
236: );
237:
238: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
239: log_msg('Inserted 1 record in gmi_discrete_transfers');
240: END IF;
241:
242: FND_MSG_PUB.Count_AND_GET
243: (p_count => x_msg_count, p_data => x_msg_data);

Line 298: , p_hdr_row IN gmi_discrete_transfers%ROWTYPE

294: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
295: , x_return_status OUT NOCOPY VARCHAR2
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