1 PACKAGE ASO_CREDIT_CHECK_PVT AUTHID CURRENT_USER as
2 /* $Header: asoiqccs.pls 120.1 2005/06/29 12:35:22 appldev ship $ */
3 -- Start of Comments
4 -- Package name : ASO_credit_check_PVT
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10 --
11 --
12 -- Record types
13 -- ASO_QUOTE_PUB.Qte_Header_Rec_type
14 --
15 --
16 --
17 -- API
18 -- CREDIT_CHECK
19 --
20
21 -- this procedure is used to perform internal and external credit check for a customer
22 -- the input needed is Quote Header Record.
23 -- The following are the values that have to be populated in the header record.
24 -- Quote Header Id, Currency Code, Org Id, Total Quote Price, Invoice to Cust Party Id,
25 -- Invoice to Cust Party Name, Invoice to Cust Acct Number, Invoice to Address1,
26 -- Invoice to Address2 , Invoice to Address3 , Invoice to Address4, Invoice to County,
27 -- Invoice to City, Invoice to Province, Invoice to State, Invoice to Country Code,
28 -- Invoice to Country, Invoice to Postal Code, Invoice Party Site Id, Invoice to Cust Account Id.
29
30 -- Subha Madapusi - Quote Credit Check.
31
32 PROCEDURE Credit_Check(
33 P_API_VERSION IN NUMBER,
34 P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
35 P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
36 P_QTE_HEADER_REC IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
37 X_RESULT_OUT OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
38 X_CC_HOLD_COMMENT OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
39 X_RETURN_STATUS OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
40 X_MSG_COUNT OUT NOCOPY /* file.sql.39 change */ NUMBER,
41 X_MSG_DATA OUT NOCOPY /* file.sql.39 change */ VARCHAR2
42 );
43
44 --subha madapusi - quote credit check end.
45
46 End ASO_CREDIT_CHECK_PVT;
[Home] [Help]