DBA Data[Home] [Help]

APPS.HR_PROCESS_ADDRESS_SS dependencies on HR_TRANSACTION_SS

Line 5: l_transaction_table hr_transaction_ss.transaction_table;

1: PACKAGE BODY hr_process_address_ss AS
2: /* $Header: hraddwrs.pkb 120.7 2011/11/15 12:01:41 sidsaxen ship $*/
3:
4: -- Package scope global variables.
5: l_transaction_table hr_transaction_ss.transaction_table;
6: l_count INTEGER := 0;
7: l_praddr_ovrlap VARCHAR2(2);
8: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;
9: l_trs_object_version_number hr_api_transaction_steps.object_version_number%type;

Line 463: l_transaction_id := hr_transaction_ss.get_transaction_id

459: END IF;
460: --
461: -- First, check if transaction id exists or not
462: --
463: l_transaction_id := hr_transaction_ss.get_transaction_id
464: (p_item_type => p_item_type
465: ,p_item_key => p_item_key);
466: --
467: IF l_transaction_id is null THEN

Line 472: hr_transaction_ss.start_transaction

468: hr_utility.set_location(l_proc,45);
469:
470: -- Start a Transaction
471:
472: hr_transaction_ss.start_transaction
473: (itemtype => p_item_type
474: ,itemkey => p_item_key
475: ,actid => p_activity_id
476: ,funmode => 'RUN'

Line 481: l_transaction_id := hr_transaction_ss.get_transaction_id

477: ,p_api_addtnl_info => p_contact_or_person
478: ,p_login_person_id => nvl(p_login_person_id, p_person_id) -- PB : Modification
479: ,result => l_result);
480:
481: l_transaction_id := hr_transaction_ss.get_transaction_id
482: (p_item_type => p_item_type
483: ,p_item_key => p_item_key);
484: END IF;
485: --

Line 517: hr_transaction_ss.g_date_format);

513:
514: l_count := l_count + 1;
515: l_transaction_table(l_count).param_name := 'P_EFFECTIVE_DATE';
516: l_transaction_table(l_count).param_value := to_char(p_effective_date,
517: hr_transaction_ss.g_date_format);
518: l_transaction_table(l_count).param_data_type := 'DATE';
519:
520: -- l_count := l_count + 1;
521: -- l_transaction_table(l_count).param_name := 'P_USER_DATE_FORMAT';

Line 629: hr_transaction_ss.g_date_format);

625:
626: l_count := l_count + 1;
627: l_transaction_table(l_count).param_name := 'P_DATE_FROM';
628: l_transaction_table(l_count).param_value := to_char(p_date_from,
629: hr_transaction_ss.g_date_format);
630: l_transaction_table(l_count).param_data_type := 'DATE';
631:
632: l_count := l_count + 1;
633: l_transaction_table(l_count).param_name := 'P_DATE_TO';

Line 635: hr_transaction_ss.g_date_format);

631:
632: l_count := l_count + 1;
633: l_transaction_table(l_count).param_name := 'P_DATE_TO';
634: l_transaction_table(l_count).param_value := to_char(p_date_to,
635: hr_transaction_ss.g_date_format);
636: l_transaction_table(l_count).param_data_type := 'DATE';
637:
638: l_count := l_count + 1;
639: l_transaction_table(l_count).param_name := 'P_STYLE';

Line 876: hr_transaction_ss.save_transaction_step

872: l_transaction_table(l_count).param_value := p_contact_relationship_id;
873: l_transaction_table(l_count).param_data_type := 'NUMBER';
874: end if;
875: --EndRegistration gsheelum
876: hr_transaction_ss.save_transaction_step
877: (p_item_type => p_item_type
878: ,p_item_key => p_item_key
879: ,p_actid => p_activity_id
880: ,p_login_person_id => nvl(p_login_person_id, p_person_id) -- PB Modification

Line 1160: l_transaction_id := hr_transaction_ss.get_transaction_id

1156: aname => 'CURRENT_EFFECTIVE_DATE',
1157: avalue => p_effective_date);
1158:
1159: -- First, check if transaction id exists or not
1160: l_transaction_id := hr_transaction_ss.get_transaction_id
1161: (p_item_type => p_item_type
1162: ,p_item_key => p_item_key);
1163: --
1164: IF l_transaction_id is null THEN

Line 1167: hr_transaction_ss.start_transaction

1163: --
1164: IF l_transaction_id is null THEN
1165: hr_utility.set_location( l_proc,35);
1166: -- Start a Transaction
1167: hr_transaction_ss.start_transaction
1168: (itemtype => p_item_type
1169: ,itemkey => p_item_key
1170: ,actid => p_activity_id
1171: ,funmode => 'RUN'

Line 1180: l_transaction_id := hr_transaction_ss.get_transaction_id

1176: --
1177: ,p_login_person_id => nvl(p_login_person_id, p_person_id)
1178: ,result => l_result);
1179:
1180: l_transaction_id := hr_transaction_ss.get_transaction_id
1181: (p_item_type => p_item_type
1182: ,p_item_key => p_item_key);
1183: END IF;
1184: --

Line 1218: hr_transaction_ss.g_date_format);

1214:
1215: l_count := l_count + 1;
1216: l_transaction_table(l_count).param_name := 'P_EFFECTIVE_DATE';
1217: l_transaction_table(l_count).param_value := to_char(p_effective_date,
1218: hr_transaction_ss.g_date_format);
1219: l_transaction_table(l_count).param_data_type := 'DATE';
1220:
1221:
1222: -- l_count := l_count + 1;

Line 1321: hr_transaction_ss.g_date_format);

1317:
1318: l_count := l_count + 1;
1319: l_transaction_table(l_count).param_name := 'P_DATE_FROM';
1320: l_transaction_table(l_count).param_value := to_char(p_date_from,
1321: hr_transaction_ss.g_date_format);
1322: l_transaction_table(l_count).param_data_type := 'DATE';
1323:
1324: l_count := l_count + 1;
1325: l_transaction_table(l_count).param_name := 'P_DATE_TO';

Line 1327: hr_transaction_ss.g_date_format);

1323:
1324: l_count := l_count + 1;
1325: l_transaction_table(l_count).param_name := 'P_DATE_TO';
1326: l_transaction_table(l_count).param_value := to_char(p_date_to,
1327: hr_transaction_ss.g_date_format);
1328: l_transaction_table(l_count).param_data_type := 'DATE';
1329:
1330: l_count := l_count + 1;
1331: l_transaction_table(l_count).param_name := 'P_STYLE';

Line 1542: hr_transaction_ss.save_transaction_step

1538: l_transaction_table(l_count).param_data_type := 'NUMBER';
1539: end if;
1540:
1541:
1542: hr_transaction_ss.save_transaction_step
1543: (p_item_type => p_item_type
1544: ,p_item_key => p_item_key
1545: ,p_login_person_id => nvl(p_login_person_id, p_person_id )
1546: ,p_actid => p_activity_id

Line 2089: hr_transaction_ss.get_wf_effective_date

2085: hr_utility.set_location(' Entering:' || l_proc,5);
2086:
2087: --
2088: p_effective_date:= to_date(
2089: hr_transaction_ss.get_wf_effective_date
2090: (p_transaction_step_id => p_transaction_step_id),g_date_format);
2091: --
2092: p_person_id := hr_transaction_api.get_number_value
2093: (p_transaction_step_id => p_transaction_step_id

Line 2473: hr_transaction_ss.get_wf_effective_date

2469: l_effective_date:= to_date(p_effective_date,g_date_format);
2470: else
2471: hr_utility.set_location( l_proc, 15);
2472: l_effective_date:= to_date(
2473: hr_transaction_ss.get_wf_effective_date
2474: (p_transaction_step_id => p_transaction_step_id),g_date_format);
2475: end if;
2476:
2477: -- ------------------------------------------------------------