DBA Data[Home] [Help]

PACKAGE: APPS.INV_RMA_SERIAL_PVT

Source


1 PACKAGE INV_RMA_SERIAL_PVT AUTHID CURRENT_USER AS
2 /* $Header: INVRMASS.pls 115.1 2004/04/22 11:57:16 aapaul noship $ */
3 
4 --------------------------------------------------------------------
5 --Name : populate_temp_table
6 --
7 --Desc : procedure to populate temp table inv_rma_serial_temp
8 --       based on the rma_line_id.
9 --I/P  : p_rma_line_id - the RMA line id
10 --       p_org_id - Organization id
11 --       p_item_id - Inventory Item id
12 -------------------------------------------------------------------
13 -- Added below global variable for bug 3572112
14 g_return_status VARCHAR2(1);
15 g_error_code NUMBER;
16 g_rma_line_id NUMBER;
17 procedure populate_temp_table(
18    p_api_version                IN   NUMBER,
19    p_init_msg_list              IN   VARCHAR2 DEFAULT FND_API.G_FALSE ,
20    p_commit                     IN   VARCHAR2 DEFAULT FND_API.G_FALSE,
21    p_validation_level           IN   NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
22    x_return_status              OUT  NOCOPY VARCHAR2,
23    x_msg_count                  OUT  NOCOPY NUMBER,
24    x_msg_data                   OUT  NOCOPY VARCHAR2,
25    x_errorcode                  OUT  NOCOPY NUMBER,
26 
27    p_rma_line_id                IN   NUMBER,
28    p_org_id                     IN   NUMBER,
29    p_item_id                    IN   NUMBER);
30 -- Added the below function for the bug 3572112
31 function validate_serial_required(p_rma_line_id   IN  NUMBER) return NUMBER;
32 
33 END INV_RMA_SERIAL_PVT;