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 2830: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type :=

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

Line 2831: ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,

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

Line 2832: p_shipment_rec IN ASO_QUOTE_PUB.shipment_rec_type :=

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

Line 2833: ASO_QUOTE_PUB.G_MISS_SHIPMENT_REC,

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

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

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

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

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

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

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

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

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

Line 3213: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type :=

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

Line 3214: ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,

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

Line 3215: p_shipment_rec IN ASO_QUOTE_PUB.shipment_rec_type :=

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

Line 3216: ASO_QUOTE_PUB.G_MISS_SHIPMENT_REC,

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

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

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

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

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

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

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

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

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

Line 3782: p_sales_credit_tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,

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

Line 3860: p_sales_credit_tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,

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

Line 3861: p_qte_line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,

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

Line 3899: P_Qte_Line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,

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

Line 3900: P_Shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type,

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

Line 3945: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,

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

Line 3946: P_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,

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

Line 4386: p_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,

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

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

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

Line 4394: l_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

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

Line 4395: m_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

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

Line 4396: l_search_price_attr1_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

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

Line 4397: l_search_price_attr2_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

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

Line 4398: l_search_priceline_attr1_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

4394: l_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
4395: m_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
4396: l_search_price_attr1_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
4397: l_search_price_attr2_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
4398: l_search_priceline_attr1_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
4399: l_search_priceline_attr2_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
4400: i BINARY_INTEGER;
4401: j BINARY_INTEGER;
4402: temp_count NUMBER;

Line 4399: l_search_priceline_attr2_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

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

Line 5238: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,

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

Line 5239: P_Qte_Line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,

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

Line 5281: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,

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

Line 5282: P_Qte_Line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,

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

Line 5333: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,

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

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

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

Line 5573: P_quote_header_rec IN ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE,

5569: End validate_service_ref_line_id;
5570:
5571: --Changes for Validating Defaulting Parameters (Start):14/09/2005
5572: PROCEDURE VALIDATE_DEFAULTING_DATA(
5573: P_quote_header_rec IN ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE,
5574: P_quote_line_rec IN ASO_QUOTE_PUB.QTE_LINE_Rec_Type,
5575: P_Shipment_header_rec IN ASO_QUOTE_PUB.shipment_rec_type,
5576: P_shipment_line_rec IN ASO_QUOTE_PUB.shipment_rec_type,
5577: P_Payment_header_rec IN ASO_QUOTE_PUB.Payment_Rec_Type,

Line 5574: P_quote_line_rec IN ASO_QUOTE_PUB.QTE_LINE_Rec_Type,

5570:
5571: --Changes for Validating Defaulting Parameters (Start):14/09/2005
5572: PROCEDURE VALIDATE_DEFAULTING_DATA(
5573: P_quote_header_rec IN ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE,
5574: P_quote_line_rec IN ASO_QUOTE_PUB.QTE_LINE_Rec_Type,
5575: P_Shipment_header_rec IN ASO_QUOTE_PUB.shipment_rec_type,
5576: P_shipment_line_rec IN ASO_QUOTE_PUB.shipment_rec_type,
5577: P_Payment_header_rec IN ASO_QUOTE_PUB.Payment_Rec_Type,
5578: P_Payment_line_rec IN ASO_QUOTE_PUB.Payment_Rec_Type,

Line 5575: P_Shipment_header_rec IN ASO_QUOTE_PUB.shipment_rec_type,

5571: --Changes for Validating Defaulting Parameters (Start):14/09/2005
5572: PROCEDURE VALIDATE_DEFAULTING_DATA(
5573: P_quote_header_rec IN ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE,
5574: P_quote_line_rec IN ASO_QUOTE_PUB.QTE_LINE_Rec_Type,
5575: P_Shipment_header_rec IN ASO_QUOTE_PUB.shipment_rec_type,
5576: P_shipment_line_rec IN ASO_QUOTE_PUB.shipment_rec_type,
5577: P_Payment_header_rec IN ASO_QUOTE_PUB.Payment_Rec_Type,
5578: P_Payment_line_rec IN ASO_QUOTE_PUB.Payment_Rec_Type,
5579: P_tax_header_rec IN ASO_QUOTE_PUB.TAX_DETAIL_REC_TYPE,

Line 5576: P_shipment_line_rec IN ASO_QUOTE_PUB.shipment_rec_type,

5572: PROCEDURE VALIDATE_DEFAULTING_DATA(
5573: P_quote_header_rec IN ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE,
5574: P_quote_line_rec IN ASO_QUOTE_PUB.QTE_LINE_Rec_Type,
5575: P_Shipment_header_rec IN ASO_QUOTE_PUB.shipment_rec_type,
5576: P_shipment_line_rec IN ASO_QUOTE_PUB.shipment_rec_type,
5577: P_Payment_header_rec IN ASO_QUOTE_PUB.Payment_Rec_Type,
5578: P_Payment_line_rec IN ASO_QUOTE_PUB.Payment_Rec_Type,
5579: P_tax_header_rec IN ASO_QUOTE_PUB.TAX_DETAIL_REC_TYPE,
5580: P_tax_line_rec IN ASO_QUOTE_PUB.TAX_DETAIL_REC_TYPE,

Line 5577: P_Payment_header_rec IN ASO_QUOTE_PUB.Payment_Rec_Type,

5573: P_quote_header_rec IN ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE,
5574: P_quote_line_rec IN ASO_QUOTE_PUB.QTE_LINE_Rec_Type,
5575: P_Shipment_header_rec IN ASO_QUOTE_PUB.shipment_rec_type,
5576: P_shipment_line_rec IN ASO_QUOTE_PUB.shipment_rec_type,
5577: P_Payment_header_rec IN ASO_QUOTE_PUB.Payment_Rec_Type,
5578: P_Payment_line_rec IN ASO_QUOTE_PUB.Payment_Rec_Type,
5579: P_tax_header_rec IN ASO_QUOTE_PUB.TAX_DETAIL_REC_TYPE,
5580: P_tax_line_rec IN ASO_QUOTE_PUB.TAX_DETAIL_REC_TYPE,
5581: p_def_object_name IN VARCHAR,

Line 5578: P_Payment_line_rec IN ASO_QUOTE_PUB.Payment_Rec_Type,

5574: P_quote_line_rec IN ASO_QUOTE_PUB.QTE_LINE_Rec_Type,
5575: P_Shipment_header_rec IN ASO_QUOTE_PUB.shipment_rec_type,
5576: P_shipment_line_rec IN ASO_QUOTE_PUB.shipment_rec_type,
5577: P_Payment_header_rec IN ASO_QUOTE_PUB.Payment_Rec_Type,
5578: P_Payment_line_rec IN ASO_QUOTE_PUB.Payment_Rec_Type,
5579: P_tax_header_rec IN ASO_QUOTE_PUB.TAX_DETAIL_REC_TYPE,
5580: P_tax_line_rec IN ASO_QUOTE_PUB.TAX_DETAIL_REC_TYPE,
5581: p_def_object_name IN VARCHAR,
5582: X_quote_header_rec OUT NOCOPY ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE,

Line 5579: P_tax_header_rec IN ASO_QUOTE_PUB.TAX_DETAIL_REC_TYPE,

5575: P_Shipment_header_rec IN ASO_QUOTE_PUB.shipment_rec_type,
5576: P_shipment_line_rec IN ASO_QUOTE_PUB.shipment_rec_type,
5577: P_Payment_header_rec IN ASO_QUOTE_PUB.Payment_Rec_Type,
5578: P_Payment_line_rec IN ASO_QUOTE_PUB.Payment_Rec_Type,
5579: P_tax_header_rec IN ASO_QUOTE_PUB.TAX_DETAIL_REC_TYPE,
5580: P_tax_line_rec IN ASO_QUOTE_PUB.TAX_DETAIL_REC_TYPE,
5581: p_def_object_name IN VARCHAR,
5582: X_quote_header_rec OUT NOCOPY ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE,
5583: X_quote_line_rec OUT NOCOPY ASO_QUOTE_PUB.QTE_LINE_Rec_Type,

Line 5580: P_tax_line_rec IN ASO_QUOTE_PUB.TAX_DETAIL_REC_TYPE,

5576: P_shipment_line_rec IN ASO_QUOTE_PUB.shipment_rec_type,
5577: P_Payment_header_rec IN ASO_QUOTE_PUB.Payment_Rec_Type,
5578: P_Payment_line_rec IN ASO_QUOTE_PUB.Payment_Rec_Type,
5579: P_tax_header_rec IN ASO_QUOTE_PUB.TAX_DETAIL_REC_TYPE,
5580: P_tax_line_rec IN ASO_QUOTE_PUB.TAX_DETAIL_REC_TYPE,
5581: p_def_object_name IN VARCHAR,
5582: X_quote_header_rec OUT NOCOPY ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE,
5583: X_quote_line_rec OUT NOCOPY ASO_QUOTE_PUB.QTE_LINE_Rec_Type,
5584: X_Shipment_header_rec OUT NOCOPY ASO_QUOTE_PUB.shipment_rec_type,

Line 5582: X_quote_header_rec OUT NOCOPY ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE,

5578: P_Payment_line_rec IN ASO_QUOTE_PUB.Payment_Rec_Type,
5579: P_tax_header_rec IN ASO_QUOTE_PUB.TAX_DETAIL_REC_TYPE,
5580: P_tax_line_rec IN ASO_QUOTE_PUB.TAX_DETAIL_REC_TYPE,
5581: p_def_object_name IN VARCHAR,
5582: X_quote_header_rec OUT NOCOPY ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE,
5583: X_quote_line_rec OUT NOCOPY ASO_QUOTE_PUB.QTE_LINE_Rec_Type,
5584: X_Shipment_header_rec OUT NOCOPY ASO_QUOTE_PUB.shipment_rec_type,
5585: X_Shipment_line_rec OUT NOCOPY ASO_QUOTE_PUB.shipment_rec_type,
5586: X_Payment_header_rec OUT NOCOPY ASO_QUOTE_PUB.Payment_Rec_Type,

Line 5583: X_quote_line_rec OUT NOCOPY ASO_QUOTE_PUB.QTE_LINE_Rec_Type,

5579: P_tax_header_rec IN ASO_QUOTE_PUB.TAX_DETAIL_REC_TYPE,
5580: P_tax_line_rec IN ASO_QUOTE_PUB.TAX_DETAIL_REC_TYPE,
5581: p_def_object_name IN VARCHAR,
5582: X_quote_header_rec OUT NOCOPY ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE,
5583: X_quote_line_rec OUT NOCOPY ASO_QUOTE_PUB.QTE_LINE_Rec_Type,
5584: X_Shipment_header_rec OUT NOCOPY ASO_QUOTE_PUB.shipment_rec_type,
5585: X_Shipment_line_rec OUT NOCOPY ASO_QUOTE_PUB.shipment_rec_type,
5586: X_Payment_header_rec OUT NOCOPY ASO_QUOTE_PUB.Payment_Rec_Type,
5587: X_Payment_line_rec OUT NOCOPY ASO_QUOTE_PUB.Payment_Rec_Type,

Line 5584: X_Shipment_header_rec OUT NOCOPY ASO_QUOTE_PUB.shipment_rec_type,

5580: P_tax_line_rec IN ASO_QUOTE_PUB.TAX_DETAIL_REC_TYPE,
5581: p_def_object_name IN VARCHAR,
5582: X_quote_header_rec OUT NOCOPY ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE,
5583: X_quote_line_rec OUT NOCOPY ASO_QUOTE_PUB.QTE_LINE_Rec_Type,
5584: X_Shipment_header_rec OUT NOCOPY ASO_QUOTE_PUB.shipment_rec_type,
5585: X_Shipment_line_rec OUT NOCOPY ASO_QUOTE_PUB.shipment_rec_type,
5586: X_Payment_header_rec OUT NOCOPY ASO_QUOTE_PUB.Payment_Rec_Type,
5587: X_Payment_line_rec OUT NOCOPY ASO_QUOTE_PUB.Payment_Rec_Type,
5588: X_tax_header_rec OUT NOCOPY ASO_QUOTE_PUB.TAX_DETAIL_REC_TYPE,

Line 5585: X_Shipment_line_rec OUT NOCOPY ASO_QUOTE_PUB.shipment_rec_type,

5581: p_def_object_name IN VARCHAR,
5582: X_quote_header_rec OUT NOCOPY ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE,
5583: X_quote_line_rec OUT NOCOPY ASO_QUOTE_PUB.QTE_LINE_Rec_Type,
5584: X_Shipment_header_rec OUT NOCOPY ASO_QUOTE_PUB.shipment_rec_type,
5585: X_Shipment_line_rec OUT NOCOPY ASO_QUOTE_PUB.shipment_rec_type,
5586: X_Payment_header_rec OUT NOCOPY ASO_QUOTE_PUB.Payment_Rec_Type,
5587: X_Payment_line_rec OUT NOCOPY ASO_QUOTE_PUB.Payment_Rec_Type,
5588: X_tax_header_rec OUT NOCOPY ASO_QUOTE_PUB.TAX_DETAIL_REC_TYPE,
5589: X_tax_line_rec OUT NOCOPY ASO_QUOTE_PUB.TAX_DETAIL_REC_TYPE,

Line 5586: X_Payment_header_rec OUT NOCOPY ASO_QUOTE_PUB.Payment_Rec_Type,

5582: X_quote_header_rec OUT NOCOPY ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE,
5583: X_quote_line_rec OUT NOCOPY ASO_QUOTE_PUB.QTE_LINE_Rec_Type,
5584: X_Shipment_header_rec OUT NOCOPY ASO_QUOTE_PUB.shipment_rec_type,
5585: X_Shipment_line_rec OUT NOCOPY ASO_QUOTE_PUB.shipment_rec_type,
5586: X_Payment_header_rec OUT NOCOPY ASO_QUOTE_PUB.Payment_Rec_Type,
5587: X_Payment_line_rec OUT NOCOPY ASO_QUOTE_PUB.Payment_Rec_Type,
5588: X_tax_header_rec OUT NOCOPY ASO_QUOTE_PUB.TAX_DETAIL_REC_TYPE,
5589: X_tax_line_rec OUT NOCOPY ASO_QUOTE_PUB.TAX_DETAIL_REC_TYPE,
5590: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 5587: X_Payment_line_rec OUT NOCOPY ASO_QUOTE_PUB.Payment_Rec_Type,

5583: X_quote_line_rec OUT NOCOPY ASO_QUOTE_PUB.QTE_LINE_Rec_Type,
5584: X_Shipment_header_rec OUT NOCOPY ASO_QUOTE_PUB.shipment_rec_type,
5585: X_Shipment_line_rec OUT NOCOPY ASO_QUOTE_PUB.shipment_rec_type,
5586: X_Payment_header_rec OUT NOCOPY ASO_QUOTE_PUB.Payment_Rec_Type,
5587: X_Payment_line_rec OUT NOCOPY ASO_QUOTE_PUB.Payment_Rec_Type,
5588: X_tax_header_rec OUT NOCOPY ASO_QUOTE_PUB.TAX_DETAIL_REC_TYPE,
5589: X_tax_line_rec OUT NOCOPY ASO_QUOTE_PUB.TAX_DETAIL_REC_TYPE,
5590: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
5591: X_MSG_DATA OUT NOCOPY VARCHAR2,

Line 5588: X_tax_header_rec OUT NOCOPY ASO_QUOTE_PUB.TAX_DETAIL_REC_TYPE,

5584: X_Shipment_header_rec OUT NOCOPY ASO_QUOTE_PUB.shipment_rec_type,
5585: X_Shipment_line_rec OUT NOCOPY ASO_QUOTE_PUB.shipment_rec_type,
5586: X_Payment_header_rec OUT NOCOPY ASO_QUOTE_PUB.Payment_Rec_Type,
5587: X_Payment_line_rec OUT NOCOPY ASO_QUOTE_PUB.Payment_Rec_Type,
5588: X_tax_header_rec OUT NOCOPY ASO_QUOTE_PUB.TAX_DETAIL_REC_TYPE,
5589: X_tax_line_rec OUT NOCOPY ASO_QUOTE_PUB.TAX_DETAIL_REC_TYPE,
5590: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
5591: X_MSG_DATA OUT NOCOPY VARCHAR2,
5592: X_MSG_COUNT OUT NOCOPY VARCHAR2

Line 5589: X_tax_line_rec OUT NOCOPY ASO_QUOTE_PUB.TAX_DETAIL_REC_TYPE,

5585: X_Shipment_line_rec OUT NOCOPY ASO_QUOTE_PUB.shipment_rec_type,
5586: X_Payment_header_rec OUT NOCOPY ASO_QUOTE_PUB.Payment_Rec_Type,
5587: X_Payment_line_rec OUT NOCOPY ASO_QUOTE_PUB.Payment_Rec_Type,
5588: X_tax_header_rec OUT NOCOPY ASO_QUOTE_PUB.TAX_DETAIL_REC_TYPE,
5589: X_tax_line_rec OUT NOCOPY ASO_QUOTE_PUB.TAX_DETAIL_REC_TYPE,
5590: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
5591: X_MSG_DATA OUT NOCOPY VARCHAR2,
5592: X_MSG_COUNT OUT NOCOPY VARCHAR2
5593:

Line 9483: p_payment_rec IN aso_quote_pub.payment_rec_type,

9479:
9480: Procedure Validate_cc_info
9481: (
9482: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
9483: p_payment_rec IN aso_quote_pub.payment_rec_type,
9484: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
9485: P_Qte_Line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_REC,
9486: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
9487: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 9484: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,

9480: Procedure Validate_cc_info
9481: (
9482: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
9483: p_payment_rec IN aso_quote_pub.payment_rec_type,
9484: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
9485: P_Qte_Line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_REC,
9486: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
9487: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
9488: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)

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

9481: (
9482: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
9483: p_payment_rec IN aso_quote_pub.payment_rec_type,
9484: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
9485: P_Qte_Line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_REC,
9486: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
9487: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
9488: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
9489: IS

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

9594:
9595: End Validate_cc_info;
9596:
9597:
9598: PROCEDURE VALIDATE_OU(p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type) IS --Procedure for OU Validtion (Yogeshwar 05/10/2005)
9599:
9600: l_org_id number;
9601: l_access_mode varchar2(1);
9602: