eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ASO_VALIDATE_PVT dependencies on ASO_QUOTE_PUB

Line 1656: p_desc_flex_rec IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.attribute_rec_type,

1652: END IF;
1653: END Validate_Quote_Number;
1654:
1655: PROCEDURE Validate_Desc_Flexfield(
1656: p_desc_flex_rec IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.attribute_rec_type,
1657: p_desc_flex_name IN VARCHAR2 ,
1658: p_value_or_id IN VARCHAR2 := 'I',
1659: x_return_status OUT NOCOPY /* file.sql.39 change */ varchar2)
1660: IS

Line 1671: WHERE application_id = ASO_QUOTE_PUB.OC_APPL_ID

1667:
1668: CURSOR desc_flex_exists IS
1669: SELECT 'Y'
1670: FROM fnd_descriptive_flexs
1671: WHERE application_id = ASO_QUOTE_PUB.OC_APPL_ID
1672: and descriptive_flexfield_name = p_desc_flex_name;
1673:
1674:
1675: BEGIN

Line 2833: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type :=

2829: END Validate_Org_Contact_crs;
2830:
2831: PROCEDURE Validate_item_tca_bsc(
2832: p_init_msg_list IN VARCHAR2,
2833: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type :=
2834: ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,
2835: p_shipment_rec IN ASO_QUOTE_PUB.shipment_rec_type :=
2836: ASO_QUOTE_PUB.G_MISS_SHIPMENT_REC,
2837: p_operation_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 2834: ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,

2830:
2831: PROCEDURE Validate_item_tca_bsc(
2832: p_init_msg_list IN VARCHAR2,
2833: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type :=
2834: ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,
2835: p_shipment_rec IN ASO_QUOTE_PUB.shipment_rec_type :=
2836: ASO_QUOTE_PUB.G_MISS_SHIPMENT_REC,
2837: p_operation_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
2838: p_application_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 2835: p_shipment_rec IN ASO_QUOTE_PUB.shipment_rec_type :=

2831: PROCEDURE Validate_item_tca_bsc(
2832: p_init_msg_list IN VARCHAR2,
2833: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type :=
2834: ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,
2835: p_shipment_rec IN ASO_QUOTE_PUB.shipment_rec_type :=
2836: ASO_QUOTE_PUB.G_MISS_SHIPMENT_REC,
2837: p_operation_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
2838: p_application_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
2839: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 2836: ASO_QUOTE_PUB.G_MISS_SHIPMENT_REC,

2832: p_init_msg_list IN VARCHAR2,
2833: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type :=
2834: ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,
2835: p_shipment_rec IN ASO_QUOTE_PUB.shipment_rec_type :=
2836: ASO_QUOTE_PUB.G_MISS_SHIPMENT_REC,
2837: p_operation_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
2838: p_application_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
2839: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
2840: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 2846: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;

2842: IS
2843: l_api_name CONSTANT VARCHAR2(30) := 'Validate_item_tca_bsc';
2844: l_party_id NUMBER;
2845:
2846: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;
2847: lp_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;
2848: l_shipment_rec ASO_QUOTE_PUB.shipment_rec_type := ASO_QUOTE_PUB.G_MISS_SHIPMENT_REC;
2849: lp_shipment_rec ASO_QUOTE_PUB.shipment_rec_type := ASO_QUOTE_PUB.G_MISS_SHIPMENT_REC;
2850:

Line 2847: lp_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;

2843: l_api_name CONSTANT VARCHAR2(30) := 'Validate_item_tca_bsc';
2844: l_party_id NUMBER;
2845:
2846: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;
2847: lp_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;
2848: l_shipment_rec ASO_QUOTE_PUB.shipment_rec_type := ASO_QUOTE_PUB.G_MISS_SHIPMENT_REC;
2849: lp_shipment_rec ASO_QUOTE_PUB.shipment_rec_type := ASO_QUOTE_PUB.G_MISS_SHIPMENT_REC;
2850:
2851: CURSOR C_Get_Party_From_Org(l_org_contact_id NUMBER) IS

Line 2848: l_shipment_rec ASO_QUOTE_PUB.shipment_rec_type := ASO_QUOTE_PUB.G_MISS_SHIPMENT_REC;

2844: l_party_id NUMBER;
2845:
2846: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;
2847: lp_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;
2848: l_shipment_rec ASO_QUOTE_PUB.shipment_rec_type := ASO_QUOTE_PUB.G_MISS_SHIPMENT_REC;
2849: lp_shipment_rec ASO_QUOTE_PUB.shipment_rec_type := ASO_QUOTE_PUB.G_MISS_SHIPMENT_REC;
2850:
2851: CURSOR C_Get_Party_From_Org(l_org_contact_id NUMBER) IS
2852: SELECT par.party_id

Line 2849: lp_shipment_rec ASO_QUOTE_PUB.shipment_rec_type := ASO_QUOTE_PUB.G_MISS_SHIPMENT_REC;

2845:
2846: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;
2847: lp_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;
2848: l_shipment_rec ASO_QUOTE_PUB.shipment_rec_type := ASO_QUOTE_PUB.G_MISS_SHIPMENT_REC;
2849: lp_shipment_rec ASO_QUOTE_PUB.shipment_rec_type := ASO_QUOTE_PUB.G_MISS_SHIPMENT_REC;
2850:
2851: CURSOR C_Get_Party_From_Org(l_org_contact_id NUMBER) IS
2852: SELECT par.party_id
2853: FROM hz_relationships par,

Line 3216: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type :=

3212:
3213:
3214: PROCEDURE Validate_record_tca_crs(
3215: p_init_msg_list IN VARCHAR2,
3216: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type :=
3217: ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,
3218: p_shipment_rec IN ASO_QUOTE_PUB.shipment_rec_type :=
3219: ASO_QUOTE_PUB.G_MISS_SHIPMENT_REC,
3220: p_operation_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 3217: ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,

3213:
3214: PROCEDURE Validate_record_tca_crs(
3215: p_init_msg_list IN VARCHAR2,
3216: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type :=
3217: ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,
3218: p_shipment_rec IN ASO_QUOTE_PUB.shipment_rec_type :=
3219: ASO_QUOTE_PUB.G_MISS_SHIPMENT_REC,
3220: p_operation_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
3221: p_application_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 3218: p_shipment_rec IN ASO_QUOTE_PUB.shipment_rec_type :=

3214: PROCEDURE Validate_record_tca_crs(
3215: p_init_msg_list IN VARCHAR2,
3216: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type :=
3217: ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,
3218: p_shipment_rec IN ASO_QUOTE_PUB.shipment_rec_type :=
3219: ASO_QUOTE_PUB.G_MISS_SHIPMENT_REC,
3220: p_operation_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
3221: p_application_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
3222: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 3219: ASO_QUOTE_PUB.G_MISS_SHIPMENT_REC,

3215: p_init_msg_list IN VARCHAR2,
3216: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type :=
3217: ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,
3218: p_shipment_rec IN ASO_QUOTE_PUB.shipment_rec_type :=
3219: ASO_QUOTE_PUB.G_MISS_SHIPMENT_REC,
3220: p_operation_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
3221: p_application_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
3222: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
3223: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 3230: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;

3226:
3227: l_api_name VARCHAR2(40) := 'Validate_record_tca_crs' ;
3228: l_party_id NUMBER;
3229:
3230: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;
3231: lp_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;
3232: l_shipment_rec ASO_QUOTE_PUB.shipment_rec_type := ASO_QUOTE_PUB.G_MISS_SHIPMENT_REC;
3233: lp_shipment_rec ASO_QUOTE_PUB.shipment_rec_type := ASO_QUOTE_PUB.G_MISS_SHIPMENT_REC;
3234:

Line 3231: lp_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;

3227: l_api_name VARCHAR2(40) := 'Validate_record_tca_crs' ;
3228: l_party_id NUMBER;
3229:
3230: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;
3231: lp_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;
3232: l_shipment_rec ASO_QUOTE_PUB.shipment_rec_type := ASO_QUOTE_PUB.G_MISS_SHIPMENT_REC;
3233: lp_shipment_rec ASO_QUOTE_PUB.shipment_rec_type := ASO_QUOTE_PUB.G_MISS_SHIPMENT_REC;
3234:
3235: CURSOR C_Get_Party_From_Org(l_org_contact_id NUMBER) IS

Line 3232: l_shipment_rec ASO_QUOTE_PUB.shipment_rec_type := ASO_QUOTE_PUB.G_MISS_SHIPMENT_REC;

3228: l_party_id NUMBER;
3229:
3230: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;
3231: lp_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;
3232: l_shipment_rec ASO_QUOTE_PUB.shipment_rec_type := ASO_QUOTE_PUB.G_MISS_SHIPMENT_REC;
3233: lp_shipment_rec ASO_QUOTE_PUB.shipment_rec_type := ASO_QUOTE_PUB.G_MISS_SHIPMENT_REC;
3234:
3235: CURSOR C_Get_Party_From_Org(l_org_contact_id NUMBER) IS
3236: SELECT par.party_id

Line 3233: lp_shipment_rec ASO_QUOTE_PUB.shipment_rec_type := ASO_QUOTE_PUB.G_MISS_SHIPMENT_REC;

3229:
3230: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;
3231: lp_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;
3232: l_shipment_rec ASO_QUOTE_PUB.shipment_rec_type := ASO_QUOTE_PUB.G_MISS_SHIPMENT_REC;
3233: lp_shipment_rec ASO_QUOTE_PUB.shipment_rec_type := ASO_QUOTE_PUB.G_MISS_SHIPMENT_REC;
3234:
3235: CURSOR C_Get_Party_From_Org(l_org_contact_id NUMBER) IS
3236: SELECT par.party_id
3237: FROM hz_relationships par,

Line 3785: p_sales_credit_tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,

3781:
3782:
3783: Procedure Validate_Quote_Percent(
3784: p_init_msg_list IN VARCHAR2,
3785: p_sales_credit_tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
3786: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
3787: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
3788: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
3789: )

Line 3863: p_sales_credit_tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,

3859:
3860:
3861: Procedure Validate_Sales_Credit_Return(
3862: p_init_msg_list IN VARCHAR2,
3863: p_sales_credit_tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
3864: p_qte_line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
3865: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
3866: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
3867: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 3864: p_qte_line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,

3860:
3861: Procedure Validate_Sales_Credit_Return(
3862: p_init_msg_list IN VARCHAR2,
3863: p_sales_credit_tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
3864: p_qte_line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
3865: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
3866: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
3867: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
3868: )

Line 3902: P_Qte_Line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,

3898: END Validate_Sales_Credit_Return;
3899:
3900:
3901: PROCEDURE validate_ship_from_org_ID (
3902: P_Qte_Line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
3903: P_Shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type,
3904: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
3905: )
3906: IS

Line 3903: P_Shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type,

3899:
3900:
3901: PROCEDURE validate_ship_from_org_ID (
3902: P_Qte_Line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
3903: P_Shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type,
3904: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
3905: )
3906: IS
3907:

Line 3948: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,

3944:
3945:
3946: PROCEDURE Validate_Commitment(
3947: P_Init_Msg_List IN VARCHAR2,
3948: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
3949: P_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
3950: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
3951: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
3952: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)

Line 3949: P_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,

3945:
3946: PROCEDURE Validate_Commitment(
3947: P_Init_Msg_List IN VARCHAR2,
3948: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
3949: P_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
3950: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
3951: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
3952: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
3953:

Line 4389: p_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,

4385: PROCEDURE Validate_Promotion (
4386: P_Api_Version_Number IN NUMBER,
4387: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
4388: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
4389: p_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
4390: x_price_attr_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
4391: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
4392: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
4393: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)

Line 4390: x_price_attr_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,

4386: P_Api_Version_Number IN NUMBER,
4387: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
4388: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
4389: p_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
4390: x_price_attr_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
4391: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
4392: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
4393: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
4394: IS

Line 4397: l_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

4393: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
4394: IS
4395: l_api_name CONSTANT VARCHAR2(30) := 'Validate_Promotion';
4396: l_api_version_number CONSTANT NUMBER := 1.0;
4397: l_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
4398: m_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
4399: l_search_price_attr1_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
4400: l_search_price_attr2_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
4401: l_search_priceline_attr1_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

Line 4398: m_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

4394: IS
4395: l_api_name CONSTANT VARCHAR2(30) := 'Validate_Promotion';
4396: l_api_version_number CONSTANT NUMBER := 1.0;
4397: l_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
4398: m_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
4399: l_search_price_attr1_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
4400: l_search_price_attr2_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
4401: l_search_priceline_attr1_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
4402: l_search_priceline_attr2_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

Line 4399: l_search_price_attr1_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

4395: l_api_name CONSTANT VARCHAR2(30) := 'Validate_Promotion';
4396: l_api_version_number CONSTANT NUMBER := 1.0;
4397: l_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
4398: m_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
4399: l_search_price_attr1_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
4400: l_search_price_attr2_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
4401: l_search_priceline_attr1_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
4402: l_search_priceline_attr2_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
4403: i BINARY_INTEGER;

Line 4400: l_search_price_attr2_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

4396: l_api_version_number CONSTANT NUMBER := 1.0;
4397: l_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
4398: m_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
4399: l_search_price_attr1_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
4400: l_search_price_attr2_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
4401: l_search_priceline_attr1_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
4402: l_search_priceline_attr2_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
4403: i BINARY_INTEGER;
4404: j BINARY_INTEGER;

Line 4401: l_search_priceline_attr1_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

4397: l_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
4398: m_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
4399: l_search_price_attr1_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
4400: l_search_price_attr2_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
4401: l_search_priceline_attr1_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
4402: l_search_priceline_attr2_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
4403: i BINARY_INTEGER;
4404: j BINARY_INTEGER;
4405: temp_count NUMBER;

Line 4402: l_search_priceline_attr2_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

4398: m_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
4399: l_search_price_attr1_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
4400: l_search_price_attr2_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
4401: l_search_priceline_attr1_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
4402: l_search_priceline_attr2_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
4403: i BINARY_INTEGER;
4404: j BINARY_INTEGER;
4405: temp_count NUMBER;
4406: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

Line 5241: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,

5237:
5238: Procedure Validate_ln_type_for_ord_type
5239: (
5240: p_init_msg_list IN VARCHAR2,
5241: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
5242: P_Qte_Line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
5243: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
5244: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
5245: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)

Line 5242: P_Qte_Line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,

5238: Procedure Validate_ln_type_for_ord_type
5239: (
5240: p_init_msg_list IN VARCHAR2,
5241: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
5242: P_Qte_Line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
5243: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
5244: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
5245: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
5246: IS

Line 5284: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,

5280:
5281: Procedure Validate_ln_category_code
5282: (
5283: p_init_msg_list IN VARCHAR2,
5284: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
5285: P_Qte_Line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
5286: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
5287: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
5288: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)

Line 5285: P_Qte_Line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,

5281: Procedure Validate_ln_category_code
5282: (
5283: p_init_msg_list IN VARCHAR2,
5284: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
5285: P_Qte_Line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
5286: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
5287: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
5288: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
5289: IS

Line 5336: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,

5332:
5333: Procedure Validate_po_line_number
5334: (
5335: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
5336: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
5337: P_Qte_Line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_REC,
5338: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
5339: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
5340: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)

Line 5337: P_Qte_Line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_REC,

5333: Procedure Validate_po_line_number
5334: (
5335: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
5336: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
5337: P_Qte_Line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_REC,
5338: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
5339: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
5340: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
5341: IS

Line 5589: P_quote_header_rec IN ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE,

5585: End validate_service_ref_line_id;
5586:
5587: --Changes for Validating Defaulting Parameters (Start):14/09/2005
5588: PROCEDURE VALIDATE_DEFAULTING_DATA(
5589: P_quote_header_rec IN ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE,
5590: P_quote_line_rec IN ASO_QUOTE_PUB.QTE_LINE_Rec_Type,
5591: P_Shipment_header_rec IN ASO_QUOTE_PUB.shipment_rec_type,
5592: P_shipment_line_rec IN ASO_QUOTE_PUB.shipment_rec_type,
5593: P_Payment_header_rec IN ASO_QUOTE_PUB.Payment_Rec_Type,

Line 5590: P_quote_line_rec IN ASO_QUOTE_PUB.QTE_LINE_Rec_Type,

5586:
5587: --Changes for Validating Defaulting Parameters (Start):14/09/2005
5588: PROCEDURE VALIDATE_DEFAULTING_DATA(
5589: P_quote_header_rec IN ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE,
5590: P_quote_line_rec IN ASO_QUOTE_PUB.QTE_LINE_Rec_Type,
5591: P_Shipment_header_rec IN ASO_QUOTE_PUB.shipment_rec_type,
5592: P_shipment_line_rec IN ASO_QUOTE_PUB.shipment_rec_type,
5593: P_Payment_header_rec IN ASO_QUOTE_PUB.Payment_Rec_Type,
5594: P_Payment_line_rec IN ASO_QUOTE_PUB.Payment_Rec_Type,

Line 5591: P_Shipment_header_rec IN ASO_QUOTE_PUB.shipment_rec_type,

5587: --Changes for Validating Defaulting Parameters (Start):14/09/2005
5588: PROCEDURE VALIDATE_DEFAULTING_DATA(
5589: P_quote_header_rec IN ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE,
5590: P_quote_line_rec IN ASO_QUOTE_PUB.QTE_LINE_Rec_Type,
5591: P_Shipment_header_rec IN ASO_QUOTE_PUB.shipment_rec_type,
5592: P_shipment_line_rec IN ASO_QUOTE_PUB.shipment_rec_type,
5593: P_Payment_header_rec IN ASO_QUOTE_PUB.Payment_Rec_Type,
5594: P_Payment_line_rec IN ASO_QUOTE_PUB.Payment_Rec_Type,
5595: P_tax_header_rec IN ASO_QUOTE_PUB.TAX_DETAIL_REC_TYPE,

Line 5592: P_shipment_line_rec IN ASO_QUOTE_PUB.shipment_rec_type,

5588: PROCEDURE VALIDATE_DEFAULTING_DATA(
5589: P_quote_header_rec IN ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE,
5590: P_quote_line_rec IN ASO_QUOTE_PUB.QTE_LINE_Rec_Type,
5591: P_Shipment_header_rec IN ASO_QUOTE_PUB.shipment_rec_type,
5592: P_shipment_line_rec IN ASO_QUOTE_PUB.shipment_rec_type,
5593: P_Payment_header_rec IN ASO_QUOTE_PUB.Payment_Rec_Type,
5594: P_Payment_line_rec IN ASO_QUOTE_PUB.Payment_Rec_Type,
5595: P_tax_header_rec IN ASO_QUOTE_PUB.TAX_DETAIL_REC_TYPE,
5596: P_tax_line_rec IN ASO_QUOTE_PUB.TAX_DETAIL_REC_TYPE,

Line 5593: P_Payment_header_rec IN ASO_QUOTE_PUB.Payment_Rec_Type,

5589: P_quote_header_rec IN ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE,
5590: P_quote_line_rec IN ASO_QUOTE_PUB.QTE_LINE_Rec_Type,
5591: P_Shipment_header_rec IN ASO_QUOTE_PUB.shipment_rec_type,
5592: P_shipment_line_rec IN ASO_QUOTE_PUB.shipment_rec_type,
5593: P_Payment_header_rec IN ASO_QUOTE_PUB.Payment_Rec_Type,
5594: P_Payment_line_rec IN ASO_QUOTE_PUB.Payment_Rec_Type,
5595: P_tax_header_rec IN ASO_QUOTE_PUB.TAX_DETAIL_REC_TYPE,
5596: P_tax_line_rec IN ASO_QUOTE_PUB.TAX_DETAIL_REC_TYPE,
5597: p_def_object_name IN VARCHAR,

Line 5594: P_Payment_line_rec IN ASO_QUOTE_PUB.Payment_Rec_Type,

5590: P_quote_line_rec IN ASO_QUOTE_PUB.QTE_LINE_Rec_Type,
5591: P_Shipment_header_rec IN ASO_QUOTE_PUB.shipment_rec_type,
5592: P_shipment_line_rec IN ASO_QUOTE_PUB.shipment_rec_type,
5593: P_Payment_header_rec IN ASO_QUOTE_PUB.Payment_Rec_Type,
5594: P_Payment_line_rec IN ASO_QUOTE_PUB.Payment_Rec_Type,
5595: P_tax_header_rec IN ASO_QUOTE_PUB.TAX_DETAIL_REC_TYPE,
5596: P_tax_line_rec IN ASO_QUOTE_PUB.TAX_DETAIL_REC_TYPE,
5597: p_def_object_name IN VARCHAR,
5598: X_quote_header_rec OUT NOCOPY ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE,

Line 5595: P_tax_header_rec IN ASO_QUOTE_PUB.TAX_DETAIL_REC_TYPE,

5591: P_Shipment_header_rec IN ASO_QUOTE_PUB.shipment_rec_type,
5592: P_shipment_line_rec IN ASO_QUOTE_PUB.shipment_rec_type,
5593: P_Payment_header_rec IN ASO_QUOTE_PUB.Payment_Rec_Type,
5594: P_Payment_line_rec IN ASO_QUOTE_PUB.Payment_Rec_Type,
5595: P_tax_header_rec IN ASO_QUOTE_PUB.TAX_DETAIL_REC_TYPE,
5596: P_tax_line_rec IN ASO_QUOTE_PUB.TAX_DETAIL_REC_TYPE,
5597: p_def_object_name IN VARCHAR,
5598: X_quote_header_rec OUT NOCOPY ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE,
5599: X_quote_line_rec OUT NOCOPY ASO_QUOTE_PUB.QTE_LINE_Rec_Type,

Line 5596: P_tax_line_rec IN ASO_QUOTE_PUB.TAX_DETAIL_REC_TYPE,

5592: P_shipment_line_rec IN ASO_QUOTE_PUB.shipment_rec_type,
5593: P_Payment_header_rec IN ASO_QUOTE_PUB.Payment_Rec_Type,
5594: P_Payment_line_rec IN ASO_QUOTE_PUB.Payment_Rec_Type,
5595: P_tax_header_rec IN ASO_QUOTE_PUB.TAX_DETAIL_REC_TYPE,
5596: P_tax_line_rec IN ASO_QUOTE_PUB.TAX_DETAIL_REC_TYPE,
5597: p_def_object_name IN VARCHAR,
5598: X_quote_header_rec OUT NOCOPY ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE,
5599: X_quote_line_rec OUT NOCOPY ASO_QUOTE_PUB.QTE_LINE_Rec_Type,
5600: X_Shipment_header_rec OUT NOCOPY ASO_QUOTE_PUB.shipment_rec_type,

Line 5598: X_quote_header_rec OUT NOCOPY ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE,

5594: P_Payment_line_rec IN ASO_QUOTE_PUB.Payment_Rec_Type,
5595: P_tax_header_rec IN ASO_QUOTE_PUB.TAX_DETAIL_REC_TYPE,
5596: P_tax_line_rec IN ASO_QUOTE_PUB.TAX_DETAIL_REC_TYPE,
5597: p_def_object_name IN VARCHAR,
5598: X_quote_header_rec OUT NOCOPY ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE,
5599: X_quote_line_rec OUT NOCOPY ASO_QUOTE_PUB.QTE_LINE_Rec_Type,
5600: X_Shipment_header_rec OUT NOCOPY ASO_QUOTE_PUB.shipment_rec_type,
5601: X_Shipment_line_rec OUT NOCOPY ASO_QUOTE_PUB.shipment_rec_type,
5602: X_Payment_header_rec OUT NOCOPY ASO_QUOTE_PUB.Payment_Rec_Type,

Line 5599: X_quote_line_rec OUT NOCOPY ASO_QUOTE_PUB.QTE_LINE_Rec_Type,

5595: P_tax_header_rec IN ASO_QUOTE_PUB.TAX_DETAIL_REC_TYPE,
5596: P_tax_line_rec IN ASO_QUOTE_PUB.TAX_DETAIL_REC_TYPE,
5597: p_def_object_name IN VARCHAR,
5598: X_quote_header_rec OUT NOCOPY ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE,
5599: X_quote_line_rec OUT NOCOPY ASO_QUOTE_PUB.QTE_LINE_Rec_Type,
5600: X_Shipment_header_rec OUT NOCOPY ASO_QUOTE_PUB.shipment_rec_type,
5601: X_Shipment_line_rec OUT NOCOPY ASO_QUOTE_PUB.shipment_rec_type,
5602: X_Payment_header_rec OUT NOCOPY ASO_QUOTE_PUB.Payment_Rec_Type,
5603: X_Payment_line_rec OUT NOCOPY ASO_QUOTE_PUB.Payment_Rec_Type,

Line 5600: X_Shipment_header_rec OUT NOCOPY ASO_QUOTE_PUB.shipment_rec_type,

5596: P_tax_line_rec IN ASO_QUOTE_PUB.TAX_DETAIL_REC_TYPE,
5597: p_def_object_name IN VARCHAR,
5598: X_quote_header_rec OUT NOCOPY ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE,
5599: X_quote_line_rec OUT NOCOPY ASO_QUOTE_PUB.QTE_LINE_Rec_Type,
5600: X_Shipment_header_rec OUT NOCOPY ASO_QUOTE_PUB.shipment_rec_type,
5601: X_Shipment_line_rec OUT NOCOPY ASO_QUOTE_PUB.shipment_rec_type,
5602: X_Payment_header_rec OUT NOCOPY ASO_QUOTE_PUB.Payment_Rec_Type,
5603: X_Payment_line_rec OUT NOCOPY ASO_QUOTE_PUB.Payment_Rec_Type,
5604: X_tax_header_rec OUT NOCOPY ASO_QUOTE_PUB.TAX_DETAIL_REC_TYPE,

Line 5601: X_Shipment_line_rec OUT NOCOPY ASO_QUOTE_PUB.shipment_rec_type,

5597: p_def_object_name IN VARCHAR,
5598: X_quote_header_rec OUT NOCOPY ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE,
5599: X_quote_line_rec OUT NOCOPY ASO_QUOTE_PUB.QTE_LINE_Rec_Type,
5600: X_Shipment_header_rec OUT NOCOPY ASO_QUOTE_PUB.shipment_rec_type,
5601: X_Shipment_line_rec OUT NOCOPY ASO_QUOTE_PUB.shipment_rec_type,
5602: X_Payment_header_rec OUT NOCOPY ASO_QUOTE_PUB.Payment_Rec_Type,
5603: X_Payment_line_rec OUT NOCOPY ASO_QUOTE_PUB.Payment_Rec_Type,
5604: X_tax_header_rec OUT NOCOPY ASO_QUOTE_PUB.TAX_DETAIL_REC_TYPE,
5605: X_tax_line_rec OUT NOCOPY ASO_QUOTE_PUB.TAX_DETAIL_REC_TYPE,

Line 5602: X_Payment_header_rec OUT NOCOPY ASO_QUOTE_PUB.Payment_Rec_Type,

5598: X_quote_header_rec OUT NOCOPY ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE,
5599: X_quote_line_rec OUT NOCOPY ASO_QUOTE_PUB.QTE_LINE_Rec_Type,
5600: X_Shipment_header_rec OUT NOCOPY ASO_QUOTE_PUB.shipment_rec_type,
5601: X_Shipment_line_rec OUT NOCOPY ASO_QUOTE_PUB.shipment_rec_type,
5602: X_Payment_header_rec OUT NOCOPY ASO_QUOTE_PUB.Payment_Rec_Type,
5603: X_Payment_line_rec OUT NOCOPY ASO_QUOTE_PUB.Payment_Rec_Type,
5604: X_tax_header_rec OUT NOCOPY ASO_QUOTE_PUB.TAX_DETAIL_REC_TYPE,
5605: X_tax_line_rec OUT NOCOPY ASO_QUOTE_PUB.TAX_DETAIL_REC_TYPE,
5606: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 5603: X_Payment_line_rec OUT NOCOPY ASO_QUOTE_PUB.Payment_Rec_Type,

5599: X_quote_line_rec OUT NOCOPY ASO_QUOTE_PUB.QTE_LINE_Rec_Type,
5600: X_Shipment_header_rec OUT NOCOPY ASO_QUOTE_PUB.shipment_rec_type,
5601: X_Shipment_line_rec OUT NOCOPY ASO_QUOTE_PUB.shipment_rec_type,
5602: X_Payment_header_rec OUT NOCOPY ASO_QUOTE_PUB.Payment_Rec_Type,
5603: X_Payment_line_rec OUT NOCOPY ASO_QUOTE_PUB.Payment_Rec_Type,
5604: X_tax_header_rec OUT NOCOPY ASO_QUOTE_PUB.TAX_DETAIL_REC_TYPE,
5605: X_tax_line_rec OUT NOCOPY ASO_QUOTE_PUB.TAX_DETAIL_REC_TYPE,
5606: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
5607: X_MSG_DATA OUT NOCOPY VARCHAR2,

Line 5604: X_tax_header_rec OUT NOCOPY ASO_QUOTE_PUB.TAX_DETAIL_REC_TYPE,

5600: X_Shipment_header_rec OUT NOCOPY ASO_QUOTE_PUB.shipment_rec_type,
5601: X_Shipment_line_rec OUT NOCOPY ASO_QUOTE_PUB.shipment_rec_type,
5602: X_Payment_header_rec OUT NOCOPY ASO_QUOTE_PUB.Payment_Rec_Type,
5603: X_Payment_line_rec OUT NOCOPY ASO_QUOTE_PUB.Payment_Rec_Type,
5604: X_tax_header_rec OUT NOCOPY ASO_QUOTE_PUB.TAX_DETAIL_REC_TYPE,
5605: X_tax_line_rec OUT NOCOPY ASO_QUOTE_PUB.TAX_DETAIL_REC_TYPE,
5606: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
5607: X_MSG_DATA OUT NOCOPY VARCHAR2,
5608: X_MSG_COUNT OUT NOCOPY VARCHAR2

Line 5605: X_tax_line_rec OUT NOCOPY ASO_QUOTE_PUB.TAX_DETAIL_REC_TYPE,

5601: X_Shipment_line_rec OUT NOCOPY ASO_QUOTE_PUB.shipment_rec_type,
5602: X_Payment_header_rec OUT NOCOPY ASO_QUOTE_PUB.Payment_Rec_Type,
5603: X_Payment_line_rec OUT NOCOPY ASO_QUOTE_PUB.Payment_Rec_Type,
5604: X_tax_header_rec OUT NOCOPY ASO_QUOTE_PUB.TAX_DETAIL_REC_TYPE,
5605: X_tax_line_rec OUT NOCOPY ASO_QUOTE_PUB.TAX_DETAIL_REC_TYPE,
5606: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
5607: X_MSG_DATA OUT NOCOPY VARCHAR2,
5608: X_MSG_COUNT OUT NOCOPY VARCHAR2
5609:

Line 9531: p_payment_rec IN aso_quote_pub.payment_rec_type,

9527:
9528: Procedure Validate_cc_info
9529: (
9530: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
9531: p_payment_rec IN aso_quote_pub.payment_rec_type,
9532: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
9533: P_Qte_Line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_REC,
9534: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
9535: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 9532: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,

9528: Procedure Validate_cc_info
9529: (
9530: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
9531: p_payment_rec IN aso_quote_pub.payment_rec_type,
9532: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
9533: P_Qte_Line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_REC,
9534: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
9535: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
9536: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)

Line 9533: P_Qte_Line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_REC,

9529: (
9530: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
9531: p_payment_rec IN aso_quote_pub.payment_rec_type,
9532: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
9533: P_Qte_Line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_REC,
9534: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
9535: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
9536: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
9537: IS

Line 9646: PROCEDURE VALIDATE_OU(p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type) IS --Procedure for OU Validtion (Yogeshwar 05/10/2005)

9642:
9643: End Validate_cc_info;
9644:
9645:
9646: PROCEDURE VALIDATE_OU(p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type) IS --Procedure for OU Validtion (Yogeshwar 05/10/2005)
9647:
9648: l_org_id number;
9649: l_access_mode varchar2(1);
9650: