eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ICX_POR_SCHEMA_UPLOAD dependencies on ICX_POR_FAILED_LINES

Line 2657: INSERT INTO icx_por_failed_lines (job_number, line_number, action,

2653: BEGIN
2654:
2655: --Bug#2729328
2656: --IF p_key IS NOT NULL THEN
2657: INSERT INTO icx_por_failed_lines (job_number, line_number, action,
2658: row_type, descriptor_key, descriptor_value) VALUES (p_request_id,
2659: p_line_number, p_action, 'CATEGORY', 'ICX_POR_CATEGORY_KEY', p_key);
2660: --END IF;
2661:

Line 2666: INSERT INTO icx_por_failed_lines (job_number, line_number, action,

2662: --Bug#2729328
2663: l_progress := '200';
2664:
2665: --IF p_name IS NOT NULL THEN
2666: INSERT INTO icx_por_failed_lines (job_number, line_number, action,
2667: row_type, descriptor_key, descriptor_value) VALUES (p_request_id,
2668: p_line_number, p_action, 'CATEGORY', 'ICX_POR_CATEGORY_NAME', p_name);
2669: --END IF;
2670:

Line 2674: INSERT INTO icx_por_failed_lines (job_number, line_number, action,

2670:
2671: l_progress := '300';
2672:
2673: IF p_type IS NOT NULL THEN
2674: INSERT INTO icx_por_failed_lines (job_number, line_number, action,
2675: row_type, descriptor_key, descriptor_value) VALUES (p_request_id,
2676: p_line_number, p_action, 'CATEGORY', 'ICX_POR_CAT_CATEGORY_TYPE', p_type);
2677: END IF;
2678:

Line 2682: INSERT INTO icx_por_failed_lines (job_number, line_number, action,

2678:
2679: l_progress := '400';
2680:
2681: IF p_description IS NOT NULL THEN
2682: INSERT INTO icx_por_failed_lines (job_number, line_number, action,
2683: row_type, descriptor_key, descriptor_value) VALUES (p_request_id,
2684: p_line_number, p_action, 'CATEGORY', 'ICX_POR_CATEGORY_DESC', p_description);
2685: END IF;
2686:

Line 2690: INSERT INTO icx_por_failed_lines (job_number, line_number, action,

2686:
2687: l_progress := '500';
2688:
2689: IF p_owner_key IS NOT NULL THEN
2690: INSERT INTO icx_por_failed_lines (job_number, line_number, action,
2691: row_type, descriptor_key, descriptor_value) VALUES (p_request_id,
2692: p_line_number, p_action, 'CATEGORY', 'ICX_POR_CAT_ATTRIB_OWNER_KEY', p_owner_key);
2693: END IF;
2694:

Line 2698: INSERT INTO icx_por_failed_lines (job_number, line_number, action,

2694:
2695: l_progress := '600';
2696:
2697: IF p_owner_name IS NOT NULL THEN
2698: INSERT INTO icx_por_failed_lines (job_number, line_number, action,
2699: row_type, descriptor_key, descriptor_value) VALUES (p_request_id,
2700: p_line_number, p_action, 'CATEGORY', 'ICX_POR_CAT_ATTRIB_OWNER_NAME', p_owner_name);
2701: END IF;
2702:

Line 2736: INSERT INTO icx_por_failed_lines (job_number, line_number, action,

2732: l_progress VARCHAR2(5) := '100';
2733: BEGIN
2734:
2735: IF p_key IS NOT NULL THEN
2736: INSERT INTO icx_por_failed_lines (job_number, line_number, action,
2737: row_type, descriptor_key, descriptor_value) VALUES (p_request_id,
2738: p_line_number, p_action, p_errortype, 'ICX_POR_ATTRIB_KEY', p_key);
2739: END IF;
2740:

Line 2744: INSERT INTO icx_por_failed_lines (job_number, line_number, action,

2740:
2741: l_progress := '200';
2742:
2743: IF p_name IS NOT NULL THEN
2744: INSERT INTO icx_por_failed_lines (job_number, line_number, action,
2745: row_type, descriptor_key, descriptor_value) VALUES (p_request_id,
2746: p_line_number, p_action, p_errortype, 'ICX_POR_ATTRIB_NAME', p_name);
2747: END IF;
2748:

Line 2752: INSERT INTO icx_por_failed_lines (job_number, line_number, action,

2748:
2749: l_progress := '300';
2750:
2751: IF p_type IS NOT NULL THEN
2752: INSERT INTO icx_por_failed_lines (job_number, line_number, action,
2753: row_type, descriptor_key, descriptor_value) VALUES (p_request_id,
2754: p_line_number, p_action, p_errortype, 'ICX_POR_CAT_CATEGORY_TYPE', p_type);
2755: END IF;
2756:

Line 2760: INSERT INTO icx_por_failed_lines (job_number, line_number, action,

2756:
2757: l_progress := '400';
2758:
2759: IF p_description IS NOT NULL THEN
2760: INSERT INTO icx_por_failed_lines (job_number, line_number, action,
2761: row_type, descriptor_key, descriptor_value) VALUES (p_request_id,
2762: p_line_number, p_action, p_errortype, 'ICX_POR_CATEGORY_DESC', p_description);
2763: END IF;
2764:

Line 2770: INSERT INTO icx_por_failed_lines (job_number, line_number, action,

2766:
2767: -- Bug 1383537 - Use ICX_POR_CAT_ATTRIB_OWNER_KEY and ICX_POR_CAT_ATTRIB_OWNER_NAME
2768: -- instead of ICX_POR_CAT_ATTRIB_OWNER to avoid unique index violation.
2769: IF p_owner_key IS NOT NULL THEN
2770: INSERT INTO icx_por_failed_lines (job_number, line_number, action,
2771: row_type, descriptor_key, descriptor_value) VALUES (p_request_id,
2772: p_line_number, p_action, p_errortype, 'ICX_POR_CAT_ATTRIB_OWNER_KEY',
2773: p_owner_key);
2774: END IF;

Line 2779: INSERT INTO icx_por_failed_lines (job_number, line_number, action,

2775:
2776: l_progress := '600';
2777:
2778: IF p_owner_name IS NOT NULL THEN
2779: INSERT INTO icx_por_failed_lines (job_number, line_number, action,
2780: row_type, descriptor_key, descriptor_value) VALUES (p_request_id,
2781: p_line_number, p_action, p_errortype, 'ICX_POR_CAT_ATTRIB_OWNER_NAME',
2782: p_owner_name);
2783: END IF;

Line 2788: INSERT INTO icx_por_failed_lines (job_number, line_number, action,

2784:
2785: l_progress := '700';
2786:
2787: IF p_sequence IS NOT NULL THEN
2788: INSERT INTO icx_por_failed_lines (job_number, line_number, action,
2789: row_type, descriptor_key, descriptor_value) VALUES (p_request_id,
2790: p_line_number, p_action, p_errortype, 'ICX_POR_ATTRIB_SEQ', p_sequence);
2791: END IF;
2792:

Line 2796: INSERT INTO icx_por_failed_lines (job_number, line_number, action,

2792:
2793: l_progress := '800';
2794:
2795: IF p_default_value IS NOT NULL THEN
2796: INSERT INTO icx_por_failed_lines (job_number, line_number, action,
2797: row_type, descriptor_key, descriptor_value) VALUES (p_request_id,
2798: p_line_number, p_action, p_errortype, 'ICX_POR_CAT_ATTRIB_DEFAULT',
2799: p_default_value);
2800: END IF;

Line 2805: INSERT INTO icx_por_failed_lines (job_number, line_number, action,

2801:
2802: l_progress := '900';
2803:
2804: IF p_searchable IS NOT NULL THEN
2805: INSERT INTO icx_por_failed_lines (job_number, line_number, action,
2806: row_type, descriptor_key, descriptor_value) VALUES (p_request_id,
2807: p_line_number, p_action, p_errortype, 'ICX_POR_CAT_ATTRIB_SEARCHABLE',
2808: p_searchable);
2809: END IF;

Line 2814: INSERT INTO icx_por_failed_lines (job_number, line_number, action,

2810:
2811: l_progress := '1000';
2812:
2813: IF p_itemdetailvisible IS NOT NULL THEN
2814: INSERT INTO icx_por_failed_lines (job_number, line_number, action,
2815: row_type, descriptor_key, descriptor_value) VALUES (p_request_id,
2816: p_line_number, p_action, p_errortype, 'ICX_POR_CAT_ATTR_DETAILVISIBLE',
2817: p_itemdetailvisible);
2818: END IF;

Line 2823: INSERT INTO icx_por_failed_lines (job_number, line_number, action,

2819:
2820: l_progress := '1100';
2821:
2822: IF p_searchresultsvisible IS NOT NULL THEN
2823: INSERT INTO icx_por_failed_lines (job_number, line_number, action,
2824: row_type, descriptor_key, descriptor_value) VALUES (p_request_id,
2825: p_line_number, p_action, p_errortype, 'ICX_POR_CAT_SEARCH_VISIBLE',
2826: p_searchresultsvisible);
2827: END IF;

Line 2833: INSERT INTO icx_por_failed_lines (job_number, line_number, action,

2829: l_progress := '1200';
2830:
2831: --!!!!!CHECK!!!!!
2832: IF p_required IS NOT NULL THEN
2833: INSERT INTO icx_por_failed_lines (job_number, line_number, action,
2834: row_type, descriptor_key, descriptor_value) VALUES (p_request_id,
2835: p_line_number, p_action, p_errortype, 'ICX_POR_CAT_ATTRIB_REQUIRED',
2836: p_required);
2837: END IF;

Line 2842: INSERT INTO icx_por_failed_lines (job_number, line_number, action,

2838:
2839: l_progress := '1300';
2840:
2841: IF p_multivalue IS NOT NULL THEN
2842: INSERT INTO icx_por_failed_lines (job_number, line_number, action,
2843: row_type, descriptor_key, descriptor_value) VALUES (p_request_id,
2844: p_line_number, p_action, p_errortype, 'ICX_POR_CAT_ATTRIB_MULTIVALUE',
2845: p_multivalue);
2846:

Line 2868: INSERT INTO icx_por_failed_lines (job_number, line_number, action,

2864: l_progress VARCHAR2(5) := '100';
2865: BEGIN
2866:
2867: IF p_parent_key IS NOT NULL THEN
2868: INSERT INTO icx_por_failed_lines (job_number, line_number, action,
2869: row_type, descriptor_key, descriptor_value) VALUES (p_request_id,
2870: p_line_number, p_action, 'RELATIONSHIP', 'ICX_POR_CAT_PARENT_KEY',
2871: p_parent_key);
2872: END IF;

Line 2877: INSERT INTO icx_por_failed_lines (job_number, line_number, action,

2873:
2874: l_progress := '110';
2875:
2876: IF p_parent_name IS NOT NULL THEN
2877: INSERT INTO icx_por_failed_lines (job_number, line_number, action,
2878: row_type, descriptor_key, descriptor_value) VALUES (p_request_id,
2879: p_line_number, p_action, 'RELATIONSHIP', 'ICX_POR_CAT_PARENT_NAME',
2880: p_parent_name);
2881: END IF;

Line 2886: INSERT INTO icx_por_failed_lines (job_number, line_number, action,

2882:
2883: l_progress := '120';
2884:
2885: IF p_child_key IS NOT NULL THEN
2886: INSERT INTO icx_por_failed_lines (job_number, line_number, action,
2887: row_type, descriptor_key, descriptor_value) VALUES (p_request_id,
2888: p_line_number, p_action, 'RELATIONSHIP', 'ICX_POR_CAT_CHILD_KEY',
2889: p_child_key);
2890: END IF;

Line 2895: INSERT INTO icx_por_failed_lines (job_number, line_number, action,

2891:
2892: l_progress := '110';
2893:
2894: IF p_child_name IS NOT NULL THEN
2895: INSERT INTO icx_por_failed_lines (job_number, line_number, action,
2896: row_type, descriptor_key, descriptor_value) VALUES (p_request_id,
2897: p_line_number, p_action, 'RELATIONSHIP', 'ICX_POR_CAT_CHILD_NAME',
2898: p_child_name);
2899: END IF;

Line 2958: INSERT INTO icx_por_failed_lines (job_number,

2954: p_line_number IN NUMBER) IS
2955: l_progress VARCHAR2(5) := '100';
2956: BEGIN
2957:
2958: INSERT INTO icx_por_failed_lines (job_number,
2959: line_number,
2960: action,
2961: row_type,
2962: descriptor_key,