PACKAGE: APPS.DPP_CUSTOMERCLAIMS_PVT

Source

1 PACKAGE DPP_CUSTOMERCLAIMS_PVT AS
2 /* $Header: dppvcuss.pls 120.3 2008/02/08 05:00:23 sdasan noship $ */
3 
4 TYPE dpp_cust_hdr_rec_type IS RECORD
5 (
6     Transaction_Header_ID   	NUMBER,
7     Effective_Start_Date			DATE,
8     Effective_End_Date				DATE,
9     Org_ID                  	VARCHAR2(15),
10     Execution_Detail_ID				NUMBER,
11     Output_XML								CLOB,
12 		Provider_Process_Id 			VARCHAR2(240),
13 		Provider_Process_Instance_id VARCHAR2(240),
14 		Last_Updated_By 					NUMBER,
15     Currency_code							VARCHAR2(15)
16 );
17 
18 TYPE dpp_customer_price_rec_type IS RECORD
19 (
20 cust_account_id				NUMBER,
21 last_price						NUMBER,
22 invoice_currency_code	VARCHAR2(15)
23 );
24 
25 TYPE dpp_customer_price_tbl_type IS TABLE OF dpp_customer_price_rec_type INDEX BY BINARY_INTEGER;
26 
27 TYPE dpp_customer_rec_type IS RECORD
28 (
29     Transaction_Line_Id			NUMBER,
30     Inventory_ITem_ID					VARCHAR2(42),
31     UOM_Code									VARCHAR2(3),
32     Customer_price_Tbl        dpp_customer_price_tbl_type
33 );
34 
35 G_MISS_dpp_customer_rec     dpp_customer_rec_type;
36 TYPE dpp_customer_tbl_type IS TABLE OF dpp_customer_rec_type INDEX BY BINARY_INTEGER;
37 G_MISS_dpp_customer_tbl     dpp_customer_tbl_type;
38 
39 ---------------------------------------------------------------------
40 -- PROCEDURE
41 --    Select_CustomerPrice
42 --
43 -- PURPOSE
44 --    Select Customer and Price
45 --
46 -- PARAMETERS
47 --
48 -- NOTES
49 --    1.
50 --    2.
51 ----------------------------------------------------------------------
52 
53 PROCEDURE Select_CustomerPrice(
54     p_api_version   	 IN 	  NUMBER
55    ,p_init_msg_list	     IN 	  VARCHAR2     := FND_API.G_FALSE
56    ,p_commit	         IN 	  VARCHAR2     := FND_API.G_FALSE
57    ,p_validation_level	 IN 	  NUMBER       := FND_API.G_VALID_LEVEL_FULL
58    ,x_return_status	     OUT NOCOPY	  VARCHAR2
59    ,x_msg_count	         OUT NOCOPY	  NUMBER
60    ,x_msg_data	         OUT NOCOPY	  VARCHAR2
61    ,p_cust_hdr_rec	 IN    dpp_cust_hdr_rec_type
62    ,p_customer_tbl	     IN OUT NOCOPY  dpp_customer_tbl_type
63 );
64 
65 ---------------------------------------------------------------------
66 -- PROCEDURE
67 --    Populate_CustomerPrice
68 --
69 -- PURPOSE
70 --    Populate Customer and Price
71 --
72 -- PARAMETERS
73 --
74 -- NOTES
75 --    1.
76 --    2.
77 ----------------------------------------------------------------------
78 
79 PROCEDURE Populate_CustomerPrice(
80     p_api_version   	 IN 	  NUMBER
81    ,p_init_msg_list	     IN 	  VARCHAR2     := FND_API.G_FALSE
82    ,p_commit	         IN 	  VARCHAR2     := FND_API.G_TRUE
83    ,p_validation_level	 IN 	  NUMBER       := FND_API.G_VALID_LEVEL_FULL
84    ,x_return_status	     OUT 	NOCOPY  VARCHAR2
85    ,x_msg_count	         OUT 	NOCOPY  NUMBER
86    ,x_msg_data	         OUT 	NOCOPY  VARCHAR2
87    ,p_cust_hdr_rec	 IN    dpp_cust_hdr_rec_type
88    ,p_customer_tbl	     IN    dpp_customer_tbl_type
89 );
90 
91 END DPP_CUSTOMERCLAIMS_PVT;