DBA Data[Home] [Help]

APPS.HR_JP_ID_PKG dependencies on HR_API

Line 79: p_effective_date IN DATE DEFAULT hr_api.g_sys,

75: FUNCTION element_type_rec(
76: p_element_name IN VARCHAR2,
77: p_business_group_id IN NUMBER DEFAULT NULL,
78: p_legislation_code IN VARCHAR2 DEFAULT NULL,
79: p_effective_date IN DATE DEFAULT hr_api.g_sys,
80: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_ELEMENT_TYPES_F%ROWTYPE;
81: --------------------------------------------------------------------------------
82: FUNCTION element_type_id(
83: p_element_name IN VARCHAR2,

Line 161: p_effective_date IN DATE DEFAULT hr_api.g_sys,

157: --------------------------------------------------------------------------------
158: FUNCTION org_payment_method_rec(
159: p_org_payment_method_name IN VARCHAR2,
160: p_business_group_id IN NUMBER,
161: p_effective_date IN DATE DEFAULT hr_api.g_sys,
162: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_ORG_PAYMENT_METHODS_F%ROWTYPE;
163: --------------------------------------------------------------------------------
164: FUNCTION org_payment_method_id(
165: p_org_payment_method_name IN VARCHAR2,

Line 172: p_effective_date IN DATE DEFAULT hr_api.g_sys,

168: --------------------------------------------------------------------------------
169: FUNCTION payroll_rec(
170: p_payroll_name IN VARCHAR2,
171: p_business_group_id IN NUMBER,
172: p_effective_date IN DATE DEFAULT hr_api.g_sys,
173: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_ALL_PAYROLLS_F%ROWTYPE;
174: --------------------------------------------------------------------------------
175: FUNCTION payroll_id(
176: p_payroll_name IN VARCHAR2,

Line 223: p_effective_date IN DATE DEFAULT hr_api.g_sys,

219: --------------------------------------------------------------------------------
220: FUNCTION emp_person_rec(
221: p_employee_number IN VARCHAR2,
222: p_business_group_id IN NUMBER,
223: p_effective_date IN DATE DEFAULT hr_api.g_sys,
224: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PER_ALL_PEOPLE_F%ROWTYPE;
225: --------------------------------------------------------------------------------
226: FUNCTION emp_person_id(
227: p_employee_number IN VARCHAR2,

Line 234: p_effective_date IN DATE DEFAULT hr_api.g_sys,

230: --------------------------------------------------------------------------------
231: FUNCTION apl_person_rec(
232: p_applicant_number IN VARCHAR2,
233: p_business_group_id IN NUMBER,
234: p_effective_date IN DATE DEFAULT hr_api.g_sys,
235: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PER_ALL_PEOPLE_F%ROWTYPE;
236: --------------------------------------------------------------------------------
237: FUNCTION apl_person_id(
238: p_applicant_number IN VARCHAR2,

Line 245: p_effective_date IN DATE DEFAULT hr_api.g_sys,

241: --------------------------------------------------------------------------------
242: FUNCTION emp_assignment_rec(
243: p_assignment_number IN VARCHAR2,
244: p_business_group_id IN NUMBER,
245: p_effective_date IN DATE DEFAULT hr_api.g_sys,
246: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PER_ALL_ASSIGNMENTS_F%ROWTYPE;
247: --------------------------------------------------------------------------------
248: FUNCTION emp_assignment_id(
249: p_assignment_number IN VARCHAR2,

Line 293: p_effective_date IN DATE DEFAULT hr_api.g_sys,

289: --------------------------------------------------------------------------------
290: FUNCTION input_value_rec(
291: p_element_type_id IN NUMBER,
292: p_name IN VARCHAR2,
293: p_effective_date IN DATE DEFAULT hr_api.g_sys,
294: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_INPUT_VALUES_F%ROWTYPE;
295: --------------------------------------------------------------------------------
296: FUNCTION input_value_id(
297: p_element_type_id IN NUMBER,

Line 306: p_effective_date IN DATE DEFAULT hr_api.g_sys,

302: p_element_name IN VARCHAR2,
303: p_name IN VARCHAR2,
304: p_business_group_id IN NUMBER DEFAULT NULL,
305: p_legislation_code IN VARCHAR2 DEFAULT NULL,
306: p_effective_date IN DATE DEFAULT hr_api.g_sys,
307: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_INPUT_VALUES_F%ROWTYPE;
308: --------------------------------------------------------------------------------
309: FUNCTION input_value_id(
310: p_element_name IN VARCHAR2,

Line 349: p_effective_date IN DATE DEFAULT hr_api.g_sys,

345: p_balance_type_id IN NUMBER,
346: p_input_value_id IN NUMBER,
347: p_business_group_id IN NUMBER DEFAULT NULL,
348: p_legislation_code IN VARCHAR2 DEFAULT NULL,
349: p_effective_date IN DATE DEFAULT hr_api.g_sys,
350: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_BALANCE_FEEDS_F%ROWTYPE;
351: --------------------------------------------------------------------------------
352: FUNCTION balance_feed_id(
353: p_balance_type_id IN NUMBER,

Line 357: p_effective_date IN DATE DEFAULT hr_api.g_sys,

353: p_balance_type_id IN NUMBER,
354: p_input_value_id IN NUMBER,
355: p_business_group_id IN NUMBER DEFAULT NULL,
356: p_legislation_code IN VARCHAR2 DEFAULT NULL,
357: p_effective_date IN DATE DEFAULT hr_api.g_sys,
358: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN NUMBER;
359: --------------------------------------------------------------------------------
360: FUNCTION balance_feed_rec(
361: p_balance_name IN VARCHAR2,

Line 366: p_effective_date IN DATE DEFAULT hr_api.g_sys,

362: p_element_name IN VARCHAR2,
363: p_name IN VARCHAR2,
364: p_business_group_id IN NUMBER DEFAULT NULL,
365: p_legislation_code IN VARCHAR2 DEFAULT NULL,
366: p_effective_date IN DATE DEFAULT hr_api.g_sys,
367: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_BALANCE_FEEDS_F%ROWTYPE;
368: --------------------------------------------------------------------------------
369: FUNCTION balance_feed_id(
370: p_balance_name IN VARCHAR2,

Line 375: p_effective_date IN DATE DEFAULT hr_api.g_sys,

371: p_element_name IN VARCHAR2,
372: p_name IN VARCHAR2,
373: p_business_group_id IN NUMBER DEFAULT NULL,
374: p_legislation_code IN VARCHAR2 DEFAULT NULL,
375: p_effective_date IN DATE DEFAULT hr_api.g_sys,
376: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN NUMBER;
377: --------------------------------------------------------------------------------
378: FUNCTION business_group_rec(
379: p_name IN VARCHAR2,

Line 399: p_effective_date IN DATE DEFAULT hr_api.g_sys,

395: p_formula_name IN VARCHAR2,
396: p_formula_type_name IN VARCHAR2,
397: p_business_group_id IN NUMBER DEFAULT NULL,
398: p_legislation_code IN VARCHAR2 DEFAULT NULL,
399: p_effective_date IN DATE DEFAULT hr_api.g_sys,
400: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN FF_FORMULAS_F%ROWTYPE;
401: --------------------------------------------------------------------------------
402: FUNCTION formula_id(
403: p_formula_name IN VARCHAR2,

Line 428: p_effective_date IN DATE DEFAULT hr_api.g_sys,

424: p_element_type_id IN NUMBER,
425: p_assignment_status_type_id IN NUMBER DEFAULT NULL,
426: p_business_group_id IN NUMBER DEFAULT NULL,
427: p_legislation_code IN VARCHAR2 DEFAULT NULL,
428: p_effective_date IN DATE DEFAULT hr_api.g_sys,
429: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_STATUS_PROCESSING_RULES_F%ROWTYPE;
430: --------------------------------------------------------------------------------
431: FUNCTION status_processing_rule_id(
432: p_element_type_id IN NUMBER,

Line 436: p_effective_date IN DATE DEFAULT hr_api.g_sys,

432: p_element_type_id IN NUMBER,
433: p_assignment_status_type_id IN NUMBER DEFAULT NULL,
434: p_business_group_id IN NUMBER DEFAULT NULL,
435: p_legislation_code IN VARCHAR2 DEFAULT NULL,
436: p_effective_date IN DATE DEFAULT hr_api.g_sys,
437: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN NUMBER;
438: --------------------------------------------------------------------------------
439: FUNCTION formula_result_rule_rec(
440: p_status_processing_rule_id IN NUMBER,

Line 447: p_effective_date IN DATE DEFAULT hr_api.g_sys,

443: p_element_type_id IN NUMBER DEFAULT NULL,
444: p_input_value_id IN NUMBER DEFAULT NULL,
445: p_business_group_id IN NUMBER DEFAULT NULL,
446: p_legislation_code IN VARCHAR2 DEFAULT NULL,
447: p_effective_date IN DATE DEFAULT hr_api.g_sys,
448: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_FORMULA_RESULT_RULES_F%ROWTYPE;
449: --------------------------------------------------------------------------------
450: FUNCTION formula_result_rule_id(
451: p_status_processing_rule_id IN NUMBER,

Line 458: p_effective_date IN DATE DEFAULT hr_api.g_sys,

454: p_element_type_id IN NUMBER DEFAULT NULL,
455: p_input_value_id IN NUMBER DEFAULT NULL,
456: p_business_group_id IN NUMBER DEFAULT NULL,
457: p_legislation_code IN VARCHAR2 DEFAULT NULL,
458: p_effective_date IN DATE DEFAULT hr_api.g_sys,
459: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN NUMBER;
460: --------------------------------------------------------------------------------
461: FUNCTION sub_classification_rule_rec(
462: p_element_type_id IN NUMBER,

Line 466: p_effective_date IN DATE DEFAULT hr_api.g_sys,

462: p_element_type_id IN NUMBER,
463: p_classification_id IN NUMBER,
464: p_business_group_id IN NUMBER,
465: p_legislation_code IN VARCHAR2,
466: p_effective_date IN DATE DEFAULT hr_api.g_sys,
467: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_SUB_CLASSIFICATION_RULES_F%ROWTYPE;
468: --------------------------------------------------------------------------------
469: FUNCTION sub_classification_rule_id(
470: p_element_type_id IN NUMBER,

Line 474: p_effective_date IN DATE DEFAULT hr_api.g_sys,

470: p_element_type_id IN NUMBER,
471: p_classification_id IN NUMBER,
472: p_business_group_id IN NUMBER,
473: p_legislation_code IN VARCHAR2,
474: p_effective_date IN DATE DEFAULT hr_api.g_sys,
475: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN NUMBER;
476: --------------------------------------------------------------------------------
477: FUNCTION element_link_id(
478: p_assignment_id IN NUMBER,

Line 480: p_effective_date IN DATE DEFAULT hr_api.g_sys,

476: --------------------------------------------------------------------------------
477: FUNCTION element_link_id(
478: p_assignment_id IN NUMBER,
479: p_element_type_id IN NUMBER,
480: p_effective_date IN DATE DEFAULT hr_api.g_sys,
481: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN NUMBER;
482: --------------------------------------------------------------------------------
483: FUNCTION element_link_id(
484: p_assignment_number IN VARCHAR2,

Line 487: p_effective_date IN DATE DEFAULT hr_api.g_sys,

483: FUNCTION element_link_id(
484: p_assignment_number IN VARCHAR2,
485: p_element_name IN VARCHAR2,
486: p_business_group_id IN NUMBER,
487: p_effective_date IN DATE DEFAULT hr_api.g_sys,
488: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN NUMBER;
489: --------------------------------------------------------------------------------
490: FUNCTION org_information_rec(
491: p_organization_id IN NUMBER,

Line 572: p_effective_date IN DATE DEFAULT hr_api.g_sys,

568: --------------------------------------------------------------------------------
569: FUNCTION period_of_service_rec(
570: p_employee_number IN VARCHAR2,
571: p_business_group_id IN NUMBER,
572: p_effective_date IN DATE DEFAULT hr_api.g_sys,
573: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PER_PERIODS_OF_SERVICE%ROWTYPE;
574: --------------------------------------------------------------------------------
575: FUNCTION element_entry_rec(
576: p_assignment_id IN VARCHAR2,

Line 579: p_effective_date IN DATE DEFAULT hr_api.g_sys,

575: FUNCTION element_entry_rec(
576: p_assignment_id IN VARCHAR2,
577: p_element_type_id IN VARCHAR2,
578: p_entry_type IN VARCHAR2 DEFAULT 'E',
579: p_effective_date IN DATE DEFAULT hr_api.g_sys,
580: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_ELEMENT_ENTRIES_F%ROWTYPE;
581: --------------------------------------------------------------------------------
582: FUNCTION element_entry_rec(
583: p_assignment_number IN VARCHAR2,

Line 587: p_effective_date IN DATE DEFAULT hr_api.g_sys,

583: p_assignment_number IN VARCHAR2,
584: p_element_name IN VARCHAR2,
585: p_entry_type IN VARCHAR2 DEFAULT 'E',
586: p_business_group_id IN NUMBER,
587: p_effective_date IN DATE DEFAULT hr_api.g_sys,
588: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_ELEMENT_ENTRIES_F%ROWTYPE;
589: --------------------------------------------------------------------------------
590: FUNCTION primary_address_rec(
591: -- This function is valid when address_type is not NULL.

Line 593: p_effective_date IN DATE DEFAULT hr_api.g_sys,

589: --------------------------------------------------------------------------------
590: FUNCTION primary_address_rec(
591: -- This function is valid when address_type is not NULL.
592: p_person_id IN NUMBER,
593: p_effective_date IN DATE DEFAULT hr_api.g_sys,
594: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PER_ADDRESSES%ROWTYPE;
595: --------------------------------------------------------------------------------
596: FUNCTION address_rec(
597: -- This function is valid when address_type is not NULL.

Line 600: p_effective_date IN DATE DEFAULT hr_api.g_sys,

596: FUNCTION address_rec(
597: -- This function is valid when address_type is not NULL.
598: p_person_id IN NUMBER,
599: p_address_type IN VARCHAR2,
600: p_effective_date IN DATE DEFAULT hr_api.g_sys,
601: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PER_ADDRESSES%ROWTYPE;
602: --------------------------------------------------------------------------------
603: FUNCTION emp_primary_address_rec(
604: -- This function is valid when address_type is not NULL.

Line 607: p_effective_date IN DATE DEFAULT hr_api.g_sys,

603: FUNCTION emp_primary_address_rec(
604: -- This function is valid when address_type is not NULL.
605: p_employee_number IN VARCHAR2,
606: p_business_group_id IN NUMBER,
607: p_effective_date IN DATE DEFAULT hr_api.g_sys,
608: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PER_ADDRESSES%ROWTYPE;
609: --------------------------------------------------------------------------------
610: FUNCTION emp_address_rec(
611: -- This function is valid when address_type is not NULL.

Line 615: p_effective_date IN DATE DEFAULT hr_api.g_sys,

611: -- This function is valid when address_type is not NULL.
612: p_employee_number IN VARCHAR2,
613: p_address_type IN VARCHAR2,
614: p_business_group_id IN NUMBER,
615: p_effective_date IN DATE DEFAULT hr_api.g_sys,
616: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PER_ADDRESSES%ROWTYPE;
617: --------------------------------------------------------------------------------
618: FUNCTION apl_primary_address_rec(
619: -- This function is valid when address_type is not NULL.

Line 622: p_effective_date IN DATE DEFAULT hr_api.g_sys,

618: FUNCTION apl_primary_address_rec(
619: -- This function is valid when address_type is not NULL.
620: p_applicant_number IN VARCHAR2,
621: p_business_group_id IN NUMBER,
622: p_effective_date IN DATE DEFAULT hr_api.g_sys,
623: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PER_ADDRESSES%ROWTYPE;
624: --------------------------------------------------------------------------------
625: FUNCTION apl_address_rec(
626: -- This function is valid when address_type is not NULL.

Line 630: p_effective_date IN DATE DEFAULT hr_api.g_sys,

626: -- This function is valid when address_type is not NULL.
627: p_applicant_number IN VARCHAR2,
628: p_address_type IN VARCHAR2,
629: p_business_group_id IN NUMBER,
630: p_effective_date IN DATE DEFAULT hr_api.g_sys,
631: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PER_ADDRESSES%ROWTYPE;
632: --------------------------------------------------------------------------------
633: FUNCTION personal_payment_method_rec(
634: p_assignment_id IN NUMBER,

Line 636: p_effective_date IN DATE DEFAULT hr_api.g_sys,

632: --------------------------------------------------------------------------------
633: FUNCTION personal_payment_method_rec(
634: p_assignment_id IN NUMBER,
635: p_priority IN NUMBER,
636: p_effective_date IN DATE DEFAULT hr_api.g_sys,
637: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_PERSONAL_PAYMENT_METHODS_F%ROWTYPE;
638: --------------------------------------------------------------------------------
639: FUNCTION personal_payment_method_rec(
640: p_assignment_number IN VARCHAR2,

Line 643: p_effective_date IN DATE DEFAULT hr_api.g_sys,

639: FUNCTION personal_payment_method_rec(
640: p_assignment_number IN VARCHAR2,
641: p_priority IN NUMBER,
642: p_business_group_id IN NUMBER,
643: p_effective_date IN DATE DEFAULT hr_api.g_sys,
644: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_PERSONAL_PAYMENT_METHODS_F%ROWTYPE;
645: --------------------------------------------------------------------------------
646: FUNCTION JP_BANK_REC(
647: P_BANK_CODE IN VARCHAR2,

Line 664: P_EFFECTIVE_DATE IN DATE DEFAULT hr_api.g_sys,

660: P_PAYROLL_ID IN NUMBER DEFAULT NULL,
661: P_LINK_TO_ALL_PAYROLLS_FLAG IN VARCHAR2 DEFAULT 'N',
662: P_PAY_BASIS_ID IN NUMBER DEFAULT NULL,
663: P_BUSINESS_GROUP_ID IN NUMBER,
664: P_EFFECTIVE_DATE IN DATE DEFAULT hr_api.g_sys,
665: P_ERROR_WHEN_NOT_EXIST IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_ELEMENT_LINKS_F%ROWTYPE;
666: --------------------------------------------------------------------------------
667: FUNCTION element_link_id(
668: P_ELEMENT_TYPE_ID IN NUMBER,

Line 680: P_EFFECTIVE_DATE IN DATE DEFAULT hr_api.g_sys,

676: P_PAYROLL_ID IN NUMBER DEFAULT NULL,
677: P_LINK_TO_ALL_PAYROLLS_FLAG IN VARCHAR2 DEFAULT 'N',
678: P_PAY_BASIS_ID IN NUMBER DEFAULT NULL,
679: P_BUSINESS_GROUP_ID IN NUMBER,
680: P_EFFECTIVE_DATE IN DATE DEFAULT hr_api.g_sys,
681: P_ERROR_WHEN_NOT_EXIST IN VARCHAR2 DEFAULT 'TRUE') RETURN NUMBER;
682: --------------------------------------------------------------------------------
683: FUNCTION backpay_rule_rec(
684: P_BACKPAY_SET_ID IN NUMBER,

Line 692: P_EFFECTIVE_DATE IN DATE DEFAULT hr_api.g_sys,

688: --------------------------------------------------------------------------------
689: FUNCTION org_pay_method_usage_rec(
690: P_PAYROLL_ID IN NUMBER,
691: P_ORG_PAYMENT_METHOD_ID IN NUMBER,
692: P_EFFECTIVE_DATE IN DATE DEFAULT hr_api.g_sys,
693: P_ERROR_WHEN_NOT_EXIST IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_ORG_PAY_METHOD_USAGES_F%ROWTYPE;
694: --------------------------------------------------------------------------------
695: end;