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 2320: l_transaction_id := hr_transaction_ss.get_transaction_id

2316: THEN
2317: hr_utility.set_location('l_per_details_changed OR l_basic_details_changed', 50);
2318: -- First, check if transaction id exists or not
2319:
2320: l_transaction_id := hr_transaction_ss.get_transaction_id
2321: (p_item_type => p_item_type
2322: ,p_item_key => p_item_key);
2323: --
2324: --

Line 2328: hr_transaction_ss.start_transaction

2324: --
2325: IF l_transaction_id is null THEN
2326: hr_utility.set_location('IF l_transaction_id is null THEN', 55);
2327: -- Start a Transaction
2328: hr_transaction_ss.start_transaction
2329: (itemtype => p_item_type
2330: ,itemkey => p_item_key
2331: ,actid => p_activity_id
2332: ,funmode => 'RUN'

Line 2337: l_transaction_id := hr_transaction_ss.get_transaction_id

2333: ,p_api_addtnl_info => p_contact_operation --TEST
2334: ,p_login_person_id => nvl(p_login_person_id, p_person_id)
2335: ,result => l_result);
2336:
2337: l_transaction_id := hr_transaction_ss.get_transaction_id
2338: (p_item_type => p_item_type
2339: ,p_item_key => p_item_key);
2340: END IF;
2341: --

Line 2449: hr_transaction_ss.g_date_format);

2445: --
2446: l_count := l_count + 1;
2447: l_transaction_table(l_count).param_name :=upper('p_cont_effective_date');
2448: l_transaction_table(l_count).param_value :=to_char( p_cont_effective_date,
2449: hr_transaction_ss.g_date_format);
2450: l_transaction_table(l_count).param_data_type := upper('date');
2451: --
2452: --
2453: l_count := l_count + 1;

Line 2492: hr_transaction_ss.g_date_format);

2488: --
2489: l_count := l_count + 1;
2490: l_transaction_table(l_count).param_name :=upper('p_date_start');
2491: l_transaction_table(l_count).param_value := to_char(p_date_start,
2492: hr_transaction_ss.g_date_format);
2493: l_transaction_table(l_count).param_data_type := upper('date');
2494: --
2495: --
2496: l_count := l_count + 1;

Line 2505: hr_transaction_ss.g_date_format);

2501: --
2502: l_count := l_count + 1;
2503: l_transaction_table(l_count).param_name :=upper('p_date_end');
2504: l_transaction_table(l_count).param_value :=to_char( p_date_end,
2505: hr_transaction_ss.g_date_format);
2506: l_transaction_table(l_count).param_data_type := upper('date');
2507: --
2508: --
2509: l_count := l_count + 1;

Line 2702: hr_transaction_ss.g_date_format);

2698: --
2699: l_count := l_count + 1;
2700: l_transaction_table(l_count).param_name :=upper('p_per_effective_date');
2701: l_transaction_table(l_count).param_value := to_char(p_per_effective_date,
2702: hr_transaction_ss.g_date_format);
2703: l_transaction_table(l_count).param_data_type := upper('date');
2704: --
2705: --
2706: l_count := l_count + 1;

Line 2751: hr_transaction_ss.g_date_format);

2747: --
2748: l_count := l_count + 1;
2749: l_transaction_table(l_count).param_name :=upper('p_date_employee_data_verified');
2750: l_transaction_table(l_count).param_value := to_char(p_date_employee_data_verified,
2751: hr_transaction_ss.g_date_format);
2752: l_transaction_table(l_count).param_data_type := upper('date');
2753: --
2754: --
2755: l_count := l_count + 1;

Line 2758: hr_transaction_ss.g_date_format);

2754: --
2755: l_count := l_count + 1;
2756: l_transaction_table(l_count).param_name :=upper('p_date_of_birth');
2757: l_transaction_table(l_count).param_value :=to_char( p_date_of_birth,
2758: hr_transaction_ss.g_date_format);
2759: l_transaction_table(l_count).param_data_type := upper('date');
2760: --
2761: --
2762: l_count := l_count + 1;

Line 3227: hr_transaction_ss.g_date_format);

3223: --
3224: l_count := l_count + 1;
3225: l_transaction_table(l_count).param_name :=upper('p_date_of_death');
3226: l_transaction_table(l_count).param_value := to_char(p_date_of_death,
3227: hr_transaction_ss.g_date_format);
3228: l_transaction_table(l_count).param_data_type := upper('date');
3229: --
3230: --
3231: l_count := l_count + 1;

Line 3234: hr_transaction_ss.g_date_format);

3230: --
3231: l_count := l_count + 1;
3232: l_transaction_table(l_count).param_name :=upper('p_dpdnt_adoption_date');
3233: l_transaction_table(l_count).param_value :=to_char(p_dpdnt_adoption_date,
3234: hr_transaction_ss.g_date_format);
3235: l_transaction_table(l_count).param_data_type := upper('date');
3236: --
3237: l_count := l_count + 1;
3238: l_transaction_table(l_count).param_name :=upper('p_background_check_status');

Line 3246: hr_transaction_ss.g_date_format);

3242: --
3243: l_count := l_count + 1;
3244: l_transaction_table(l_count).param_name :=upper('p_background_date_check');
3245: l_transaction_table(l_count).param_value := to_char(p_background_date_check,
3246: hr_transaction_ss.g_date_format);
3247: l_transaction_table(l_count).param_data_type := upper('date');
3248: --
3249: --
3250: l_count := l_count + 1;

Line 3277: hr_transaction_ss.g_date_format);

3273: --
3274: l_count := l_count + 1;
3275: l_transaction_table(l_count).param_name :=upper('p_hold_applicant_date_until');
3276: l_transaction_table(l_count).param_value := to_char(p_hold_applicant_date_until,
3277: hr_transaction_ss.g_date_format);
3278: l_transaction_table(l_count).param_data_type := upper('date');
3279: --
3280: --
3281: l_count := l_count + 1;

Line 3302: hr_transaction_ss.g_date_format);

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

Line 3333: hr_transaction_ss.g_date_format);

3329: --
3330: l_count := l_count + 1;
3331: l_transaction_table(l_count).param_name :=upper('p_projected_start_date');
3332: l_transaction_table(l_count).param_value := to_char(p_projected_start_date,
3333: hr_transaction_ss.g_date_format);
3334: l_transaction_table(l_count).param_data_type := upper('date');
3335: --
3336: --
3337: l_count := l_count + 1;

Line 3358: hr_transaction_ss.g_date_format);

3354: --
3355: l_count := l_count + 1;
3356: l_transaction_table(l_count).param_name :=upper('p_resume_last_updated');
3357: l_transaction_table(l_count).param_value := to_char(p_resume_last_updated,
3358: hr_transaction_ss.g_date_format);
3359: l_transaction_table(l_count).param_data_type := upper('date');
3360: --
3361: --
3362: l_count := l_count + 1;

Line 3401: hr_transaction_ss.g_date_format);

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

Line 3432: hr_transaction_ss.g_date_format);

3428: --
3429: l_count := l_count + 1;
3430: l_transaction_table(l_count).param_name :=upper('p_original_date_of_hire');
3431: l_transaction_table(l_count).param_value := to_char(p_original_date_of_hire,
3432: hr_transaction_ss.g_date_format);
3433: l_transaction_table(l_count).param_data_type := upper('date');
3434: --
3435: --
3436: l_count := l_count + 1;

Line 3439: hr_transaction_ss.g_date_format);

3435: --
3436: l_count := l_count + 1;
3437: l_transaction_table(l_count).param_name :=upper('p_adjusted_svc_date');
3438: l_transaction_table(l_count).param_value := to_char(p_adjusted_svc_date,
3439: hr_transaction_ss.g_date_format);
3440: l_transaction_table(l_count).param_data_type := upper('date');
3441: --
3442: --
3443: l_count := l_count + 1;

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

3468: -- ffunction which works for create_contact and update_contact.
3469: --
3470: l_count := l_count + 1;
3471: l_transaction_table(l_count).param_name :=upper('p_start_date');
3472: l_transaction_table(l_count).param_value := to_char(p_date_start, hr_transaction_ss.g_date_format);
3473: l_transaction_table(l_count).param_data_type := upper('date');
3474: --
3475: --
3476: l_count := l_count + 1;

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

3843: l_transaction_table(l_count).param_name :=upper('P_CONT_INFORMATION20');
3844: l_transaction_table(l_count).param_value := P_CONT_INFORMATION20;
3845: l_transaction_table(l_count).param_data_type := upper('varchar2');
3846:
3847: hr_utility.set_location('Before Calling :hr_transaction_ss.save_transaction_step', 75);
3848: hr_utility.set_location('Before Calling :hr_transaction_ss.save_transaction_step '
3849: || to_char(l_transaction_table.count), 75);
3850: --
3851:

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

3844: l_transaction_table(l_count).param_value := P_CONT_INFORMATION20;
3845: l_transaction_table(l_count).param_data_type := upper('varchar2');
3846:
3847: hr_utility.set_location('Before Calling :hr_transaction_ss.save_transaction_step', 75);
3848: hr_utility.set_location('Before Calling :hr_transaction_ss.save_transaction_step '
3849: || to_char(l_transaction_table.count), 75);
3850: --
3851:
3852: -- Bug 3152505 : Added the new transaction var

Line 3859: hr_transaction_ss.save_transaction_step

3855: l_transaction_table(l_count).param_value := p_orig_rel_type;
3856: l_transaction_table(l_count).param_data_type := upper('varchar2');
3857: --
3858:
3859: hr_transaction_ss.save_transaction_step
3860: (p_item_type => p_item_type
3861: ,p_item_key => p_item_key
3862: ,p_login_person_id => nvl(p_login_person_id, p_person_id)
3863: ,p_actid => p_activity_id

Line 6649: l_transaction_table hr_transaction_ss.transaction_table;

6645:
6646: )
6647: IS
6648: l_count INTEGER := 0;
6649: l_transaction_table hr_transaction_ss.transaction_table;
6650: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;
6651: l_object_version_number hr_api_transaction_steps.object_version_number%type;
6652: l_attribute_update_mode varchar2(100) default null;
6653: l_validate_mode boolean default false;

Line 7419: l_transaction_id := hr_transaction_ss.get_transaction_id

7415: --
7416: /* StartRegistration : Begin code addition */
7417: --
7418: -- First, check if transaction id exists or not
7419: l_transaction_id := hr_transaction_ss.get_transaction_id
7420: (p_item_type => p_item_type
7421: ,p_item_key => p_item_key);
7422: --
7423: IF l_transaction_id is null THEN

Line 7425: hr_transaction_ss.start_transaction

7421: ,p_item_key => p_item_key);
7422: --
7423: IF l_transaction_id is null THEN
7424: -- Start a Transaction
7425: hr_transaction_ss.start_transaction
7426: (itemtype => p_item_type
7427: ,itemkey => p_item_key
7428: ,actid => p_activity_id
7429: ,funmode => 'RUN'

Line 7434: l_transaction_id := hr_transaction_ss.get_transaction_id

7430: ,p_api_addtnl_info => p_contact_operation --TEST
7431: ,p_login_person_id => nvl(p_login_person_id, p_person_id)
7432: ,result => l_result);
7433:
7434: l_transaction_id := hr_transaction_ss.get_transaction_id
7435: (p_item_type => p_item_type
7436: ,p_item_key => p_item_key);
7437: END IF;
7438: --

Line 7530: , hr_transaction_ss.g_date_format);

7526: l_count := l_count + 1;
7527: l_transaction_table(l_count).param_name :=upper('p_start_date');
7528: -- l_transaction_table(l_count).param_value := to_char(p_start_date
7529: l_transaction_table(l_count).param_value := to_char(l_start_date
7530: , hr_transaction_ss.g_date_format);
7531: l_transaction_table(l_count).param_data_type := upper('date');
7532: --
7533: --
7534: l_count := l_count + 1;

Line 7573: , hr_transaction_ss.g_date_format);

7569: --
7570: l_count := l_count + 1;
7571: l_transaction_table(l_count).param_name :=upper('p_date_start');
7572: l_transaction_table(l_count).param_value := to_char(p_date_start
7573: , hr_transaction_ss.g_date_format);
7574: l_transaction_table(l_count).param_data_type := upper('date');
7575: --
7576: -- StartRegistration
7577: --

Line 7587: , hr_transaction_ss.g_date_format);

7583: --
7584: l_count := l_count + 1;
7585: l_transaction_table(l_count).param_name :=upper('p_date_end');
7586: l_transaction_table(l_count).param_value := to_char(p_date_end
7587: , hr_transaction_ss.g_date_format);
7588: l_transaction_table(l_count).param_data_type := upper('date');
7589: --
7590: -- StartRegistration
7591: --

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

7791: --
7792: l_count := l_count + 1;
7793: l_transaction_table(l_count).param_name :=upper('p_date_of_birth');
7794: l_transaction_table(l_count).param_value :=
7795: to_char(p_date_of_birth , hr_transaction_ss.g_date_format);
7796: l_transaction_table(l_count).param_data_type := upper('date');
7797: --
7798: --
7799: l_count := l_count + 1;

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

8449: --
8450: l_count := l_count + 1;
8451: l_transaction_table(l_count).param_name :=upper('p_adjusted_svc_date');
8452: l_transaction_table(l_count).param_value :=
8453: to_char(p_adjusted_svc_date , hr_transaction_ss.g_date_format);
8454: l_transaction_table(l_count).param_data_type := upper('date');
8455: --
8456: --
8457: l_count := l_count + 1;

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

8474: --
8475: l_count := l_count + 1;
8476: l_transaction_table(l_count).param_name :=upper('p_background_date_check');
8477: l_transaction_table(l_count).param_value :=
8478: to_char(p_background_date_check , hr_transaction_ss.g_date_format);
8479: l_transaction_table(l_count).param_data_type := upper('date');
8480: --
8481: --
8482: l_count := l_count + 1;

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

8511: --
8512: l_count := l_count + 1;
8513: l_transaction_table(l_count).param_name :=upper('p_date_employee_data_verified');
8514: l_transaction_table(l_count).param_value :=
8515: to_char(p_date_employee_data_verified , hr_transaction_ss.g_date_format);
8516: l_transaction_table(l_count).param_data_type := upper('date');
8517: --
8518: --
8519: l_count := l_count + 1;

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

8518: --
8519: l_count := l_count + 1;
8520: l_transaction_table(l_count).param_name :=upper('p_date_of_death');
8521: l_transaction_table(l_count).param_value :=
8522: to_char(p_date_of_death , 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 8529: to_char(p_dpdnt_adoption_date , hr_transaction_ss.g_date_format);

8525: --
8526: l_count := l_count + 1;
8527: l_transaction_table(l_count).param_name :=upper('p_dpdnt_adoption_date');
8528: l_transaction_table(l_count).param_value :=
8529: to_char(p_dpdnt_adoption_date , hr_transaction_ss.g_date_format);
8530: l_transaction_table(l_count).param_data_type := upper('date');
8531: --
8532: --
8533: l_count := l_count + 1;

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

8568: --
8569: l_count := l_count + 1;
8570: l_transaction_table(l_count).param_name :=upper('p_hold_applicant_date_until');
8571: l_transaction_table(l_count).param_value :=
8572: to_char(p_hold_applicant_date_until , hr_transaction_ss.g_date_format);
8573: l_transaction_table(l_count).param_data_type := upper('date');
8574: --
8575: --
8576: l_count := l_count + 1;

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

8587: --
8588: l_count := l_count + 1;
8589: l_transaction_table(l_count).param_name :=upper('p_last_medical_test_date');
8590: l_transaction_table(l_count).param_value :=
8591: to_char(p_last_medical_test_date , 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 8616: to_char(p_original_date_of_hire , hr_transaction_ss.g_date_format);

8612: --
8613: l_count := l_count + 1;
8614: l_transaction_table(l_count).param_name :=upper('p_original_date_of_hire');
8615: l_transaction_table(l_count).param_value :=
8616: to_char(p_original_date_of_hire , hr_transaction_ss.g_date_format);
8617: l_transaction_table(l_count).param_data_type := upper('date');
8618: --
8619: --
8620: l_count := l_count + 1;

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

8619: --
8620: l_count := l_count + 1;
8621: l_transaction_table(l_count).param_name :=upper('p_projected_start_date');
8622: l_transaction_table(l_count).param_value :=
8623: to_char(p_projected_start_date , hr_transaction_ss.g_date_format);
8624: l_transaction_table(l_count).param_data_type := upper('date');
8625: --
8626: --
8627: l_count := l_count + 1;

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

8626: --
8627: l_count := l_count + 1;
8628: l_transaction_table(l_count).param_name :=upper('p_receipt_of_death_cert_date');
8629: l_transaction_table(l_count).param_value :=
8630: to_char(p_receipt_of_death_cert_date , hr_transaction_ss.g_date_format);
8631: l_transaction_table(l_count).param_data_type := upper('date');
8632: --
8633: --
8634: l_count := l_count + 1;

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

8662: --
8663: --
8664: l_count := l_count + 1;
8665: l_transaction_table(l_count).param_name :=upper('p_resume_last_updated');
8666: l_transaction_table(l_count).param_value := to_char(p_resume_last_updated , hr_transaction_ss.g_date_format);
8667: l_transaction_table(l_count).param_data_type := upper('date');
8668: --
8669: --
8670: l_count := l_count + 1;

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

9079: l_transaction_table(l_count).param_name := 'P_CONTACT_SET';
9080: l_transaction_table(l_count).param_value := l_contact_set;
9081: l_transaction_table(l_count).param_data_type := 'VARCHAR2';
9082: --EndRegistration
9083: hr_utility.set_location('Before Calling :hr_transaction_ss.save_transaction_step', 90);
9084: --
9085: hr_transaction_ss.save_transaction_step
9086: (p_item_type => p_item_type
9087: ,p_item_key => p_item_key

Line 9085: hr_transaction_ss.save_transaction_step

9081: l_transaction_table(l_count).param_data_type := 'VARCHAR2';
9082: --EndRegistration
9083: hr_utility.set_location('Before Calling :hr_transaction_ss.save_transaction_step', 90);
9084: --
9085: hr_transaction_ss.save_transaction_step
9086: (p_item_type => p_item_type
9087: ,p_item_key => p_item_key
9088: ,p_login_person_id => nvl(p_login_person_id, p_person_id) -- Registration
9089: -- ,p_login_person_id => p_person_id

Line 9587: hr_transaction_ss.get_wf_effective_date

9583: --
9584: else
9585: --
9586: l_effective_date:= to_date(
9587: hr_transaction_ss.get_wf_effective_date
9588: (p_transaction_step_id => p_transaction_step_id),g_date_format);
9589: --
9590: end if;
9591: --

Line 12381: hr_transaction_ss.get_wf_effective_date

12377: l_effective_date:= to_date(p_effective_date,g_date_format);
12378:
12379: else
12380: l_effective_date:= to_date(
12381: hr_transaction_ss.get_wf_effective_date
12382: (p_transaction_step_id => p_transaction_step_id),g_date_format);
12383:
12384: end if;
12385: --

Line 14885: l_transaction_table hr_transaction_ss.transaction_table;

14881: where contact_relationship_id = p_contact_relationship_id
14882: and trunc(sysdate) between nvl(date_start, trunc(sysdate))
14883: and nvl(date_end, trunc(sysdate));
14884:
14885: l_transaction_table hr_transaction_ss.transaction_table;
14886: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;
14887: l_trs_object_version_number hr_api_transaction_steps.object_version_number%type;
14888: l_old_ovn number;
14889: l_old_contact_relationship_id number;

Line 15036: hr_transaction_ss.g_date_format);

15032: --
15033: l_count := l_count + 1;
15034: l_transaction_table(l_count).param_name := 'P_EFFECTIVE_DATE';
15035: l_transaction_table(l_count).param_value := to_char(P_EFFECTIVE_DATE,
15036: hr_transaction_ss.g_date_format);
15037: l_transaction_table(l_count).param_data_type := 'DATE';
15038: --
15039: l_count:=l_count+1;
15040: l_transaction_table(l_count).param_name := 'P_SAVE_MODE';

Line 15117: hr_transaction_ss.g_date_format);

15113: --
15114: l_count := l_count + 1;
15115: l_transaction_table(l_count).param_name := 'P_DATE_START';
15116: l_transaction_table(l_count).param_value := to_char(P_DATE_START,
15117: hr_transaction_ss.g_date_format);
15118: l_transaction_table(l_count).param_data_type := 'DATE';
15119: --
15120: l_count := l_count + 1;
15121: l_transaction_table(l_count).param_name := 'P_START_LIFE_REASON_ID';

Line 15129: hr_transaction_ss.g_date_format);

15125: hr_utility.set_location('P_DATE_END = ' || to_char(P_DATE_END), 30);
15126: l_count := l_count + 1;
15127: l_transaction_table(l_count).param_name := 'P_DATE_END';
15128: l_transaction_table(l_count).param_value := to_char(P_DATE_END,
15129: hr_transaction_ss.g_date_format);
15130: l_transaction_table(l_count).param_data_type := 'DATE';
15131: --
15132: l_count := l_count + 1;
15133: l_transaction_table(l_count).param_name := 'P_END_LIFE_REASON_ID';

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

15323: l_transaction_table(l_count).param_name := 'P_OTHER_REL_OBJ_VER_NO';
15324: l_transaction_table(l_count).param_value := l_other_rel_object_ver_no;
15325: l_transaction_table(l_count).param_data_type := 'NUMBER';
15326:
15327: hr_utility.set_location('Before Calling :hr_transaction_ss.save_transaction_step', 30);
15328: hr_utility.set_location('Before Calling :hr_transaction_ss.save_transaction_step ' || to_char(l_transaction_table.count), 35);
15329: --
15330: hr_transaction_ss.save_transaction_step
15331: (p_item_type => p_item_type

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

15324: l_transaction_table(l_count).param_value := l_other_rel_object_ver_no;
15325: l_transaction_table(l_count).param_data_type := 'NUMBER';
15326:
15327: hr_utility.set_location('Before Calling :hr_transaction_ss.save_transaction_step', 30);
15328: hr_utility.set_location('Before Calling :hr_transaction_ss.save_transaction_step ' || to_char(l_transaction_table.count), 35);
15329: --
15330: hr_transaction_ss.save_transaction_step
15331: (p_item_type => p_item_type
15332: ,p_item_key => p_item_key

Line 15330: hr_transaction_ss.save_transaction_step

15326:
15327: hr_utility.set_location('Before Calling :hr_transaction_ss.save_transaction_step', 30);
15328: hr_utility.set_location('Before Calling :hr_transaction_ss.save_transaction_step ' || to_char(l_transaction_table.count), 35);
15329: --
15330: hr_transaction_ss.save_transaction_step
15331: (p_item_type => p_item_type
15332: ,p_item_key => p_item_key
15333: ,p_login_person_id => nvl(p_login_person_id,p_person_id)
15334: ,p_actid => p_activity_id

Line 15413: hr_transaction_ss.get_wf_effective_date

15409: else
15410: --
15411: hr_utility.set_location('Eff date is Null:'||l_proc, 15);
15412: l_effective_date:= to_date(
15413: hr_transaction_ss.get_wf_effective_date
15414: (p_transaction_step_id => p_transaction_step_id),g_date_format);
15415: --
15416: end if;
15417: -- For normal commit the effective date should come from txn tbales.

Line 15817: hr_transaction_ss.delete_transaction_step

15813: l_contact_set := 1;
15814: end if;
15815:
15816: if l_contact_set >= l_wf_contact_set then
15817: hr_transaction_ss.delete_transaction_step
15818: (p_transaction_step_id => l_trans_step_ids(i)
15819: ,p_object_version_number => l_trans_obj_vers_num(i)
15820: ,p_login_person_id => p_login_person_id);
15821: end if;

Line 15910: hr_transaction_ss.delete_transaction_step

15906:
15907: -- When the procedure is called from 'Do not add Contacts'
15908: -- button in 'Add contacts yes no' page
15909: if p_mode = 'ALL' then
15910: hr_transaction_ss.delete_transaction_step
15911: (p_transaction_step_id => l_trans_step_ids(i)
15912: ,p_object_version_number => l_trans_obj_vers_num(i)
15913: ,p_login_person_id => p_login_person_id);
15914:

Line 15919: hr_transaction_ss.delete_transaction_step

15915: -- When the procedure is called from 'add another Contact'
15916: -- button in contacts page
15917: elsif p_mode = 'THIS' then
15918: if l_contact_set = l_wf_contact_set then
15919: hr_transaction_ss.delete_transaction_step
15920: (p_transaction_step_id => l_trans_step_ids(i)
15921: ,p_object_version_number => l_trans_obj_vers_num(i)
15922: ,p_login_person_id => p_login_person_id);
15923: end if;

Line 15929: hr_transaction_ss.delete_transaction_step

15925: -- When the procedure is called from 'Next' button
15926: -- in contacts page
15927: elsif p_mode = 'THIS AND ABOVE' then
15928: if l_contact_set >= l_wf_contact_set then
15929: hr_transaction_ss.delete_transaction_step
15930: (p_transaction_step_id => l_trans_step_ids(i)
15931: ,p_object_version_number => l_trans_obj_vers_num(i)
15932: ,p_login_person_id => p_login_person_id);
15933: end if;