DBA Data[Home] [Help]

APPS.CTO_CUSTOM_PURCHASE_PRICE_PK SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 8

    configurations selected in the oe_order_lines. The price list can be
    Org dependent. So this fucntion will take organization_id in the in parameteres.
    Note:By the time this function is called the config item is not yet created.
    So all the reference needs to go with the model item and the options selected
    in the sales order. If it returns null the models list price will be defaulted
    to Config item also.
+----------------------------------------------------------------------------*/

function Get_Purchase_price(
        p_item_id        in      number,
        p_vendor_id      in      Number,
        p_vendor_site_id in      Number)
Return Boolean IS

begin
	/*----------------------------------------------------------------+
	   This function can be replaced by custom code that will calculate
           the price list for this configuration.
        +-----------------------------------------------------------------*/

	return FALSE;