DBA Data[Home] [Help]

APPS.AMS_EVENTOFFER_PVT dependencies on QP_PRICE_LIST_PUB

Line 5814: p_price_list_rec qp_price_list_pub.price_list_rec_type;

5810: l_return_status VARCHAR2(1);
5811: l_msg_count NUMBER;
5812: l_msg_data VARCHAR2(2000);
5813:
5814: p_price_list_rec qp_price_list_pub.price_list_rec_type;
5815: p_price_list_val_rec qp_price_list_pub.price_list_val_rec_type;
5816: p_price_list_line_tbl qp_price_list_pub.price_list_line_tbl_type;
5817: p_price_list_line_val_tbl qp_price_list_pub.price_list_line_val_tbl_type;
5818: p_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;

Line 5815: p_price_list_val_rec qp_price_list_pub.price_list_val_rec_type;

5811: l_msg_count NUMBER;
5812: l_msg_data VARCHAR2(2000);
5813:
5814: p_price_list_rec qp_price_list_pub.price_list_rec_type;
5815: p_price_list_val_rec qp_price_list_pub.price_list_val_rec_type;
5816: p_price_list_line_tbl qp_price_list_pub.price_list_line_tbl_type;
5817: p_price_list_line_val_tbl qp_price_list_pub.price_list_line_val_tbl_type;
5818: p_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
5819: p_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;

Line 5816: p_price_list_line_tbl qp_price_list_pub.price_list_line_tbl_type;

5812: l_msg_data VARCHAR2(2000);
5813:
5814: p_price_list_rec qp_price_list_pub.price_list_rec_type;
5815: p_price_list_val_rec qp_price_list_pub.price_list_val_rec_type;
5816: p_price_list_line_tbl qp_price_list_pub.price_list_line_tbl_type;
5817: p_price_list_line_val_tbl qp_price_list_pub.price_list_line_val_tbl_type;
5818: p_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
5819: p_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
5820: p_pricing_attr_tbl qp_price_list_pub.pricing_attr_tbl_type;

Line 5817: p_price_list_line_val_tbl qp_price_list_pub.price_list_line_val_tbl_type;

5813:
5814: p_price_list_rec qp_price_list_pub.price_list_rec_type;
5815: p_price_list_val_rec qp_price_list_pub.price_list_val_rec_type;
5816: p_price_list_line_tbl qp_price_list_pub.price_list_line_tbl_type;
5817: p_price_list_line_val_tbl qp_price_list_pub.price_list_line_val_tbl_type;
5818: p_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
5819: p_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
5820: p_pricing_attr_tbl qp_price_list_pub.pricing_attr_tbl_type;
5821: p_pricing_attr_val_tbl qp_price_list_pub.pricing_attr_val_tbl_type;

Line 5820: p_pricing_attr_tbl qp_price_list_pub.pricing_attr_tbl_type;

5816: p_price_list_line_tbl qp_price_list_pub.price_list_line_tbl_type;
5817: p_price_list_line_val_tbl qp_price_list_pub.price_list_line_val_tbl_type;
5818: p_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
5819: p_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
5820: p_pricing_attr_tbl qp_price_list_pub.pricing_attr_tbl_type;
5821: p_pricing_attr_val_tbl qp_price_list_pub.pricing_attr_val_tbl_type;
5822:
5823: l_price_list_rec qp_price_list_pub.price_list_rec_type;
5824: l_price_list_val_rec qp_price_list_pub.price_list_val_rec_type;

Line 5821: p_pricing_attr_val_tbl qp_price_list_pub.pricing_attr_val_tbl_type;

5817: p_price_list_line_val_tbl qp_price_list_pub.price_list_line_val_tbl_type;
5818: p_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
5819: p_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
5820: p_pricing_attr_tbl qp_price_list_pub.pricing_attr_tbl_type;
5821: p_pricing_attr_val_tbl qp_price_list_pub.pricing_attr_val_tbl_type;
5822:
5823: l_price_list_rec qp_price_list_pub.price_list_rec_type;
5824: l_price_list_val_rec qp_price_list_pub.price_list_val_rec_type;
5825: l_price_list_line_tbl qp_price_list_pub.price_list_line_tbl_type;

Line 5823: l_price_list_rec qp_price_list_pub.price_list_rec_type;

5819: p_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
5820: p_pricing_attr_tbl qp_price_list_pub.pricing_attr_tbl_type;
5821: p_pricing_attr_val_tbl qp_price_list_pub.pricing_attr_val_tbl_type;
5822:
5823: l_price_list_rec qp_price_list_pub.price_list_rec_type;
5824: l_price_list_val_rec qp_price_list_pub.price_list_val_rec_type;
5825: l_price_list_line_tbl qp_price_list_pub.price_list_line_tbl_type;
5826: l_price_list_line_val_tbl qp_price_list_pub.price_list_line_val_tbl_type;
5827: l_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;

Line 5824: l_price_list_val_rec qp_price_list_pub.price_list_val_rec_type;

5820: p_pricing_attr_tbl qp_price_list_pub.pricing_attr_tbl_type;
5821: p_pricing_attr_val_tbl qp_price_list_pub.pricing_attr_val_tbl_type;
5822:
5823: l_price_list_rec qp_price_list_pub.price_list_rec_type;
5824: l_price_list_val_rec qp_price_list_pub.price_list_val_rec_type;
5825: l_price_list_line_tbl qp_price_list_pub.price_list_line_tbl_type;
5826: l_price_list_line_val_tbl qp_price_list_pub.price_list_line_val_tbl_type;
5827: l_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
5828: l_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;

Line 5825: l_price_list_line_tbl qp_price_list_pub.price_list_line_tbl_type;

5821: p_pricing_attr_val_tbl qp_price_list_pub.pricing_attr_val_tbl_type;
5822:
5823: l_price_list_rec qp_price_list_pub.price_list_rec_type;
5824: l_price_list_val_rec qp_price_list_pub.price_list_val_rec_type;
5825: l_price_list_line_tbl qp_price_list_pub.price_list_line_tbl_type;
5826: l_price_list_line_val_tbl qp_price_list_pub.price_list_line_val_tbl_type;
5827: l_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
5828: l_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
5829: l_pricing_attr_tbl qp_price_list_pub.pricing_attr_tbl_type;

Line 5826: l_price_list_line_val_tbl qp_price_list_pub.price_list_line_val_tbl_type;

5822:
5823: l_price_list_rec qp_price_list_pub.price_list_rec_type;
5824: l_price_list_val_rec qp_price_list_pub.price_list_val_rec_type;
5825: l_price_list_line_tbl qp_price_list_pub.price_list_line_tbl_type;
5826: l_price_list_line_val_tbl qp_price_list_pub.price_list_line_val_tbl_type;
5827: l_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
5828: l_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
5829: l_pricing_attr_tbl qp_price_list_pub.pricing_attr_tbl_type;
5830: l_pricing_attr_val_tbl qp_price_list_pub.pricing_attr_val_tbl_type;

Line 5829: l_pricing_attr_tbl qp_price_list_pub.pricing_attr_tbl_type;

5825: l_price_list_line_tbl qp_price_list_pub.price_list_line_tbl_type;
5826: l_price_list_line_val_tbl qp_price_list_pub.price_list_line_val_tbl_type;
5827: l_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
5828: l_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
5829: l_pricing_attr_tbl qp_price_list_pub.pricing_attr_tbl_type;
5830: l_pricing_attr_val_tbl qp_price_list_pub.pricing_attr_val_tbl_type;
5831:
5832: BEGIN
5833:

Line 5830: l_pricing_attr_val_tbl qp_price_list_pub.pricing_attr_val_tbl_type;

5826: l_price_list_line_val_tbl qp_price_list_pub.price_list_line_val_tbl_type;
5827: l_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
5828: l_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
5829: l_pricing_attr_tbl qp_price_list_pub.pricing_attr_tbl_type;
5830: l_pricing_attr_val_tbl qp_price_list_pub.pricing_attr_val_tbl_type;
5831:
5832: BEGIN
5833:
5834: -- dbms_output.put_line('create List header called');

Line 5863: QP_PRICE_LIST_PUB.Process_Price_List(

5859:
5860:
5861: END IF;
5862:
5863: QP_PRICE_LIST_PUB.Process_Price_List(
5864: p_api_version_number => 1.0,
5865: p_init_msg_list => FND_API.G_TRUE,
5866: p_return_values => FND_API.G_TRUE,
5867: p_commit => FND_API.G_TRUE,

Line 5964: p_price_list_rec qp_price_list_pub.price_list_rec_type;

5960: l_return_status VARCHAR2(1);
5961: l_msg_count NUMBER;
5962: l_msg_data VARCHAR2(2000);
5963:
5964: p_price_list_rec qp_price_list_pub.price_list_rec_type;
5965: p_price_list_val_rec qp_price_list_pub.price_list_val_rec_type;
5966: p_price_list_line_tbl qp_price_list_pub.price_list_line_tbl_type;
5967: p_price_list_line_val_tbl qp_price_list_pub.price_list_line_val_tbl_type;
5968: p_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;

Line 5965: p_price_list_val_rec qp_price_list_pub.price_list_val_rec_type;

5961: l_msg_count NUMBER;
5962: l_msg_data VARCHAR2(2000);
5963:
5964: p_price_list_rec qp_price_list_pub.price_list_rec_type;
5965: p_price_list_val_rec qp_price_list_pub.price_list_val_rec_type;
5966: p_price_list_line_tbl qp_price_list_pub.price_list_line_tbl_type;
5967: p_price_list_line_val_tbl qp_price_list_pub.price_list_line_val_tbl_type;
5968: p_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
5969: p_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;

Line 5966: p_price_list_line_tbl qp_price_list_pub.price_list_line_tbl_type;

5962: l_msg_data VARCHAR2(2000);
5963:
5964: p_price_list_rec qp_price_list_pub.price_list_rec_type;
5965: p_price_list_val_rec qp_price_list_pub.price_list_val_rec_type;
5966: p_price_list_line_tbl qp_price_list_pub.price_list_line_tbl_type;
5967: p_price_list_line_val_tbl qp_price_list_pub.price_list_line_val_tbl_type;
5968: p_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
5969: p_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
5970: p_pricing_attr_tbl qp_price_list_pub.pricing_attr_tbl_type;

Line 5967: p_price_list_line_val_tbl qp_price_list_pub.price_list_line_val_tbl_type;

5963:
5964: p_price_list_rec qp_price_list_pub.price_list_rec_type;
5965: p_price_list_val_rec qp_price_list_pub.price_list_val_rec_type;
5966: p_price_list_line_tbl qp_price_list_pub.price_list_line_tbl_type;
5967: p_price_list_line_val_tbl qp_price_list_pub.price_list_line_val_tbl_type;
5968: p_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
5969: p_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
5970: p_pricing_attr_tbl qp_price_list_pub.pricing_attr_tbl_type;
5971: p_pricing_attr_val_tbl qp_price_list_pub.pricing_attr_val_tbl_type;

Line 5970: p_pricing_attr_tbl qp_price_list_pub.pricing_attr_tbl_type;

5966: p_price_list_line_tbl qp_price_list_pub.price_list_line_tbl_type;
5967: p_price_list_line_val_tbl qp_price_list_pub.price_list_line_val_tbl_type;
5968: p_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
5969: p_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
5970: p_pricing_attr_tbl qp_price_list_pub.pricing_attr_tbl_type;
5971: p_pricing_attr_val_tbl qp_price_list_pub.pricing_attr_val_tbl_type;
5972:
5973: l_price_list_rec qp_price_list_pub.price_list_rec_type;
5974: l_price_list_val_rec qp_price_list_pub.price_list_val_rec_type;

Line 5971: p_pricing_attr_val_tbl qp_price_list_pub.pricing_attr_val_tbl_type;

5967: p_price_list_line_val_tbl qp_price_list_pub.price_list_line_val_tbl_type;
5968: p_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
5969: p_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
5970: p_pricing_attr_tbl qp_price_list_pub.pricing_attr_tbl_type;
5971: p_pricing_attr_val_tbl qp_price_list_pub.pricing_attr_val_tbl_type;
5972:
5973: l_price_list_rec qp_price_list_pub.price_list_rec_type;
5974: l_price_list_val_rec qp_price_list_pub.price_list_val_rec_type;
5975: l_price_list_line_tbl qp_price_list_pub.price_list_line_tbl_type;

Line 5973: l_price_list_rec qp_price_list_pub.price_list_rec_type;

5969: p_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
5970: p_pricing_attr_tbl qp_price_list_pub.pricing_attr_tbl_type;
5971: p_pricing_attr_val_tbl qp_price_list_pub.pricing_attr_val_tbl_type;
5972:
5973: l_price_list_rec qp_price_list_pub.price_list_rec_type;
5974: l_price_list_val_rec qp_price_list_pub.price_list_val_rec_type;
5975: l_price_list_line_tbl qp_price_list_pub.price_list_line_tbl_type;
5976: l_price_list_line_val_tbl qp_price_list_pub.price_list_line_val_tbl_type;
5977: l_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;

Line 5974: l_price_list_val_rec qp_price_list_pub.price_list_val_rec_type;

5970: p_pricing_attr_tbl qp_price_list_pub.pricing_attr_tbl_type;
5971: p_pricing_attr_val_tbl qp_price_list_pub.pricing_attr_val_tbl_type;
5972:
5973: l_price_list_rec qp_price_list_pub.price_list_rec_type;
5974: l_price_list_val_rec qp_price_list_pub.price_list_val_rec_type;
5975: l_price_list_line_tbl qp_price_list_pub.price_list_line_tbl_type;
5976: l_price_list_line_val_tbl qp_price_list_pub.price_list_line_val_tbl_type;
5977: l_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
5978: l_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;

Line 5975: l_price_list_line_tbl qp_price_list_pub.price_list_line_tbl_type;

5971: p_pricing_attr_val_tbl qp_price_list_pub.pricing_attr_val_tbl_type;
5972:
5973: l_price_list_rec qp_price_list_pub.price_list_rec_type;
5974: l_price_list_val_rec qp_price_list_pub.price_list_val_rec_type;
5975: l_price_list_line_tbl qp_price_list_pub.price_list_line_tbl_type;
5976: l_price_list_line_val_tbl qp_price_list_pub.price_list_line_val_tbl_type;
5977: l_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
5978: l_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
5979: l_pricing_attr_tbl qp_price_list_pub.pricing_attr_tbl_type;

Line 5976: l_price_list_line_val_tbl qp_price_list_pub.price_list_line_val_tbl_type;

5972:
5973: l_price_list_rec qp_price_list_pub.price_list_rec_type;
5974: l_price_list_val_rec qp_price_list_pub.price_list_val_rec_type;
5975: l_price_list_line_tbl qp_price_list_pub.price_list_line_tbl_type;
5976: l_price_list_line_val_tbl qp_price_list_pub.price_list_line_val_tbl_type;
5977: l_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
5978: l_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
5979: l_pricing_attr_tbl qp_price_list_pub.pricing_attr_tbl_type;
5980: l_pricing_attr_val_tbl qp_price_list_pub.pricing_attr_val_tbl_type;

Line 5979: l_pricing_attr_tbl qp_price_list_pub.pricing_attr_tbl_type;

5975: l_price_list_line_tbl qp_price_list_pub.price_list_line_tbl_type;
5976: l_price_list_line_val_tbl qp_price_list_pub.price_list_line_val_tbl_type;
5977: l_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
5978: l_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
5979: l_pricing_attr_tbl qp_price_list_pub.pricing_attr_tbl_type;
5980: l_pricing_attr_val_tbl qp_price_list_pub.pricing_attr_val_tbl_type;
5981:
5982: BEGIN
5983:

Line 5980: l_pricing_attr_val_tbl qp_price_list_pub.pricing_attr_val_tbl_type;

5976: l_price_list_line_val_tbl qp_price_list_pub.price_list_line_val_tbl_type;
5977: l_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
5978: l_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
5979: l_pricing_attr_tbl qp_price_list_pub.pricing_attr_tbl_type;
5980: l_pricing_attr_val_tbl qp_price_list_pub.pricing_attr_val_tbl_type;
5981:
5982: BEGIN
5983:
5984: --dbms_output.put_line('create List line called');

Line 6032: QP_PRICE_LIST_PUB.Process_Price_List(

6028: AMS_Utility_PVT.debug_message(l_full_name ||': create pricelist line...');
6029:
6030: END IF;
6031:
6032: QP_PRICE_LIST_PUB.Process_Price_List(
6033: p_api_version_number => 1.0,
6034: p_init_msg_list => FND_API.G_TRUE,
6035: p_return_values => FND_API.G_TRUE,
6036: p_commit => FND_API.G_TRUE,