[Home] [Help]
PACKAGE: APPS.DPP_CUSTOMERCLAIMS_PVT
Source
1 PACKAGE DPP_CUSTOMERCLAIMS_PVT AUTHID CURRENT_USER 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;