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 125: priupadh 115.149 15-May-2009 Bug 8512762 Added commit in process_pay_dyndbi_changes.

121: Name Ver DD-MON-YYYY BugNo. and text
122: -----------------------------------------
123: pgongada 115.150 22-Aug-2009 Bug#8717589.Creating database items for
124: 'Further Personal Payment Method Info' DFF.
125: priupadh 115.149 15-May-2009 Bug 8512762 Added commit in process_pay_dyndbi_changes.
126: ckesanap 115.148 25-Apr-2008 Bug 6955080. In delete_keyflex_dict, chaged the
127: where condition clause for deleting the
128: existing user_entity from ff_user_entities.
129: ckesanap 115.147 07-Aug-2007 Bug 5930272. Added fnd_message.retrieve() in

Line 148: Only delete PAY_DYNDBI_CHANGES row if

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

Line 161: process_pay_dyndbi_changes.

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

Line 177: Put debug into PROCESS_PAY_DYNDBI_CHANGES,

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

Line 183: - process_pay_dyndbi_changes code now calls

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

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

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

Line 190: PAY_DYNDBI_CHANGES row deleted.

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

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

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

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

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

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

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

Line 645: -- Flags for PROCESS_PAY_DYNDBI_CHANGES procedure.

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

Line 10235: -- Process PAY_DYNDBI_CHANGES rows. --

10231: p_errors(p_errors.count + 1) := sqlerrm;
10232: end process_leg_translations;
10233:
10234: -- ================================ --
10235: -- Process PAY_DYNDBI_CHANGES rows. --
10236: -- ================================ --
10237:
10238: --
10239: -- Procedure to fetch changes for a particular entity type.

Line 10251: from pay_dyndbi_changes pdc

10247: (p_type in varchar2
10248: ) is
10249: select pdc.id
10250: , pdc.language
10251: from pay_dyndbi_changes pdc
10252: where pdc.type = p_type
10253: order by 1, 2
10254: ;
10255: begin

Line 10301: procedure process_pay_dyndbi_changes

10297: --
10298: p_start := i;
10299: end next_dyndbi_change;
10300:
10301: procedure process_pay_dyndbi_changes
10302: (errbuf out nocopy varchar2
10303: ,retcode out nocopy number
10304: ,p_element_types in varchar2
10305: ,p_input_values in varchar2

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

10305: ,p_input_values in varchar2
10306: ,p_defined_balances in varchar2
10307: ,p_localization in varchar2
10308: ) is
10309: l_proc varchar2(2000) := 'PROCESS_PAY_DYNDBI_CHANGES:';
10310: l_ids dbms_sql.number_table;
10311: l_languages dbms_sql.varchar2s;
10312: l_id number;
10313: l_id_langs dbms_sql.varchar2s;

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

10374: g_security_group_id :=
10375: fnd_global.lookup_security_group('NAME_TRANSLATIONS', 3);
10376:
10377: if l_debug then
10378: hr_utility.set_location('process_pay_dyndbi_changes', 0);
10379: end if;
10380:
10381: --
10382: -- Set log file message separator.

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

10388: -- ============== --
10389: if upper(p_element_types) = 'Y' then
10390:
10391: if l_debug then
10392: hr_utility.set_location('process_pay_dyndbi_changes', 10);
10393: end if;
10394:
10395: --
10396: -- Initialise everything.

Line 10403: -- Fetch the PAY_DYNDBI_CHANGES rows.

10399: l_languages.delete;
10400: i := 1;
10401:
10402: --
10403: -- Fetch the PAY_DYNDBI_CHANGES rows.
10404: --
10405: fetch_dyndbi_changes
10406: (p_type => pay_dyndbi_changes_pkg.c_element_type
10407: ,p_ids => l_ids

Line 10406: (p_type => pay_dyndbi_changes_pkg.c_element_type

10402: --
10403: -- Fetch the PAY_DYNDBI_CHANGES rows.
10404: --
10405: fetch_dyndbi_changes
10406: (p_type => pay_dyndbi_changes_pkg.c_element_type
10407: ,p_ids => l_ids
10408: ,p_languages => l_languages
10409: );
10410:

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

10408: ,p_languages => l_languages
10409: );
10410:
10411: if l_debug then
10412: hr_utility.set_location('process_pay_dyndbi_changes', 20);
10413: end if;
10414:
10415: --
10416: -- Do the updates.

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

10419:
10420: while l_ids.exists(i) loop
10421:
10422: if l_debug then
10423: hr_utility.set_location('process_pay_dyndbi_changes', 30);
10424: end if;
10425:
10426: l_id_langs.delete;
10427: next_dyndbi_change

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

10442: l_found := csr_ele_eff_date%found;
10443: close csr_ele_eff_date;
10444:
10445: if l_debug then
10446: hr_utility.set_location('process_pay_dyndbi_changes', 40);
10447: end if;
10448:
10449: g_dyndbi_changes_ok := true;
10450: if l_found then

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

10449: g_dyndbi_changes_ok := true;
10450: if l_found then
10451:
10452: if l_debug then
10453: hr_utility.set_location('process_pay_dyndbi_changes', 50);
10454: end if;
10455:
10456: begin
10457: update_element_type

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

10468: retcode := 2;
10469: end;
10470:
10471: if l_debug then
10472: hr_utility.set_location('process_pay_dyndbi_changes', 60);
10473: end if;
10474: else
10475: hr_utility.trace(l_proc||'no such element '||l_id);
10476: end if;

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

10475: hr_utility.trace(l_proc||'no such element '||l_id);
10476: end if;
10477:
10478: if l_debug then
10479: hr_utility.set_location('process_pay_dyndbi_changes', 70);
10480: end if;
10481:
10482: --
10483: -- Delete the PAY_DYNDBI_CHANGES rows.

Line 10483: -- Delete the PAY_DYNDBI_CHANGES rows.

10479: hr_utility.set_location('process_pay_dyndbi_changes', 70);
10480: end if;
10481:
10482: --
10483: -- Delete the PAY_DYNDBI_CHANGES rows.
10484: --
10485: if g_dyndbi_changes_ok then
10486: pay_dyndbi_changes_pkg.delete_rows
10487: (p_id => l_id

Line 10486: pay_dyndbi_changes_pkg.delete_rows

10482: --
10483: -- Delete the PAY_DYNDBI_CHANGES rows.
10484: --
10485: if g_dyndbi_changes_ok then
10486: pay_dyndbi_changes_pkg.delete_rows
10487: (p_id => l_id
10488: ,p_type => pay_dyndbi_changes_pkg.c_element_type
10489: );
10490: end if;

Line 10488: ,p_type => pay_dyndbi_changes_pkg.c_element_type

10484: --
10485: if g_dyndbi_changes_ok then
10486: pay_dyndbi_changes_pkg.delete_rows
10487: (p_id => l_id
10488: ,p_type => pay_dyndbi_changes_pkg.c_element_type
10489: );
10490: end if;
10491:
10492: if l_debug then

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

10489: );
10490: end if;
10491:
10492: if l_debug then
10493: hr_utility.set_location('process_pay_dyndbi_changes', 80);
10494: end if;
10495:
10496: incr_cnt(p_cnt => l_cnt);
10497: end loop;

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

10502: commit;
10503: end if;
10504:
10505: if l_debug then
10506: hr_utility.set_location('process_pay_dyndbi_changes', 90);
10507: end if;
10508:
10509: -- ============= --
10510: -- Input Values. --

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

10511: -- ============= --
10512: if upper(p_input_values) = 'Y' then
10513:
10514: if l_debug then
10515: hr_utility.set_location('process_pay_dyndbi_changes', 100);
10516: end if;
10517:
10518: --
10519: -- Initialise everything.

Line 10526: -- Fetch the PAY_DYNDBI_CHANGES rows.

10522: l_languages.delete;
10523: i := 1;
10524:
10525: --
10526: -- Fetch the PAY_DYNDBI_CHANGES rows.
10527: --
10528: fetch_dyndbi_changes
10529: (p_type => pay_dyndbi_changes_pkg.c_input_value
10530: ,p_ids => l_ids

Line 10529: (p_type => pay_dyndbi_changes_pkg.c_input_value

10525: --
10526: -- Fetch the PAY_DYNDBI_CHANGES rows.
10527: --
10528: fetch_dyndbi_changes
10529: (p_type => pay_dyndbi_changes_pkg.c_input_value
10530: ,p_ids => l_ids
10531: ,p_languages => l_languages
10532: );
10533:

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

10531: ,p_languages => l_languages
10532: );
10533:
10534: if l_debug then
10535: hr_utility.set_location('process_pay_dyndbi_changes', 110);
10536: end if;
10537:
10538: --
10539: -- Do the updates.

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

10542:
10543: while l_ids.exists(i) loop
10544:
10545: if l_debug then
10546: hr_utility.set_location('process_pay_dyndbi_changes', 120);
10547: end if;
10548:
10549: l_id_langs.delete;
10550: next_dyndbi_change

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

10565: l_found := csr_ipv_eff_date%found;
10566: close csr_ipv_eff_date;
10567:
10568: if l_debug then
10569: hr_utility.set_location('process_pay_dyndbi_changes', 130);
10570: end if;
10571:
10572: g_dyndbi_changes_ok := true;
10573: if l_found then

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

10589: hr_utility.trace(l_proc||'no such input value '||l_id);
10590: end if;
10591:
10592: if l_debug then
10593: hr_utility.set_location('process_pay_dyndbi_changes', 140);
10594: end if;
10595:
10596: --
10597: -- Delete the PAY_DYNDBI_CHANGES rows.

Line 10597: -- Delete the PAY_DYNDBI_CHANGES rows.

10593: hr_utility.set_location('process_pay_dyndbi_changes', 140);
10594: end if;
10595:
10596: --
10597: -- Delete the PAY_DYNDBI_CHANGES rows.
10598: --
10599: if g_dyndbi_changes_ok then
10600: pay_dyndbi_changes_pkg.delete_rows
10601: (p_id => l_id

Line 10600: pay_dyndbi_changes_pkg.delete_rows

10596: --
10597: -- Delete the PAY_DYNDBI_CHANGES rows.
10598: --
10599: if g_dyndbi_changes_ok then
10600: pay_dyndbi_changes_pkg.delete_rows
10601: (p_id => l_id
10602: ,p_type => pay_dyndbi_changes_pkg.c_input_value
10603: );
10604: end if;

Line 10602: ,p_type => pay_dyndbi_changes_pkg.c_input_value

10598: --
10599: if g_dyndbi_changes_ok then
10600: pay_dyndbi_changes_pkg.delete_rows
10601: (p_id => l_id
10602: ,p_type => pay_dyndbi_changes_pkg.c_input_value
10603: );
10604: end if;
10605:
10606: if l_debug then

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

10603: );
10604: end if;
10605:
10606: if l_debug then
10607: hr_utility.set_location('process_pay_dyndbi_changes', 150);
10608: end if;
10609:
10610: incr_cnt(p_cnt => l_cnt);
10611: end loop;

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

10616: commit;
10617: end if;
10618:
10619: if l_debug then
10620: hr_utility.set_location('process_pay_dyndbi_changes', 160);
10621: end if;
10622:
10623: -- ================= --
10624: -- Defined Balances. --

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

10625: -- ================= --
10626: if upper(p_defined_balances) = 'Y' then
10627:
10628: if l_debug then
10629: hr_utility.set_location('process_pay_dyndbi_changes', 170);
10630: end if;
10631:
10632: --
10633: -- Initialise everything.

Line 10640: -- Fetch the PAY_DYNDBI_CHANGES rows.

10636: l_languages.delete;
10637: i := 1;
10638:
10639: --
10640: -- Fetch the PAY_DYNDBI_CHANGES rows.
10641: --
10642: fetch_dyndbi_changes
10643: (p_type => pay_dyndbi_changes_pkg.c_defined_balance
10644: ,p_ids => l_ids

Line 10643: (p_type => pay_dyndbi_changes_pkg.c_defined_balance

10639: --
10640: -- Fetch the PAY_DYNDBI_CHANGES rows.
10641: --
10642: fetch_dyndbi_changes
10643: (p_type => pay_dyndbi_changes_pkg.c_defined_balance
10644: ,p_ids => l_ids
10645: ,p_languages => l_languages
10646: );
10647:

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

10645: ,p_languages => l_languages
10646: );
10647:
10648: if l_debug then
10649: hr_utility.set_location('process_pay_dyndbi_changes', 180);
10650: end if;
10651:
10652: --
10653: -- Do the updates.

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

10656:
10657: while l_ids.exists(i) loop
10658:
10659: if l_debug then
10660: hr_utility.set_location('process_pay_dyndbi_changes', 190);
10661: end if;
10662:
10663: l_id_langs.delete;
10664: next_dyndbi_change

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

10676: l_found := csr_def_balance%found;
10677: close csr_def_balance;
10678:
10679: if l_debug then
10680: hr_utility.set_location('process_pay_dyndbi_changes', 200);
10681: end if;
10682:
10683: g_dyndbi_changes_ok := true;
10684: if l_found then

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

10683: g_dyndbi_changes_ok := true;
10684: if l_found then
10685:
10686: if l_debug then
10687: hr_utility.set_location('process_pay_dyndbi_changes', 210);
10688: end if;
10689:
10690: begin
10691: update_defined_balance

Line 10708: -- Delete the PAY_DYNDBI_CHANGES rows.

10704: hr_utility.trace(l_proc||'no defined balance '||l_id);
10705: end if;
10706:
10707: --
10708: -- Delete the PAY_DYNDBI_CHANGES rows.
10709: --
10710: if g_dyndbi_changes_ok then
10711: pay_dyndbi_changes_pkg.delete_rows
10712: (p_id => l_id

Line 10711: pay_dyndbi_changes_pkg.delete_rows

10707: --
10708: -- Delete the PAY_DYNDBI_CHANGES rows.
10709: --
10710: if g_dyndbi_changes_ok then
10711: pay_dyndbi_changes_pkg.delete_rows
10712: (p_id => l_id
10713: ,p_type => pay_dyndbi_changes_pkg.c_defined_balance
10714: );
10715: end if;

Line 10713: ,p_type => pay_dyndbi_changes_pkg.c_defined_balance

10709: --
10710: if g_dyndbi_changes_ok then
10711: pay_dyndbi_changes_pkg.delete_rows
10712: (p_id => l_id
10713: ,p_type => pay_dyndbi_changes_pkg.c_defined_balance
10714: );
10715: end if;
10716:
10717: if l_debug then

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

10714: );
10715: end if;
10716:
10717: if l_debug then
10718: hr_utility.set_location('process_pay_dyndbi_changes', 220);
10719: end if;
10720:
10721: incr_cnt(p_cnt => l_cnt);
10722: end loop;

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

10727: commit;
10728: end if;
10729:
10730: if l_debug then
10731: hr_utility.set_location('process_pay_dyndbi_changes', 230);
10732: end if;
10733:
10734: --
10735: -- Do the legislation-specfic changes.

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

10736: --
10737: if upper(p_localization) = 'Y' then
10738:
10739: if l_debug then
10740: hr_utility.set_location('process_pay_dyndbi_changes', 235);
10741: end if;
10742:
10743: process_leg_translations(p_errors => l_errors);
10744: for i in 1 .. l_errors.count loop

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

10755: ,p_messages => l_messages
10756: );
10757:
10758: if l_debug then
10759: hr_utility.set_location('process_pay_dyndbi_changes', 240);
10760: end if;
10761:
10762: --
10763: -- Set error status if there are any error messages.

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

10788:
10789: g_dyndbi_changes := false;
10790:
10791: if l_debug then
10792: hr_utility.set_location('process_pay_dyndbi_changes', 250);
10793: end if;
10794:
10795: commit; /*Bug 8512762 Added commit as FND is not commiting if status is error (retcode =2 )*/
10796:

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

10800: errbuf := sqlerrm;
10801: retcode := 2;
10802:
10803: if l_debug then
10804: hr_utility.set_location('process_pay_dyndbi_changes', 300);
10805: end if;
10806: end process_pay_dyndbi_changes;
10807:
10808: end hrdyndbi;

Line 10806: end process_pay_dyndbi_changes;

10802:
10803: if l_debug then
10804: hr_utility.set_location('process_pay_dyndbi_changes', 300);
10805: end if;
10806: end process_pay_dyndbi_changes;
10807:
10808: end hrdyndbi;