[Home] [Help]
PACKAGE: APPS.AHL_PC_HEADER_PUB
Source
1 PACKAGE AHL_PC_HEADER_PUB AUTHID CURRENT_USER AS
2 /* $Header: AHLPPCHS.pls 120.1.12020000.2 2012/12/10 15:43:38 prakkum ship $ */
3 /*#
4 * This is the public interface to create, modify and terminate Product Classifiaction Header
5 * depending on the flag that is being passed.
6 * @rep:scope public
7 * @rep:product AHL
8 * @rep:displayname Product Classification Header
9 * @rep:lifecycle active
10 * @rep:category BUSINESS_ENTITY AHL_PROD_CLASS
11 */
12
13 -- Table type to hold warning messages
14 TYPE Warn_Tbl_Type IS TABLE OF VARCHAR2(2000) INDEX BY BINARY_INTEGER;
15
16 G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_PC_HEADER_PUB';
17
18 G_DML_CREATE CONSTANT VARCHAR2(1) := 'C';
19 G_DML_UPDATE CONSTANT VARCHAR2(1) := 'U';
20 G_DML_DELETE CONSTANT VARCHAR2(1) := 'D';
21 G_DML_COPY CONSTANT VARCHAR2(1) := 'X';
22 G_DML_LINK CONSTANT VARCHAR2(1) := 'L';
23
24 -----------------------------------------------------------------
25 -- Define Record Type for Product Classification Header Record --
26 -----------------------------------------------------------------
27 TYPE PC_HEADER_REC IS RECORD (
28 PC_HEADER_ID NUMBER,
29 NAME VARCHAR2(240),
30 DESCRIPTION VARCHAR2(2000),
31 STATUS VARCHAR2(30),
32 STATUS_DESC VARCHAR2(80),
33 PRODUCT_TYPE_CODE VARCHAR2(30),
34 PRODUCT_TYPE_DESC VARCHAR2(80),
35 PRIMARY_FLAG VARCHAR2(1),
36 BUE_FLAG VARCHAR2(1), -- AJPRASAN:: BUG #9596384 - BUE usage flag
37 PRIMARY_FLAG_DESC VARCHAR2(80),
38 ASSOCIATION_TYPE_FLAG VARCHAR2(1),
39 ASSOCIATION_TYPE_DESC VARCHAR2(80),
40 DRAFT_FLAG VARCHAR2(1),
41 LINK_TO_PC_ID NUMBER,
42 OBJECT_VERSION_NUMBER NUMBER,
43 ATTRIBUTE_CATEGORY VARCHAR2(30),
44 ATTRIBUTE1 VARCHAR2(150),
45 ATTRIBUTE2 VARCHAR2(150),
46 ATTRIBUTE3 VARCHAR2(150),
47 ATTRIBUTE4 VARCHAR2(150),
48 ATTRIBUTE5 VARCHAR2(150),
49 ATTRIBUTE6 VARCHAR2(150),
50 ATTRIBUTE7 VARCHAR2(150),
51 ATTRIBUTE8 VARCHAR2(150),
52 ATTRIBUTE9 VARCHAR2(150),
53 ATTRIBUTE10 VARCHAR2(150),
54 ATTRIBUTE11 VARCHAR2(150),
55 ATTRIBUTE12 VARCHAR2(150),
56 ATTRIBUTE13 VARCHAR2(150),
57 ATTRIBUTE14 VARCHAR2(150),
58 ATTRIBUTE15 VARCHAR2(150),
59 OPERATION_FLAG VARCHAR2(1),
60 COPY_ASSOS_FLAG VARCHAR2(1),
61 COPY_DOCS_FLAG VARCHAR2(1)
62 );
63
64 ------------------------
65 -- Declare Procedures --
66 ------------------------
67 -- Start of Comments --
68 --
69 -- Procedure name : PROCESS_PC_HEADER
70 -- Type : Public
71 -- Function : Processes Product Classification Header.
72 -- Pre-reqs :
73 --
74 -- Standard IN Parameters :
75 -- p_api_version IN NUMBER Required
76 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
77 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
78 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
79 -- p_module_type IN VARCHAR2 Default NULL
80 --
81 -- Standard OUT Parameters :
82 -- x_return_status OUT VARCHAR2 Required
83 -- x_msg_count OUT NUMBER Required
84 -- x_msg_data OUT VARCHAR2 Required
85 --
86 -- p_x_PC_HEADER_rec IN OUT NOCOPY PC_HEADER_REC Required
87 -- PC_HEADER_ID Required / Optional depending on operation - System Generated Primary Key
88 -- NAME Required and should be unique
89 -- DESCRIPTION Optional
90 -- STATUS Required
91 -- STATUS_DES Optional
92 -- PRODUCT_TYPE_CODE Required
93 -- PRODUCT_TYPE_DESC Optional
94 -- PRIMARY_FLAG Required Y/N
95 -- ASSOCIATION_TYPE_FLAG Required U/I
96 -- OPERATION_FLAG Required, C - Create, U - Update, D - Delete, X - Copy, L - Link
97 --
98 -- Version :
99 -- Initial Version 1.0
100 --
101 -- End of Comments --
102 /*#
103 * The procedure Creates, modifies and deletes Product Classification Header.
104 * @param p_api_version Api Version Number
105 * @param p_init_msg_list Initialize the message stack, default value FND_API.G_FALSE
106 * @param p_commit To decide whether to commit the transaction, default value FND_API.G_FALSE
107 * @param p_validation_level Validation level, default value FND_API.G_VALID_LEVEL_FULL
108 * @param p_module_type whether 'API'or 'JSP', default value NULL
109 * @param p_x_pc_header_rec Product Classification table of type PC_HEADER_REC
110 * @param x_return_status Return status,Standard API parameter
111 * @param x_msg_count Return message count,Standard API parameter
112 * @param x_msg_data Return message data,Standard API parameter
113 * @rep:scope public
114 * @rep:lifecycle active
115 * @rep:displayname Process PC Header
116 */
117 PROCEDURE PROCESS_PC_HEADER (
118 p_api_version IN NUMBER,
119 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
120 p_commit IN VARCHAR2 := FND_API.G_FALSE,
121 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
122 p_module_type IN VARCHAR2 := NULL,
123 p_x_pc_header_rec IN OUT NOCOPY AHL_PC_HEADER_PUB.PC_HEADER_REC,
124 x_return_status OUT NOCOPY VARCHAR2,
125 x_msg_count OUT NOCOPY NUMBER,
126 x_msg_data OUT NOCOPY VARCHAR2,
127 x_warning_msg_data OUT NOCOPY AHL_PC_HEADER_PUB.Warn_Tbl_Type
128 );
129
130 END AHL_PC_HEADER_PUB;