APPS.OTA_ADD_TRAINING_SS dependencies on HR_TRANSACTION_SS

Line 100: l_transaction_table hr_transaction_ss.transaction_table;

96: l_transaction_id NUMBER ;
97: l_transaction_step_id NUMBER ;
98: l_trans_obj_vers_num NUMBER ;
99: l_count INTEGER ;
100: l_transaction_table hr_transaction_ss.transaction_table;
101: l_review_item_name VARCHAR2(50);
102: l_message_number VARCHAR2(10);
103: l_result VARCHAR2(100) ;
104: l_old_transaction_step_id NUMBER;

Line 112: l_transaction_id := hr_transaction_ss.get_transaction_id

108: --
109: BEGIN
110: --
111: -- First, check if transaction id exists or not
112: l_transaction_id := hr_transaction_ss.get_transaction_id
113: (p_item_type => p_item_type
114: ,p_item_key => p_item_key);
115: --
116: IF l_transaction_id is null THEN

Line 118: hr_transaction_ss.start_transaction

114: ,p_item_key => p_item_key);
115: --
116: IF l_transaction_id is null THEN
117: -- Start a Transaction
118: hr_transaction_ss.start_transaction
119: (itemtype => p_item_type
120: ,itemkey => p_item_key
121: ,actid => p_activity_id
122: ,funmode => 'RUN'

Line 125: l_transaction_id := hr_transaction_ss.get_transaction_id

121: ,actid => p_activity_id
122: ,funmode => 'RUN'
123: ,p_login_person_id => p_login_person_id
124: ,result => l_result);
125: l_transaction_id := hr_transaction_ss.get_transaction_id
126: (p_item_type => p_item_type
127: ,p_item_key => p_item_key);
128: END IF;
129: --

Line 255: l_transaction_table(l_count).param_value := to_char(p_completion_date, hr_transaction_ss.g_date_format);

251: l_transaction_table(l_count).param_data_type := 'VARCHAR2';
252:
253: l_count := l_count + 1;
254: l_transaction_table(l_count).param_name := 'P_COMPLETION_DATE';
255: l_transaction_table(l_count).param_value := to_char(p_completion_date, hr_transaction_ss.g_date_format);
256: l_transaction_table(l_count).param_data_type := 'DATE';
257:
258: l_count := l_count + 1;
259: l_transaction_table(l_count).param_name := 'P_AWARD';

Line 492: hr_transaction_ss.save_transaction_step

488: 'Y');
489: end if;
490: --bug 4146681
491:
492: hr_transaction_ss.save_transaction_step
493: (p_item_type => p_item_type
494: ,p_item_key => p_item_key
495: ,p_actid => p_activity_id
496: ,p_login_person_id => p_login_person_id