[Home] [Help]
PACKAGE: APPS.EGO_MASS_UPDATE_PVT
Source
1 PACKAGE EGO_MASS_UPDATE_PVT AS
2 /* $Header: EGOMUPGS.pls 120.0 2005/07/15 03:34:11 ajerome noship $ */
3
4 --========================================================================
5 -- PROCEDURE : Item_Org_Assignment PUBLIC
6 -- PARAMETERS: p_batch_id IN NUMBER Batch Id for records in Temp Table
7 -- ,p_all_request_ids OUT NOCOPY VARCHAR2(300) Concatenated Request Ids
8 -- ,x_return_status OUT NOCOPY VARCHAR2 Standard OUT Parameter
9 -- ,x_msg_count OUT NOCOPY NUMBER Standard OUT Parameter
10 -- ,x_msg_data OUT NOCOPY VARCHAR2 Standard OUT Parameter
11 --
12 -- DESCRIPTION : This procedure Assigns Items to Organizations in
13 -- in Mass Update flows. Items and Orgs for the assignment are
14 -- obtained from temporary tables
15 --=========================================================================
16
17 PROCEDURE item_org_assignment
18 ( p_batch_id IN NUMBER
19 ,p_all_request_ids OUT NOCOPY VARCHAR2
20 ,x_return_status OUT NOCOPY VARCHAR2
21 ,x_msg_count OUT NOCOPY NUMBER
22 ,x_msg_data OUT NOCOPY VARCHAR2
23 );
24
25 --========================================================================
26 -- PROCEDURE : Write_Debug
27 -- PARAMETERS: p_msg IN VARCHAR2
28 --
29 -- DESCRIPTION : Debug Message Logger
30 --=========================================================================
31
32 PROCEDURE Write_Debug (p_msg IN VARCHAR2);
33
34 --========================================================================
35 -- PROCEDURE : clear_temp_tables
36 -- PARAMETERS: errbuf out NOCOPY varchar2
37 -- PARAMETERS: retcode out NOCOPY varchar2
38 -- PARAMETERS: hours IN NUMBER
39 --
40 -- DESCRIPTION : Clears Massupdate temp Tables
41 --=========================================================================
42
43 PROCEDURE clear_temp_tables( errbuf OUT NOCOPY VARCHAR2,
44 retcode OUT NOCOPY NUMBER,
45 hours NUMBER) ;
46
47 END EGO_MASS_UPDATE_PVT;