5184: hr_utility.trace('leaving truncate_fcomp_info');
5185: hrrbdeib_trace_off;
5186:
5187: else
5188: dbms_lock.sleep(5);
5189: end if;
5190:
5191: g_triggers_altered := TRUE;
5192: --
5199: -- disable delete triggers for these entities for performance.
5200: if p_worker_id = 0 then
5201: disable_ffue_cascade_trig;
5202: else
5203: dbms_lock.sleep(5);
5204: end if;
5205:
5206: --
5207: if (p_commit = 'Y') then
5236: and process_type = 'ZZ';
5237:
5238: exit when workers_complete = p_maxworkers;
5239:
5240: dbms_lock.sleep(5);
5241:
5242: end loop;
5243:
5244: if (p_commit = 'Y') then
5249: if p_worker_id = 0 then
5250: enable_ffue_cascade_trig;
5251: disable_refbal_trig;
5252: else
5253: dbms_lock.sleep(5);
5254: end if;
5255:
5256: --
5257: hrdyndbi.refresh_defined_balances(p_worker_id,
5287: and process_type = 'ZZ';
5288:
5289: exit when workers_complete = p_maxworkers;
5290:
5291: dbms_lock.sleep(5);
5292:
5293: end loop;
5294: --
5295: if (p_commit = 'Y') then
5300: if p_worker_id = 0 then
5301: enable_refbal_trig;
5302: disable_ffue_cascade_trig;
5303: else
5304: dbms_lock.sleep(5);
5305: end if;
5306:
5307: --
5308: --
5335: and process_type = 'ZZ';
5336:
5337: exit when workers_complete = p_maxworkers;
5338:
5339: dbms_lock.sleep(5);
5340:
5341: end loop;
5342:
5343: if (p_commit = 'Y') then
5347: -- re-enable delete triggers
5348: if p_worker_id = 0 then
5349: enable_ffue_cascade_trig;
5350: else
5351: dbms_lock.sleep(5);
5352: end if;
5353:
5354: --
5355: -- Create all input and element DB items:
5361: -- disable insert triggers for these entities for performance.
5362: if p_worker_id = 0 then
5363: disable_refbal_trig;
5364: else
5365: dbms_lock.sleep(5);
5366: end if;
5367:
5368: --
5369: hrdyndbi.refresh_element_types(p_worker_id,
5397: and process_type = 'ZZ';
5398:
5399: exit when workers_complete = p_maxworkers;
5400:
5401: dbms_lock.sleep(5);
5402:
5403: end loop;
5404: --
5405: -- Important. In order not to hang when we have selected more than
5415: -- re-enable insert triggers
5416: if p_worker_id = 0 then
5417: enable_refbal_trig;
5418: else
5419: dbms_lock.sleep(5);
5420: end if;
5421:
5422: --
5423: -- reset global
5664: and process_type = p_leg_code;
5665:
5666: exit when workers_complete = p_maxworkers;
5667:
5668: dbms_lock.sleep(5);
5669:
5670: end loop;
5671: --
5672: -- Create ALL DB items for defined balances in the account:
5674: -- disable insert triggers for these entities for performance.
5675: if p_worker_id = 0 then
5676: disable_refbal_trig;
5677: else
5678: dbms_lock.sleep(5);
5679: end if;
5680:
5681: --
5682: hrdyndbi.refresh_defined_balances(p_leg_code,
5712: and process_type = p_leg_code;
5713:
5714: exit when workers_complete = p_maxworkers;
5715:
5716: dbms_lock.sleep(5);
5717:
5718: end loop;
5719:
5720: if (p_commit = 'Y') then
5725: if p_worker_id = 0 then
5726: enable_refbal_trig;
5727: disable_ffue_cascade_trig;
5728: else
5729: dbms_lock.sleep(5);
5730: end if;
5731:
5732: --
5733: --
5760: and process_type = p_leg_code;
5761:
5762: exit when workers_complete = p_maxworkers;
5763:
5764: dbms_lock.sleep(5);
5765:
5766: end loop;
5767:
5768: if (p_commit = 'Y') then
5772: -- re-enable delete triggers
5773: if p_worker_id = 0 then
5774: enable_ffue_cascade_trig;
5775: else
5776: dbms_lock.sleep(5);
5777: end if;
5778:
5779: --
5780: -- Create all input and element DB items:
5787: -- disable insert triggers for these entities for performance.
5788: if p_worker_id = 0 then
5789: disable_refbal_trig;
5790: else
5791: dbms_lock.sleep(5);
5792: end if;
5793:
5794: --
5795: hrdyndbi.refresh_element_types(p_leg_code,
5826: and process_type = p_leg_code;
5827:
5828: exit when workers_complete = p_maxworkers;
5829:
5830: dbms_lock.sleep(5);
5831:
5832: end loop;
5833: --
5834: -- Important. In order not to hang when we have selected more than
5844: -- re-enable insert triggers
5845: if p_worker_id = 0 then
5846: enable_refbal_trig;
5847: else
5848: dbms_lock.sleep(5);
5849: end if;
5850:
5851: --
5852: -- reset global