APPS.POR_IFT_ADMIN_PKG dependencies on POR_TEMPLATE_ASSOC

Line 215: DELETE FROM POR_TEMPLATE_ASSOC

211: DELETE FROM POR_TEMPLATES_ALL_TL
212: WHERE TEMPLATE_CODE = l_template_code;
213:
214: l_progress := '006';
215: DELETE FROM POR_TEMPLATE_ASSOC
216: WHERE region_code = l_template_code;
217:
218: EXCEPTION
219: WHEN OTHERS THEN

Line 517: SELECT por_template_assoc_s.NEXTVAL

513: l_template_assoc_id NUMBER;
514: BEGIN
515:
516: l_progress := '001';
517: SELECT por_template_assoc_s.NEXTVAL
518: INTO l_template_assoc_id
519: FROM SYS.DUAL;
520:
521: l_progress := '002';

Line 522: INSERT INTO por_template_assoc (

518: INTO l_template_assoc_id
519: FROM SYS.DUAL;
520:
521: l_progress := '002';
522: INSERT INTO por_template_assoc (
523: template_assoc_id,
524: region_code,
525: item_or_category_flag,
526: item_or_category_id,

Line 548: FROM por_template_assoc_v

544:
545: l_progress := '003';
546: SELECT row_id
547: INTO p_row_id
548: FROM por_template_assoc_v
549: WHERE template_assoc_id = l_template_assoc_id;
550:
551: EXCEPTION
552: WHEN OTHERS THEN

Line 566: FROM por_template_assoc

562: p_user_id IN NUMBER,
563: p_login_id IN NUMBER) IS
564: CURSOR c_rec(p_row_id VARCHAR2) IS
565: SELECT *
566: FROM por_template_assoc
567: WHERE rowid = p_row_id
568: FOR UPDATE NOWAIT;
569: l_rec c_rec%ROWTYPE;
570: l_progress VARCHAR2(10) := '000';

Line 634: UPDATE por_template_assoc

630: l_progress VARCHAR2(10) := '000';
631: BEGIN
632:
633: l_progress := '001';
634: UPDATE por_template_assoc
635: SET template_assoc_id = p_template_assoc_id,
636: region_code = p_region_code,
637: item_or_category_flag = p_item_or_category_flag,
638: item_or_category_id = p_item_or_category_id,

Line 656: DELETE FROM por_template_assoc

652: l_progress VARCHAR2(10) := '000';
653: BEGIN
654:
655: l_progress := '001';
656: DELETE FROM por_template_assoc
657: WHERE rowid = p_row_id;
658:
659: EXCEPTION
660: WHEN OTHERS THEN

Line 670: DELETE FROM por_template_assoc

666: l_progress VARCHAR2(10) := '000';
667: BEGIN
668:
669: l_progress := '001';
670: DELETE FROM por_template_assoc
671: WHERE region_code = p_region_code;
672:
673: EXCEPTION
674: WHEN OTHERS THEN