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