[Home] [Help]
PACKAGE: APPS.OZF_ASSIGNMENT_QUALIFIER_PUB
Source
1 PACKAGE OZF_ASSIGNMENT_QUALIFIER_PUB AUTHID CURRENT_USER as
2 /* $Header: ozfpasqs.pls 115.1 2003/06/30 19:14:32 mchang noship $ */
3 -- Start of Comments
4 -- Package name : OZF_ASSIGNMENT_QUALIFIER_PUB
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10 TYPE Deduction_Rec_Type is record(
11 CLAIM_ID NUMBER ,
12 CLAIM_NUMBER VARCHAR2(30) ,
13 CLAIM_TYPE_ID NUMBER ,
14 CLAIM_DATE DATE ,
15 DUE_DATE DATE ,
16 OWNER_ID NUMBER ,
17 AMOUNT NUMBER ,
18 CURRENCY_CODE VARCHAR2(15) ,
19 EXCHANGE_RATE_TYPE VARCHAR2(30) ,
20 EXCHANGE_RATE_DATE DATE ,
21 EXCHANGE_RATE NUMBER ,
22 SET_OF_BOOKS_ID NUMBER ,
23 SOURCE_OBJECT_ID NUMBER ,
24 SOURCE_OBJECT_CLASS VARCHAR2(15) ,
25 SOURCE_OBJECT_TYPE_ID NUMBER ,
26 SOURCE_OBJECT_NUMBER VARCHAR2(30) ,
27 CUST_ACCOUNT_ID NUMBER ,
28 CUST_BILLTO_ACCT_SITE_ID NUMBER ,
29 CUST_SHIPTO_ACCT_SITE_ID NUMBER ,
30 LOCATION_ID NUMBER ,
31 REASON_CODE_ID NUMBER ,
32 STATUS_CODE VARCHAR2(30) ,
33 USER_STATUS_ID NUMBER ,
34 SALES_REP_ID NUMBER ,
35 COLLECTOR_ID NUMBER ,
36 CONTACT_ID NUMBER ,
37 BROKER_ID NUMBER ,
38 CUSTOMER_REF_DATE DATE ,
39 CUSTOMER_REF_NUMBER VARCHAR2(30),
40 RECEIPT_ID NUMBER,
41 RECEIPT_NUMBER VARCHAR2(30),
42 GL_DATE DATE,
43 COMMENTS VARCHAR2(2000),
44 DEDUCTION_ATTRIBUTE_CATEGORY VARCHAR2(30),
45 DEDUCTION_ATTRIBUTE1 VARCHAR2(150),
46 DEDUCTION_ATTRIBUTE2 VARCHAR2(150),
47 DEDUCTION_ATTRIBUTE3 VARCHAR2(150),
48 DEDUCTION_ATTRIBUTE4 VARCHAR2(150),
49 DEDUCTION_ATTRIBUTE5 VARCHAR2(150),
50 DEDUCTION_ATTRIBUTE6 VARCHAR2(150),
51 DEDUCTION_ATTRIBUTE7 VARCHAR2(150),
52 DEDUCTION_ATTRIBUTE8 VARCHAR2(150),
53 DEDUCTION_ATTRIBUTE9 VARCHAR2(150),
54 DEDUCTION_ATTRIBUTE10 VARCHAR2(150),
55 DEDUCTION_ATTRIBUTE11 VARCHAR2(150),
56 DEDUCTION_ATTRIBUTE12 VARCHAR2(150),
57 DEDUCTION_ATTRIBUTE13 VARCHAR2(150),
58 DEDUCTION_ATTRIBUTE14 VARCHAR2(150),
59 DEDUCTION_ATTRIBUTE15 VARCHAR2(150),
60 ORG_ID NUMBER
61 );
62
63 TYPE Qualifier_Rec_Type is record(
64 CLAIM_TYPE_ID NUMBER,
65 CLAIM_DATE DATE,
66 DUE_DATE DATE,
67 OWNER_ID NUMBER,
68 CUST_BILLTO_ACCT_SITE_ID NUMBER,
69 CUST_SHIPTO_ACCT_SITE_ID NUMBER ,
70 REASON_CODE_ID NUMBER ,
71 SALES_REP_ID NUMBER ,
72 CONTACT_ID NUMBER ,
73 BROKER_ID NUMBER ,
74 CUSTOMER_REF_DATE DATE ,
75 CUSTOMER_REF_NUMBER VARCHAR2(30) ,
76 GL_DATE DATE ,
77 COMMENTS VARCHAR2(2000)
78 );
79
80 ---------------------------------------------------------------------
81 -- PROCEDURE: Get_Deduction_Value
82 --
83 -- PURPOSE:
84 -- This procedure modifies the values of a deduction record.
85 --
86 -- PARAMETERS:
87 -- IN
88 -- p_api_version_number IN NUMBER Required
89 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
90 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
91 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
92 -- P_deduction IN DEDUCTION_REC_TYPE Required
93 --
94 -- OUT:
95 -- x_return_status OUT VARCHAR2
96 -- x_msg_count OUT NUMBER
97 -- x_msg_data OUT VARCHAR2
98 -- x_deduction OUT Qualifier_Rec_Type
99 -- NOTES:
100 --
101 ---------------------------------------------------------------------
102 PROCEDURE Get_Deduction_Value(
103 P_Api_Version_Number IN NUMBER,
104 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
105 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
106 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
107
108 X_Return_Status OUT NOCOPY VARCHAR2,
109 X_Msg_Count OUT NOCOPY NUMBER,
110 X_Msg_Data OUT NOCOPY VARCHAR2,
111
112 P_deduction IN DEDUCTION_REC_TYPE,
113 X_qualifier OUT NOCOPY Qualifier_Rec_Type
114 );
115
116 End OZF_ASSIGNMENT_QUALIFIER_PUB;