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.3.12010000.2 2008/08/06 08:31:13 ubhat 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 455: l_transaction_id := hr_transaction_ss.get_transaction_id

451: END IF;
452: --
453: -- First, check if transaction id exists or not
454: --
455: l_transaction_id := hr_transaction_ss.get_transaction_id
456: (p_item_type => p_item_type
457: ,p_item_key => p_item_key);
458: --
459: IF l_transaction_id is null THEN

Line 464: hr_transaction_ss.start_transaction

460: hr_utility.set_location(l_proc,45);
461:
462: -- Start a Transaction
463:
464: hr_transaction_ss.start_transaction
465: (itemtype => p_item_type
466: ,itemkey => p_item_key
467: ,actid => p_activity_id
468: ,funmode => 'RUN'

Line 473: l_transaction_id := hr_transaction_ss.get_transaction_id

469: ,p_api_addtnl_info => p_contact_or_person
470: ,p_login_person_id => nvl(p_login_person_id, p_person_id) -- PB : Modification
471: ,result => l_result);
472:
473: l_transaction_id := hr_transaction_ss.get_transaction_id
474: (p_item_type => p_item_type
475: ,p_item_key => p_item_key);
476: END IF;
477: --

Line 509: hr_transaction_ss.g_date_format);

505:
506: l_count := l_count + 1;
507: l_transaction_table(l_count).param_name := 'P_EFFECTIVE_DATE';
508: l_transaction_table(l_count).param_value := to_char(p_effective_date,
509: hr_transaction_ss.g_date_format);
510: l_transaction_table(l_count).param_data_type := 'DATE';
511:
512: -- l_count := l_count + 1;
513: -- l_transaction_table(l_count).param_name := 'P_USER_DATE_FORMAT';

Line 621: hr_transaction_ss.g_date_format);

617:
618: l_count := l_count + 1;
619: l_transaction_table(l_count).param_name := 'P_DATE_FROM';
620: l_transaction_table(l_count).param_value := to_char(p_date_from,
621: hr_transaction_ss.g_date_format);
622: l_transaction_table(l_count).param_data_type := 'DATE';
623:
624: l_count := l_count + 1;
625: l_transaction_table(l_count).param_name := 'P_DATE_TO';

Line 627: hr_transaction_ss.g_date_format);

623:
624: l_count := l_count + 1;
625: l_transaction_table(l_count).param_name := 'P_DATE_TO';
626: l_transaction_table(l_count).param_value := to_char(p_date_to,
627: hr_transaction_ss.g_date_format);
628: l_transaction_table(l_count).param_data_type := 'DATE';
629:
630: l_count := l_count + 1;
631: l_transaction_table(l_count).param_name := 'P_STYLE';

Line 868: hr_transaction_ss.save_transaction_step

864: l_transaction_table(l_count).param_value := p_contact_relationship_id;
865: l_transaction_table(l_count).param_data_type := 'NUMBER';
866: end if;
867: --EndRegistration gsheelum
868: hr_transaction_ss.save_transaction_step
869: (p_item_type => p_item_type
870: ,p_item_key => p_item_key
871: ,p_actid => p_activity_id
872: ,p_login_person_id => nvl(p_login_person_id, p_person_id) -- PB Modification

Line 1152: l_transaction_id := hr_transaction_ss.get_transaction_id

1148: aname => 'CURRENT_EFFECTIVE_DATE',
1149: avalue => p_effective_date);
1150:
1151: -- First, check if transaction id exists or not
1152: l_transaction_id := hr_transaction_ss.get_transaction_id
1153: (p_item_type => p_item_type
1154: ,p_item_key => p_item_key);
1155: --
1156: IF l_transaction_id is null THEN

Line 1159: hr_transaction_ss.start_transaction

1155: --
1156: IF l_transaction_id is null THEN
1157: hr_utility.set_location( l_proc,35);
1158: -- Start a Transaction
1159: hr_transaction_ss.start_transaction
1160: (itemtype => p_item_type
1161: ,itemkey => p_item_key
1162: ,actid => p_activity_id
1163: ,funmode => 'RUN'

Line 1172: l_transaction_id := hr_transaction_ss.get_transaction_id

1168: --
1169: ,p_login_person_id => nvl(p_login_person_id, p_person_id)
1170: ,result => l_result);
1171:
1172: l_transaction_id := hr_transaction_ss.get_transaction_id
1173: (p_item_type => p_item_type
1174: ,p_item_key => p_item_key);
1175: END IF;
1176: --

Line 1210: hr_transaction_ss.g_date_format);

1206:
1207: l_count := l_count + 1;
1208: l_transaction_table(l_count).param_name := 'P_EFFECTIVE_DATE';
1209: l_transaction_table(l_count).param_value := to_char(p_effective_date,
1210: hr_transaction_ss.g_date_format);
1211: l_transaction_table(l_count).param_data_type := 'DATE';
1212:
1213:
1214: -- l_count := l_count + 1;

Line 1313: hr_transaction_ss.g_date_format);

1309:
1310: l_count := l_count + 1;
1311: l_transaction_table(l_count).param_name := 'P_DATE_FROM';
1312: l_transaction_table(l_count).param_value := to_char(p_date_from,
1313: hr_transaction_ss.g_date_format);
1314: l_transaction_table(l_count).param_data_type := 'DATE';
1315:
1316: l_count := l_count + 1;
1317: l_transaction_table(l_count).param_name := 'P_DATE_TO';

Line 1319: hr_transaction_ss.g_date_format);

1315:
1316: l_count := l_count + 1;
1317: l_transaction_table(l_count).param_name := 'P_DATE_TO';
1318: l_transaction_table(l_count).param_value := to_char(p_date_to,
1319: hr_transaction_ss.g_date_format);
1320: l_transaction_table(l_count).param_data_type := 'DATE';
1321:
1322: l_count := l_count + 1;
1323: l_transaction_table(l_count).param_name := 'P_STYLE';

Line 1534: hr_transaction_ss.save_transaction_step

1530: l_transaction_table(l_count).param_data_type := 'NUMBER';
1531: end if;
1532:
1533:
1534: hr_transaction_ss.save_transaction_step
1535: (p_item_type => p_item_type
1536: ,p_item_key => p_item_key
1537: ,p_login_person_id => nvl(p_login_person_id, p_person_id )
1538: ,p_actid => p_activity_id

Line 2081: hr_transaction_ss.get_wf_effective_date

2077: hr_utility.set_location(' Entering:' || l_proc,5);
2078:
2079: --
2080: p_effective_date:= to_date(
2081: hr_transaction_ss.get_wf_effective_date
2082: (p_transaction_step_id => p_transaction_step_id),g_date_format);
2083: --
2084: p_person_id := hr_transaction_api.get_number_value
2085: (p_transaction_step_id => p_transaction_step_id

Line 2465: hr_transaction_ss.get_wf_effective_date

2461: l_effective_date:= to_date(p_effective_date,g_date_format);
2462: else
2463: hr_utility.set_location( l_proc, 15);
2464: l_effective_date:= to_date(
2465: hr_transaction_ss.get_wf_effective_date
2466: (p_transaction_step_id => p_transaction_step_id),g_date_format);
2467: end if;
2468:
2469: -- ------------------------------------------------------------