DBA Data[Home] [Help]

APPS.HR_PROCESS_ASSIGNMENT_SS dependencies on HR_TRANSACTION_SS

Line 2250: l_trans_tbl hr_transaction_ss.transaction_table;

2246: l_transaction_id number;
2247: l_result varchar2(100);
2248: l_transaction_step_id number;
2249: l_count number;
2250: l_trans_tbl hr_transaction_ss.transaction_table;
2251: l_assignment_rec per_all_assignments_f%rowtype;
2252: l_old_assignment_rec per_all_assignments_f%rowtype;
2253: l_db_assignment_rec per_all_assignments_f%rowtype;
2254: l_date_error boolean default false;

Line 2721: if (l_effective_date<> to_date(hr_transaction_ss.get_wf_effective_date

2717: (p_transaction_step_id => l_transaction_step_id
2718: ,p_name => 'P_REVIEW_ACTID');
2719: -- check that effective_date and date track update mode
2720: -- have not changed
2721: if (l_effective_date<> to_date(hr_transaction_ss.get_wf_effective_date
2722: (p_transaction_step_id => l_transaction_step_id)
2723: ,g_date_format))
2724: then
2725: --Should add page level error

Line 4785: l_transaction_id:=hr_transaction_ss.get_transaction_id

4781: if l_transaction_step_id is null then
4782: --
4783: -- first of all check if this transaction is already in progress
4784: --
4785: l_transaction_id:=hr_transaction_ss.get_transaction_id
4786: (p_item_type => l_item_type
4787: ,p_item_key => l_item_key);
4788: --
4789: -- if the transaction is not already in progress, create a new one

Line 4792: hr_transaction_ss.start_transaction

4788: --
4789: -- if the transaction is not already in progress, create a new one
4790: --
4791: if l_transaction_id is null then
4792: hr_transaction_ss.start_transaction
4793: (itemtype => l_item_type
4794: ,itemkey => l_item_key
4795: ,actid => l_activity_id
4796: ,funmode => 'RUN'

Line 4803: l_transaction_id:=hr_transaction_ss.get_transaction_id

4799: ,p_rptg_grp_id => p_rptg_grp_id
4800: ,p_effective_date_option => p_effective_date_option
4801: ,result => l_result);
4802: --
4803: l_transaction_id:=hr_transaction_ss.get_transaction_id
4804: (p_item_type => l_item_type
4805: ,p_item_key => l_item_key);
4806: if l_transaction_id is null then
4807: fnd_message.set_name('PER', 'HR_CREATE_TRANSACTION_ID_ERR');

Line 5702: hr_transaction_ss.save_transaction_step

5698: l_trans_tbl(l_count).param_data_type := 'VARCHAR2';
5699: --
5700: -- save the transaction step
5701: --
5702: hr_transaction_ss.save_transaction_step
5703: (p_item_type => l_item_type
5704: ,p_item_key => l_item_key
5705: ,p_actid => l_activity_id
5706: ,p_login_person_id => p_login_person_id

Line 5718: hr_transaction_ss.delete_transaction_step

5714: open pay_step(l_item_type,l_item_key); --bug6405208
5715: fetch pay_step into l_pay_step_id,l_pay_activity_id;
5716: if (pay_step%found and l_pay_activity_id <> -1 and
5717: l_assignment_rec.pay_basis_id is null) then
5718: hr_transaction_ss.delete_transaction_step
5719: (p_transaction_step_id => l_pay_step_id
5720: ,p_login_person_id => p_login_person_id);
5721: end if;
5722: close pay_step;

Line 5841: hr_transaction_ss.delete_transaction_step

5837: ,p_name => 'P_REVIEW_ACTID');
5838: -- for Pay Rate GSP Txn, Review Activity Id is -1
5839: if((lv_gsp_activity_id is not null) and (to_number(lv_gsp_activity_id) = -1))
5840: THEN
5841: hr_transaction_ss.delete_transaction_step
5842: (p_transaction_step_id => ln_gsp_step_id
5843: ,p_login_person_id => p_login_person_id);
5844: delete from per_pay_transactions where TRANSACTION_STEP_ID=ln_gsp_step_id;
5845: end if;

Line 5859: hr_transaction_ss.delete_transaction_step

5855: -- Bug 1043890 fix
5856: p_transaction_step_id := null;
5857: IF l_transaction_step_id IS NOT NULL
5858: THEN
5859: hr_transaction_ss.delete_transaction_step
5860: (p_transaction_step_id => l_transaction_step_id
5861: ,p_login_person_id => p_login_person_id);
5862: END IF;
5863: -- GSP Change

Line 5889: hr_transaction_ss.delete_transaction_step

5885: (p_transaction_step_id => ln_gsp_step_id
5886: ,p_name => 'P_REVIEW_ACTID');
5887: if((lv_gsp_activity_id is not null) and (to_number(lv_gsp_activity_id) = -1))
5888: THEN
5889: hr_transaction_ss.delete_transaction_step
5890: (p_transaction_step_id => ln_gsp_step_id
5891: ,p_login_person_id => p_login_person_id);
5892: delete from per_pay_transactions where TRANSACTION_STEP_ID=ln_gsp_step_id;
5893: end if;

Line 6096: hr_transaction_ss.get_wf_effective_date

6092: hr_utility.set_location(' if (p_effective_date is not null) then:'||l_proc,10);
6093: l_effective_date:= to_date(p_effective_date,g_date_format);
6094: else
6095: l_effective_date:= to_date(
6096: hr_transaction_ss.get_wf_effective_date
6097: (p_transaction_step_id => p_transaction_step_id),g_date_format);
6098: end if;
6099: --
6100: l_datetrack_update_mode:=

Line 7790: asgRec hr_transaction_ss.transaction_data;

7786: FUNCTION get_assignment(p_transaction_step_id in number)
7787: RETURN ref_cursor IS
7788: csr ref_cursor;
7789:
7790: asgRec hr_transaction_ss.transaction_data;
7791: l_proc varchar2(72) := g_package||'get_assignment';
7792: l_old_mgr_flag varchar2(10);
7793: l_old_labour_union_flag varchar2(10);
7794: l_old_organization_id number;

Line 7829: hr_transaction_ss.get_transaction_data

7825: l_primary_flag := 'Y';
7826: end if;
7827: end if;
7828:
7829: hr_transaction_ss.get_transaction_data
7830: (p_transaction_step_id => p_transaction_step_id
7831: ,p_transaction_data => asgRec);
7832:
7833: IF (asgRec.name.count < 108) THEN