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.HR_PROCESS_PERSON_SS dependencies on HR_TRANSACTION_SS

Line 786: hr_transaction_ss.get_wf_effective_date

782: BEGIN
783: --
784: hr_utility.set_location('Entering:'||l_proc, 5);
785: p_effective_date:= to_date(
786: hr_transaction_ss.get_wf_effective_date
787: (p_transaction_step_id => p_transaction_step_id),g_date_format);
788: --
789: hr_utility.set_location('Start Calling hr_transaction_api methods:'||l_proc,10);
790: p_attribute_update_mode :=

Line 1117: hr_transaction_ss.get_wf_effective_date

1113: (p_transaction_step_id => p_transaction_step_id
1114: ,p_name => 'P_ADJUSTED_SVC_DATE');
1115: --
1116: p_date_start:= to_date(
1117: hr_transaction_ss.get_wf_effective_date
1118: (p_transaction_step_id => p_transaction_step_id),g_date_format);
1119: --
1120: exception
1121: when others then

Line 1881: l_transaction_table hr_transaction_ss.transaction_table;

1877: l_validate_mode boolean default false;
1878: l_basic_details_update_mode varchar2(100) default null;
1879: l_form_changed boolean default false;
1880: l_count number default 0;
1881: l_transaction_table hr_transaction_ss.transaction_table;
1882: l_dummy_txn_table hr_transaction_ss.transaction_table;
1883: l_trs_object_version_number
1884: hr_api_transaction_steps.object_version_number%type default null;
1885: l_transaction_step_id

Line 1882: l_dummy_txn_table hr_transaction_ss.transaction_table;

1878: l_basic_details_update_mode varchar2(100) default null;
1879: l_form_changed boolean default false;
1880: l_count number default 0;
1881: l_transaction_table hr_transaction_ss.transaction_table;
1882: l_dummy_txn_table hr_transaction_ss.transaction_table;
1883: l_trs_object_version_number
1884: hr_api_transaction_steps.object_version_number%type default null;
1885: l_transaction_step_id
1886: hr_api_transaction_steps.transaction_step_id%type default null;

Line 2569: l_transaction_id := hr_transaction_ss.get_transaction_id

2565:
2566: --
2567: -- First, check if transaction id exists or not
2568: --
2569: l_transaction_id := hr_transaction_ss.get_transaction_id
2570: (p_item_type => p_item_type
2571: ,p_item_key => p_item_key);
2572: --
2573: IF l_transaction_id is null THEN

Line 2578: hr_transaction_ss.start_transaction

2574:
2575: -- Start a Transaction
2576:
2577: if (p_asgn_change_mode = 'V' OR p_asgn_change_mode = 'W') then
2578: hr_transaction_ss.start_transaction
2579: (itemtype => p_item_type
2580: ,itemkey => p_item_key
2581: ,actid => p_actid
2582: ,funmode => 'RUN'

Line 2588: hr_transaction_ss.start_transaction

2584: ,p_rptg_grp_id =>p_appl_assign_id
2585: ,result => l_result);
2586:
2587: else
2588: hr_transaction_ss.start_transaction
2589: (itemtype => p_item_type
2590: ,itemkey => p_item_key
2591: ,actid => p_actid
2592: ,funmode => 'RUN'

Line 2597: l_transaction_id := hr_transaction_ss.get_transaction_id

2593: ,p_login_person_id => p_login_person_id
2594: ,result => l_result);
2595: end if;
2596:
2597: l_transaction_id := hr_transaction_ss.get_transaction_id
2598: (p_item_type => p_item_type
2599: ,p_item_key => p_item_key);
2600: /*Added following code as a part of ER#9879782 Starts*/
2601: IF (l_current_applicant_flag = 'Y')

Line 2671: hr_transaction_ss.g_date_format);

2667: --
2668: l_count := l_count + 1;
2669: l_transaction_table(l_count).param_name := 'P_EFFECTIVE_DATE';
2670: l_transaction_table(l_count).param_value := to_char(p_effective_date,
2671: hr_transaction_ss.g_date_format);
2672: l_transaction_table(l_count).param_data_type := 'DATE';
2673: --
2674: -- Store the hire date in p_date_start to be shown as HireDate
2675: -- in review page for applicant hire.

Line 2679: hr_transaction_ss.g_date_format);

2675: -- in review page for applicant hire.
2676: l_count := l_count + 1;
2677: l_transaction_table(l_count).param_name := 'P_DATE_START';
2678: l_transaction_table(l_count).param_value := to_char(p_effective_date,
2679: hr_transaction_ss.g_date_format);
2680: l_transaction_table(l_count).param_data_type := 'DATE';
2681: --
2682: l_count := l_count + 1;
2683: l_transaction_table(l_count).param_name := 'P_ATTRIBUTE_UPDATE_MODE';

Line 2720: -- hr_transaction_ss.save_transaction_step, it uses a to_number function

2716: --NOTE: When we save to transaction table, we need to convert all number and
2717: -- date data type to varchar2 because the transaction table is defined as
2718: -- varchar2 for the param_value. Otherwise, we will get ORA 06502:PL/SQL
2719: -- numeric or value error, character conversion to number because in
2720: -- hr_transaction_ss.save_transaction_step, it uses a to_number function
2721: -- to convert the param_value from char to num for param_type = 'NUMBER'.
2722: ------------------------------------------------------------------------------
2723: l_count := l_count + 1;
2724: l_transaction_table(l_count).param_name := 'P_FULL_NAME';

Line 2742: ,hr_transaction_ss.g_date_format);

2738: l_count := l_count + 1;
2739: l_transaction_table(l_count).param_name := 'P_DATE_EMPLOYEE_DATA_VERIFIED';
2740: l_transaction_table(l_count).param_value := to_char
2741: (p_date_employee_data_verified
2742: ,hr_transaction_ss.g_date_format);
2743: l_transaction_table(l_count).param_data_type := 'DATE';
2744: --
2745: l_count := l_count + 1;
2746: l_transaction_table(l_count).param_name := 'P_ORIGINAL_DATE_OF_HIRE';

Line 2749: ,hr_transaction_ss.g_date_format);

2745: l_count := l_count + 1;
2746: l_transaction_table(l_count).param_name := 'P_ORIGINAL_DATE_OF_HIRE';
2747: l_transaction_table(l_count).param_value := to_char
2748: (p_original_date_of_hire
2749: ,hr_transaction_ss.g_date_format);
2750: l_transaction_table(l_count).param_data_type := 'DATE';
2751: --
2752: l_count := l_count + 1;
2753: l_transaction_table(l_count).param_name := 'P_DATE_OF_BIRTH';

Line 2756: ,hr_transaction_ss.g_date_format);

2752: l_count := l_count + 1;
2753: l_transaction_table(l_count).param_name := 'P_DATE_OF_BIRTH';
2754: l_transaction_table(l_count).param_value := to_char
2755: (p_date_of_birth
2756: ,hr_transaction_ss.g_date_format);
2757: l_transaction_table(l_count).param_data_type := 'DATE';
2758: --
2759: l_count := l_count + 1;
2760: l_transaction_table(l_count).param_name := 'P_TOWN_OF_BIRTH';

Line 2868: ,hr_transaction_ss.g_date_format);

2864: l_count := l_count + 1;
2865: l_transaction_table(l_count).param_name := 'P_DATE_OF_DEATH';
2866: l_transaction_table(l_count).param_value := to_char
2867: (p_date_of_death
2868: ,hr_transaction_ss.g_date_format);
2869: l_transaction_table(l_count).param_data_type := 'DATE';
2870: --
2871: l_count := l_count + 1;
2872: l_transaction_table(l_count).param_name := 'P_BACKGROUND_CHECK_STATUS';

Line 2880: ,hr_transaction_ss.g_date_format);

2876: l_count := l_count + 1;
2877: l_transaction_table(l_count).param_name := 'P_BACKGROUND_DATE_CHECK';
2878: l_transaction_table(l_count).param_value := to_char
2879: (p_background_date_check
2880: ,hr_transaction_ss.g_date_format);
2881: l_transaction_table(l_count).param_data_type := 'DATE';
2882: --
2883: l_count := l_count + 1;
2884: l_transaction_table(l_count).param_name := 'P_BLOOD_TYPE';

Line 2907: ,hr_transaction_ss.g_date_format);

2903: l_count := l_count + 1;
2904: l_transaction_table(l_count).param_name := 'P_HOLD_APPLICANT_DATE_UNTIL';
2905: l_transaction_table(l_count).param_value := to_char
2906: (p_hold_applicant_date_until
2907: ,hr_transaction_ss.g_date_format);
2908: l_transaction_table(l_count).param_data_type := 'DATE';
2909: --
2910: l_count := l_count + 1;
2911: l_transaction_table(l_count).param_name := 'P_HONORS';

Line 2929: ,hr_transaction_ss.g_date_format);

2925: l_count := l_count + 1;
2926: l_transaction_table(l_count).param_name := 'P_LAST_MEDICAL_TEST_DATE';
2927: l_transaction_table(l_count).param_value := to_char
2928: (p_last_medical_test_date
2929: ,hr_transaction_ss.g_date_format);
2930: l_transaction_table(l_count).param_data_type := 'DATE';
2931: --
2932: l_count := l_count + 1;
2933: l_transaction_table(l_count).param_name := 'P_MAILSTOP';

Line 2956: ,hr_transaction_ss.g_date_format);

2952: l_count := l_count + 1;
2953: l_transaction_table(l_count).param_name := 'P_PROJECTED_START_DATE';
2954: l_transaction_table(l_count).param_value := to_char
2955: (p_projected_start_date
2956: ,hr_transaction_ss.g_date_format);
2957: l_transaction_table(l_count).param_data_type := 'DATE';
2958: --
2959: l_count := l_count + 1;
2960: l_transaction_table(l_count).param_name := 'P_REHIRE_AUTHORIZOR';

Line 2978: ,hr_transaction_ss.g_date_format);

2974: l_count := l_count + 1;
2975: l_transaction_table(l_count).param_name := 'P_RESUME_LAST_UPDATED';
2976: l_transaction_table(l_count).param_value := to_char
2977: (p_resume_last_updated
2978: ,hr_transaction_ss.g_date_format);
2979: l_transaction_table(l_count).param_data_type := 'DATE';
2980: --
2981: l_count := l_count + 1;
2982: l_transaction_table(l_count).param_name := 'P_SECOND_PASSPORT_EXISTS';

Line 3010: ,hr_transaction_ss.g_date_format);

3006: l_count := l_count + 1;
3007: l_transaction_table(l_count).param_name := 'P_RECEIPT_OF_DEATH_CERT_DATE';
3008: l_transaction_table(l_count).param_value := to_char
3009: (p_receipt_of_death_cert_date
3010: ,hr_transaction_ss.g_date_format);
3011: l_transaction_table(l_count).param_data_type := 'DATE';
3012: --
3013: l_count := l_count + 1;
3014: l_transaction_table(l_count).param_name := 'P_COORD_BEN_MED_PLN_NO';

Line 3032: ,hr_transaction_ss.g_date_format);

3028: l_count := l_count + 1;
3029: l_transaction_table(l_count).param_name := 'P_DPDNT_ADOPTION_DATE';
3030: l_transaction_table(l_count).param_value := to_char
3031: (p_dpdnt_adoption_date
3032: ,hr_transaction_ss.g_date_format);
3033: l_transaction_table(l_count).param_data_type := 'DATE';
3034: --
3035: l_count := l_count + 1;
3036: l_transaction_table(l_count).param_name := 'P_DPDNT_VLNTRY_SVCE_FLAG';

Line 3045: ,hr_transaction_ss.g_date_format);

3041: l_count := l_count + 1;
3042: l_transaction_table(l_count).param_name := 'P_ADJUSTED_SVC_DATE';
3043: l_transaction_table(l_count).param_value := to_char
3044: (p_adjusted_svc_date
3045: ,hr_transaction_ss.g_date_format);
3046: l_transaction_table(l_count).param_data_type := 'DATE';
3047:
3048: --
3049: l_count := l_count + 1;

Line 3398: -- hr_transaction_ss.save_transaction_step will create a transaction and

3394: l_transaction_table(l_count).param_data_type := 'VARCHAR2';
3395:
3396: --------------------------------------------------------------------------------
3397: -- NOTE: If l_transaction_step_id is null, when we call
3398: -- hr_transaction_ss.save_transaction_step will create a transaction and
3399: -- create a transaction_step_id.
3400: -- If it is not null, it will use the existing step id to update the
3401: -- database.
3402: --------------------------------------------------------------------------------

Line 3410: hr_transaction_ss.save_transaction_step

3406: hr_utility.set_location('Before save_transaction_step', 95);
3407: END IF;
3408:
3409:
3410: hr_transaction_ss.save_transaction_step
3411: (p_item_type => p_item_type
3412: ,p_item_key => p_item_key
3413: ,p_actid => p_actid
3414: ,p_login_person_id => p_login_person_id

Line 3451: hr_transaction_ss.save_transaction_step

3447: l_dummy_txn_table(l_count).param_name := 'P_ORG_NAME';
3448: l_dummy_txn_table(l_count).param_value := p_org_name;
3449: l_dummy_txn_table(l_count).param_data_type := 'VARCHAR2';
3450:
3451: hr_transaction_ss.save_transaction_step
3452: (p_item_type => p_item_type
3453: ,p_item_key => p_item_key
3454: ,p_actid => -1
3455: ,p_login_person_id => p_login_person_id

Line 5703: hr_transaction_ss.get_wf_effective_date

5699: hr_utility.set_location('p_effective_date is not null:'||l_proc,10);
5700: else
5701: hr_utility.set_location('p_effective_date is null:'||l_proc,15);
5702: l_effective_date:= to_date(
5703: hr_transaction_ss.get_wf_effective_date
5704: (p_transaction_step_id => p_transaction_step_id),g_date_format);
5705: end if;
5706:
5707: --

Line 7792: l_transaction_table hr_transaction_ss.transaction_table;

7788: l_transaction_id number default null;
7789: l_transaction_step_id number default null;
7790: l_trans_obj_vers_num number default null;
7791: l_count integer default 0;
7792: l_transaction_table hr_transaction_ss.transaction_table;
7793: l_review_item_name varchar2(250);
7794: --
7795: l_full_name_duplicate_flag varchar2(1) default null;
7796: l_result varchar2(50);

Line 8428: l_transaction_id := hr_transaction_ss.get_transaction_id

8424: avalue => p_effective_date);
8425: --
8426: -- First, check if transaction id exists or not
8427: --
8428: l_transaction_id := hr_transaction_ss.get_transaction_id
8429: (p_item_type => p_item_type
8430: ,p_item_key => p_item_key);
8431: --
8432: IF l_transaction_id is null THEN

Line 8435: hr_transaction_ss.start_transaction

8431: --
8432: IF l_transaction_id is null THEN
8433: -- Start a Transaction
8434: hr_utility.set_location('l_transaction_id is null THEN:'||l_proc,105);
8435: hr_transaction_ss.start_transaction
8436: (itemtype => p_item_type
8437: ,itemkey => p_item_key
8438: ,actid => p_actid
8439: ,funmode => 'RUN'

Line 8443: l_transaction_id := hr_transaction_ss.get_transaction_id

8439: ,funmode => 'RUN'
8440: ,p_login_person_id => p_login_person_id --nvl(p_login_person_id, p_parent_id)
8441: ,result => l_result);
8442:
8443: l_transaction_id := hr_transaction_ss.get_transaction_id
8444: (p_item_type => p_item_type
8445: ,p_item_key => p_item_key);
8446: END IF;
8447: ------------------

Line 8532: hr_transaction_ss.g_date_format);

8528: --
8529: l_count := l_count + 1;
8530: l_transaction_table(l_count).param_name := 'P_DATE_START';
8531: l_transaction_table(l_count).param_value := to_char(p_hire_date,
8532: hr_transaction_ss.g_date_format);
8533: l_transaction_table(l_count).param_data_type := 'DATE';
8534: --
8535: -- We don't want to derive the business_group_id because we want to save a
8536: -- db sql statement call to improve the performance.

Line 8565: hr_transaction_ss.g_date_format);

8561: --
8562: l_count := l_count + 1;
8563: l_transaction_table(l_count).param_name := 'P_DATE_EMPLOYEE_DATA_VERIFIED';
8564: l_transaction_table(l_count).param_value := to_char(p_date_employee_data_verified,
8565: hr_transaction_ss.g_date_format);
8566: l_transaction_table(l_count).param_data_type := 'DATE';
8567: --
8568: l_count := l_count + 1;
8569: l_transaction_table(l_count).param_name := 'P_DATE_OF_BIRTH';

Line 8571: hr_transaction_ss.g_date_format);

8567: --
8568: l_count := l_count + 1;
8569: l_transaction_table(l_count).param_name := 'P_DATE_OF_BIRTH';
8570: l_transaction_table(l_count).param_value := to_char(p_date_of_birth,
8571: hr_transaction_ss.g_date_format);
8572: l_transaction_table(l_count).param_data_type := 'DATE';
8573: --
8574: l_count := l_count + 1;
8575: l_transaction_table(l_count).param_name := 'P_EMAIL_ADDRESS';

Line 8954: ,hr_transaction_ss.g_date_format);

8950: l_count := l_count + 1;
8951: l_transaction_table(l_count).param_name := 'P_DATE_OF_DEATH';
8952: l_transaction_table(l_count).param_value := to_char
8953: (p_date_of_death
8954: ,hr_transaction_ss.g_date_format);
8955: l_transaction_table(l_count).param_data_type := 'DATE';
8956: --
8957: l_count := l_count + 1;
8958: l_transaction_table(l_count).param_name := 'P_BACKGROUND_CHECK_STATUS';

Line 8966: ,hr_transaction_ss.g_date_format);

8962: l_count := l_count + 1;
8963: l_transaction_table(l_count).param_name := 'P_BACKGROUND_DATE_CHECK';
8964: l_transaction_table(l_count).param_value := to_char
8965: (p_background_date_check
8966: ,hr_transaction_ss.g_date_format);
8967: l_transaction_table(l_count).param_data_type := 'DATE';
8968: --
8969: l_count := l_count + 1;
8970: l_transaction_table(l_count).param_name := 'P_BLOOD_TYPE';

Line 9008: ,hr_transaction_ss.g_date_format);

9004: l_count := l_count + 1;
9005: l_transaction_table(l_count).param_name := 'P_LAST_MEDICAL_TEST_DATE';
9006: l_transaction_table(l_count).param_value := to_char
9007: (p_last_medical_test_date
9008: ,hr_transaction_ss.g_date_format);
9009: l_transaction_table(l_count).param_data_type := 'DATE';
9010: --
9011: l_count := l_count + 1;
9012: l_transaction_table(l_count).param_name := 'P_MAILSTOP';

Line 9035: ,hr_transaction_ss.g_date_format);

9031: l_count := l_count + 1;
9032: l_transaction_table(l_count).param_name := 'P_PROJECTED_START_DATE';
9033: l_transaction_table(l_count).param_value := to_char
9034: (p_projected_start_date
9035: ,hr_transaction_ss.g_date_format);
9036: l_transaction_table(l_count).param_data_type := 'DATE';
9037: --
9038: l_count := l_count + 1;
9039: l_transaction_table(l_count).param_name := 'P_RESUME_EXISTS';

Line 9047: ,hr_transaction_ss.g_date_format);

9043: l_count := l_count + 1;
9044: l_transaction_table(l_count).param_name := 'P_RESUME_LAST_UPDATED';
9045: l_transaction_table(l_count).param_value := to_char
9046: (p_resume_last_updated
9047: ,hr_transaction_ss.g_date_format);
9048: l_transaction_table(l_count).param_data_type := 'DATE';
9049: --
9050: l_count := l_count + 1;
9051: l_transaction_table(l_count).param_name := 'P_SECOND_PASSPORT_EXISTS';

Line 9079: ,hr_transaction_ss.g_date_format);

9075: l_count := l_count + 1;
9076: l_transaction_table(l_count).param_name := 'P_RECEIPT_OF_DEATH_CERT_DATE';
9077: l_transaction_table(l_count).param_value := to_char
9078: (p_receipt_of_death_cert_date
9079: ,hr_transaction_ss.g_date_format);
9080: l_transaction_table(l_count).param_data_type := 'DATE';
9081: --
9082: l_count := l_count + 1;
9083: l_transaction_table(l_count).param_name := 'P_COORD_BEN_MED_PLN_NO';

Line 9101: ,hr_transaction_ss.g_date_format);

9097: l_count := l_count + 1;
9098: l_transaction_table(l_count).param_name := 'P_DPDNT_ADOPTION_DATE';
9099: l_transaction_table(l_count).param_value := to_char
9100: (p_dpdnt_adoption_date
9101: ,hr_transaction_ss.g_date_format);
9102: l_transaction_table(l_count).param_data_type := 'DATE';
9103: --
9104: l_count := l_count + 1;
9105: l_transaction_table(l_count).param_name := 'P_DPDNT_VLNTRY_SVCE_FLAG';

Line 9113: ,hr_transaction_ss.g_date_format);

9109: l_count := l_count + 1;
9110: l_transaction_table(l_count).param_name := 'P_ORIGINAL_DATE_OF_HIRE';
9111: l_transaction_table(l_count).param_value := to_char
9112: (p_original_date_of_hire
9113: ,hr_transaction_ss.g_date_format);
9114: l_transaction_table(l_count).param_data_type := 'DATE';
9115: --
9116: l_count := l_count + 1;
9117: l_transaction_table(l_count).param_name := 'P_ADJUSTED_SVC_DATE';

Line 9120: ,hr_transaction_ss.g_date_format);

9116: l_count := l_count + 1;
9117: l_transaction_table(l_count).param_name := 'P_ADJUSTED_SVC_DATE';
9118: l_transaction_table(l_count).param_value := to_char
9119: (p_adjusted_svc_date
9120: ,hr_transaction_ss.g_date_format);
9121: l_transaction_table(l_count).param_data_type := 'DATE';
9122: --
9123: l_count := l_count + 1;
9124: l_transaction_table(l_count).param_name := 'P_TOWN_OF_BIRTH';

Line 9167: ,hr_transaction_ss.g_date_format);

9163: l_count := l_count + 1;
9164: l_transaction_table(l_count).param_name := 'P_PER_EFFECTIVE_START_DATE';
9165: l_transaction_table(l_count).param_value := to_char
9166: (p_per_effective_start_date
9167: ,hr_transaction_ss.g_date_format);
9168: l_transaction_table(l_count).param_data_type := 'DATE';
9169: --
9170: l_count := l_count + 1;
9171: l_transaction_table(l_count).param_name := 'P_PER_EFFECTIVE_END_DATE';

Line 9174: ,hr_transaction_ss.g_date_format);

9170: l_count := l_count + 1;
9171: l_transaction_table(l_count).param_name := 'P_PER_EFFECTIVE_END_DATE';
9172: l_transaction_table(l_count).param_value := to_char
9173: (p_per_effective_end_date
9174: ,hr_transaction_ss.g_date_format);
9175: l_transaction_table(l_count).param_data_type := 'DATE';
9176: --
9177: l_review_item_name := p_review_page_region_code;
9178: if (p_review_page_region_code IS NULL) then

Line 9206: hr_transaction_ss.g_date_format);

9202: --
9203: l_count := l_count + 1;
9204: l_transaction_table(l_count).param_name := 'P_EFFECTIVE_DATE';
9205: l_transaction_table(l_count).param_value := to_char(p_effective_date,
9206: hr_transaction_ss.g_date_format);
9207: l_transaction_table(l_count).param_data_type := 'DATE';
9208: --
9209: l_count := l_count + 1;
9210: l_transaction_table(l_count).param_name := 'P_ATTRIBUTE_UPDATE_MODE';

Line 9243: ,hr_transaction_ss.g_date_format);

9239: l_count := l_count + 1;
9240: l_transaction_table(l_count).param_name := 'P_HOLD_APPLICANT_DATE_UNTIL';
9241: l_transaction_table(l_count).param_value := to_char
9242: (p_hold_applicant_date_until
9243: ,hr_transaction_ss.g_date_format);
9244: l_transaction_table(l_count).param_data_type := 'DATE';
9245: --
9246: l_count := l_count + 1;
9247: l_transaction_table(l_count).param_name := 'P_REHIRE_AUTHORIZOR';

Line 9289: hr_transaction_ss.save_transaction_step

9285: --
9286:
9287:
9288:
9289: hr_transaction_ss.save_transaction_step
9290: (p_item_type => p_item_type
9291: ,p_item_key => p_item_key
9292: ,p_actid => p_actid
9293: ,p_login_person_id => p_login_person_id