1 PACKAGE pay_in_utils AS
2 /* $Header: pyinutil.pkh 120.15 2008/01/12 17:13:41 lnagaraj noship $ */
3
4 TYPE char_tab_type IS TABLE OF VARCHAR2(255) INDEX BY BINARY_INTEGER;
5
6 ----------------------------------------------------------------------------
7 -- --
8 -- Name : GET_MAX_ACT_SEQUENCE --
9 -- Type : Function --
10 -- Access : Public --
11 -- Description : This function returns the maximum action sequence --
12 -- for a given assignment id and process type --
13 -- Parameters : --
14 -- IN : p_assignment_id NUMBER --
15 -- p_process_type VARCHAR2 --
16 -- p_effective_date DATE --
17 -- --
18 ---------------------------------------------------------------------------
19 FUNCTION get_max_act_sequence (p_assignment_id IN NUMBER
20 ,p_process_type IN VARCHAR2
21 ,p_effective_date IN DATE
22 )
23 RETURN NUMBER;
24
25
26 ----------------------------------------------------------------------------
27 -- --
28 -- Name : SET_LOCATION --
29 -- Type : PROCEDURE --
30 -- Access : Public --
31 -- Description : Procedure to set the location based on the trace --
32 -- --
33 -- Parameters : --
34 -- IN : p_message varchar2 --
35 -- p_step number --
36 -- p_trace varchar2 --
37 -- --
38 ---------------------------------------------------------------------------
39 PROCEDURE set_location (p_trace IN BOOLEAN
40 ,p_message IN VARCHAR2
41 ,p_step IN INTEGER
42 );
43
44 --------------------------------------------------------------------------
45 -- --
46 -- Name : TRACE --
47 -- Type : PROCEDURE --
48 -- Access : Public --
49 -- Description : Procedure to set the trace --
50 -- --
51 -- Parameters : --
52 -- IN : p_message varchar2 --
53 -- p_value varchar2 --
54 -- --
55 ---------------------------------------------------------------------------
56 PROCEDURE trace (p_message IN VARCHAR2
57 ,p_value IN VARCHAR2);
58
59
60 --------------------------------------------------------------------------
61 -- --
62 -- Name : TRACE --
63 -- Type : Function --
64 -- Access : Public --
65 -- Description : Function to set the trace in Fast formulas --
66 -- --
67 -- Parameters : --
68 -- IN : p_message varchar2 --
69 -- p_value varchar2 --
70 -- --
71 ---------------------------------------------------------------------------
72 FUNCTION trace (p_message IN VARCHAR2
73 ,p_value IN VARCHAR2) RETURN NUMBER ;
74
75 --------------------------------------------------------------------------
76 -- --
77 -- Name : GET_PAY_MESSAGE --
78 -- Type : FUNCTION --
79 -- Access : Public --
80 -- Description : Function to construct the message for FF --
81 -- --
82 -- Parameters : --
83 -- IN : p_message_name VARCHAR2 --
84 -- p_token1 VARCHAR2 --
85 -- p_token2 VARCHAR2 --
86 -- p_token3 VARCHAR2 --
87 -- p_token4 VARCHAR2 --
88 -- RETURN : VARCHAR2 --
89 ---------------------------------------------------------------------------
90 FUNCTION get_pay_message
91 (p_message_name IN VARCHAR2
92 ,p_token1 IN VARCHAR2 DEFAULT NULL
93 ,p_token2 IN VARCHAR2 DEFAULT NULL
94 ,p_token3 IN VARCHAR2 DEFAULT NULL
95 ,p_token4 IN VARCHAR2 DEFAULT NULL
96 )
97 RETURN VARCHAR2;
98
99 --------------------------------------------------------------------------
100 -- --
101 -- Name : NULL_MESSAGE --
102 -- Type : PROCEDURE --
103 -- Access : Public --
104 -- Description : Function to null the messages --
105 -- Parameters : --
106 --------------------------------------------------------------------------
107 PROCEDURE null_message
108 (p_token_name IN OUT NOCOPY pay_in_utils.char_tab_type
109 ,p_token_value IN OUT NOCOPY pay_in_utils.char_tab_type);
110
111 --------------------------------------------------------------------------
112 -- --
113 -- Name : RAISE_MESSAGE --
114 -- Type : PROCEDURE --
115 -- Access : Public --
116 -- Description : Function to set and raise the messages --
117 -- Parameters : --
118 --------------------------------------------------------------------------
119 PROCEDURE raise_message
120 (p_application_id IN NUMBER
121 ,p_message_name IN VARCHAR2
122 ,p_token_name IN OUT NOCOPY pay_in_utils.char_tab_type
123 ,p_token_value IN OUT NOCOPY pay_in_utils.char_tab_type);
124 --------------------------------------------------------------------------
125 -- --
126 -- Name : GET_USER_TABLE_VALUE --
127 -- Type : FUNCTION --
128 -- Access : Public --
129 -- Description : Function to fetch the user table value --
130 -- --
131 -- Parameters : --
132 -- IN : p_business_group_id NUMBER --
133 -- p_table_name VARCHAR2 --
134 -- p_column_name VARCHAR2 --
135 -- p_row_name VARCHAR2 --
136 -- p_row_value VARCHAR2 --
137 -- RETURN : VARCHAR2 --
138 -- OUT : p_message VARCHAR2 --
139 -- --
140 ---------------------------------------------------------------------------
141 FUNCTION get_user_table_value
142 (p_business_group_id IN NUMBER
143 ,p_table_name IN VARCHAR2
144 ,p_column_name IN VARCHAR2
145 ,p_row_name IN VARCHAR2
146 ,p_row_value IN VARCHAR2
147 ,p_effective_date IN DATE
148 ,p_message OUT NOCOPY VARCHAR2
149 )
150 RETURN VARCHAR2;
151
152
153 --------------------------------------------------------------------------
154 -- --
155 -- Name : GET_RUN_TYPE_NAME --
156 -- Type : FUNCTION --
157 -- Access : Public --
158 -- Description : Function to fetch the run type name --
159 -- --
160 -- Parameters : --
161 -- IN : p_payroll_action_id --
162 -- RETURN : VARCHAR2 --
163 -- --
164 -- --
165 --------------------------------------------------------------------------
166 FUNCTION get_run_type_name (p_payroll_action_id IN NUMBER,
167 p_assignment_action_id IN NUMBER)
168 RETURN VARCHAR2;
169
170 --------------------------------------------------------------------------
171 -- --
172 -- Name : GET_PERSON_ID --
173 -- Type : FUNCTION --
174 -- Access : Public --
175 -- Description : Function returns the person_id of the assignment --
176 -- as of effective date. IF effective date is null --
177 -- then details are retrieved as of sysdate. --
178 -- --
179 -- Parameters : --
180 -- IN : p_assignment_id NUMBER --
181 -- p_effective_date DATE --
182 -- --
183 --------------------------------------------------------------------------
184 FUNCTION get_person_id
185 (p_assignment_id IN per_assignments_f.assignment_id%TYPE
186 ,p_effective_date IN DATE default null)
187 RETURN per_assignments_f.person_id%TYPE;
188
189 --------------------------------------------------------------------------
190 -- --
191 -- Name : NEXT_TAX_YEAR --
192 -- Type : FUNCTION --
193 -- Access : Public --
194 -- Description : Function returns the beginning of the next finan- --
195 -- cial year calculated based of the p_date input. --
196 -- --
197 -- Parameters : --
198 -- IN : p_date DATE --
199 -- --
200 --------------------------------------------------------------------------
201 FUNCTION next_tax_year(p_date IN DATE)
202 RETURN DATE;
203
204 --------------------------------------------------------------------------
205 -- --
206 -- Name : GET_EFFECTIVE_DATE --
207 -- Type : FUNCTION --
208 -- Access : Public --
209 -- Description : Function returns the calculates the effective date --
210 -- based on the following conditions: --
211 -- 1) If effective date is passed returns the same --
212 -- 2) Else use the System date. --
213 -- --
214 -- Parameters : --
215 -- IN : p_effective_date DATE --
216 -- --
217 --------------------------------------------------------------------------
218 FUNCTION get_effective_date(p_effective_date IN DATE)
219 RETURN DATE;
220
221 --------------------------------------------------------------------------
222 -- --
223 -- Name : GET_ASSIGNMENT_ID --
224 -- Type : FUNCTION --
225 -- Access : Public --
226 -- Description : Function returns the assignment_if of the person --
227 -- as of effective date. IF effective date is null --
228 -- then details are retrieved as of sysdate. --
229 -- --
230 -- Parameters : --
231 -- IN : p_person_id NUMBER --
232 -- p_effective_date DATE --
233 -- --
234 --------------------------------------------------------------------------
235 FUNCTION get_assignment_id
236 (p_person_id IN per_people_f.person_id%TYPE
237 ,p_effective_date IN DATE default null)
238 RETURN per_assignments_f.assignment_id%TYPE;
239
240 -------------------------------------------------------------------------
241 -- --
242 -- Name : validate_dates --
243 -- Type : FUNCTION --
244 -- Access : Public --
245 -- Description : This function checks if the effective end date is --
246 -- greater than or equal to effective start date . --
247 -- Parameters : --
248 -- IN : p_effective_start_date IN DATE --
249 -- p_effective_end_date IN DATE --
250 -- RETURN : BOOLEAN --
251 --------------------------------------------------------------------------
252 FUNCTION validate_dates(p_start_date IN DATE,
253 p_end_date IN DATE)
254 RETURN BOOLEAN;
255
256 -------------------------------------------------------------------------
257 -- --
258 -- Name : chk_org_class --
259 -- Type : FUNCTION --
260 -- Access : Public --
261 -- Description : This function checks if the organization passed has --
262 -- the classification enabled --
263 -- Parameters : --
264 -- IN : p_effective_start_date IN DATE --
265 -- p_effective_end_date IN DATE --
266 -- RETURN : BOOLEAN --
267 --------------------------------------------------------------------------
268 FUNCTION chk_org_class(p_organization_id IN NUMBER,
269 p_org_class IN VARCHAR2)
270 RETURN BOOLEAN;
271
272
273 -------------------------------------------------------------------------
274 -- --
275 -- Name : number_to_words --
276 -- Type : FUNCTION --
277 -- Access : Public --
278 -- Description : This function returns the number passed to the --
279 -- function in words. --
280 -- Parameters : --
281 -- IN : p_value IN NUMBER --
282 -- RETURN : VARCHAR2 --
283 --------------------------------------------------------------------------
284 FUNCTION number_to_words ( p_value IN number)
285 RETURN VARCHAR2;
286
287 -------------------------------------------------------------------------
288 -- --
289 -- Name : encode_html_string --
290 -- Type : FUNCTION --
291 -- Access : Public --
292 -- Description : This procedure encodes the HTML literals. --
293 -- --
294 -- Parameters : --
295 -- IN : p_value IN NUMBER --
296 -- RETURN : VARCHAR2 --
297 --------------------------------------------------------------------------
298 -- Change History : --
299 --------------------------------------------------------------------------
300 -- Rev# Date Userid Bug Description --
301 --------------------------------------------------------------------------
302 -- 1.0 22/12/04 aaagarwa 4070869 Created this function --
303 --------------------------------------------------------------------------
304
305 FUNCTION encode_html_string(p_value IN VARCHAR2)
306 RETURN VARCHAR2;
307
308
309 --------------------------------------------------------------------------
310 -- --
311 -- Name : GET_SCL_SEGMENT_ON_DATE --
312 -- Type : Function --
313 -- Access : Public --
314 -- Description : Returns --
315 -- Parameters : --
316 -- IN : p_assigment_id VARCHAR2 --
317 -- : p_business_group_id NUMBER --
321 -- RETURN : VARCHAR2 --
318 -- : p_date DATE --
319 -- : p_column VARCHAR2 --
320 -- OUT : N/A --
322 -- --
323 --------------------------------------------------------------------------
324
325
326 FUNCTION get_scl_segment_on_date(p_assignment_id IN NUMBER
327 ,p_business_group_id IN NUMBER
328 ,p_date IN DATE
329 ,p_column IN VARCHAR2)
330 RETURN VARCHAR2 ;
331
332
333
334 -------------------------------------------------------------------------
335 -- --
336 -- Name : chk_element_link --
337 -- Type : FUNCTION --
338 -- Access : Public --
339 -- Description : This function checks if an assignment is eligible --
340 -- for an element as on a given date --
341 -- Parameters : --
342 -- IN : p_element_name VARCHAR2 --
343 -- p_assignment_id NUMBER --
344 -- p_effective_date DATE --
345 -- OUT : p_element_link_id NUMBER --
346 -- RETURN : VARCHAR2 --
347 -- Change History : --
348 --------------------------------------------------------------------------
349 -- Rev# Date Userid Description --
350 --------------------------------------------------------------------------
351 -- 1.0 27/12/04 lnagaraj Created this function --
352 --------------------------------------------------------------------------
353 FUNCTION chk_element_link(p_element_name IN VARCHAR2
354 ,p_assignment_id IN NUMBER
355 ,p_effective_date IN DATE
356 ,p_element_link_id OUT NOCOPY NUMBER)
357 RETURN VARCHAR2;
358
359 -------------------------------------------------------------------------
360 -- --
361 -- Name : get_element_link_id --
362 -- Type : FUNCTION --
363 -- Access : Public --
364 -- Description : This function returns element link id for an --
365 -- assignment for an element as on a given date --
366 -- Parameters : --
367 -- IN : p_assignment_id NUMBER --
368 -- p_effective_date DATE --
369 -- p_element_type_id NUMBER --
370 -- RETURN : NUMBER --
371 -- Change History : --
372 --------------------------------------------------------------------------
373 -- Rev# Date Userid Description --
374 --------------------------------------------------------------------------
375 -- 1.0 06/12/05 aaagarwa Created this function --
376 --------------------------------------------------------------------------
377 FUNCTION get_element_link_id(p_assignment_id IN NUMBER
378 ,p_effective_date IN DATE
379 ,p_element_type_id IN NUMBER
380 )
381 RETURN NUMBER;
382 --------------------------------------------------------------------------
383 -- --
384 -- Name : GET_EE_VALUE --
385 -- Type : FUNCTION --
386 -- Access : Public --
387 -- Description : Function to return the element entry value --
388 -- --
389 -- Parameters : --
390 -- IN : p_element_entry_id NUMBER --
391 -- p_input_name VARCHAR2 --
392 -- p_effective_date DATE --
393 -- RETURN : VARCHAR2 --
394 ---------------------------------------------------------------------------
395 FUNCTION get_ee_value
396 (p_element_entry_id IN NUMBER
397 ,p_input_name IN VARCHAR2
398 ,p_effective_date IN DATE
399 )
400 RETURN VARCHAR2;
401
402 --------------------------------------------------------------------------
403 -- --
404 -- Name : GET_EE_VALUE --
405 -- Type : FUNCTION --
406 -- Access : Public --
407 -- Description : Function to return the element entry value --
411 -- p_input_name VARCHAR2 --
408 -- --
409 -- Parameters : --
410 -- IN : p_element_entry_id NUMBER --
412 -- p_effective_date DATE --
413 -- RETURN : VARCHAR2 --
414 ---------------------------------------------------------------------------
415 FUNCTION get_ee_value
416 (p_element_entry_id IN NUMBER
417 ,p_input_name IN VARCHAR2
418 )
419 RETURN VARCHAR2;
420 --------------------------------------------------------------------------
421 -- --
422 -- Name : GET_ACTION_TYPE --
423 -- Type : FUNCTION --
424 -- Access : Public --
425 -- Description : Function to return the action_type of an asact_id --
426 -- --
427 -- Parameters : --
428 -- IN : p_assignment_action_id NUMBER --
429 -- RETURN : VARCHAR2 --
430 ---------------------------------------------------------------------------
431 FUNCTION get_action_type
432 (p_assignment_action_id IN NUMBER
433 )
434 RETURN VARCHAR2;
435
436 --------------------------------------------------------------------------
437 -- --
438 -- Name : GET_TAX_UNIT_ID --
439 -- Type : FUNCTION --
440 -- Access : Public --
441 -- Description : Function to return the tax unit id for an assignment--
442 -- --
443 -- Parameters : --
444 -- IN : p_assignment_id NUMBER --
445 -- p_effective_date DATE --
446 -- RETURN : VARCHAR2 --
447 ---------------------------------------------------------------------------
448 FUNCTION get_tax_unit_id
449 (p_assignment_id IN NUMBER
450 ,p_effective_date DATE
451 )
452 RETURN VARCHAR2;
453
454 --------------------------------------------------------------------------
455 -- Name : GET_FORMULA_ID --
456 -- Type : FUNCTION --
457 -- Access : Public --
458 -- Description : Function to fetch the formula_id --
459 -- Parameters : --
460 -- IN : p_effective_date DATE --
461 -- : p_formula_name VARCHAR2 --
462 -- OUT : N/A --
463 -- RETURN : Number --
464 --------------------------------------------------------------------------
465 FUNCTION get_formula_id
466 (p_effective_date IN DATE
467 ,p_formula_name IN VARCHAR2
468 )
469 RETURN NUMBER ;
470
471 --------------------------------------------------------------------------
472 -- Name : GET_ELEMENT_TYPE_ID --
473 -- Type : FUNCTION --
474 -- Access : Public --
475 -- Description : Function to fetch the element_type_id --
476 -- Parameters : --
477 -- IN : p_effective_date DATE --
478 -- : p_element_name VARCHAR2 --
479 -- OUT : N/A --
480 -- RETURN : Number --
481 --------------------------------------------------------------------------
482 FUNCTION get_element_type_id
483 (p_effective_date IN DATE
484 ,p_element_name IN VARCHAR2
485 )
486 RETURN NUMBER ;
487
488 --------------------------------------------------------------------------
489 -- Name : GET_BALANCE_TYPE_ID --
490 -- Type : FUNCTION --
491 -- Access : Public --
492 -- Description : Function to fetch the balance_type_id --
493 -- Parameters : --
494 -- IN : p_balance_name VARCHAR2 --
495 -- OUT : N/A --
496 -- RETURN : Number --
497 --------------------------------------------------------------------------
498 FUNCTION get_balance_type_id
499 (p_balance_name IN VARCHAR2
500 )
501 RETURN NUMBER;
502
503 --------------------------------------------------------------------------
507 -- Description : Function to fetch the input_value_id --
504 -- Name : GET_INPUT_VALUE_ID --
505 -- Type : FUNCTION --
506 -- Access : Public --
508 -- Parameters : --
509 -- IN : p_effective_date DATE --
510 -- : p_element_id NUMBER --
511 -- : p_input_value VARCHAR2 --
512 -- OUT : N/A --
513 -- RETURN : Number --
514 --------------------------------------------------------------------------
515 FUNCTION get_input_value_id
516 (p_effective_date IN DATE
517 ,p_element_id IN NUMBER
518 ,p_input_value IN VARCHAR2
519 )
520 RETURN NUMBER ;
521
522 --------------------------------------------------------------------------
523 -- Name : GET_INPUT_VALUE_ID --
524 -- Type : FUNCTION --
525 -- Access : Public --
526 -- Description : Function to fetch the input_value_id --
527 -- Parameters : --
528 -- IN : p_effective_date DATE --
529 -- : p_element_id NUMBER --
530 -- : p_input_value VARCHAR2 --
531 -- OUT : N/A --
532 -- RETURN : Number --
533 --------------------------------------------------------------------------
534 FUNCTION get_input_value_id
535 (p_effective_date IN DATE
536 ,p_element_name IN VARCHAR2
537 ,p_input_value IN VARCHAR2
538 )
539 RETURN NUMBER ;
540
541 --------------------------------------------------------------------------
542 -- Name : GET_TEMPLATE_ID --
543 -- Type : FUNCTION --
544 -- Access : Private --
545 -- Description : Procedure to fetch the template_id --
546 -- Parameters : --
547 -- IN : p_template_name VARCHAR2 --
548 -- OUT : p_template_id NUMBER --
549 -- RETURN : N/A --
550 --------------------------------------------------------------------------
551 FUNCTION get_template_id
552 (p_template_name IN VARCHAR2
553 )
554 RETURN NUMBER ;
555
556 --------------------------------------------------------------------------
557 -- Name : GET_PERSON_NAME --
558 -- Type : FUNCTION --
559 -- Access : Private --
560 -- Description : Function to fetch the person name based on person id--
561 -- Parameters : --
562 -- IN : p_person_id IN NUMBER --
563 -- : p_effective_date IN DATE --
564 -- RETURN : VARCHAR2 --
565 --------------------------------------------------------------------------
566 FUNCTION get_person_name
567 (p_person_id IN NUMBER
568 ,p_effective_date IN DATE
569 )
570 RETURN VARCHAR2;
571
572 --------------------------------------------------------------------------
573 -- Name : GET_ORGANIZATION_NAME --
574 -- Type : FUNCTION --
575 -- Access : Private --
576 -- Description : Function to fetch the organization name --
577 -- Parameters : --
578 -- IN : p_organization_id IN NUMBER --
579 -- RETURN : VARCHAR2 --
580 --------------------------------------------------------------------------
581 FUNCTION get_organization_name
582 (p_organization_id IN NUMBER
583 )
584 RETURN VARCHAR2;
585
586 --------------------------------------------------------------------------
587 -- Name : GET_PAYMENT_NAME --
588 -- Type : FUNCTION --
589 -- Access : Private --
590 -- Description : Function to fetch the payment method name --
591 -- Parameters : --
592 -- IN : p_payment_type_id IN NUMBER --
593 -- RETURN : VARCHAR2 --
594 --------------------------------------------------------------------------
595 FUNCTION get_payment_name
596 (p_payment_type_id IN NUMBER
597 )
598 RETURN VARCHAR2;
599
600 --------------------------------------------------------------------------
604 -- Description : Function to fetch the bank name --
601 -- Name : GET_BANK_NAME --
602 -- Type : FUNCTION --
603 -- Access : Private --
605 -- Parameters : --
606 -- IN : p_org_information_id IN NUMBER --
607 -- RETURN : VARCHAR2 --
608 --------------------------------------------------------------------------
609 FUNCTION get_bank_name
610 (p_org_information_id IN NUMBER
611 )
612 RETURN VARCHAR2;
613
614 --------------------------------------------------------------------------
615 -- Name : GET_ARCHIVE_REF_NUM --
616 -- Type : FUNCTION --
617 -- Access : Private --
618 -- Description : Function to fetch the form 24Q or 24QC ref number. --
619 -- Parameters : --
620 -- IN : p_year IN VARCHAR2 --
621 -- : p_quarter IN VARCHAR2 --
622 -- : p_return_type IN VARCHAR2 --
623 -- : p_organization_id IN NUMBER --
624 -- : p_action_context_id IN NUMBER --
625 -- RETURN : VARCHAR2 --
626 --------------------------------------------------------------------------
627 FUNCTION get_archive_ref_num
628 (p_year IN VARCHAR2,
629 p_quarter IN VARCHAR2,
630 p_return_type IN VARCHAR2,
631 p_organization_id IN NUMBER,
632 p_action_context_id IN NUMBER
633 )
634 RETURN VARCHAR2;
635
636 --------------------------------------------------------------------------
637 -- Name : GET_ADDR_DFF_DETAILS --
638 -- Type : FUNCTION --
639 -- Access : Private --
640 -- Description : Function to fetch the segments of 'Personal Address --
641 -- : ' Information' DFF for IN localization. --
642 -- Parameters : --
643 -- IN : p_address_id IN NUMBER --
644 -- : p_segment_no IN VARCHAR2 --
645 -- RETURN : VARCHAR2 --
646 --------------------------------------------------------------------------
647 FUNCTION get_addr_dff_details
648 (p_address_id IN NUMBER
649 ,p_segment_no IN VARCHAR2
650 )
651 RETURN VARCHAR2;
652
653
654 --------------------------------------------------------------------------
655 -- Name : get_processing_type --
656 -- Type : Function --
657 -- Access : Public --
658 -- Description : Function to get processing type --
659 -- (Non-recurring/Recurring) of an element --
660 -- Parameters : --
661 -- IN : p_element_type_id NUMBER --
662 -- p_business_group_id NUMBER --
663 -- p_earned_date DATE --
664 --------------------------------------------------------------------------
665 FUNCTION get_processing_type
666 (p_element_type_id IN NUMBER
667 ,p_business_group_id IN NUMBER
668 ,p_earned_date IN DATE
669 )
670 RETURN VARCHAR;
671
672 --------------------------------------------------------------------------
673 -- Name : chk_business_group --
674 -- Type : FUNCTION --
675 -- Access : Public --
676 -- Description : Function to check the business group as per the --
677 -- : profile value. --
678 -- Parameters : --
679 -- IN : p_assignment_id IN NUMBER --
680 -- RETURN : VARCHAR2 --
681 --------------------------------------------------------------------------
682 FUNCTION chk_business_group
683 (p_assignment_id IN NUMBER
684 )
685 RETURN NUMBER;
686
687 --------------------------------------------------------------------------
688 -- Name : INS_FORM_RES_RULE --
689 -- Type : PROCEDURE --
690 -- Access : Private --
691 -- Description : Procedure to update element details in post-process --
692 -- Parameters : --
693 -- IN : p_business_group_id NUMBER --
697 -- : p_result_rule_type VARCHAR2 --
694 -- : p_effective_date DATE --
695 -- : p_status_processing_rule_id NUMBER --
696 -- : p_result_name VARCHAR2 --
698 -- : p_element_name VARCHAR2 --
699 -- : p_input_value_name VARCHAR2 --
700 -- : p_severity_level VARCHAR2 --
701 -- : p_element_type_id NUMBER --
702 -- OUT : N/A --
703 -- RETURN : N/A --
704 --------------------------------------------------------------------------
705 PROCEDURE ins_form_res_rule
706 (
707 p_business_group_id NUMBER,
708 p_effective_date DATE ,
709 p_status_processing_rule_id NUMBER,
710 p_result_name VARCHAR2,
711 p_result_rule_type VARCHAR2,
712 p_element_name VARCHAR2 DEFAULT NULL,
713 p_input_value_name VARCHAR2 DEFAULT NULL,
714 p_severity_level VARCHAR2 DEFAULT NULL,
715 p_element_type_id NUMBER DEFAULT NULL
716 );
717
718 --------------------------------------------------------------------------
719 -- Name : DEL_FORM_RES_RULE --
720 -- Type : PROCEDURE --
721 -- Access : Private --
722 -- Description : Procedure to delete formula setup for elements --
726 -- OUT : N/A --
723 -- Parameters : --
724 -- IN : p_element_type_id_id NUMBER --
725 -- : p_effective_date DATE --
727 -- RETURN : N/A --
728 --------------------------------------------------------------------------
729 PROCEDURE del_form_res_rule
730 (p_element_type_id IN NUMBER,
731 p_effective_date IN DATE
732 );
733
734 --------------------------------------------------------------------------
735 -- Name : DELETE_BALANCE_FEEDS --
736 -- Type : Procedure --
737 -- Access : Public --
738 -- Description : Procedure to fetch the template_id --
739 -- Parameters : --
740 -- IN : p_template_name VARCHAR2 --
741 -- OUT : p_template_id NUMBER --
742 -- RETURN : N/A --
743 --------------------------------------------------------------------------
744 PROCEDURE delete_balance_feeds
745 (p_balance_name IN VARCHAR2
746 ,p_element_name IN VARCHAR2
747 ,p_input_value_name IN VARCHAR2
748 ,p_effective_date IN DATE
749 );
750
751 --------------------------------------------------------------------------
752 -- Name : GET_SECONDARY_CLASSIFICATION --
753 -- Type : Procedure --
754 -- Access : Public --
755 -- Description : Procedure to fetch the secondary classification --
756 -- Parameters : --
757 -- IN : p_element_type_id NUMBER --
758 -- OUT : p_date_earned DATE --
759 -- RETURN : NUMBER --
760 --------------------------------------------------------------------------
761 FUNCTION get_secondary_classification
762 (p_element_type_id NUMBER
763 ,p_date_earned DATE
764 )
765 RETURN NUMBER;
766
767 --------------------------------------------------------------------------
768 -- Name : GET_CONFIGURATION_INFO --
769 -- Type : Procedure --
770 -- Access : Public --
771 -- Description : Procedure to fetch the configuartion information --
772 -- Parameters : --
773 -- IN : p_element_type_id NUMBER --
774 -- OUT : p_date_earned DATE --
775 -- RETURN : NUMBER --
776 --------------------------------------------------------------------------
777 FUNCTION get_configuration_info
778 (p_element_type_id NUMBER
779 ,p_date_earned DATE
780 )
781 RETURN VARCHAR2;
782 --------------------------------------------------------------------------
783 -- Name : GET_ELEMENT_ENTRY_END_DATE --
784 -- Type : Procedure --
785 -- Access : Public --
786 -- Description : Procedure to fetch the element entry date --
787 -- Parameters : --
788 -- IN : p_element_entry_id NUMBER --
789 -- RETURN : DATE --
790 --------------------------------------------------------------------------
791 FUNCTION get_element_entry_end_date
792 (p_element_entry_id NUMBER
793 )
794 RETURN DATE;
795 --------------------------------------------------------------------------
796 -- Name : GET_CONTACT_RELATIONSHIP --
797 -- Type : fUNCTION --
798 -- Access : Public --
799 -- Description : Gets the relationship between 2 persons --
800 -- Parameters : --
801 -- IN : p_asg_id NUMBER --
802 -- : p_contact_person_id NUMBER --
803 -- RETURN : VARCHAR2 --
804
805 --------------------------------------------------------------------------
806 FUNCTION get_contact_relationship
807 (p_asg_id NUMBER
808 ,p_contact_person_id NUMBER
809 )
810 RETURN VARCHAR2;
811 --------------------------------------------------------------------------
812 -- Name : GET_HIRE_DATE --
813 -- Type : fUNCTION --
814 -- Access : Public --
815 -- Description : Gets the hire date of an assignment --
816 -- Parameters : --
817 -- IN : p_assignment_id NUMBER --
818 -- RETURN : DATE --
819
820 --------------------------------------------------------------------------
821
822
823 FUNCTION get_hire_date(p_assignment_id NUMBER)
824 RETURN DATE;
825
829 -- Access : Public --
826 --------------------------------------------------------------------------
827 -- Name : GET_POSITION_NAME --
828 -- Type : fUNCTION --
830 -- Description : Gets the position --
831 -- Parameters : --
832 -- IN : p_assignment_id NUMBER --
833 -- : p_effective_date DATE --
834 -- RETURN : VARCHAR2 --
835
836 --------------------------------------------------------------------------
837
838 FUNCTION get_position_name
839 (p_assignment_id NUMBER
840 ,p_effective_date DATE
841 )
842 RETURN VARCHAR2;
843
844 --------------------------------------------------------------------------
845 -- Name : GET_AGE --
846 -- Type : fUNCTION --
847 -- Access : Public --
848 -- Description : Gets the age of a person as on a date --
849 -- Parameters : --
850 -- IN : p_person_id NUMBER --
851 -- : p_effective_date DATE --
852 -- RETURN : NUMBER --
853
854 --------------------------------------------------------------------------
855
856 FUNCTION get_age(p_person_id in number
857 ,p_effective_date in date)
858 RETURN NUMBER ;
859 --------------------------------------------------------------------------
860 -- Name : GET_LTC_BLOCK --
861 -- Type : fUNCTION --
862 -- Access : Public --
863 -- Description : Gets the current LTC Block --
864 -- Parameters : --
865 -- IN : p_effective_date DATE --
866 -- RETURN : VARCHAR2 --
867
868 --------------------------------------------------------------------------
869
870 FUNCTION get_ltc_block(p_effective_date in date)
871 RETURN VARCHAR2 ;
872 --------------------------------------------------------------------------
873 -- Name : GET_PREV_LTC_BLOCK --
874 -- Type : fUNCTION --
875 -- Access : Public --
876 -- Description : Gets the previous LTC Block --
877 -- Parameters : --
878 -- IN : p_effective_date DATE --
879 -- RETURN : VARCHAR2 --
880
881 --------------------------------------------------------------------------
882
883
884 FUNCTION get_prev_ltc_block(p_effective_date in date)
885 RETURN VARCHAR2 ;
886
887 END pay_in_utils;