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.HRDYNDBI dependencies on PAY_DYNDBI_CHANGES

Line 145: Only delete PAY_DYNDBI_CHANGES row if

141: Set the g_security_group_id for the
142: NAME_TRANSLATIONS lookup in
143: pay_process_dyndbi_changes, otherwise
144: the meaning is not translated.
145: Only delete PAY_DYNDBI_CHANGES row if
146: no errors occurred.
147: arashid 115.142 10-NOV-2006 Bug5464970 fix for changed
148: pay_dbitl_update_errors_pkg.fetch_all_rows
149: interface. Also, use dbms_sql.varchar_table

Line 158: process_pay_dyndbi_changes.

154: not taking place.
155: divicker 115.140 01-JUN-2006 11511 branch merge
156: arashid 115.139 11-MAY-2006 Add code for running legislation-specific
157: database item translation from
158: process_pay_dyndbi_changes.
159: arashid 115.138 09-MAY-2006 Don't disable ff_user_entities delete
160: triggers as thay are required to delete
161: ff_database_items_tl rows (other child
162: rows are cascade deleted).

Line 174: Put debug into PROCESS_PAY_DYNDBI_CHANGES,

170: GEN_EIV_BASE_DBI_NAME
171: arashid 115.136 04-MAY-2006 Fixed infinitely looping code for
172: translating DATE_PAID and non-DATE_PAID
173: ELEMENT TYPE / INPUT VALUE database items.
174: Put debug into PROCESS_PAY_DYNDBI_CHANGES,
175: and tidied up the update error logging
176: code therein.
177: arashid 115.135 27-APR-2006 The following changes were made:
178: - process date-paid and non-date-paid

Line 180: - process_pay_dyndbi_changes code now calls

176: code therein.
177: arashid 115.135 27-APR-2006 The following changes were made:
178: - process date-paid and non-date-paid
179: database items when updating _TL names.
180: - process_pay_dyndbi_changes code now calls
181: FF_DATABASE_ITEMS_PKG.UPDATE_SEEDED_TL_ROWS
182: and writes messages to the concurrent
183: processing log file.
184: arashid 115.134 31-MAR-2006 Changed process_pay_dyndbi_changes to not

Line 184: arashid 115.134 31-MAR-2006 Changed process_pay_dyndbi_changes to not

180: - process_pay_dyndbi_changes code now calls
181: FF_DATABASE_ITEMS_PKG.UPDATE_SEEDED_TL_ROWS
182: and writes messages to the concurrent
183: processing log file.
184: arashid 115.134 31-MAR-2006 Changed process_pay_dyndbi_changes to not
185: raise assertions when entities are missing.
186: Instead, the condition is traced and the
187: PAY_DYNDBI_CHANGES row deleted.
188: arashid 115.133 27-JAN-2006 Changed process_pay_dyndbi_changes to a

Line 187: PAY_DYNDBI_CHANGES row deleted.

183: processing log file.
184: arashid 115.134 31-MAR-2006 Changed process_pay_dyndbi_changes to not
185: raise assertions when entities are missing.
186: Instead, the condition is traced and the
187: PAY_DYNDBI_CHANGES row deleted.
188: arashid 115.133 27-JAN-2006 Changed process_pay_dyndbi_changes to a
189: concurrent processing interface with VARCHAR2
190: parameters.
191: arashid 115.132 11-NOV-2005 Fixed bug in new_defined_balance whereby

Line 188: arashid 115.133 27-JAN-2006 Changed process_pay_dyndbi_changes to a

184: arashid 115.134 31-MAR-2006 Changed process_pay_dyndbi_changes to not
185: raise assertions when entities are missing.
186: Instead, the condition is traced and the
187: PAY_DYNDBI_CHANGES row deleted.
188: arashid 115.133 27-JAN-2006 Changed process_pay_dyndbi_changes to a
189: concurrent processing interface with VARCHAR2
190: parameters.
191: arashid 115.132 11-NOV-2005 Fixed bug in new_defined_balance whereby
192: p_defined_balance_id was being passed

Line 194: arashid 115.131 01-NOV-2005 Made process_pay_dyndbi_changes multi-threaded.

190: parameters.
191: arashid 115.132 11-NOV-2005 Fixed bug in new_defined_balance whereby
192: p_defined_balance_id was being passed
193: as p_balance_type_id in GEN_DB_TL_DBI_NAME.
194: arashid 115.131 01-NOV-2005 Made process_pay_dyndbi_changes multi-threaded.
195: arashid 115.130 31-OCT-2005 Changed PROCESS_PAY_DYNDBI_CHANGES to COMMIT
196: every 50 rows.
197: arashid 115.129 19-OCT-2005 Added support for fully translated dynamic
198: database items.

Line 195: arashid 115.130 31-OCT-2005 Changed PROCESS_PAY_DYNDBI_CHANGES to COMMIT

191: arashid 115.132 11-NOV-2005 Fixed bug in new_defined_balance whereby
192: p_defined_balance_id was being passed
193: as p_balance_type_id in GEN_DB_TL_DBI_NAME.
194: arashid 115.131 01-NOV-2005 Made process_pay_dyndbi_changes multi-threaded.
195: arashid 115.130 31-OCT-2005 Changed PROCESS_PAY_DYNDBI_CHANGES to COMMIT
196: every 50 rows.
197: arashid 115.129 19-OCT-2005 Added support for fully translated dynamic
198: database items.
199: 1. Added internal insert_database_item

Line 642: -- Flags for PROCESS_PAY_DYNDBI_CHANGES procedure.

638: );
639:
640: type t_dbi_prefixes is table of r_dbi_prefix index by binary_integer;
641: --
642: -- Flags for PROCESS_PAY_DYNDBI_CHANGES procedure.
643: --
644: g_dyndbi_changes boolean := false;
645: g_dyndbi_changes_ok boolean;
646: --

Line 10158: -- Process PAY_DYNDBI_CHANGES rows. --

10154: p_errors(p_errors.count + 1) := sqlerrm;
10155: end process_leg_translations;
10156:
10157: -- ================================ --
10158: -- Process PAY_DYNDBI_CHANGES rows. --
10159: -- ================================ --
10160:
10161: --
10162: -- Procedure to fetch changes for a particular entity type.

Line 10174: from pay_dyndbi_changes pdc

10170: (p_type in varchar2
10171: ) is
10172: select pdc.id
10173: , pdc.language
10174: from pay_dyndbi_changes pdc
10175: where pdc.type = p_type
10176: order by 1, 2
10177: ;
10178: begin

Line 10224: procedure process_pay_dyndbi_changes

10220: --
10221: p_start := i;
10222: end next_dyndbi_change;
10223:
10224: procedure process_pay_dyndbi_changes
10225: (errbuf out nocopy varchar2
10226: ,retcode out nocopy number
10227: ,p_element_types in varchar2
10228: ,p_input_values in varchar2

Line 10232: l_proc varchar2(2000) := 'PROCESS_PAY_DYNDBI_CHANGES:';

10228: ,p_input_values in varchar2
10229: ,p_defined_balances in varchar2
10230: ,p_localization in varchar2
10231: ) is
10232: l_proc varchar2(2000) := 'PROCESS_PAY_DYNDBI_CHANGES:';
10233: l_ids dbms_sql.number_table;
10234: l_languages dbms_sql.varchar2s;
10235: l_id number;
10236: l_id_langs dbms_sql.varchar2s;

Line 10301: hr_utility.set_location('process_pay_dyndbi_changes', 0);

10297: g_security_group_id :=
10298: fnd_global.lookup_security_group('NAME_TRANSLATIONS', 3);
10299:
10300: if l_debug then
10301: hr_utility.set_location('process_pay_dyndbi_changes', 0);
10302: end if;
10303:
10304: --
10305: -- Set log file message separator.

Line 10315: hr_utility.set_location('process_pay_dyndbi_changes', 10);

10311: -- ============== --
10312: if upper(p_element_types) = 'Y' then
10313:
10314: if l_debug then
10315: hr_utility.set_location('process_pay_dyndbi_changes', 10);
10316: end if;
10317:
10318: --
10319: -- Initialise everything.

Line 10326: -- Fetch the PAY_DYNDBI_CHANGES rows.

10322: l_languages.delete;
10323: i := 1;
10324:
10325: --
10326: -- Fetch the PAY_DYNDBI_CHANGES rows.
10327: --
10328: fetch_dyndbi_changes
10329: (p_type => pay_dyndbi_changes_pkg.c_element_type
10330: ,p_ids => l_ids

Line 10329: (p_type => pay_dyndbi_changes_pkg.c_element_type

10325: --
10326: -- Fetch the PAY_DYNDBI_CHANGES rows.
10327: --
10328: fetch_dyndbi_changes
10329: (p_type => pay_dyndbi_changes_pkg.c_element_type
10330: ,p_ids => l_ids
10331: ,p_languages => l_languages
10332: );
10333:

Line 10335: hr_utility.set_location('process_pay_dyndbi_changes', 20);

10331: ,p_languages => l_languages
10332: );
10333:
10334: if l_debug then
10335: hr_utility.set_location('process_pay_dyndbi_changes', 20);
10336: end if;
10337:
10338: --
10339: -- Do the updates.

Line 10346: hr_utility.set_location('process_pay_dyndbi_changes', 30);

10342:
10343: while l_ids.exists(i) loop
10344:
10345: if l_debug then
10346: hr_utility.set_location('process_pay_dyndbi_changes', 30);
10347: end if;
10348:
10349: l_id_langs.delete;
10350: next_dyndbi_change

Line 10369: hr_utility.set_location('process_pay_dyndbi_changes', 40);

10365: l_found := csr_ele_eff_date%found;
10366: close csr_ele_eff_date;
10367:
10368: if l_debug then
10369: hr_utility.set_location('process_pay_dyndbi_changes', 40);
10370: end if;
10371:
10372: g_dyndbi_changes_ok := true;
10373: if l_found then

Line 10376: hr_utility.set_location('process_pay_dyndbi_changes', 50);

10372: g_dyndbi_changes_ok := true;
10373: if l_found then
10374:
10375: if l_debug then
10376: hr_utility.set_location('process_pay_dyndbi_changes', 50);
10377: end if;
10378:
10379: begin
10380: update_element_type

Line 10395: hr_utility.set_location('process_pay_dyndbi_changes', 60);

10391: retcode := 2;
10392: end;
10393:
10394: if l_debug then
10395: hr_utility.set_location('process_pay_dyndbi_changes', 60);
10396: end if;
10397: else
10398: hr_utility.trace(l_proc||'no such element '||l_id);
10399: end if;

Line 10402: hr_utility.set_location('process_pay_dyndbi_changes', 70);

10398: hr_utility.trace(l_proc||'no such element '||l_id);
10399: end if;
10400:
10401: if l_debug then
10402: hr_utility.set_location('process_pay_dyndbi_changes', 70);
10403: end if;
10404:
10405: --
10406: -- Delete the PAY_DYNDBI_CHANGES rows.

Line 10406: -- Delete the PAY_DYNDBI_CHANGES rows.

10402: hr_utility.set_location('process_pay_dyndbi_changes', 70);
10403: end if;
10404:
10405: --
10406: -- Delete the PAY_DYNDBI_CHANGES rows.
10407: --
10408: if g_dyndbi_changes_ok then
10409: pay_dyndbi_changes_pkg.delete_rows
10410: (p_id => l_id

Line 10409: pay_dyndbi_changes_pkg.delete_rows

10405: --
10406: -- Delete the PAY_DYNDBI_CHANGES rows.
10407: --
10408: if g_dyndbi_changes_ok then
10409: pay_dyndbi_changes_pkg.delete_rows
10410: (p_id => l_id
10411: ,p_type => pay_dyndbi_changes_pkg.c_element_type
10412: );
10413: end if;

Line 10411: ,p_type => pay_dyndbi_changes_pkg.c_element_type

10407: --
10408: if g_dyndbi_changes_ok then
10409: pay_dyndbi_changes_pkg.delete_rows
10410: (p_id => l_id
10411: ,p_type => pay_dyndbi_changes_pkg.c_element_type
10412: );
10413: end if;
10414:
10415: if l_debug then

Line 10416: hr_utility.set_location('process_pay_dyndbi_changes', 80);

10412: );
10413: end if;
10414:
10415: if l_debug then
10416: hr_utility.set_location('process_pay_dyndbi_changes', 80);
10417: end if;
10418:
10419: incr_cnt(p_cnt => l_cnt);
10420: end loop;

Line 10429: hr_utility.set_location('process_pay_dyndbi_changes', 90);

10425: commit;
10426: end if;
10427:
10428: if l_debug then
10429: hr_utility.set_location('process_pay_dyndbi_changes', 90);
10430: end if;
10431:
10432: -- ============= --
10433: -- Input Values. --

Line 10438: hr_utility.set_location('process_pay_dyndbi_changes', 100);

10434: -- ============= --
10435: if upper(p_input_values) = 'Y' then
10436:
10437: if l_debug then
10438: hr_utility.set_location('process_pay_dyndbi_changes', 100);
10439: end if;
10440:
10441: --
10442: -- Initialise everything.

Line 10449: -- Fetch the PAY_DYNDBI_CHANGES rows.

10445: l_languages.delete;
10446: i := 1;
10447:
10448: --
10449: -- Fetch the PAY_DYNDBI_CHANGES rows.
10450: --
10451: fetch_dyndbi_changes
10452: (p_type => pay_dyndbi_changes_pkg.c_input_value
10453: ,p_ids => l_ids

Line 10452: (p_type => pay_dyndbi_changes_pkg.c_input_value

10448: --
10449: -- Fetch the PAY_DYNDBI_CHANGES rows.
10450: --
10451: fetch_dyndbi_changes
10452: (p_type => pay_dyndbi_changes_pkg.c_input_value
10453: ,p_ids => l_ids
10454: ,p_languages => l_languages
10455: );
10456:

Line 10458: hr_utility.set_location('process_pay_dyndbi_changes', 110);

10454: ,p_languages => l_languages
10455: );
10456:
10457: if l_debug then
10458: hr_utility.set_location('process_pay_dyndbi_changes', 110);
10459: end if;
10460:
10461: --
10462: -- Do the updates.

Line 10469: hr_utility.set_location('process_pay_dyndbi_changes', 120);

10465:
10466: while l_ids.exists(i) loop
10467:
10468: if l_debug then
10469: hr_utility.set_location('process_pay_dyndbi_changes', 120);
10470: end if;
10471:
10472: l_id_langs.delete;
10473: next_dyndbi_change

Line 10492: hr_utility.set_location('process_pay_dyndbi_changes', 130);

10488: l_found := csr_ipv_eff_date%found;
10489: close csr_ipv_eff_date;
10490:
10491: if l_debug then
10492: hr_utility.set_location('process_pay_dyndbi_changes', 130);
10493: end if;
10494:
10495: g_dyndbi_changes_ok := true;
10496: if l_found then

Line 10516: hr_utility.set_location('process_pay_dyndbi_changes', 140);

10512: hr_utility.trace(l_proc||'no such input value '||l_id);
10513: end if;
10514:
10515: if l_debug then
10516: hr_utility.set_location('process_pay_dyndbi_changes', 140);
10517: end if;
10518:
10519: --
10520: -- Delete the PAY_DYNDBI_CHANGES rows.

Line 10520: -- Delete the PAY_DYNDBI_CHANGES rows.

10516: hr_utility.set_location('process_pay_dyndbi_changes', 140);
10517: end if;
10518:
10519: --
10520: -- Delete the PAY_DYNDBI_CHANGES rows.
10521: --
10522: if g_dyndbi_changes_ok then
10523: pay_dyndbi_changes_pkg.delete_rows
10524: (p_id => l_id

Line 10523: pay_dyndbi_changes_pkg.delete_rows

10519: --
10520: -- Delete the PAY_DYNDBI_CHANGES rows.
10521: --
10522: if g_dyndbi_changes_ok then
10523: pay_dyndbi_changes_pkg.delete_rows
10524: (p_id => l_id
10525: ,p_type => pay_dyndbi_changes_pkg.c_input_value
10526: );
10527: end if;

Line 10525: ,p_type => pay_dyndbi_changes_pkg.c_input_value

10521: --
10522: if g_dyndbi_changes_ok then
10523: pay_dyndbi_changes_pkg.delete_rows
10524: (p_id => l_id
10525: ,p_type => pay_dyndbi_changes_pkg.c_input_value
10526: );
10527: end if;
10528:
10529: if l_debug then

Line 10530: hr_utility.set_location('process_pay_dyndbi_changes', 150);

10526: );
10527: end if;
10528:
10529: if l_debug then
10530: hr_utility.set_location('process_pay_dyndbi_changes', 150);
10531: end if;
10532:
10533: incr_cnt(p_cnt => l_cnt);
10534: end loop;

Line 10543: hr_utility.set_location('process_pay_dyndbi_changes', 160);

10539: commit;
10540: end if;
10541:
10542: if l_debug then
10543: hr_utility.set_location('process_pay_dyndbi_changes', 160);
10544: end if;
10545:
10546: -- ================= --
10547: -- Defined Balances. --

Line 10552: hr_utility.set_location('process_pay_dyndbi_changes', 170);

10548: -- ================= --
10549: if upper(p_defined_balances) = 'Y' then
10550:
10551: if l_debug then
10552: hr_utility.set_location('process_pay_dyndbi_changes', 170);
10553: end if;
10554:
10555: --
10556: -- Initialise everything.

Line 10563: -- Fetch the PAY_DYNDBI_CHANGES rows.

10559: l_languages.delete;
10560: i := 1;
10561:
10562: --
10563: -- Fetch the PAY_DYNDBI_CHANGES rows.
10564: --
10565: fetch_dyndbi_changes
10566: (p_type => pay_dyndbi_changes_pkg.c_defined_balance
10567: ,p_ids => l_ids

Line 10566: (p_type => pay_dyndbi_changes_pkg.c_defined_balance

10562: --
10563: -- Fetch the PAY_DYNDBI_CHANGES rows.
10564: --
10565: fetch_dyndbi_changes
10566: (p_type => pay_dyndbi_changes_pkg.c_defined_balance
10567: ,p_ids => l_ids
10568: ,p_languages => l_languages
10569: );
10570:

Line 10572: hr_utility.set_location('process_pay_dyndbi_changes', 180);

10568: ,p_languages => l_languages
10569: );
10570:
10571: if l_debug then
10572: hr_utility.set_location('process_pay_dyndbi_changes', 180);
10573: end if;
10574:
10575: --
10576: -- Do the updates.

Line 10583: hr_utility.set_location('process_pay_dyndbi_changes', 190);

10579:
10580: while l_ids.exists(i) loop
10581:
10582: if l_debug then
10583: hr_utility.set_location('process_pay_dyndbi_changes', 190);
10584: end if;
10585:
10586: l_id_langs.delete;
10587: next_dyndbi_change

Line 10603: hr_utility.set_location('process_pay_dyndbi_changes', 200);

10599: l_found := csr_def_balance%found;
10600: close csr_def_balance;
10601:
10602: if l_debug then
10603: hr_utility.set_location('process_pay_dyndbi_changes', 200);
10604: end if;
10605:
10606: g_dyndbi_changes_ok := true;
10607: if l_found then

Line 10610: hr_utility.set_location('process_pay_dyndbi_changes', 210);

10606: g_dyndbi_changes_ok := true;
10607: if l_found then
10608:
10609: if l_debug then
10610: hr_utility.set_location('process_pay_dyndbi_changes', 210);
10611: end if;
10612:
10613: begin
10614: update_defined_balance

Line 10631: -- Delete the PAY_DYNDBI_CHANGES rows.

10627: hr_utility.trace(l_proc||'no defined balance '||l_id);
10628: end if;
10629:
10630: --
10631: -- Delete the PAY_DYNDBI_CHANGES rows.
10632: --
10633: if g_dyndbi_changes_ok then
10634: pay_dyndbi_changes_pkg.delete_rows
10635: (p_id => l_id

Line 10634: pay_dyndbi_changes_pkg.delete_rows

10630: --
10631: -- Delete the PAY_DYNDBI_CHANGES rows.
10632: --
10633: if g_dyndbi_changes_ok then
10634: pay_dyndbi_changes_pkg.delete_rows
10635: (p_id => l_id
10636: ,p_type => pay_dyndbi_changes_pkg.c_defined_balance
10637: );
10638: end if;

Line 10636: ,p_type => pay_dyndbi_changes_pkg.c_defined_balance

10632: --
10633: if g_dyndbi_changes_ok then
10634: pay_dyndbi_changes_pkg.delete_rows
10635: (p_id => l_id
10636: ,p_type => pay_dyndbi_changes_pkg.c_defined_balance
10637: );
10638: end if;
10639:
10640: if l_debug then

Line 10641: hr_utility.set_location('process_pay_dyndbi_changes', 220);

10637: );
10638: end if;
10639:
10640: if l_debug then
10641: hr_utility.set_location('process_pay_dyndbi_changes', 220);
10642: end if;
10643:
10644: incr_cnt(p_cnt => l_cnt);
10645: end loop;

Line 10654: hr_utility.set_location('process_pay_dyndbi_changes', 230);

10650: commit;
10651: end if;
10652:
10653: if l_debug then
10654: hr_utility.set_location('process_pay_dyndbi_changes', 230);
10655: end if;
10656:
10657: --
10658: -- Do the legislation-specfic changes.

Line 10663: hr_utility.set_location('process_pay_dyndbi_changes', 235);

10659: --
10660: if upper(p_localization) = 'Y' then
10661:
10662: if l_debug then
10663: hr_utility.set_location('process_pay_dyndbi_changes', 235);
10664: end if;
10665:
10666: process_leg_translations(p_errors => l_errors);
10667: for i in 1 .. l_errors.count loop

Line 10682: hr_utility.set_location('process_pay_dyndbi_changes', 240);

10678: ,p_messages => l_messages
10679: );
10680:
10681: if l_debug then
10682: hr_utility.set_location('process_pay_dyndbi_changes', 240);
10683: end if;
10684:
10685: --
10686: -- Set error status if there are any error messages.

Line 10715: hr_utility.set_location('process_pay_dyndbi_changes', 250);

10711:
10712: g_dyndbi_changes := false;
10713:
10714: if l_debug then
10715: hr_utility.set_location('process_pay_dyndbi_changes', 250);
10716: end if;
10717:
10718: exception
10719: when others then

Line 10725: hr_utility.set_location('process_pay_dyndbi_changes', 300);

10721: errbuf := sqlerrm;
10722: retcode := 2;
10723:
10724: if l_debug then
10725: hr_utility.set_location('process_pay_dyndbi_changes', 300);
10726: end if;
10727: end process_pay_dyndbi_changes;
10728:
10729: end hrdyndbi;

Line 10727: end process_pay_dyndbi_changes;

10723:
10724: if l_debug then
10725: hr_utility.set_location('process_pay_dyndbi_changes', 300);
10726: end if;
10727: end process_pay_dyndbi_changes;
10728:
10729: end hrdyndbi;