DBA Data[Home] [Help]

APPS.HR_PROCESS_SIT_SS dependencies on HR_PROCESS_SIT_SS

Line 1: Package Body hr_process_sit_ss as

1: Package Body hr_process_sit_ss as
2: /* $Header: hrsitwrs.pkb 120.0 2005/05/31 02:46:37 appldev noship $ */
3: --
4: -- Package Variables
5: --

Line 6: g_package varchar2(33) := 'HR_PROCESS_SIT_SS';

2: /* $Header: hrsitwrs.pkb 120.0 2005/05/31 02:46:37 appldev noship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := 'HR_PROCESS_SIT_SS';
7: -- ----------------------------------------------------------------------------
8: -- |-----------------------< save_transaction_data >--------------------------|
9: -- ----------------------------------------------------------------------------
10: PROCEDURE save_transaction_data

Line 620: l_analysis_criteria_rec hr_process_sit_ss.per_analysis_criteria_rec;

616: -- Declare cursors and local variables
617: --
618: l_proc varchar2(72) := g_package||'insert_sit';
619: l_analysis_criteria_id number;
620: l_analysis_criteria_rec hr_process_sit_ss.per_analysis_criteria_rec;
621: l_error_message long default null;
622: --
623: begin
624: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 759: l_analysis_criteria_rec hr_process_sit_ss.per_analysis_criteria_rec;

755: --
756: --
757: l_proc varchar2(72) := g_package||'update_sit';
758: l_analysis_criteria_id number;
759: l_analysis_criteria_rec hr_process_sit_ss.per_analysis_criteria_rec;
760: l_error_message long default null;
761: --
762: begin
763: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 919: l_analysis_criteria_rec hr_process_sit_ss.per_analysis_criteria_rec;

915: l_id_flex_num number;
916: l_structure_code varchar2(30);
917: l_structure_name varchar2(30);
918: l_action varchar2(100);
919: l_analysis_criteria_rec hr_process_sit_ss.per_analysis_criteria_rec;
920: l_error_message long default null;
921: l_attribute_category PER_PERSON_ANALYSES.attribute_category%type;
922: l_attribute1 PER_PERSON_ANALYSES.attribute1%type;
923: l_attribute2 PER_PERSON_ANALYSES.attribute2%type;

Line 948: where t1.api_name = 'HR_PROCESS_SIT_SS.PROCESS_API'

944: --2287707
945: cursor csr_get_steps is
946: select t1.transaction_step_id
947: from HR_API_TRANSACTION_STEPS t1
948: where t1.api_name = 'HR_PROCESS_SIT_SS.PROCESS_API'
949: and t1.transaction_id = (select t2.transaction_id
950: from HR_API_TRANSACTION_STEPS t2
951: where t2.transaction_step_id = p_transaction_step_id)
952: order by transaction_step_id;

Line 1200: l_analysis_criteria_rec hr_process_sit_ss.per_analysis_criteria_rec;

1196: where analysis_criteria_id = p_analysis_criteria_id;
1197:
1198:
1199: l_criteria_segments csr_criteria_segments%ROWTYPE;
1200: l_analysis_criteria_rec hr_process_sit_ss.per_analysis_criteria_rec;
1201: l_proc varchar2(72) := g_package||'get_segments_from_ccid';
1202:
1203: BEGIN
1204:

Line 1250: -- Wrapper Package for API hr_process_sit_ss.

1246: END get_segments_from_ccid;
1247:
1248: -- ----------------------------------------------------------------------------
1249: -- |-----------------------< del_transaction_data >---------------------------|
1250: -- Wrapper Package for API hr_process_sit_ss.
1251: --
1252: -- Description:
1253: -- This Function dels the transaction data for the given item type, item key
1254: -- and activity id.

Line 1284: end hr_process_sit_ss;

1280:
1281: hr_utility.set_location('Exiting:'||l_proc, 15);
1282: END del_transaction_data;
1283:
1284: end hr_process_sit_ss;