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 780: hr_transaction_ss.get_wf_effective_date

776: BEGIN
777: --
778: hr_utility.set_location('Entering:'||l_proc, 5);
779: p_effective_date:= to_date(
780: hr_transaction_ss.get_wf_effective_date
781: (p_transaction_step_id => p_transaction_step_id),g_date_format);
782: --
783: hr_utility.set_location('Start Calling hr_transaction_api methods:'||l_proc,10);
784: p_attribute_update_mode :=

Line 1111: hr_transaction_ss.get_wf_effective_date

1107: (p_transaction_step_id => p_transaction_step_id
1108: ,p_name => 'P_ADJUSTED_SVC_DATE');
1109: --
1110: p_date_start:= to_date(
1111: hr_transaction_ss.get_wf_effective_date
1112: (p_transaction_step_id => p_transaction_step_id),g_date_format);
1113: --
1114: exception
1115: when others then

Line 1674: l_transaction_table hr_transaction_ss.transaction_table;

1670: l_validate_mode boolean default false;
1671: l_basic_details_update_mode varchar2(100) default null;
1672: l_form_changed boolean default false;
1673: l_count number default 0;
1674: l_transaction_table hr_transaction_ss.transaction_table;
1675: l_trs_object_version_number
1676: hr_api_transaction_steps.object_version_number%type default null;
1677: l_transaction_step_id
1678: hr_api_transaction_steps.transaction_step_id%type default null;

Line 2275: l_transaction_id := hr_transaction_ss.get_transaction_id

2271:
2272: --
2273: -- First, check if transaction id exists or not
2274: --
2275: l_transaction_id := hr_transaction_ss.get_transaction_id
2276: (p_item_type => p_item_type
2277: ,p_item_key => p_item_key);
2278: --
2279: IF l_transaction_id is null THEN

Line 2283: hr_transaction_ss.start_transaction

2279: IF l_transaction_id is null THEN
2280:
2281: -- Start a Transaction
2282:
2283: hr_transaction_ss.start_transaction
2284: (itemtype => p_item_type
2285: ,itemkey => p_item_key
2286: ,actid => p_actid
2287: ,funmode => 'RUN'

Line 2291: l_transaction_id := hr_transaction_ss.get_transaction_id

2287: ,funmode => 'RUN'
2288: ,p_login_person_id => p_login_person_id
2289: ,result => l_result);
2290:
2291: l_transaction_id := hr_transaction_ss.get_transaction_id
2292: (p_item_type => p_item_type
2293: ,p_item_key => p_item_key);
2294: END IF;
2295: --

Line 2340: hr_transaction_ss.g_date_format);

2336: --
2337: l_count := l_count + 1;
2338: l_transaction_table(l_count).param_name := 'P_EFFECTIVE_DATE';
2339: l_transaction_table(l_count).param_value := to_char(p_effective_date,
2340: hr_transaction_ss.g_date_format);
2341: l_transaction_table(l_count).param_data_type := 'DATE';
2342: --
2343: -- Store the hire date in p_date_start to be shown as HireDate
2344: -- in review page for applicant hire.

Line 2348: hr_transaction_ss.g_date_format);

2344: -- in review page for applicant hire.
2345: l_count := l_count + 1;
2346: l_transaction_table(l_count).param_name := 'P_DATE_START';
2347: l_transaction_table(l_count).param_value := to_char(p_effective_date,
2348: hr_transaction_ss.g_date_format);
2349: l_transaction_table(l_count).param_data_type := 'DATE';
2350: --
2351: l_count := l_count + 1;
2352: l_transaction_table(l_count).param_name := 'P_ATTRIBUTE_UPDATE_MODE';

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

2385: --NOTE: When we save to transaction table, we need to convert all number and
2386: -- date data type to varchar2 because the transaction table is defined as
2387: -- varchar2 for the param_value. Otherwise, we will get ORA 06502:PL/SQL
2388: -- numeric or value error, character conversion to number because in
2389: -- hr_transaction_ss.save_transaction_step, it uses a to_number function
2390: -- to convert the param_value from char to num for param_type = 'NUMBER'.
2391: ------------------------------------------------------------------------------
2392: l_count := l_count + 1;
2393: l_transaction_table(l_count).param_name := 'P_FULL_NAME';

Line 2411: ,hr_transaction_ss.g_date_format);

2407: l_count := l_count + 1;
2408: l_transaction_table(l_count).param_name := 'P_DATE_EMPLOYEE_DATA_VERIFIED';
2409: l_transaction_table(l_count).param_value := to_char
2410: (p_date_employee_data_verified
2411: ,hr_transaction_ss.g_date_format);
2412: l_transaction_table(l_count).param_data_type := 'DATE';
2413: --
2414: l_count := l_count + 1;
2415: l_transaction_table(l_count).param_name := 'P_ORIGINAL_DATE_OF_HIRE';

Line 2418: ,hr_transaction_ss.g_date_format);

2414: l_count := l_count + 1;
2415: l_transaction_table(l_count).param_name := 'P_ORIGINAL_DATE_OF_HIRE';
2416: l_transaction_table(l_count).param_value := to_char
2417: (p_original_date_of_hire
2418: ,hr_transaction_ss.g_date_format);
2419: l_transaction_table(l_count).param_data_type := 'DATE';
2420: --
2421: l_count := l_count + 1;
2422: l_transaction_table(l_count).param_name := 'P_DATE_OF_BIRTH';

Line 2425: ,hr_transaction_ss.g_date_format);

2421: l_count := l_count + 1;
2422: l_transaction_table(l_count).param_name := 'P_DATE_OF_BIRTH';
2423: l_transaction_table(l_count).param_value := to_char
2424: (p_date_of_birth
2425: ,hr_transaction_ss.g_date_format);
2426: l_transaction_table(l_count).param_data_type := 'DATE';
2427: --
2428: l_count := l_count + 1;
2429: l_transaction_table(l_count).param_name := 'P_TOWN_OF_BIRTH';

Line 2537: ,hr_transaction_ss.g_date_format);

2533: l_count := l_count + 1;
2534: l_transaction_table(l_count).param_name := 'P_DATE_OF_DEATH';
2535: l_transaction_table(l_count).param_value := to_char
2536: (p_date_of_death
2537: ,hr_transaction_ss.g_date_format);
2538: l_transaction_table(l_count).param_data_type := 'DATE';
2539: --
2540: l_count := l_count + 1;
2541: l_transaction_table(l_count).param_name := 'P_BACKGROUND_CHECK_STATUS';

Line 2549: ,hr_transaction_ss.g_date_format);

2545: l_count := l_count + 1;
2546: l_transaction_table(l_count).param_name := 'P_BACKGROUND_DATE_CHECK';
2547: l_transaction_table(l_count).param_value := to_char
2548: (p_background_date_check
2549: ,hr_transaction_ss.g_date_format);
2550: l_transaction_table(l_count).param_data_type := 'DATE';
2551: --
2552: l_count := l_count + 1;
2553: l_transaction_table(l_count).param_name := 'P_BLOOD_TYPE';

Line 2576: ,hr_transaction_ss.g_date_format);

2572: l_count := l_count + 1;
2573: l_transaction_table(l_count).param_name := 'P_HOLD_APPLICANT_DATE_UNTIL';
2574: l_transaction_table(l_count).param_value := to_char
2575: (p_hold_applicant_date_until
2576: ,hr_transaction_ss.g_date_format);
2577: l_transaction_table(l_count).param_data_type := 'DATE';
2578: --
2579: l_count := l_count + 1;
2580: l_transaction_table(l_count).param_name := 'P_HONORS';

Line 2598: ,hr_transaction_ss.g_date_format);

2594: l_count := l_count + 1;
2595: l_transaction_table(l_count).param_name := 'P_LAST_MEDICAL_TEST_DATE';
2596: l_transaction_table(l_count).param_value := to_char
2597: (p_last_medical_test_date
2598: ,hr_transaction_ss.g_date_format);
2599: l_transaction_table(l_count).param_data_type := 'DATE';
2600: --
2601: l_count := l_count + 1;
2602: l_transaction_table(l_count).param_name := 'P_MAILSTOP';

Line 2625: ,hr_transaction_ss.g_date_format);

2621: l_count := l_count + 1;
2622: l_transaction_table(l_count).param_name := 'P_PROJECTED_START_DATE';
2623: l_transaction_table(l_count).param_value := to_char
2624: (p_projected_start_date
2625: ,hr_transaction_ss.g_date_format);
2626: l_transaction_table(l_count).param_data_type := 'DATE';
2627: --
2628: l_count := l_count + 1;
2629: l_transaction_table(l_count).param_name := 'P_REHIRE_AUTHORIZOR';

Line 2647: ,hr_transaction_ss.g_date_format);

2643: l_count := l_count + 1;
2644: l_transaction_table(l_count).param_name := 'P_RESUME_LAST_UPDATED';
2645: l_transaction_table(l_count).param_value := to_char
2646: (p_resume_last_updated
2647: ,hr_transaction_ss.g_date_format);
2648: l_transaction_table(l_count).param_data_type := 'DATE';
2649: --
2650: l_count := l_count + 1;
2651: l_transaction_table(l_count).param_name := 'P_SECOND_PASSPORT_EXISTS';

Line 2679: ,hr_transaction_ss.g_date_format);

2675: l_count := l_count + 1;
2676: l_transaction_table(l_count).param_name := 'P_RECEIPT_OF_DEATH_CERT_DATE';
2677: l_transaction_table(l_count).param_value := to_char
2678: (p_receipt_of_death_cert_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_COORD_BEN_MED_PLN_NO';

Line 2701: ,hr_transaction_ss.g_date_format);

2697: l_count := l_count + 1;
2698: l_transaction_table(l_count).param_name := 'P_DPDNT_ADOPTION_DATE';
2699: l_transaction_table(l_count).param_value := to_char
2700: (p_dpdnt_adoption_date
2701: ,hr_transaction_ss.g_date_format);
2702: l_transaction_table(l_count).param_data_type := 'DATE';
2703: --
2704: l_count := l_count + 1;
2705: l_transaction_table(l_count).param_name := 'P_DPDNT_VLNTRY_SVCE_FLAG';

Line 2714: ,hr_transaction_ss.g_date_format);

2710: l_count := l_count + 1;
2711: l_transaction_table(l_count).param_name := 'P_ADJUSTED_SVC_DATE';
2712: l_transaction_table(l_count).param_value := to_char
2713: (p_adjusted_svc_date
2714: ,hr_transaction_ss.g_date_format);
2715: l_transaction_table(l_count).param_data_type := 'DATE';
2716:
2717: --
2718: l_count := l_count + 1;

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

3059: --
3060:
3061: --------------------------------------------------------------------------------
3062: -- NOTE: If l_transaction_step_id is null, when we call
3063: -- hr_transaction_ss.save_transaction_step will create a transaction and
3064: -- create a transaction_step_id.
3065: -- If it is not null, it will use the existing step id to update the
3066: -- database.
3067: --------------------------------------------------------------------------------

Line 3075: hr_transaction_ss.save_transaction_step

3071: hr_utility.set_location('Before save_transaction_step', 95);
3072: END IF;
3073:
3074:
3075: hr_transaction_ss.save_transaction_step
3076: (p_item_type => p_item_type
3077: ,p_item_key => p_item_key
3078: ,p_actid => p_actid
3079: ,p_login_person_id => p_login_person_id

Line 5265: hr_transaction_ss.get_wf_effective_date

5261: hr_utility.set_location('p_effective_date is not null:'||l_proc,10);
5262: else
5263: hr_utility.set_location('p_effective_date is null:'||l_proc,15);
5264: l_effective_date:= to_date(
5265: hr_transaction_ss.get_wf_effective_date
5266: (p_transaction_step_id => p_transaction_step_id),g_date_format);
5267: end if;
5268:
5269: --

Line 7220: l_transaction_table hr_transaction_ss.transaction_table;

7216: l_transaction_id number default null;
7217: l_transaction_step_id number default null;
7218: l_trans_obj_vers_num number default null;
7219: l_count integer default 0;
7220: l_transaction_table hr_transaction_ss.transaction_table;
7221: l_review_item_name varchar2(250);
7222: --
7223: l_full_name_duplicate_flag varchar2(1) default null;
7224: l_result varchar2(50);

Line 7850: l_transaction_id := hr_transaction_ss.get_transaction_id

7846: avalue => p_effective_date);
7847: --
7848: -- First, check if transaction id exists or not
7849: --
7850: l_transaction_id := hr_transaction_ss.get_transaction_id
7851: (p_item_type => p_item_type
7852: ,p_item_key => p_item_key);
7853: --
7854: IF l_transaction_id is null THEN

Line 7857: hr_transaction_ss.start_transaction

7853: --
7854: IF l_transaction_id is null THEN
7855: -- Start a Transaction
7856: hr_utility.set_location('l_transaction_id is null THEN:'||l_proc,105);
7857: hr_transaction_ss.start_transaction
7858: (itemtype => p_item_type
7859: ,itemkey => p_item_key
7860: ,actid => p_actid
7861: ,funmode => 'RUN'

Line 7865: l_transaction_id := hr_transaction_ss.get_transaction_id

7861: ,funmode => 'RUN'
7862: ,p_login_person_id => p_login_person_id --nvl(p_login_person_id, p_parent_id)
7863: ,result => l_result);
7864:
7865: l_transaction_id := hr_transaction_ss.get_transaction_id
7866: (p_item_type => p_item_type
7867: ,p_item_key => p_item_key);
7868: END IF;
7869: ------------------

Line 7954: hr_transaction_ss.g_date_format);

7950: --
7951: l_count := l_count + 1;
7952: l_transaction_table(l_count).param_name := 'P_DATE_START';
7953: l_transaction_table(l_count).param_value := to_char(p_hire_date,
7954: hr_transaction_ss.g_date_format);
7955: l_transaction_table(l_count).param_data_type := 'DATE';
7956: --
7957: -- We don't want to derive the business_group_id because we want to save a
7958: -- db sql statement call to improve the performance.

Line 7987: hr_transaction_ss.g_date_format);

7983: --
7984: l_count := l_count + 1;
7985: l_transaction_table(l_count).param_name := 'P_DATE_EMPLOYEE_DATA_VERIFIED';
7986: l_transaction_table(l_count).param_value := to_char(p_date_employee_data_verified,
7987: hr_transaction_ss.g_date_format);
7988: l_transaction_table(l_count).param_data_type := 'DATE';
7989: --
7990: l_count := l_count + 1;
7991: l_transaction_table(l_count).param_name := 'P_DATE_OF_BIRTH';

Line 7993: hr_transaction_ss.g_date_format);

7989: --
7990: l_count := l_count + 1;
7991: l_transaction_table(l_count).param_name := 'P_DATE_OF_BIRTH';
7992: l_transaction_table(l_count).param_value := to_char(p_date_of_birth,
7993: hr_transaction_ss.g_date_format);
7994: l_transaction_table(l_count).param_data_type := 'DATE';
7995: --
7996: l_count := l_count + 1;
7997: l_transaction_table(l_count).param_name := 'P_EMAIL_ADDRESS';

Line 8376: ,hr_transaction_ss.g_date_format);

8372: l_count := l_count + 1;
8373: l_transaction_table(l_count).param_name := 'P_DATE_OF_DEATH';
8374: l_transaction_table(l_count).param_value := to_char
8375: (p_date_of_death
8376: ,hr_transaction_ss.g_date_format);
8377: l_transaction_table(l_count).param_data_type := 'DATE';
8378: --
8379: l_count := l_count + 1;
8380: l_transaction_table(l_count).param_name := 'P_BACKGROUND_CHECK_STATUS';

Line 8388: ,hr_transaction_ss.g_date_format);

8384: l_count := l_count + 1;
8385: l_transaction_table(l_count).param_name := 'P_BACKGROUND_DATE_CHECK';
8386: l_transaction_table(l_count).param_value := to_char
8387: (p_background_date_check
8388: ,hr_transaction_ss.g_date_format);
8389: l_transaction_table(l_count).param_data_type := 'DATE';
8390: --
8391: l_count := l_count + 1;
8392: l_transaction_table(l_count).param_name := 'P_BLOOD_TYPE';

Line 8430: ,hr_transaction_ss.g_date_format);

8426: l_count := l_count + 1;
8427: l_transaction_table(l_count).param_name := 'P_LAST_MEDICAL_TEST_DATE';
8428: l_transaction_table(l_count).param_value := to_char
8429: (p_last_medical_test_date
8430: ,hr_transaction_ss.g_date_format);
8431: l_transaction_table(l_count).param_data_type := 'DATE';
8432: --
8433: l_count := l_count + 1;
8434: l_transaction_table(l_count).param_name := 'P_MAILSTOP';

Line 8457: ,hr_transaction_ss.g_date_format);

8453: l_count := l_count + 1;
8454: l_transaction_table(l_count).param_name := 'P_PROJECTED_START_DATE';
8455: l_transaction_table(l_count).param_value := to_char
8456: (p_projected_start_date
8457: ,hr_transaction_ss.g_date_format);
8458: l_transaction_table(l_count).param_data_type := 'DATE';
8459: --
8460: l_count := l_count + 1;
8461: l_transaction_table(l_count).param_name := 'P_RESUME_EXISTS';

Line 8469: ,hr_transaction_ss.g_date_format);

8465: l_count := l_count + 1;
8466: l_transaction_table(l_count).param_name := 'P_RESUME_LAST_UPDATED';
8467: l_transaction_table(l_count).param_value := to_char
8468: (p_resume_last_updated
8469: ,hr_transaction_ss.g_date_format);
8470: l_transaction_table(l_count).param_data_type := 'DATE';
8471: --
8472: l_count := l_count + 1;
8473: l_transaction_table(l_count).param_name := 'P_SECOND_PASSPORT_EXISTS';

Line 8501: ,hr_transaction_ss.g_date_format);

8497: l_count := l_count + 1;
8498: l_transaction_table(l_count).param_name := 'P_RECEIPT_OF_DEATH_CERT_DATE';
8499: l_transaction_table(l_count).param_value := to_char
8500: (p_receipt_of_death_cert_date
8501: ,hr_transaction_ss.g_date_format);
8502: l_transaction_table(l_count).param_data_type := 'DATE';
8503: --
8504: l_count := l_count + 1;
8505: l_transaction_table(l_count).param_name := 'P_COORD_BEN_MED_PLN_NO';

Line 8523: ,hr_transaction_ss.g_date_format);

8519: l_count := l_count + 1;
8520: l_transaction_table(l_count).param_name := 'P_DPDNT_ADOPTION_DATE';
8521: l_transaction_table(l_count).param_value := to_char
8522: (p_dpdnt_adoption_date
8523: ,hr_transaction_ss.g_date_format);
8524: l_transaction_table(l_count).param_data_type := 'DATE';
8525: --
8526: l_count := l_count + 1;
8527: l_transaction_table(l_count).param_name := 'P_DPDNT_VLNTRY_SVCE_FLAG';

Line 8535: ,hr_transaction_ss.g_date_format);

8531: l_count := l_count + 1;
8532: l_transaction_table(l_count).param_name := 'P_ORIGINAL_DATE_OF_HIRE';
8533: l_transaction_table(l_count).param_value := to_char
8534: (p_original_date_of_hire
8535: ,hr_transaction_ss.g_date_format);
8536: l_transaction_table(l_count).param_data_type := 'DATE';
8537: --
8538: l_count := l_count + 1;
8539: l_transaction_table(l_count).param_name := 'P_ADJUSTED_SVC_DATE';

Line 8542: ,hr_transaction_ss.g_date_format);

8538: l_count := l_count + 1;
8539: l_transaction_table(l_count).param_name := 'P_ADJUSTED_SVC_DATE';
8540: l_transaction_table(l_count).param_value := to_char
8541: (p_adjusted_svc_date
8542: ,hr_transaction_ss.g_date_format);
8543: l_transaction_table(l_count).param_data_type := 'DATE';
8544: --
8545: l_count := l_count + 1;
8546: l_transaction_table(l_count).param_name := 'P_TOWN_OF_BIRTH';

Line 8589: ,hr_transaction_ss.g_date_format);

8585: l_count := l_count + 1;
8586: l_transaction_table(l_count).param_name := 'P_PER_EFFECTIVE_START_DATE';
8587: l_transaction_table(l_count).param_value := to_char
8588: (p_per_effective_start_date
8589: ,hr_transaction_ss.g_date_format);
8590: l_transaction_table(l_count).param_data_type := 'DATE';
8591: --
8592: l_count := l_count + 1;
8593: l_transaction_table(l_count).param_name := 'P_PER_EFFECTIVE_END_DATE';

Line 8596: ,hr_transaction_ss.g_date_format);

8592: l_count := l_count + 1;
8593: l_transaction_table(l_count).param_name := 'P_PER_EFFECTIVE_END_DATE';
8594: l_transaction_table(l_count).param_value := to_char
8595: (p_per_effective_end_date
8596: ,hr_transaction_ss.g_date_format);
8597: l_transaction_table(l_count).param_data_type := 'DATE';
8598: --
8599: l_review_item_name := p_review_page_region_code;
8600: if (p_review_page_region_code IS NULL) then

Line 8628: hr_transaction_ss.g_date_format);

8624: --
8625: l_count := l_count + 1;
8626: l_transaction_table(l_count).param_name := 'P_EFFECTIVE_DATE';
8627: l_transaction_table(l_count).param_value := to_char(p_effective_date,
8628: hr_transaction_ss.g_date_format);
8629: l_transaction_table(l_count).param_data_type := 'DATE';
8630: --
8631: l_count := l_count + 1;
8632: l_transaction_table(l_count).param_name := 'P_ATTRIBUTE_UPDATE_MODE';

Line 8665: ,hr_transaction_ss.g_date_format);

8661: l_count := l_count + 1;
8662: l_transaction_table(l_count).param_name := 'P_HOLD_APPLICANT_DATE_UNTIL';
8663: l_transaction_table(l_count).param_value := to_char
8664: (p_hold_applicant_date_until
8665: ,hr_transaction_ss.g_date_format);
8666: l_transaction_table(l_count).param_data_type := 'DATE';
8667: --
8668: l_count := l_count + 1;
8669: l_transaction_table(l_count).param_name := 'P_REHIRE_AUTHORIZOR';

Line 8711: hr_transaction_ss.save_transaction_step

8707: --
8708:
8709:
8710:
8711: hr_transaction_ss.save_transaction_step
8712: (p_item_type => p_item_type
8713: ,p_item_key => p_item_key
8714: ,p_actid => p_actid
8715: ,p_login_person_id => p_login_person_id