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_IBY_FINANCING_PVT dependencies on ASO_QUOTE_PUB

Line 34: l_related_obj_rec aso_quote_pub.related_obj_rec_type;

30: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
31: ) IS
32: l_api_version NUMBER := 1.0;
33: l_api_name VARCHAR2 (50) := 'Update_Status';
34: l_related_obj_rec aso_quote_pub.related_obj_rec_type;
35: l_related_obj_id NUMBER;
36: l_control_rec aso_quote_pub.control_rec_type;
37: l_first_time_pending BOOLEAN := FALSE;
38: l_current_status_code VARCHAR2 (30);

Line 36: l_control_rec aso_quote_pub.control_rec_type;

32: l_api_version NUMBER := 1.0;
33: l_api_name VARCHAR2 (50) := 'Update_Status';
34: l_related_obj_rec aso_quote_pub.related_obj_rec_type;
35: l_related_obj_id NUMBER;
36: l_control_rec aso_quote_pub.control_rec_type;
37: l_first_time_pending BOOLEAN := FALSE;
38: l_current_status_code VARCHAR2 (30);
39: l_quote_status_id NUMBER;
40: l_quote_header_id NUMBER := p_tangible_id;

Line 44: l_qte_header_rec aso_quote_pub.qte_header_rec_type

40: l_quote_header_id NUMBER := p_tangible_id;
41: l_credit_app_id NUMBER;
42: l_qte_source_code VARCHAR2 (240);
43: l_qte_resource_id NUMBER;
44: l_qte_header_rec aso_quote_pub.qte_header_rec_type
45: := aso_quote_pub.g_miss_qte_header_rec;
46: lx_qte_header_rec aso_quote_pub.qte_header_rec_type;
47: lx_qte_line_tbl aso_quote_pub.qte_line_tbl_type;
48: lx_qte_line_dtl_tbl aso_quote_pub.qte_line_dtl_tbl_type;

Line 45: := aso_quote_pub.g_miss_qte_header_rec;

41: l_credit_app_id NUMBER;
42: l_qte_source_code VARCHAR2 (240);
43: l_qte_resource_id NUMBER;
44: l_qte_header_rec aso_quote_pub.qte_header_rec_type
45: := aso_quote_pub.g_miss_qte_header_rec;
46: lx_qte_header_rec aso_quote_pub.qte_header_rec_type;
47: lx_qte_line_tbl aso_quote_pub.qte_line_tbl_type;
48: lx_qte_line_dtl_tbl aso_quote_pub.qte_line_dtl_tbl_type;
49: lx_hd_price_attr_tbl aso_quote_pub.price_attributes_tbl_type;

Line 46: lx_qte_header_rec aso_quote_pub.qte_header_rec_type;

42: l_qte_source_code VARCHAR2 (240);
43: l_qte_resource_id NUMBER;
44: l_qte_header_rec aso_quote_pub.qte_header_rec_type
45: := aso_quote_pub.g_miss_qte_header_rec;
46: lx_qte_header_rec aso_quote_pub.qte_header_rec_type;
47: lx_qte_line_tbl aso_quote_pub.qte_line_tbl_type;
48: lx_qte_line_dtl_tbl aso_quote_pub.qte_line_dtl_tbl_type;
49: lx_hd_price_attr_tbl aso_quote_pub.price_attributes_tbl_type;
50: lx_hd_payment_tbl aso_quote_pub.payment_tbl_type;

Line 47: lx_qte_line_tbl aso_quote_pub.qte_line_tbl_type;

43: l_qte_resource_id NUMBER;
44: l_qte_header_rec aso_quote_pub.qte_header_rec_type
45: := aso_quote_pub.g_miss_qte_header_rec;
46: lx_qte_header_rec aso_quote_pub.qte_header_rec_type;
47: lx_qte_line_tbl aso_quote_pub.qte_line_tbl_type;
48: lx_qte_line_dtl_tbl aso_quote_pub.qte_line_dtl_tbl_type;
49: lx_hd_price_attr_tbl aso_quote_pub.price_attributes_tbl_type;
50: lx_hd_payment_tbl aso_quote_pub.payment_tbl_type;
51: lx_hd_shipment_rec aso_quote_pub.shipment_rec_type;

Line 48: lx_qte_line_dtl_tbl aso_quote_pub.qte_line_dtl_tbl_type;

44: l_qte_header_rec aso_quote_pub.qte_header_rec_type
45: := aso_quote_pub.g_miss_qte_header_rec;
46: lx_qte_header_rec aso_quote_pub.qte_header_rec_type;
47: lx_qte_line_tbl aso_quote_pub.qte_line_tbl_type;
48: lx_qte_line_dtl_tbl aso_quote_pub.qte_line_dtl_tbl_type;
49: lx_hd_price_attr_tbl aso_quote_pub.price_attributes_tbl_type;
50: lx_hd_payment_tbl aso_quote_pub.payment_tbl_type;
51: lx_hd_shipment_rec aso_quote_pub.shipment_rec_type;
52: lx_hd_shipment_tbl aso_quote_pub.shipment_tbl_type;

Line 49: lx_hd_price_attr_tbl aso_quote_pub.price_attributes_tbl_type;

45: := aso_quote_pub.g_miss_qte_header_rec;
46: lx_qte_header_rec aso_quote_pub.qte_header_rec_type;
47: lx_qte_line_tbl aso_quote_pub.qte_line_tbl_type;
48: lx_qte_line_dtl_tbl aso_quote_pub.qte_line_dtl_tbl_type;
49: lx_hd_price_attr_tbl aso_quote_pub.price_attributes_tbl_type;
50: lx_hd_payment_tbl aso_quote_pub.payment_tbl_type;
51: lx_hd_shipment_rec aso_quote_pub.shipment_rec_type;
52: lx_hd_shipment_tbl aso_quote_pub.shipment_tbl_type;
53: lx_hd_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;

Line 50: lx_hd_payment_tbl aso_quote_pub.payment_tbl_type;

46: lx_qte_header_rec aso_quote_pub.qte_header_rec_type;
47: lx_qte_line_tbl aso_quote_pub.qte_line_tbl_type;
48: lx_qte_line_dtl_tbl aso_quote_pub.qte_line_dtl_tbl_type;
49: lx_hd_price_attr_tbl aso_quote_pub.price_attributes_tbl_type;
50: lx_hd_payment_tbl aso_quote_pub.payment_tbl_type;
51: lx_hd_shipment_rec aso_quote_pub.shipment_rec_type;
52: lx_hd_shipment_tbl aso_quote_pub.shipment_tbl_type;
53: lx_hd_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
54: lx_hd_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;

Line 51: lx_hd_shipment_rec aso_quote_pub.shipment_rec_type;

47: lx_qte_line_tbl aso_quote_pub.qte_line_tbl_type;
48: lx_qte_line_dtl_tbl aso_quote_pub.qte_line_dtl_tbl_type;
49: lx_hd_price_attr_tbl aso_quote_pub.price_attributes_tbl_type;
50: lx_hd_payment_tbl aso_quote_pub.payment_tbl_type;
51: lx_hd_shipment_rec aso_quote_pub.shipment_rec_type;
52: lx_hd_shipment_tbl aso_quote_pub.shipment_tbl_type;
53: lx_hd_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
54: lx_hd_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
55: lx_line_attr_ext_tbl aso_quote_pub.line_attribs_ext_tbl_type;

Line 52: lx_hd_shipment_tbl aso_quote_pub.shipment_tbl_type;

48: lx_qte_line_dtl_tbl aso_quote_pub.qte_line_dtl_tbl_type;
49: lx_hd_price_attr_tbl aso_quote_pub.price_attributes_tbl_type;
50: lx_hd_payment_tbl aso_quote_pub.payment_tbl_type;
51: lx_hd_shipment_rec aso_quote_pub.shipment_rec_type;
52: lx_hd_shipment_tbl aso_quote_pub.shipment_tbl_type;
53: lx_hd_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
54: lx_hd_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
55: lx_line_attr_ext_tbl aso_quote_pub.line_attribs_ext_tbl_type;
56: lx_line_rltship_tbl aso_quote_pub.line_rltship_tbl_type;

Line 53: lx_hd_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;

49: lx_hd_price_attr_tbl aso_quote_pub.price_attributes_tbl_type;
50: lx_hd_payment_tbl aso_quote_pub.payment_tbl_type;
51: lx_hd_shipment_rec aso_quote_pub.shipment_rec_type;
52: lx_hd_shipment_tbl aso_quote_pub.shipment_tbl_type;
53: lx_hd_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
54: lx_hd_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
55: lx_line_attr_ext_tbl aso_quote_pub.line_attribs_ext_tbl_type;
56: lx_line_rltship_tbl aso_quote_pub.line_rltship_tbl_type;
57: lx_price_adjustment_tbl aso_quote_pub.price_adj_tbl_type;

Line 54: lx_hd_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;

50: lx_hd_payment_tbl aso_quote_pub.payment_tbl_type;
51: lx_hd_shipment_rec aso_quote_pub.shipment_rec_type;
52: lx_hd_shipment_tbl aso_quote_pub.shipment_tbl_type;
53: lx_hd_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
54: lx_hd_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
55: lx_line_attr_ext_tbl aso_quote_pub.line_attribs_ext_tbl_type;
56: lx_line_rltship_tbl aso_quote_pub.line_rltship_tbl_type;
57: lx_price_adjustment_tbl aso_quote_pub.price_adj_tbl_type;
58: lx_price_adj_attr_tbl aso_quote_pub.price_adj_attr_tbl_type;

Line 55: lx_line_attr_ext_tbl aso_quote_pub.line_attribs_ext_tbl_type;

51: lx_hd_shipment_rec aso_quote_pub.shipment_rec_type;
52: lx_hd_shipment_tbl aso_quote_pub.shipment_tbl_type;
53: lx_hd_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
54: lx_hd_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
55: lx_line_attr_ext_tbl aso_quote_pub.line_attribs_ext_tbl_type;
56: lx_line_rltship_tbl aso_quote_pub.line_rltship_tbl_type;
57: lx_price_adjustment_tbl aso_quote_pub.price_adj_tbl_type;
58: lx_price_adj_attr_tbl aso_quote_pub.price_adj_attr_tbl_type;
59: lx_price_adj_rltship_tbl aso_quote_pub.price_adj_rltship_tbl_type;

Line 56: lx_line_rltship_tbl aso_quote_pub.line_rltship_tbl_type;

52: lx_hd_shipment_tbl aso_quote_pub.shipment_tbl_type;
53: lx_hd_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
54: lx_hd_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
55: lx_line_attr_ext_tbl aso_quote_pub.line_attribs_ext_tbl_type;
56: lx_line_rltship_tbl aso_quote_pub.line_rltship_tbl_type;
57: lx_price_adjustment_tbl aso_quote_pub.price_adj_tbl_type;
58: lx_price_adj_attr_tbl aso_quote_pub.price_adj_attr_tbl_type;
59: lx_price_adj_rltship_tbl aso_quote_pub.price_adj_rltship_tbl_type;
60: lx_ln_price_attr_tbl aso_quote_pub.price_attributes_tbl_type;

Line 57: lx_price_adjustment_tbl aso_quote_pub.price_adj_tbl_type;

53: lx_hd_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
54: lx_hd_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
55: lx_line_attr_ext_tbl aso_quote_pub.line_attribs_ext_tbl_type;
56: lx_line_rltship_tbl aso_quote_pub.line_rltship_tbl_type;
57: lx_price_adjustment_tbl aso_quote_pub.price_adj_tbl_type;
58: lx_price_adj_attr_tbl aso_quote_pub.price_adj_attr_tbl_type;
59: lx_price_adj_rltship_tbl aso_quote_pub.price_adj_rltship_tbl_type;
60: lx_ln_price_attr_tbl aso_quote_pub.price_attributes_tbl_type;
61: lx_ln_payment_tbl aso_quote_pub.payment_tbl_type;

Line 58: lx_price_adj_attr_tbl aso_quote_pub.price_adj_attr_tbl_type;

54: lx_hd_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
55: lx_line_attr_ext_tbl aso_quote_pub.line_attribs_ext_tbl_type;
56: lx_line_rltship_tbl aso_quote_pub.line_rltship_tbl_type;
57: lx_price_adjustment_tbl aso_quote_pub.price_adj_tbl_type;
58: lx_price_adj_attr_tbl aso_quote_pub.price_adj_attr_tbl_type;
59: lx_price_adj_rltship_tbl aso_quote_pub.price_adj_rltship_tbl_type;
60: lx_ln_price_attr_tbl aso_quote_pub.price_attributes_tbl_type;
61: lx_ln_payment_tbl aso_quote_pub.payment_tbl_type;
62: lx_ln_shipment_tbl aso_quote_pub.shipment_tbl_type;

Line 59: lx_price_adj_rltship_tbl aso_quote_pub.price_adj_rltship_tbl_type;

55: lx_line_attr_ext_tbl aso_quote_pub.line_attribs_ext_tbl_type;
56: lx_line_rltship_tbl aso_quote_pub.line_rltship_tbl_type;
57: lx_price_adjustment_tbl aso_quote_pub.price_adj_tbl_type;
58: lx_price_adj_attr_tbl aso_quote_pub.price_adj_attr_tbl_type;
59: lx_price_adj_rltship_tbl aso_quote_pub.price_adj_rltship_tbl_type;
60: lx_ln_price_attr_tbl aso_quote_pub.price_attributes_tbl_type;
61: lx_ln_payment_tbl aso_quote_pub.payment_tbl_type;
62: lx_ln_shipment_tbl aso_quote_pub.shipment_tbl_type;
63: lx_ln_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;

Line 60: lx_ln_price_attr_tbl aso_quote_pub.price_attributes_tbl_type;

56: lx_line_rltship_tbl aso_quote_pub.line_rltship_tbl_type;
57: lx_price_adjustment_tbl aso_quote_pub.price_adj_tbl_type;
58: lx_price_adj_attr_tbl aso_quote_pub.price_adj_attr_tbl_type;
59: lx_price_adj_rltship_tbl aso_quote_pub.price_adj_rltship_tbl_type;
60: lx_ln_price_attr_tbl aso_quote_pub.price_attributes_tbl_type;
61: lx_ln_payment_tbl aso_quote_pub.payment_tbl_type;
62: lx_ln_shipment_tbl aso_quote_pub.shipment_tbl_type;
63: lx_ln_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
64: lx_ln_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;

Line 61: lx_ln_payment_tbl aso_quote_pub.payment_tbl_type;

57: lx_price_adjustment_tbl aso_quote_pub.price_adj_tbl_type;
58: lx_price_adj_attr_tbl aso_quote_pub.price_adj_attr_tbl_type;
59: lx_price_adj_rltship_tbl aso_quote_pub.price_adj_rltship_tbl_type;
60: lx_ln_price_attr_tbl aso_quote_pub.price_attributes_tbl_type;
61: lx_ln_payment_tbl aso_quote_pub.payment_tbl_type;
62: lx_ln_shipment_tbl aso_quote_pub.shipment_tbl_type;
63: lx_ln_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
64: lx_ln_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
65:

Line 62: lx_ln_shipment_tbl aso_quote_pub.shipment_tbl_type;

58: lx_price_adj_attr_tbl aso_quote_pub.price_adj_attr_tbl_type;
59: lx_price_adj_rltship_tbl aso_quote_pub.price_adj_rltship_tbl_type;
60: lx_ln_price_attr_tbl aso_quote_pub.price_attributes_tbl_type;
61: lx_ln_payment_tbl aso_quote_pub.payment_tbl_type;
62: lx_ln_shipment_tbl aso_quote_pub.shipment_tbl_type;
63: lx_ln_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
64: lx_ln_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
65:
66: CURSOR c_financing_id (

Line 63: lx_ln_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;

59: lx_price_adj_rltship_tbl aso_quote_pub.price_adj_rltship_tbl_type;
60: lx_ln_price_attr_tbl aso_quote_pub.price_attributes_tbl_type;
61: lx_ln_payment_tbl aso_quote_pub.payment_tbl_type;
62: lx_ln_shipment_tbl aso_quote_pub.shipment_tbl_type;
63: lx_ln_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
64: lx_ln_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
65:
66: CURSOR c_financing_id (
67: lc_qte_header_id NUMBER

Line 64: lx_ln_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;

60: lx_ln_price_attr_tbl aso_quote_pub.price_attributes_tbl_type;
61: lx_ln_payment_tbl aso_quote_pub.payment_tbl_type;
62: lx_ln_shipment_tbl aso_quote_pub.shipment_tbl_type;
63: lx_ln_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
64: lx_ln_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
65:
66: CURSOR c_financing_id (
67: lc_qte_header_id NUMBER
68: ) IS

Line 481: l_control_rec := aso_quote_pub.g_miss_control_rec;

477:
478: IF l_qte_header_rec.quote_status_id <> l_quote_status_id
479: THEN
480: l_qte_header_rec.quote_header_id := l_quote_header_id;
481: l_control_rec := aso_quote_pub.g_miss_control_rec;
482: l_control_rec.auto_version_flag := fnd_api.g_true;
483: aso_quote_pub.update_quote (
484: p_api_version_number => 1.0,
485: p_init_msg_list => fnd_api.g_false,

Line 483: aso_quote_pub.update_quote (

479: THEN
480: l_qte_header_rec.quote_header_id := l_quote_header_id;
481: l_control_rec := aso_quote_pub.g_miss_control_rec;
482: l_control_rec.auto_version_flag := fnd_api.g_true;
483: aso_quote_pub.update_quote (
484: p_api_version_number => 1.0,
485: p_init_msg_list => fnd_api.g_false,
486: p_commit => fnd_api.g_false,
487: p_qte_header_rec => l_qte_header_rec,