APPS.ICX_POR_ITEM_UPLOAD dependencies on ICX_POR_PRICE_LISTS

Line 4431: (icx_por_price_lists_s.nextval, p_price_list_name,

4427: buyer_id, description, currency, begindate, enddate, action, status,
4428: type, parent_header_id, creation_date, published_date, approval_date,
4429: created_by, last_update_date, last_updated_by,
4430: last_update_login, request_id) values
4431: (icx_por_price_lists_s.nextval, p_price_list_name,
4432: p_supplier_id, p_buyer_id,null,p_currency,
4433: to_date(p_begindate, DEFAULT_DATE_FORMAT),
4434: to_date(p_enddate, DEFAULT_DATE_FORMAT),
4435: 'ADD', 'APPROVED', p_type, null, sysdate, sysdate, sysdate,

Line 4458: p_type icx_por_price_lists.type%TYPE;

4454: p_enddate IN VARCHAR2,
4455: p_user_id IN NUMBER,
4456: p_request_id IN NUMBER) IS
4457: xErrLoc INTEGER;
4458: p_type icx_por_price_lists.type%TYPE;
4459: BEGIN
4460: xErrLoc := 100;
4461: -- Delete unapproved price lists first
4462: DELETE FROM icx_cat_price_lists