[Home] [Help]
PACKAGE: APPS.MTL_CROSS_REFERENCES_PVT
Source
1 PACKAGE MTL_CROSS_REFERENCES_PVT AUTHID CURRENT_USER AS
2 /* $Header: INVVXRFS.pls 120.4.12020000.2 2012/10/03 11:41:12 ccsingh ship $ */
3
4 G_Entity_Code VARCHAR2(30) := 'XRef';
5 G_Table_Name VARCHAR2(30) := 'MTL_CROSS_REFERENCES';
6 G_PKG_NAME VARCHAR2(30) := 'MTL_CROSS_REFERENCES_PVT';
7 G_Xref_Indx NUMBER := 0;
8 G_Api_Name VARCHAR2(30) := 'Process_XRef';
9 -- -----------------------------------------------------------------------------
10 -- API Name: Process_XRef
11 --
12 -- Description :
13 -- Process (CREATE/UPDATE/DELETE) a set of Cross References based on data in
14 -- the pl/sql table.
15 -- -----------------------------------------------------------------------------
16 PROCEDURE Process_XRef(
17 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
18 ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
19 ,p_XRef_Tbl IN OUT NOCOPY MTL_CROSS_REFERENCES_PUB.XRef_Tbl_Type
20 ,x_return_status OUT NOCOPY VARCHAR2
21 ,x_msg_count OUT NOCOPY NUMBER
22 ,x_message_list OUT NOCOPY Error_Handler.Error_Tbl_Type);
23
24 -- -----------------------------------------------------------------------------
25 -- Procedure Name: Validate_GTIN_Rec
26 --
27 -- Description : Specific validations for Cross References that are of type GTIN
28 -- -----------------------------------------------------------------------------
29 PROCEDURE Validate_GTIN_Rec(
30 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
31 ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
32 ,p_GTIN_XRef_Rec IN OUT NOCOPY MTL_CROSS_REFERENCES_PUB.XRef_Rec_Type
33 ,x_return_status OUT NOCOPY VARCHAR2
34 ,x_msg_count OUT NOCOPY NUMBER);
35
36 -- -----------------------------------------------------------------------------
37 -- Procedure Name: Validate_GTIN_Number
38 --
39 -- Description : Takes in a GTIN as characters to validate the 14 digit GTIN
40 -- -----------------------------------------------------------------------------
41 PROCEDURE Validate_GTIN_Number(
42 p_GTIN_XRef_Number IN VARCHAR2
43 ,x_return_status OUT NOCOPY VARCHAR2);
44
45 -- -----------------------------------------------------------------------------
46 -- Procedure Name: Process_XRef_Intf_Rows
47 --
48 -- Description : Concurrent program to pull rows from
49 -- MTL_CROSS_REFERENCES_INTERFACE for processing.
50 -- -----------------------------------------------------------------------------
51 PROCEDURE Process_XRef_Intf_Rows(
52 ERRBUF OUT NOCOPY VARCHAR2,
53 RETCODE OUT NOCOPY VARCHAR2,
54 p_data_set_id IN NUMBER,
55 p_del_rec_flag IN NUMBER := 1);
56
57 PROCEDURE Write_Debug (p_msg IN VARCHAR2);
58
59 -- -----------------------------------------------------------------------------
60 -- Procedure Name: LOG_ERROR
61 --
62 -- Description : Function to log error messages in error inerface table
63 -- and concurrent prog log file. -- bug 12533707 --
64 -- -----------------------------------------------------------------------------
65 FUNCTION LOG_ERROR(
66 org_id IN NUMBER,
67 user_id IN NUMBER,
68 login_id IN NUMBER,
69 prog_appid IN NUMBER,
70 prog_id IN NUMBER,
71 req_id IN NUMBER,
72 trans_id IN NUMBER,
73 error_text IN VARCHAR2,
74 p_column_name IN VARCHAR2 := NULL,
75 tbl_name IN VARCHAR2,
76 msg_name IN VARCHAR2,
77 err_text OUT NOCOPY VARCHAR2)
78 RETURN INTEGER;
79
80 -- -----------------------------------------------------------------------------
81 -- Procedure Name: Del_Processed_Recs
82 --
83 -- Description : Method to delete processed rows from intf table.
84
85 -- -----------------------------------------------------------------------------
86
87 FUNCTION Del_Processed_Recs(
88 err_text OUT NOCOPY VARCHAR2,
89 com_flag IN NUMBER DEFAULT 1,
90 p_data_set_id IN NUMBER DEFAULT -999
91 )
92 RETURN INTEGER;
93
94 END ;