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

APPS.HR_DM_LIBRARY dependencies on HR_DM_DT_DELETES

Line 2402: l_data_type hr_dm_dt_deletes.data_type%type;

2398: p_source_id in number,
2399: p_destination_id out nocopy number
2400: ) is
2401:
2402: l_data_type hr_dm_dt_deletes.data_type%type;
2403: --
2404: -- cursor to find the row in hr_dm_dt_deletes table for a given id, table and
2405: -- type combination
2406:

Line 2404: -- cursor to find the row in hr_dm_dt_deletes table for a given id, table and

2400: ) is
2401:
2402: l_data_type hr_dm_dt_deletes.data_type%type;
2403: --
2404: -- cursor to find the row in hr_dm_dt_deletes table for a given id, table and
2405: -- type combination
2406:
2407: cursor csr_find_destination_pk is
2408: select destination_id

Line 2476: insert into hr_dm_dt_deletes ( dt_delete_id

2472: ')(p_pk_column_3 - ' || p_pk_column_3 ||
2473: ')(p_pk_column_4- ' || p_pk_column_4 ||
2474: ')', 10);
2475:
2476: insert into hr_dm_dt_deletes ( dt_delete_id
2477: ,table_name
2478: ,data_type
2479: ,id_value
2480: ,pk_column_1

Line 2485: values ( hr_dm_dt_deletes_s.nextval

2481: ,pk_column_2
2482: ,pk_column_3
2483: ,pk_column_4
2484: )
2485: values ( hr_dm_dt_deletes_s.nextval
2486: ,p_table_name
2487: ,p_ins_type
2488: ,p_id
2489: ,p_pk_column_1

Line 2495: 'hr_dm_dt_deletes table ',15);

2491: ,p_pk_column_3
2492: ,p_pk_column_4);
2493:
2494: hr_dm_utility.message('INFO','HR_DM_LIBARARY - insert row into ' ||
2495: 'hr_dm_dt_deletes table ',15);
2496: --hr_dm_utility.message('SUMM','HR_DM_LIBARARY - - insert row into ' ||
2497: -- 'hr_dm_dt_deletes table ',20);
2498: hr_dm_utility.message('ROUT','exit:hr_dm_library.ins_dt_delete',
2499: 25);

Line 2497: -- 'hr_dm_dt_deletes table ',20);

2493:
2494: hr_dm_utility.message('INFO','HR_DM_LIBARARY - insert row into ' ||
2495: 'hr_dm_dt_deletes table ',15);
2496: --hr_dm_utility.message('SUMM','HR_DM_LIBARARY - - insert row into ' ||
2497: -- 'hr_dm_dt_deletes table ',20);
2498: hr_dm_utility.message('ROUT','exit:hr_dm_library.ins_dt_delete',
2499: 25);
2500: exception
2501: when others then

Line 2530: l_data_type hr_dm_dt_deletes.data_type%type;

2526: p_ins_type out nocopy varchar2,
2527: p_row_exists out nocopy varchar2
2528: ) is
2529:
2530: l_data_type hr_dm_dt_deletes.data_type%type;
2531: --
2532: -- cursor to find the row in hr_dm_dt_deletes table for a given id, table and
2533: -- type combination
2534: cursor csr_find_dt_deletes is

Line 2532: -- cursor to find the row in hr_dm_dt_deletes table for a given id, table and

2528: ) is
2529:
2530: l_data_type hr_dm_dt_deletes.data_type%type;
2531: --
2532: -- cursor to find the row in hr_dm_dt_deletes table for a given id, table and
2533: -- type combination
2534: cursor csr_find_dt_deletes is
2535: select data_type
2536: from hr_dm_dt_deletes

Line 2536: from hr_dm_dt_deletes

2532: -- cursor to find the row in hr_dm_dt_deletes table for a given id, table and
2533: -- type combination
2534: cursor csr_find_dt_deletes is
2535: select data_type
2536: from hr_dm_dt_deletes
2537: where id_value = p_id
2538: and table_name = p_table_name
2539: order by data_type;
2540: begin

Line 2558: 'in hr_dm_dt_deletes table ',15);

2554: p_ins_type := null;
2555: close csr_find_dt_deletes;
2556: end if;
2557: hr_dm_utility.message('INFO','HR_DM_LIBARARY - check whether row exists ' ||
2558: 'in hr_dm_dt_deletes table ',15);
2559: --hr_dm_utility.message('SUMM','HR_DM_LIBARARY - check whether row exists ' ||
2560: -- 'in hr_dm_dt_deletes table ',20);
2561:
2562: hr_dm_utility.message('PARA','(p_ins_type - ' || p_ins_type

Line 2560: -- 'in hr_dm_dt_deletes table ',20);

2556: end if;
2557: hr_dm_utility.message('INFO','HR_DM_LIBARARY - check whether row exists ' ||
2558: 'in hr_dm_dt_deletes table ',15);
2559: --hr_dm_utility.message('SUMM','HR_DM_LIBARARY - check whether row exists ' ||
2560: -- 'in hr_dm_dt_deletes table ',20);
2561:
2562: hr_dm_utility.message('PARA','(p_ins_type - ' || p_ins_type
2563: || ')( p_row_exists - ' ||p_row_exists ,30);
2564: hr_dm_utility.message('ROUT','exit:hr_dm_library.chk_row_in_dt_delete',

Line 2597: l_data_type hr_dm_dt_deletes.data_type%type;

2593: p_ins_type out nocopy varchar2,
2594: p_row_exists out nocopy varchar2
2595: ) is
2596:
2597: l_data_type hr_dm_dt_deletes.data_type%type;
2598: --
2599: -- cursor to find the row in hr_dm_dt_deletes table for a given id, table and
2600: -- type combination
2601: cursor csr_find_dt_deletes is

Line 2599: -- cursor to find the row in hr_dm_dt_deletes table for a given id, table and

2595: ) is
2596:
2597: l_data_type hr_dm_dt_deletes.data_type%type;
2598: --
2599: -- cursor to find the row in hr_dm_dt_deletes table for a given id, table and
2600: -- type combination
2601: cursor csr_find_dt_deletes is
2602: select data_type
2603: from hr_dm_dt_deletes

Line 2603: from hr_dm_dt_deletes

2599: -- cursor to find the row in hr_dm_dt_deletes table for a given id, table and
2600: -- type combination
2601: cursor csr_find_dt_deletes is
2602: select data_type
2603: from hr_dm_dt_deletes
2604: where pk_column_1 = p_pk_column_1
2605: and table_name = p_table_name
2606: order by data_type;
2607: begin

Line 2625: 'in hr_dm_dt_deletes table ',15);

2621: p_ins_type := null;
2622: close csr_find_dt_deletes;
2623: end if;
2624: hr_dm_utility.message('INFO','HR_DM_LIBARARY - check whether row exists ' ||
2625: 'in hr_dm_dt_deletes table ',15);
2626: --hr_dm_utility.message('SUMM','HR_DM_LIBARARY - check whether row exists ' ||
2627: -- 'in hr_dm_dt_deletes table ',20);
2628:
2629: hr_dm_utility.message('PARA','(p_ins_type - ' || p_ins_type

Line 2627: -- 'in hr_dm_dt_deletes table ',20);

2623: end if;
2624: hr_dm_utility.message('INFO','HR_DM_LIBARARY - check whether row exists ' ||
2625: 'in hr_dm_dt_deletes table ',15);
2626: --hr_dm_utility.message('SUMM','HR_DM_LIBARARY - check whether row exists ' ||
2627: -- 'in hr_dm_dt_deletes table ',20);
2628:
2629: hr_dm_utility.message('PARA','(p_ins_type - ' || p_ins_type
2630: || ')( p_row_exists - ' ||p_row_exists ,30);
2631: hr_dm_utility.message('ROUT','exit:hr_dm_library.chk_row_in_dt_delete_1_pkcol',

Line 2665: l_data_type hr_dm_dt_deletes.data_type%type;

2661: p_ins_type out nocopy varchar2,
2662: p_row_exists out nocopy varchar2
2663: ) is
2664:
2665: l_data_type hr_dm_dt_deletes.data_type%type;
2666: --
2667: -- cursor to find the row in hr_dm_dt_deletes table for a given id, table and
2668: -- type combination
2669: cursor csr_find_dt_deletes is

Line 2667: -- cursor to find the row in hr_dm_dt_deletes table for a given id, table and

2663: ) is
2664:
2665: l_data_type hr_dm_dt_deletes.data_type%type;
2666: --
2667: -- cursor to find the row in hr_dm_dt_deletes table for a given id, table and
2668: -- type combination
2669: cursor csr_find_dt_deletes is
2670: select data_type
2671: from hr_dm_dt_deletes

Line 2671: from hr_dm_dt_deletes

2667: -- cursor to find the row in hr_dm_dt_deletes table for a given id, table and
2668: -- type combination
2669: cursor csr_find_dt_deletes is
2670: select data_type
2671: from hr_dm_dt_deletes
2672: where pk_column_1 = p_pk_column_1
2673: and pk_column_2 = p_pk_column_2
2674: and table_name = p_table_name
2675: order by data_type;

Line 2694: 'in hr_dm_dt_deletes table ',15);

2690: p_ins_type := null;
2691: close csr_find_dt_deletes;
2692: end if;
2693: hr_dm_utility.message('INFO','HR_DM_LIBARARY - check whether row exists ' ||
2694: 'in hr_dm_dt_deletes table ',15);
2695: --hr_dm_utility.message('SUMM','HR_DM_LIBARARY - check whether row exists ' ||
2696: -- 'in hr_dm_dt_deletes table ',20);
2697:
2698: hr_dm_utility.message('PARA','(p_ins_type - ' || p_ins_type

Line 2696: -- 'in hr_dm_dt_deletes table ',20);

2692: end if;
2693: hr_dm_utility.message('INFO','HR_DM_LIBARARY - check whether row exists ' ||
2694: 'in hr_dm_dt_deletes table ',15);
2695: --hr_dm_utility.message('SUMM','HR_DM_LIBARARY - check whether row exists ' ||
2696: -- 'in hr_dm_dt_deletes table ',20);
2697:
2698: hr_dm_utility.message('PARA','(p_ins_type - ' || p_ins_type
2699: || ')( p_row_exists - ' ||p_row_exists ,30);
2700: hr_dm_utility.message('ROUT','exit:hr_dm_library.chk_row_in_dt_delete_2_pkcol',

Line 2738: l_data_type hr_dm_dt_deletes.data_type%type;

2734: p_ins_type out nocopy varchar2,
2735: p_row_exists out nocopy varchar2
2736: ) is
2737:
2738: l_data_type hr_dm_dt_deletes.data_type%type;
2739: --
2740: -- cursor to find the row in hr_dm_dt_deletes table for a given id, table and
2741: -- type combination
2742: cursor csr_find_dt_deletes is

Line 2740: -- cursor to find the row in hr_dm_dt_deletes table for a given id, table and

2736: ) is
2737:
2738: l_data_type hr_dm_dt_deletes.data_type%type;
2739: --
2740: -- cursor to find the row in hr_dm_dt_deletes table for a given id, table and
2741: -- type combination
2742: cursor csr_find_dt_deletes is
2743: select data_type
2744: from hr_dm_dt_deletes

Line 2744: from hr_dm_dt_deletes

2740: -- cursor to find the row in hr_dm_dt_deletes table for a given id, table and
2741: -- type combination
2742: cursor csr_find_dt_deletes is
2743: select data_type
2744: from hr_dm_dt_deletes
2745: where pk_column_1 = p_pk_column_1
2746: and pk_column_2 = p_pk_column_2
2747: and pk_column_3 = p_pk_column_3
2748: and table_name = p_table_name

Line 2769: 'in hr_dm_dt_deletes table ',15);

2765: p_ins_type := null;
2766: close csr_find_dt_deletes;
2767: end if;
2768: hr_dm_utility.message('INFO','HR_DM_LIBARARY - check whether row exists ' ||
2769: 'in hr_dm_dt_deletes table ',15);
2770: --hr_dm_utility.message('SUMM','HR_DM_LIBARARY - check whether row exists ' ||
2771: -- 'in hr_dm_dt_deletes table ',20);
2772:
2773: hr_dm_utility.message('PARA','(p_ins_type - ' || p_ins_type

Line 2771: -- 'in hr_dm_dt_deletes table ',20);

2767: end if;
2768: hr_dm_utility.message('INFO','HR_DM_LIBARARY - check whether row exists ' ||
2769: 'in hr_dm_dt_deletes table ',15);
2770: --hr_dm_utility.message('SUMM','HR_DM_LIBARARY - check whether row exists ' ||
2771: -- 'in hr_dm_dt_deletes table ',20);
2772:
2773: hr_dm_utility.message('PARA','(p_ins_type - ' || p_ins_type
2774: || ')( p_row_exists - ' ||p_row_exists ,30);
2775: hr_dm_utility.message('ROUT','exit:hr_dm_library.chk_row_in_dt_delete_3_pkcol',

Line 2814: l_data_type hr_dm_dt_deletes.data_type%type;

2810: p_ins_type out nocopy varchar2,
2811: p_row_exists out nocopy varchar2
2812: ) is
2813:
2814: l_data_type hr_dm_dt_deletes.data_type%type;
2815: --
2816: -- cursor to find the row in hr_dm_dt_deletes table for a given id, table and
2817: -- type combination
2818: cursor csr_find_dt_deletes is

Line 2816: -- cursor to find the row in hr_dm_dt_deletes table for a given id, table and

2812: ) is
2813:
2814: l_data_type hr_dm_dt_deletes.data_type%type;
2815: --
2816: -- cursor to find the row in hr_dm_dt_deletes table for a given id, table and
2817: -- type combination
2818: cursor csr_find_dt_deletes is
2819: select data_type
2820: from hr_dm_dt_deletes

Line 2820: from hr_dm_dt_deletes

2816: -- cursor to find the row in hr_dm_dt_deletes table for a given id, table and
2817: -- type combination
2818: cursor csr_find_dt_deletes is
2819: select data_type
2820: from hr_dm_dt_deletes
2821: where pk_column_1 = p_pk_column_1
2822: and pk_column_2 = p_pk_column_2
2823: and pk_column_3 = p_pk_column_3
2824: and pk_column_4 = p_pk_column_4

Line 2847: 'in hr_dm_dt_deletes table ',15);

2843: p_ins_type := null;
2844: close csr_find_dt_deletes;
2845: end if;
2846: hr_dm_utility.message('INFO','HR_DM_LIBARARY - check whether row exists ' ||
2847: 'in hr_dm_dt_deletes table ',15);
2848: --hr_dm_utility.message('SUMM','HR_DM_LIBARARY - check whether row exists ' ||
2849: -- 'in hr_dm_dt_deletes table ',20);
2850:
2851: hr_dm_utility.message('PARA','(p_ins_type - ' || p_ins_type

Line 2849: -- 'in hr_dm_dt_deletes table ',20);

2845: end if;
2846: hr_dm_utility.message('INFO','HR_DM_LIBARARY - check whether row exists ' ||
2847: 'in hr_dm_dt_deletes table ',15);
2848: --hr_dm_utility.message('SUMM','HR_DM_LIBARARY - check whether row exists ' ||
2849: -- 'in hr_dm_dt_deletes table ',20);
2850:
2851: hr_dm_utility.message('PARA','(p_ins_type - ' || p_ins_type
2852: || ')( p_row_exists - ' ||p_row_exists ,30);
2853: hr_dm_utility.message('ROUT','exit:hr_dm_library.chk_row_in_dt_delete_4_pkcol',

Line 2956: 'in hr_dm_dt_deletes table ',15);

2952: if upper( l_status ) <> 'VALID' then
2953: raise e_invalid_package;
2954: end if;
2955: hr_dm_utility.message('INFO','HR_DM_LIBARARY - check status of the package ' ||
2956: 'in hr_dm_dt_deletes table ',15);
2957: --hr_dm_utility.message('SUMM','HR_DM_LIBARARY - check status of the package ' ||
2958: -- 'in hr_dm_dt_deletes table ',20);
2959: hr_dm_utility.message('ROUT','exit:hr_dm_library.check_compile',
2960: 25);

Line 2958: -- 'in hr_dm_dt_deletes table ',20);

2954: end if;
2955: hr_dm_utility.message('INFO','HR_DM_LIBARARY - check status of the package ' ||
2956: 'in hr_dm_dt_deletes table ',15);
2957: --hr_dm_utility.message('SUMM','HR_DM_LIBARARY - check status of the package ' ||
2958: -- 'in hr_dm_dt_deletes table ',20);
2959: hr_dm_utility.message('ROUT','exit:hr_dm_library.check_compile',
2960: 25);
2961:
2962: exception