[Home] [Help]
5187: hr_utility.trace('leaving truncate_fcomp_info');
5188: hrrbdeib_trace_off;
5189:
5190: else
5191: dbms_lock.sleep(5);
5192: end if;
5193:
5194: g_triggers_altered := TRUE;
5195: --
5202: -- disable delete triggers for these entities for performance.
5203: if p_worker_id = 0 then
5204: disable_ffue_cascade_trig;
5205: else
5206: dbms_lock.sleep(5);
5207: end if;
5208:
5209: --
5210: if (p_commit = 'Y') then
5239: and process_type = 'ZZ';
5240:
5241: exit when workers_complete = p_maxworkers;
5242:
5243: dbms_lock.sleep(5);
5244:
5245: end loop;
5246:
5247: if (p_commit = 'Y') then
5252: if p_worker_id = 0 then
5253: enable_ffue_cascade_trig;
5254: disable_refbal_trig;
5255: else
5256: dbms_lock.sleep(5);
5257: end if;
5258:
5259: --
5260: hrdyndbi.refresh_defined_balances(p_worker_id,
5290: and process_type = 'ZZ';
5291:
5292: exit when workers_complete = p_maxworkers;
5293:
5294: dbms_lock.sleep(5);
5295:
5296: end loop;
5297: --
5298: if (p_commit = 'Y') then
5303: if p_worker_id = 0 then
5304: enable_refbal_trig;
5305: disable_ffue_cascade_trig;
5306: else
5307: dbms_lock.sleep(5);
5308: end if;
5309:
5310: --
5311: --
5338: and process_type = 'ZZ';
5339:
5340: exit when workers_complete = p_maxworkers;
5341:
5342: dbms_lock.sleep(5);
5343:
5344: end loop;
5345:
5346: if (p_commit = 'Y') then
5350: -- re-enable delete triggers
5351: if p_worker_id = 0 then
5352: enable_ffue_cascade_trig;
5353: else
5354: dbms_lock.sleep(5);
5355: end if;
5356:
5357: --
5358: -- Create all input and element DB items:
5364: -- disable insert triggers for these entities for performance.
5365: if p_worker_id = 0 then
5366: disable_refbal_trig;
5367: else
5368: dbms_lock.sleep(5);
5369: end if;
5370:
5371: --
5372: hrdyndbi.refresh_element_types(p_worker_id,
5400: and process_type = 'ZZ';
5401:
5402: exit when workers_complete = p_maxworkers;
5403:
5404: dbms_lock.sleep(5);
5405:
5406: end loop;
5407: --
5408: -- Important. In order not to hang when we have selected more than
5418: -- re-enable insert triggers
5419: if p_worker_id = 0 then
5420: enable_refbal_trig;
5421: else
5422: dbms_lock.sleep(5);
5423: end if;
5424:
5425: --
5426: -- reset global
5667: and process_type = p_leg_code;
5668:
5669: exit when workers_complete = p_maxworkers;
5670:
5671: dbms_lock.sleep(5);
5672:
5673: end loop;
5674: --
5675: -- Create ALL DB items for defined balances in the account:
5677: -- disable insert triggers for these entities for performance.
5678: if p_worker_id = 0 then
5679: disable_refbal_trig;
5680: else
5681: dbms_lock.sleep(5);
5682: end if;
5683:
5684: --
5685: hrdyndbi.refresh_defined_balances(p_leg_code,
5715: and process_type = p_leg_code;
5716:
5717: exit when workers_complete = p_maxworkers;
5718:
5719: dbms_lock.sleep(5);
5720:
5721: end loop;
5722:
5723: if (p_commit = 'Y') then
5728: if p_worker_id = 0 then
5729: enable_refbal_trig;
5730: disable_ffue_cascade_trig;
5731: else
5732: dbms_lock.sleep(5);
5733: end if;
5734:
5735: --
5736: --
5763: and process_type = p_leg_code;
5764:
5765: exit when workers_complete = p_maxworkers;
5766:
5767: dbms_lock.sleep(5);
5768:
5769: end loop;
5770:
5771: if (p_commit = 'Y') then
5775: -- re-enable delete triggers
5776: if p_worker_id = 0 then
5777: enable_ffue_cascade_trig;
5778: else
5779: dbms_lock.sleep(5);
5780: end if;
5781:
5782: --
5783: -- Create all input and element DB items:
5790: -- disable insert triggers for these entities for performance.
5791: if p_worker_id = 0 then
5792: disable_refbal_trig;
5793: else
5794: dbms_lock.sleep(5);
5795: end if;
5796:
5797: --
5798: hrdyndbi.refresh_element_types(p_leg_code,
5829: and process_type = p_leg_code;
5830:
5831: exit when workers_complete = p_maxworkers;
5832:
5833: dbms_lock.sleep(5);
5834:
5835: end loop;
5836: --
5837: -- Important. In order not to hang when we have selected more than
5847: -- re-enable insert triggers
5848: if p_worker_id = 0 then
5849: enable_refbal_trig;
5850: else
5851: dbms_lock.sleep(5);
5852: end if;
5853:
5854: --
5855: -- reset global