[Home] [Help]
PACKAGE: APPS.MTL_RELATED_ITEMS_PVT
Source
1 PACKAGE MTL_RELATED_ITEMS_PVT AUTHID CURRENT_USER AS
2 /* $Header: INVVRITS.pls 120.1.12020000.2 2012/10/03 11:23:36 ccsingh ship $ */
3
4
5 G_Entity_Code VARCHAR2(30) := 'RelItem';
6 G_Table_Name VARCHAR2(30) := 'MTL_RELATED_ITEMS';
7 G_PKG_NAME VARCHAR2(30) := 'MTL_RELATED_ITEMS_PVT';
8
9 -------------------------------------------------------------------------
10 -- Debug Profile option used to write Error_Handler.Write_Debug --
11 -- Profile option name = INV_DEBUG_TRACE ; --
12 -- User Profile Option Name = INV: Debug Trace --
13 -- Values: 1 (True) ; 0 (False) --
14 -------------------------------------------------------------------------
15 G_DEBUG VARCHAR2(10);
16
17
18 -- -----------------------------------------------------------------------------
19 -- Procedure Name: Process_Rel_Item
20 --
21 -- Description : Main API to process (CREATE/UPDATE/DELETE) a single
22 -- Related Item record and its corresponding Planning Details
23 -- (Substitution Sets and Customer References).
24 -- -----------------------------------------------------------------------------
25 PROCEDURE Process_Rel_Item(
26 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
27 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
28 ,p_Rel_Item_Rec IN OUT NOCOPY MTL_RELATED_ITEMS_PUB.Rel_Item_Rec_Type
29 ,p_Pln_Info_Tbl IN OUT NOCOPY MTL_RELATED_ITEMS_PUB.Pln_Info_Tbl_Type
30 ,p_Cust_Ref_Tbl IN OUT NOCOPY MTL_RELATED_ITEMS_PUB.Cust_Ref_Tbl_Type
31 ,x_return_status OUT NOCOPY VARCHAR2
32 ,x_msg_count OUT NOCOPY NUMBER
33 ,x_msg_list OUT NOCOPY Error_Handler.Error_Tbl_Type);
34
35 -- -----------------------------------------------------------------------------
36 -- Procedure Name: Process_Rel_Items_Rows
37 --
38 -- Description : Concurrent program to pull rows from
39 -- MTL_RELATED_ITEMS_INTERFACE for processing.
40 -- Does not support planning details.
41 -- -----------------------------------------------------------------------------
42 PROCEDURE Process_Rel_Items_Rows(
43 ERRBUF OUT NOCOPY VARCHAR2,
44 RETCODE OUT NOCOPY VARCHAR2,
45 p_data_set_id IN NUMBER,
46 p_del_rec_flag IN NUMBER := 1);
47
48 -- -----------------------------------------------------------------------------
49 -- Procedure Name: Del_Processed_Recs
50 --
51 -- Description : Method to delete processed rows from intf table.
52
53 -- -----------------------------------------------------------------------------
54 FUNCTION Del_Processed_Recs(
55 err_text OUT NOCOPY VARCHAR2,
56 com_flag IN NUMBER DEFAULT 1,
57 p_data_set_id IN NUMBER DEFAULT -999
58 )
59 return INTEGER;
60
61 PROCEDURE Write_Debug (p_msg IN VARCHAR2);
62
63 END;