APPS.ICX_POR_ITEM_UPLOAD dependencies on ICX_CAT_PRICE_LISTS

Line 4426: INSERT INTO icx_cat_price_lists (price_list_id, name, supplier_id,

4422: p_type := 'B';
4423:
4424: xErrLoc := 200;
4425:
4426: INSERT INTO icx_cat_price_lists (price_list_id, name, supplier_id,
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

Line 4462: DELETE FROM icx_cat_price_lists

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
4463: WHERE price_list_id = p_header_id
4464: AND status IN ('UNPUBLISHED', 'PUBLISHED');
4465:
4466: xErrLoc := 200;

Line 4468: INSERT INTO icx_cat_price_lists (price_list_id, name, supplier_id,

4464: AND status IN ('UNPUBLISHED', 'PUBLISHED');
4465:
4466: xErrLoc := 200;
4467:
4468: INSERT INTO icx_cat_price_lists (price_list_id, name, supplier_id,
4469: buyer_id, description, currency, begindate, enddate, action, status,
4470: type, parent_header_id,
4471: creation_date, created_by, last_update_date, last_updated_by,
4472: last_update_login, request_id)

Line 4482: FROM icx_cat_price_lists pl

4478: to_date(p_enddate, DEFAULT_DATE_FORMAT)) ,
4479: 'UPDATE', 'UNPUBLISHED',
4480: pl.type, pl.parent_header_id, pl.creation_date,
4481: pl.created_by, sysdate, p_user_id, p_user_id, p_request_id
4482: FROM icx_cat_price_lists pl
4483: WHERE pl.price_list_id = p_header_id
4484: AND pl.status = 'APPROVED';
4485:
4486: -- added by bluk for group pricing project

Line 4490: SELECT type INTO p_type FROM icx_cat_price_lists

4486: -- added by bluk for group pricing project
4487: -- propagate changes for child lists
4488: xErrLoc := 300;
4489:
4490: SELECT type INTO p_type FROM icx_cat_price_lists
4491: WHERE price_list_id = p_header_id
4492: AND status = 'APPROVED';
4493:
4494: xErrLoc := 310;

Line 4508: p_type icx_cat_price_lists.type%TYPE;

4504: END update_price_list;
4505:
4506: PROCEDURE delete_price_list( p_header_id IN NUMBER ) IS
4507: xErrLoc INTEGER;
4508: p_type icx_cat_price_lists.type%TYPE;
4509: BEGIN
4510: xErrLoc := 100;
4511: DELETE FROM icx_cat_price_lists
4512: WHERE price_list_id = p_header_id;

Line 4511: DELETE FROM icx_cat_price_lists

4507: xErrLoc INTEGER;
4508: p_type icx_cat_price_lists.type%TYPE;
4509: BEGIN
4510: xErrLoc := 100;
4511: DELETE FROM icx_cat_price_lists
4512: WHERE price_list_id = p_header_id;
4513: commit;
4514:
4515: EXCEPTION