DBA Data[Home] [Help]

APPS.PAY_BEE_SS dependencies on HR_TRANSACTION_SS

Line 28: l_transaction_table hr_transaction_ss.transaction_table;

24: l_transaction_id number default null;
25: l_transaction_step_id number default null;
26: l_trans_obj_vers_num number default null;
27: l_count integer default 0;
28: l_transaction_table hr_transaction_ss.transaction_table;
29: l_result varchar2(50);
30: l_trans_step_ids hr_util_web.g_varchar2_tab_type;
31: l_api_names hr_util_web.g_varchar2_tab_type;
32: l_trans_step_rows NUMBER ;

Line 48: l_transaction_id := hr_transaction_ss.get_transaction_id

44: p_batch_id :=0;
45:
46: -- Start a transaction
47:
48: l_transaction_id := hr_transaction_ss.get_transaction_id
49: (p_item_type => p_item_type
50: ,p_item_key => p_item_key);
51:
52:

Line 60: hr_transaction_ss.start_transaction

56: --
57: IF l_transaction_id is null THEN
58: -- Start a Transaction
59: hr_utility.set_location('l_transaction_id is null THEN:'||l_proc,105);
60: hr_transaction_ss.start_transaction
61: (itemtype => p_item_type
62: ,itemkey => p_item_key
63: ,actid => p_actid
64: ,funmode => 'RUN'

Line 68: l_transaction_id := hr_transaction_ss.get_transaction_id

64: ,funmode => 'RUN'
65: ,p_login_person_id => p_login_person_id --nvl(p_login_person_id, p_parent_id)
66: ,result => l_result);
67:
68: l_transaction_id := hr_transaction_ss.get_transaction_id
69: (p_item_type => p_item_type
70: ,p_item_key => p_item_key);
71: END IF;
72: ------------------

Line 182: hr_transaction_ss.save_transaction_step

178: l_transaction_table(l_count).param_data_type := 'DATE';
179:
180:
181:
182: hr_transaction_ss.save_transaction_step
183: (p_item_type => p_item_type
184: ,p_item_key => p_item_key
185: ,p_actid => p_actid
186: ,p_login_person_id => p_login_person_id

Line 228: l_transaction_table hr_transaction_ss.transaction_table;

224: l_transaction_id number default null;
225: l_transaction_step_id number default null;
226: l_trans_obj_vers_num number default null;
227: l_count integer default 0;
228: l_transaction_table hr_transaction_ss.transaction_table;
229: l_result varchar2(50);
230: l_trans_step_ids hr_util_web.g_varchar2_tab_type;
231: l_api_names hr_util_web.g_varchar2_tab_type;
232: l_trans_step_rows NUMBER ;

Line 243: l_transaction_id := hr_transaction_ss.get_transaction_id

239: l_flag number;
240:
241: begin
242: -- -- -- bee_trace('Exception:Others 12'||l_proc);
243: l_transaction_id := hr_transaction_ss.get_transaction_id
244: (p_item_type => p_item_type
245: ,p_item_key => p_item_key);
246: -- -- -- bee_trace('Exception:Others 13'||l_proc);
247:

Line 357: hr_transaction_ss.save_transaction_step

353: l_transaction_table(l_count).param_value := TO_CHAR(to_date(p_effective_date,'YYYY-MM-DD'),'RRRR/MM/DD');
354: l_transaction_table(l_count).param_data_type := 'DATE';
355:
356:
357: hr_transaction_ss.save_transaction_step
358: (p_item_type => p_item_type
359: ,p_item_key => p_item_key
360: ,p_actid => p_actid
361: ,p_login_person_id => p_login_person_id

Line 391: l_transaction_table hr_transaction_ss.transaction_table;

387: l_transaction_id number default null;
388: l_transaction_step_id number default null;
389: l_trans_obj_vers_num number default null;
390: l_count integer default 0;
391: l_transaction_table hr_transaction_ss.transaction_table;
392: l_result varchar2(50);
393: l_trans_step_ids hr_util_web.g_varchar2_tab_type;
394: l_api_names hr_util_web.g_varchar2_tab_type;
395: l_trans_step_rows NUMBER ;

Line 406: l_transaction_id := hr_transaction_ss.get_transaction_id

402: l_flag number;
403:
404: begin
405: ---- -- bee_trace('Exception:Others 12'||l_proc);
406: l_transaction_id := hr_transaction_ss.get_transaction_id
407: (p_item_type => p_item_type
408: ,p_item_key => p_item_key);
409: ---- -- bee_trace('Exception:Others 13'||l_proc);
410:

Line 520: hr_transaction_ss.save_transaction_step

516: l_transaction_table(l_count).param_value := TO_CHAR(to_date(p_effective_date,'YYYY-MM-DD'),'RRRR/MM/DD');
517: l_transaction_table(l_count).param_data_type := 'DATE';
518:
519: ---- -- bee_trace('Exception:Others 15'||l_proc);
520: hr_transaction_ss.save_transaction_step
521: (p_item_type => p_item_type
522: ,p_item_key => p_item_key
523: ,p_actid => p_actid
524: ,p_login_person_id => p_login_person_id

Line 548: l_transaction_table hr_transaction_ss.transaction_table;

544: l_transaction_id number default null;
545: l_transaction_step_id number default null;
546: l_trans_obj_vers_num number default null;
547: l_count integer default 0;
548: l_transaction_table hr_transaction_ss.transaction_table;
549: l_result varchar2(50);
550: l_trans_step_ids hr_util_web.g_varchar2_tab_type;
551: l_api_names hr_util_web.g_varchar2_tab_type;
552: l_trans_step_rows NUMBER ;

Line 564: l_transaction_id := hr_transaction_ss.get_transaction_id

560: l_element_type_id number;
561: l_input_value_id number;
562:
563: begin
564: l_transaction_id := hr_transaction_ss.get_transaction_id
565: (p_item_type => p_item_type
566: ,p_item_key => p_item_key);
567: -- -- -- bee_trace('Exception:Others 13'||l_proc);
568:

Line 627: hr_transaction_ss.save_transaction_step

623: l_transaction_table(l_count).param_data_type := 'VARCHAR2';
624:
625: -- -- -- bee_trace('Exception:Others 16'||to_char(p_input_value));
626:
627: hr_transaction_ss.save_transaction_step
628: (p_item_type => p_item_type
629: ,p_item_key => p_item_key
630: ,p_actid => p_actid
631: ,p_login_person_id => p_login_person_id

Line 649: l_transaction_table hr_transaction_ss.transaction_table;

645: l_transaction_id number default null;
646: l_transaction_step_id number default null;
647: l_trans_obj_vers_num number default null;
648: l_count integer default 0;
649: l_transaction_table hr_transaction_ss.transaction_table;
650: l_result varchar2(50);
651: l_trans_step_ids hr_util_web.g_varchar2_tab_type;
652: l_api_names hr_util_web.g_varchar2_tab_type;
653: l_trans_step_rows NUMBER ;

Line 665: l_transaction_id := hr_transaction_ss.get_transaction_id

661: l_element_type_id number;
662: l_input_value_id number;
663:
664: begin
665: l_transaction_id := hr_transaction_ss.get_transaction_id
666: (p_item_type => p_item_type
667: ,p_item_key => p_item_key);
668: -- -- -- bee_trace('Exception:Others 13'||l_proc);
669:

Line 728: hr_transaction_ss.save_transaction_step

724: l_transaction_table(l_count).param_data_type := 'VARCHAR2';
725:
726: -- -- -- bee_trace('Exception:Others 16'||to_char(p_input_value));
727:
728: hr_transaction_ss.save_transaction_step
729: (p_item_type => p_item_type
730: ,p_item_key => p_item_key
731: ,p_actid => p_actid
732: ,p_login_person_id => p_login_person_id

Line 1544: l_transaction_id := hr_transaction_ss.get_transaction_id

1540: l_result varchar2(50);
1541:
1542: begin
1543:
1544: l_transaction_id := hr_transaction_ss.get_transaction_id
1545: (p_item_type => p_item_type
1546: ,p_item_key => p_item_key);
1547:
1548:

Line 1570: hr_transaction_ss.start_transaction

1566: --
1567: IF l_transaction_id is null THEN
1568: -- Start a Transaction
1569: -- hr_utility.set_location('l_transaction_id is null THEN:'||l_proc,105);
1570: hr_transaction_ss.start_transaction
1571: (itemtype => p_item_type
1572: ,itemkey => p_item_key
1573: ,actid => p_actid
1574: ,funmode => 'RUN'

Line 1578: l_transaction_id := hr_transaction_ss.get_transaction_id

1574: ,funmode => 'RUN'
1575: ,p_login_person_id => p_login_person_id --nvl(p_login_person_id, p_parent_id)
1576: ,result => l_result);
1577:
1578: l_transaction_id := hr_transaction_ss.get_transaction_id
1579: (p_item_type => p_item_type
1580: ,p_item_key => p_item_key);
1581: END IF;
1582: