APPS.AZW_REPORT dependencies on HTP

Line 634: htp.p('

630: END IF;
631:
632: print_param_page_header(g_cpr, g_cpr_msg, NULL);
633:
634: htp.p('

635: 'cellspacing="2" width="96%">');
636: htp.p('');
637: htp.p(' 638: 'action="azw_report.context_report">');

Line 636: htp.p('

');

632: print_param_page_header(g_cpr, g_cpr_msg, NULL);
633:
634: htp.p('

635: 'cellspacing="2" width="96%">');
636: htp.p('');
637: htp.p(' 638: 'action="azw_report.context_report">');
639: htp.p('');

Line 637: htp.p('

633:
634: htp.p('

' || 640: g_ctxt_type || '

635: 'cellspacing="2" width="96%">');
636: htp.p('');
637: htp.p(' 638: 'action="azw_report.context_report">');
639: htp.p('');
641: htp.p('');
637: htp.p(' 638: 'action="azw_report.context_report">');
639: htp.p('');
641: htp.p('');
639: htp.p('');
641: htp.p('');

Line 654: htp.p('');

650: htp.p(' '||
651: one_context.meaning || '');
652: END IF;
653: END LOOP;
654: htp.p('');
655:
656: -- print OK and Cancel buttons
657: print_param_page_footer;
658:

Line 723: htp.p('

' || 640: g_ctxt_type || '	'); Line 639: htp.p('
' || 635: 'cellspacing="2" width="96%">'); 636: htp.p('
' || 640: g_ctxt_type || '	'); 642: -- construct pop-up list of context types BG, IO, OU, SOB and NONE 643: -- if v_context.lookup_code like '%BG%' make it default Line 641: htp.p('			'); 637: htp.p(' 638: 'action="azw_report.context_report">
' || 640: g_ctxt_type || '	'); 642: -- construct pop-up list of context types BG, IO, OU, SOB and NONE 643: -- if v_context.lookup_code like '%BG%' make it default 644: 645: FOR one_context IN context_types_cursor LOOP Line 647: htp.p(' '|| 643: -- if v_context.lookup_code like '%BG%' make it default 644: 645: FOR one_context IN context_types_cursor LOOP 646: IF (one_context.lookup_code LIKE '%BG%') THEN 647: htp.p(' '|| 648: one_context.meaning || ''); 649: ELSE 650: htp.p(' '|| 651: one_context.meaning || ''); Line 650: htp.p(' '|| 646: IF (one_context.lookup_code LIKE '%BG%') THEN 647: htp.p(' '|| 648: one_context.meaning || ''); 649: ELSE 650: htp.p(' '|| 651: one_context.meaning || ''); 652: END IF; 653: END LOOP; 654: htp.p('

');

719:
720: --
721: -- Display the Report Details
722: --
723: htp.p('

');
724: htp.p('');
726: htp.p('');
727: htp.p('');
2721: htp.p('');
2722: htp.p('

' || 725: ''|| g_details ||'
Line 724: htp.p('
' || 720: -- 721: -- Display the Report Details 722: -- 723: htp.p(''); 724: htp.p(''); 726: htp.p(''); 727: htp.p(''); Line 726: htp.p(' '); 722: -- 723: htp.p(' ' || 725: ''|| g_details ||' 728: 'NOWRAP>'|| g_hierarchy ||' '); 724: htp.p(''); 726: htp.p(''); 727: htp.p(''); 729: htp.p(''); Line 727: htp.p(' '); 2719: htp.p(' ' || 725: ''|| g_details ||' 728: 'NOWRAP>'|| g_hierarchy ||' 730: 'NOWRAP>'|| g_ctxt_type ||' 723: htp.p(''); 724: htp.p(''); 726: htp.p(''); 727: htp.p(''); 729: htp.p(''); 731: htp.p(''); 726: htp.p(''); 727: htp.p(''); 729: htp.p(''); 731: htp.p(''); 733: Line 731: htp.p(' '); 729: htp.p(''); 731: htp.p(''); 733: 734: v_count := 0; 735: FOR one_node IN hierarchies_cursor LOOP Line 736: htp.tableRowOpen; 732: 'NOWRAP>'|| g_description ||''); 733: 734: v_count := 0; 735: FOR one_node IN hierarchies_cursor LOOP 736: htp.tableRowOpen; 737: IF (one_node.parent_node_id IS NULL) THEN 738: IF (v_count > 0) THEN 739: print_back_to_top(2); 740: END IF; Line 741: htp.p(' '); 745: ELSIF (one_node.node_type = 'G') THEN Line 746: htp.tableData(''|| 742: 'NOWRAP>' || 744: one_node.hierarchy || ''); 745: ELSIF (one_node.node_type = 'G') THEN 746: htp.tableData(''|| 747: lpad_nbsp(one_node.level) || one_node.hierarchy || 748: '', 'LEFT', '', 'NOWRAP'); 749: htp.tableData(''|| one_node.context_type_name || ''); 750: v_count := v_count + 1; Line 749: htp.tableData(''|| one_node.context_type_name || ''); 745: ELSIF (one_node.node_type = 'G') THEN 746: htp.tableData(''|| 747: lpad_nbsp(one_node.level) || one_node.hierarchy || 748: '', 'LEFT', '', 'NOWRAP'); 749: htp.tableData(''|| one_node.context_type_name || ''); 750: v_count := v_count + 1; 751: ELSE 752: htp.tableData(''|| lpad_nbsp(one_node.level) || one_node.hierarchy || 753: '', 'LEFT', '', 'NOWRAP'); Line 752: htp.tableData(''|| lpad_nbsp(one_node.level) || one_node.hierarchy || 748: '', 'LEFT', '', 'NOWRAP'); 749: htp.tableData(''|| one_node.context_type_name || ''); 750: v_count := v_count + 1; 751: ELSE 752: htp.tableData(''|| lpad_nbsp(one_node.level) || one_node.hierarchy || 753: '', 'LEFT', '', 'NOWRAP'); 754: htp.tableData(one_node.context_type_name); 755: htp.tableData(one_node.description); 756: END IF; Line 754: htp.tableData(one_node.context_type_name); 750: v_count := v_count + 1; 751: ELSE 752: htp.tableData(''|| lpad_nbsp(one_node.level) || one_node.hierarchy || 753: '', 'LEFT', '', 'NOWRAP'); 754: htp.tableData(one_node.context_type_name); 755: htp.tableData(one_node.description); 756: END IF; 757: htp.tableRowClose; 758: END LOOP; Line 755: htp.tableData(one_node.description); 751: ELSE 752: htp.tableData(''|| lpad_nbsp(one_node.level) || one_node.hierarchy || 753: '', 'LEFT', '', 'NOWRAP'); 754: htp.tableData(one_node.context_type_name); 755: htp.tableData(one_node.description); 756: END IF; 757: htp.tableRowClose; 758: END LOOP; 759: print_back_to_top(2); Line 757: htp.tableRowClose; 753: '', 'LEFT', '', 'NOWRAP'); 754: htp.tableData(one_node.context_type_name); 755: htp.tableData(one_node.description); 756: END IF; 757: htp.tableRowClose; 758: END LOOP; 759: print_back_to_top(2); 760: -- print Table closing tag 761: htp.tableClose; Line 761: htp.tableClose; 757: htp.tableRowClose; 758: END LOOP; 759: print_back_to_top(2); 760: -- print Table closing tag 761: htp.tableClose; 762: -- print report legend 763: print_legend; 764: 765: -- Line 776: htp.tableClose; 772: 773: EXCEPTION 774: WHEN NO_DATA_FOUND THEN 775: -- print Table closing tag 776: htp.tableClose; 777: print_related_reports('AZW_RPT_IPR', 'AZW_RPT_PPR'); 778: WHEN application_exception THEN 779: RAISE; 780: WHEN OTHERS THEN Line 2409: htp.p(' ' || 725: ''|| g_details ||' 728: 'NOWRAP>'|| g_hierarchy ||' 730: 'NOWRAP>'|| g_ctxt_type ||' Line 729: htp.p(' 725: ''|| g_details ||' 728: 'NOWRAP>'|| g_hierarchy ||' 730: 'NOWRAP>'|| g_ctxt_type ||' 732: 'NOWRAP>'|| g_description ||' 727: htp.p(' 728: 'NOWRAP>'|| g_hierarchy ||' 730: 'NOWRAP>'|| g_ctxt_type ||' 732: 'NOWRAP>'|| g_description ||' 737: IF (one_node.parent_node_id IS NULL) THEN 738: IF (v_count > 0) THEN 739: print_back_to_top(2); 740: END IF; 741: htp.p(' 742: 'NOWRAP>' || 744: one_node.hierarchy || ' 2405: g_help_target := get_report_procedure ('AZW_RPT_IPR'); 2406: 2407: print_param_page_header (g_ipr, g_ipr_msg, NULL); 2408: 2409: htp.p(' 2410: 'cellspacing="2" width="96%">'); 2411: htp.p(''); 2412: htp.p(' 2413: 'action="azw_report.implementation_report">'); Line 2411: htp.p(' '); 2407: print_param_page_header (g_ipr, g_ipr_msg, NULL); 2408: 2409: htp.p(' 2410: 'cellspacing="2" width="96%">'); 2411: htp.p(''); 2412: htp.p(' 2413: 'action="azw_report.implementation_report">'); 2414: htp.p(''); Line 2412: htp.p(' 2408: 2409: htp.p(' ' || 2415: g_phase || ' 2410: 'cellspacing="2" width="96%">'); 2411: htp.p(''); 2412: htp.p(' 2413: 'action="azw_report.implementation_report">'); 2414: htp.p(''); 2416: -- Line 2414: htp.p(' '); 2412: htp.p(' 2413: 'action="azw_report.implementation_report">'); 2414: htp.p(''); 2416: -- 2417: -- create the pop-up list of phase values 2418: -- Line 2419: htp.p(' '); 2416: -- 2417: -- create the pop-up list of phase values 2418: -- 2419: htp.p(''); 2428: Line 2427: htp.p(''); 2423: FOR one_phase IN valid_phases_cursor LOOP 2424: htp.p(''|| one_phase.phase || 2425: ''); 2426: END LOOP; 2427: htp.p(''); 2428: 2429: print_param_page_footer; 2430: 2431: EXCEPTION Line 2521: htp.p(' ' || 2415: g_phase || ' ' || 2410: 'cellspacing="2" width="96%">'); 2411: htp.p(' ' || 2415: g_phase || ' '); 2415: g_phase || ' '); 2420: -- by default the blank choice means selecting all phases 2421: htp.p(''|| g_all ||''); 2422: 2423: FOR one_phase IN valid_phases_cursor LOOP Line 2421: htp.p(''|| g_all ||''); 2417: -- create the pop-up list of phase values 2418: -- 2419: htp.p(' '); 2420: -- by default the blank choice means selecting all phases 2421: htp.p(''|| g_all ||''); 2422: 2423: FOR one_phase IN valid_phases_cursor LOOP 2424: htp.p(''|| one_phase.phase || 2425: ''); Line 2424: htp.p(''|| one_phase.phase || 2420: -- by default the blank choice means selecting all phases 2421: htp.p(' '|| g_all ||''); 2422: 2423: FOR one_phase IN valid_phases_cursor LOOP 2424: htp.p(''|| one_phase.phase || 2425: ''); 2426: END LOOP; 2427: htp.p(' '); 2517: 2518: -- 2519: -- Display Report Details 2520: -- 2521: htp.p(' '); 2522: htp.p(''); 2524: htp.p(''); 2525: htp.p(' ' || 2523: ''|| g_details ||' Line 2522: htp.p(' ' || 2518: -- 2519: -- Display Report Details 2520: -- 2521: htp.p(''); 2522: htp.p(''); 2524: htp.p(''); 2525: htp.p(''); Line 2524: htp.p(' '); 2520: -- 2521: htp.p(' ' || 2523: ''|| g_details ||' 2526: 'NOWRAP>'|| g_hierarchy ||' '); 2522: htp.p(''); 2524: htp.p(''); 2525: htp.p(''); 2527: htp.p(''); Line 2525: htp.p(' '); 2722: htp.p(' ' || 2523: ''|| g_details ||' 2526: 'NOWRAP>'|| g_hierarchy ||' 2528: 'NOWRAP>'|| g_description ||' 2521: htp.p(''); 2522: htp.p(''); 2524: htp.p(''); 2525: htp.p(''); 2527: htp.p(''); 2529: Line 2527: htp.p(' '); 2524: htp.p(''); 2525: htp.p(''); 2527: htp.p(''); 2529: 2530: IF (p_phase IS NULL) THEN -- for all phases 2531: -- print hierarchy for each phase Line 2539: htp.p(' '); 2542: v_locator := 1; 2543: FOR one_node IN hierarchies_cursor(one.phase) LOOP Line 2550: htp.p(' '); Line 2556: -- htp.tableData(one_node.phase, 'RIGHT'); 2552: one_node.phase || '_' || 2553: one_node.node_id || '">' || 2554: one_node.hierarchy || ''); 2555: ELSIF (one_node.node_type = 'G' ) THEN 2556: -- htp.tableData(one_node.phase, 'RIGHT'); 2557: htp.tableRowOpen; 2558: htp.tableData(''|| lpad_nbsp(one_node.level) || one_node.hierarchy 2559: ||'', 'LEFT', '', 'NOWRAP'); 2560: ELSE Line 2557: htp.tableRowOpen; 2553: one_node.node_id || '">' || 2554: one_node.hierarchy || ''); 2555: ELSIF (one_node.node_type = 'G' ) THEN 2556: -- htp.tableData(one_node.phase, 'RIGHT'); 2557: htp.tableRowOpen; 2558: htp.tableData(''|| lpad_nbsp(one_node.level) || one_node.hierarchy 2559: ||'', 'LEFT', '', 'NOWRAP'); 2560: ELSE 2561: -- htp.tableData(one_node.phase, 'RIGHT'); Line 2558: htp.tableData(''|| lpad_nbsp(one_node.level) || one_node.hierarchy 2554: one_node.hierarchy || ''); 2555: ELSIF (one_node.node_type = 'G' ) THEN 2556: -- htp.tableData(one_node.phase, 'RIGHT'); 2557: htp.tableRowOpen; 2558: htp.tableData(''|| lpad_nbsp(one_node.level) || one_node.hierarchy 2559: ||'', 'LEFT', '', 'NOWRAP'); 2560: ELSE 2561: -- htp.tableData(one_node.phase, 'RIGHT'); 2562: htp.tableRowOpen; Line 2561: -- htp.tableData(one_node.phase, 'RIGHT'); 2557: htp.tableRowOpen; 2558: htp.tableData(''|| lpad_nbsp(one_node.level) || one_node.hierarchy 2559: ||'', 'LEFT', '', 'NOWRAP'); 2560: ELSE 2561: -- htp.tableData(one_node.phase, 'RIGHT'); 2562: htp.tableRowOpen; 2563: htp.tableData(''|| lpad_nbsp(one_node.level) || one_node.hierarchy 2564: ||'', 'LEFT', '', 'NOWRAP'); 2565: htp.tableData(one_node.description); Line 2562: htp.tableRowOpen; 2558: htp.tableData(''|| lpad_nbsp(one_node.level) || one_node.hierarchy 2559: ||'', 'LEFT', '', 'NOWRAP'); 2560: ELSE 2561: -- htp.tableData(one_node.phase, 'RIGHT'); 2562: htp.tableRowOpen; 2563: htp.tableData(''|| lpad_nbsp(one_node.level) || one_node.hierarchy 2564: ||'', 'LEFT', '', 'NOWRAP'); 2565: htp.tableData(one_node.description); 2566: END IF; Line 2563: htp.tableData(''|| lpad_nbsp(one_node.level) || one_node.hierarchy 2559: ||'', 'LEFT', '', 'NOWRAP'); 2560: ELSE 2561: -- htp.tableData(one_node.phase, 'RIGHT'); 2562: htp.tableRowOpen; 2563: htp.tableData(''|| lpad_nbsp(one_node.level) || one_node.hierarchy 2564: ||'', 'LEFT', '', 'NOWRAP'); 2565: htp.tableData(one_node.description); 2566: END IF; 2567: htp.tableRowClose; Line 2565: htp.tableData(one_node.description); 2561: -- htp.tableData(one_node.phase, 'RIGHT'); 2562: htp.tableRowOpen; 2563: htp.tableData(''|| lpad_nbsp(one_node.level) || one_node.hierarchy 2564: ||'', 'LEFT', '', 'NOWRAP'); 2565: htp.tableData(one_node.description); 2566: END IF; 2567: htp.tableRowClose; 2568: v_count := v_count + 1; 2569: END LOOP; Line 2567: htp.tableRowClose; 2563: htp.tableData(''|| lpad_nbsp(one_node.level) || one_node.hierarchy 2564: ||'', 'LEFT', '', 'NOWRAP'); 2565: htp.tableData(one_node.description); 2566: END IF; 2567: htp.tableRowClose; 2568: v_count := v_count + 1; 2569: END LOOP; 2570: END LOOP; 2571: ELSE -- for one phase Line 2572: htp.p(' '); 2575: v_count := 0; 2576: -- print hierarchy for the phase Line 2579: htp.tableRowOpen; 2575: v_count := 0; 2576: -- print hierarchy for the phase 2577: v_locator := 2; 2578: FOR one_node IN hierarchies_cursor(v_phase) LOOP 2579: htp.tableRowOpen; 2580: IF (one_node.parent_node_id IS NULL) THEN 2581: IF (v_count > 0) THEN 2582: print_back_to_top(2); 2583: END IF; Line 2584: htp.p(' '); Line 2590: htp.tableData(''||lpad_nbsp(one_node.level) || one_node.hierarchy 2586: one_node.phase || '_' || 2587: one_node.node_id || '">' || 2588: one_node.hierarchy ||''); 2589: ELSIF (one_node.node_type = 'G') THEN 2590: htp.tableData(''||lpad_nbsp(one_node.level) || one_node.hierarchy 2591: || '', 'LEFT', '', 'NOWRAP'); 2592: ELSE 2593: htp.tableData(''||lpad_nbsp(one_node.level) || one_node.hierarchy 2594: || '', 'LEFT', '', 'NOWRAP'); Line 2593: htp.tableData(''||lpad_nbsp(one_node.level) || one_node.hierarchy 2589: ELSIF (one_node.node_type = 'G') THEN 2590: htp.tableData(''||lpad_nbsp(one_node.level) || one_node.hierarchy 2591: || '', 'LEFT', '', 'NOWRAP'); 2592: ELSE 2593: htp.tableData(''||lpad_nbsp(one_node.level) || one_node.hierarchy 2594: || '', 'LEFT', '', 'NOWRAP'); 2595: htp.tableData(one_node.description, 'LEFT', '', 'NOWRAP'); 2596: END IF; 2597: htp.tableRowClose; Line 2595: htp.tableData(one_node.description, 'LEFT', '', 'NOWRAP'); 2591: || '', 'LEFT', '', 'NOWRAP'); 2592: ELSE 2593: htp.tableData(''||lpad_nbsp(one_node.level) || one_node.hierarchy 2594: || '', 'LEFT', '', 'NOWRAP'); 2595: htp.tableData(one_node.description, 'LEFT', '', 'NOWRAP'); 2596: END IF; 2597: htp.tableRowClose; 2598: v_count := v_count +1; 2599: END LOOP; Line 2597: htp.tableRowClose; 2593: htp.tableData(''||lpad_nbsp(one_node.level) || one_node.hierarchy 2594: || '', 'LEFT', '', 'NOWRAP'); 2595: htp.tableData(one_node.description, 'LEFT', '', 'NOWRAP'); 2596: END IF; 2597: htp.tableRowClose; 2598: v_count := v_count +1; 2599: END LOOP; 2600: END IF; 2601: print_back_to_top(2); Line 2602: htp.tableClose; 2598: v_count := v_count +1; 2599: END LOOP; 2600: END IF; 2601: print_back_to_top(2); 2602: htp.tableClose; 2603: print_time_stamp('End displaying report details'); 2604: print_legend; 2605: -- 2606: -- print related report links Line 2615: htp.tableClose; 2611: 2612: EXCEPTION 2613: WHEN NO_DATA_FOUND THEN 2614: -- print Table closing tag 2615: htp.tableClose; 2616: print_related_reports('AZW_RPT_CPR', 'AZW_RPT_PPR'); 2617: WHEN application_exception THEN 2618: RAISE; 2619: WHEN OTHERS THEN Line 2638: htp.p(' '); 2640: 2641: EXCEPTION 2642: WHEN application_exception THEN Line 2664: htp.p(''); Line 2686: htp.p('font.curOption {font-family: arial, sans-serif; font-size: 10pt; ' || 2682: htp.p('font.banner {font-family: arial, sans-serif; font-size: 16pt; ' || 2683: 'font-weight: bold; color: white; text-decoration: none}'); 2684: htp.p('font.subtitle {font-family: arial, sans-serif; font-size: 14pt; ' || 2685: 'color: black; text-decoration: none}'); 2686: htp.p('font.curOption {font-family: arial, sans-serif; font-size: 10pt; ' || 2687: 'color: #666666; text-decoration: none}'); 2688: htp.p('--> .OraCopyright{ display: none; } .OraLegal{ display: none; } .OraPrivacy{ display: none; } tr:hover td.OraTableCellText{ background-color: wheat; } '); 2689: 2690: EXCEPTION Line 2688: htp.p('--> .OraCopyright{ display: none; } .OraLegal{ display: none; } .OraPrivacy{ display: none; } tr:hover td.OraTableCellText{ background-color: wheat; } '); 2684: htp.p('font.subtitle {font-family: arial, sans-serif; font-size: 14pt; ' || 2685: 'color: black; text-decoration: none}'); 2686: htp.p('font.curOption {font-family: arial, sans-serif; font-size: 10pt; ' || 2687: 'color: #666666; text-decoration: none}'); 2688: htp.p('--> .OraCopyright{ display: none; } .OraLegal{ display: none; } .OraPrivacy{ display: none; } tr:hover td.OraTableCellText{ background-color: wheat; } '); 2689: 2690: EXCEPTION 2691: WHEN application_exception THEN 2692: RAISE; Line 2707: htp.p(' ' || 2523: ''|| g_details ||' 2526: 'NOWRAP>'|| g_hierarchy ||' 2528: 'NOWRAP>'|| g_description ||' 2523: ''|| g_details ||' 2526: 'NOWRAP>'|| g_hierarchy ||' 2528: 'NOWRAP>'|| g_description ||' 2535: IF (v_count > 0) THEN 2536: blnBackToTop := TRUE; 2537: print_back_to_top(2); 2538: END IF; 2539: htp.p(' 2540: ' COLSPAN="2">'|| g_phase 2541: || ' ' || one.phase || ' 2546: print_back_to_top(2); 2547: ELSE 2548: blnBackToTop := FALSE; 2549: END IF; 2550: htp.p(' 2551: 'NOWRAP>' || 2554: one_node.hierarchy || ' 2568: v_count := v_count + 1; 2569: END LOOP; 2570: END LOOP; 2571: ELSE -- for one phase 2572: htp.p(' 2573: ' COLSPAN="2">'|| g_phase 2574: || ' ' || v_phase || ' 2580: IF (one_node.parent_node_id IS NULL) THEN 2581: IF (v_count > 0) THEN 2582: print_back_to_top(2); 2583: END IF; 2584: htp.p(' 2585: 'NOWRAP>' || 2588: one_node.hierarchy ||' ' || 2634: PROCEDURE print_back_to_top (p_col_span IN NUMBER) IS 2635: 2636: BEGIN 2637: 2638: htp.p(' ' || 2639: '' || g_back_top || ' '); 2703: *-----------------------------------------------------------------------*/ 2704: PROCEDURE print_context_subheader(p_context IN VARCHAR2) IS 2705: 2706: BEGIN 2707: htp.p(' '); 2708: htp.p(''); 2721: htp.p(''); 2722: htp.p(' '); 2709: htp.p(''); 2710: htp.p(''); 2711: htp.p(''); 2721: htp.p(''); 2722: htp.p('     '|| g_ctxt_type || '   ' || Line 2708: htp.p(' '); 2704: PROCEDURE print_context_subheader(p_context IN VARCHAR2) IS 2705: 2706: BEGIN 2707: htp.p(''); 2708: htp.p(' '); 2709: htp.p(''); 2710: htp.p(''); 2711: htp.p(''); Line 2709: htp.p('     '|| g_ctxt_type || '   ' || 2712: get_translation('AZ_CONTEXT_TYPE', p_context) ||' '); 2705: 2706: BEGIN 2707: htp.p(' '); 2708: htp.p(''); 2706: BEGIN 2707: htp.p(' '); 2709: htp.p(''); 2710: htp.p(''); 2711: htp.p(''); 2713: htp.p('     '|| g_ctxt_type || '   ' || 2712: get_translation('AZ_CONTEXT_TYPE', p_context) ||' '); Line 2710: htp.p('     '); 2708: htp.p(''); Line 2718: htp.p(' '); 2714: htp.p(' '); 2721: htp.p(''); 2722: htp.p(' '); 2709: htp.p(''); 2710: htp.p(''); 2711: htp.p(''); 2713: htp.p('     '|| g_ctxt_type || '   ' || 2712: get_translation('AZ_CONTEXT_TYPE', p_context) ||' '); 2714: htp.p(' '); Line 2711: htp.p(' '|| g_ctxt_type || '   ' || 2707: htp.p(''); 2708: htp.p(''); 2713: htp.p(' '); 2709: htp.p(''); 2710: htp.p(''); 2711: htp.p(''); 2713: htp.p('     '|| g_ctxt_type || '   ' || 2712: get_translation('AZ_CONTEXT_TYPE', p_context) ||' '); 2714: htp.p(' '); 2715: htp.p(''); Line 2713: htp.p(' '); 2709: htp.p(''); 2710: htp.p(''); 2711: htp.p(''); 2713: htp.p('     '|| g_ctxt_type || '   ' || 2712: get_translation('AZ_CONTEXT_TYPE', p_context) ||' '); 2714: htp.p(' '); 2715: htp.p(''); 2716: htp.p(''); Line 2714: htp.p(' '); 2711: htp.p(''); 2713: htp.p(' ' || g_as_of || '   '|| 2717: FND_DATE.date_to_displayDT(SYSDATE) || ' '); 2710: htp.p('     '|| g_ctxt_type || '   ' || 2712: get_translation('AZ_CONTEXT_TYPE', p_context) ||' '); 2714: htp.p(' '); 2715: htp.p(''); 2716: htp.p(''); 2718: htp.p(''); Line 2715: htp.p(' ' || g_as_of || '   '|| 2717: FND_DATE.date_to_displayDT(SYSDATE) || '     '); 2711: htp.p(' '); 2713: htp.p(' '|| g_ctxt_type || '   ' || 2712: get_translation('AZ_CONTEXT_TYPE', p_context) ||' '); 2714: htp.p(' '); 2715: htp.p(''); 2716: htp.p(''); 2718: htp.p(''); 2719: htp.p(' ' || g_as_of || '   '|| 2717: FND_DATE.date_to_displayDT(SYSDATE) || '     '); Line 2716: htp.p(' ' || g_as_of || '   '|| 2712: get_translation('AZ_CONTEXT_TYPE', p_context) ||' '); 2714: htp.p(' '); 2715: htp.p(''); 2716: htp.p(''); 2718: htp.p(''); 2719: htp.p(' ' || g_as_of || '   '|| 2717: FND_DATE.date_to_displayDT(SYSDATE) || '     '); 2720: htp.p('     '); 2715: htp.p(''); 2716: htp.p(''); 2718: htp.p(''); 2719: htp.p(' ' || g_as_of || '   '|| 2717: FND_DATE.date_to_displayDT(SYSDATE) || '     '); 2720: htp.p(' '); Line 2719: htp.p(' '); 2715: htp.p(''); 2716: htp.p(''); 2718: htp.p(''); 2719: htp.p(' ' || g_as_of || '   '|| 2717: FND_DATE.date_to_displayDT(SYSDATE) || '     '); 2720: htp.p(' '); 2723: htp.p(''); Line 2720: htp.p(''); 2716: htp.p(' '); 2718: htp.p(''); 2719: htp.p(' ' || g_as_of || '   '|| 2717: FND_DATE.date_to_displayDT(SYSDATE) || '     '); 2720: htp.p(' '); 2723: htp.p(''); 2724: htp.p(''); Line 2721: htp.p(''); 2717: FND_DATE.date_to_displayDT(SYSDATE) || ''); 2718: htp.p(' '); 2719: htp.p(''); 2720: htp.p(''); 2721: htp.p(' '); 2723: htp.p(''); 2724: htp.p(''); 2725: htp.p(''); Line 2722: htp.p(' '); 2718: htp.p('     '); 2720: htp.p('

');
2723: htp.p('');
2724: htp.p('');
2725: htp.p('');
2726: htp.p('
');

Line 2723: htp.p('');

2719: htp.p('

');
2720: htp.p('');
2721: htp.p('');
2722: htp.p('');
2723: htp.p('');
2724: htp.p('');
2725: htp.p('');
2726: htp.p('
');
2727:

Line 2724: htp.p('');

2720: htp.p('');
2721: htp.p('');
2722: htp.p('');
2723: htp.p('');
2724: htp.p('');
2725: htp.p('');
2726: htp.p('
');
2727:
2728: EXCEPTION

Line 2725: htp.p('');

2721: htp.p('');
2722: htp.p('');
2723: htp.p('');
2724: htp.p('');
2725: htp.p('');
2726: htp.p('
');
2727:
2728: EXCEPTION
2729: WHEN application_exception THEN

Line 2726: htp.p('
');

2722: htp.p('');
2723: htp.p('');
2724: htp.p('');
2725: htp.p('');
2726: htp.p('
');
2727:
2728: EXCEPTION
2729: WHEN application_exception THEN
2730: RAISE;

Line 2746: htp.nl;

2742: PROCEDURE print_imp_start_page IS
2743: v_link VARCHAR2(240);
2744: BEGIN
2745:
2746: htp.nl;
2747: htp.nl;
2748: htp.p('');
2749:
2750: htp.p('');
2787:
2788: htp.p('

'); Line 2747: htp.nl; 2743: v_link VARCHAR2(240); 2744: BEGIN 2745: 2746: htp.nl; 2747: htp.nl; 2748: htp.p(' '); 2749: 2750: htp.p(''); 2787: 2788: htp.p(' '); 2751: Line 2748: htp.p(' '); 2744: BEGIN 2745: 2746: htp.nl; 2747: htp.nl; 2748: htp.p(' '); 2749: 2750: htp.p(''); 2787: 2788: htp.p(' '); 2751: 2752: -- display hyper-linked reports in group 1 Line 2750: htp.p(' '); 2759: 2760: htp.p(''); 2761: htp.p(''); 2759: 2760: htp.p(''); 2761: htp.p(' '); 2746: htp.nl; 2747: htp.nl; 2748: htp.p(' '); 2749: 2750: htp.p(''); 2754: htp.p(' '); 2755: htp.p(''); 2757: 2758: htp.p(' '); 2751: 2752: -- display hyper-linked reports in group 1 2753: htp.tableRowOpen; 2754: htp.p(''); Line 2753: htp.tableRowOpen; 2749: 2750: htp.p(' '); 2759: Line 2758: htp.p(' '); 2751: 2752: -- display hyper-linked reports in group 1 2753: htp.tableRowOpen; 2754: htp.p(''); 2755: htp.p(''); 2757: Line 2754: htp.p(' '); 2750: htp.p(' '); Line 2755: htp.p(' '); 2755: htp.p(''); 2757: 2758: htp.p(' '|| 2756: ''|| g_planning ||' '); 2751: 2752: -- display hyper-linked reports in group 1 2753: htp.tableRowOpen; 2754: htp.p(''); 2755: htp.p(''); 2757: 2758: htp.p(' '|| 2756: ''|| g_planning ||' '|| 2751: 2752: -- display hyper-linked reports in group 1 2753: htp.tableRowOpen; 2754: htp.p(' '|| 2756: ''|| g_planning ||' '|| 2756: ''|| g_planning ||' '); 2762: Line 2760: htp.p(' '); 2756: ''|| g_planning ||''); 2757: 2758: htp.p(' '); 2762: 2763: v_link := get_report_procedure('AZW_RPT_IPR'); 2764: htp.p(''); 2759: 2760: htp.p(''); 2761: htp.p(''); 2785: htp.p(' '|| Line 2761: htp.p(' '); 2757: 2758: htp.p(' '); 2762: 2763: v_link := get_report_procedure('AZW_RPT_IPR'); 2764: htp.p(''); 2761: htp.p(' '|| 2765: ''|| 2760: htp.p(' '); 2762: 2763: v_link := get_report_procedure('AZW_RPT_IPR'); 2764: htp.p(''); Line 2771: htp.p(' '); 2769: 2770: v_link := get_report_procedure('AZW_RPT_PPR'); 2771: htp.p(''); 2777: 2778: v_link := get_report_procedure('AZW_RPT_CPR'); 2779: htp.p(' '|| 2765: ''|| g_ipr ||' '|| 2767: g_web_agent || v_link||'" OnMouseOver="window.status=' || 2768: '''' || g_ipr_desc || '''' || ';return true;">'|| g_ipr ||' '|| 2772: '' Line 2779: htp.p(' '|| 2775: '''' || g_ppr_desc || '''' || ';return true;">' 2776: || g_ppr||' '|| 2780: '' Line 2785: htp.p(' '); 2781: g_cpr_desc || '">' 2784: || g_cpr||' '); 2786: htp.p(' '); 2789: htp.p(' '); Line 2786: htp.p(' '); 2782: g_web_agent|| v_link||'" OnMouseOver="window.status=' || 2783: '''' || g_cpr_desc || '''' || ';return true;">' 2784: || g_cpr||' '); 2785: htp.p(' '); 2786: htp.p(' '); 2789: htp.p(' '); 2790: Line 2788: htp.p(' '); 2784: || g_cpr||''); 2785: htp.p(' '); 2786: htp.p('

');
2789: htp.p('');
2787:
2788: htp.p('

'); 2790: 2791: -- display hyper-linked reports in group 2 2792: htp.tableRowOpen; Line 2789: htp.p(' '); 2785: htp.p(' '); 2786: htp.p('

');
2789: htp.p('');
2797:
2798: htp.p('');

Line 2796: htp.p('

'); 2790: 2791: -- display hyper-linked reports in group 2 2792: htp.tableRowOpen; 2793: htp.p(''); Line 2792: htp.tableRowOpen; 2788: htp.p(' '); 2789: htp.p(''); Line 2793: htp.p(' '); 2789: htp.p(' '); 2797: Line 2794: htp.p(' '); 2794: htp.p(''); 2796: htp.p(' '); 2790: 2791: -- display hyper-linked reports in group 2 2792: htp.tableRowOpen; 2793: htp.p(''); 2794: htp.p(''); 2796: htp.p(' '|| 2795: ''|| g_monitor ||' '); 2790: 2791: -- display hyper-linked reports in group 2 2792: htp.tableRowOpen; 2793: htp.p(''); 2794: htp.p(''); 2796: htp.p(' '|| 2795: ''|| g_monitor ||' '|| 2790: 2791: -- display hyper-linked reports in group 2 2792: htp.tableRowOpen; 2793: htp.p(' '|| 2795: ''|| g_monitor ||'

');

2792: htp.tableRowOpen;
2793: htp.p('
');
2794: htp.p(''||
2795: ''|| g_monitor ||'');
2796: htp.p('');
2797:
2798: htp.p('
');
2799: htp.p('');
2800:

Line 2798: htp.p('

');

2794: htp.p('

');
2796: htp.p('

'|| 2795: ''|| g_monitor ||'

');
2797:
2798: htp.p('
');
2799: htp.p('');
2800:
2801: v_link := get_report_procedure('AZW_RPT_ISR');
2802: htp.p('');
2797:
2798: htp.p('');
2799: htp.p('');
2816:
2817: htp.p('');
2818: htp.p('

'|| Line 2799: htp.p('

'); 2795: ''|| g_monitor ||''); 2796: htp.p('

'); 2800: 2801: v_link := get_report_procedure('AZW_RPT_ISR'); 2802: htp.p(''); 2799: htp.p(''); 2820: 2821: htp.tableClose; Line 2818: htp.p(' '|| 2803: ''|| 2798: htp.p(' '); 2800: 2801: v_link := get_report_procedure('AZW_RPT_ISR'); 2802: htp.p(''); 2808: 2809: v_link := get_report_procedure('AZW_RPT_UPR'); 2810: htp.p(''); 2813: g_web_agent|| v_link||'" OnMouseOver="window.status=' || 2814: '''' || g_upr_desc || '''' || ';return true;">' 2815: ||g_upr||' (' || g_mode_label || ')'||' '); 2816: 2817: htp.p(''); 2818: htp.p(' '|| 2803: '' Line 2810: htp.p(' '|| 2806: '''' || g_isr_desc || '''' || ';return true;">' 2807: ||g_isr||' (' || g_mode_label || ')'||' '|| 2811: '' Line 2817: htp.p(' '); 2819: htp.p(' '); 2814: '''' || g_upr_desc || '''' || ';return true;">' 2815: ||g_upr||' (' || g_mode_label || ')'||'

');
2819: htp.p('');
2820:
2821: htp.tableClose;
2822:

Line 2819: htp.p('');

2815: ||g_upr||' (' || g_mode_label || ')'||'');
2816:
2817: htp.p('');
2818: htp.p('
');
2819: htp.p('');
2820:
2821: htp.tableClose;
2822:
2823: EXCEPTION

Line 2821: htp.tableClose;

2817: htp.p('');
2818: htp.p('
');
2819: htp.p('');
2820:
2821: htp.tableClose;
2822:
2823: EXCEPTION
2824: WHEN application_exception THEN
2825: RAISE;

Line 2840: htp.nl;

2836: PROCEDURE print_upgrade_start_page IS
2837: v_link VARCHAR2(240);
2838: BEGIN
2839:
2840: htp.nl;
2841: htp.nl;
2842: htp.p('');
2843:
2844: htp.p('');
2876:
2877: htp.tableClose;
2878: EXCEPTION
2879: WHEN application_exception THEN

Line 2877: htp.tableClose;

2873: htp.p('');
2874: htp.p('

'); Line 2841: htp.nl; 2837: v_link VARCHAR2(240); 2838: BEGIN 2839: 2840: htp.nl; 2841: htp.nl; 2842: htp.p(' '); 2843: 2844: htp.p(''); 2853: 2854: htp.p(''); 2855: htp.p(''); 2853: 2854: htp.p(''); 2855: htp.p(''); 2876: 2877: htp.tableClose; 2878: EXCEPTION Line 2875: htp.p(''); 2871: ||g_upr||' (' || g_mode_label || ')'||' '); 2872: 2873: htp.p(''); 2874: htp.p(' '); 2845: Line 2842: htp.p(' '); 2838: BEGIN 2839: 2840: htp.nl; 2841: htp.nl; 2842: htp.p(' '); 2843: 2844: htp.p(''); 2848: htp.tableRowOpen; 2849: htp.p(' '); 2850: htp.p(''); 2852: htp.p(' '); 2845: 2846: -- display hyper-linked reports in group 2 Line 2844: htp.p(' '); 2853: 2854: htp.p(''); Line 2852: htp.p(' '); 2840: htp.nl; 2841: htp.nl; 2842: htp.p(' '); 2843: 2844: htp.p(''); 2853: Line 2850: htp.p(' '); 2850: htp.p(''); 2852: htp.p(' '); 2845: 2846: -- display hyper-linked reports in group 2 2847: 2848: htp.tableRowOpen; Line 2848: htp.tableRowOpen; 2844: htp.p(' '); Line 2849: htp.p(' '); 2845: 2846: -- display hyper-linked reports in group 2 2847: 2848: htp.tableRowOpen; 2849: htp.p(' '); 2850: htp.p(''); 2852: htp.p(' '); 2845: 2846: -- display hyper-linked reports in group 2 2847: 2848: htp.tableRowOpen; 2849: htp.p(''); 2850: htp.p(''); 2852: htp.p(' '|| 2851: ''|| g_monitor ||' '|| 2851: ''|| g_monitor ||' '|| 2846: -- display hyper-linked reports in group 2 2847: 2848: htp.tableRowOpen; 2849: htp.p(' '|| 2851: ''|| g_monitor ||' '|| 2851: ''|| g_monitor ||' '); 2856: Line 2854: htp.p(' '); 2850: htp.p(' '); 2852: htp.p(' '|| 2851: ''|| g_monitor ||' '); 2856: 2857: v_link := get_report_procedure('AZW_RPT_ISR'); 2858: htp.p(''); 2853: 2854: htp.p(''); 2855: htp.p(''); 2872: 2873: htp.p(''); 2874: htp.p(' '|| Line 2855: htp.p(' '); 2851: ''|| g_monitor ||''); 2852: htp.p(' '); 2856: 2857: v_link := get_report_procedure('AZW_RPT_ISR'); 2858: htp.p(''); 2855: htp.p(''); 2876: 2877: htp.tableClose; Line 2874: htp.p(' '|| 2859: ''|| 2854: htp.p(' '); 2856: 2857: v_link := get_report_procedure('AZW_RPT_ISR'); 2858: htp.p(''); 2864: 2865: v_link := get_report_procedure('AZW_RPT_UPR'); 2866: htp.p(''); 2869: g_web_agent|| v_link||'" OnMouseOver="window.status=' || 2870: '''' || g_upr_desc || '''' || ';return true;">' 2871: ||g_upr||' (' || g_mode_label || ')'||' '); 2872: 2873: htp.p(''); 2874: htp.p(' '|| 2859: '' Line 2866: htp.p(' '|| 2862: '''' || g_isr_desc || '''' || ';return true;">' 2863: ||g_isr||' (' || g_mode_label || ')'||' '|| 2867: '' Line 2873: htp.p(' '); 2875: htp.p(' '); 2870: '''' || g_upr_desc || '''' || ';return true;">' 2871: ||g_upr||' (' || g_mode_label || ')'||' '); 2875: htp.p(' '); 2875: htp.p('

');
2875: htp.p('');
2876:
2877: htp.tableClose;
2878: EXCEPTION
2879: WHEN application_exception THEN
2880: RAISE;
2881: WHEN OTHERS THEN

Line 2899: htp.p('');

2895: */
2896: PROCEDURE print_ipr_report_parameters (p_phase IN VARCHAR2) IS
2897:
2898: BEGIN
2899: htp.p('

');
2900: htp.p('');
2901: htp.p(' ');
2919: htp.p('');
2920: htp.p('

'); 2902: htp.p(' '); 2903: htp.p(' '); Line 2900: htp.p(' '); 2896: PROCEDURE print_ipr_report_parameters (p_phase IN VARCHAR2) IS 2897: 2898: BEGIN 2899: htp.p(' '); 2900: htp.p(''); 2901: htp.p(' '); 2919: htp.p(''); 2920: htp.p(' '); 2902: htp.p(' '); 2903: htp.p(' '); 2904: htp.p(' '); 2914: htp.p(' '); 2916: htp.p(' '); 2917: htp.p('     '|| g_phase || '   '); Line 2901: htp.p(' '); 2897: 2898: BEGIN 2899: htp.p(''); 2900: htp.p(''); 2901: htp.p(' '); 2919: htp.p(''); 2920: htp.p(' '); 2902: htp.p(' '); 2903: htp.p(' '); 2904: htp.p('     '|| g_phase || '   '); 2905: IF (p_phase IS NOT NULL) THEN Line 2902: htp.p(' '); 2898: BEGIN 2899: htp.p(' '); 2900: htp.p(''); 2901: htp.p(' '); Line 2916: htp.p(' '); 2912: htp.p(' '); 2919: htp.p(''); 2920: htp.p(' '); 2902: htp.p(' '); 2903: htp.p(' '); 2904: htp.p(' '); 2899: htp.p('     '|| g_phase || '   '); 2905: IF (p_phase IS NOT NULL) THEN 2906: htp.p(p_phase); Line 2903: htp.p('     '); 2900: htp.p(''); 2901: htp.p(' '); 2911: htp.p(' '); 2902: htp.p(' '); 2903: htp.p(' '); 2904: htp.p(' '); 2901: htp.p(' '); 2911: htp.p('     '|| g_phase || '   '); 2905: IF (p_phase IS NOT NULL) THEN 2906: htp.p(p_phase); 2907: ELSE Line 2904: htp.p(' '|| g_phase || '   '); 2900: htp.p(' '); 2902: htp.p(' '); 2903: htp.p(' '); 2904: htp.p(' '); 2906: htp.p(p_phase); 2907: ELSE 2908: htp.p(g_all); 2909: END IF; 2910: htp.p(''); 2911: htp.p('     '|| g_phase || '   '); 2905: IF (p_phase IS NOT NULL) THEN 2906: htp.p(p_phase); 2907: ELSE 2908: htp.p(g_all); Line 2906: htp.p(p_phase); 2902: htp.p(' '); 2903: htp.p(' '); 2904: htp.p(' '); Line 2908: htp.p(g_all); 2904: htp.p(' '); 2911: htp.p('     '|| g_phase || '   '); 2905: IF (p_phase IS NOT NULL) THEN 2906: htp.p(p_phase); 2907: ELSE 2908: htp.p(g_all); 2909: END IF; 2910: htp.p(' '|| g_phase || '   '); 2905: IF (p_phase IS NOT NULL) THEN 2906: htp.p(p_phase); 2907: ELSE 2908: htp.p(g_all); 2909: END IF; 2910: htp.p(' '); 2912: htp.p(' '); Line 2910: htp.p(' '); 2912: htp.p(' '); 2913: htp.p(' '); 2914: htp.p(' ' || g_as_of || '   '|| Line 2911: htp.p(' '); 2907: ELSE 2908: htp.p(g_all); 2909: END IF; 2910: htp.p(' '); 2912: htp.p(' '); 2913: htp.p(' '); 2914: htp.p(' '); Line 2912: htp.p(' '); 2911: htp.p(' ' || g_as_of || '   '|| 2915: FND_DATE.date_to_displayDT(SYSDATE) || ' '); 2908: htp.p(g_all); 2909: END IF; 2910: htp.p(' '); 2912: htp.p(' '); 2913: htp.p(' '); 2914: htp.p(' '); 2916: htp.p(' '); Line 2913: htp.p(' ' || g_as_of || '   '|| 2915: FND_DATE.date_to_displayDT(SYSDATE) || '     '); 2909: END IF; 2910: htp.p(''); 2911: htp.p(' '); 2912: htp.p(' '); 2913: htp.p(' '); 2914: htp.p(' '); 2916: htp.p(' '); 2917: htp.p(' ' || g_as_of || '   '|| 2915: FND_DATE.date_to_displayDT(SYSDATE) || '     '); Line 2914: htp.p(' ' || g_as_of || '   '|| 2910: htp.p(' '); 2912: htp.p(' '); 2913: htp.p(' '); 2914: htp.p(' '); 2916: htp.p(' '); 2917: htp.p(' ' || g_as_of || '   '|| 2915: FND_DATE.date_to_displayDT(SYSDATE) || '     '); 2918: htp.p('     '); 2913: htp.p(' '); 2914: htp.p(' '); 2916: htp.p(' '); 2917: htp.p(' ' || g_as_of || '   '|| 2915: FND_DATE.date_to_displayDT(SYSDATE) || '     '); 2918: htp.p(' '); Line 2917: htp.p(' '); 2913: htp.p(' '); 2914: htp.p(' '); 2916: htp.p(' '); 2917: htp.p(' ' || g_as_of || '   '|| 2915: FND_DATE.date_to_displayDT(SYSDATE) || '     '); 2918: htp.p(' '); 2921: htp.p(''); Line 2918: htp.p(' ' || g_as_of || '   '|| 2915: FND_DATE.date_to_displayDT(SYSDATE) || '     '); 2918: htp.p(' '); 2921: htp.p(''); 2922: htp.p(''); Line 2919: htp.p(''); 2915: FND_DATE.date_to_displayDT(SYSDATE) || ''); 2916: htp.p(' '); 2917: htp.p(' '); 2918: htp.p('

');
2921: htp.p('');
2922: htp.p('');
2923: htp.p('');

Line 2920: htp.p('

');

2916: htp.p('   ');
2917: htp.p(' ');
2918: htp.p(' ');
2919: htp.p('');
2920: htp.p('');
2921: htp.p('');
2922: htp.p('');
2923: htp.p('');
2924: htp.p('');

Line 2921: htp.p('');

2917: htp.p(' ');
2918: htp.p(' ');
2919: htp.p('');
2920: htp.p('');
2921: htp.p('');
2922: htp.p('');
2923: htp.p('');
2924: htp.p('');
2925: htp.p('
');

Line 2922: htp.p('');

2918: htp.p(' ');
2919: htp.p('');
2920: htp.p('

');
2921: htp.p('');
2922: htp.p('');
2923: htp.p('');
2924: htp.p('');
2925: htp.p('
');
2926:

Line 2923: htp.p('');

2919: htp.p('');
2920: htp.p('');
2921: htp.p('');
2922: htp.p('');
2923: htp.p('');
2924: htp.p('');
2925: htp.p('
');
2926:
2927: EXCEPTION

Line 2924: htp.p('');

2920: htp.p('');
2921: htp.p('');
2922: htp.p('');
2923: htp.p('');
2924: htp.p('');
2925: htp.p('
');
2926:
2927: EXCEPTION
2928: WHEN application_exception THEN

Line 2925: htp.p('
');

2921: htp.p('');
2922: htp.p('');
2923: htp.p('');
2924: htp.p('');
2925: htp.p('
');
2926:
2927: EXCEPTION
2928: WHEN application_exception THEN
2929: RAISE;

Line 2967: htp.p('');

2963: v_count PLS_INTEGER;
2964: v_locator PLS_INTEGER := 0;
2965: BEGIN
2966: -- Print the Table header
2967: htp.p('

');
2968: htp.p('');
2970:
2971: -- open the correspondig cursor according to the p_phase argument.

Line 2968: htp.p('

' || 2969: ''|| g_installed ||'

' || 2964: v_locator PLS_INTEGER := 0; 2965: BEGIN 2966: -- Print the Table header 2967: htp.p(''); 2968: htp.p(''); 2970: 2971: -- open the correspondig cursor according to the p_phase argument. 2972: IF (p_phase IS NULL) THEN Line 2997: htp.p(' '); 2993: IF (v_count = 0 OR v_prev_phase <> product_rec.phase) THEN 2994: IF (v_count > 0 AND MOD(v_count, 2) = 1) THEN 2995: -- display an empty table data and close 2996: -- both table data and table row 2997: htp.p(' '); 2998: v_count := v_count + 1; 2999: END IF; 3000: -- Display the phase number header. 3001: htp.p(''); 2998: v_count := v_count + 1; 2999: END IF; 3000: -- Display the phase number header. 3001: htp.p(''); 3004: -- Display the product name in the first column 3005: htp.p(''); Line 3005: htp.p(' '); 3001: htp.p(' '); 3004: -- Display the product name in the first column 3005: htp.p(''); 3006: ELSE 3007: IF (MOD(v_count, 2) = 0) THEN -- if v_count is even then new record for the same phase 3008: -- Display the product name in the first column 3009: htp.p(''); Line 3009: htp.p(' '); 3005: htp.p(' '); 3006: ELSE 3007: IF (MOD(v_count, 2) = 0) THEN -- if v_count is even then new record for the same phase 3008: -- Display the product name in the first column 3009: htp.p(''); 3010: ELSE 3011: -- Display the product name in the Second column 3012: htp.p(''); 3013: END IF; Line 3012: htp.p(' '); 3008: -- Display the product name in the first column 3009: htp.p(' '); 3010: ELSE 3011: -- Display the product name in the Second column 3012: htp.p(''); 3013: END IF; 3014: END IF; 3015: v_count := v_count + 1; 3016: v_prev_phase := product_rec.phase; Line 3026: htp.p(' '); 3022: v_locator := 6; 3023: CLOSE per_phase; 3024: END IF; 3025: IF (v_count > 0 AND MOD(v_count, 2) = 1) THEN 3026: htp.p(' '); 3027: END IF; 3028: -- If there are no products installed 3029: IF (v_count = 0) THEN 3030: htp.p(''); Line 3030: htp.p(' '); 3026: htp.p(' '); 3027: END IF; 3028: -- If there are no products installed 3029: IF (v_count = 0) THEN 3030: htp.p(''); 3031: END IF; 3032: htp.p(' ' || 2969: ''|| g_installed ||'     ' || Line 3001: htp.p(' ' || 2997: htp.p('   ' || 3002: ' '|| g_phase || ' ' || 3003: product_rec.phase ||' '|| product_rec.name ||' '|| product_rec.name ||' ' || 3002: ' '|| g_phase || ' ' || 3003: product_rec.phase ||' '|| product_rec.name ||' '|| product_rec.name ||' '|| product_rec.name ||' '|| product_rec.name ||' '|| product_rec.name ||' '|| product_rec.name ||' '|| product_rec.name ||' '|| product_rec.name ||' '|| product_rec.name ||'     ' || g_no_prod_inst || ' ' || g_no_prod_inst || '   ' || g_no_prod_inst || ' '); 3033: return; 3034: Line 3032: htp.p('

');

3028: -- If there are no products installed
3029: IF (v_count = 0) THEN
3030: htp.p('' || g_no_prod_inst || '');
3031: END IF;
3032: htp.p('
');
3033: return;
3034:
3035: EXCEPTION
3036: WHEN application_exception THEN

Line 3064: htp.p('');

3060: v_locator PLS_INTEGER := 0;
3061: BEGIN
3062: -- Print the Table header
3063:
3064: htp.p('

');
3065: htp.p('');
3068: htp.p('');

Line 3065: htp.p('

' || 3066: '' || 3067: g_summary ||'

' || 3061: BEGIN 3062: -- Print the Table header 3063: 3064: htp.p(''); 3065: htp.p(''); 3068: htp.p(''); 3069: htp.p(''); 3064: htp.p(' ' || 3066: '' || 3067: g_summary ||' '|| Line 3068: htp.p(' '); 3065: htp.p(''); 3068: htp.p(''); 3069: htp.p(''); 3071: htp.p(''); Line 3069: htp.p(' '); 3068: htp.p(''); 3069: htp.p(''); 3071: htp.p(''); 3073: htp.p(''); 3068: htp.p(''); 3069: htp.p(''); 3071: htp.p(''); 3073: htp.p(''); 3075: htp.p(''); 3071: htp.p(''); 3073: htp.p(''); 3075: htp.p(''); 3077: htp.p(''); Line 3075: htp.p(' '); 3073: htp.p(''); 3075: htp.p(''); 3077: htp.p(''); 3078: 3079: -- Line 3077: htp.p(''); 3073: htp.p(' '); 3075: htp.p(''); 3077: htp.p(''); 3078: 3079: -- 3080: -- Select the report summary data and populate the array with it. 3081: -- Line 3098: htp.p(' '); 3094: IF (v_count = 0 OR v_prev_phase <> process_groups(i).phase) THEN 3095: IF (v_count > 0 AND MOD(v_count, 2) = 1) THEN 3096: -- display an empty table data and close 3097: -- both table data and table row 3098: htp.p(' '); 3099: v_count := v_count + 1; 3100: END IF; 3101: IF (process_groups(i).phase > 0) THEN 3102: -- Display the phase number header. Line 3103: htp.p(' '); 3106: END IF; 3107: -- Display the product name in the first column Line 3108: htp.p(' ' || 3104: '' || g_phase || ' ' || 3105: process_groups(i).phase || ' '); 3106: END IF; 3107: -- Display the product name in the first column 3108: htp.p('' || 3109: ''); 3110: ELSE 3111: -- if v_count is even then new record for the same phase 3112: IF (MOD(v_count, 2) = 0) THEN Line 3114: htp.p(' '); 3116: ELSE 3117: -- Display the product name in the Second column 3118: htp.p(''); 3116: ELSE 3117: -- Display the product name in the Second column 3118: htp.p(''); 3120: END IF; 3121: END IF; 3122: v_count := v_count + 1; Line 3127: htp.p(' '); 3123: v_prev_phase := process_groups(i).phase; 3124: END LOOP; 3125: -- if v_count is odd then we need to close with an empty table data 3126: IF (MOD(v_count, 2) = 1) THEN 3127: htp.p(' '); 3128: END IF; 3129: htp.p(' ' || 3066: '' || 3067: g_summary ||' '|| 3070: g_process_group ||' '|| 3072: g_num_procs ||' '|| 3065: htp.p(' ' || 3066: '' || 3067: g_summary ||' '|| 3070: g_process_group ||' '|| 3072: g_num_procs ||' '|| Line 3071: htp.p(' '|| 3067: g_summary ||' '|| 3070: g_process_group ||' '|| 3072: g_num_procs ||' '|| 3074: g_process_group ||' '|| Line 3073: htp.p(' '|| 3069: htp.p(' '|| 3070: g_process_group ||' '|| 3072: g_num_procs ||' '|| 3074: g_process_group ||' '|| 3076: g_num_procs ||' '|| 3071: htp.p(' '|| 3072: g_num_procs ||' '|| 3074: g_process_group ||' '|| 3076: g_num_procs ||' '|| 3074: g_process_group ||' '|| 3076: g_num_procs ||'         ' || 3099: v_count := v_count + 1; 3100: END IF; 3101: IF (process_groups(i).phase > 0) THEN 3102: -- Display the phase number header. 3103: htp.p(' ' || 3104: '' || g_phase || ' ' || 3105: process_groups(i).phase || ' '|| v_display_data ||' '|| v_display_data ||' '|| process_groups(i).processes_count || ' '|| v_display_data ||' ' 3110: ELSE 3111: -- if v_count is even then new record for the same phase 3112: IF (MOD(v_count, 2) = 0) THEN 3113: -- Display the product name in the first column 3114: htp.p(' '|| v_display_data ||' ' 3115: || process_groups(i).processes_count ||' '|| v_display_data || ' '|| Line 3118: htp.p(' '|| v_display_data || ' '|| 3114: htp.p(' '|| v_display_data ||' ' 3115: || process_groups(i).processes_count ||' '|| v_display_data || ' '|| 3119: process_groups(i).processes_count ||'         '); 3130: return; 3131: Line 3129: htp.p('

');

3125: -- if v_count is odd then we need to close with an empty table data
3126: IF (MOD(v_count, 2) = 1) THEN
3127: htp.p('  ');
3128: END IF;
3129: htp.p('
');
3130: return;
3131:
3132: EXCEPTION
3133: WHEN application_exception THEN

Line 3269: htp.p('

3265: print_report_header (p_title, FALSE, NULL);
3266: END IF;
3267:
3268:
3269: htp.p('

3270: 'width="96%">');
3271: htp.p('');
3272: htp.p('');

Line 3271: htp.p('

');

3267:
3268:
3269: htp.p('

'|| 3273: g_param_hdr ||'

3270: 'width="96%">');
3271: htp.p('');
3272: htp.p('');
3274: htp.p('');
3275: htp.p('');
3272: htp.p('');
3274: htp.p('');
3275: htp.p('');
3277: htp.p('');
3278: htp.p('

'|| 3273: g_param_hdr ||'

'|| Line 3272: htp.p('

'|| 3268: 3269: htp.p(' 3270: 'width="96%">'); 3271: htp.p(''); 3272: htp.p(''); 3274: htp.p(''); 3275: htp.p(''); Line 3274: htp.p(' '); 3270: 'width="96%">'); 3271: htp.p(' '); 3272: htp.p(''); 3274: htp.p(''); 3275: htp.p(''); 3277: htp.p(''); 3278: htp.p(' '|| 3273: g_param_hdr ||' '|| 3276: g_param_note ||' '|| 3273: g_param_hdr ||' '|| 3276: g_param_note ||' '); Line 3275: htp.p('

'|| 3271: htp.p('

'|| 3273: g_param_hdr ||'

'|| 3276: g_param_note ||'

');
3279:

Line 3277: htp.p('
');

3273: g_param_hdr ||'');
3274: htp.p('
');
3275: htp.p(''||
3276: g_param_note ||'');
3277: htp.p('
');
3278: htp.p('');
3279:
3280: EXCEPTION
3281: WHEN application_exception THEN

Line 3278: htp.p('');

3274: htp.p('
');
3275: htp.p(''||
3276: g_param_note ||'');
3277: htp.p('
');
3278: htp.p('');
3279:
3280: EXCEPTION
3281: WHEN application_exception THEN
3282: RAISE;

Line 3303: htp.p('');

3299: print_footer_separator_line();
3300: -- Print the ok and cancel buttons
3301: print_ok_cancel_buttons('javascript:void(document.Form1.submit())');
3302:
3303: htp.p('');
3304: htp.centerClose;
3305: htp.bodyClose;
3306: htp.htmlClose;
3307:

Line 3304: htp.centerClose;

3300: -- Print the ok and cancel buttons
3301: print_ok_cancel_buttons('javascript:void(document.Form1.submit())');
3302:
3303: htp.p('');
3304: htp.centerClose;
3305: htp.bodyClose;
3306: htp.htmlClose;
3307:
3308: EXCEPTION

Line 3305: htp.bodyClose;

3301: print_ok_cancel_buttons('javascript:void(document.Form1.submit())');
3302:
3303: htp.p('');
3304: htp.centerClose;
3305: htp.bodyClose;
3306: htp.htmlClose;
3307:
3308: EXCEPTION
3309: WHEN application_exception THEN

Line 3306: htp.htmlClose;

3302:
3303: htp.p('');
3304: htp.centerClose;
3305: htp.bodyClose;
3306: htp.htmlClose;
3307:
3308: EXCEPTION
3309: WHEN application_exception THEN
3310: RAISE;

Line 3326: htp.p('
');

3322: *--------------------------------------------------------------------------*/
3323: PROCEDURE print_footer_separator_line IS
3324:
3325: BEGIN
3326: htp.p('
');
3327: htp.p('
');
3328: -- light grey single pixel separator line between parameters and buttons
3329: htp.p('' ||
3330: '');

Line 3327: htp.p('
');

3323: PROCEDURE print_footer_separator_line IS
3324:
3325: BEGIN
3326: htp.p('
');
3327: htp.p('
');
3328: -- light grey single pixel separator line between parameters and buttons
3329: htp.p('' ||
3330: '');
3331: htp.p('
');

Line 3329: htp.p('' ||

3325: BEGIN
3326: htp.p('
');
3327: htp.p('
');
3328: -- light grey single pixel separator line between parameters and buttons
3329: htp.p('' ||
3330: '');
3331: htp.p('
');
3332: htp.p('');
3333:

Line 3331: htp.p('
');

3327: htp.p('
');
3328: -- light grey single pixel separator line between parameters and buttons
3329: htp.p('' ||
3330: '');
3331: htp.p('
');
3332: htp.p('');
3333:
3334: EXCEPTION
3335: WHEN application_exception THEN

Line 3332: htp.p('');

3328: -- light grey single pixel separator line between parameters and buttons
3329: htp.p('' ||
3330: '');
3331: htp.p('
');
3332: htp.p('');
3333:
3334: EXCEPTION
3335: WHEN application_exception THEN
3336: RAISE;

Line 3353: htp.p('');

3349:
3350: BEGIN
3351:
3352: -- Table for the OK and Cancel buttons
3353: htp.p('

');
3354: htp.p('');
3391: htp.p('');
3393: htp.p('

'); 3355: htp.p(''); 3356: htp.p(''); 3357: -- OK button Line 3354: htp.p(' '); 3350: BEGIN 3351: 3352: -- Table for the OK and Cancel buttons 3353: htp.p(''); 3354: htp.p(' '); 3355: htp.p(''); 3356: htp.p(''); 3357: -- OK button 3358: htp.p(''); Line 3355: htp.p(' '); 3351: 3352: -- Table for the OK and Cancel buttons 3353: htp.p(' '); 3354: htp.p(''); 3374: htp.p(''); 3374: htp.p(' '); 3355: htp.p(''); 3356: htp.p(''); 3357: -- OK button 3358: htp.p(''); 3359: htp.p(''); Line 3356: htp.p(' '); 3352: -- Table for the OK and Cancel buttons 3353: htp.p(' '); 3354: htp.p(''); 3374: htp.p(''); 3369: htp.p(' '); 3371: htp.p(''); 3373: htp.p(' '); 3355: htp.p(''); 3356: htp.p(''); 3357: -- OK button 3358: htp.p(''); 3359: htp.p(''); 3360: htp.p(''); Line 3358: htp.p(' '); 3354: htp.p(' '); Line 3371: htp.p(' '); 3369: htp.p(''); 3371: htp.p(''); 3373: htp.p(' '); 3355: htp.p(''); 3356: htp.p(''); 3357: -- OK button 3358: htp.p(''); 3359: htp.p(''); 3360: htp.p(''); 3361: htp.p(''); 3362: htp.p(''); Line 3359: htp.p(' '); 3355: htp.p(' '); 3356: htp.p(''); 3357: -- OK button 3358: htp.p(''); 3359: htp.p(''); 3360: htp.p(''); 3361: htp.p(''); 3362: htp.p(''); 3363: htp.p(''); 3356: htp.p(' '); 3357: -- OK button 3358: htp.p(''); 3359: htp.p(''); 3360: htp.p(''); 3361: htp.p(''); 3362: htp.p(''); 3363: htp.p(''); Line 3361: htp.p(' '); 3357: -- OK button 3358: htp.p(' '); 3359: htp.p(''); 3360: htp.p(''); 3361: htp.p(''); 3362: htp.p(''); 3363: htp.p(''); 3365: htp.p(''); 3359: htp.p(''); 3360: htp.p(''); 3361: htp.p(''); 3362: htp.p(''); 3363: htp.p(''); 3365: htp.p(''); 3360: htp.p(''); 3361: htp.p(''); 3362: htp.p(''); 3363: htp.p(''); 3365: htp.p(''); 3365: htp.p(''); 3369: htp.p(''); 3369: htp.p(''); 3371: htp.p(''); 3373: htp.p(' ' || Line 3360: htp.p(' ' || 3364: ' ' || 3364: ' ' || 3364: ' ' || 3364: ' Line 3365: htp.p(' 3368: '>'|| g_ok ||' ' || Line 3369: htp.p(' ' || 3365: htp.p(' 3368: '>'|| g_ok ||' ' || 3370: ' ' || 3372: ' ' || 3367: '''' || g_ok_hlp || '''' || ';return true;" ' || 3368: '>'|| g_ok ||' ' || 3370: ' ' || 3372: ' '); 3375: htp.p(''); Line 3373: htp.p(' ' || 3370: ' ' || 3372: ' '); 3375: htp.p(''); 3376: htp.p(''); 3377: -- Cancel button Line 3374: htp.p(' '); 3371: htp.p(''); 3373: htp.p(' '); 3370: ' ' || 3372: ' '); 3375: htp.p(''); 3376: htp.p(''); 3377: -- Cancel button 3378: htp.p(''); 3374: htp.p(''); 3374: htp.p(''); 3389: htp.p(''); 3391: htp.p(''); 3393: htp.p(' ' || Line 3375: htp.p(''); 3371: htp.p(' '); 3373: htp.p(' ' || 3372: ' '); 3375: htp.p(''); 3376: htp.p(''); 3377: -- Cancel button 3378: htp.p(''); Line 3376: htp.p(' '); 3372: ' '); 3373: htp.p(' ' || 3379: ' '); 3375: htp.p(''); 3376: htp.p(''); 3377: -- Cancel button 3378: htp.p(''); 3380: htp.p(''); Line 3378: htp.p(' ' || 3379: ' ' || 3374: htp.p(' '); 3375: htp.p(''); 3376: htp.p(''); 3377: -- Cancel button 3378: htp.p(''); 3380: htp.p(''); 3381: htp.p(''); Line 3380: htp.p(' '); 3376: htp.p(' '); 3377: -- Cancel button 3378: htp.p(''); 3380: htp.p(''); 3381: htp.p(''); 3383: htp.p(''); Line 3381: htp.p(' '); 3380: htp.p(''); 3381: htp.p(''); 3383: htp.p(''); 3385: htp.p(''); 3380: htp.p(''); 3381: htp.p(''); 3383: htp.p(''); 3385: htp.p(''); 3383: htp.p(''); 3385: htp.p(''); 3389: htp.p(''); 3389: htp.p(''); 3391: htp.p(''); 3393: htp.p(' ' || 3379: ' ' || 3382: ' ' || 3379: ' ' || 3382: ' ' || 3384: ' ' || 3377: -- Cancel button 3378: htp.p(' ' || 3379: ' ' || 3382: ' ' || 3384: ' ' || Line 3383: htp.p(' ' || 3379: ' ' || 3382: ' ' || 3384: ' ' || 3386: ' 3387: 'onMouseOver="window.status='||''''|| g_cancel_hlp ||''''|| Line 3385: htp.p(' ' || 3381: htp.p(' ' || 3382: ' ' || 3384: ' ' || 3386: ' 3387: 'onMouseOver="window.status='||''''|| g_cancel_hlp ||''''|| 3388: ';return true">'|| g_cancel ||' ' || Line 3389: htp.p(' ' || 3385: htp.p(' ' || 3386: ' 3387: 'onMouseOver="window.status='||''''|| g_cancel_hlp ||''''|| 3388: ';return true">'|| g_cancel ||' ' || 3390: ' ' || 3392: ' '); Line 3391: htp.p(' ' || 3387: 'onMouseOver="window.status='||''''|| g_cancel_hlp ||''''|| 3388: ';return true">'|| g_cancel ||' ' || 3390: ' ' || 3392: ' '); 3394: htp.p(' '); 3395: Line 3393: htp.p(' '); 3389: htp.p('

' || 3390: '

' || 3392: '

');
3394: htp.p('


');
3395:
3396: EXCEPTION
3397: WHEN application_exception THEN

Line 3394: htp.p('


');

3390: '');
3391: htp.p('' ||
3392: '');
3393: htp.p('');
3394: htp.p('


');
3395:
3396: EXCEPTION
3397: WHEN application_exception THEN
3398: RAISE;

Line 3415: htp.p('');

Line 3464: htp.p(' else');

3460: htp.p('{');
3461: htp.p(' set_final_product_list(varProductList);');
3462: htp.p(' if (document.forms[1].p_product_list.value == "")');
3463: htp.p(' alert("'|| g_js_slct_prd ||'");');
3464: htp.p(' else');
3465: htp.p(' document.Form1.submit();');
3466: htp.p('}');
3467: htp.p('');
3468: htp.br;

Line 3465: htp.p(' document.Form1.submit();');

3461: htp.p(' set_final_product_list(varProductList);');
3462: htp.p(' if (document.forms[1].p_product_list.value == "")');
3463: htp.p(' alert("'|| g_js_slct_prd ||'");');
3464: htp.p(' else');
3465: htp.p(' document.Form1.submit();');
3466: htp.p('}');
3467: htp.p('');
3468: htp.br;
3469: EXCEPTION

Line 3466: htp.p('}');

3462: htp.p(' if (document.forms[1].p_product_list.value == "")');
3463: htp.p(' alert("'|| g_js_slct_prd ||'");');
3464: htp.p(' else');
3465: htp.p(' document.Form1.submit();');
3466: htp.p('}');
3467: htp.p('');
3468: htp.br;
3469: EXCEPTION
3470: WHEN application_exception THEN

Line 3467: htp.p('');

3463: htp.p(' alert("'|| g_js_slct_prd ||'");');
3464: htp.p(' else');
3465: htp.p(' document.Form1.submit();');
3466: htp.p('}');
3467: htp.p('');
3468: htp.br;
3469: EXCEPTION
3470: WHEN application_exception THEN
3471: RAISE;

Line 3468: htp.br;

3464: htp.p(' else');
3465: htp.p(' document.Form1.submit();');
3466: htp.p('}');
3467: htp.p('');
3468: htp.br;
3469: EXCEPTION
3470: WHEN application_exception THEN
3471: RAISE;
3472: WHEN OTHERS THEN

Line 3495: htp.p('');

3491:
3492: --
3493: -- Print The Date header
3494: --
3495: htp.p('

');
3496: htp.p('');
3497: htp.p(' ');

3503: htp.p('

');
3505: htp.p('

'); 3498: htp.p(' '); 3499: htp.p(' '); Line 3496: htp.p(' '); 3492: -- 3493: -- Print The Date header 3494: -- 3495: htp.p(' '); 3496: htp.p(''); 3497: htp.p(' '); 3507: htp.p(''); 3508: htp.p(' '); 3498: htp.p(' '); 3499: htp.p(' '); 3500: htp.p(' '); Line 3497: htp.p(' '); 3493: -- Print The Date header 3494: -- 3495: htp.p(''); 3496: htp.p(''); 3497: htp.p(' '); 3502: htp.p(' '); 3498: htp.p(' '); 3499: htp.p(' '); 3500: htp.p(' '); 3501: htp.p(' '); Line 3498: htp.p(' '); 3494: -- 3495: htp.p(' '); 3496: htp.p(''); 3497: htp.p(' '); 3507: htp.p(''); 3508: htp.p(' '); 3498: htp.p(' '); 3499: htp.p(' '); 3500: htp.p(' '); 3501: htp.p(' '); 3502: htp.p(' '); Line 3499: htp.p(' '); 3495: htp.p(' '); 3496: htp.p(''); 3497: htp.p(' '); 3497: htp.p(' '); 3507: htp.p(''); Line 3505: htp.p(' '); 3498: htp.p(' '); 3499: htp.p(' '); 3500: htp.p(' '); 3501: htp.p(' '); 3502: htp.p(' '); 3503: htp.p(' ' || g_as_of || '   '|| Line 3500: htp.p(' '); 3496: htp.p(' '); 3498: htp.p(' '); 3499: htp.p(' '); 3500: htp.p(' '); 3501: htp.p(' '); 3502: htp.p(' '); 3503: htp.p(' '); Line 3501: htp.p(' '); Line 3503: htp.p(' '); 3500: htp.p(' ' || g_as_of || '   '|| 3504: FND_DATE.date_to_displayDT(SYSDATE) || ' '); 3497: htp.p(' '); 3498: htp.p(' '); 3499: htp.p(' '); 3500: htp.p(' '); 3501: htp.p(' '); 3502: htp.p(' '); 3503: htp.p(' '); 3505: htp.p(' ' || g_as_of || '   '|| 3504: FND_DATE.date_to_displayDT(SYSDATE) || ' '); Line 3502: htp.p(' '); 3498: htp.p(' '); 3499: htp.p(' '); 3500: htp.p(' '); 3501: htp.p(' '); 3502: htp.p(' '); 3503: htp.p(' '); 3505: htp.p(' ' || g_as_of || '   '|| 3504: FND_DATE.date_to_displayDT(SYSDATE) || ' '); 3506: htp.p(' ' || g_as_of || '   '|| 3499: htp.p('     '); 3501: htp.p(' '); 3502: htp.p(' '); 3503: htp.p(' '); 3505: htp.p(' ' || g_as_of || '   '|| 3504: FND_DATE.date_to_displayDT(SYSDATE) || ' '); 3506: htp.p(' '); 3501: htp.p(' '); 3502: htp.p(' '); 3503: htp.p(' '); 3505: htp.p(' ' || g_as_of || '   '|| 3504: FND_DATE.date_to_displayDT(SYSDATE) || ' '); 3506: htp.p(' '); 3509: Line 3506: htp.p(' '); 3503: htp.p(' '); 3505: htp.p(' ' || g_as_of || '   '|| 3504: FND_DATE.date_to_displayDT(SYSDATE) || ' '); 3506: htp.p(' '); 3509: 3510: -- Line 3507: htp.p('
' || g_as_of || '		'|| 3504: FND_DATE.date_to_displayDT(SYSDATE) || '

');
3506: htp.p(' ');
3507: htp.p('');
3508: htp.p('');
3509:
3510: --
3511: -- Print the Selected Products Table header

Line 3508: htp.p('');

3504: FND_DATE.date_to_displayDT(SYSDATE) || '');
3505: htp.p(' ');
3506: htp.p(' ');
3507: htp.p('');
3508: htp.p('');
3509:
3510: --
3511: -- Print the Selected Products Table header
3512: --

Line 3542: htp.p('');

3538: v_count PLS_INTEGER;
3539:
3540: BEGIN
3541:
3542: htp.p('

');
3543: htp.p('');
3545:
3546: v_count := 0;

Line 3543: htp.p('

');
3563: END IF;
3564: htp.p('

' || 3544: ''|| g_selected ||'

' || 3539: 3540: BEGIN 3541: 3542: htp.p(''); 3543: htp.p(''); 3545: 3546: v_count := 0; 3547: FOR v_index IN 1..p_ids.COUNT LOOP Line 3550: htp.p(' '); 3546: v_count := 0; 3547: FOR v_index IN 1..p_ids.COUNT LOOP 3548: v_text := get_application_name(p_ids(v_index)); 3549: IF (MOD(v_count, 2) = 0) THEN 3550: htp.p(' '); 3551: ELSE 3552: htp.p(''); 3553: END IF; 3554: v_count := v_count + 1; Line 3552: htp.p(' '); 3548: v_text := get_application_name(p_ids(v_index)); 3549: IF (MOD(v_count, 2) = 0) THEN 3550: htp.p(' '); 3551: ELSE 3552: htp.p(''); 3553: END IF; 3554: v_count := v_count + 1; 3555: END LOOP; 3556: -- if the last record was odd then we need to add a new empty cell Line 3558: htp.p(' '); 3554: v_count := v_count + 1; 3555: END LOOP; 3556: -- if the last record was odd then we need to add a new empty cell 3557: IF (v_count > 0 AND MOD(v_count, 2) = 1) THEN 3558: htp.p(' '); 3559: END IF; 3560: -- If there are no products selected 3561: IF (v_count = 0) THEN 3562: htp.p(''); Line 3562: htp.p(' '); 3558: htp.p(' '); 3559: END IF; 3560: -- If there are no products selected 3561: IF (v_count = 0) THEN 3562: htp.p(''); 3563: END IF; 3564: htp.p(' ' || 3544: ''|| g_selected ||' '|| v_text ||' '|| v_text ||' '|| v_text ||' '|| v_text ||' '|| v_text ||' '|| v_text ||'               ' || g_no_prod_sel ||' ' || g_no_prod_sel ||'        ' || g_no_prod_sel ||' '); 3565: 3566: htp.p(''); Line 3564: htp.p(' '); 3560: -- If there are no products selected 3561: IF (v_count = 0) THEN 3562: htp.p('

' || g_no_prod_sel ||'

');
3565:
3566: htp.p('');
3567: htp.p('');
3568: htp.p('');

Line 3566: htp.p('');

3562: htp.p('

');
3563: END IF;
3564: htp.p('

' || g_no_prod_sel ||'

');
3565:
3566: htp.p('');
3567: htp.p('');
3568: htp.p('');
3569: htp.p('
');
3570: EXCEPTION

Line 3567: htp.p('');

3563: END IF;
3564: htp.p('
');
3565:
3566: htp.p('');
3567: htp.p('');
3568: htp.p('');
3569: htp.p('
');
3570: EXCEPTION
3571: WHEN application_exception THEN

Line 3568: htp.p('');

3564: htp.p('
');
3565:
3566: htp.p('');
3567: htp.p('');
3568: htp.p('');
3569: htp.p('
');
3570: EXCEPTION
3571: WHEN application_exception THEN
3572: RAISE;

Line 3569: htp.p('
');

3565:
3566: htp.p('');
3567: htp.p('');
3568: htp.p('');
3569: htp.p('
');
3570: EXCEPTION
3571: WHEN application_exception THEN
3572: RAISE;
3573: WHEN OTHERS THEN

Line 3592: htp.hr('ALL');

3588:
3589: -- Get the report title and short desc
3590: get_report_title_desc(p_rpt1, v_text, v_desc);
3591:
3592: htp.hr('ALL');
3593: htp.p('');
3594: htp.tableRowOpen;
3595: htp.p('');

Line 3593: htp.p('

' || 3596: ''|| g_related ||'

');

3589: -- Get the report title and short desc
3590: get_report_title_desc(p_rpt1, v_text, v_desc);
3591:
3592: htp.hr('ALL');
3593: htp.p('

');
3594: htp.tableRowOpen;
3595: htp.p('');
3597: htp.tableRowClose;

Line 3594: htp.tableRowOpen;

3590: get_report_title_desc(p_rpt1, v_text, v_desc);
3591:
3592: htp.hr('ALL');
3593: htp.p('

' || 3596: ''|| g_related ||'

');
3594: htp.tableRowOpen;
3595: htp.p('');
3597: htp.tableRowClose;
3598: htp.tableRowOpen;

Line 3595: htp.p('

');

3703: '');
3705: -- Oracle Applications Logo
3706: htp.p('

');
3707: htp.p('');
3708: htp.p('');
3709: htp.p('

' || 3596: ''|| g_related ||'

' || 3591: 3592: htp.hr('ALL'); 3593: htp.p(''); 3594: htp.tableRowOpen; 3595: htp.p(''); 3597: htp.tableRowClose; 3598: htp.tableRowOpen; 3599: htp.p(''); 3597: htp.tableRowClose; 3598: htp.tableRowOpen; 3599: htp.p(''); 3597: htp.tableRowClose; 3598: htp.tableRowOpen; 3599: htp.p(''); Line 3599: htp.p(' '); 3597: htp.tableRowClose; 3598: htp.tableRowOpen; 3599: htp.p(''); 3603: Line 3608: htp.p(' '); 3612: END IF; Line 3614: htp.tableRowClose; 3610: ' 3611: ' alt="'|| v_desc ||'"> '|| v_text || ''); 3612: END IF; 3613: 3614: htp.tableRowClose; 3615: htp.tableClose; 3616: htp.bodyClose; 3617: htp.htmlClose; 3618: EXCEPTION Line 3615: htp.tableClose; 3611: ' alt="'|| v_desc ||'"> '|| v_text || ''); 3612: END IF; 3613: 3614: htp.tableRowClose; 3615: htp.tableClose; 3616: htp.bodyClose; 3617: htp.htmlClose; 3618: EXCEPTION 3619: WHEN application_exception THEN Line 3616: htp.bodyClose; 3612: END IF; 3613: 3614: htp.tableRowClose; 3615: htp.tableClose; 3616: htp.bodyClose; 3617: htp.htmlClose; 3618: EXCEPTION 3619: WHEN application_exception THEN 3620: RAISE; Line 3617: htp.htmlClose; 3613: 3614: htp.tableRowClose; 3615: htp.tableClose; 3616: htp.bodyClose; 3617: htp.htmlClose; 3618: EXCEPTION 3619: WHEN application_exception THEN 3620: RAISE; 3621: WHEN OTHERS THEN Line 3640: htp.htmlOpen; 3636: BEGIN 3637: 3638: report_help_url := fnd_help.get_url('AZ', g_help_target); 3639: 3640: htp.htmlOpen; 3641: htp.headOpen; 3642: 3643: htp.title(p_title); 3644: print_html_style; Line 3641: htp.headOpen; 3637: 3638: report_help_url := fnd_help.get_url('AZ', g_help_target); 3639: 3640: htp.htmlOpen; 3641: htp.headOpen; 3642: 3643: htp.title(p_title); 3644: print_html_style; 3645: htp.headClose; Line 3643: htp.title(p_title); 3639: 3640: htp.htmlOpen; 3641: htp.headOpen; 3642: 3643: htp.title(p_title); 3644: print_html_style; 3645: htp.headClose; 3646: htp.p(''); 3647: Line 3645: htp.headClose; 3641: htp.headOpen; 3642: 3643: htp.title(p_title); 3644: print_html_style; 3645: htp.headClose; 3646: htp.p(''); 3647: 3648: v_js_string:=''); Line 3655: htp.p('function exit_window() { self.close(); }'); 3651: ||''''||'resizable=yes,scrollbars=yes,toolbar=yes,width=550,' 3652: ||'height=250'||''''||')}'; 3653: 3654: htp.p(v_js_string); 3655: htp.p('function exit_window() { self.close(); }'); 3656: htp.p(''); 3657: htp.p(''); 3658: htp.p(''); 3659: Line 3656: htp.p(''); 3652: ||'height=250'||''''||')}'; 3653: 3654: htp.p(v_js_string); 3655: htp.p('function exit_window() { self.close(); }'); 3656: htp.p(''); 3657: htp.p(''); 3658: htp.p(''); 3659: 3660: htp.tableOpen('align=center bgcolor=#336699 border=0 cellpadding=0 ' || Line 3657: htp.p(''); 3653: 3654: htp.p(v_js_string); 3655: htp.p('function exit_window() { self.close(); }'); 3656: htp.p(''); 3657: htp.p(''); 3658: htp.p(''); 3659: 3660: htp.tableOpen('align=center bgcolor=#336699 border=0 cellpadding=0 ' || 3661: 'cellspacing=0 valign=center width=100%'); Line 3658: htp.p(''); 3654: htp.p(v_js_string); 3655: htp.p('function exit_window() { self.close(); }'); 3656: htp.p(''); 3657: htp.p(''); 3658: htp.p(''); 3659: 3660: htp.tableOpen('align=center bgcolor=#336699 border=0 cellpadding=0 ' || 3661: 'cellspacing=0 valign=center width=100%'); 3662: htp.tableRowOpen; Line 3660: htp.tableOpen('align=center bgcolor=#336699 border=0 cellpadding=0 ' || 3656: htp.p(''); 3657: htp.p(''); 3658: htp.p(''); 3659: 3660: htp.tableOpen('align=center bgcolor=#336699 border=0 cellpadding=0 ' || 3661: 'cellspacing=0 valign=center width=100%'); 3662: htp.tableRowOpen; 3663: htp.p(' '); 3664: htp.p(''); Line 3662: htp.tableRowOpen; 3658: htp.p(''); 3659: 3660: htp.tableOpen('align=center bgcolor=#336699 border=0 cellpadding=0 ' || 3661: 'cellspacing=0 valign=center width=100%'); 3662: htp.tableRowOpen; 3663: htp.p(' '); 3664: htp.p(''); 3665: 3666: IF p_type THEN Line 3663: htp.p(' '); 3659: 3660: htp.tableOpen('align=center bgcolor=#336699 border=0 cellpadding=0 ' || 3661: 'cellspacing=0 valign=center width=100%'); 3662: htp.tableRowOpen; 3663: htp.p(' '); 3664: htp.p(''); 3665: 3666: IF p_type THEN 3667: Line 3664: htp.p(' '); 3660: htp.tableOpen('align=center bgcolor=#336699 border=0 cellpadding=0 ' || 3661: 'cellspacing=0 valign=center width=100%'); 3662: htp.tableRowOpen; 3663: htp.p(' '); 3664: htp.p(''); 3665: 3666: IF p_type THEN 3667: 3668: -- Related Reports Button Line 3669: htp.p(' '); 3665: 3666: IF p_type THEN 3667: 3668: -- Related Reports Button 3669: htp.p(' '); 3670: htp.p(''); 3670: htp.p(''); Line 3677: htp.p(' '); 3673: ''); 3675: 3676: -- Parameters Page Button 3677: htp.p(' '); 3678: htp.p(''); 3675: 3676: -- Parameters Page Button 3677: htp.p(''); 3678: htp.p(''); Line 3685: htp.p(' '); 3681: ''); 3683: END IF; 3684: -- Main Menu Button 3685: htp.p(' '); 3686: htp.p(''); 3683: END IF; 3684: -- Main Menu Button 3685: htp.p(''); 3686: htp.p(''); Line 3692: htp.p(' '); 3688: g_mn_menu || '''' || ';return true">' || 3689: ''); 3691: -- Exit Button 3692: htp.p(' '); 3693: htp.p(''); 3691: -- Exit Button 3692: htp.p(''); 3693: htp.p(''); Line 3699: htp.p(' '); 3695: g_exit || '''' || ';return true">' || 3696: ''); 3698: -- Help Button 3699: htp.p(' '); 3700: htp.p(''); 3698: -- Help Button 3699: htp.p(''); 3700: htp.p(''); Line 3706: htp.p(' '); 3702: g_help || '''' || ';return true">' || 3703: ''); 3705: -- Oracle Applications Logo 3706: htp.p(' '); 3707: htp.p(''); 3708: htp.p(''); 3709: htp.p(' ' || 3596: ''|| g_related ||' '); 3594: htp.tableRowOpen; 3595: htp.p(' ' || 3596: ''|| g_related ||' ' || 3601: ' Line 3598: htp.tableRowOpen; 3594: htp.tableRowOpen; 3595: htp.p(' ' || 3596: ''|| g_related ||' ' || 3601: ' 3602: ||' alt="'|| v_desc ||'"> '|| v_text ||' ' || 3596: ''|| g_related ||' ' || 3601: ' 3602: ||' alt="'|| v_desc ||'"> '|| v_text ||' ' || 3610: ' 3611: ' alt="'|| v_desc ||'"> '|| v_text || ' '|| p_title ||' '|| p_title ||' '|| p_title ||' '|| p_title ||' '|| p_title ||' 3671: 'onMouseOver="window.status=' || '''' || 3672: g_related || '''' || ';return true">' || 3673: ' 3666: IF p_type THEN 3667: 3668: -- Related Reports Button 3669: htp.p(' 3671: 'onMouseOver="window.status=' || '''' || 3672: g_related || '''' || ';return true">' || 3673: ' 3679: 'onMouseOver="window.status=' || '''' || 3680: g_param_hdr || '''' || ';return true">' || 3681: ' 3674: g_related ||'"> 3679: 'onMouseOver="window.status=' || '''' || 3680: g_param_hdr || '''' || ';return true">' || 3681: ' 3687: 'onMouseOver="window.status=' || '''' || 3688: g_mn_menu || '''' || ';return true">' || 3689: ' 3682: g_param_hdr ||'"> 3687: 'onMouseOver="window.status=' || '''' || 3688: g_mn_menu || '''' || ';return true">' || 3689: ' 3694: 'onMouseOver="window.status=' || '''' || 3695: g_exit || '''' || ';return true">' || 3696: ' 3689: ' 3694: 'onMouseOver="window.status=' || '''' || 3695: g_exit || '''' || ';return true">' || 3696: ' 3701: ' onMouseOver="window.status=' || '''' || 3702: g_help || '''' || ';return true">' || 3703: ' 3696: ' 3701: ' onMouseOver="window.status=' || '''' || 3702: g_help || '''' || ';return true">' || 3703: ' '); 3710: EXCEPTION Line 3707: htp.p('

');
3710: EXCEPTION
3711: WHEN application_exception THEN

Line 3708: htp.p('
');

3704: g_help ||'">');
3705: -- Oracle Applications Logo
3706: htp.p('
');
3707: htp.p('');
3708: htp.p('
');
3709: htp.p('');
3710: EXCEPTION
3711: WHEN application_exception THEN
3712: RAISE;

Line 3709: htp.p('');

3705: -- Oracle Applications Logo
3706: htp.p('
');
3707: htp.p('');
3708: htp.p('
');
3709: htp.p('');
3710: EXCEPTION
3711: WHEN application_exception THEN
3712: RAISE;
3713: WHEN OTHERS THEN

Line 3733: htp.p('');

3729: v_line_cnt INTEGER := 1;
3730:
3731: BEGIN
3732:
3733: htp.p('

');
3734: htp.p('');
3735: htp.p(' ');
3753: htp.p('');
3754: htp.p('

'); 3736: htp.p(' '); 3737: htp.p(' '); Line 3734: htp.p(' '); 3730: 3731: BEGIN 3732: 3733: htp.p(' '); 3734: htp.p(''); 3735: htp.p(' '); 3753: htp.p(''); 3754: htp.p(' '); 3736: htp.p(' '); 3737: htp.p(' '); 3738: htp.p(' '); 3748: htp.p(' '); 3750: htp.p(' '); 3751: htp.p('     '|| g_proc_status || '   '); Line 3735: htp.p(' '); 3731: BEGIN 3732: 3733: htp.p(''); 3734: htp.p(''); 3735: htp.p(' '); 3753: htp.p(''); 3754: htp.p(' '); 3736: htp.p(' '); 3737: htp.p(' '); 3738: htp.p('     '|| g_proc_status || '   '); 3739: IF (p_status IS NOT NULL) THEN Line 3736: htp.p(' '); 3732: 3733: htp.p(' '); 3734: htp.p(''); 3735: htp.p(' '); Line 3750: htp.p(' '); 3746: htp.p(' '); 3753: htp.p(''); 3754: htp.p(' '); 3736: htp.p(' '); 3737: htp.p(' '); 3738: htp.p(' '); 3733: htp.p('     '|| g_proc_status || '   '); 3739: IF (p_status IS NOT NULL) THEN 3740: htp.p(get_translation('AZ_PROCESS_STATUS', p_status)); Line 3737: htp.p('     '); 3734: htp.p(''); 3735: htp.p(' '); 3745: htp.p(' '); 3736: htp.p(' '); 3737: htp.p(' '); 3738: htp.p(' '); 3735: htp.p(' '); 3745: htp.p('     '|| g_proc_status || '   '); 3739: IF (p_status IS NOT NULL) THEN 3740: htp.p(get_translation('AZ_PROCESS_STATUS', p_status)); 3741: ELSE Line 3738: htp.p(' '|| g_proc_status || '   '); 3734: htp.p(' '); 3736: htp.p(' '); 3737: htp.p(' '); 3738: htp.p(' '); 3740: htp.p(get_translation('AZ_PROCESS_STATUS', p_status)); 3741: ELSE 3742: htp.p(g_all); 3743: END IF; 3744: htp.p(''); 3745: htp.p('     '|| g_proc_status || '   '); 3739: IF (p_status IS NOT NULL) THEN 3740: htp.p(get_translation('AZ_PROCESS_STATUS', p_status)); 3741: ELSE 3742: htp.p(g_all); Line 3740: htp.p(get_translation('AZ_PROCESS_STATUS', p_status)); 3736: htp.p(' '); 3737: htp.p(' '); 3738: htp.p(' '); Line 3742: htp.p(g_all); 3738: htp.p(' '); 3745: htp.p('     '|| g_proc_status || '   '); 3739: IF (p_status IS NOT NULL) THEN 3740: htp.p(get_translation('AZ_PROCESS_STATUS', p_status)); 3741: ELSE 3742: htp.p(g_all); 3743: END IF; 3744: htp.p(' '|| g_proc_status || '   '); 3739: IF (p_status IS NOT NULL) THEN 3740: htp.p(get_translation('AZ_PROCESS_STATUS', p_status)); 3741: ELSE 3742: htp.p(g_all); 3743: END IF; 3744: htp.p(' '); 3746: htp.p(' '); Line 3744: htp.p(' '); 3746: htp.p(' '); 3747: htp.p(' '); 3748: htp.p(' ' || g_as_of || '   '|| Line 3745: htp.p(' '); 3741: ELSE 3742: htp.p(g_all); 3743: END IF; 3744: htp.p(' '); 3746: htp.p(' '); 3747: htp.p(' '); 3748: htp.p(' '); Line 3746: htp.p(' '); 3745: htp.p(' ' || g_as_of || '   '|| 3749: FND_DATE.date_to_displayDT(SYSDATE) || ' '); 3742: htp.p(g_all); 3743: END IF; 3744: htp.p(' '); 3746: htp.p(' '); 3747: htp.p(' '); 3748: htp.p(' '); 3750: htp.p(' '); Line 3747: htp.p(' ' || g_as_of || '   '|| 3749: FND_DATE.date_to_displayDT(SYSDATE) || '     '); 3743: END IF; 3744: htp.p(''); 3745: htp.p(' '); 3746: htp.p(' '); 3747: htp.p(' '); 3748: htp.p(' '); 3750: htp.p(' '); 3751: htp.p(' ' || g_as_of || '   '|| 3749: FND_DATE.date_to_displayDT(SYSDATE) || '     '); Line 3748: htp.p(' ' || g_as_of || '   '|| 3744: htp.p(' '); 3746: htp.p(' '); 3747: htp.p(' '); 3748: htp.p(' '); 3750: htp.p(' '); 3751: htp.p(' ' || g_as_of || '   '|| 3749: FND_DATE.date_to_displayDT(SYSDATE) || '     '); 3752: htp.p('     '); 3747: htp.p(' '); 3748: htp.p(' '); 3750: htp.p(' '); 3751: htp.p(' ' || g_as_of || '   '|| 3749: FND_DATE.date_to_displayDT(SYSDATE) || '     '); 3752: htp.p(' '); Line 3751: htp.p(' '); 3747: htp.p(' '); 3748: htp.p(' '); 3750: htp.p(' '); 3751: htp.p(' ' || g_as_of || '   '|| 3749: FND_DATE.date_to_displayDT(SYSDATE) || '     '); 3752: htp.p(' '); 3755: htp.p(''); Line 3752: htp.p(' ' || g_as_of || '   '|| 3749: FND_DATE.date_to_displayDT(SYSDATE) || '     '); 3752: htp.p(' '); 3755: htp.p(''); 3756: htp.p(''); Line 3753: htp.p(''); 3749: FND_DATE.date_to_displayDT(SYSDATE) || ''); 3750: htp.p(' '); 3751: htp.p(' '); 3752: htp.p('

');
3755: htp.p('');
3756: htp.p('');
3757: htp.p('');

Line 3754: htp.p('

');

3750: htp.p('   ');
3751: htp.p(' ');
3752: htp.p(' ');
3753: htp.p('');
3754: htp.p('');
3755: htp.p('');
3756: htp.p('');
3757: htp.p('');
3758: htp.p('');

Line 3755: htp.p('');

3751: htp.p(' ');
3752: htp.p(' ');
3753: htp.p('');
3754: htp.p('');
3755: htp.p('');
3756: htp.p('');
3757: htp.p('');
3758: htp.p('');
3759: htp.p('
');

Line 3756: htp.p('');

3752: htp.p(' ');
3753: htp.p('');
3754: htp.p('

');
3755: htp.p('');
3756: htp.p('');
3757: htp.p('');
3758: htp.p('');
3759: htp.p('
');
3760: --

Line 3757: htp.p('');

3753: htp.p('');
3754: htp.p('');
3755: htp.p('');
3756: htp.p('');
3757: htp.p('');
3758: htp.p('');
3759: htp.p('
');
3760: --
3761: -- Display Installed products table

Line 3758: htp.p('');

3754: htp.p('');
3755: htp.p('');
3756: htp.p('');
3757: htp.p('');
3758: htp.p('');
3759: htp.p('
');
3760: --
3761: -- Display Installed products table
3762: --

Line 3759: htp.p('
');

3755: htp.p('');
3756: htp.p('');
3757: htp.p('');
3758: htp.p('');
3759: htp.p('
');
3760: --
3761: -- Display Installed products table
3762: --
3763: print_isr_installed_products;

Line 3796: htp.p('');

3792: v_count PLS_INTEGER;
3793:
3794: BEGIN
3795: -- Print the Table header
3796: htp.p('

');
3797: htp.p('');
3799:
3800: v_count := 0;

Line 3797: htp.p('

' || 3798: ''|| g_installed ||'

' || 3793: 3794: BEGIN 3795: -- Print the Table header 3796: htp.p(''); 3797: htp.p(''); 3799: 3800: v_count := 0; 3801: FOR product_rec IN installed_products LOOP Line 3805: htp.p(' '); 3801: FOR product_rec IN installed_products LOOP 3802: -- if v_count is even then new record for the same phase 3803: IF (MOD(v_count, 2) = 0) THEN 3804: -- Display the product name in the first column 3805: htp.p(' '); 3806: ELSE 3807: -- Display the product name in the Second column 3808: htp.p(''); 3809: END IF; Line 3808: htp.p(' '); 3804: -- Display the product name in the first column 3805: htp.p(' '); 3806: ELSE 3807: -- Display the product name in the Second column 3808: htp.p(''); 3809: END IF; 3810: v_count := v_count + 1; 3811: END LOOP; 3812: IF (v_count > 0 AND MOD(v_count, 2) = 1) THEN Line 3813: htp.p(' '); 3809: END IF; 3810: v_count := v_count + 1; 3811: END LOOP; 3812: IF (v_count > 0 AND MOD(v_count, 2) = 1) THEN 3813: htp.p(' '); 3814: END IF; 3815: -- If there are no products installed 3816: IF (v_count = 0) THEN 3817: htp.p(''); Line 3817: htp.p(' '); 3813: htp.p(' '); 3814: END IF; 3815: -- If there are no products installed 3816: IF (v_count = 0) THEN 3817: htp.p(''); 3818: END IF; 3819: htp.p(' ' || 3798: ''|| g_installed ||' '|| product_rec.name ||' '|| product_rec.name ||' '|| product_rec.name ||' '|| product_rec.name ||' '|| product_rec.name ||' '|| product_rec.name ||'     ' || g_no_prod_inst ||' ' || g_no_prod_inst ||'   ' || g_no_prod_inst ||' '); 3820: 3821: EXCEPTION Line 3819: htp.p('

');

3815: -- If there are no products installed
3816: IF (v_count = 0) THEN
3817: htp.p('' || g_no_prod_inst ||'');
3818: END IF;
3819: htp.p('
');
3820:
3821: EXCEPTION
3822: WHEN application_exception THEN
3823: RAISE;

Line 3851: htp.p('');

3847: v_locator PLS_INTEGER := 0;
3848: BEGIN
3849: -- Print the Table header
3850: v_locator := 1;
3851: htp.p('

');
3852:
3853: IF (p_status IS NULL) THEN
3854: v_colspan := 5;
3855: ELSIF (p_status = 'I') THEN

Line 3861: htp.p('

');
3864: htp.p('');
3865: htp.p('');

3860:
3861: htp.p('

');
3864: htp.p('');
3865: htp.p('');
3867: IF (p_status IS NULL OR p_status = 'I') THEN
3868: htp.p('');
3864: htp.p('');
3865: htp.p('');
3867: IF (p_status IS NULL OR p_status = 'I') THEN
3868: htp.p('');

Line 3868: htp.p('

');
3865: htp.p('');
3867: IF (p_status IS NULL OR p_status = 'I') THEN
3868: htp.p('');
3870: END IF;
3871: IF (p_status IS NULL OR p_status = 'C') THEN
3872: htp.p('');
3870: END IF;
3871: IF (p_status IS NULL OR p_status = 'C') THEN
3872: htp.p('');
3874: END IF;
3875: IF (p_status IS NULL OR p_status = 'A' OR p_status = 'I') THEN
3876: htp.p('');
3874: END IF;
3875: IF (p_status IS NULL OR p_status = 'A' OR p_status = 'I') THEN
3876: htp.p('');
3878: END IF;
3879: IF (p_status IS NULL OR p_status = 'N' OR p_status = 'I') THEN
3880: htp.p('');
3878: END IF;
3879: IF (p_status IS NULL OR p_status = 'N' OR p_status = 'I') THEN
3880: htp.p('');
3882: END IF;
3883: htp.p('');
3884:

Line 3883: htp.p('');

3879: IF (p_status IS NULL OR p_status = 'N' OR p_status = 'I') THEN
3880: htp.p('

');
3882: END IF;
3883: htp.p('');
3884:
3885: --
3886: -- Select the report summary data and populate the array with it.
3887: --

Line 3894: htp.p('

');

3890: FOR i IN 1..process_groups.COUNT LOOP
3891: v_display_data := ''||
3893: process_groups(i).display_name || '';
3894: htp.p('

');
3895: IF (p_status IS NULL OR p_status = 'I') THEN
3896: htp.p('');
3898: END IF;

Line 3896: htp.p('

');
3895: IF (p_status IS NULL OR p_status = 'I') THEN
3896: htp.p('');
3898: END IF;
3899: IF (p_status IS NULL OR p_status = 'C') THEN
3900: htp.p('');
3898: END IF;
3899: IF (p_status IS NULL OR p_status = 'C') THEN
3900: htp.p('');
3902: END IF;
3903: IF (p_status IS NULL OR p_status = 'A' OR p_status = 'I') THEN
3904: htp.p('');
3902: END IF;
3903: IF (p_status IS NULL OR p_status = 'A' OR p_status = 'I') THEN
3904: htp.p('');
3906: END IF;
3907: IF (p_status IS NULL OR p_status = 'N' OR p_status = 'I') THEN
3908: htp.p('');
3906: END IF;
3907: IF (p_status IS NULL OR p_status = 'N' OR p_status = 'I') THEN
3908: htp.p('');
3910: END IF;
3911: htp.p('');
3912: END LOOP;

Line 3911: htp.p('');

3907: IF (p_status IS NULL OR p_status = 'N' OR p_status = 'I') THEN
3908: htp.p('

');
3910: END IF;
3911: htp.p('');
3912: END LOOP;
3913: htp.p('

' || 3857: ELSE 3858: v_colspan := 2; 3859: END IF; 3860: 3861: htp.p('

' || 3862: '' || 3863: g_summary ||'

'|| Line 3864: htp.p('

' || 3862: '' || 3863: g_summary ||'

'|| 3866: g_process_group ||'

'|| Line 3865: htp.p('

'|| 3861: htp.p('

' || 3862: '' || 3863: g_summary ||'

'|| 3866: g_process_group ||'

'|| 3869: g_num_procs ||'

'|| 3864: htp.p('

'|| 3866: g_process_group ||'

'|| 3869: g_num_procs ||'

'|| Line 3872: htp.p('

'|| 3868: htp.p('

'|| 3869: g_num_procs ||'

'|| 3873: g_num_completed_procs ||'

'|| Line 3876: htp.p('

'|| 3872: htp.p('

'|| 3873: g_num_completed_procs ||'

'|| 3877: g_num_active_procs ||'

'|| Line 3880: htp.p('

'|| 3876: htp.p('

'|| 3877: g_num_active_procs ||'

'|| 3881: g_num_notstarted_procs ||'

'|| 3881: g_num_notstarted_procs ||'

'|| v_display_data ||'

'|| v_display_data ||'

' 3897: || process_groups(i).processes_count ||'

' 3892: process_groups(i).node_id || '">'|| 3893: process_groups(i).display_name || ''; 3894: htp.p('

'|| v_display_data ||'

' 3897: || process_groups(i).processes_count ||'

' Line 3900: htp.p('

' 3896: htp.p('

' 3897: || process_groups(i).processes_count ||'

' 3901: || process_groups(i).complete_procs_count ||'

' Line 3904: htp.p('

' 3900: htp.p('

' 3901: || process_groups(i).complete_procs_count ||'

' 3905: || process_groups(i).active_procs_count ||'

' Line 3908: htp.p('

' 3904: htp.p('

' 3905: || process_groups(i).active_procs_count ||'

' 3909: || process_groups(i).not_started_procs_count ||'

' 3909: || process_groups(i).not_started_procs_count ||'

');
3914: return;
3915:

Line 3913: htp.p('
');

3909: || process_groups(i).not_started_procs_count ||'');
3910: END IF;
3911: htp.p('');
3912: END LOOP;
3913: htp.p('
');
3914: return;
3915:
3916: EXCEPTION
3917: WHEN application_exception THEN

Line 4054: htp.p('');

4050: p_display_name wf_roles.display_name%TYPE;
4051: v_locator PLS_INTEGER := 0;
4052: BEGIN
4053:
4054: htp.p('

');
4055: htp.p('');
4056: htp.p(' ');
4104: htp.p('');
4105: htp.p('

'); 4057: htp.p(' '); 4058: htp.p(' '); Line 4055: htp.p(' '); 4051: v_locator PLS_INTEGER := 0; 4052: BEGIN 4053: 4054: htp.p(' '); 4055: htp.p(''); 4056: htp.p(' '); 4099: END IF; 4100: v_locator := 4; 4101: htp.p(' '); 4102: htp.p(' '); 4057: htp.p(' '); 4058: htp.p(' '); 4059: htp.p(' '); 4104: htp.p(''); 4105: htp.p('     ' || g_user || '   '); Line 4056: htp.p(' '); 4052: BEGIN 4053: 4054: htp.p(''); 4055: htp.p(''); 4056: htp.p(' '); 4099: END IF; 4100: v_locator := 4; 4101: htp.p(''); 4102: htp.p(' '); 4057: htp.p(' '); 4058: htp.p(' '); 4059: htp.p('     ' || g_user || '   '); 4060: v_locator := 1; Line 4057: htp.p(' '); 4053: 4054: htp.p(' '); 4055: htp.p(''); 4056: htp.p(' '); 4104: htp.p(''); 4105: htp.p(' '); 4057: htp.p(' '); 4058: htp.p(' '); 4059: htp.p(' '); 4054: htp.p('     ' || g_user || '   '); 4060: v_locator := 1; 4061: IF (p_user IS NOT NULL) THEN Line 4058: htp.p('     '); 4055: htp.p(''); 4056: htp.p(' '); 4079: htp.p(' '); 4057: htp.p(' '); 4058: htp.p(' '); 4059: htp.p(' '); 4056: htp.p(' '); 4074: ELSE 4075: htp.p(g_all); 4076: END IF; 4077: v_locator := 3; 4078: htp.p(''); 4079: htp.p('     ' || g_user || '   '); 4060: v_locator := 1; 4061: IF (p_user IS NOT NULL) THEN 4062: SELECT display_name INTO p_display_name Line 4059: htp.p(' ' || g_user || '   '); 4055: htp.p(' '); 4057: htp.p(' '); 4058: htp.p(' '); 4059: htp.p(' '); 4071: htp.p(' '); 4066: ELSE 4067: htp.p(g_all); 4068: END IF; 4069: v_locator := 2; 4070: htp.p(''); 4071: htp.p(' '); 4071: htp.p(' '); 4071: htp.p(' '); 4079: htp.p('     ' || g_user || '   '); 4060: v_locator := 1; 4061: IF (p_user IS NOT NULL) THEN 4062: SELECT display_name INTO p_display_name 4063: FROM wf_roles Line 4065: htp.p(p_user || ' (' || p_display_name || ')'); 4061: IF (p_user IS NOT NULL) THEN 4062: SELECT display_name INTO p_display_name 4063: FROM wf_roles 4064: WHERE name = p_user; 4065: htp.p(p_user || ' (' || p_display_name || ')'); 4066: ELSE 4067: htp.p(g_all); 4068: END IF; 4069: v_locator := 2; Line 4067: htp.p(g_all); 4063: FROM wf_roles 4064: WHERE name = p_user; 4065: htp.p(p_user || ' (' || p_display_name || ')'); 4066: ELSE 4067: htp.p(g_all); 4068: END IF; 4069: v_locator := 2; 4070: htp.p(' '|| g_status ||'   '); Line 4070: htp.p(' '|| g_status ||'   '); 4072: IF (p_status IS NOT NULL) THEN 4073: htp.p(get_translation('AZ_PROCESS_STATUS', p_status)); 4074: ELSE Line 4071: htp.p(' '|| g_status ||'   '); 4067: htp.p(g_all); 4068: END IF; 4069: v_locator := 2; 4070: htp.p(' '|| g_status ||'   '); 4072: IF (p_status IS NOT NULL) THEN 4073: htp.p(get_translation('AZ_PROCESS_STATUS', p_status)); 4074: ELSE 4075: htp.p(g_all); Line 4073: htp.p(get_translation('AZ_PROCESS_STATUS', p_status)); 4069: v_locator := 2; 4070: htp.p(' '|| g_status ||'   '); 4072: IF (p_status IS NOT NULL) THEN 4073: htp.p(get_translation('AZ_PROCESS_STATUS', p_status)); 4074: ELSE 4075: htp.p(g_all); 4076: END IF; 4077: v_locator := 3; Line 4075: htp.p(g_all); 4071: htp.p(' '|| g_status ||'   '); 4072: IF (p_status IS NOT NULL) THEN 4073: htp.p(get_translation('AZ_PROCESS_STATUS', p_status)); 4074: ELSE 4075: htp.p(g_all); 4076: END IF; 4077: v_locator := 3; 4078: htp.p(' '); Line 4078: htp.p(' '); 4080: htp.p(' '); 4081: htp.p(' '); 4082: htp.p(' ' || g_as_of || Line 4079: htp.p(' '); 4075: htp.p(g_all); 4076: END IF; 4077: v_locator := 3; 4078: htp.p(' '); 4080: htp.p(' '); 4081: htp.p(' '); 4082: htp.p(' '); 4079: htp.p(' ' || g_as_of || 4083: '   '|| Line 4080: htp.p(' '); 4076: END IF; 4077: v_locator := 3; 4078: htp.p(' '); 4080: htp.p(' '); 4081: htp.p(' '); 4082: htp.p(' '); Line 4081: htp.p(' ' || g_as_of || 4083: '   '|| 4084: FND_DATE.date_to_displayDT(SYSDATE) || ' '); 4077: v_locator := 3; 4078: htp.p(''); 4079: htp.p(' '); 4080: htp.p(' '); 4081: htp.p(' '); 4082: htp.p(' '); 4085: IF (p_time_or_period = 'T') THEN -- Time Elapsed Line 4082: htp.p(' '); 4079: htp.p(' ' || g_as_of || 4083: '   '|| 4084: FND_DATE.date_to_displayDT(SYSDATE) || ' ' || g_as_of || 4078: htp.p(' '); 4080: htp.p(' '); 4081: htp.p(' '); 4082: htp.p(' '); 4085: IF (p_time_or_period = 'T') THEN -- Time Elapsed 4086: htp.p(''); 4085: IF (p_time_or_period = 'T') THEN -- Time Elapsed 4086: htp.p(''); 4095: ELSE -- Date Range Line 4093: htp.p(' '|| p_days ||' '|| g_days); 4089: htp.p(g_atmost); 4090: ELSE 4091: htp.p(g_atleast); 4092: END IF; 4093: htp.p(' '|| p_days ||' '|| g_days); 4094: htp.p(''); 4095: ELSE -- Date Range 4096: htp.p(' '); 4090: ELSE 4091: htp.p(g_atleast); 4092: END IF; 4093: htp.p(' '|| p_days ||' '|| g_days); 4094: htp.p(''); 4095: ELSE -- Date Range 4096: htp.p(' '); Line 4096: htp.p(' '); 4095: ELSE -- Date Range 4096: htp.p(''); 4099: END IF; 4100: v_locator := 4; Line 4101: htp.p(' '); 4097: || ' '); 4099: END IF; 4100: v_locator := 4; 4101: htp.p(''); 4102: htp.p(' ' || g_as_of || 4083: '   '|| 4084: FND_DATE.date_to_displayDT(SYSDATE) || ' ' || g_duration || Line 4086: htp.p(' ' || g_duration || 4082: htp.p(' ' || g_as_of || 4083: '   '|| 4084: FND_DATE.date_to_displayDT(SYSDATE) || ' ' || g_duration || 4087: '   '); 4088: IF (p_operator = '<=') THEN 4089: htp.p(g_atmost); 4090: ELSE Line 4089: htp.p(g_atmost); 4085: IF (p_time_or_period = 'T') THEN -- Time Elapsed 4086: htp.p(' ' || g_duration || 4087: '   '); 4088: IF (p_operator = '<=') THEN 4089: htp.p(g_atmost); 4090: ELSE 4091: htp.p(g_atleast); 4092: END IF; 4093: htp.p(' '|| p_days ||' '|| g_days); Line 4091: htp.p(g_atleast); 4087: '   '); 4088: IF (p_operator = '<=') THEN 4089: htp.p(g_atmost); 4090: ELSE 4091: htp.p(g_atleast); 4092: END IF; 4093: htp.p(' '|| p_days ||' '|| g_days); 4094: htp.p(' ' || g_active_by 4097: || '   ' || Line 4094: htp.p(' ' || g_active_by 4097: || '   ' || 4098: p_start || ' - ' || p_end || ' ' || g_active_by 4092: END IF; 4093: htp.p(' '|| p_days ||' '|| g_days); 4094: htp.p(' ' || g_active_by 4097: || '   ' || 4098: p_start || ' - ' || p_end || '       ' || 4098: p_start || ' - ' || p_end || '     '); 4103: htp.p(' '); Line 4102: htp.p(' '); 4098: p_start || ' - ' || p_end || '     '); 4103: htp.p(' '); 4106: htp.p(''); Line 4103: htp.p('     '); 4103: htp.p('

');
4106: htp.p('');
4107: htp.p('');

Line 4104: htp.p('');

4100: v_locator := 4;
4101: htp.p('

');
4102: htp.p(' ');
4103: htp.p(' ');
4104: htp.p('');
4105: htp.p('');
4106: htp.p('');
4107: htp.p('');
4108: htp.p('');

Line 4105: htp.p('

');

4101: htp.p('  ');
4102: htp.p(' ');
4103: htp.p(' ');
4104: htp.p('');
4105: htp.p('');
4106: htp.p('');
4107: htp.p('');
4108: htp.p('');
4109: htp.p('');

Line 4106: htp.p('');

4102: htp.p(' ');
4103: htp.p(' ');
4104: htp.p('');
4105: htp.p('');
4106: htp.p('');
4107: htp.p('');
4108: htp.p('');
4109: htp.p('');
4110: htp.p('
');

Line 4107: htp.p('');

4103: htp.p(' ');
4104: htp.p('');
4105: htp.p('

');
4106: htp.p('');
4107: htp.p('');
4108: htp.p('');
4109: htp.p('');
4110: htp.p('
');
4111:

Line 4108: htp.p('');

4104: htp.p('');
4105: htp.p('');
4106: htp.p('');
4107: htp.p('');
4108: htp.p('');
4109: htp.p('');
4110: htp.p('
');
4111:
4112: EXCEPTION

Line 4109: htp.p('');

4105: htp.p('');
4106: htp.p('');
4107: htp.p('');
4108: htp.p('');
4109: htp.p('');
4110: htp.p('
');
4111:
4112: EXCEPTION
4113: WHEN application_exception THEN

Line 4110: htp.p('
');

4106: htp.p('');
4107: htp.p('');
4108: htp.p('');
4109: htp.p('');
4110: htp.p('
');
4111:
4112: EXCEPTION
4113: WHEN application_exception THEN
4114: RAISE;

Line 4133: htp.p('');

Line 4199: htp.p(' else');

4195: htp.p(' DisplayAlert(CurForm.p_days, "'||
4196: g_js_slct_time_elapsed ||'");');
4197: htp.p(' return false;');
4198: htp.p(' }');
4199: htp.p(' else');
4200: htp.p(' CurForm.submit();');
4201: htp.p('}');
4202: htp.p('');
4203:

Line 4200: htp.p(' CurForm.submit();');

4196: g_js_slct_time_elapsed ||'");');
4197: htp.p(' return false;');
4198: htp.p(' }');
4199: htp.p(' else');
4200: htp.p(' CurForm.submit();');
4201: htp.p('}');
4202: htp.p('');
4203:
4204: EXCEPTION

Line 4201: htp.p('}');

4197: htp.p(' return false;');
4198: htp.p(' }');
4199: htp.p(' else');
4200: htp.p(' CurForm.submit();');
4201: htp.p('}');
4202: htp.p('');
4203:
4204: EXCEPTION
4205: WHEN application_exception THEN

Line 4202: htp.p('');

4198: htp.p(' }');
4199: htp.p(' else');
4200: htp.p(' CurForm.submit();');
4201: htp.p('}');
4202: htp.p('');
4203:
4204: EXCEPTION
4205: WHEN application_exception THEN
4206: RAISE;

Line 4232: htp.htmlOpen;

4228: get_web_agent;
4229: get_translated_labels;
4230: END IF;
4231:
4232: htp.htmlOpen;
4233: htp.headOpen;
4234: htp.title(g_welcome_msg);
4235: print_html_style; -- print the 11i HTML style sheet.
4236: htp.headClose;

Line 4233: htp.headOpen;

4229: get_translated_labels;
4230: END IF;
4231:
4232: htp.htmlOpen;
4233: htp.headOpen;
4234: htp.title(g_welcome_msg);
4235: print_html_style; -- print the 11i HTML style sheet.
4236: htp.headClose;
4237:

Line 4234: htp.title(g_welcome_msg);

4230: END IF;
4231:
4232: htp.htmlOpen;
4233: htp.headOpen;
4234: htp.title(g_welcome_msg);
4235: print_html_style; -- print the 11i HTML style sheet.
4236: htp.headClose;
4237:
4238: htp.p('');

Line 4236: htp.headClose;

4232: htp.htmlOpen;
4233: htp.headOpen;
4234: htp.title(g_welcome_msg);
4235: print_html_style; -- print the 11i HTML style sheet.
4236: htp.headClose;
4237:
4238: htp.p('');
4239:
4240: report_help_url := fnd_help.get_url('AZ', 'azw_report.start_page');

Line 4238: htp.p('');

4234: htp.title(g_welcome_msg);
4235: print_html_style; -- print the 11i HTML style sheet.
4236: htp.headClose;
4237:
4238: htp.p('');
4239:
4240: report_help_url := fnd_help.get_url('AZ', 'azw_report.start_page');
4241:
4242: v_js_string := '');
4254: htp.tableOpen('align=center bgcolor=#336699 border=0 cellpadding=0 ' ||

Line 4251: htp.p('');

4247:
4248: htp.p(v_js_string);
4249:
4250: htp.p('function exit_window() { self.close(); }');
4251: htp.p('');
4252: htp.p('');
4253: htp.p('');
4254: htp.tableOpen('align=center bgcolor=#336699 border=0 cellpadding=0 ' ||
4255: 'cellspacing=0 valign=center width=100%');

Line 4252: htp.p('');

4248: htp.p(v_js_string);
4249:
4250: htp.p('function exit_window() { self.close(); }');
4251: htp.p('');
4252: htp.p('');
4253: htp.p('');
4254: htp.tableOpen('align=center bgcolor=#336699 border=0 cellpadding=0 ' ||
4255: 'cellspacing=0 valign=center width=100%');
4256: htp.tableRowOpen;

Line 4253: htp.p('');

4249:
4250: htp.p('function exit_window() { self.close(); }');
4251: htp.p('');
4252: htp.p('');
4253: htp.p('');
4254: htp.tableOpen('align=center bgcolor=#336699 border=0 cellpadding=0 ' ||
4255: 'cellspacing=0 valign=center width=100%');
4256: htp.tableRowOpen;
4257: htp.p('
');

Line 4254: htp.tableOpen('align=center bgcolor=#336699 border=0 cellpadding=0 ' ||

4250: htp.p('function exit_window() { self.close(); }');
4251: htp.p('');
4252: htp.p('');
4253: htp.p('');
4254: htp.tableOpen('align=center bgcolor=#336699 border=0 cellpadding=0 ' ||
4255: 'cellspacing=0 valign=center width=100%');
4256: htp.tableRowOpen;
4257: htp.p('
');
4258: htp.p(' '|| g_welcome_msg ||'');

Line 4256: htp.tableRowOpen;

4252: htp.p('');
4253: htp.p('');
4254: htp.tableOpen('align=center bgcolor=#336699 border=0 cellpadding=0 ' ||
4255: 'cellspacing=0 valign=center width=100%');
4256: htp.tableRowOpen;
4257: htp.p('
');
4258: htp.p(' '|| g_welcome_msg ||'');
4259: htp.p('
');
4260: htp.p('

Line 4257: htp.p('
');

4253: htp.p('');
4254: htp.tableOpen('align=center bgcolor=#336699 border=0 cellpadding=0 ' ||
4255: 'cellspacing=0 valign=center width=100%');
4256: htp.tableRowOpen;
4257: htp.p('
');
4258: htp.p(' '|| g_welcome_msg ||'');
4259: htp.p('
');
4260: htp.p(' 4261: 'onMouseOver="window.status=' || '''' ||

Line 4258: htp.p(' '|| g_welcome_msg ||'');

4254: htp.tableOpen('align=center bgcolor=#336699 border=0 cellpadding=0 ' ||
4255: 'cellspacing=0 valign=center width=100%');
4256: htp.tableRowOpen;
4257: htp.p('
');
4258: htp.p(' '|| g_welcome_msg ||'');
4259: htp.p('
');
4260: htp.p(' 4261: 'onMouseOver="window.status=' || '''' ||
4262: g_exit || '''' || ';return true">' ||

Line 4259: htp.p('
');

4255: 'cellspacing=0 valign=center width=100%');
4256: htp.tableRowOpen;
4257: htp.p('
');
4258: htp.p(' '|| g_welcome_msg ||'');
4259: htp.p('
');
4260: htp.p(' 4261: 'onMouseOver="window.status=' || '''' ||
4262: g_exit || '''' || ';return true">' ||
4263: '

4256: htp.tableRowOpen;
4257: htp.p('
');
4258: htp.p(' '|| g_welcome_msg ||'');
4259: htp.p('
');
4260: htp.p(' 4261: 'onMouseOver="window.status=' || '''' ||
4262: g_exit || '''' || ';return true">' ||
4263: '');

Line 4265: htp.p('
');

4261: 'onMouseOver="window.status=' || '''' ||
4262: g_exit || '''' || ';return true">' ||
4263: '');
4265: htp.p('
');
4266: htp.p(' 4267: ' onMouseOver="window.status=' || '''' ||
4268: g_help || '''' || ';return true">' ||
4269: '

4262: g_exit || '''' || ';return true">' ||
4263: '');
4265: htp.p('
');
4266: htp.p(' 4267: ' onMouseOver="window.status=' || '''' ||
4268: g_help || '''' || ';return true">' ||
4269: '');

Line 4271: htp.p('
');

4267: ' onMouseOver="window.status=' || '''' ||
4268: g_help || '''' || ';return true">' ||
4269: '');
4271: htp.p('
');
4272: htp.p('');
4273: htp.p('
');
4274: htp.p('');
4275: htp.p(FND_DATE.date_to_displaydate(SYSDATE));

Line 4272: htp.p('');

4268: g_help || '''' || ';return true">' ||
4269: '');
4271: htp.p('
');
4272: htp.p('');
4273: htp.p('
');
4274: htp.p('');
4275: htp.p(FND_DATE.date_to_displaydate(SYSDATE));
4276: EXCEPTION

Line 4273: htp.p('
');

4269: '');
4271: htp.p('
');
4272: htp.p('');
4273: htp.p('
');
4274: htp.p('');
4275: htp.p(FND_DATE.date_to_displaydate(SYSDATE));
4276: EXCEPTION
4277: WHEN application_exception THEN

Line 4274: htp.p('');

4270: g_help ||'">');
4271: htp.p('
');
4272: htp.p('');
4273: htp.p('
');
4274: htp.p('');
4275: htp.p(FND_DATE.date_to_displaydate(SYSDATE));
4276: EXCEPTION
4277: WHEN application_exception THEN
4278: RAISE;

Line 4275: htp.p(FND_DATE.date_to_displaydate(SYSDATE));

4271: htp.p('
');
4272: htp.p('');
4273: htp.p('
');
4274: htp.p('');
4275: htp.p(FND_DATE.date_to_displaydate(SYSDATE));
4276: EXCEPTION
4277: WHEN application_exception THEN
4278: RAISE;
4279: WHEN OTHERS THEN

Line 4349: htp.centerOpen;

4345: print_param_page_header(g_ppr, g_ppr_msg, NULL);
4346:
4347: print_pp_jscripts;
4348:
4349: htp.centerOpen;
4350: v_locator := 1;
4351: OPEN product_list_cursor;
4352: FETCH product_list_cursor INTO v_product;
4353: v_group := v_product.dependency_parent_id;

Line 4396: htp.p('

');

4392: * In scenario #2, NONE of the checkboxes will be selected in the
4393: * product parameter page.
4394: */
4395:
4396: htp.p('');
4397: htp.p('');
4398: v_locator := 2;
4399: WHILE product_list_cursor%FOUND LOOP
4400: v_product_cnt := v_product_cnt + 1;

Line 4397: htp.p('

');

4393: * product parameter page.
4394: */
4395:
4396: htp.p('');
4397: htp.p('

');
4398: v_locator := 2;
4399: WHILE product_list_cursor%FOUND LOOP
4400: v_product_cnt := v_product_cnt + 1;
4401: IF (v_group <> v_product.dependency_parent_id) THEN

Line 4403: htp.p('

');

4399: WHILE product_list_cursor%FOUND LOOP
4400: v_product_cnt := v_product_cnt + 1;
4401: IF (v_group <> v_product.dependency_parent_id) THEN
4402: -- print a line break bewteen groups
4403: htp.p('

');
4404:
4405: v_group := v_product.dependency_parent_id;
4406: v_column := 0;
4407: END IF;

Line 4412: htp.tableRowOpen;

4408:
4409: IF (v_column = 0) THEN
4410: -- print check box with v_product.application_name and
4411: -- v_product.application_id in the first column
4412: htp.tableRowOpen;
4413:
4414: htp.p('

');
4418:

Line 4420: htp.tableData(lpad_nbsp(3)); -- tab one column

4416: ' value='||v_product.application_id||
4417: ' UNCHECKED> '||v_product.application_name||' ');
4418:
4419: v_column := v_column + 1;
4420: htp.tableData(lpad_nbsp(3)); -- tab one column
4421:
4422: ELSE
4423: -- print check box with v_product.application_name and
4424: -- v_product.application_id in the third column

Line 4426: htp.p('

');
4430:

Line 4436: htp.tableRowClose;

4432:
4433: END IF;
4434: FETCH product_list_cursor INTO v_product;
4435: END LOOP;
4436: htp.tableRowClose;
4437: v_locator := 4;
4438: CLOSE product_list_cursor;
4439: htp.tableClose;
4440:

Line 4439: htp.tableClose;

4435: END LOOP;
4436: htp.tableRowClose;
4437: v_locator := 4;
4438: CLOSE product_list_cursor;
4439: htp.tableClose;
4440:
4441: -- add the hidden field 'p_product_list' which will be used in order
4442: -- to maintain the comma-delimited list of selected product codes
4443:

Line 4444: htp.p('');

4440:
4441: -- add the hidden field 'p_product_list' which will be used in order
4442: -- to maintain the comma-delimited list of selected product codes
4443:
4444: htp.p('');
4445:
4446: -- hidden field for the number of installed products
4447: htp.p('');

Line 4447: htp.p('');
4445:
4446: -- hidden field for the number of installed products
4447: htp.p('');
4449: htp.p('');
4450:
4451: -- the second form contains the report parameter field 'p_product_list'

Line 4449: htp.p('');

4445:
4446: -- hidden field for the number of installed products
4447: htp.p('');
4449: htp.p('');
4450:
4451: -- the second form contains the report parameter field 'p_product_list'
4452: htp.p('

');
4453:

Line 4452: htp.p('');

4448: v_product_cnt||'">');
4449: htp.p('');
4450:
4451: -- the second form contains the report parameter field 'p_product_list'
4452: htp.p('

');
4453:
4454: -- Print the horizontal seperator
4455: htp.p('

'|| 4415: ' 4416: ' value='||v_product.application_id|| Line 4414: htp.p('	'|| 4410: -- print check box with v_product.application_name and 4411: -- v_product.application_id in the first column 4412: htp.tableRowOpen; 4413: 4414: htp.p('	'|| 4415: ' 4416: ' value='||v_product.application_id|| 4417: ' UNCHECKED> '||v_product.application_name||'	'||''||' '||v_product.application_name||'

');
4456: --

Line 4455: htp.p('

');

4451: -- the second form contains the report parameter field 'p_product_list'
4452: htp.p('');
4453:
4454: -- Print the horizontal seperator
4455: htp.p('

');
4456: --
4457: -- Print Footer line seperator.
4458: --
4459: print_footer_separator_line();

Line 4466: htp.p('');

4462: --
4463: v_locator := 5;
4464: print_ok_cancel_buttons('javascript:void(' ||
4465: 'SubmitCurrentForm(document.Form1.p_product_list))');
4466: htp.p('');
4467: htp.p('');
4468: htp.centerClose;
4469: htp.bodyClose;
4470: htp.htmlClose;

Line 4467: htp.p('');

4463: v_locator := 5;
4464: print_ok_cancel_buttons('javascript:void(' ||
4465: 'SubmitCurrentForm(document.Form1.p_product_list))');
4466: htp.p('');
4467: htp.p('');
4468: htp.centerClose;
4469: htp.bodyClose;
4470: htp.htmlClose;
4471:

Line 4468: htp.centerClose;

4464: print_ok_cancel_buttons('javascript:void(' ||
4465: 'SubmitCurrentForm(document.Form1.p_product_list))');
4466: htp.p('');
4467: htp.p('');
4468: htp.centerClose;
4469: htp.bodyClose;
4470: htp.htmlClose;
4471:
4472: EXCEPTION

Line 4469: htp.bodyClose;

4465: 'SubmitCurrentForm(document.Form1.p_product_list))');
4466: htp.p('');
4467: htp.p('');
4468: htp.centerClose;
4469: htp.bodyClose;
4470: htp.htmlClose;
4471:
4472: EXCEPTION
4473: WHEN application_exception THEN

Line 4470: htp.htmlClose;

4466: htp.p('');
4467: htp.p('');
4468: htp.centerClose;
4469: htp.bodyClose;
4470: htp.htmlClose;
4471:
4472: EXCEPTION
4473: WHEN application_exception THEN
4474: RAISE;

Line 4574: htp.p('

');

4570: -- Add a hyperlink to the Step Details report that
4571: -- shows all the steps for all the processes available
4572: -- to the selected products
4573: --
4574: htp.p('

');
4575: /*htp.p('

4576: 'azw_report.show_all_steps?p_selected_products='|| 4577: p_product_list || '")) onMouseOver=window.status="' || 4578: g_step_all_procs || '";return true>' || Line 4575: /*htp.p('

4571: -- shows all the steps for all the processes available 4572: -- to the selected products 4573: -- 4574: htp.p(''); 4575: /*htp.p('');*/ Line 4580: htp.p(' ');*/ 4580: htp.p(''); 4584: htp.p(' 4576: 'azw_report.show_all_steps?p_selected_products='|| 4577: p_product_list || '")) onMouseOver=window.status="' || 4578: g_step_all_procs || '";return true>' || 4579: g_step_all_procs || ' 4576: 'azw_report.show_all_steps?p_selected_products='|| 4577: p_product_list || '")) onMouseOver=window.status="' || 4578: g_step_all_procs || '";return true>' || 4579: g_step_all_procs || ' 4581: 'azw_report.show_all_steps?p_selected_products='|| 4582: p_product_list || '"))>' || 4583: g_step_all_procs || ' '); Line 4584: htp.p('

');

4580: htp.p(' 4581: 'azw_report.show_all_steps?p_selected_products='||
4582: p_product_list || '"))>' ||
4583: g_step_all_procs || '');
4584: htp.p('');
4585: htp.p('
');
4586:
4587: --
4588: -- Display Report Details

Line 4585: htp.p('
');

4581: 'azw_report.show_all_steps?p_selected_products='||
4582: p_product_list || '"))>' ||
4583: g_step_all_procs || '');
4584: htp.p('');
4585: htp.p('
');
4586:
4587: --
4588: -- Display Report Details
4589: --

Line 4590: htp.p('');

4586:
4587: --
4588: -- Display Report Details
4589: --
4590: htp.p('

');
4591: htp.p('');
4593: htp.p('');
4594: htp.p('

' || 4592: ''|| g_details ||'
Line 4591: htp.p('
' || 4587: -- 4588: -- Display Report Details 4589: -- 4590: htp.p(''); 4591: htp.p(''); 4593: htp.p(''); 4594: htp.p(''); Line 4593: htp.p(' '); 4589: -- 4590: htp.p(' ' || 4592: ''|| g_details ||' 4595: 'NOWRAP>'|| g_hierarchy ||' '); 4591: htp.p(''); 4593: htp.p(''); 4594: htp.p(''); 4596: htp.p(''); Line 4594: htp.p(' ' || 4592: ''|| g_details ||' 4595: 'NOWRAP>'|| g_hierarchy ||' 4597: 'NOWRAP>'|| g_description ||' 4590: htp.p(''); 4591: htp.p(''); 4593: htp.p(''); 4594: htp.p(''); 4596: htp.p(''); 4598: Line 4596: htp.p(' '); 4593: htp.p(''); 4594: htp.p(''); 4596: htp.p(''); 4598: 4599: -- print hierarchies nodes 4600: v_count := 0; Line 4614: htp.p(' '); 4618: ELSIF (one_node.node_type = 'G') THEN Line 4619: htp.tableRowOpen; 4615: '' || 4617: one_node.hierarchy || ''); 4618: ELSIF (one_node.node_type = 'G') THEN 4619: htp.tableRowOpen; 4620: htp.tableData(''||lpad_nbsp(one_node.level)|| one_node.hierarchy || 4621: '', 'LEFT', '', 'NOWRAP'); 4622: ELSE 4623: get_process_type_name (one_node.node_id, v_item_type, v_process_name); Line 4620: htp.tableData(''||lpad_nbsp(one_node.level)|| one_node.hierarchy || 4616: one_node.node_id || '">' || 4617: one_node.hierarchy || ''); 4618: ELSIF (one_node.node_type = 'G') THEN 4619: htp.tableRowOpen; 4620: htp.tableData(''||lpad_nbsp(one_node.level)|| one_node.hierarchy || 4621: '', 'LEFT', '', 'NOWRAP'); 4622: ELSE 4623: get_process_type_name (one_node.node_id, v_item_type, v_process_name); 4624: v_process_groups := get_parent_structure(v_upper_group_names, one_node.level - 1, '\\'); Line 4625: htp.tableRowOpen; 4621: '', 'LEFT', '', 'NOWRAP'); 4622: ELSE 4623: get_process_type_name (one_node.node_id, v_item_type, v_process_name); 4624: v_process_groups := get_parent_structure(v_upper_group_names, one_node.level - 1, '\\'); 4625: htp.tableRowOpen; 4626: htp.tableData(lpad_nbsp(one_node.level) || ' 4627: 'azw_report.display_process_steps?p_selected_products=' || p_product_list || 4628: '&p_item_type=' || v_item_type || 4629: '&p_process_name=' || v_process_name || Line 4626: htp.tableData(lpad_nbsp(one_node.level) || ' 4622: ELSE 4623: get_process_type_name (one_node.node_id, v_item_type, v_process_name); 4624: v_process_groups := get_parent_structure(v_upper_group_names, one_node.level - 1, '\\'); 4625: htp.tableRowOpen; 4626: htp.tableData(lpad_nbsp(one_node.level) || ' 4627: 'azw_report.display_process_steps?p_selected_products=' || p_product_list || 4628: '&p_item_type=' || v_item_type || 4629: '&p_process_name=' || v_process_name || 4630: '&p_context_type_name=' || url_encode(one_node.context_type_name) || Line 4635: htp.tableData(one_node.description, 'LEFT', '', 'NOWRAP'); 4631: '&p_process_groups=' || url_encode(v_process_groups) || 4632: '&p_new_call=YES&p_external_call=YES' || '"))>' 4633: || TRIM(one_node.hierarchy) || 4634: '', 'LEFT', '', 'NOWRAP'); 4635: htp.tableData(one_node.description, 'LEFT', '', 'NOWRAP'); 4636: END IF; 4637: htp.tableRowClose; 4638: v_count := v_count + 1; 4639: END LOOP; Line 4637: htp.tableRowClose; 4633: || TRIM(one_node.hierarchy) || 4634: '', 'LEFT', '', 'NOWRAP'); 4635: htp.tableData(one_node.description, 'LEFT', '', 'NOWRAP'); 4636: END IF; 4637: htp.tableRowClose; 4638: v_count := v_count + 1; 4639: END LOOP; 4640: v_locator := 6; 4641: print_back_to_top(2); Line 4643: htp.tableClose; 4639: END LOOP; 4640: v_locator := 6; 4641: print_back_to_top(2); 4642: -- print Table closing tag 4643: htp.tableClose; 4644: -- print report legend 4645: print_legend; 4646: -- print related report links 4647: print_related_reports('AZW_RPT_IPR', 'AZW_RPT_CPR'); Line 4654: htp.tableClose; 4650: 4651: EXCEPTION 4652: WHEN NO_DATA_FOUND THEN 4653: -- print Table closing tag 4654: htp.tableClose; 4655: print_related_reports('AZW_RPT_IPR', 'AZW_RPT_CPR'); 4656: WHEN application_exception THEN 4657: RAISE; 4658: WHEN OTHERS THEN Line 4691: htp.bodyClose; 4687: print_imp_start_page; 4688: ELSE 4689: print_upgrade_start_page; 4690: END IF; 4691: htp.bodyClose; 4692: htp.htmlClose; 4693: 4694: EXCEPTION 4695: WHEN application_exception THEN Line 4692: htp.htmlClose; 4688: ELSE 4689: print_upgrade_start_page; 4690: END IF; 4691: htp.bodyClose; 4692: htp.htmlClose; 4693: 4694: EXCEPTION 4695: WHEN application_exception THEN 4696: RAISE; Line 4735: htp.p(' ' || 4592: ''|| g_details ||' 4595: 'NOWRAP>'|| g_hierarchy ||' 4597: 'NOWRAP>'|| g_description ||' 4592: ''|| g_details ||' 4595: 'NOWRAP>'|| g_hierarchy ||' 4597: 'NOWRAP>'|| g_description ||' ' || 4610: IF (one_node.parent_node_id IS NULL) THEN 4611: IF (v_count > 0) THEN 4612: print_back_to_top(2); 4613: END IF; 4614: htp.p(' ' || 4615: '' || 4617: one_node.hierarchy || ' 4731: END IF; 4732: 4733: print_param_page_header(g_isr, g_isr_msg, g_mode_label); 4734: 4735: htp.p(' 4736: 'cellspacing="2" width="96%">'); 4737: htp.p(''); 4738: htp.p(' 4739: 'action="azw_report.status_report">'); Line 4737: htp.p(' '); 4733: print_param_page_header(g_isr, g_isr_msg, g_mode_label); 4734: 4735: htp.p(' 4736: 'cellspacing="2" width="96%">'); 4737: htp.p(''); 4738: htp.p(' 4739: 'action="azw_report.status_report">'); 4740: 4741: -- create the pop-up list of process status Line 4738: htp.p(' 4734: 4735: htp.p(' 4736: 'cellspacing="2" width="96%">'); 4737: htp.p(''); 4738: htp.p(' 4739: 'action="azw_report.status_report">'); 4740: 4741: -- create the pop-up list of process status 4742: htp.p(''); 4740: 4741: -- create the pop-up list of process status 4742: htp.p(''); 4744: htp.p(''); 4744: htp.p(''); 4744: htp.p(''); Line 4755: htp.p(''); 4751: htp.p(' '|| 4752: one_status.meaning||''); 4753: END IF; 4754: END LOOP; 4755: htp.p(''); 4756: 4757: print_param_page_footer; 4758: 4759: EXCEPTION Line 4846: htp.p(' ' || Line 4742: htp.p(' ' || 4738: htp.p(' 4739: 'action="azw_report.status_report"> ' || 4743: g_proc_status || ' '); 4745: 4746: -- make the blank as the default and first option meaning for all statuses Line 4744: htp.p(' '); 4740: 4741: -- create the pop-up list of process status 4742: htp.p(' ' || 4743: g_proc_status || ' '); 4745: 4746: -- make the blank as the default and first option meaning for all statuses 4747: htp.p(''|| g_all ||''); 4748: Line 4747: htp.p(''|| g_all ||''); 4743: g_proc_status || ' '); 4745: 4746: -- make the blank as the default and first option meaning for all statuses 4747: htp.p(''|| g_all ||''); 4748: 4749: FOR one_status IN statuses_cursor LOOP 4750: IF (one_status.lookup_code <> 'ALL') THEN 4751: htp.p(' '|| Line 4751: htp.p(' '|| 4747: htp.p(' '|| g_all ||''); 4748: 4749: FOR one_status IN statuses_cursor LOOP 4750: IF (one_status.lookup_code <> 'ALL') THEN 4751: htp.p(' '|| 4752: one_status.meaning||''); 4753: END IF; 4754: END LOOP; 4755: htp.p(' '); 4842: 4843: -- 4844: -- print report details and header based on p_status 4845: -- 4846: htp.p(' '); 4847: IF (p_status IS NULL OR p_status='A' OR p_status='C' OR p_status='I') THEN 4848: v_colspan := 8; 4849: ELSE 4850: v_colspan := 4; Line 4852: htp.p(' '); 4854: 4855: htp.p(''); 4856: htp.p(''); 4851: END IF; 4852: htp.p(' '); 4854: 4855: htp.p(''); 4856: htp.p(''); 4858: htp.p(''); Line 4856: htp.p(' '); 4854: 4855: htp.p(''); 4856: htp.p(''); 4858: htp.p(''); 4860: htp.p(''); 4856: htp.p(''); 4858: htp.p(''); 4860: htp.p(''); 4862: htp.p(''); 4858: htp.p(''); 4860: htp.p(''); 4862: htp.p(''); 4864: IF (p_status IS NULL OR p_status='A' OR p_status='C' OR p_status='I') THEN Line 4862: htp.p(' '); 4860: htp.p(''); 4862: htp.p(''); 4864: IF (p_status IS NULL OR p_status='A' OR p_status='C' OR p_status='I') THEN 4865: htp.p(''); Line 4865: htp.p(' '); 4862: htp.p(''); 4864: IF (p_status IS NULL OR p_status='A' OR p_status='C' OR p_status='I') THEN 4865: htp.p(''); 4867: htp.p(''); 4869: htp.p(''); 4864: IF (p_status IS NULL OR p_status='A' OR p_status='C' OR p_status='I') THEN 4865: htp.p(''); 4867: htp.p(''); 4869: htp.p(''); 4871: htp.p(''); 4867: htp.p(''); 4869: htp.p(''); 4871: htp.p(''); 4873: END IF; Line 4871: htp.p(' '); 4869: htp.p(''); 4871: htp.p(''); 4873: END IF; 4874: htp.tableRowClose; 4875: v_count := 0; Line 4874: htp.tableRowClose; 4870: 'NOWRAP>'|| g_end ||''); 4871: htp.p(' '); 4873: END IF; 4874: htp.tableRowClose; 4875: v_count := 0; 4876: v_locator := 2; 4877: FOR one_node IN hierarchies_cursor LOOP 4878: -- Line 4885: htp.tableRowOpen; 4881: -- "\Common Applications\System Administration\" 4882: -- 4883: v_upper_group_names(one_node.level) := TRIM(one_node.hierarchy); 4884: -- print hierarchy, context type, context name and status 4885: htp.tableRowOpen; 4886: IF (one_node.parent_node_id IS NULL) THEN 4887: IF (v_count > 0) THEN 4888: print_back_to_top(v_colspan); 4889: END IF; Line 4890: htp.p(' '); Line 4896: htp.tableData(''||lpad_nbsp(one_node.level)|| one_node.hierarchy || 4892: 'NOWRAP>' || 4894: one_node.hierarchy || ''); 4895: ELSIF (one_node.node_type = 'G') THEN 4896: htp.tableData(''||lpad_nbsp(one_node.level)|| one_node.hierarchy || 4897: '', 'LEFT', '', 'NOWRAP'); 4898: htp.tableData(''||one_node.context_type_name||''); 4899: htp.tableData(''||one_node.context_name||''); 4900: htp.tableData(''||one_node.status_code_name||'', 'LEFT', '', 'NOWRAP'); Line 4898: htp.tableData(''||one_node.context_type_name||''); 4894: one_node.hierarchy || ''); 4895: ELSIF (one_node.node_type = 'G') THEN 4896: htp.tableData(''||lpad_nbsp(one_node.level)|| one_node.hierarchy || 4897: '', 'LEFT', '', 'NOWRAP'); 4898: htp.tableData(''||one_node.context_type_name||''); 4899: htp.tableData(''||one_node.context_name||''); 4900: htp.tableData(''||one_node.status_code_name||'', 'LEFT', '', 'NOWRAP'); 4901: IF (p_status IS NULL OR p_status='A' OR p_status='C' OR p_status='I') 4902: THEN Line 4899: htp.tableData(''||one_node.context_name||''); 4895: ELSIF (one_node.node_type = 'G') THEN 4896: htp.tableData(''||lpad_nbsp(one_node.level)|| one_node.hierarchy || 4897: '', 'LEFT', '', 'NOWRAP'); 4898: htp.tableData(''||one_node.context_type_name||''); 4899: htp.tableData(''||one_node.context_name||''); 4900: htp.tableData(''||one_node.status_code_name||'', 'LEFT', '', 'NOWRAP'); 4901: IF (p_status IS NULL OR p_status='A' OR p_status='C' OR p_status='I') 4902: THEN 4903: -- print assigned user, start/end dates, and duration Line 4900: htp.tableData(''||one_node.status_code_name||'', 'LEFT', '', 'NOWRAP'); 4896: htp.tableData(''||lpad_nbsp(one_node.level)|| one_node.hierarchy || 4897: '', 'LEFT', '', 'NOWRAP'); 4898: htp.tableData(''||one_node.context_type_name||''); 4899: htp.tableData(''||one_node.context_name||''); 4900: htp.tableData(''||one_node.status_code_name||'', 'LEFT', '', 'NOWRAP'); 4901: IF (p_status IS NULL OR p_status='A' OR p_status='C' OR p_status='I') 4902: THEN 4903: -- print assigned user, start/end dates, and duration 4904: htp.tableData(''||one_node.assigned_user||''); Line 4904: htp.tableData(''||one_node.assigned_user||''); 4900: htp.tableData(''||one_node.status_code_name||'', 'LEFT', '', 'NOWRAP'); 4901: IF (p_status IS NULL OR p_status='A' OR p_status='C' OR p_status='I') 4902: THEN 4903: -- print assigned user, start/end dates, and duration 4904: htp.tableData(''||one_node.assigned_user||''); 4905: htp.tableData(''||one_node.start_date||''); 4906: htp.tableData(''||one_node.end_date||''); 4907: htp.tableData(''||one_node.time_elapsed||'', 'RIGHT'); 4908: END IF; Line 4905: htp.tableData(''||one_node.start_date||''); 4901: IF (p_status IS NULL OR p_status='A' OR p_status='C' OR p_status='I') 4902: THEN 4903: -- print assigned user, start/end dates, and duration 4904: htp.tableData(''||one_node.assigned_user||''); 4905: htp.tableData(''||one_node.start_date||''); 4906: htp.tableData(''||one_node.end_date||''); 4907: htp.tableData(''||one_node.time_elapsed||'', 'RIGHT'); 4908: END IF; 4909: ELSIF (one_node.node_type = 'P') THEN Line 4906: htp.tableData(''||one_node.end_date||''); 4902: THEN 4903: -- print assigned user, start/end dates, and duration 4904: htp.tableData(''||one_node.assigned_user||''); 4905: htp.tableData(''||one_node.start_date||''); 4906: htp.tableData(''||one_node.end_date||''); 4907: htp.tableData(''||one_node.time_elapsed||'', 'RIGHT'); 4908: END IF; 4909: ELSIF (one_node.node_type = 'P') THEN 4910: -- To be used by the task HREF Line 4907: htp.tableData(''||one_node.time_elapsed||'', 'RIGHT'); 4903: -- print assigned user, start/end dates, and duration 4904: htp.tableData(''||one_node.assigned_user||''); 4905: htp.tableData(''||one_node.start_date||''); 4906: htp.tableData(''||one_node.end_date||''); 4907: htp.tableData(''||one_node.time_elapsed||'', 'RIGHT'); 4908: END IF; 4909: ELSIF (one_node.node_type = 'P') THEN 4910: -- To be used by the task HREF 4911: v_process_groups := get_parent_structure(v_upper_group_names, one_node.level, '\\'); Line 4914: htp.tableData(''||lpad_nbsp(one_node.level)|| one_node.hierarchy || 4910: -- To be used by the task HREF 4911: v_process_groups := get_parent_structure(v_upper_group_names, one_node.level, '\\'); 4912: v_ctx_type_name := one_node.context_type_name; 4913: 4914: htp.tableData(''||lpad_nbsp(one_node.level)|| one_node.hierarchy || 4915: '', 'LEFT', '', 'NOWRAP'); 4916: htp.tableData(one_node.context_type_name||''); 4917: htp.tableData(one_node.context_name||''); 4918: htp.tableData(one_node.status_code_name||'', 'LEFT', '', 'NOWRAP'); Line 4916: htp.tableData(one_node.context_type_name||''); 4912: v_ctx_type_name := one_node.context_type_name; 4913: 4914: htp.tableData(''||lpad_nbsp(one_node.level)|| one_node.hierarchy || 4915: '', 'LEFT', '', 'NOWRAP'); 4916: htp.tableData(one_node.context_type_name||''); 4917: htp.tableData(one_node.context_name||''); 4918: htp.tableData(one_node.status_code_name||'', 'LEFT', '', 'NOWRAP'); 4919: IF (p_status IS NULL OR p_status='A' OR p_status='C' OR p_status='I') 4920: THEN Line 4917: htp.tableData(one_node.context_name||''); 4913: 4914: htp.tableData(''||lpad_nbsp(one_node.level)|| one_node.hierarchy || 4915: '', 'LEFT', '', 'NOWRAP'); 4916: htp.tableData(one_node.context_type_name||''); 4917: htp.tableData(one_node.context_name||''); 4918: htp.tableData(one_node.status_code_name||'', 'LEFT', '', 'NOWRAP'); 4919: IF (p_status IS NULL OR p_status='A' OR p_status='C' OR p_status='I') 4920: THEN 4921: -- print assigned user, start/end dates, and duration Line 4918: htp.tableData(one_node.status_code_name||'', 'LEFT', '', 'NOWRAP'); 4914: htp.tableData(''||lpad_nbsp(one_node.level)|| one_node.hierarchy || 4915: '', 'LEFT', '', 'NOWRAP'); 4916: htp.tableData(one_node.context_type_name||''); 4917: htp.tableData(one_node.context_name||''); 4918: htp.tableData(one_node.status_code_name||'', 'LEFT', '', 'NOWRAP'); 4919: IF (p_status IS NULL OR p_status='A' OR p_status='C' OR p_status='I') 4920: THEN 4921: -- print assigned user, start/end dates, and duration 4922: htp.tableData(''||one_node.assigned_user||''); Line 4922: htp.tableData(''||one_node.assigned_user||''); 4918: htp.tableData(one_node.status_code_name||'', 'LEFT', '', 'NOWRAP'); 4919: IF (p_status IS NULL OR p_status='A' OR p_status='C' OR p_status='I') 4920: THEN 4921: -- print assigned user, start/end dates, and duration 4922: htp.tableData(''||one_node.assigned_user||''); 4923: htp.tableData(''||one_node.start_date||''); 4924: htp.tableData(''||one_node.end_date||''); 4925: htp.tableData(''||one_node.time_elapsed||'', 'RIGHT'); 4926: END IF; Line 4923: htp.tableData(''||one_node.start_date||''); 4919: IF (p_status IS NULL OR p_status='A' OR p_status='C' OR p_status='I') 4920: THEN 4921: -- print assigned user, start/end dates, and duration 4922: htp.tableData(''||one_node.assigned_user||''); 4923: htp.tableData(''||one_node.start_date||''); 4924: htp.tableData(''||one_node.end_date||''); 4925: htp.tableData(''||one_node.time_elapsed||'', 'RIGHT'); 4926: END IF; 4927: IF (one_node.comments IS NOT NULL) THEN Line 4924: htp.tableData(''||one_node.end_date||''); 4920: THEN 4921: -- print assigned user, start/end dates, and duration 4922: htp.tableData(''||one_node.assigned_user||''); 4923: htp.tableData(''||one_node.start_date||''); 4924: htp.tableData(''||one_node.end_date||''); 4925: htp.tableData(''||one_node.time_elapsed||'', 'RIGHT'); 4926: END IF; 4927: IF (one_node.comments IS NOT NULL) THEN 4928: htp.tableRowClose; Line 4925: htp.tableData(''||one_node.time_elapsed||'', 'RIGHT'); 4921: -- print assigned user, start/end dates, and duration 4922: htp.tableData(''||one_node.assigned_user||''); 4923: htp.tableData(''||one_node.start_date||''); 4924: htp.tableData(''||one_node.end_date||''); 4925: htp.tableData(''||one_node.time_elapsed||'', 'RIGHT'); 4926: END IF; 4927: IF (one_node.comments IS NOT NULL) THEN 4928: htp.tableRowClose; 4929: htp.tableRowOpen; Line 4928: htp.tableRowClose; 4924: htp.tableData(''||one_node.end_date||''); 4925: htp.tableData(''||one_node.time_elapsed||'', 'RIGHT'); 4926: END IF; 4927: IF (one_node.comments IS NOT NULL) THEN 4928: htp.tableRowClose; 4929: htp.tableRowOpen; 4930: htp.tableData('' || lpad_nbsp(one_node.level)||'('|| 4931: g_comments ||':'||one_node.comments 4932: ||')', 'LEFT', '', 'NOWRAP'); Line 4929: htp.tableRowOpen; 4925: htp.tableData(''||one_node.time_elapsed||'', 'RIGHT'); 4926: END IF; 4927: IF (one_node.comments IS NOT NULL) THEN 4928: htp.tableRowClose; 4929: htp.tableRowOpen; 4930: htp.tableData('' || lpad_nbsp(one_node.level)||'('|| 4931: g_comments ||':'||one_node.comments 4932: ||')', 'LEFT', '', 'NOWRAP'); 4933: END IF; Line 4930: htp.tableData('' || lpad_nbsp(one_node.level)||'('|| 4926: END IF; 4927: IF (one_node.comments IS NOT NULL) THEN 4928: htp.tableRowClose; 4929: htp.tableRowOpen; 4930: htp.tableData('' || lpad_nbsp(one_node.level)||'('|| 4931: g_comments ||':'||one_node.comments 4932: ||')', 'LEFT', '', 'NOWRAP'); 4933: END IF; 4934: ELSE /* node_type = 'T' */ Line 4947: htp.p(' '); 4943: '&p_time_elapsed=' || url_encode(one_node.time_elapsed) || 4944: '&p_item_type=' || v_item_type || 4945: '&p_item_key=' || v_item_key || '")) onMouseOver=window.status=' 4946: || g_task_details || '";return true>'; 4947: htp.p(' '); 4948: htp.p(''); 4949: htp.p(''); 4950: htp.p(''); 4951: Line 4948: htp.p(' '); 4944: '&p_item_type=' || v_item_type || 4945: '&p_item_key=' || v_item_key || '")) onMouseOver=window.status=' 4946: || g_task_details || '";return true>'; 4947: htp.p(' '); 4948: htp.p(''); 4949: htp.p(''); 4950: htp.p(''); 4951: 4952: IF (p_status IS NULL OR p_status='A' OR p_status='C' OR p_status='I') THEN Line 4949: htp.p(' '); 4945: '&p_item_key=' || v_item_key || '")) onMouseOver=window.status=' 4946: || g_task_details || '";return true>'; 4947: htp.p(' '); 4948: htp.p(''); 4949: htp.p(''); 4950: htp.p(''); 4951: 4952: IF (p_status IS NULL OR p_status='A' OR p_status='C' OR p_status='I') THEN 4953: -- print assigned user, start/end dates, and duration Line 4950: htp.p(' '); 4946: || g_task_details || '";return true>'; 4947: htp.p(' '); 4948: htp.p(''); 4949: htp.p(''); 4950: htp.p(''); 4951: 4952: IF (p_status IS NULL OR p_status='A' OR p_status='C' OR p_status='I') THEN 4953: -- print assigned user, start/end dates, and duration 4954: htp.tableData(one_node.assigned_user, '', '', '', '', '', Line 4954: htp.tableData(one_node.assigned_user, '', '', '', '', '', 4950: htp.p(' '); 4951: 4952: IF (p_status IS NULL OR p_status='A' OR p_status='C' OR p_status='I') THEN 4953: -- print assigned user, start/end dates, and duration 4954: htp.tableData(one_node.assigned_user, '', '', '', '', '', 4955: 'bgcolor=#DDDDDD'); 4956: htp.tableData(one_node.start_date, '', '', '', '', '', 4957: 'bgcolor=#DDDDDD'); 4958: htp.tableData(one_node.end_date||' ', '', '', '', '', '', Line 4956: htp.tableData(one_node.start_date, '', '', '', '', '', 4952: IF (p_status IS NULL OR p_status='A' OR p_status='C' OR p_status='I') THEN 4953: -- print assigned user, start/end dates, and duration 4954: htp.tableData(one_node.assigned_user, '', '', '', '', '', 4955: 'bgcolor=#DDDDDD'); 4956: htp.tableData(one_node.start_date, '', '', '', '', '', 4957: 'bgcolor=#DDDDDD'); 4958: htp.tableData(one_node.end_date||' ', '', '', '', '', '', 4959: 'bgcolor=#DDDDDD'); 4960: htp.tableData(one_node.time_elapsed, 'RIGHT', '', '', '', '', Line 4958: htp.tableData(one_node.end_date||' ', '', '', '', '', '', 4954: htp.tableData(one_node.assigned_user, '', '', '', '', '', 4955: 'bgcolor=#DDDDDD'); 4956: htp.tableData(one_node.start_date, '', '', '', '', '', 4957: 'bgcolor=#DDDDDD'); 4958: htp.tableData(one_node.end_date||' ', '', '', '', '', '', 4959: 'bgcolor=#DDDDDD'); 4960: htp.tableData(one_node.time_elapsed, 'RIGHT', '', '', '', '', 4961: 'bgcolor=#DDDDDD'); 4962: END IF; Line 4960: htp.tableData(one_node.time_elapsed, 'RIGHT', '', '', '', '', 4956: htp.tableData(one_node.start_date, '', '', '', '', '', 4957: 'bgcolor=#DDDDDD'); 4958: htp.tableData(one_node.end_date||' ', '', '', '', '', '', 4959: 'bgcolor=#DDDDDD'); 4960: htp.tableData(one_node.time_elapsed, 'RIGHT', '', '', '', '', 4961: 'bgcolor=#DDDDDD'); 4962: END IF; 4963: END IF; 4964: Line 4966: htp.tableRowClose; 4962: END IF; 4963: END IF; 4964: 4965: -- print Table row closing tag 4966: htp.tableRowClose; 4967: v_count := v_count + 1; 4968: END LOOP; 4969: v_locator := 3; 4970: print_back_to_top(v_colspan); Line 4972: htp.tableClose; 4968: END LOOP; 4969: v_locator := 3; 4970: print_back_to_top(v_colspan); 4971: -- print Table closing tag 4972: htp.tableClose; 4973: -- print report legend 4974: print_legend (TRUE); 4975: 4976: -- print related report links Line 4985: htp.tableClose; 4981: 4982: EXCEPTION 4983: WHEN NO_DATA_FOUND THEN 4984: -- print Table closing tag 4985: htp.tableClose; 4986: print_related_reports('AZW_RPT_UPR'); 4987: WHEN application_exception THEN 4988: RAISE; 4989: WHEN OTHERS THEN Line 5099: htp.p(''); 5095: END IF; 5096: print_param_page_header(g_upr, g_upr_msg, g_mode_label); 5097: print_up_jscripts; 5098: 5099: htp.p(''); 5100: htp.p(' ' || 4848: v_colspan := 8; 4849: ELSE 4850: v_colspan := 4; 4851: END IF; 4852: htp.p(' ' || 4853: ''|| g_details ||' Line 4855: htp.p(' ' || 4853: ''|| g_details ||' 4857: 'NOWRAP>'|| g_hierarchy ||' 4859: 'NOWRAP>'|| g_ctxt_type ||' 4852: htp.p(' ' || 4853: ''|| g_details ||' 4857: 'NOWRAP>'|| g_hierarchy ||' 4859: 'NOWRAP>'|| g_ctxt_type ||' Line 4858: htp.p(' 4854: 4855: htp.p(' 4857: 'NOWRAP>'|| g_hierarchy ||' 4859: 'NOWRAP>'|| g_ctxt_type ||' 4861: 'NOWRAP>'|| g_ctxt_name ||' Line 4860: htp.p(' 4856: htp.p(' 4857: 'NOWRAP>'|| g_hierarchy ||' 4859: 'NOWRAP>'|| g_ctxt_type ||' 4861: 'NOWRAP>'|| g_ctxt_name ||' 4863: 'NOWRAP>'|| g_status ||' 4858: htp.p(' 4859: 'NOWRAP>'|| g_ctxt_type ||' 4861: 'NOWRAP>'|| g_ctxt_name ||' 4863: 'NOWRAP>'|| g_status ||' 4866: 'NOWRAP>'|| g_user ||' 4861: 'NOWRAP>'|| g_ctxt_name ||' 4863: 'NOWRAP>'|| g_status ||' 4866: 'NOWRAP>'|| g_user ||' 4868: 'NOWRAP>'|| g_start ||' Line 4867: htp.p(' 4863: 'NOWRAP>'|| g_status ||' 4866: 'NOWRAP>'|| g_user ||' 4868: 'NOWRAP>'|| g_start ||' 4870: 'NOWRAP>'|| g_end ||' Line 4869: htp.p(' 4865: htp.p(' 4866: 'NOWRAP>'|| g_user ||' 4868: 'NOWRAP>'|| g_start ||' 4870: 'NOWRAP>'|| g_end ||' 4872: 'NOWRAP>'|| g_duration ||' 4867: htp.p(' 4868: 'NOWRAP>'|| g_start ||' 4870: 'NOWRAP>'|| g_end ||' 4872: 'NOWRAP>'|| g_duration ||' 4872: 'NOWRAP>'|| g_duration ||' 4892: 'NOWRAP>' || 4894: one_node.hierarchy || '         '|| v_href || one_node.status_code_name || '         '|| v_href || one_node.status_code_name || '         '|| v_href || one_node.status_code_name || ' '|| v_href || one_node.status_code_name || '       '|| v_href || one_node.status_code_name || ' '|| v_href || one_node.status_code_name || ' '); 5101: htp.p(''); 5102: 5103: -- Line 5100: htp.p(' '); 5096: print_param_page_header(g_upr, g_upr_msg, g_mode_label); 5097: print_up_jscripts; 5098: 5099: htp.p(''); 5100: htp.p(' '); 5101: htp.p(''); 5102: 5103: -- 5104: -- Display the list of users (extracted from the database). Line 5101: htp.p(' '); 5097: print_up_jscripts; 5098: 5099: htp.p(''); 5100: htp.p(' '); 5101: htp.p(''); 5102: 5103: -- 5104: -- Display the list of users (extracted from the database). 5105: -- Line 5106: htp.p(' '); 5108: htp.p(''); 5108: htp.p(''); 5108: htp.p(''); Line 5117: htp.p(' '); 5113: htp.p(''|| one_user.name 5114: || ' (' || one_user.display_name || ')' || 5115: ''); 5116: END LOOP; 5117: htp.p(' '); 5118: 5119: -- 5120: -- Display the list of status values. 5121: -- Line 5122: htp.p(' '); 5124: htp.p(''); 5124: htp.p(''); 5124: htp.p(''); 5133: Line 5132: htp.p(''); 5128: -- print each status as an option 5129: htp.p(''|| 5130: one_status.meaning||''); 5131: END LOOP; 5132: htp.p(''); 5133: 5134: -- Note that the default value for the radio button is "T", 5135: -- which represents the date range. 5136: Line 5141: htp.p(' '); 5158: -- 5159: -- Display the rest of the Time Elapsed row. 5160: -- 5161: htp.p(''); 5158: -- 5159: -- Display the rest of the Time Elapsed row. 5160: -- 5161: htp.p(''); Line 5182: htp.p(''); 5178: htp.p(' 5179: 'onChange="CheckRelativeRadioButton(' || 5180: '''' ||'p_days' || '''' || ')" ' || 5181: 'size=3>'|| g_days ||''); 5182: htp.p(''); 5183: 5184: -- 5185: -- Display the Start Date "From" - "To" row. 5186: -- Line 5187: htp.p(' '); 5183: 5184: -- 5185: -- Display the Start Date "From" - "To" row. 5186: -- 5187: htp.p(' '); 5188: htp.p(' '|| 5102: 5103: -- 5104: -- Display the list of users (extracted from the database). 5105: -- 5106: htp.p(' '|| 5107: g_user ||' '); 5109: htp.p(''||g_all||''); 5110: v_locator := 1; Line 5108: htp.p(' '); 5104: -- Display the list of users (extracted from the database). 5105: -- 5106: htp.p(' '|| 5107: g_user ||' '); 5109: htp.p(''||g_all||''); 5110: v_locator := 1; 5111: FOR one_user IN valid_users_cursor LOOP 5112: -- print each valid user as an option Line 5109: htp.p(''||g_all||''); 5105: -- 5106: htp.p(' '|| 5107: g_user ||' '); 5109: htp.p(''||g_all||''); 5110: v_locator := 1; 5111: FOR one_user IN valid_users_cursor LOOP 5112: -- print each valid user as an option 5113: htp.p(''|| one_user.name Line 5113: htp.p(''|| one_user.name 5109: htp.p(' '||g_all||''); 5110: v_locator := 1; 5111: FOR one_user IN valid_users_cursor LOOP 5112: -- print each valid user as an option 5113: htp.p(''|| one_user.name 5114: || ' (' || one_user.display_name || ')' || 5115: ''); 5116: END LOOP; 5117: htp.p(' '|| 5118: 5119: -- 5120: -- Display the list of status values. 5121: -- 5122: htp.p(' '|| 5123: g_status ||' '); 5125: htp.p(''||g_all||''); 5126: v_locator := 2; Line 5124: htp.p(' '); 5120: -- Display the list of status values. 5121: -- 5122: htp.p(' '|| 5123: g_status ||' '); 5125: htp.p(''||g_all||''); 5126: v_locator := 2; 5127: FOR one_status IN statuses_cursor LOOP 5128: -- print each status as an option Line 5125: htp.p(''||g_all||''); 5121: -- 5122: htp.p(' '|| 5123: g_status ||' '); 5125: htp.p(''||g_all||''); 5126: v_locator := 2; 5127: FOR one_status IN statuses_cursor LOOP 5128: -- print each status as an option 5129: htp.p(''|| Line 5129: htp.p(''|| 5125: htp.p(' '||g_all||''); 5126: v_locator := 2; 5127: FOR one_status IN statuses_cursor LOOP 5128: -- print each status as an option 5129: htp.p(''|| 5130: one_status.meaning||''); 5131: END LOOP; 5132: htp.p(' '); 5137: -- 5138: -- Display Both Radio buttons in the first with a 5139: -- rowspan of 2 (to align the radio buttons) 5140: -- 5141: htp.p(' '); 5142: htp.p(''); 5143: htp.p(''); 5144: htp.p(''); Line 5142: htp.p(' 5145: 'CHECKED align=right onClick="set_fields_to_null()"> '); 5138: -- Display Both Radio buttons in the first '); 5158: -- 5159: -- Display the rest of the Time Elapsed row. 5160: -- Line 5157: htp.p(''); 5153: htp.p(' '); 5155: htp.p(''); 5156: htp.p(' with a 5139: -- rowspan of 2 (to align the radio buttons) 5140: -- 5141: htp.p(' '); 5142: htp.p(''); 5143: htp.p(''); 5144: htp.p(''); 5146: htp.p(''); 5139: -- rowspan of 2 (to align the radio buttons) 5140: -- 5141: htp.p(' '); 5153: htp.p(''); 5155: htp.p(''); 5156: htp.p(' 5145: 'CHECKED align=right onClick="set_fields_to_null()"> '|| Line 5143: htp.p(' '); 5142: htp.p(''); 5143: htp.p(''); 5144: htp.p(''); 5146: htp.p(''); Line 5144: htp.p(' '); 5158: -- 5159: -- Display the rest of the Time Elapsed row. Line 5156: htp.p(' 5145: 'CHECKED align=right onClick="set_fields_to_null()"> '|| 5147: g_duration ||' 5140: -- 5141: htp.p(' '); 5142: htp.p(''); 5143: htp.p(''); 5144: htp.p(''); 5146: htp.p(''); 5148: htp.p(''); Line 5146: htp.p(' '); Line 5155: htp.p(' '); 5151: htp.p(' '); 5153: htp.p(''); 5155: htp.p(''); 5156: htp.p(' 5145: 'CHECKED align=right onClick="set_fields_to_null()"> '|| 5147: g_duration ||' '|| 5142: htp.p(''); 5143: htp.p(''); 5144: htp.p(''); 5146: htp.p(''); 5148: htp.p(''); 5149: htp.p(''); 5150: htp.p(''); Line 5148: htp.p(' '); 5144: htp.p(' '); 5146: htp.p(''); 5148: htp.p(''); 5149: htp.p(''); 5150: htp.p(''); 5151: htp.p(''); Line 5149: htp.p(' '); 5145: 'CHECKED align=right onClick="set_fields_to_null()">'); 5146: htp.p(' '); 5148: htp.p(''); 5149: htp.p(''); 5150: htp.p(''); 5151: htp.p(''); 5153: htp.p(''); 5146: htp.p(' '); 5148: htp.p(''); 5149: htp.p(''); 5150: htp.p(''); 5151: htp.p(''); 5153: htp.p(''); Line 5151: htp.p(' '); 5148: htp.p(''); 5149: htp.p(''); 5150: htp.p(''); 5151: htp.p(''); 5153: htp.p(''); 5155: htp.p(''); Line 5153: htp.p(' '); 5150: htp.p(''); 5151: htp.p(''); 5153: htp.p(''); 5155: htp.p(''); 5156: htp.p(' 5145: 'CHECKED align=right onClick="set_fields_to_null()"> '|| 5147: g_duration ||' 5145: 'CHECKED align=right onClick="set_fields_to_null()"> '|| 5147: g_duration ||' 5152: ' align=right onClick="set_fields_to_null()"> '|| 5147: g_duration ||' 5152: ' align=right onClick="set_fields_to_null()"> '|| Line 5150: htp.p(' '|| 5147: g_duration ||' 5152: ' align=right onClick="set_fields_to_null()"> '|| 5154: g_active_by ||' 5147: g_duration ||' 5152: ' align=right onClick="set_fields_to_null()"> '|| 5154: g_active_by ||' '|| 5149: htp.p(' 5152: ' align=right onClick="set_fields_to_null()"> '|| 5154: g_active_by ||' '); 5157: htp.p(' 5152: ' align=right onClick="set_fields_to_null()"> '|| 5154: g_active_by ||' '); 5157: htp.p(' '); 5152: ' align=right onClick="set_fields_to_null()"> '|| 5154: g_active_by ||' '); 5157: htp.p(' '|| 5154: g_active_by ||' '); 5157: htp.p(' '); Line 5161: htp.p(' '); 5157: htp.p(' '); 5162: htp.p(' 5163: 'onChange="CheckRelativeRadioButton(' || 5164: '''' ||'p_operator' || '''' || ')">'); 5165: v_locator := 3; Line 5162: htp.p(' 5158: -- 5159: -- Display the rest of the Time Elapsed row. 5160: -- 5161: htp.p(' '); 5162: htp.p(' 5163: 'onChange="CheckRelativeRadioButton(' || 5164: '''' ||'p_operator' || '''' || ')">'); 5165: v_locator := 3; 5166: FOR one_range IN duration_ranges_cursor LOOP Line 5167: -- htp.p one_range as an option, with '>=' as the default value 5163: 'onChange="CheckRelativeRadioButton(' || 5164: '''' ||'p_operator' || '''' || ')">'); 5165: v_locator := 3; 5166: FOR one_range IN duration_ranges_cursor LOOP 5167: -- htp.p one_range as an option, with '>=' as the default value 5168: IF (one_range.lookup_code = '>=') THEN 5169: htp.p(' '|| 5170: one_range.meaning||''); 5171: ELSE Line 5169: htp.p(''|| 5165: v_locator := 3; 5166: FOR one_range IN duration_ranges_cursor LOOP 5167: -- htp.p one_range as an option, with '>=' as the default value 5168: IF (one_range.lookup_code = '>=') THEN 5169: htp.p(''|| 5170: one_range.meaning||''); 5171: ELSE 5172: htp.p(' '||' '|| 5173: one_range.meaning||''); Line 5172: htp.p(''||' '|| 5168: IF (one_range.lookup_code = '>=') THEN 5169: htp.p(' '|| 5170: one_range.meaning||''); 5171: ELSE 5172: htp.p(''||' '|| 5173: one_range.meaning||''); 5174: END IF; 5175: END LOOP; 5176: Line 5177: htp.p('   '); 5173: one_range.meaning||''); 5174: END IF; 5175: END LOOP; 5176: 5177: htp.p('  '); 5178: htp.p(' 5179: 'onChange="CheckRelativeRadioButton(' || 5180: '''' ||'p_days' || '''' || ')" ' || 5181: 'size=3>'|| g_days ||''); Line 5178: htp.p(' 5174: END IF; 5175: END LOOP; 5176: 5177: htp.p('  '); 5178: htp.p(' 5179: 'onChange="CheckRelativeRadioButton(' || 5180: '''' ||'p_days' || '''' || ')" ' || 5181: 'size=3>'|| g_days ||''); 5182: htp.p(' '); 5189: htp.p(''); 5190: htp.p(''); 5191: htp.p(''); Line 5188: htp.p(' '); 5188: htp.p(' ' || g_from || '   ' || g_to || ' '); 5184: -- 5185: -- Display the Start Date "From" - "To" row. 5186: -- 5187: htp.p(' '); 5189: htp.p(''); 5190: htp.p(''); 5191: htp.p(''); 5192: htp.p(' ' || g_from || '   ' || g_to || ' '); Line 5189: htp.p(''); 5185: -- Display the Start Date "From" - "To" row. 5186: -- 5187: htp.p(' '); 5188: htp.p(''); 5201: htp.p(''); 5203: 5204: -- Print the horizontal seperator 5205: print_footer_separator_line(); Line 5210: htp.p(''); 5206: -- Print the ok and cancel buttons 5207: print_ok_cancel_buttons('javascript:' || 5208: 'void(SubmitCurrentForm(document.Form1))'); 5209: 5210: htp.p(''); 5211: htp.centerClose; 5212: htp.bodyClose; 5213: htp.htmlClose; 5214: EXCEPTION Line 5211: htp.centerClose; 5207: print_ok_cancel_buttons('javascript:' || 5208: 'void(SubmitCurrentForm(document.Form1))'); 5209: 5210: htp.p(''); 5211: htp.centerClose; 5212: htp.bodyClose; 5213: htp.htmlClose; 5214: EXCEPTION 5215: WHEN application_exception THEN Line 5212: htp.bodyClose; 5208: 'void(SubmitCurrentForm(document.Form1))'); 5209: 5210: htp.p(''); 5211: htp.centerClose; 5212: htp.bodyClose; 5213: htp.htmlClose; 5214: EXCEPTION 5215: WHEN application_exception THEN 5216: RAISE; Line 5213: htp.htmlClose; 5209: 5210: htp.p(''); 5211: htp.centerClose; 5212: htp.bodyClose; 5213: htp.htmlClose; 5214: EXCEPTION 5215: WHEN application_exception THEN 5216: RAISE; 5217: WHEN OTHERS THEN Line 5342: htp.p(' '); 5189: htp.p(''); 5190: htp.p(''); 5191: htp.p(''); 5192: htp.p(''); 5186: -- 5187: htp.p(' '); 5188: htp.p(''); 5201: htp.p(''); 5203: 5204: -- Print the horizontal seperator Line 5201: htp.p(' ' || g_from || '   ' || g_to || ' '); 5193: htp.p(' Line 5190: htp.p(' ' || g_from || '   '); 5189: htp.p(''); 5190: htp.p(''); 5191: htp.p(''); 5192: htp.p(''); 5187: htp.p(' '); 5188: htp.p(''); 5196: htp.p(' ' || g_from || '   ' || g_to || ' '); 5193: htp.p(' 5194: 'onChange="CheckRelativeRadioButton(' || Line 5191: htp.p(' ' || g_to || ' '); 5189: htp.p(''); 5190: htp.p(''); 5191: htp.p(''); 5192: htp.p(''); 5201: htp.p(' ' || g_from || '   ' || g_to || ' '); 5193: htp.p(' 5194: 'onChange="CheckRelativeRadioButton(' || 5195: '''' ||'p_start' || '''' || ')">'); Line 5192: htp.p(' '); 5188: htp.p(' '); 5189: htp.p(''); 5190: htp.p(''); 5191: htp.p(''); 5192: htp.p(''); Line 5197: htp.p(' 5193: htp.p(' 5194: 'onChange="CheckRelativeRadioButton(' || 5195: '''' ||'p_start' || '''' || ')">'); 5196: htp.p(' ' || g_from || '   ' || g_to || ' '); 5193: htp.p(' 5194: 'onChange="CheckRelativeRadioButton(' || 5195: '''' ||'p_start' || '''' || ')">'); 5196: htp.p(' - '); Line 5193: htp.p(' 5189: htp.p(''); 5190: htp.p(''); 5191: htp.p(''); 5192: htp.p(' ' || g_from || '   ' || g_to || ' '); 5193: htp.p(' 5194: 'onChange="CheckRelativeRadioButton(' || 5195: '''' ||'p_start' || '''' || ')">'); 5196: htp.p(' - '); 5197: htp.p(' Line 5196: htp.p(' - '); 5192: htp.p(' '); 5193: htp.p(' 5194: 'onChange="CheckRelativeRadioButton(' || 5195: '''' ||'p_start' || '''' || ')">'); 5196: htp.p(' - '); 5197: htp.p(' 5198: 'onChange="CheckRelativeRadioButton(' || 5199: '''' ||'p_end' || '''' || ')">'); 5200: htp.p(' - '); 5197: htp.p(' 5198: 'onChange="CheckRelativeRadioButton(' || 5199: '''' ||'p_end' || '''' || ')">'); 5200: htp.p(' ' || Line 5200: htp.p(' - '); 5197: htp.p(' 5198: 'onChange="CheckRelativeRadioButton(' || 5199: '''' ||'p_end' || '''' || ')">'); 5200: htp.p(' ' || 5202: g_dateformat_msg || ' ' || FND_DATE.user_mask ||' ' || 5197: htp.p(' 5198: 'onChange="CheckRelativeRadioButton(' || 5199: '''' ||'p_end' || '''' || ')">'); 5200: htp.p(' ' || 5202: g_dateformat_msg || ' ' || FND_DATE.user_mask ||' '); 5338: print_time_stamp('End of Temp Table Inserts'); 5339: print_legend_link; 5340: 5341: -- print hierarchy for the user 5342: htp.p(' '); 5343: htp.tableRowOpen; 5344: htp.p(''); 5346: htp.p(' ' || 5345: ''|| g_hierarchy ||' ' || Line 5343: htp.tableRowOpen; 5339: print_legend_link; 5340: 5341: -- print hierarchy for the user 5342: htp.p(''); 5343: htp.tableRowOpen; 5344: htp.p(''); 5346: htp.p(''); Line 5344: htp.p(' ' || 5345: ''|| g_hierarchy ||' ' || 5347: ''|| g_ctxt_type ||' ' || 5340: 5341: -- print hierarchy for the user 5342: htp.p(''); 5343: htp.tableRowOpen; 5344: htp.p(''); 5346: htp.p(''); 5348: htp.p(''); 5622: htp.p(''); 5623: END LOOP; 5624: htp.p(' ' || 5345: ''|| g_hierarchy ||' ' || 5347: ''|| g_ctxt_type ||' ' || Line 5346: htp.p(' ' || 5342: htp.p(''); 5343: htp.tableRowOpen; 5344: htp.p(''); 5346: htp.p(''); 5348: htp.p(''); 5350: htp.p(''); 5346: htp.p(''); 5348: htp.p(''); 5350: htp.p(''); 5352: htp.p(''); 5348: htp.p(''); 5350: htp.p(''); 5352: htp.p(''); 5354: htp.p(''); 5350: htp.p(''); 5352: htp.p(''); 5354: htp.p(''); 5356: htp.p(''); 5352: htp.p(''); 5354: htp.p(''); 5356: htp.p(''); 5358: htp.tableRowClose; Line 5356: htp.p(' '); 5354: htp.p(''); 5356: htp.p(''); 5358: htp.tableRowClose; 5359: v_locator := 5; 5360: FOR one_node IN hierarchies_cursor(p_user) LOOP Line 5358: htp.tableRowClose; 5354: htp.p(' '); 5356: htp.p(''); 5358: htp.tableRowClose; 5359: v_locator := 5; 5360: FOR one_node IN hierarchies_cursor(p_user) LOOP 5361: -- 5362: -- Keep track of all the upper groups to be able to display Line 5367: htp.tableRowOpen; 5363: -- them in a flat directory structure like 5364: -- "\Common Applications\System Administration\" 5365: -- 5366: v_upper_group_names(one_node.level) := TRIM(one_node.hierarchy); 5367: htp.tableRowOpen; 5368: IF (one_node.parent_node_id IS NULL) THEN 5369: htp.p(' '); Line 5369: htp.p(' '); 5372: ELSIF (one_node.node_type = 'G') THEN 5373: htp.tableData(''||lpad_nbsp(one_node.level)|| one_node.hierarchy || Line 5373: htp.tableData(''||lpad_nbsp(one_node.level)|| one_node.hierarchy || 5369: htp.p(' '); 5372: ELSIF (one_node.node_type = 'G') THEN 5373: htp.tableData(''||lpad_nbsp(one_node.level)|| one_node.hierarchy || 5374: '', 'LEFT', '', 'NOWRAP'); 5375: htp.tableData(''||one_node.context_type_name||''); 5376: htp.tableData(''||one_node.context_name||''); 5377: htp.tableData(''||one_node.status_code_name||'', 'LEFT', '','NOWRAP'); Line 5375: htp.tableData(''||one_node.context_type_name||''); 5371: one_node.hierarchy || ''); 5372: ELSIF (one_node.node_type = 'G') THEN 5373: htp.tableData(''||lpad_nbsp(one_node.level)|| one_node.hierarchy || 5374: '', 'LEFT', '', 'NOWRAP'); 5375: htp.tableData(''||one_node.context_type_name||''); 5376: htp.tableData(''||one_node.context_name||''); 5377: htp.tableData(''||one_node.status_code_name||'', 'LEFT', '','NOWRAP'); 5378: htp.tableData(''||one_node.start_date||''); 5379: htp.tableData(''||one_node.end_date||''); Line 5376: htp.tableData(''||one_node.context_name||''); 5372: ELSIF (one_node.node_type = 'G') THEN 5373: htp.tableData(''||lpad_nbsp(one_node.level)|| one_node.hierarchy || 5374: '', 'LEFT', '', 'NOWRAP'); 5375: htp.tableData(''||one_node.context_type_name||''); 5376: htp.tableData(''||one_node.context_name||''); 5377: htp.tableData(''||one_node.status_code_name||'', 'LEFT', '','NOWRAP'); 5378: htp.tableData(''||one_node.start_date||''); 5379: htp.tableData(''||one_node.end_date||''); 5380: htp.tableData(''||one_node.time_elapsed||'', 'RIGHT'); Line 5377: htp.tableData(''||one_node.status_code_name||'', 'LEFT', '','NOWRAP'); 5373: htp.tableData(''||lpad_nbsp(one_node.level)|| one_node.hierarchy || 5374: '', 'LEFT', '', 'NOWRAP'); 5375: htp.tableData(''||one_node.context_type_name||''); 5376: htp.tableData(''||one_node.context_name||''); 5377: htp.tableData(''||one_node.status_code_name||'', 'LEFT', '','NOWRAP'); 5378: htp.tableData(''||one_node.start_date||''); 5379: htp.tableData(''||one_node.end_date||''); 5380: htp.tableData(''||one_node.time_elapsed||'', 'RIGHT'); 5381: Line 5378: htp.tableData(''||one_node.start_date||''); 5374: '', 'LEFT', '', 'NOWRAP'); 5375: htp.tableData(''||one_node.context_type_name||''); 5376: htp.tableData(''||one_node.context_name||''); 5377: htp.tableData(''||one_node.status_code_name||'', 'LEFT', '','NOWRAP'); 5378: htp.tableData(''||one_node.start_date||''); 5379: htp.tableData(''||one_node.end_date||''); 5380: htp.tableData(''||one_node.time_elapsed||'', 'RIGHT'); 5381: 5382: ELSIF (one_node.node_type = 'P') THEN Line 5379: htp.tableData(''||one_node.end_date||''); 5375: htp.tableData(''||one_node.context_type_name||''); 5376: htp.tableData(''||one_node.context_name||''); 5377: htp.tableData(''||one_node.status_code_name||'', 'LEFT', '','NOWRAP'); 5378: htp.tableData(''||one_node.start_date||''); 5379: htp.tableData(''||one_node.end_date||''); 5380: htp.tableData(''||one_node.time_elapsed||'', 'RIGHT'); 5381: 5382: ELSIF (one_node.node_type = 'P') THEN 5383: Line 5380: htp.tableData(''||one_node.time_elapsed||'', 'RIGHT'); 5376: htp.tableData(''||one_node.context_name||''); 5377: htp.tableData(''||one_node.status_code_name||'', 'LEFT', '','NOWRAP'); 5378: htp.tableData(''||one_node.start_date||''); 5379: htp.tableData(''||one_node.end_date||''); 5380: htp.tableData(''||one_node.time_elapsed||'', 'RIGHT'); 5381: 5382: ELSIF (one_node.node_type = 'P') THEN 5383: 5384: -- To be used by the task HREF Line 5388: htp.tableData(''||lpad_nbsp(one_node.level)|| one_node.hierarchy || 5384: -- To be used by the task HREF 5385: v_process_groups := get_parent_structure(v_upper_group_names, one_node.level, '\\'); 5386: v_ctx_type_name := one_node.context_type_name; 5387: 5388: htp.tableData(''||lpad_nbsp(one_node.level)|| one_node.hierarchy || 5389: '', 'LEFT', '', 'NOWRAP'); 5390: htp.tableData(one_node.context_type_name); 5391: htp.tableData(one_node.context_name); 5392: htp.tableData(one_node.status_code_name, 'LEFT', '','NOWRAP'); Line 5390: htp.tableData(one_node.context_type_name); 5386: v_ctx_type_name := one_node.context_type_name; 5387: 5388: htp.tableData(''||lpad_nbsp(one_node.level)|| one_node.hierarchy || 5389: '', 'LEFT', '', 'NOWRAP'); 5390: htp.tableData(one_node.context_type_name); 5391: htp.tableData(one_node.context_name); 5392: htp.tableData(one_node.status_code_name, 'LEFT', '','NOWRAP'); 5393: htp.tableData(one_node.start_date); 5394: htp.tableData(one_node.end_date); Line 5391: htp.tableData(one_node.context_name); 5387: 5388: htp.tableData(''||lpad_nbsp(one_node.level)|| one_node.hierarchy || 5389: '', 'LEFT', '', 'NOWRAP'); 5390: htp.tableData(one_node.context_type_name); 5391: htp.tableData(one_node.context_name); 5392: htp.tableData(one_node.status_code_name, 'LEFT', '','NOWRAP'); 5393: htp.tableData(one_node.start_date); 5394: htp.tableData(one_node.end_date); 5395: htp.tableData(one_node.time_elapsed, 'RIGHT'); Line 5392: htp.tableData(one_node.status_code_name, 'LEFT', '','NOWRAP'); 5388: htp.tableData(''||lpad_nbsp(one_node.level)|| one_node.hierarchy || 5389: '', 'LEFT', '', 'NOWRAP'); 5390: htp.tableData(one_node.context_type_name); 5391: htp.tableData(one_node.context_name); 5392: htp.tableData(one_node.status_code_name, 'LEFT', '','NOWRAP'); 5393: htp.tableData(one_node.start_date); 5394: htp.tableData(one_node.end_date); 5395: htp.tableData(one_node.time_elapsed, 'RIGHT'); 5396: IF (one_node.comments IS NOT NULL) THEN Line 5393: htp.tableData(one_node.start_date); 5389: '', 'LEFT', '', 'NOWRAP'); 5390: htp.tableData(one_node.context_type_name); 5391: htp.tableData(one_node.context_name); 5392: htp.tableData(one_node.status_code_name, 'LEFT', '','NOWRAP'); 5393: htp.tableData(one_node.start_date); 5394: htp.tableData(one_node.end_date); 5395: htp.tableData(one_node.time_elapsed, 'RIGHT'); 5396: IF (one_node.comments IS NOT NULL) THEN 5397: htp.tableRowClose; Line 5394: htp.tableData(one_node.end_date); 5390: htp.tableData(one_node.context_type_name); 5391: htp.tableData(one_node.context_name); 5392: htp.tableData(one_node.status_code_name, 'LEFT', '','NOWRAP'); 5393: htp.tableData(one_node.start_date); 5394: htp.tableData(one_node.end_date); 5395: htp.tableData(one_node.time_elapsed, 'RIGHT'); 5396: IF (one_node.comments IS NOT NULL) THEN 5397: htp.tableRowClose; 5398: htp.tableRowOpen; Line 5395: htp.tableData(one_node.time_elapsed, 'RIGHT'); 5391: htp.tableData(one_node.context_name); 5392: htp.tableData(one_node.status_code_name, 'LEFT', '','NOWRAP'); 5393: htp.tableData(one_node.start_date); 5394: htp.tableData(one_node.end_date); 5395: htp.tableData(one_node.time_elapsed, 'RIGHT'); 5396: IF (one_node.comments IS NOT NULL) THEN 5397: htp.tableRowClose; 5398: htp.tableRowOpen; 5399: htp.tableData('' || lpad_nbsp(one_node.level)||'('|| g_comments ||':'|| Line 5397: htp.tableRowClose; 5393: htp.tableData(one_node.start_date); 5394: htp.tableData(one_node.end_date); 5395: htp.tableData(one_node.time_elapsed, 'RIGHT'); 5396: IF (one_node.comments IS NOT NULL) THEN 5397: htp.tableRowClose; 5398: htp.tableRowOpen; 5399: htp.tableData('' || lpad_nbsp(one_node.level)||'('|| g_comments ||':'|| 5400: one_node.comments ||')', 'LEFT', '', 'NOWRAP'); 5401: END IF; Line 5398: htp.tableRowOpen; 5394: htp.tableData(one_node.end_date); 5395: htp.tableData(one_node.time_elapsed, 'RIGHT'); 5396: IF (one_node.comments IS NOT NULL) THEN 5397: htp.tableRowClose; 5398: htp.tableRowOpen; 5399: htp.tableData('' || lpad_nbsp(one_node.level)||'('|| g_comments ||':'|| 5400: one_node.comments ||')', 'LEFT', '', 'NOWRAP'); 5401: END IF; 5402: ELSE Line 5399: htp.tableData('' || lpad_nbsp(one_node.level)||'('|| g_comments ||':'|| 5395: htp.tableData(one_node.time_elapsed, 'RIGHT'); 5396: IF (one_node.comments IS NOT NULL) THEN 5397: htp.tableRowClose; 5398: htp.tableRowOpen; 5399: htp.tableData('' || lpad_nbsp(one_node.level)||'('|| g_comments ||':'|| 5400: one_node.comments ||')', 'LEFT', '', 'NOWRAP'); 5401: END IF; 5402: ELSE 5403: get_task_type_key(one_node.node_id, v_item_type, v_item_key); Line 5414: htp.p(' '); 5410: '&p_time_elapsed=' || url_encode(one_node.time_elapsed) || 5411: '&p_item_type=' || v_item_type || 5412: '&p_item_key=' || v_item_key || '")) onMouseOver=window.status="' 5413: || g_task_details || '";return true>'; 5414: htp.p(' '); 5415: htp.p(''); 5416: htp.p(''); 5417: htp.p(''); 5418: htp.p(''); Line 5415: htp.p(' '); 5411: '&p_item_type=' || v_item_type || 5412: '&p_item_key=' || v_item_key || '")) onMouseOver=window.status="' 5413: || g_task_details || '";return true>'; 5414: htp.p(' '); 5415: htp.p(''); 5416: htp.p(''); 5417: htp.p(''); 5418: htp.p(''); 5419: htp.p(''); Line 5416: htp.p(' '); 5412: '&p_item_key=' || v_item_key || '")) onMouseOver=window.status="' 5413: || g_task_details || '";return true>'; 5414: htp.p(' '); 5415: htp.p(''); 5416: htp.p(''); 5417: htp.p(''); 5418: htp.p(''); 5419: htp.p(''); 5420: htp.p(''); Line 5417: htp.p(' '); 5413: || g_task_details || '";return true>'; 5414: htp.p(' '); 5415: htp.p(''); 5416: htp.p(''); 5417: htp.p(''); 5418: htp.p(''); 5419: htp.p(''); 5420: htp.p(''); 5421: END IF; Line 5418: htp.p(' '); 5414: htp.p(' '); 5415: htp.p(''); 5416: htp.p(''); 5417: htp.p(''); 5418: htp.p(''); 5419: htp.p(''); 5420: htp.p(''); 5421: END IF; 5422: htp.tableRowClose; Line 5419: htp.p(' '); 5415: htp.p(' '); 5416: htp.p(''); 5417: htp.p(''); 5418: htp.p(''); 5419: htp.p(''); 5420: htp.p(''); 5421: END IF; 5422: htp.tableRowClose; 5423: /* Line 5420: htp.p(' '); 5416: htp.p(' '); 5417: htp.p(''); 5418: htp.p(''); 5419: htp.p(''); 5420: htp.p(''); 5421: END IF; 5422: htp.tableRowClose; 5423: /* 5424: dbms_output.put_line('Name=' || one_node.hierarchy); Line 5422: htp.tableRowClose; 5418: htp.p(' '); 5419: htp.p(''); 5420: htp.p(''); 5421: END IF; 5422: htp.tableRowClose; 5423: /* 5424: dbms_output.put_line('Name=' || one_node.hierarchy); 5425: dbms_output.put_line('Type=' || one_node.node_type); 5426: dbms_output.put_line('start=' || one_node.start_date); Line 5430: htp.tableClose; 5426: dbms_output.put_line('start=' || one_node.start_date); 5427: dbms_output.put_line('end=' || one_node.end_date); 5428: */ 5429: END LOOP; 5430: htp.tableClose; 5431: ELSE 5432: print_time_stamp('Start of Temp Table Inserts'); 5433: IF (p_time_or_period = 'T') THEN 5434: IF (p_operator = '<=') THEN Line 5456: htp.p(' ' || 5345: ''|| g_hierarchy ||' ' || 5347: ''|| g_ctxt_type ||' ' || 5349: ''|| g_ctxt_name ||' ' || Line 5348: htp.p(' ' || 5344: htp.p(' ' || 5345: ''|| g_hierarchy ||' ' || 5347: ''|| g_ctxt_type ||' ' || 5349: ''|| g_ctxt_name ||' ' || 5351: ''|| g_status ||' ' || Line 5350: htp.p(' ' || 5346: htp.p(' ' || 5347: ''|| g_ctxt_type ||' ' || 5349: ''|| g_ctxt_name ||' ' || 5351: ''|| g_status ||' ' || 5353: ''|| g_start ||' ' || Line 5352: htp.p(' ' || 5348: htp.p(' ' || 5349: ''|| g_ctxt_name ||' ' || 5351: ''|| g_status ||' ' || 5353: ''|| g_start ||' ' || 5355: ''|| g_end ||' ' || Line 5354: htp.p(' ' || 5350: htp.p(' ' || 5351: ''|| g_status ||' ' || 5353: ''|| g_start ||' ' || 5355: ''|| g_end ||' ' || 5357: ''|| g_duration ||' ' || 5352: htp.p(' ' || 5353: ''|| g_start ||' ' || 5355: ''|| g_end ||' ' || 5357: ''|| g_duration ||' ' || 5355: ''|| g_end ||' ' || 5357: ''|| g_duration ||' 5370: 'NOWRAP>' || 5371: one_node.hierarchy || ' 5365: -- 5366: v_upper_group_names(one_node.level) := TRIM(one_node.hierarchy); 5367: htp.tableRowOpen; 5368: IF (one_node.parent_node_id IS NULL) THEN 5369: htp.p(' 5370: 'NOWRAP>' || 5371: one_node.hierarchy || ' 5370: 'NOWRAP>' || 5371: one_node.hierarchy || '         '|| v_href || one_node.status_code_name || ' ' || one_node.start_date || '         '|| v_href || one_node.status_code_name || ' ' || one_node.start_date || ' ' || one_node.end_date || '          '|| v_href || one_node.status_code_name || ' ' || one_node.start_date || ' ' || one_node.end_date || '  ' || one_node.time_elapsed || ' '|| v_href || one_node.status_code_name || '       '|| v_href || one_node.status_code_name || ' ' || one_node.start_date || ' ' || one_node.end_date || '  ' || one_node.time_elapsed || ' ' || one_node.start_date || '       '|| v_href || one_node.status_code_name || ' ' || one_node.start_date || ' ' || one_node.end_date || '  ' || one_node.time_elapsed || ' ' || one_node.end_date || '      '|| v_href || one_node.status_code_name || ' ' || one_node.start_date || ' ' || one_node.end_date || '  ' || one_node.time_elapsed || ' ' || one_node.time_elapsed || '   '|| v_href || one_node.status_code_name || ' ' || one_node.start_date || ' ' || one_node.end_date || '  ' || one_node.time_elapsed || ' ' || one_node.start_date || ' ' || one_node.end_date || '  ' || one_node.time_elapsed || ' '); 5452: print_user_report_summary; 5453: 5454: print_legend_link; 5455: 5456: htp.p(' '); 5457: -- print hierarchy for each user 5458: htp.tableRowOpen; 5459: htp.p(''); Line 5458: htp.tableRowOpen; 5454: print_legend_link; 5455: 5456: htp.p(' ' || 5460: ''|| g_hierarchy ||' '); 5457: -- print hierarchy for each user 5458: htp.tableRowOpen; 5459: htp.p(''); 5461: htp.p(''); Line 5459: htp.p(' ' || 5460: ''|| g_hierarchy ||' ' || 5462: ''|| g_ctxt_type ||' ' || 5455: 5456: htp.p(''); 5457: -- print hierarchy for each user 5458: htp.tableRowOpen; 5459: htp.p(''); 5461: htp.p(''); 5463: htp.p(''); 5461: htp.p(''); 5463: htp.p(''); 5465: htp.p(''); 5461: htp.p(''); 5463: htp.p(''); 5465: htp.p(''); 5467: htp.p(''); 5463: htp.p(''); 5465: htp.p(''); 5467: htp.p(''); 5469: htp.p(''); 5465: htp.p(''); 5467: htp.p(''); 5469: htp.p(''); 5471: htp.p(''); 5467: htp.p(''); 5469: htp.p(''); 5471: htp.p(''); 5473: htp.tableRowClose; Line 5471: htp.p(' '); 5469: htp.p(''); 5471: htp.p(''); 5473: htp.tableRowClose; 5474: 5475: i := 0; Line 5473: htp.tableRowClose; 5469: htp.p(' '); 5471: htp.p(''); 5473: htp.tableRowClose; 5474: 5475: i := 0; 5476: v_locator := 6; 5477: FOR one IN valid_users_cursor LOOP Line 5488: htp.p(' '); 5492: FOR one_node IN hierarchies_cursor(one.user_name) LOOP Line 5499: htp.tableRowOpen; 5495: -- them in a flat directory structure like 5496: -- "\Common Applications\System Administration\" 5497: -- 5498: v_upper_group_names(one_node.level) := TRIM(one_node.hierarchy); 5499: htp.tableRowOpen; 5500: IF (one_node.parent_node_id IS NULL) THEN 5501: htp.p(' '); Line 5501: htp.p(' '); 5504: ELSIF (one_node.node_type = 'G') THEN 5505: htp.tableData(''||lpad_nbsp(one_node.level) || one_node.hierarchy Line 5505: htp.tableData(''||lpad_nbsp(one_node.level) || one_node.hierarchy 5501: htp.p(' '); 5504: ELSIF (one_node.node_type = 'G') THEN 5505: htp.tableData(''||lpad_nbsp(one_node.level) || one_node.hierarchy 5506: ||'', 'LEFT', '', 'NOWRAP'); 5507: htp.tableData(''||one_node.context_type_name||''); 5508: htp.tableData(''||one_node.context_name||''); 5509: htp.tableData(''||one_node.status_code_name||''); Line 5507: htp.tableData(''||one_node.context_type_name||''); 5503: one_node.hierarchy || ''); 5504: ELSIF (one_node.node_type = 'G') THEN 5505: htp.tableData(''||lpad_nbsp(one_node.level) || one_node.hierarchy 5506: ||'', 'LEFT', '', 'NOWRAP'); 5507: htp.tableData(''||one_node.context_type_name||''); 5508: htp.tableData(''||one_node.context_name||''); 5509: htp.tableData(''||one_node.status_code_name||''); 5510: htp.tableData(''||one_node.start_date||''); 5511: htp.tableData(''||one_node.end_date||''); Line 5508: htp.tableData(''||one_node.context_name||''); 5504: ELSIF (one_node.node_type = 'G') THEN 5505: htp.tableData(''||lpad_nbsp(one_node.level) || one_node.hierarchy 5506: ||'', 'LEFT', '', 'NOWRAP'); 5507: htp.tableData(''||one_node.context_type_name||''); 5508: htp.tableData(''||one_node.context_name||''); 5509: htp.tableData(''||one_node.status_code_name||''); 5510: htp.tableData(''||one_node.start_date||''); 5511: htp.tableData(''||one_node.end_date||''); 5512: htp.tableData(''||one_node.time_elapsed||'', 'RIGHT'); Line 5509: htp.tableData(''||one_node.status_code_name||''); 5505: htp.tableData(''||lpad_nbsp(one_node.level) || one_node.hierarchy 5506: ||'', 'LEFT', '', 'NOWRAP'); 5507: htp.tableData(''||one_node.context_type_name||''); 5508: htp.tableData(''||one_node.context_name||''); 5509: htp.tableData(''||one_node.status_code_name||''); 5510: htp.tableData(''||one_node.start_date||''); 5511: htp.tableData(''||one_node.end_date||''); 5512: htp.tableData(''||one_node.time_elapsed||'', 'RIGHT'); 5513: ELSIF (one_node.node_type = 'P') THEN Line 5510: htp.tableData(''||one_node.start_date||''); 5506: ||'', 'LEFT', '', 'NOWRAP'); 5507: htp.tableData(''||one_node.context_type_name||''); 5508: htp.tableData(''||one_node.context_name||''); 5509: htp.tableData(''||one_node.status_code_name||''); 5510: htp.tableData(''||one_node.start_date||''); 5511: htp.tableData(''||one_node.end_date||''); 5512: htp.tableData(''||one_node.time_elapsed||'', 'RIGHT'); 5513: ELSIF (one_node.node_type = 'P') THEN 5514: -- To be used by the task HREF Line 5511: htp.tableData(''||one_node.end_date||''); 5507: htp.tableData(''||one_node.context_type_name||''); 5508: htp.tableData(''||one_node.context_name||''); 5509: htp.tableData(''||one_node.status_code_name||''); 5510: htp.tableData(''||one_node.start_date||''); 5511: htp.tableData(''||one_node.end_date||''); 5512: htp.tableData(''||one_node.time_elapsed||'', 'RIGHT'); 5513: ELSIF (one_node.node_type = 'P') THEN 5514: -- To be used by the task HREF 5515: v_process_groups := get_parent_structure( Line 5512: htp.tableData(''||one_node.time_elapsed||'', 'RIGHT'); 5508: htp.tableData(''||one_node.context_name||''); 5509: htp.tableData(''||one_node.status_code_name||''); 5510: htp.tableData(''||one_node.start_date||''); 5511: htp.tableData(''||one_node.end_date||''); 5512: htp.tableData(''||one_node.time_elapsed||'', 'RIGHT'); 5513: ELSIF (one_node.node_type = 'P') THEN 5514: -- To be used by the task HREF 5515: v_process_groups := get_parent_structure( 5516: v_upper_group_names, Line 5519: htp.tableData(''||lpad_nbsp(one_node.level) || 5515: v_process_groups := get_parent_structure( 5516: v_upper_group_names, 5517: one_node.level, '\\'); 5518: v_ctx_type_name := one_node.context_type_name; 5519: htp.tableData(''||lpad_nbsp(one_node.level) || 5520: one_node.hierarchy 5521: ||'', 'LEFT', '', 'NOWRAP'); 5522: htp.tableData(one_node.context_type_name); 5523: htp.tableData(one_node.context_name); Line 5522: htp.tableData(one_node.context_type_name); 5518: v_ctx_type_name := one_node.context_type_name; 5519: htp.tableData(''||lpad_nbsp(one_node.level) || 5520: one_node.hierarchy 5521: ||'', 'LEFT', '', 'NOWRAP'); 5522: htp.tableData(one_node.context_type_name); 5523: htp.tableData(one_node.context_name); 5524: htp.tableData(one_node.status_code_name); 5525: htp.tableData(one_node.start_date); 5526: htp.tableData(one_node.end_date); Line 5523: htp.tableData(one_node.context_name); 5519: htp.tableData(''||lpad_nbsp(one_node.level) || 5520: one_node.hierarchy 5521: ||'', 'LEFT', '', 'NOWRAP'); 5522: htp.tableData(one_node.context_type_name); 5523: htp.tableData(one_node.context_name); 5524: htp.tableData(one_node.status_code_name); 5525: htp.tableData(one_node.start_date); 5526: htp.tableData(one_node.end_date); 5527: htp.tableData(one_node.time_elapsed, 'RIGHT'); Line 5524: htp.tableData(one_node.status_code_name); 5520: one_node.hierarchy 5521: ||'', 'LEFT', '', 'NOWRAP'); 5522: htp.tableData(one_node.context_type_name); 5523: htp.tableData(one_node.context_name); 5524: htp.tableData(one_node.status_code_name); 5525: htp.tableData(one_node.start_date); 5526: htp.tableData(one_node.end_date); 5527: htp.tableData(one_node.time_elapsed, 'RIGHT'); 5528: IF (one_node.comments IS NOT NULL) THEN Line 5525: htp.tableData(one_node.start_date); 5521: ||'', 'LEFT', '', 'NOWRAP'); 5522: htp.tableData(one_node.context_type_name); 5523: htp.tableData(one_node.context_name); 5524: htp.tableData(one_node.status_code_name); 5525: htp.tableData(one_node.start_date); 5526: htp.tableData(one_node.end_date); 5527: htp.tableData(one_node.time_elapsed, 'RIGHT'); 5528: IF (one_node.comments IS NOT NULL) THEN 5529: htp.tableRowClose; Line 5526: htp.tableData(one_node.end_date); 5522: htp.tableData(one_node.context_type_name); 5523: htp.tableData(one_node.context_name); 5524: htp.tableData(one_node.status_code_name); 5525: htp.tableData(one_node.start_date); 5526: htp.tableData(one_node.end_date); 5527: htp.tableData(one_node.time_elapsed, 'RIGHT'); 5528: IF (one_node.comments IS NOT NULL) THEN 5529: htp.tableRowClose; 5530: htp.tableRowOpen; Line 5527: htp.tableData(one_node.time_elapsed, 'RIGHT'); 5523: htp.tableData(one_node.context_name); 5524: htp.tableData(one_node.status_code_name); 5525: htp.tableData(one_node.start_date); 5526: htp.tableData(one_node.end_date); 5527: htp.tableData(one_node.time_elapsed, 'RIGHT'); 5528: IF (one_node.comments IS NOT NULL) THEN 5529: htp.tableRowClose; 5530: htp.tableRowOpen; 5531: htp.tableData('' || lpad_nbsp(one_node.level)|| '('|| g_comments ||':'|| Line 5529: htp.tableRowClose; 5525: htp.tableData(one_node.start_date); 5526: htp.tableData(one_node.end_date); 5527: htp.tableData(one_node.time_elapsed, 'RIGHT'); 5528: IF (one_node.comments IS NOT NULL) THEN 5529: htp.tableRowClose; 5530: htp.tableRowOpen; 5531: htp.tableData('' || lpad_nbsp(one_node.level)|| '('|| g_comments ||':'|| 5532: one_node.comments || ')', 'LEFT', '', 'NOWRAP'); 5533: END IF; Line 5530: htp.tableRowOpen; 5526: htp.tableData(one_node.end_date); 5527: htp.tableData(one_node.time_elapsed, 'RIGHT'); 5528: IF (one_node.comments IS NOT NULL) THEN 5529: htp.tableRowClose; 5530: htp.tableRowOpen; 5531: htp.tableData('' || lpad_nbsp(one_node.level)|| '('|| g_comments ||':'|| 5532: one_node.comments || ')', 'LEFT', '', 'NOWRAP'); 5533: END IF; 5534: ELSE Line 5531: htp.tableData('' || lpad_nbsp(one_node.level)|| '('|| g_comments ||':'|| 5527: htp.tableData(one_node.time_elapsed, 'RIGHT'); 5528: IF (one_node.comments IS NOT NULL) THEN 5529: htp.tableRowClose; 5530: htp.tableRowOpen; 5531: htp.tableData('' || lpad_nbsp(one_node.level)|| '('|| g_comments ||':'|| 5532: one_node.comments || ')', 'LEFT', '', 'NOWRAP'); 5533: END IF; 5534: ELSE 5535: get_task_type_key(one_node.node_id, v_item_type, v_item_key); Line 5547: htp.p(' '); 5543: '&p_time_elapsed=' || url_encode(one_node.time_elapsed) || 5544: '&p_item_type=' || v_item_type || 5545: '&p_item_key=' || v_item_key || '")) onMouseOver=window.status="' 5546: || g_task_details || '";return true>'; 5547: htp.p(' '); 5548: htp.p(''); 5549: htp.p(''); 5550: htp.p(''); 5551: htp.p(''); Line 5548: htp.p(' '); 5544: '&p_item_type=' || v_item_type || 5545: '&p_item_key=' || v_item_key || '")) onMouseOver=window.status="' 5546: || g_task_details || '";return true>'; 5547: htp.p(' '); 5548: htp.p(''); 5549: htp.p(''); 5550: htp.p(''); 5551: htp.p(''); 5552: htp.p(''); Line 5549: htp.p(' '); 5545: '&p_item_key=' || v_item_key || '")) onMouseOver=window.status="' 5546: || g_task_details || '";return true>'; 5547: htp.p(' '); 5548: htp.p(''); 5549: htp.p(''); 5550: htp.p(''); 5551: htp.p(''); 5552: htp.p(''); 5553: htp.p(''); Line 5550: htp.p(' '); 5546: || g_task_details || '";return true>'; 5547: htp.p(' '); 5548: htp.p(''); 5549: htp.p(''); 5550: htp.p(''); 5551: htp.p(''); 5552: htp.p(''); 5553: htp.p(''); 5554: END IF; Line 5551: htp.p(' '); 5547: htp.p(' '); 5548: htp.p(''); 5549: htp.p(''); 5550: htp.p(''); 5551: htp.p(''); 5552: htp.p(''); 5553: htp.p(''); 5554: END IF; 5555: htp.tableRowClose; Line 5552: htp.p(' '); 5548: htp.p(' '); 5549: htp.p(''); 5550: htp.p(''); 5551: htp.p(''); 5552: htp.p(''); 5553: htp.p(''); 5554: END IF; 5555: htp.tableRowClose; 5556: END LOOP; Line 5553: htp.p(' '); 5549: htp.p(' '); 5550: htp.p(''); 5551: htp.p(''); 5552: htp.p(''); 5553: htp.p(''); 5554: END IF; 5555: htp.tableRowClose; 5556: END LOOP; 5557: i := i + 1; Line 5555: htp.tableRowClose; 5551: htp.p(' '); 5552: htp.p(''); 5553: htp.p(''); 5554: END IF; 5555: htp.tableRowClose; 5556: END LOOP; 5557: i := i + 1; 5558: END IF; 5559: END LOOP; Line 5561: htp.tableClose; 5557: i := i + 1; 5558: END IF; 5559: END LOOP; 5560: print_back_to_top(7); 5561: htp.tableClose; 5562: END IF; 5563: 5564: -- print Table closing tag 5565: -- htp.tableClose; Line 5565: -- htp.tableClose; 5561: htp.tableClose; 5562: END IF; 5563: 5564: -- print Table closing tag 5565: -- htp.tableClose; 5566: 5567: -- print report legend 5568: print_legend (TRUE); 5569: Line 5578: htp.tableClose; 5574: 5575: EXCEPTION 5576: WHEN NO_DATA_FOUND THEN 5577: -- print Table closing tag 5578: htp.tableClose; 5579: print_related_reports('AZW_RPT_ISR'); 5580: WHEN application_exception THEN 5581: RAISE; 5582: WHEN OTHERS THEN Line 5607: htp.p(' ' || 5460: ''|| g_hierarchy ||' ' || 5462: ''|| g_ctxt_type ||' ' || Line 5461: htp.p(' ' || 5457: -- print hierarchy for each user 5458: htp.tableRowOpen; 5459: htp.p(' ' || 5460: ''|| g_hierarchy ||' ' || 5462: ''|| g_ctxt_type ||' ' || 5464: ''|| g_ctxt_name ||' ' || Line 5463: htp.p(' ' || 5459: htp.p(' ' || 5460: ''|| g_hierarchy ||' ' || 5462: ''|| g_ctxt_type ||' ' || 5464: ''|| g_ctxt_name ||' ' || 5466: ''|| g_status ||' ' || Line 5465: htp.p(' ' || 5461: htp.p(' ' || 5462: ''|| g_ctxt_type ||' ' || 5464: ''|| g_ctxt_name ||' ' || 5466: ''|| g_status ||' ' || 5468: ''|| g_start ||' ' || Line 5467: htp.p(' ' || 5463: htp.p(' ' || 5464: ''|| g_ctxt_name ||' ' || 5466: ''|| g_status ||' ' || 5468: ''|| g_start ||' ' || 5470: ''|| g_end ||' ' || Line 5469: htp.p(' ' || 5465: htp.p(' ' || 5466: ''|| g_status ||' ' || 5468: ''|| g_start ||' ' || 5470: ''|| g_end ||' ' || 5472: ''|| g_duration ||' ' || 5467: htp.p(' ' || 5468: ''|| g_start ||' ' || 5470: ''|| g_end ||' ' || 5472: ''|| g_duration ||' ' || 5470: ''|| g_end ||' ' || 5472: ''|| g_duration ||' ' || 5484: IF (v_count <> 0) THEN 5485: IF (i > 0) THEN 5486: print_back_to_top(7); 5487: END IF; 5488: htp.p(' ' || 5489: ''|| 5490: g_user || ': ' || one.user_name || ' (' || one.display_name || ')' 5491: || ' 5502: 'NOWRAP>' || 5503: one_node.hierarchy || ' 5497: -- 5498: v_upper_group_names(one_node.level) := TRIM(one_node.hierarchy); 5499: htp.tableRowOpen; 5500: IF (one_node.parent_node_id IS NULL) THEN 5501: htp.p(' 5502: 'NOWRAP>' || 5503: one_node.hierarchy || ' 5502: 'NOWRAP>' || 5503: one_node.hierarchy || '         '|| v_href || one_node.status_code_name || ' ' || one_node.start_date || '         '|| v_href || one_node.status_code_name || ' ' || one_node.start_date || ' ' || one_node.end_date || '          '|| v_href || one_node.status_code_name || ' ' || one_node.start_date || ' ' || one_node.end_date || '  ' || one_node.time_elapsed || ' '|| v_href || one_node.status_code_name || '       '|| v_href || one_node.status_code_name || ' ' || one_node.start_date || ' ' || one_node.end_date || '  ' || one_node.time_elapsed || ' ' || one_node.start_date || '       '|| v_href || one_node.status_code_name || ' ' || one_node.start_date || ' ' || one_node.end_date || '  ' || one_node.time_elapsed || ' ' || one_node.end_date || '      '|| v_href || one_node.status_code_name || ' ' || one_node.start_date || ' ' || one_node.end_date || '  ' || one_node.time_elapsed || ' ' || one_node.time_elapsed || '   '|| v_href || one_node.status_code_name || ' ' || one_node.start_date || ' ' || one_node.end_date || '  ' || one_node.time_elapsed || ' ' || one_node.start_date || ' ' || one_node.end_date || '  ' || one_node.time_elapsed || ' '); 5603: GROUP BY ASSIGNED_USER; 5604: 5605: BEGIN 5606: -- Print the Table header 5607: htp.p(' '); 5608: htp.p(''); 5611: htp.p(''); Line 5608: htp.p(' '); 5618: 5619: FOR current_rec IN user_task_count LOOP 5620: htp.p(' '); 5622: htp.p(''); 5623: END LOOP; 5624: htp.p(' ' || 5609: '' || g_summary 5610: ||' ' || 5604: 5605: BEGIN 5606: -- Print the Table header 5607: htp.p(''); 5608: htp.p(''); 5611: htp.p(''); 5612: htp.p(''); 5607: htp.p(' ' || 5609: '' || g_summary 5610: ||' '|| Line 5611: htp.p(' '); 5608: htp.p(''); 5611: htp.p(''); 5612: htp.p(''); 5614: htp.p(''); Line 5612: htp.p(' '); 5611: htp.p(''); 5612: htp.p(''); 5614: htp.p(''); 5616: htp.p(''); Line 5614: htp.p(' '); 5611: htp.p(''); 5612: htp.p(''); 5614: htp.p(''); 5616: htp.p(''); 5617: 5618: Line 5616: htp.p(''); 5612: htp.p(' '); 5614: htp.p(''); 5616: htp.p(''); 5617: 5618: 5619: FOR current_rec IN user_task_count LOOP 5620: htp.p(''); 5617: 5618: 5619: FOR current_rec IN user_task_count LOOP 5620: htp.p(''); 5622: htp.p(''); 5623: END LOOP; 5624: htp.p(' ' || 5609: '' || g_summary 5610: ||' '|| 5613: g_user ||' '|| 5615: g_num_tasks ||' '|| 5608: htp.p(' ' || 5609: '' || g_summary 5610: ||' '|| 5613: g_user ||' '|| 5615: g_num_tasks ||' '|| 5610: ||' '|| 5613: g_user ||' '|| 5615: g_num_tasks ||' '|| 5613: g_user ||' '|| 5615: g_num_tasks ||' '|| Line 5620: htp.p(' '|| 5616: htp.p(' '|| 5621: current_rec.assigned_user ||' '|| current_rec.num_tasks ||' '); Line 5622: htp.p(' '|| current_rec.num_tasks ||' '|| 5621: current_rec.assigned_user ||' '|| current_rec.num_tasks ||' '); 5625: return; 5626: Line 5624: htp.p(' '); 5620: htp.p(' '|| 5621: current_rec.assigned_user ||' '|| current_rec.num_tasks ||' '); 5625: return; 5626: 5627: EXCEPTION 5628: WHEN application_exception THEN Line 5686: -- htp.p(''); 5682: */ 5683: PROCEDURE print_time_stamp (v_string VARCHAR2) IS 5684: 5685: BEGIN 5686: -- htp.p(''); 5687: NULL; 5688: END print_time_stamp; 5689: 5690: /* Line 5702: htp.p(''); 5698: */ 5699: PROCEDURE print_legend_link IS 5700: 5701: BEGIN 5702: htp.p(' '); 5703: htp.p(''); 5705: htp.p(' ' || 5704: g_report_legend || ' '); 5706: htp.p(' '); Line 5703: htp.p(' ' || 5699: PROCEDURE print_legend_link IS 5700: 5701: BEGIN 5702: htp.p(''); 5703: htp.p(''); 5705: htp.p(' ' || 5704: g_report_legend || ' '); 5706: htp.p(' '); 5707: END print_legend_link; Line 5705: htp.p(' '); 5701: BEGIN 5702: htp.p(''); 5703: htp.p(''); 5705: htp.p(' ' || 5704: g_report_legend || ' '); 5706: htp.p(' '); 5707: END print_legend_link; 5708: 5709: /* Line 5706: htp.p(' '); 5702: htp.p(''); 5703: htp.p(''); 5705: htp.p(' ' || 5704: g_report_legend || ' '); 5706: htp.p(' '); 5707: END print_legend_link; 5708: 5709: /* 5710: ** Line 5720: htp.p(' '); 5716: */ 5717: PROCEDURE print_legend (p_status BOOLEAN DEFAULT FALSE) IS 5718: 5719: BEGIN 5720: htp.p(' '); 5721: htp.p(''); 5722: htp.p(''); 5724: htp.p(''); Line 5721: htp.p(' ' || 5723: '' || g_report_legend ||' '|| g_group_legend ||' '); 5717: PROCEDURE print_legend (p_status BOOLEAN DEFAULT FALSE) IS 5718: 5719: BEGIN 5720: htp.p(' '); 5721: htp.p(' '); 5722: htp.p(''); 5724: htp.p(''); 5725: htp.p(''); Line 5722: htp.p(' ' || 5723: '' || g_report_legend ||' '|| g_group_legend ||' '|| g_subgrp_legend ||' ' || 5718: 5719: BEGIN 5720: htp.p(' '); 5721: htp.p(''); 5722: htp.p(''); 5724: htp.p(''); 5725: htp.p(''); 5726: htp.p(''); Line 5724: htp.p(' '); 5720: htp.p(' '); 5721: htp.p(' ' || 5723: '' || g_report_legend ||' '|| g_group_legend ||' '|| g_subgrp_legend ||' '|| g_process_legend ||' '|| g_group_legend ||' '); 5722: htp.p(''); 5724: htp.p(''); 5725: htp.p(''); 5726: htp.p(''); 5727: IF (p_status) THEN 5728: htp.p(''); Line 5725: htp.p(' '); 5721: htp.p(' ' || 5723: '' || g_report_legend ||' '|| g_group_legend ||' '|| g_subgrp_legend ||' '|| g_process_legend ||' '|| g_task_legend ||' '|| g_subgrp_legend ||' '); 5722: htp.p(''); 5724: htp.p(''); 5725: htp.p(''); 5726: htp.p(''); 5727: IF (p_status) THEN 5728: htp.p(''); 5729: END IF; Line 5726: htp.p(' '); 5722: htp.p(' '); 5724: htp.p(''); 5725: htp.p(''); 5726: htp.p(''); 5727: IF (p_status) THEN 5728: htp.p(''); 5729: END IF; 5730: htp.tableClose; Line 5728: htp.p(' '); 5724: htp.p(' '); 5725: htp.p(''); 5726: htp.p(''); 5727: IF (p_status) THEN 5728: htp.p(''); 5729: END IF; 5730: htp.tableClose; 5731: END print_legend; 5732: Line 5730: htp.tableClose; 5726: htp.p(' '); 5727: IF (p_status) THEN 5728: htp.p(''); 5729: END IF; 5730: htp.tableClose; 5731: END print_legend; 5732: 5733: /* 5734: ** Line 5761: htp.p(''); 5757: IF (g_web_agent IS NULL) THEN 5758: get_web_agent; 5759: get_translated_labels; 5760: END IF; 5761: htp.p(''); 5762: htp.title(g_task_details); 5763: print_html_style; 5764: htp.p(''); 5765: Line 5762: htp.title(g_task_details); 5758: get_web_agent; 5759: get_translated_labels; 5760: END IF; 5761: htp.p(''); 5762: htp.title(g_task_details); 5763: print_html_style; 5764: htp.p(''); 5765: 5766: -- Print the Table header Line 5764: htp.p(''); 5760: END IF; 5761: htp.p(''); 5762: htp.title(g_task_details); 5763: print_html_style; 5764: htp.p(''); 5765: 5766: -- Print the Table header 5767: htp.p(' ' || 5723: '' || g_report_legend ||' '|| g_group_legend ||' '|| g_subgrp_legend ||' '|| g_process_legend ||' '|| g_task_legend ||' '|| g_process_legend ||' ' || 5723: '' || g_report_legend ||' '|| g_group_legend ||' '|| g_subgrp_legend ||' '|| g_process_legend ||' '|| g_task_legend ||' '|| g_task_legend ||' '|| g_group_legend ||' '|| g_subgrp_legend ||' '|| g_process_legend ||' '|| g_task_legend ||' '|| g_process_legend ||' '|| g_task_legend ||' '); 5768: htp.p(''); 5911: print_task_steps(p_item_type, p_item_key, step.name, g_curr_process_level); 5912: ELSIF step.type = 'FUNCTION' AND step.name = 'START' THEN Line 5916: htp.p(' '); 5912: ELSIF step.type = 'FUNCTION' AND step.name = 'START' THEN 5913: NULL; 5914: ELSIF step.type = 'FUNCTION' AND step.name = 'END' THEN 5915: IF p_process_level > 1 THEN 5916: htp.p(' '); 5917: END IF; 5918: g_curr_process_level := g_curr_process_level - 1; 5919: ELSE 5920: htp.p(''); Line 5920: htp.p(' '); 5916: htp.p(' '); 5917: END IF; 5918: g_curr_process_level := g_curr_process_level - 1; 5919: ELSE 5920: htp.p(''); 5921: htp.p(''); 5922: htp.p(''); 5923: htp.p(''); 5924: END IF; Line 5921: htp.p(' '); 5917: END IF; 5918: g_curr_process_level := g_curr_process_level - 1; 5919: ELSE 5920: htp.p(' '); 5921: htp.p(''); 5922: htp.p(''); 5923: htp.p(''); 5924: END IF; 5925: END LOOP; Line 5922: htp.p(' '); 5918: g_curr_process_level := g_curr_process_level - 1; 5919: ELSE 5920: htp.p(' '); 5921: htp.p(''); 5922: htp.p(''); 5923: htp.p(''); 5924: END IF; 5925: END LOOP; 5926: Line 5923: htp.p(' '); 5919: ELSE 5920: htp.p(' '); 5921: htp.p(''); 5922: htp.p(''); 5923: htp.p(''); 5924: END IF; 5925: END LOOP; 5926: 5927: EXCEPTION Line 6021: htp.htmlOpen; 6017: get_translated_labels; 6018: END IF; 6019: v_locator := 1; 6020: 6021: htp.htmlOpen; 6022: htp.headOpen; 6023: htp.title(g_step_details); 6024: htp.headClose; 6025: Line 6022: htp.headOpen; 6018: END IF; 6019: v_locator := 1; 6020: 6021: htp.htmlOpen; 6022: htp.headOpen; 6023: htp.title(g_step_details); 6024: htp.headClose; 6025: 6026: Line 6023: htp.title(g_step_details); 6019: v_locator := 1; 6020: 6021: htp.htmlOpen; 6022: htp.headOpen; 6023: htp.title(g_step_details); 6024: htp.headClose; 6025: 6026: 6027: -- Line 6024: htp.headClose; 6020: 6021: htp.htmlOpen; 6022: htp.headOpen; 6023: htp.title(g_step_details); 6024: htp.headClose; 6025: 6026: 6027: -- 6028: -- get the product list string into the id table Line 6080: htp.p(' ' || Line 5767: htp.p(''); 5763: print_html_style; 5764: htp.p(''); 5765: 5766: -- Print the Table header 5767: htp.p(' '); 5768: htp.p(''); 5770: htp.tableRowOpen; 5771: htp.p(' ' || 5769: '' || g_task_params ||' ' || Line 5768: htp.p(' ' || 5764: htp.p(''); 5765: 5766: -- Print the Table header 5767: htp.p(''); 5768: htp.p(''); 5770: htp.tableRowOpen; 5771: htp.p(''); Line 5770: htp.tableRowOpen; 5766: -- Print the Table header 5767: htp.p(' ' || 5769: '' || g_task_params ||' ' || 5772: ''|| g_hierarchy ||' '); 5768: htp.p(''); 5770: htp.tableRowOpen; 5771: htp.p(''); 5773: htp.p(''); Line 5771: htp.p(' ' || 5769: '' || g_task_params ||' ' || 5772: ''|| g_hierarchy ||' ' || 5774: ''|| g_ctxt_type ||' ' || 5767: htp.p(''); 5768: htp.p(''); 5770: htp.tableRowOpen; 5771: htp.p(''); 5773: htp.p(''); 5775: htp.p(''); 5770: htp.tableRowOpen; 5771: htp.p(''); 5773: htp.p(''); 5775: htp.p(''); 5777: htp.p(''); 5773: htp.p(''); 5775: htp.p(''); 5777: htp.p(''); 5779: htp.p(''); 5775: htp.p(''); 5777: htp.p(''); 5779: htp.p(''); 5781: htp.p(''); 5777: htp.p(''); 5779: htp.p(''); 5781: htp.p(''); 5783: htp.tableRowClose; Line 5781: htp.p(' '); 5779: htp.p(''); 5781: htp.p(''); 5783: htp.tableRowClose; 5784: htp.tableRowOpen; 5785: Line 5783: htp.tableRowClose; 5779: htp.p(' '); 5781: htp.p(''); 5783: htp.tableRowClose; 5784: htp.tableRowOpen; 5785: 5786: -- 5787: -- Line 5784: htp.tableRowOpen; 5780: ''|| g_end ||''); 5781: htp.p(' '); 5783: htp.tableRowClose; 5784: htp.tableRowOpen; 5785: 5786: -- 5787: -- 5788: -- Line 5791: htp.p(' '); 5787: -- 5788: -- 5789: g_curr_process_level := 1; 5790: g_upper_process_names(1) := SUBSTR(p_process_groups, INSTR(p_process_groups, '\', -1) + 1); 5791: htp.p(' '); 5792: htp.p(''); 5793: htp.p(''); 5794: htp.p(''); 5795: htp.p(''); Line 5792: htp.p(' '); 5788: -- 5789: g_curr_process_level := 1; 5790: g_upper_process_names(1) := SUBSTR(p_process_groups, INSTR(p_process_groups, '\', -1) + 1); 5791: htp.p(' '); 5792: htp.p(''); 5793: htp.p(''); 5794: htp.p(''); 5795: htp.p(''); 5796: htp.p(''); Line 5793: htp.p(' '); 5789: g_curr_process_level := 1; 5790: g_upper_process_names(1) := SUBSTR(p_process_groups, INSTR(p_process_groups, '\', -1) + 1); 5791: htp.p(' '); 5792: htp.p(''); 5793: htp.p(''); 5794: htp.p(''); 5795: htp.p(''); 5796: htp.p(''); 5797: htp.tableRowClose; Line 5794: htp.p(' '); 5790: g_upper_process_names(1) := SUBSTR(p_process_groups, INSTR(p_process_groups, '\', -1) + 1); 5791: htp.p(' '); 5792: htp.p(''); 5793: htp.p(''); 5794: htp.p(''); 5795: htp.p(''); 5796: htp.p(''); 5797: htp.tableRowClose; 5798: htp.p(''); 5791: htp.p(' '); 5792: htp.p(''); 5793: htp.p(''); 5794: htp.p(''); 5795: htp.p(''); 5796: htp.p(''); 5797: htp.tableRowClose; 5798: htp.p(''); Line 5796: htp.p(' '); 5792: htp.p(' '); 5793: htp.p(''); 5794: htp.p(''); 5795: htp.p(''); 5796: htp.p(''); 5797: htp.tableRowClose; 5798: htp.p(''); 5800: htp.p(''); Line 5797: htp.tableRowClose; 5793: htp.p(' '); 5794: htp.p(''); 5795: htp.p(''); 5796: htp.p(''); 5797: htp.tableRowClose; 5798: htp.p(''); 5800: htp.p(''); 5801: htp.p(''); 5795: htp.p(''); 5796: htp.p(''); 5797: htp.tableRowClose; 5798: htp.p(''); 5800: htp.p(''); 5801: htp.p(''); Line 5800: htp.p(' '); 5796: htp.p(' '); 5797: htp.tableRowClose; 5798: htp.p(''); 5800: htp.p(''); 5801: htp.p(''); 5803: htp.p(''); Line 5801: htp.p(' '); 5800: htp.p(''); 5801: htp.p(''); 5803: htp.p(''); 5805: htp.p(''); 5800: htp.p(''); 5801: htp.p(''); 5803: htp.p(''); 5805: htp.p(''); 5807: htp.p(''); 5803: htp.p(''); 5805: htp.p(''); 5807: htp.p(''); 5809: htp.p(''); Line 5807: htp.p(' '); 5805: htp.p(''); 5807: htp.p(''); 5809: htp.p(''); 5810: 5811: -- Line 5809: htp.p(''); 5805: htp.p(' '); 5807: htp.p(''); 5809: htp.p(''); 5810: 5811: -- 5812: -- Get the main process name 5813: -- Line 5824: htp.p(' '); 5827: 5828: -- Line 5834: htp.p(' ' || 5769: '' || g_task_params ||' ' || 5772: ''|| g_hierarchy ||' ' || 5774: ''|| g_ctxt_type ||' ' || Line 5773: htp.p(' ' || 5769: '' || g_task_params ||' ' || 5772: ''|| g_hierarchy ||' ' || 5774: ''|| g_ctxt_type ||' ' || 5776: ''|| g_status ||' ' || Line 5775: htp.p(' ' || 5771: htp.p(' ' || 5772: ''|| g_hierarchy ||' ' || 5774: ''|| g_ctxt_type ||' ' || 5776: ''|| g_status ||' ' || 5778: ''|| g_start ||' ' || Line 5777: htp.p(' ' || 5773: htp.p(' ' || 5774: ''|| g_ctxt_type ||' ' || 5776: ''|| g_status ||' ' || 5778: ''|| g_start ||' ' || 5780: ''|| g_end ||' ' || Line 5779: htp.p(' ' || 5775: htp.p(' ' || 5776: ''|| g_status ||' ' || 5778: ''|| g_start ||' ' || 5780: ''|| g_end ||' ' || 5782: ''|| g_duration ||' ' || 5777: htp.p(' ' || 5778: ''|| g_start ||' ' || 5780: ''|| g_end ||' ' || 5782: ''|| g_duration ||' ' || 5780: ''|| g_end ||' ' || 5782: ''|| g_duration ||' ' || 5782: ''|| g_duration ||' ' || p_process_groups ||' ' || p_process_groups ||' ' || p_ctx_type ||' ' || p_status ||' ' || p_start ||' ' || p_end ||' ' || p_ctx_type ||' ' || p_process_groups ||' ' || p_ctx_type ||' ' || p_status ||' ' || p_start ||' ' || p_end ||' ' || p_time_elapsed ||' ' || p_status ||' ' || p_process_groups ||' ' || p_ctx_type ||' ' || p_status ||' ' || p_start ||' ' || p_end ||' ' || p_time_elapsed ||' ' || p_start ||' ' || p_process_groups ||' ' || p_ctx_type ||' ' || p_status ||' ' || p_start ||' ' || p_end ||' ' || p_time_elapsed ||' ' || Line 5795: htp.p(' ' || p_end ||' ' || p_process_groups ||' ' || p_ctx_type ||' ' || p_status ||' ' || p_start ||' ' || p_end ||' ' || p_time_elapsed ||' ' || 5799: '' || g_task_details ||' ' || p_time_elapsed ||' ' || p_ctx_type ||' ' || p_status ||' ' || p_start ||' ' || p_end ||' ' || p_time_elapsed ||' ' || 5799: '' || g_task_details ||' ' || p_status ||' ' || p_start ||' ' || p_end ||' ' || p_time_elapsed ||' ' || 5799: '' || g_task_details ||' '|| Line 5798: htp.p(' ' || 5794: htp.p(' ' || p_start ||' ' || p_end ||' ' || p_time_elapsed ||' ' || 5799: '' || g_task_details ||' '|| 5802: g_hierarchy ||' ' || p_time_elapsed ||' ' || 5799: '' || g_task_details ||' '|| 5802: g_hierarchy ||' '|| 5804: g_step_name ||' '|| 5797: htp.tableRowClose; 5798: htp.p(' ' || 5799: '' || g_task_details ||' '|| 5802: g_hierarchy ||' '|| 5804: g_step_name ||' '|| Line 5803: htp.p(' '|| 5799: '' || g_task_details ||' '|| 5802: g_hierarchy ||' '|| 5804: g_step_name ||' '|| 5806: g_step_response ||' '|| Line 5805: htp.p(' '|| 5801: htp.p(' '|| 5802: g_hierarchy ||' '|| 5804: g_step_name ||' '|| 5806: g_step_response ||' '|| 5808: g_comments ||' '|| 5803: htp.p(' '|| 5804: g_step_name ||' '|| 5806: g_step_response ||' '|| 5808: g_comments ||' '|| 5806: g_step_response ||' '|| 5808: g_comments ||' ' || 5820: -- Update the global array of the upper process names 5821: -- 5822: g_curr_process_level := 1; 5823: g_upper_process_names(1) := SUBSTR(p_process_groups, INSTR(p_process_groups, '\', -1) + 1); 5824: htp.p(' ' || 5825: g_upper_process_names(g_curr_process_level) 5826: || '   '); 5830: -- which mean call it by the main process name. 5831: -- 5832: print_task_steps(p_item_type, p_item_key, v_process_name, 1); 5833: 5834: htp.p(' '); 5835: htp.p(''); 5836: EXCEPTION 5837: WHEN application_exception THEN 5838: RAISE; Line 5835: htp.p(''); 5831: -- 5832: print_task_steps(p_item_type, p_item_key, v_process_name, 1); 5833: 5834: htp.p(' '); 5835: htp.p(''); 5836: EXCEPTION 5837: WHEN application_exception THEN 5838: RAISE; 5839: WHEN OTHERS THEN Line 5908: htp.p(' ' || 5904: -- for all sub-processes. 5905: -- 5906: g_curr_process_level := p_process_level + 1; 5907: g_upper_process_names(g_curr_process_level) := step.display_name; 5908: htp.p(' ' || 5909: get_parent_structure(g_upper_process_names, g_curr_process_level) 5910: || '                     '||step.display_name ||' '||step.result_name ||' '||v_user_comments ||' '||step.display_name ||'   '||step.display_name ||' '||step.result_name ||' '||v_user_comments ||' '||step.result_name ||'   '||step.display_name ||' '||step.result_name ||' '||v_user_comments ||' '||v_user_comments ||'   '||step.display_name ||' '||step.result_name ||' '||v_user_comments ||' '); 6076: v_locator := 8; 6077: END IF; 6078: END LOOP; 6079: v_locator := 7; 6080: htp.p(' '); 6081: htp.p(''); 6082: htp.htmlClose; 6083: COMMIT; 6084: Line 6081: htp.p(''); 6077: END IF; 6078: END LOOP; 6079: v_locator := 7; 6080: htp.p(' '); 6081: htp.p(''); 6082: htp.htmlClose; 6083: COMMIT; 6084: 6085: EXCEPTION Line 6082: htp.htmlClose; 6078: END LOOP; 6079: v_locator := 7; 6080: htp.p(' '); 6081: htp.p(''); 6082: htp.htmlClose; 6083: COMMIT; 6084: 6085: EXCEPTION 6086: WHEN application_exception THEN Line 6108: htp.htmlOpen; 6104: v_colspan PLS_INTEGER; 6105: 6106: BEGIN 6107: IF (p_display_msg = 'YES') THEN 6108: htp.htmlOpen; 6109: htp.headOpen; 6110: htp.title(g_step_details); 6111: htp.headClose; 6112: v_colspan := 4; Line 6109: htp.headOpen; 6105: 6106: BEGIN 6107: IF (p_display_msg = 'YES') THEN 6108: htp.htmlOpen; 6109: htp.headOpen; 6110: htp.title(g_step_details); 6111: htp.headClose; 6112: v_colspan := 4; 6113: ELSE Line 6110: htp.title(g_step_details); 6106: BEGIN 6107: IF (p_display_msg = 'YES') THEN 6108: htp.htmlOpen; 6109: htp.headOpen; 6110: htp.title(g_step_details); 6111: htp.headClose; 6112: v_colspan := 4; 6113: ELSE 6114: v_colspan := 3; Line 6111: htp.headClose; 6107: IF (p_display_msg = 'YES') THEN 6108: htp.htmlOpen; 6109: htp.headOpen; 6110: htp.title(g_step_details); 6111: htp.headClose; 6112: v_colspan := 4; 6113: ELSE 6114: v_colspan := 3; 6115: END IF; Line 6118: htp.p(''); 6114: v_colspan := 3; 6115: END IF; 6116: 6117: print_html_style; 6118: htp.p(''); 6119: htp.p(''); 6120: htp.p(''); 6122: htp.p(' ' || 6121: '' || g_step_details ||' Line 6119: htp.p(''); 6115: END IF; 6116: 6117: print_html_style; 6118: htp.p(''); 6119: htp.p(' '); 6120: htp.p(''); 6122: htp.p(''); Line 6120: htp.p(' '); 6315: -- To show an empty line at the end of a sub-process 6316: -- if it is followed by a NOTICE 6317: IF (g_prev_act_name = 'END') THEN 6318: IF (p_display_msg = 'YES') THEN 6319: htp.p(' '); 6320: ELSE 6321: htp.p(''); 6322: END IF; 6323: g_prev_act_name := NULL; Line 6321: htp.p(' '); 6317: IF (g_prev_act_name = 'END') THEN 6318: IF (p_display_msg = 'YES') THEN 6319: htp.p(' '); 6320: ELSE 6321: htp.p(''); 6322: END IF; 6323: g_prev_act_name := NULL; 6324: END IF; 6325: Line 6331: htp.p(' '); 6333: htp.p(''); 6334: ELSE 6335: htp.p(''); Line 6333: htp.p(' '); 6329: where wmv.type = act_type 6330: and wmv.name = l_mesg; 6331: htp.p(' '); 6333: htp.p(''); 6334: ELSE 6335: htp.p(''); 6336: END IF; 6337: ELSIF l_act_type = 'PROCESS' THEN Line 6335: htp.p(' '); 6331: htp.p(' '); 6333: htp.p(''); 6334: ELSE 6335: htp.p(''); 6336: END IF; 6337: ELSIF l_act_type = 'PROCESS' THEN 6338: display_process_steps(p_selected_products, 6339: act_type, Line 6393: htp.p(''); Line 6404: htp.p(' NewWindow.focus();'); 6400: END IF; 6401: 6402: htp.p('"scrollbars=yes,menubar=yes,toolbar=no,status=yes,location=no,resizable=yes");'); 6403: 6404: htp.p(' NewWindow.focus();'); 6405: htp.p('}'); 6406: htp.p(''); 6407: EXCEPTION 6408: WHEN application_exception THEN Line 6405: htp.p('}'); 6401: 6402: htp.p('"scrollbars=yes,menubar=yes,toolbar=no,status=yes,location=no,resizable=yes");'); 6403: 6404: htp.p(' NewWindow.focus();'); 6405: htp.p('}'); 6406: htp.p(''); 6407: EXCEPTION 6408: WHEN application_exception THEN 6409: RAISE; Line 6406: htp.p(''); 6402: htp.p('"scrollbars=yes,menubar=yes,toolbar=no,status=yes,location=no,resizable=yes");'); 6403: 6404: htp.p(' NewWindow.focus();'); 6405: htp.p('}'); 6406: htp.p(''); 6407: EXCEPTION 6408: WHEN application_exception THEN 6409: RAISE; 6410: WHEN OTHERS THEN ' || 6121: '' || g_step_details ||' 6123: 'NOWRAP>'|| g_hierarchy ||' ' || 6116: 6117: print_html_style; 6118: htp.p(''); 6119: htp.p(''); 6120: htp.p(''); 6122: htp.p(''); 6124: htp.p(' ' || 6121: '' || g_step_details ||' 6123: 'NOWRAP>'|| g_hierarchy ||' Line 6122: htp.p(' 6118: htp.p(''); 6119: htp.p(''); 6120: htp.p(''); 6122: htp.p(''); 6124: htp.p(''); 6126: htp.p(''); 6122: htp.p(''); 6124: htp.p(''); 6126: htp.p(''); 6128: IF (p_display_msg = 'YES') THEN Line 6126: htp.p(' '); 6124: htp.p(''); 6126: htp.p(''); 6128: IF (p_display_msg = 'YES') THEN 6129: htp.p(''); Line 6129: htp.p(' '); 6126: htp.p(''); 6128: IF (p_display_msg = 'YES') THEN 6129: htp.p(''); 6131: END IF; 6132: htp.p(''); 6133: EXCEPTION Line 6132: htp.p(''); 6128: IF (p_display_msg = 'YES') THEN 6129: htp.p(' '); 6131: END IF; 6132: htp.p(''); 6133: EXCEPTION 6134: WHEN application_exception THEN 6135: RAISE; 6136: WHEN OTHERS THEN Line 6218: htp.p(' '); 6221: g_prev_act_name := NULL; 6222: ELSE Line 6223: htp.p(' '); 6221: g_prev_act_name := NULL; 6222: ELSE 6223: htp.p(''); 6230: END IF; 6231: Line 6229: htp.p(' '); 6225: get_parent_structure(g_upper_process_names, g_curr_process_level)); 6226: IF (p_context_type_name IS NOT NULL) THEN 6227: htp.p('(' || p_context_type_name || ')'); 6228: END IF; 6229: htp.p(' '); 6230: END IF; 6231: 6232: IF (p_external_call = 'YES') THEN 6233: IF (g_curr_process_level > 1) THEN Line 6234: htp.p(' '); 6230: END IF; 6231: 6232: IF (p_external_call = 'YES') THEN 6233: IF (g_curr_process_level > 1) THEN 6234: htp.p(' '); 6235: ELSE 6236: htp.p(''); 6237: END IF; 6238: END IF; Line 6236: htp.p(' '); 6232: IF (p_external_call = 'YES') THEN 6233: IF (g_curr_process_level > 1) THEN 6234: htp.p(' '); 6235: ELSE 6236: htp.p(''); 6237: END IF; 6238: END IF; 6239: htp.p(''); 6240: Line 6239: htp.p(''); 6235: ELSE 6236: htp.p(' '); 6237: END IF; 6238: END IF; 6239: htp.p(''); 6240: 6241: -- 6242: -- Display each link. 6243: -- Line 6253: htp.p(' ' || 6121: '' || g_step_details ||' 6123: 'NOWRAP>'|| g_hierarchy ||' 6125: 'NOWRAP>' || g_process || ' Line 6124: htp.p(' 6120: htp.p(' ' || 6121: '' || g_step_details ||' 6123: 'NOWRAP>'|| g_hierarchy ||' 6125: 'NOWRAP>' || g_process || ' 6127: 'NOWRAP>'|| g_steps ||' 6122: htp.p(' 6123: 'NOWRAP>'|| g_hierarchy ||' 6125: 'NOWRAP>' || g_process || ' 6127: 'NOWRAP>'|| g_steps ||' 6130: 'NOWRAP>'|| g_step_msg ||' 6125: 'NOWRAP>' || g_process || ' 6127: 'NOWRAP>'|| g_steps ||' 6130: 'NOWRAP>'|| g_step_msg ||' 6130: 'NOWRAP>'|| g_step_msg ||'   '|| 6214: g_upper_process_names(g_curr_process_level) := l_dname; 6215: END IF; 6216: 6217: IF (g_curr_process_level > 1) THEN 6218: htp.p('   '|| 6219: get_parent_structure(g_upper_process_names, g_curr_process_level) || 6220: '   ' || p_process_groups || 6219: get_parent_structure(g_upper_process_names, g_curr_process_level) || 6220: '   ' || p_process_groups || 6224: ' '|| 6225: get_parent_structure(g_upper_process_names, g_curr_process_level)); 6226: IF (p_context_type_name IS NOT NULL) THEN 6227: htp.p('(' || p_context_type_name || ')'); Line 6227: htp.p('(' || p_context_type_name || ')'); 6223: htp.p(' ' || p_process_groups || 6224: ' '|| 6225: get_parent_structure(g_upper_process_names, g_curr_process_level)); 6226: IF (p_context_type_name IS NOT NULL) THEN 6227: htp.p('(' || p_context_type_name || ')'); 6228: END IF; 6229: htp.p('                     '); 6249: END IF; 6250: END LOOP; 6251: 6252: IF (p_external_call = 'YES') AND (p_new_call = 'YES') THEN 6253: htp.p(' '); 6254: END IF; 6255: 6256: EXCEPTION 6257: WHEN application_exception THEN Line 6319: htp.p('                             '|| 6327: select body into l_body 6328: from wf_messages_vl wmv 6329: where wmv.type = act_type 6330: and wmv.name = l_mesg; 6331: htp.p('     '|| 6332: l_dname ||' '|| format_step_body(l_body) ||'       '|| l_dname ||'       '|| 6332: l_dname ||' '|| format_step_body(l_body) ||'       '|| l_dname ||'     '|| l_dname ||'     '|| 6332: l_dname ||' '|| format_step_body(l_body) ||'       '|| l_dname ||'