3975: l_return_status VARCHAR2(1);
3976: l_msg_count NUMBER;
3977: l_msg_data VARCHAR2(2000);
3978:
3979: p_price_list_rec qp_price_list_pub.price_list_rec_type;
3980: p_price_list_val_rec qp_price_list_pub.price_list_val_rec_type;
3981: p_price_list_line_tbl qp_price_list_pub.price_list_line_tbl_type;
3982: p_price_list_line_val_tbl qp_price_list_pub.price_list_line_val_tbl_type;
3983: p_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
3976: l_msg_count NUMBER;
3977: l_msg_data VARCHAR2(2000);
3978:
3979: p_price_list_rec qp_price_list_pub.price_list_rec_type;
3980: p_price_list_val_rec qp_price_list_pub.price_list_val_rec_type;
3981: p_price_list_line_tbl qp_price_list_pub.price_list_line_tbl_type;
3982: p_price_list_line_val_tbl qp_price_list_pub.price_list_line_val_tbl_type;
3983: p_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
3984: p_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
3977: l_msg_data VARCHAR2(2000);
3978:
3979: p_price_list_rec qp_price_list_pub.price_list_rec_type;
3980: p_price_list_val_rec qp_price_list_pub.price_list_val_rec_type;
3981: p_price_list_line_tbl qp_price_list_pub.price_list_line_tbl_type;
3982: p_price_list_line_val_tbl qp_price_list_pub.price_list_line_val_tbl_type;
3983: p_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
3984: p_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
3985: p_pricing_attr_tbl qp_price_list_pub.pricing_attr_tbl_type;
3978:
3979: p_price_list_rec qp_price_list_pub.price_list_rec_type;
3980: p_price_list_val_rec qp_price_list_pub.price_list_val_rec_type;
3981: p_price_list_line_tbl qp_price_list_pub.price_list_line_tbl_type;
3982: p_price_list_line_val_tbl qp_price_list_pub.price_list_line_val_tbl_type;
3983: p_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
3984: p_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
3985: p_pricing_attr_tbl qp_price_list_pub.pricing_attr_tbl_type;
3986: p_pricing_attr_val_tbl qp_price_list_pub.pricing_attr_val_tbl_type;
3981: p_price_list_line_tbl qp_price_list_pub.price_list_line_tbl_type;
3982: p_price_list_line_val_tbl qp_price_list_pub.price_list_line_val_tbl_type;
3983: p_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
3984: p_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
3985: p_pricing_attr_tbl qp_price_list_pub.pricing_attr_tbl_type;
3986: p_pricing_attr_val_tbl qp_price_list_pub.pricing_attr_val_tbl_type;
3987:
3988: l_price_list_rec qp_price_list_pub.price_list_rec_type;
3989: l_price_list_val_rec qp_price_list_pub.price_list_val_rec_type;
3982: p_price_list_line_val_tbl qp_price_list_pub.price_list_line_val_tbl_type;
3983: p_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
3984: p_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
3985: p_pricing_attr_tbl qp_price_list_pub.pricing_attr_tbl_type;
3986: p_pricing_attr_val_tbl qp_price_list_pub.pricing_attr_val_tbl_type;
3987:
3988: l_price_list_rec qp_price_list_pub.price_list_rec_type;
3989: l_price_list_val_rec qp_price_list_pub.price_list_val_rec_type;
3990: l_price_list_line_tbl qp_price_list_pub.price_list_line_tbl_type;
3984: p_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
3985: p_pricing_attr_tbl qp_price_list_pub.pricing_attr_tbl_type;
3986: p_pricing_attr_val_tbl qp_price_list_pub.pricing_attr_val_tbl_type;
3987:
3988: l_price_list_rec qp_price_list_pub.price_list_rec_type;
3989: l_price_list_val_rec qp_price_list_pub.price_list_val_rec_type;
3990: l_price_list_line_tbl qp_price_list_pub.price_list_line_tbl_type;
3991: l_price_list_line_val_tbl qp_price_list_pub.price_list_line_val_tbl_type;
3992: l_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
3985: p_pricing_attr_tbl qp_price_list_pub.pricing_attr_tbl_type;
3986: p_pricing_attr_val_tbl qp_price_list_pub.pricing_attr_val_tbl_type;
3987:
3988: l_price_list_rec qp_price_list_pub.price_list_rec_type;
3989: l_price_list_val_rec qp_price_list_pub.price_list_val_rec_type;
3990: l_price_list_line_tbl qp_price_list_pub.price_list_line_tbl_type;
3991: l_price_list_line_val_tbl qp_price_list_pub.price_list_line_val_tbl_type;
3992: l_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
3993: l_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
3986: p_pricing_attr_val_tbl qp_price_list_pub.pricing_attr_val_tbl_type;
3987:
3988: l_price_list_rec qp_price_list_pub.price_list_rec_type;
3989: l_price_list_val_rec qp_price_list_pub.price_list_val_rec_type;
3990: l_price_list_line_tbl qp_price_list_pub.price_list_line_tbl_type;
3991: l_price_list_line_val_tbl qp_price_list_pub.price_list_line_val_tbl_type;
3992: l_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
3993: l_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
3994: l_pricing_attr_tbl qp_price_list_pub.pricing_attr_tbl_type;
3987:
3988: l_price_list_rec qp_price_list_pub.price_list_rec_type;
3989: l_price_list_val_rec qp_price_list_pub.price_list_val_rec_type;
3990: l_price_list_line_tbl qp_price_list_pub.price_list_line_tbl_type;
3991: l_price_list_line_val_tbl qp_price_list_pub.price_list_line_val_tbl_type;
3992: l_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
3993: l_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
3994: l_pricing_attr_tbl qp_price_list_pub.pricing_attr_tbl_type;
3995: l_pricing_attr_val_tbl qp_price_list_pub.pricing_attr_val_tbl_type;
3990: l_price_list_line_tbl qp_price_list_pub.price_list_line_tbl_type;
3991: l_price_list_line_val_tbl qp_price_list_pub.price_list_line_val_tbl_type;
3992: l_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
3993: l_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
3994: l_pricing_attr_tbl qp_price_list_pub.pricing_attr_tbl_type;
3995: l_pricing_attr_val_tbl qp_price_list_pub.pricing_attr_val_tbl_type;
3996:
3997: BEGIN
3998:
3991: l_price_list_line_val_tbl qp_price_list_pub.price_list_line_val_tbl_type;
3992: l_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
3993: l_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
3994: l_pricing_attr_tbl qp_price_list_pub.pricing_attr_tbl_type;
3995: l_pricing_attr_val_tbl qp_price_list_pub.pricing_attr_val_tbl_type;
3996:
3997: BEGIN
3998:
3999: --dbms_output.put_line('create List header called');
4012: IF (AMS_DEBUG_HIGH_ON) THEN
4013: AMS_Utility_PVT.debug_message(l_full_name ||': create pricelist header...');
4014: END IF;
4015:
4016: QP_PRICE_LIST_PUB.Process_Price_List(
4017: p_api_version_number => 1.0,
4018: p_init_msg_list => FND_API.g_false,
4019: p_return_values => FND_API.G_TRUE,
4020: p_commit => FND_API.g_false,
4082: l_return_status VARCHAR2(1);
4083: l_msg_count NUMBER;
4084: l_msg_data VARCHAR2(2000);
4085:
4086: p_price_list_rec qp_price_list_pub.price_list_rec_type;
4087: p_price_list_val_rec qp_price_list_pub.price_list_val_rec_type;
4088: p_price_list_line_tbl qp_price_list_pub.price_list_line_tbl_type;
4089: p_price_list_line_val_tbl qp_price_list_pub.price_list_line_val_tbl_type;
4090: p_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
4083: l_msg_count NUMBER;
4084: l_msg_data VARCHAR2(2000);
4085:
4086: p_price_list_rec qp_price_list_pub.price_list_rec_type;
4087: p_price_list_val_rec qp_price_list_pub.price_list_val_rec_type;
4088: p_price_list_line_tbl qp_price_list_pub.price_list_line_tbl_type;
4089: p_price_list_line_val_tbl qp_price_list_pub.price_list_line_val_tbl_type;
4090: p_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
4091: p_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
4084: l_msg_data VARCHAR2(2000);
4085:
4086: p_price_list_rec qp_price_list_pub.price_list_rec_type;
4087: p_price_list_val_rec qp_price_list_pub.price_list_val_rec_type;
4088: p_price_list_line_tbl qp_price_list_pub.price_list_line_tbl_type;
4089: p_price_list_line_val_tbl qp_price_list_pub.price_list_line_val_tbl_type;
4090: p_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
4091: p_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
4092: p_pricing_attr_tbl qp_price_list_pub.pricing_attr_tbl_type;
4085:
4086: p_price_list_rec qp_price_list_pub.price_list_rec_type;
4087: p_price_list_val_rec qp_price_list_pub.price_list_val_rec_type;
4088: p_price_list_line_tbl qp_price_list_pub.price_list_line_tbl_type;
4089: p_price_list_line_val_tbl qp_price_list_pub.price_list_line_val_tbl_type;
4090: p_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
4091: p_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
4092: p_pricing_attr_tbl qp_price_list_pub.pricing_attr_tbl_type;
4093: p_pricing_attr_val_tbl qp_price_list_pub.pricing_attr_val_tbl_type;
4088: p_price_list_line_tbl qp_price_list_pub.price_list_line_tbl_type;
4089: p_price_list_line_val_tbl qp_price_list_pub.price_list_line_val_tbl_type;
4090: p_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
4091: p_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
4092: p_pricing_attr_tbl qp_price_list_pub.pricing_attr_tbl_type;
4093: p_pricing_attr_val_tbl qp_price_list_pub.pricing_attr_val_tbl_type;
4094:
4095: l_price_list_rec qp_price_list_pub.price_list_rec_type;
4096: l_price_list_val_rec qp_price_list_pub.price_list_val_rec_type;
4089: p_price_list_line_val_tbl qp_price_list_pub.price_list_line_val_tbl_type;
4090: p_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
4091: p_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
4092: p_pricing_attr_tbl qp_price_list_pub.pricing_attr_tbl_type;
4093: p_pricing_attr_val_tbl qp_price_list_pub.pricing_attr_val_tbl_type;
4094:
4095: l_price_list_rec qp_price_list_pub.price_list_rec_type;
4096: l_price_list_val_rec qp_price_list_pub.price_list_val_rec_type;
4097: l_price_list_line_tbl qp_price_list_pub.price_list_line_tbl_type;
4091: p_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
4092: p_pricing_attr_tbl qp_price_list_pub.pricing_attr_tbl_type;
4093: p_pricing_attr_val_tbl qp_price_list_pub.pricing_attr_val_tbl_type;
4094:
4095: l_price_list_rec qp_price_list_pub.price_list_rec_type;
4096: l_price_list_val_rec qp_price_list_pub.price_list_val_rec_type;
4097: l_price_list_line_tbl qp_price_list_pub.price_list_line_tbl_type;
4098: l_price_list_line_val_tbl qp_price_list_pub.price_list_line_val_tbl_type;
4099: l_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
4092: p_pricing_attr_tbl qp_price_list_pub.pricing_attr_tbl_type;
4093: p_pricing_attr_val_tbl qp_price_list_pub.pricing_attr_val_tbl_type;
4094:
4095: l_price_list_rec qp_price_list_pub.price_list_rec_type;
4096: l_price_list_val_rec qp_price_list_pub.price_list_val_rec_type;
4097: l_price_list_line_tbl qp_price_list_pub.price_list_line_tbl_type;
4098: l_price_list_line_val_tbl qp_price_list_pub.price_list_line_val_tbl_type;
4099: l_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
4100: l_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
4093: p_pricing_attr_val_tbl qp_price_list_pub.pricing_attr_val_tbl_type;
4094:
4095: l_price_list_rec qp_price_list_pub.price_list_rec_type;
4096: l_price_list_val_rec qp_price_list_pub.price_list_val_rec_type;
4097: l_price_list_line_tbl qp_price_list_pub.price_list_line_tbl_type;
4098: l_price_list_line_val_tbl qp_price_list_pub.price_list_line_val_tbl_type;
4099: l_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
4100: l_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
4101: l_pricing_attr_tbl qp_price_list_pub.pricing_attr_tbl_type;
4094:
4095: l_price_list_rec qp_price_list_pub.price_list_rec_type;
4096: l_price_list_val_rec qp_price_list_pub.price_list_val_rec_type;
4097: l_price_list_line_tbl qp_price_list_pub.price_list_line_tbl_type;
4098: l_price_list_line_val_tbl qp_price_list_pub.price_list_line_val_tbl_type;
4099: l_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
4100: l_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
4101: l_pricing_attr_tbl qp_price_list_pub.pricing_attr_tbl_type;
4102: l_pricing_attr_val_tbl qp_price_list_pub.pricing_attr_val_tbl_type;
4097: l_price_list_line_tbl qp_price_list_pub.price_list_line_tbl_type;
4098: l_price_list_line_val_tbl qp_price_list_pub.price_list_line_val_tbl_type;
4099: l_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
4100: l_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
4101: l_pricing_attr_tbl qp_price_list_pub.pricing_attr_tbl_type;
4102: l_pricing_attr_val_tbl qp_price_list_pub.pricing_attr_val_tbl_type;
4103:
4104: BEGIN
4105:
4098: l_price_list_line_val_tbl qp_price_list_pub.price_list_line_val_tbl_type;
4099: l_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
4100: l_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
4101: l_pricing_attr_tbl qp_price_list_pub.pricing_attr_tbl_type;
4102: l_pricing_attr_val_tbl qp_price_list_pub.pricing_attr_val_tbl_type;
4103:
4104: BEGIN
4105:
4106: --dbms_output.put_line('create List line called');
4126: IF (AMS_DEBUG_HIGH_ON) THEN
4127: AMS_Utility_PVT.debug_message(l_full_name ||': create pricelist line...');
4128: END IF;
4129:
4130: QP_PRICE_LIST_PUB.Process_Price_List(
4131: p_api_version_number => 1.0,
4132: p_init_msg_list => FND_API.g_false,
4133: p_return_values => FND_API.G_TRUE,
4134: p_commit => FND_API.g_false,