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_CONTACT_SS dependencies on HR_TRANSACTION_SS

Line 1653: l_transaction_table hr_transaction_ss.transaction_table;

1649: and trunc(sysdate) >= decode(date_start,null,trunc(sysdate),trunc(date_start))
1650: and trunc(sysdate) < decode(date_end,null,trunc(sysdate)+1,trunc(date_end)) ;
1651: -- and primary_contact_flag = 'Y';
1652: --
1653: l_transaction_table hr_transaction_ss.transaction_table;
1654: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;
1655: l_trs_object_version_number hr_api_transaction_steps.object_version_number%type;
1656: l_cont_old_ovn number ;
1657: l_per_old_ovn number;

Line 2389: l_transaction_id := hr_transaction_ss.get_transaction_id

2385: THEN
2386: hr_utility.set_location('l_per_details_changed OR l_basic_details_changed', 50);
2387: -- First, check if transaction id exists or not
2388:
2389: l_transaction_id := hr_transaction_ss.get_transaction_id
2390: (p_item_type => p_item_type
2391: ,p_item_key => p_item_key);
2392: --
2393: --

Line 2397: hr_transaction_ss.start_transaction

2393: --
2394: IF l_transaction_id is null THEN
2395: hr_utility.set_location('IF l_transaction_id is null THEN', 55);
2396: -- Start a Transaction
2397: hr_transaction_ss.start_transaction
2398: (itemtype => p_item_type
2399: ,itemkey => p_item_key
2400: ,actid => p_activity_id
2401: ,funmode => 'RUN'

Line 2406: l_transaction_id := hr_transaction_ss.get_transaction_id

2402: ,p_api_addtnl_info => p_contact_operation --TEST
2403: ,p_login_person_id => nvl(p_login_person_id, p_person_id)
2404: ,result => l_result);
2405:
2406: l_transaction_id := hr_transaction_ss.get_transaction_id
2407: (p_item_type => p_item_type
2408: ,p_item_key => p_item_key);
2409: END IF;
2410: --

Line 2518: hr_transaction_ss.g_date_format);

2514: --
2515: l_count := l_count + 1;
2516: l_transaction_table(l_count).param_name :=upper('p_cont_effective_date');
2517: l_transaction_table(l_count).param_value :=to_char( p_cont_effective_date,
2518: hr_transaction_ss.g_date_format);
2519: l_transaction_table(l_count).param_data_type := upper('date');
2520: --
2521: --
2522: l_count := l_count + 1;

Line 2561: hr_transaction_ss.g_date_format);

2557: --
2558: l_count := l_count + 1;
2559: l_transaction_table(l_count).param_name :=upper('p_date_start');
2560: l_transaction_table(l_count).param_value := to_char(p_date_start,
2561: hr_transaction_ss.g_date_format);
2562: l_transaction_table(l_count).param_data_type := upper('date');
2563: --
2564: --
2565: l_count := l_count + 1;

Line 2574: hr_transaction_ss.g_date_format);

2570: --
2571: l_count := l_count + 1;
2572: l_transaction_table(l_count).param_name :=upper('p_date_end');
2573: l_transaction_table(l_count).param_value :=to_char( p_date_end,
2574: hr_transaction_ss.g_date_format);
2575: l_transaction_table(l_count).param_data_type := upper('date');
2576: --
2577: --
2578: l_count := l_count + 1;

Line 2771: hr_transaction_ss.g_date_format);

2767: --
2768: l_count := l_count + 1;
2769: l_transaction_table(l_count).param_name :=upper('p_per_effective_date');
2770: l_transaction_table(l_count).param_value := to_char(p_per_effective_date,
2771: hr_transaction_ss.g_date_format);
2772: l_transaction_table(l_count).param_data_type := upper('date');
2773: --
2774: --
2775: l_count := l_count + 1;

Line 2820: hr_transaction_ss.g_date_format);

2816: --
2817: l_count := l_count + 1;
2818: l_transaction_table(l_count).param_name :=upper('p_date_employee_data_verified');
2819: l_transaction_table(l_count).param_value := to_char(p_date_employee_data_verified,
2820: hr_transaction_ss.g_date_format);
2821: l_transaction_table(l_count).param_data_type := upper('date');
2822: --
2823: --
2824: l_count := l_count + 1;

Line 2827: hr_transaction_ss.g_date_format);

2823: --
2824: l_count := l_count + 1;
2825: l_transaction_table(l_count).param_name :=upper('p_date_of_birth');
2826: l_transaction_table(l_count).param_value :=to_char( p_date_of_birth,
2827: hr_transaction_ss.g_date_format);
2828: l_transaction_table(l_count).param_data_type := upper('date');
2829: --
2830: --
2831: l_count := l_count + 1;

Line 3296: hr_transaction_ss.g_date_format);

3292: --
3293: l_count := l_count + 1;
3294: l_transaction_table(l_count).param_name :=upper('p_date_of_death');
3295: l_transaction_table(l_count).param_value := to_char(p_date_of_death,
3296: hr_transaction_ss.g_date_format);
3297: l_transaction_table(l_count).param_data_type := upper('date');
3298: --
3299: --
3300: l_count := l_count + 1;

Line 3303: hr_transaction_ss.g_date_format);

3299: --
3300: l_count := l_count + 1;
3301: l_transaction_table(l_count).param_name :=upper('p_dpdnt_adoption_date');
3302: l_transaction_table(l_count).param_value :=to_char(p_dpdnt_adoption_date,
3303: hr_transaction_ss.g_date_format);
3304: l_transaction_table(l_count).param_data_type := upper('date');
3305: --
3306: l_count := l_count + 1;
3307: l_transaction_table(l_count).param_name :=upper('p_background_check_status');

Line 3315: hr_transaction_ss.g_date_format);

3311: --
3312: l_count := l_count + 1;
3313: l_transaction_table(l_count).param_name :=upper('p_background_date_check');
3314: l_transaction_table(l_count).param_value := to_char(p_background_date_check,
3315: hr_transaction_ss.g_date_format);
3316: l_transaction_table(l_count).param_data_type := upper('date');
3317: --
3318: --
3319: l_count := l_count + 1;

Line 3346: hr_transaction_ss.g_date_format);

3342: --
3343: l_count := l_count + 1;
3344: l_transaction_table(l_count).param_name :=upper('p_hold_applicant_date_until');
3345: l_transaction_table(l_count).param_value := to_char(p_hold_applicant_date_until,
3346: hr_transaction_ss.g_date_format);
3347: l_transaction_table(l_count).param_data_type := upper('date');
3348: --
3349: --
3350: l_count := l_count + 1;

Line 3371: hr_transaction_ss.g_date_format);

3367: --
3368: l_count := l_count + 1;
3369: l_transaction_table(l_count).param_name :=upper('p_last_medical_test_date');
3370: l_transaction_table(l_count).param_value := to_char(p_last_medical_test_date,
3371: hr_transaction_ss.g_date_format);
3372: l_transaction_table(l_count).param_data_type := upper('date');
3373: --
3374: --
3375: l_count := l_count + 1;

Line 3402: hr_transaction_ss.g_date_format);

3398: --
3399: l_count := l_count + 1;
3400: l_transaction_table(l_count).param_name :=upper('p_projected_start_date');
3401: l_transaction_table(l_count).param_value := to_char(p_projected_start_date,
3402: hr_transaction_ss.g_date_format);
3403: l_transaction_table(l_count).param_data_type := upper('date');
3404: --
3405: --
3406: l_count := l_count + 1;

Line 3427: hr_transaction_ss.g_date_format);

3423: --
3424: l_count := l_count + 1;
3425: l_transaction_table(l_count).param_name :=upper('p_resume_last_updated');
3426: l_transaction_table(l_count).param_value := to_char(p_resume_last_updated,
3427: hr_transaction_ss.g_date_format);
3428: l_transaction_table(l_count).param_data_type := upper('date');
3429: --
3430: --
3431: l_count := l_count + 1;

Line 3470: hr_transaction_ss.g_date_format);

3466: --
3467: l_count := l_count + 1;
3468: l_transaction_table(l_count).param_name :=upper('p_receipt_of_death_cert_date');
3469: l_transaction_table(l_count).param_value := to_char(p_receipt_of_death_cert_date,
3470: hr_transaction_ss.g_date_format);
3471: l_transaction_table(l_count).param_data_type := upper('date');
3472: --
3473: --
3474: l_count := l_count + 1;

Line 3501: hr_transaction_ss.g_date_format);

3497: --
3498: l_count := l_count + 1;
3499: l_transaction_table(l_count).param_name :=upper('p_original_date_of_hire');
3500: l_transaction_table(l_count).param_value := to_char(p_original_date_of_hire,
3501: hr_transaction_ss.g_date_format);
3502: l_transaction_table(l_count).param_data_type := upper('date');
3503: --
3504: --
3505: l_count := l_count + 1;

Line 3508: hr_transaction_ss.g_date_format);

3504: --
3505: l_count := l_count + 1;
3506: l_transaction_table(l_count).param_name :=upper('p_adjusted_svc_date');
3507: l_transaction_table(l_count).param_value := to_char(p_adjusted_svc_date,
3508: hr_transaction_ss.g_date_format);
3509: l_transaction_table(l_count).param_data_type := upper('date');
3510: --
3511: --
3512: l_count := l_count + 1;

Line 3541: l_transaction_table(l_count).param_value := to_char(p_date_start, hr_transaction_ss.g_date_format);

3537: -- ffunction which works for create_contact and update_contact.
3538: --
3539: l_count := l_count + 1;
3540: l_transaction_table(l_count).param_name :=upper('p_start_date');
3541: l_transaction_table(l_count).param_value := to_char(p_date_start, hr_transaction_ss.g_date_format);
3542: l_transaction_table(l_count).param_data_type := upper('date');
3543: --
3544: --
3545: l_count := l_count + 1;

Line 3916: hr_utility.set_location('Before Calling :hr_transaction_ss.save_transaction_step', 75);

3912: l_transaction_table(l_count).param_name :=upper('P_CONT_INFORMATION20');
3913: l_transaction_table(l_count).param_value := P_CONT_INFORMATION20;
3914: l_transaction_table(l_count).param_data_type := upper('varchar2');
3915:
3916: hr_utility.set_location('Before Calling :hr_transaction_ss.save_transaction_step', 75);
3917: hr_utility.set_location('Before Calling :hr_transaction_ss.save_transaction_step '
3918: || to_char(l_transaction_table.count), 75);
3919: --
3920:

Line 3917: hr_utility.set_location('Before Calling :hr_transaction_ss.save_transaction_step '

3913: l_transaction_table(l_count).param_value := P_CONT_INFORMATION20;
3914: l_transaction_table(l_count).param_data_type := upper('varchar2');
3915:
3916: hr_utility.set_location('Before Calling :hr_transaction_ss.save_transaction_step', 75);
3917: hr_utility.set_location('Before Calling :hr_transaction_ss.save_transaction_step '
3918: || to_char(l_transaction_table.count), 75);
3919: --
3920:
3921: -- Bug 3152505 : Added the new transaction var

Line 3928: hr_transaction_ss.save_transaction_step

3924: l_transaction_table(l_count).param_value := p_orig_rel_type;
3925: l_transaction_table(l_count).param_data_type := upper('varchar2');
3926: --
3927:
3928: hr_transaction_ss.save_transaction_step
3929: (p_item_type => p_item_type
3930: ,p_item_key => p_item_key
3931: ,p_login_person_id => nvl(p_login_person_id, p_person_id)
3932: ,p_actid => p_activity_id

Line 6718: l_transaction_table hr_transaction_ss.transaction_table;

6714:
6715: )
6716: IS
6717: l_count INTEGER := 0;
6718: l_transaction_table hr_transaction_ss.transaction_table;
6719: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;
6720: l_object_version_number hr_api_transaction_steps.object_version_number%type;
6721: l_attribute_update_mode varchar2(100) default null;
6722: l_validate_mode boolean default false;

Line 7488: l_transaction_id := hr_transaction_ss.get_transaction_id

7484: --
7485: /* StartRegistration : Begin code addition */
7486: --
7487: -- First, check if transaction id exists or not
7488: l_transaction_id := hr_transaction_ss.get_transaction_id
7489: (p_item_type => p_item_type
7490: ,p_item_key => p_item_key);
7491: --
7492: IF l_transaction_id is null THEN

Line 7494: hr_transaction_ss.start_transaction

7490: ,p_item_key => p_item_key);
7491: --
7492: IF l_transaction_id is null THEN
7493: -- Start a Transaction
7494: hr_transaction_ss.start_transaction
7495: (itemtype => p_item_type
7496: ,itemkey => p_item_key
7497: ,actid => p_activity_id
7498: ,funmode => 'RUN'

Line 7503: l_transaction_id := hr_transaction_ss.get_transaction_id

7499: ,p_api_addtnl_info => p_contact_operation --TEST
7500: ,p_login_person_id => nvl(p_login_person_id, p_person_id)
7501: ,result => l_result);
7502:
7503: l_transaction_id := hr_transaction_ss.get_transaction_id
7504: (p_item_type => p_item_type
7505: ,p_item_key => p_item_key);
7506: END IF;
7507: --

Line 7599: , hr_transaction_ss.g_date_format);

7595: l_count := l_count + 1;
7596: l_transaction_table(l_count).param_name :=upper('p_start_date');
7597: -- l_transaction_table(l_count).param_value := to_char(p_start_date
7598: l_transaction_table(l_count).param_value := to_char(l_start_date
7599: , hr_transaction_ss.g_date_format);
7600: l_transaction_table(l_count).param_data_type := upper('date');
7601: --
7602: --
7603: l_count := l_count + 1;

Line 7642: , hr_transaction_ss.g_date_format);

7638: --
7639: l_count := l_count + 1;
7640: l_transaction_table(l_count).param_name :=upper('p_date_start');
7641: l_transaction_table(l_count).param_value := to_char(p_date_start
7642: , hr_transaction_ss.g_date_format);
7643: l_transaction_table(l_count).param_data_type := upper('date');
7644: --
7645: -- StartRegistration
7646: --

Line 7656: , hr_transaction_ss.g_date_format);

7652: --
7653: l_count := l_count + 1;
7654: l_transaction_table(l_count).param_name :=upper('p_date_end');
7655: l_transaction_table(l_count).param_value := to_char(p_date_end
7656: , hr_transaction_ss.g_date_format);
7657: l_transaction_table(l_count).param_data_type := upper('date');
7658: --
7659: -- StartRegistration
7660: --

Line 7864: to_char(p_date_of_birth , hr_transaction_ss.g_date_format);

7860: --
7861: l_count := l_count + 1;
7862: l_transaction_table(l_count).param_name :=upper('p_date_of_birth');
7863: l_transaction_table(l_count).param_value :=
7864: to_char(p_date_of_birth , hr_transaction_ss.g_date_format);
7865: l_transaction_table(l_count).param_data_type := upper('date');
7866: --
7867: --
7868: l_count := l_count + 1;

Line 8522: to_char(p_adjusted_svc_date , hr_transaction_ss.g_date_format);

8518: --
8519: l_count := l_count + 1;
8520: l_transaction_table(l_count).param_name :=upper('p_adjusted_svc_date');
8521: l_transaction_table(l_count).param_value :=
8522: to_char(p_adjusted_svc_date , hr_transaction_ss.g_date_format);
8523: l_transaction_table(l_count).param_data_type := upper('date');
8524: --
8525: --
8526: l_count := l_count + 1;

Line 8547: to_char(p_background_date_check , hr_transaction_ss.g_date_format);

8543: --
8544: l_count := l_count + 1;
8545: l_transaction_table(l_count).param_name :=upper('p_background_date_check');
8546: l_transaction_table(l_count).param_value :=
8547: to_char(p_background_date_check , hr_transaction_ss.g_date_format);
8548: l_transaction_table(l_count).param_data_type := upper('date');
8549: --
8550: --
8551: l_count := l_count + 1;

Line 8584: to_char(p_date_employee_data_verified , hr_transaction_ss.g_date_format);

8580: --
8581: l_count := l_count + 1;
8582: l_transaction_table(l_count).param_name :=upper('p_date_employee_data_verified');
8583: l_transaction_table(l_count).param_value :=
8584: to_char(p_date_employee_data_verified , hr_transaction_ss.g_date_format);
8585: l_transaction_table(l_count).param_data_type := upper('date');
8586: --
8587: --
8588: l_count := l_count + 1;

Line 8591: to_char(p_date_of_death , hr_transaction_ss.g_date_format);

8587: --
8588: l_count := l_count + 1;
8589: l_transaction_table(l_count).param_name :=upper('p_date_of_death');
8590: l_transaction_table(l_count).param_value :=
8591: to_char(p_date_of_death , hr_transaction_ss.g_date_format);
8592: l_transaction_table(l_count).param_data_type := upper('date');
8593: --
8594: --
8595: l_count := l_count + 1;

Line 8598: to_char(p_dpdnt_adoption_date , hr_transaction_ss.g_date_format);

8594: --
8595: l_count := l_count + 1;
8596: l_transaction_table(l_count).param_name :=upper('p_dpdnt_adoption_date');
8597: l_transaction_table(l_count).param_value :=
8598: to_char(p_dpdnt_adoption_date , hr_transaction_ss.g_date_format);
8599: l_transaction_table(l_count).param_data_type := upper('date');
8600: --
8601: --
8602: l_count := l_count + 1;

Line 8641: to_char(p_hold_applicant_date_until , hr_transaction_ss.g_date_format);

8637: --
8638: l_count := l_count + 1;
8639: l_transaction_table(l_count).param_name :=upper('p_hold_applicant_date_until');
8640: l_transaction_table(l_count).param_value :=
8641: to_char(p_hold_applicant_date_until , hr_transaction_ss.g_date_format);
8642: l_transaction_table(l_count).param_data_type := upper('date');
8643: --
8644: --
8645: l_count := l_count + 1;

Line 8660: to_char(p_last_medical_test_date , hr_transaction_ss.g_date_format);

8656: --
8657: l_count := l_count + 1;
8658: l_transaction_table(l_count).param_name :=upper('p_last_medical_test_date');
8659: l_transaction_table(l_count).param_value :=
8660: to_char(p_last_medical_test_date , hr_transaction_ss.g_date_format);
8661: l_transaction_table(l_count).param_data_type := upper('date');
8662: --
8663: --
8664: l_count := l_count + 1;

Line 8685: to_char(p_original_date_of_hire , hr_transaction_ss.g_date_format);

8681: --
8682: l_count := l_count + 1;
8683: l_transaction_table(l_count).param_name :=upper('p_original_date_of_hire');
8684: l_transaction_table(l_count).param_value :=
8685: to_char(p_original_date_of_hire , hr_transaction_ss.g_date_format);
8686: l_transaction_table(l_count).param_data_type := upper('date');
8687: --
8688: --
8689: l_count := l_count + 1;

Line 8692: to_char(p_projected_start_date , hr_transaction_ss.g_date_format);

8688: --
8689: l_count := l_count + 1;
8690: l_transaction_table(l_count).param_name :=upper('p_projected_start_date');
8691: l_transaction_table(l_count).param_value :=
8692: to_char(p_projected_start_date , hr_transaction_ss.g_date_format);
8693: l_transaction_table(l_count).param_data_type := upper('date');
8694: --
8695: --
8696: l_count := l_count + 1;

Line 8699: to_char(p_receipt_of_death_cert_date , hr_transaction_ss.g_date_format);

8695: --
8696: l_count := l_count + 1;
8697: l_transaction_table(l_count).param_name :=upper('p_receipt_of_death_cert_date');
8698: l_transaction_table(l_count).param_value :=
8699: to_char(p_receipt_of_death_cert_date , hr_transaction_ss.g_date_format);
8700: l_transaction_table(l_count).param_data_type := upper('date');
8701: --
8702: --
8703: l_count := l_count + 1;

Line 8735: l_transaction_table(l_count).param_value := to_char(p_resume_last_updated , hr_transaction_ss.g_date_format);

8731: --
8732: --
8733: l_count := l_count + 1;
8734: l_transaction_table(l_count).param_name :=upper('p_resume_last_updated');
8735: l_transaction_table(l_count).param_value := to_char(p_resume_last_updated , hr_transaction_ss.g_date_format);
8736: l_transaction_table(l_count).param_data_type := upper('date');
8737: --
8738: --
8739: l_count := l_count + 1;

Line 9152: hr_utility.set_location('Before Calling :hr_transaction_ss.save_transaction_step', 90);

9148: l_transaction_table(l_count).param_name := 'P_CONTACT_SET';
9149: l_transaction_table(l_count).param_value := l_contact_set;
9150: l_transaction_table(l_count).param_data_type := 'VARCHAR2';
9151: --EndRegistration
9152: hr_utility.set_location('Before Calling :hr_transaction_ss.save_transaction_step', 90);
9153: --
9154: hr_transaction_ss.save_transaction_step
9155: (p_item_type => p_item_type
9156: ,p_item_key => p_item_key

Line 9154: hr_transaction_ss.save_transaction_step

9150: l_transaction_table(l_count).param_data_type := 'VARCHAR2';
9151: --EndRegistration
9152: hr_utility.set_location('Before Calling :hr_transaction_ss.save_transaction_step', 90);
9153: --
9154: hr_transaction_ss.save_transaction_step
9155: (p_item_type => p_item_type
9156: ,p_item_key => p_item_key
9157: ,p_login_person_id => nvl(p_login_person_id, p_person_id) -- Registration
9158: -- ,p_login_person_id => p_person_id

Line 9672: hr_transaction_ss.get_wf_effective_date

9668: --
9669: else
9670: --
9671: l_effective_date:= to_date(
9672: hr_transaction_ss.get_wf_effective_date
9673: (p_transaction_step_id => p_transaction_step_id),g_date_format);
9674: --
9675: end if;
9676: --

Line 12507: hr_transaction_ss.get_wf_effective_date

12503: l_effective_date:= to_date(p_effective_date,g_date_format);
12504:
12505: else
12506: l_effective_date:= to_date(
12507: hr_transaction_ss.get_wf_effective_date
12508: (p_transaction_step_id => p_transaction_step_id),g_date_format);
12509:
12510: end if;
12511: --

Line 15053: l_transaction_table hr_transaction_ss.transaction_table;

15049: where contact_relationship_id = p_contact_relationship_id
15050: and trunc(sysdate) between nvl(date_start, trunc(sysdate))
15051: and nvl(date_end, trunc(sysdate));
15052:
15053: l_transaction_table hr_transaction_ss.transaction_table;
15054: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;
15055: l_trs_object_version_number hr_api_transaction_steps.object_version_number%type;
15056: l_old_ovn number;
15057: l_old_contact_relationship_id number;

Line 15204: hr_transaction_ss.g_date_format);

15200: --
15201: l_count := l_count + 1;
15202: l_transaction_table(l_count).param_name := 'P_EFFECTIVE_DATE';
15203: l_transaction_table(l_count).param_value := to_char(P_EFFECTIVE_DATE,
15204: hr_transaction_ss.g_date_format);
15205: l_transaction_table(l_count).param_data_type := 'DATE';
15206: --
15207: l_count:=l_count+1;
15208: l_transaction_table(l_count).param_name := 'P_SAVE_MODE';

Line 15285: hr_transaction_ss.g_date_format);

15281: --
15282: l_count := l_count + 1;
15283: l_transaction_table(l_count).param_name := 'P_DATE_START';
15284: l_transaction_table(l_count).param_value := to_char(P_DATE_START,
15285: hr_transaction_ss.g_date_format);
15286: l_transaction_table(l_count).param_data_type := 'DATE';
15287: --
15288: l_count := l_count + 1;
15289: l_transaction_table(l_count).param_name := 'P_START_LIFE_REASON_ID';

Line 15297: hr_transaction_ss.g_date_format);

15293: hr_utility.set_location('P_DATE_END = ' || to_char(P_DATE_END), 30);
15294: l_count := l_count + 1;
15295: l_transaction_table(l_count).param_name := 'P_DATE_END';
15296: l_transaction_table(l_count).param_value := to_char(P_DATE_END,
15297: hr_transaction_ss.g_date_format);
15298: l_transaction_table(l_count).param_data_type := 'DATE';
15299: --
15300: l_count := l_count + 1;
15301: l_transaction_table(l_count).param_name := 'P_END_LIFE_REASON_ID';

Line 15495: hr_utility.set_location('Before Calling :hr_transaction_ss.save_transaction_step', 30);

15491: l_transaction_table(l_count).param_name := 'P_OTHER_REL_OBJ_VER_NO';
15492: l_transaction_table(l_count).param_value := l_other_rel_object_ver_no;
15493: l_transaction_table(l_count).param_data_type := 'NUMBER';
15494:
15495: hr_utility.set_location('Before Calling :hr_transaction_ss.save_transaction_step', 30);
15496: hr_utility.set_location('Before Calling :hr_transaction_ss.save_transaction_step ' || to_char(l_transaction_table.count), 35);
15497: --
15498: hr_transaction_ss.save_transaction_step
15499: (p_item_type => p_item_type

Line 15496: hr_utility.set_location('Before Calling :hr_transaction_ss.save_transaction_step ' || to_char(l_transaction_table.count), 35);

15492: l_transaction_table(l_count).param_value := l_other_rel_object_ver_no;
15493: l_transaction_table(l_count).param_data_type := 'NUMBER';
15494:
15495: hr_utility.set_location('Before Calling :hr_transaction_ss.save_transaction_step', 30);
15496: hr_utility.set_location('Before Calling :hr_transaction_ss.save_transaction_step ' || to_char(l_transaction_table.count), 35);
15497: --
15498: hr_transaction_ss.save_transaction_step
15499: (p_item_type => p_item_type
15500: ,p_item_key => p_item_key

Line 15498: hr_transaction_ss.save_transaction_step

15494:
15495: hr_utility.set_location('Before Calling :hr_transaction_ss.save_transaction_step', 30);
15496: hr_utility.set_location('Before Calling :hr_transaction_ss.save_transaction_step ' || to_char(l_transaction_table.count), 35);
15497: --
15498: hr_transaction_ss.save_transaction_step
15499: (p_item_type => p_item_type
15500: ,p_item_key => p_item_key
15501: ,p_login_person_id => nvl(p_login_person_id,p_person_id)
15502: ,p_actid => p_activity_id

Line 15581: hr_transaction_ss.get_wf_effective_date

15577: else
15578: --
15579: hr_utility.set_location('Eff date is Null:'||l_proc, 15);
15580: l_effective_date:= to_date(
15581: hr_transaction_ss.get_wf_effective_date
15582: (p_transaction_step_id => p_transaction_step_id),g_date_format);
15583: --
15584: end if;
15585: -- For normal commit the effective date should come from txn tbales.

Line 15985: hr_transaction_ss.delete_transaction_step

15981: l_contact_set := 1;
15982: end if;
15983:
15984: if l_contact_set >= l_wf_contact_set then
15985: hr_transaction_ss.delete_transaction_step
15986: (p_transaction_step_id => l_trans_step_ids(i)
15987: ,p_object_version_number => l_trans_obj_vers_num(i)
15988: ,p_login_person_id => p_login_person_id);
15989: end if;

Line 16078: hr_transaction_ss.delete_transaction_step

16074:
16075: -- When the procedure is called from 'Do not add Contacts'
16076: -- button in 'Add contacts yes no' page
16077: if p_mode = 'ALL' then
16078: hr_transaction_ss.delete_transaction_step
16079: (p_transaction_step_id => l_trans_step_ids(i)
16080: ,p_object_version_number => l_trans_obj_vers_num(i)
16081: ,p_login_person_id => p_login_person_id);
16082:

Line 16087: hr_transaction_ss.delete_transaction_step

16083: -- When the procedure is called from 'add another Contact'
16084: -- button in contacts page
16085: elsif p_mode = 'THIS' then
16086: if l_contact_set = l_wf_contact_set then
16087: hr_transaction_ss.delete_transaction_step
16088: (p_transaction_step_id => l_trans_step_ids(i)
16089: ,p_object_version_number => l_trans_obj_vers_num(i)
16090: ,p_login_person_id => p_login_person_id);
16091: end if;

Line 16097: hr_transaction_ss.delete_transaction_step

16093: -- When the procedure is called from 'Next' button
16094: -- in contacts page
16095: elsif p_mode = 'THIS AND ABOVE' then
16096: if l_contact_set >= l_wf_contact_set then
16097: hr_transaction_ss.delete_transaction_step
16098: (p_transaction_step_id => l_trans_step_ids(i)
16099: ,p_object_version_number => l_trans_obj_vers_num(i)
16100: ,p_login_person_id => p_login_person_id);
16101: end if;