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 1166: x_qte_header_rec IN OUT NOCOPY aso_quote_pub.Qte_Header_Rec_Type

1162: end Express_Buy_Order;
1163:
1164:
1165: Procedure get_express_items_settings(
1166: x_qte_header_rec IN OUT NOCOPY aso_quote_pub.Qte_Header_Rec_Type
1167: ,p_flag IN VARCHAR2
1168: ,x_payment_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type
1169: ,x_hd_shipment_tbl IN OUT NOCOPY ASO_Quote_Pub.Shipment_Tbl_Type
1170: ,x_hd_tax_dtl_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type) is

Line 1168: ,x_payment_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type

1164:
1165: Procedure get_express_items_settings(
1166: x_qte_header_rec IN OUT NOCOPY aso_quote_pub.Qte_Header_Rec_Type
1167: ,p_flag IN VARCHAR2
1168: ,x_payment_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type
1169: ,x_hd_shipment_tbl IN OUT NOCOPY ASO_Quote_Pub.Shipment_Tbl_Type
1170: ,x_hd_tax_dtl_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type) is
1171:
1172: CURSOR c_quote(c_party_id NUMBER, c_acct_id NUMBER) IS

Line 1169: ,x_hd_shipment_tbl IN OUT NOCOPY ASO_Quote_Pub.Shipment_Tbl_Type

1165: Procedure get_express_items_settings(
1166: x_qte_header_rec IN OUT NOCOPY aso_quote_pub.Qte_Header_Rec_Type
1167: ,p_flag IN VARCHAR2
1168: ,x_payment_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type
1169: ,x_hd_shipment_tbl IN OUT NOCOPY ASO_Quote_Pub.Shipment_Tbl_Type
1170: ,x_hd_tax_dtl_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type) is
1171:
1172: CURSOR c_quote(c_party_id NUMBER, c_acct_id NUMBER) IS
1173: SELECT quote_header_id, creation_date, currency_code

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

1166: x_qte_header_rec IN OUT NOCOPY aso_quote_pub.Qte_Header_Rec_Type
1167: ,p_flag IN VARCHAR2
1168: ,x_payment_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type
1169: ,x_hd_shipment_tbl IN OUT NOCOPY ASO_Quote_Pub.Shipment_Tbl_Type
1170: ,x_hd_tax_dtl_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type) is
1171:
1172: CURSOR c_quote(c_party_id NUMBER, c_acct_id NUMBER) IS
1173: SELECT quote_header_id, creation_date, currency_code
1174: FROM aso_quote_headers

Line 1235: l_hd_shipment_tbl ASO_Quote_Pub.Shipment_Tbl_Type

1231: and subject_type = 'PERSON'
1232: and object_type = 'ORGANIZATION');
1233:
1234: l_true varchar2(10) := 'TRUE';
1235: l_hd_shipment_tbl ASO_Quote_Pub.Shipment_Tbl_Type
1236: := ASO_Quote_Pub.G_MISS_SHIPMENT_Tbl;
1237: l_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
1238: l_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
1239:

Line 1236: := ASO_Quote_Pub.G_MISS_SHIPMENT_Tbl;

1232: and object_type = 'ORGANIZATION');
1233:
1234: l_true varchar2(10) := 'TRUE';
1235: l_hd_shipment_tbl ASO_Quote_Pub.Shipment_Tbl_Type
1236: := ASO_Quote_Pub.G_MISS_SHIPMENT_Tbl;
1237: l_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
1238: l_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
1239:
1240: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;

Line 1237: l_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;

1233:
1234: l_true varchar2(10) := 'TRUE';
1235: l_hd_shipment_tbl ASO_Quote_Pub.Shipment_Tbl_Type
1236: := ASO_Quote_Pub.G_MISS_SHIPMENT_Tbl;
1237: l_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
1238: l_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
1239:
1240: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1241: l_push_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;

Line 1238: l_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;

1234: l_true varchar2(10) := 'TRUE';
1235: l_hd_shipment_tbl ASO_Quote_Pub.Shipment_Tbl_Type
1236: := ASO_Quote_Pub.G_MISS_SHIPMENT_Tbl;
1237: l_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
1238: l_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
1239:
1240: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1241: l_push_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1242: l_tax_detail_rec ASO_QUOTE_PUB.Tax_Detail_Rec_Type;

Line 1240: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;

1236: := ASO_Quote_Pub.G_MISS_SHIPMENT_Tbl;
1237: l_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
1238: l_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
1239:
1240: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1241: l_push_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1242: l_tax_detail_rec ASO_QUOTE_PUB.Tax_Detail_Rec_Type;
1243: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1244: l_payment_rec ASO_QUOTE_PUB.Payment_Rec_Type;

Line 1241: l_push_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;

1237: l_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
1238: l_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
1239:
1240: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1241: l_push_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1242: l_tax_detail_rec ASO_QUOTE_PUB.Tax_Detail_Rec_Type;
1243: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1244: l_payment_rec ASO_QUOTE_PUB.Payment_Rec_Type;
1245: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;

Line 1242: l_tax_detail_rec ASO_QUOTE_PUB.Tax_Detail_Rec_Type;

1238: l_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
1239:
1240: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1241: l_push_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1242: l_tax_detail_rec ASO_QUOTE_PUB.Tax_Detail_Rec_Type;
1243: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1244: l_payment_rec ASO_QUOTE_PUB.Payment_Rec_Type;
1245: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
1246:

Line 1243: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;

1239:
1240: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1241: l_push_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1242: l_tax_detail_rec ASO_QUOTE_PUB.Tax_Detail_Rec_Type;
1243: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1244: l_payment_rec ASO_QUOTE_PUB.Payment_Rec_Type;
1245: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
1246:
1247: l_curr_cart_id NUMBER := FND_API.g_miss_num;

Line 1244: l_payment_rec ASO_QUOTE_PUB.Payment_Rec_Type;

1240: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1241: l_push_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1242: l_tax_detail_rec ASO_QUOTE_PUB.Tax_Detail_Rec_Type;
1243: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1244: l_payment_rec ASO_QUOTE_PUB.Payment_Rec_Type;
1245: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
1246:
1247: l_curr_cart_id NUMBER := FND_API.g_miss_num;
1248: l_curr_cart_date DATE;

Line 1245: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;

1241: l_push_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1242: l_tax_detail_rec ASO_QUOTE_PUB.Tax_Detail_Rec_Type;
1243: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1244: l_payment_rec ASO_QUOTE_PUB.Payment_Rec_Type;
1245: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
1246:
1247: l_curr_cart_id NUMBER := FND_API.g_miss_num;
1248: l_curr_cart_date DATE;
1249: l_curr_cart_currcode VARCHAR2(10);