PACKAGE: APPS.CSICUMPI_PUB

Source

1 PACKAGE CSICUMPI_PUB AUTHID CURRENT_USER AS
2 /* $Header: CSICUMPS.pls 120.1 2005/07/01 06:42:43 bnarayan noship $ */
3 TYPE Config_Rec_Type IS RECORD
4  (Config_CP_Id NUMBER DEFAULT FND_API.G_MISS_NUM,
5   Config_Parent_CP_Id NUMBER DEFAULT FND_API.G_MISS_NUM,
6   Config_Type VARCHAR2(30) DEFAULT FND_API.G_MISS_Char,
7   CUSTOMER_ID  NUMBER DEFAULT FND_API.G_MISS_NUM,
8   Inventory_Item_Id NUMBER DEFAULT FND_API.G_MISS_NUM,
9   Serial_Number VARCHAR2(30) DEFAULT FND_API.G_MISS_Char,
10   Lot_Number VARCHAR2(80) DEFAULT  FND_API.G_MISS_Char);
11 TYPE Config_Tbl_Type IS TABLE OF Config_Rec_Type
12  INDEX BY BINARY_INTEGER;
13 
14 FUNCTION get_non_primary_party_list(p_account_number  VARCHAR2,
15                                     p_org_id          NUMBER) RETURN VARCHAR2;
16 
17 
18 FUNCTION get_part_information(p_customer_product_id NUMBER) RETURN VARCHAR2;
19 FUNCTION get_root_information(p_customer_product_id NUMBER) RETURN VARCHAR2;
20 FUNCTION get_root_ID(p_customer_product_id NUMBER) RETURN NUMBER;
21 
22 FUNCTION get_children_flag(p_customer_product_id NUMBER) RETURN VARCHAR2;
23 /*PROCEDURE Get_Configuration(
24 	p_cp_id				IN	NUMBER,
25 	p_config_type			IN	VARCHAR2	DEFAULT NULL,
26 	p_as_of_date			IN	DATE	DEFAULT SYSDATE,
27 	x_config_tbl		 OUT NOCOPY Config_Tbl_Type,
28 	x_config_tbl_count	 OUT NOCOPY NUMBER);
29 */
30 END CSICUMPI_PUB;