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.PAY_ELEMENT_TEMPLATE_UTIL dependencies on HR_UTILITY

Line 147: hr_utility.set_location('Entering:'|| l_proc, 10);

143: ,p_template_ff_usages in out nocopy t_template_ff_usages
144: ) is
145: l_proc varchar2(72) := g_package||'flush_plsql_template';
146: begin
147: hr_utility.set_location('Entering:'|| l_proc, 10);
148: p_element_template := null;
149: p_core_objects.delete;
150: p_exclusion_rules.delete;
151: p_element_types.delete;

Line 165: hr_utility.set_location(' Leaving:'||l_proc, 20);

161: p_ele_type_usages.delete;
162: p_gu_bal_exclusions.delete;
163: p_bal_attributes.delete;
164: p_template_ff_usages.delete;
165: hr_utility.set_location(' Leaving:'||l_proc, 20);
166: end flush_plsql_template;
167: -- ----------------------------------------------------------------------------
168: -- |------------------------< get_element_template >--------------------------|
169: -- ----------------------------------------------------------------------------

Line 255: hr_utility.set_location('Entering:'|| l_proc, 10);

251: where template_id = p_template_id
252: for update of template_id;
253: --
254: begin
255: hr_utility.set_location('Entering:'|| l_proc, 10);
256: open csr_element_template(p_template_id);
257: fetch csr_element_template into p_element_template;
258: if csr_element_template%notfound then
259: close csr_element_template;

Line 263: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');

259: close csr_element_template;
260: --
261: -- The template_id is invalid therefore we must error
262: --
263: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
264: hr_utility.raise_error;
265: end if;
266: close csr_element_template;
267: hr_utility.set_location('Leaving:'|| l_proc, 20);

Line 264: hr_utility.raise_error;

260: --
261: -- The template_id is invalid therefore we must error
262: --
263: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
264: hr_utility.raise_error;
265: end if;
266: close csr_element_template;
267: hr_utility.set_location('Leaving:'|| l_proc, 20);
268: exception

Line 267: hr_utility.set_location('Leaving:'|| l_proc, 20);

263: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
264: hr_utility.raise_error;
265: end if;
266: close csr_element_template;
267: hr_utility.set_location('Leaving:'|| l_proc, 20);
268: exception
269: when others then
270: hr_utility.set_location('Leaving:'|| l_proc, 30);
271: if csr_element_template%isopen then

Line 270: hr_utility.set_location('Leaving:'|| l_proc, 30);

266: close csr_element_template;
267: hr_utility.set_location('Leaving:'|| l_proc, 20);
268: exception
269: when others then
270: hr_utility.set_location('Leaving:'|| l_proc, 30);
271: if csr_element_template%isopen then
272: close csr_element_template;
273: end if;
274: raise;

Line 551: hr_utility.set_location('Entering:'|| l_proc, 10);

547: where tfu.template_id = p_template_id
548: and f.formula_id = tfu.formula_id
549: for update of f.formula_id;
550: begin
551: hr_utility.set_location('Entering:'|| l_proc, 10);
552:
553: --
554: -- Element payroll formulas.
555: --

Line 574: hr_utility.set_location('Leaving:'|| l_proc, 20);

570: for crec in csr_tfu_formulas(p_template_id) loop
571: p_formulas(crec.formula_id) := crec;
572: end loop;
573:
574: hr_utility.set_location('Leaving:'|| l_proc, 20);
575: exception
576: --
577: -- Catch exception for overflow of the 32k buffer when reading from
578: -- the LONG formula text column.

Line 581: hr_utility.set_location('Leaving:'|| l_proc, 30);

577: -- Catch exception for overflow of the 32k buffer when reading from
578: -- the LONG formula text column.
579: --
580: when plsql_value_error then
581: hr_utility.set_location('Leaving:'|| l_proc, 30);
582: fnd_message.set_name(801, 'PAY_50068_ETM_GEN_FF_TOO_LONG');
583: fnd_message.set_token('BASE_NAME', '');
584: fnd_message.set_token('LENGTH', 32767);
585: fnd_message.raise_error;

Line 587: hr_utility.set_location('Leaving:'|| l_proc, 40);

583: fnd_message.set_token('BASE_NAME', '');
584: fnd_message.set_token('LENGTH', 32767);
585: fnd_message.raise_error;
586: when others then
587: hr_utility.set_location('Leaving:'|| l_proc, 40);
588: raise;
589: end get_formulas;
590: -- ----------------------------------------------------------------------------
591: -- |---------------------------< get_balance_feeds >--------------------------|

Line 1030: hr_utility.set_location('Entering:'|| l_proc, 10);

1026: from pay_shadow_bal_attributes
1027: where defined_balance_id = p_defined_balance_id
1028: for update of balance_attribute_id;
1029: begin
1030: hr_utility.set_location('Entering:'|| l_proc, 10);
1031: --
1032: -- Exit if no balance types in the PL/SQL element template.
1033: --
1034: if p_defined_balances.count = 0 then

Line 1035: hr_utility.set_location('Leaving:'|| l_proc, 20);

1031: --
1032: -- Exit if no balance types in the PL/SQL element template.
1033: --
1034: if p_defined_balances.count = 0 then
1035: hr_utility.set_location('Leaving:'|| l_proc, 20);
1036: return;
1037: end if;
1038: --
1039: -- For each balance type get the defined balances.

Line 1052: hr_utility.set_location('Leaving:'|| l_proc, 30);

1048: end loop;
1049: --
1050: i := p_defined_balances.next(i);
1051: end loop;
1052: hr_utility.set_location('Leaving:'|| l_proc, 30);
1053: end get_bal_attributes;
1054: -- ----------------------------------------------------------------------------
1055: -- |-----------------------< get_template_ff_usages >-------------------------|
1056: -- ----------------------------------------------------------------------------

Line 1077: hr_utility.set_location('Entering:'|| l_proc, 10);

1073: from pay_template_ff_usages
1074: where template_id = p_template_id
1075: for update of template_ff_usage_id;
1076: begin
1077: hr_utility.set_location('Entering:'|| l_proc, 10);
1078: for crec in csr_template_ff_usages(p_template_id => p_template_id) loop
1079: p_template_ff_usages(crec.template_ff_usage_id) := crec;
1080: end loop;
1081: hr_utility.set_location('Leaving:'|| l_proc, 20);

Line 1081: hr_utility.set_location('Leaving:'|| l_proc, 20);

1077: hr_utility.set_location('Entering:'|| l_proc, 10);
1078: for crec in csr_template_ff_usages(p_template_id => p_template_id) loop
1079: p_template_ff_usages(crec.template_ff_usage_id) := crec;
1080: end loop;
1081: hr_utility.set_location('Leaving:'|| l_proc, 20);
1082: end get_template_ff_usages;
1083: -- ----------------------------------------------------------------------------
1084: -- |----------------------------< exclusion_on >------------------------------|
1085: -- ----------------------------------------------------------------------------

Line 1093: hr_utility.set_location('Entering:'|| l_proc, 10);

1089: ) return boolean is
1090: l_proc varchar2(72) := g_package||'exclusion_on';
1091: l_exclusion_on boolean;
1092: begin
1093: hr_utility.set_location('Entering:'|| l_proc, 10);
1094: l_exclusion_on := false;
1095: if upper(p_rec.flexfield_column) = 'CONFIGURATION_INFORMATION1' and
1096: p_element_template.configuration_information1 =
1097: p_rec.exclusion_value then

Line 1216: hr_utility.set_location('Leaving:'|| l_proc, 20);

1212: p_element_template.configuration_information30 =
1213: p_rec.exclusion_value then
1214: l_exclusion_on := true;
1215: end if;
1216: hr_utility.set_location('Leaving:'|| l_proc, 20);
1217: return l_exclusion_on;
1218: end exclusion_on;
1219: -- ----------------------------------------------------------------------------
1220: -- |-----------------------< exclude_defined_balance >------------------------|

Line 1232: hr_utility.set_location('Entering:'|| l_proc, 10);

1228: l_defined_balance_id number;
1229: i number;
1230: j number;
1231: begin
1232: hr_utility.set_location('Entering:'|| l_proc, 10);
1233: --
1234: -- Get the defined_balance_id for this defined balance.
1235: --
1236: l_defined_balance_id := p_defined_balances(p_i).defined_balance_id;

Line 1257: hr_utility.set_location('Leaving:'|| l_proc, 20);

1253: i := p_bal_attributes.next(i);
1254: end if;
1255: --
1256: end loop;
1257: hr_utility.set_location('Leaving:'|| l_proc, 20);
1258: end exclude_defined_balance;
1259: -- ----------------------------------------------------------------------------
1260: -- |-------------------------< exclude_balance_type >-------------------------|
1261: -- ----------------------------------------------------------------------------

Line 1277: hr_utility.set_location('Entering:'|| l_proc, 10);

1273: i number;
1274: j number;
1275: l_remaining_balances t_balance_types;
1276: begin
1277: hr_utility.set_location('Entering:'|| l_proc, 10);
1278: --
1279: -- Confirm that this balance has not already been excluded.
1280: --
1281: if not p_balance_types.exists(p_i) then

Line 1390: hr_utility.set_location('Leaving:'|| l_proc, 20);

1386: end loop;
1387: --
1388: p_balance_types := l_remaining_balances;
1389: --
1390: hr_utility.set_location('Leaving:'|| l_proc, 20);
1391: end exclude_balance_type;
1392: -- ----------------------------------------------------------------------------
1393: -- |-------------------------< exclude_input_value >--------------------------|
1394: -- ----------------------------------------------------------------------------

Line 1413: hr_utility.set_location('Entering:'|| l_proc, 10);

1409: i number;
1410: j number;
1411: l_remaining_balances t_balance_types;
1412: begin
1413: hr_utility.set_location('Entering:'|| l_proc, 10);
1414: --
1415: -- Get the input_value_id for this input value.
1416: --
1417: l_input_value_id := p_input_values(p_i).input_value_id;

Line 1497: hr_utility.set_location('Leaving:'|| l_proc, 20);

1493: end loop;
1494: --
1495: p_balance_types := l_remaining_balances;
1496: --
1497: hr_utility.set_location('Leaving:'|| l_proc, 20);
1498: end exclude_input_value;
1499: -- ----------------------------------------------------------------------------
1500: -- |-------------------------< exclude_element_type >-------------------------|
1501: -- ----------------------------------------------------------------------------

Line 1523: hr_utility.set_location('Entering:'|| l_proc, 10);

1519: l_element_type_id number;
1520: i number;
1521: j number;
1522: begin
1523: hr_utility.set_location('Entering:'|| l_proc, 10);
1524: --
1525: -- Get the element_type_id for this element type.
1526: --
1527: l_element_type_id := p_element_types(p_i).element_type_id;

Line 1657: hr_utility.set_location('Leaving:'|| l_proc, 20);

1653: i := p_template_ff_usages.next(i);
1654: end if;
1655: --
1656: end loop;
1657: hr_utility.set_location('Leaving:'|| l_proc, 20);
1658: end exclude_element_type;
1659: -- ----------------------------------------------------------------------------
1660: -- |--------------------------< exclude_formulas >----------------------------|
1661: -- ----------------------------------------------------------------------------

Line 1673: hr_utility.set_location('Entering:'|| l_proc, 10);

1669: l_formula_not_used boolean;
1670: i number;
1671: j number;
1672: begin
1673: hr_utility.set_location('Entering:'|| l_proc, 10);
1674: i := p_formulas.first;
1675: loop
1676: exit when not p_formulas.exists(i);
1677: --

Line 1720: hr_utility.set_location('Leaving:'|| l_proc, 50);

1716: i := p_formulas.next(i);
1717: end if;
1718: end loop;
1719: --
1720: hr_utility.set_location('Leaving:'|| l_proc, 50);
1721: end exclude_formulas;
1722: -- ----------------------------------------------------------------------------
1723: -- |----------------------------< apply_ff_usages >---------------------------|
1724: -- ----------------------------------------------------------------------------

Line 1799: hr_utility.set_location('Entering:'|| l_proc, 10);

1795: k number;
1796: l_exclusion_rule_id number;
1797: l_remaining_balances t_balance_types;
1798: begin
1799: hr_utility.set_location('Entering:'|| l_proc, 10);
1800: i := p_exclusion_rules.first;
1801: loop
1802: exit when not p_exclusion_rules.exists(i);
1803: if exclusion_on(p_element_template, p_exclusion_rules(i)) then

Line 2072: hr_utility.set_location('Leaving:'|| l_proc, 20);

2068: (p_formulas => p_formulas
2069: ,p_element_types => p_element_types
2070: ,p_input_values => p_input_values
2071: );
2072: hr_utility.set_location('Leaving:'|| l_proc, 20);
2073: end apply_exclusion_rules;
2074: -- ----------------------------------------------------------------------------
2075: -- |----------------------< set_input_value_defaults >------------------------|
2076: -- ----------------------------------------------------------------------------

Line 2084: hr_utility.set_location('Entering:'|| l_proc, 10);

2080: ) is
2081: l_proc varchar2(72) := g_package||'set_input_value_defaults';
2082: i number;
2083: begin
2084: hr_utility.set_location('Entering:'|| l_proc, 10);
2085: i := p_input_values.first;
2086: loop
2087: exit when not p_input_values.exists(i);
2088: --

Line 2245: hr_utility.set_location('Leaving:'|| l_proc, 20);

2241: end if;
2242: --
2243: i := p_input_values.next(i);
2244: end loop;
2245: hr_utility.set_location('Leaving:'|| l_proc, 20);
2246: end set_input_value_defaults;
2247: -- ----------------------------------------------------------------------------
2248: -- |------------------------< create_plsql_template >-------------------------|
2249: -- ----------------------------------------------------------------------------

Line 2276: hr_utility.set_location('Entering:'|| l_proc, 10);

2272: ) is
2273: l_proc varchar2(72) := g_package||'create_plsql_template';
2274: --
2275: begin
2276: hr_utility.set_location('Entering:'|| l_proc, 10);
2277: savepoint create_plsql_template;
2278: --
2279: -- Get the shadow schema rows in locking ladder order.
2280: --

Line 2380: hr_utility.set_location(' Leaving:'||l_proc, 90);

2376: -- Release locks.
2377: --
2378: rollback to create_plsql_template;
2379: end if;
2380: hr_utility.set_location(' Leaving:'||l_proc, 90);
2381: exception
2382: when others then
2383: hr_utility.set_location(' Leaving:'||l_proc, 100);
2384: flush_plsql_template

Line 2383: hr_utility.set_location(' Leaving:'||l_proc, 100);

2379: end if;
2380: hr_utility.set_location(' Leaving:'||l_proc, 90);
2381: exception
2382: when others then
2383: hr_utility.set_location(' Leaving:'||l_proc, 100);
2384: flush_plsql_template
2385: (p_element_template => p_element_template
2386: ,p_core_objects => p_core_objects
2387: ,p_formulas => p_formulas

Line 2492: hr_utility.set_location('Entering:'|| l_proc, 10);

2488: l_proc varchar2(72) := g_package||'plsql_to_db_template';
2489: l_id number;
2490: i number;
2491: begin
2492: hr_utility.set_location('Entering:'|| l_proc, 10);
2493: ------------------------------------------
2494: -- Create row in pay_element_templates. --
2495: ------------------------------------------
2496: p_element_template.template_id := null;

Line 2504: hr_utility.set_location(l_proc, 20);

2500: p_object_version_number := p_element_template.object_version_number;
2501: -----------------------------------
2502: -- Create the template formulas. --
2503: -----------------------------------
2504: hr_utility.set_location(l_proc, 20);
2505: i := p_formulas.first;
2506: loop
2507: exit when not p_formulas.exists(i);
2508: --

Line 2518: hr_utility.set_location(l_proc, 30);

2514: end loop;
2515: -------------------------------
2516: -- Create the element types. --
2517: -------------------------------
2518: hr_utility.set_location(l_proc, 30);
2519: i := p_element_types.first;
2520: loop
2521: exit when not p_element_types.exists(i);
2522: --

Line 2539: hr_utility.set_location(l_proc, 40);

2535: end loop;
2536: ------------------------------
2537: -- Create the input values. --
2538: ------------------------------
2539: hr_utility.set_location(l_proc, 40);
2540: i := p_input_values.first;
2541: loop
2542: exit when not p_input_values.exists(i);
2543: --

Line 2562: hr_utility.set_location(l_proc, 50);

2558: end loop;
2559: -------------------------------
2560: -- Create the balance types. --
2561: -------------------------------
2562: hr_utility.set_location(l_proc, 50);
2563: i := p_balance_types.first;
2564: loop
2565: exit when not p_balance_types.exists(i);
2566: --

Line 2580: hr_utility.set_location(l_proc, 60);

2576: end loop;
2577: ------------------------------------------
2578: -- Create the sub-classification rules. --
2579: ------------------------------------------
2580: hr_utility.set_location(l_proc, 60);
2581: i := p_sub_classi_rules.first;
2582: loop
2583: exit when not p_sub_classi_rules.exists(i);
2584: --

Line 2599: hr_utility.set_location(l_proc, 70);

2595: end loop;
2596: --------------------------------------
2597: -- Create the formula result rules. --
2598: --------------------------------------
2599: hr_utility.set_location(l_proc, 70);
2600: i := p_formula_rules.first;
2601: loop
2602: exit when not p_formula_rules.exists(i);
2603: --

Line 2628: hr_utility.set_location(l_proc, 80);

2624: end loop;
2625: -----------------------------------------
2626: -- Create the balance classifications. --
2627: -----------------------------------------
2628: hr_utility.set_location(l_proc, 80);
2629: i := p_balance_classis.first;
2630: loop
2631: exit when not p_balance_classis.exists(i);
2632: --

Line 2647: hr_utility.set_location(l_proc, 90);

2643: end loop;
2644: ----------------------------------
2645: -- Create the defined balances. --
2646: ----------------------------------
2647: hr_utility.set_location(l_proc, 90);
2648: i := p_defined_balances.first;
2649: loop
2650: exit when not p_defined_balances.exists(i);
2651: --

Line 2666: hr_utility.set_location(l_proc, 100);

2662: end loop;
2663: -------------------------------
2664: -- Create the balance feeds. --
2665: -------------------------------
2666: hr_utility.set_location(l_proc, 100);
2667: i := p_balance_feeds.first;
2668: loop
2669: exit when not p_balance_feeds.exists(i);
2670: --

Line 2689: hr_utility.set_location(l_proc, 110);

2685: end loop;
2686: ---------------------------------
2687: -- Create the iterative rules. --
2688: ---------------------------------
2689: hr_utility.set_location(l_proc, 110);
2690: i := p_iterative_rules.first;
2691: loop
2692: exit when not p_iterative_rules.exists(i);
2693: --

Line 2712: hr_utility.set_location(l_proc, 120);

2708: end loop;
2709: -------------------------------------
2710: -- Create the element type usages. --
2711: -------------------------------------
2712: hr_utility.set_location(l_proc, 120);
2713: i := p_ele_type_usages.first;
2714: loop
2715: exit when not p_ele_type_usages.exists(i);
2716: --

Line 2730: hr_utility.set_location(l_proc, 130);

2726: end loop;
2727: --------------------------------------------
2728: -- Create the grossup balance exclusions. --
2729: --------------------------------------------
2730: hr_utility.set_location(l_proc, 130);
2731: i := p_gu_bal_exclusions.first;
2732: loop
2733: exit when not p_gu_bal_exclusions.exists(i);
2734: --

Line 2753: hr_utility.set_location(l_proc, 140);

2749: end loop;
2750: ------------------------------------
2751: -- Create the balance attributes. --
2752: ------------------------------------
2753: hr_utility.set_location(l_proc, 140);
2754: i := p_bal_attributes.first;
2755: loop
2756: exit when not p_bal_attributes.exists(i);
2757: --

Line 2772: hr_utility.set_location('Leaving:'|| l_proc, 500);

2768: --
2769: i := p_bal_attributes.next(i);
2770: end loop;
2771: --
2772: hr_utility.set_location('Leaving:'|| l_proc, 500);
2773: end plsql_to_db_template;
2774: -- ----------------------------------------------------------------------------
2775: -- |---------------------------< replace_name >-------------------------------|
2776: -- ----------------------------------------------------------------------------

Line 2785: hr_utility.set_location('Entering:'|| l_proc, 10);

2781: ) is
2782: l_proc varchar2(72) := g_package||'replace_name';
2783: l_temp_string varchar2(32767);
2784: begin
2785: hr_utility.set_location('Entering:'|| l_proc, 10);
2786: l_temp_string := replace(p_string, g_name_placeholder, p_base_name);
2787: p_string := hr_mb_substrb(l_temp_string, 1, p_string_length);
2788: hr_utility.set_location('Leaving:'|| l_proc, 20);
2789: end replace_name;

Line 2788: hr_utility.set_location('Leaving:'|| l_proc, 20);

2784: begin
2785: hr_utility.set_location('Entering:'|| l_proc, 10);
2786: l_temp_string := replace(p_string, g_name_placeholder, p_base_name);
2787: p_string := hr_mb_substrb(l_temp_string, 1, p_string_length);
2788: hr_utility.set_location('Leaving:'|| l_proc, 20);
2789: end replace_name;
2790: -- ----------------------------------------------------------------------------
2791: -- |---------------------------< prefix_name >--------------------------------|
2792: -- ----------------------------------------------------------------------------

Line 2800: hr_utility.set_location('Entering:'|| l_proc, 10);

2796: ,p_prefix in varchar2
2797: ) is
2798: l_proc varchar2(72) := g_package||'prefix_name';
2799: begin
2800: hr_utility.set_location('Entering:'|| l_proc, 10);
2801: --
2802: -- Preserve the prefix at the expense of the suffix.
2803: --
2804: p_string :=

Line 2806: hr_utility.set_location('Leaving:'|| l_proc, 20);

2802: -- Preserve the prefix at the expense of the suffix.
2803: --
2804: p_string :=
2805: hr_mb_substrb(p_prefix || p_string, 1, p_maximum_string_length);
2806: hr_utility.set_location('Leaving:'|| l_proc, 20);
2807: end prefix_name;
2808: -- ----------------------------------------------------------------------------
2809: -- |-------------------< create_plsql_user_structure >------------------------|
2810: -- ----------------------------------------------------------------------------

Line 2900: hr_utility.set_location('Entering:'|| l_proc, 10);

2896: i number;
2897: l_base_name varchar2(2000);
2898: --
2899: begin
2900: hr_utility.set_location('Entering:'|| l_proc, 10);
2901: ---------------------------------------------------------------------------
2902: -- Keep a local copy of the base name with spaces replaced by '_'. --
2903: ---------------------------------------------------------------------------
2904: l_base_name := upper(replace(p_base_name, ' ', '_'));

Line 3248: hr_utility.set_location('Leaving:'|| l_proc, 20);

3244: begin
3245: replace_name(p_formulas(i).formula_text, l_base_name, 32767);
3246: exception
3247: when plsql_value_error then
3248: hr_utility.set_location('Leaving:'|| l_proc, 20);
3249: fnd_message.set_name(801, 'PAY_50068_ETM_GEN_FF_TOO_LONG');
3250: fnd_message.set_token('BASE_NAME', l_base_name, false);
3251: fnd_message.set_token('LENGTH', 32767);
3252: fnd_message.raise_error;

Line 3254: hr_utility.set_location('Leaving:'|| l_proc, 30);

3250: fnd_message.set_token('BASE_NAME', l_base_name, false);
3251: fnd_message.set_token('LENGTH', 32767);
3252: fnd_message.raise_error;
3253: when others then
3254: hr_utility.set_location('Leaving:'|| l_proc, 30);
3255: raise;
3256: end;
3257: i := p_formulas.next(i);
3258: end loop;

Line 3290: hr_utility.set_location('Leaving:'|| l_proc, 40);

3286: );
3287: ----------------------------------------
3288: -- Apply the template formula usages. --
3289: ----------------------------------------
3290: hr_utility.set_location('Leaving:'|| l_proc, 40);
3291: end create_plsql_user_structure;
3292: -- ----------------------------------------------------------------------------
3293: -- |---------------------------< delete_template >----------------------------|
3294: -- ----------------------------------------------------------------------------

Line 3304: hr_utility.set_location('Entering:'|| l_proc, 10);

3300: l_proc varchar2(72) := g_package||'delete_template';
3301: i number;
3302: l_ovn number;
3303: begin
3304: hr_utility.set_location('Entering:'|| l_proc, 10);
3305: ---------------------------------------------
3306: -- Delete template core object rows first. --
3307: ---------------------------------------------
3308: delete from pay_template_core_objects

Line 3471: hr_utility.set_location('Leaving:'|| l_proc, 200);

3467: ---------------------------
3468: delete from pay_element_templates
3469: where template_id = p_template_id;
3470: --
3471: hr_utility.set_location('Leaving:'|| l_proc, 200);
3472: end delete_template;
3473: --
3474:
3475: FUNCTION get_shadow_formula_name(p_formula_id in number)