[Home] [Help]
PACKAGE: APPS.ASO_OPP_QTE_PUB
Source
1 PACKAGE ASO_OPP_QTE_PUB AUTHID CURRENT_USER AS
2 /* $Header: asopopqs.pls 120.3 2005/11/01 14:54:30 skulkarn ship $ */
3
4 -- Start of Comments
5 -- Package name : ASO_OPP_QTE_PUB
6 -- Purpose : API to create quote from opportunity
7 -- End of Comments
8
9
10 TYPE OPP_QTE_IN_REC_TYPE IS RECORD
11 (
12 OPPORTUNITY_ID NUMBER := FND_API.G_MISS_NUM, -- Lead ID
13 QUOTE_NUMBER NUMBER := FND_API.G_MISS_NUM, -- Quote Number
14 QUOTE_NAME VARCHAR2(240) := FND_API.G_MISS_CHAR, -- Quote Name
15 CUST_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM, -- Sold_To Customer (Party) Account
16 RESOURCE_ID NUMBER := FND_API.G_MISS_NUM, -- Primary Salesperson
17 SOLD_TO_CONTACT_ID NUMBER := FND_API.G_MISS_NUM, -- Sold_To Contact
18 SOLD_TO_PARTY_SITE_ID NUMBER := FND_API.G_MISS_NUM, -- Sold_To Address
19 PRICE_LIST_ID NUMBER := FND_API.G_MISS_NUM, -- Price List
20 RESOURCE_GRP_ID NUMBER := FND_API.G_MISS_NUM, -- Primary Sales Group
21 CHANNEL_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR, -- Sales Channel
22 ORDER_TYPE_ID NUMBER := FND_API.G_MISS_NUM, -- Order Type
23 AGREEMENT_ID NUMBER := FND_API.G_MISS_NUM, -- Contract
24 CONTRACT_TEMPLATE_ID NUMBER := FND_API.G_MISS_NUM, -- Contract Template
25 CONTRACT_TEMPLATE_MAJOR_VER NUMBER := FND_API.G_MISS_NUM, -- Contract Template Major Version
26 CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR, -- Currency Code
27 MARKETING_SOURCE_CODE_ID NUMBER := FND_API.G_MISS_NUM, -- Marketing Source Code
28 QUOTE_EXPIRATION_DATE DATE := FND_API.G_MISS_DATE, -- Quote Expiration Date
29 CUST_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
30 PRICING_STATUS_INDICATOR VARCHAR2(1) := FND_API.G_MISS_CHAR,
31 TAX_STATUS_INDICATOR VARCHAR2(1) := FND_API.G_MISS_CHAR,
32 PRICE_UPDATED_DATE DATE := FND_API.G_MISS_DATE,
33 TAX_UPDATED_DATE DATE := FND_API.G_MISS_DATE,
34 ORG_ID NUMBER:= FND_API.G_MISS_NUM --Yogeshwar (MOAC)
35 );
36
37 TYPE OPP_QTE_IN_TBL_TYPE IS TABLE OF OPP_QTE_IN_REC_TYPE INDEX BY BINARY_INTEGER;
38
39 G_MISS_OPP_QTE_IN_REC OPP_QTE_IN_REC_TYPE;
40 G_MISS_OPP_QTE_IN_TBL OPP_QTE_IN_TBL_TYPE;
41
42
43 TYPE OPP_QTE_OUT_REC_TYPE IS RECORD
44 (
45 QUOTE_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
46 QUOTE_NUMBER NUMBER := FND_API.G_MISS_NUM, -- Quote Number
47 RELATED_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
48 CUST_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
49 PARTY_ID NUMBER := FND_API.G_MISS_NUM,
50 CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR
51 );
52
53 TYPE OPP_QTE_OUT_TBL_TYPE IS TABLE OF OPP_QTE_OUT_REC_TYPE INDEX BY BINARY_INTEGER;
54
55 G_MISS_OPP_QTE_OUT_REC OPP_QTE_OUT_REC_TYPE;
56 G_MISS_OPP_QTE_OUT_TBL OPP_QTE_OUT_TBL_TYPE;
57
58
59 PROCEDURE Create_Qte_Opportunity(
60 P_API_VERSION_NUMBER IN NUMBER,
61 P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
62 P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
63 P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
64 P_SOURCE_CODE IN VARCHAR2,
65 P_QUOTE_HEADER_REC IN ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_MISS_Qte_Header_Rec,
66 P_HEADER_PAYMENT_REC IN ASO_QUOTE_PUB.Payment_Rec_Type := ASO_QUOTE_PUB.G_MISS_Payment_REC,
67 P_HEADER_SHIPMENT_REC IN ASO_QUOTE_PUB.Shipment_Rec_Type := ASO_QUOTE_PUB.G_MISS_Shipment_REC,
68 P_HEADER_TAX_DETAIL_REC IN ASO_QUOTE_PUB.Tax_Detail_Rec_Type := ASO_QUOTE_PUB.G_MISS_Tax_Detail_Rec,
69 P_TEMPLATE_TBL IN ASO_QUOTE_PUB.TEMPLATE_TBL_TYPE := ASO_QUOTE_PUB.G_MISS_TEMPLATE_TBL,
70 P_OPP_QTE_IN_REC IN OPP_QTE_IN_REC_TYPE,
71 P_CONTROL_REC IN ASO_QUOTE_PUB.Control_Rec_Type := ASO_QUOTE_PUB.G_MISS_Control_Rec,
72 X_OPP_QTE_OUT_REC OUT NOCOPY /* file.sql.39 change */ OPP_QTE_OUT_REC_TYPE,
73 X_RETURN_STATUS OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
74 X_MSG_COUNT OUT NOCOPY /* file.sql.39 change */ NUMBER,
75 X_MSG_DATA OUT NOCOPY /* file.sql.39 change */ VARCHAR2
76 );
77
78
79 FUNCTION Validate_Item(
80 p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
81 p_inventory_item_id IN NUMBER,
82 p_organization_id IN NUMBER,
83 p_quantity IN NUMBER,
84 p_uom_code IN VARCHAR2
85 ) RETURN BOOLEAN;
86
87
88 PROCEDURE Set_Copy_Flags
89 (
90 p_object_id IN NUMBER,
91 x_copy_notes_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
92 x_copy_task_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
93 x_copy_att_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2
94 );
95
96
97 Procedure Address_Validation(
98 p_party_site_id IN Number,
99 p_use_type IN VARCHAR2,
100 x_valid OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
101 X_RETURN_STATUS OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
102 X_MSG_COUNT OUT NOCOPY /* file.sql.39 change */ NUMBER,
103 X_MSG_DATA OUT NOCOPY /* file.sql.39 change */ VARCHAR2
104 );
105
106
107 END; -- ASO_OPP_QTE_PUB
108