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
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
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
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
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
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
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
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
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
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
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
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
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
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,
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,
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,
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,
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,
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)
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: );
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:
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;
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:
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,
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
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: );
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:
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;
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:
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,
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,
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,