DBA Data[Home] [Help]

APPS.OTA_EL_TRAINING_SS dependencies on HR_TRANSACTION_SS

Line 58: l_transaction_table hr_transaction_ss.transaction_table;

54: l_transaction_id number ;
55: l_transaction_step_id number ;
56: l_trans_obj_vers_num number ;
57: l_count integer ;
58: l_transaction_table hr_transaction_ss.transaction_table;
59: l_review_item_name varchar2(50);
60: l_message_number VARCHAR2(10);
61: l_result varchar2(100) ;
62: l_old_transaction_step_id number;

Line 69: l_transaction_id := hr_transaction_ss.get_transaction_id

65: begin
66:
67: --
68: -- First, check if transaction id exists or not
69: l_transaction_id := hr_transaction_ss.get_transaction_id
70: (p_item_type => p_item_type
71: ,p_item_key => p_item_key);
72: --
73: IF l_transaction_id is null THEN

Line 75: hr_transaction_ss.start_transaction

71: ,p_item_key => p_item_key);
72: --
73: IF l_transaction_id is null THEN
74: -- Start a Transaction
75: hr_transaction_ss.start_transaction
76: (itemtype => p_item_type
77: ,itemkey => p_item_key
78: ,actid => p_activity_id
79: ,funmode => 'RUN'

Line 83: l_transaction_id := hr_transaction_ss.get_transaction_id

79: ,funmode => 'RUN'
80: ,p_login_person_id => p_login_person_id
81: ,result => l_result);
82:
83: l_transaction_id := hr_transaction_ss.get_transaction_id
84: (p_item_type => p_item_type
85: ,p_item_key => p_item_key);
86: END IF;
87:

Line 166: hr_transaction_ss.save_transaction_step

162: l_transaction_table(l_count).param_name := 'P_REVIEW_ACTID';
163: l_transaction_table(l_count).param_value := p_activity_id;
164: l_transaction_table(l_count).param_data_type := 'VARCHAR2';
165:
166: hr_transaction_ss.save_transaction_step
167: (p_item_type => p_item_type
168: ,p_item_key => p_item_key
169: ,p_actid => p_activity_id
170: ,p_login_person_id => p_login_person_id

Line 249: l_transaction_table hr_transaction_ss.transaction_table;

245: l_transaction_id number ;
246: l_transaction_step_id number ;
247: l_trans_obj_vers_num number ;
248: l_count integer ;
249: l_transaction_table hr_transaction_ss.transaction_table;
250: l_review_item_name varchar2(50);
251: l_message_number VARCHAR2(10);
252: l_result varchar2(100) ;
253: l_old_transaction_step_id number;

Line 259: l_transaction_id := hr_transaction_ss.get_transaction_id

255:
256: begin
257:
258: -- First, check if transaction id exists or not
259: l_transaction_id := hr_transaction_ss.get_transaction_id
260: (p_item_type => p_item_type
261: ,p_item_key => p_item_key);
262: --
263: IF l_transaction_id is null THEN

Line 265: hr_transaction_ss.start_transaction

261: ,p_item_key => p_item_key);
262: --
263: IF l_transaction_id is null THEN
264: -- Start a Transaction
265: hr_transaction_ss.start_transaction
266: (itemtype => p_item_type
267: ,itemkey => p_item_key
268: ,actid => p_activity_id
269: ,funmode => 'RUN'

Line 273: l_transaction_id := hr_transaction_ss.get_transaction_id

269: ,funmode => 'RUN'
270: ,p_login_person_id => p_login_person_id
271: ,result => l_result);
272:
273: l_transaction_id := hr_transaction_ss.get_transaction_id
274: (p_item_type => p_item_type
275: ,p_item_key => p_item_key);
276: END IF;
277:

Line 534: hr_transaction_ss.save_transaction_step

530: 'OTA_TRANSACTION_STEP_ID',
531: l_transaction_step_id);
532:
533:
534: hr_transaction_ss.save_transaction_step
535: (p_item_type => p_item_type
536: ,p_item_key => p_item_key
537: ,p_actid => p_activity_id
538: ,p_login_person_id => p_login_person_id

Line 1094: l_transaction_table hr_transaction_ss.transaction_table;

1090: l_item_type HR_API_TRANSACTION_STEPS.ITEM_TYPE%TYPE;
1091: l_item_key HR_API_TRANSACTION_STEPS.ITEM_KEY%TYPE;
1092: l_activity_id HR_API_TRANSACTION_STEPS.ACTIVITY_ID%TYPE;
1093: l_transaction_step_id HR_API_TRANSACTION_STEPS.TRANSACTION_STEP_ID%TYPE;
1094: l_transaction_table hr_transaction_ss.transaction_table;
1095: l_from varchar2(15);
1096: l_cancel_boolean BOOLEAN;
1097: l_auto_create_finance VARCHAR2(40);
1098: l_price_basis OTA_EVENTS.price_basis%TYPE;

Line 1425: hr_transaction_ss.get_transaction_id

1421: l_item_key,
1422: 'TRANSACTION_ID',
1423: --Bug#4617150
1424: -- hr_transaction_web.get_transaction_id
1425: hr_transaction_ss.get_transaction_id
1426: (p_item_type => l_item_type
1427: ,p_item_key => l_item_key));
1428:
1429: