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.IBE_ORD_ONECLICK_PVT dependencies on ASO_QUOTE_PUB

Line 650: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;

646: l_credit_card_num NUMBER;
647: l_credit_card_name VARCHAR2(80);
648: l_credit_card_exp DATE;
649: l_credit_card_holder_name VARCHAR2(50);
650: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
651: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
652: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
653: l_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
654: l_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;

Line 651: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;

647: l_credit_card_name VARCHAR2(80);
648: l_credit_card_exp DATE;
649: l_credit_card_holder_name VARCHAR2(50);
650: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
651: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
652: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
653: l_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
654: l_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
655: l_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;

Line 652: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;

648: l_credit_card_exp DATE;
649: l_credit_card_holder_name VARCHAR2(50);
650: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
651: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
652: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
653: l_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
654: l_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
655: l_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
656: l_payment_rec ASO_QUOTE_PUB.Payment_Rec_Type;

Line 653: l_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;

649: l_credit_card_holder_name VARCHAR2(50);
650: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
651: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
652: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
653: l_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
654: l_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
655: l_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
656: l_payment_rec ASO_QUOTE_PUB.Payment_Rec_Type;
657: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;

Line 654: l_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;

650: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
651: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
652: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
653: l_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
654: l_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
655: l_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
656: l_payment_rec ASO_QUOTE_PUB.Payment_Rec_Type;
657: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
658: l_tax_detail_rec ASO_QUOTE_PUB.Tax_Detail_Rec_Type;

Line 655: l_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;

651: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
652: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
653: l_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
654: l_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
655: l_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
656: l_payment_rec ASO_QUOTE_PUB.Payment_Rec_Type;
657: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
658: l_tax_detail_rec ASO_QUOTE_PUB.Tax_Detail_Rec_Type;
659: l_attach_contract VARCHAR2(1);

Line 656: l_payment_rec ASO_QUOTE_PUB.Payment_Rec_Type;

652: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
653: l_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
654: l_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
655: l_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
656: l_payment_rec ASO_QUOTE_PUB.Payment_Rec_Type;
657: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
658: l_tax_detail_rec ASO_QUOTE_PUB.Tax_Detail_Rec_Type;
659: l_attach_contract VARCHAR2(1);
660: l_contract_template_id NUMBER;

Line 657: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;

653: l_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
654: l_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
655: l_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
656: l_payment_rec ASO_QUOTE_PUB.Payment_Rec_Type;
657: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
658: l_tax_detail_rec ASO_QUOTE_PUB.Tax_Detail_Rec_Type;
659: l_attach_contract VARCHAR2(1);
660: l_contract_template_id NUMBER;
661:

Line 658: l_tax_detail_rec ASO_QUOTE_PUB.Tax_Detail_Rec_Type;

654: l_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
655: l_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
656: l_payment_rec ASO_QUOTE_PUB.Payment_Rec_Type;
657: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
658: l_tax_detail_rec ASO_QUOTE_PUB.Tax_Detail_Rec_Type;
659: l_attach_contract VARCHAR2(1);
660: l_contract_template_id NUMBER;
661:
662: lx_quote_header_id NUMBER;

Line 1173: x_qte_header_rec IN OUT NOCOPY aso_quote_pub.Qte_Header_Rec_Type

1169: end Express_Buy_Order;
1170:
1171:
1172: Procedure get_express_items_settings(
1173: x_qte_header_rec IN OUT NOCOPY aso_quote_pub.Qte_Header_Rec_Type
1174: ,p_flag IN VARCHAR2
1175: ,x_payment_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type
1176: ,x_hd_shipment_tbl IN OUT NOCOPY ASO_Quote_Pub.Shipment_Tbl_Type
1177: ,x_hd_tax_dtl_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type) is

Line 1175: ,x_payment_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type

1171:
1172: Procedure get_express_items_settings(
1173: x_qte_header_rec IN OUT NOCOPY aso_quote_pub.Qte_Header_Rec_Type
1174: ,p_flag IN VARCHAR2
1175: ,x_payment_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type
1176: ,x_hd_shipment_tbl IN OUT NOCOPY ASO_Quote_Pub.Shipment_Tbl_Type
1177: ,x_hd_tax_dtl_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type) is
1178:
1179: CURSOR c_quote(c_party_id NUMBER, c_acct_id NUMBER) IS

Line 1176: ,x_hd_shipment_tbl IN OUT NOCOPY ASO_Quote_Pub.Shipment_Tbl_Type

1172: Procedure get_express_items_settings(
1173: x_qte_header_rec IN OUT NOCOPY aso_quote_pub.Qte_Header_Rec_Type
1174: ,p_flag IN VARCHAR2
1175: ,x_payment_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type
1176: ,x_hd_shipment_tbl IN OUT NOCOPY ASO_Quote_Pub.Shipment_Tbl_Type
1177: ,x_hd_tax_dtl_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type) is
1178:
1179: CURSOR c_quote(c_party_id NUMBER, c_acct_id NUMBER) IS
1180: SELECT quote_header_id, creation_date, currency_code

Line 1177: ,x_hd_tax_dtl_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type) is

1173: x_qte_header_rec IN OUT NOCOPY aso_quote_pub.Qte_Header_Rec_Type
1174: ,p_flag IN VARCHAR2
1175: ,x_payment_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type
1176: ,x_hd_shipment_tbl IN OUT NOCOPY ASO_Quote_Pub.Shipment_Tbl_Type
1177: ,x_hd_tax_dtl_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type) is
1178:
1179: CURSOR c_quote(c_party_id NUMBER, c_acct_id NUMBER) IS
1180: SELECT quote_header_id, creation_date, currency_code
1181: FROM aso_quote_headers

Line 1242: l_hd_shipment_tbl ASO_Quote_Pub.Shipment_Tbl_Type

1238: and subject_type = 'PERSON'
1239: and object_type = 'ORGANIZATION');
1240:
1241: l_true varchar2(10) := 'TRUE';
1242: l_hd_shipment_tbl ASO_Quote_Pub.Shipment_Tbl_Type
1243: := ASO_Quote_Pub.G_MISS_SHIPMENT_Tbl;
1244: l_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
1245: l_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
1246:

Line 1243: := ASO_Quote_Pub.G_MISS_SHIPMENT_Tbl;

1239: and object_type = 'ORGANIZATION');
1240:
1241: l_true varchar2(10) := 'TRUE';
1242: l_hd_shipment_tbl ASO_Quote_Pub.Shipment_Tbl_Type
1243: := ASO_Quote_Pub.G_MISS_SHIPMENT_Tbl;
1244: l_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
1245: l_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
1246:
1247: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;

Line 1244: l_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;

1240:
1241: l_true varchar2(10) := 'TRUE';
1242: l_hd_shipment_tbl ASO_Quote_Pub.Shipment_Tbl_Type
1243: := ASO_Quote_Pub.G_MISS_SHIPMENT_Tbl;
1244: l_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
1245: l_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
1246:
1247: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1248: l_push_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;

Line 1245: l_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;

1241: l_true varchar2(10) := 'TRUE';
1242: l_hd_shipment_tbl ASO_Quote_Pub.Shipment_Tbl_Type
1243: := ASO_Quote_Pub.G_MISS_SHIPMENT_Tbl;
1244: l_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
1245: l_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
1246:
1247: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1248: l_push_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1249: l_tax_detail_rec ASO_QUOTE_PUB.Tax_Detail_Rec_Type;

Line 1247: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;

1243: := ASO_Quote_Pub.G_MISS_SHIPMENT_Tbl;
1244: l_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
1245: l_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
1246:
1247: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1248: l_push_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1249: l_tax_detail_rec ASO_QUOTE_PUB.Tax_Detail_Rec_Type;
1250: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1251: l_payment_rec ASO_QUOTE_PUB.Payment_Rec_Type;

Line 1248: l_push_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;

1244: l_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
1245: l_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
1246:
1247: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1248: l_push_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1249: l_tax_detail_rec ASO_QUOTE_PUB.Tax_Detail_Rec_Type;
1250: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1251: l_payment_rec ASO_QUOTE_PUB.Payment_Rec_Type;
1252: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;

Line 1249: l_tax_detail_rec ASO_QUOTE_PUB.Tax_Detail_Rec_Type;

1245: l_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
1246:
1247: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1248: l_push_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1249: l_tax_detail_rec ASO_QUOTE_PUB.Tax_Detail_Rec_Type;
1250: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1251: l_payment_rec ASO_QUOTE_PUB.Payment_Rec_Type;
1252: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
1253:

Line 1250: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;

1246:
1247: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1248: l_push_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1249: l_tax_detail_rec ASO_QUOTE_PUB.Tax_Detail_Rec_Type;
1250: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1251: l_payment_rec ASO_QUOTE_PUB.Payment_Rec_Type;
1252: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
1253:
1254: l_curr_cart_id NUMBER := FND_API.g_miss_num;

Line 1251: l_payment_rec ASO_QUOTE_PUB.Payment_Rec_Type;

1247: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1248: l_push_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1249: l_tax_detail_rec ASO_QUOTE_PUB.Tax_Detail_Rec_Type;
1250: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1251: l_payment_rec ASO_QUOTE_PUB.Payment_Rec_Type;
1252: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
1253:
1254: l_curr_cart_id NUMBER := FND_API.g_miss_num;
1255: l_curr_cart_date DATE;

Line 1252: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;

1248: l_push_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1249: l_tax_detail_rec ASO_QUOTE_PUB.Tax_Detail_Rec_Type;
1250: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1251: l_payment_rec ASO_QUOTE_PUB.Payment_Rec_Type;
1252: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
1253:
1254: l_curr_cart_id NUMBER := FND_API.g_miss_num;
1255: l_curr_cart_date DATE;
1256: l_curr_cart_currcode VARCHAR2(10);