DBA Data[Home] [Help]

APPS.HR_REVTERMINATION_SS dependencies on HR_REVTERMINATION_SS

Line 1: PACKAGE BODY hr_revtermination_ss AS

1: PACKAGE BODY hr_revtermination_ss AS
2: /* $Header: hrrevtrmwrs.pkb 120.4.12020000.2 2013/03/28 09:19:51 cpilania ship $ */
3:
4: -- Package scope global variables.
5: -- The canonical date format has to use hyphens instead of slashes, ie.

Line 11: g_package constant varchar2(30) := 'HR_REVTERMINATION_SS';

7: -- dateValue() is expecting the date string in "rrrr-mm-dd" format.
8: -- All date fields are converted to canonical date formats and return to
9: -- the java caller.
10: g_date_format constant varchar2(10):='RRRR-MM-DD';
11: g_package constant varchar2(30) := 'HR_REVTERMINATION_SS';
12: g_debug boolean;
13:
14: cursor csr_person_type(l_person_id Number) is
15: select pps.SYSTEM_PERSON_TYPE

Line 548: lv_activity_name := hr_revtermination_ss.gv_TERMINATION_ACTIVITY_NAME;

544: ----------------------------------------------------------------------
545: -- Store the activity internal name for this particular
546: -- activity with other information.
547: ----------------------------------------------------------------------
548: lv_activity_name := hr_revtermination_ss.gv_TERMINATION_ACTIVITY_NAME;
549: lv_cnt := lv_cnt + 1;
550: hr_revtermination_ss.gtt_transaction_steps(lv_cnt).param_name
551: := 'P_ACTIVITY_NAME';
552: hr_revtermination_ss.gtt_transaction_steps(lv_cnt).param_value

Line 550: hr_revtermination_ss.gtt_transaction_steps(lv_cnt).param_name

546: -- activity with other information.
547: ----------------------------------------------------------------------
548: lv_activity_name := hr_revtermination_ss.gv_TERMINATION_ACTIVITY_NAME;
549: lv_cnt := lv_cnt + 1;
550: hr_revtermination_ss.gtt_transaction_steps(lv_cnt).param_name
551: := 'P_ACTIVITY_NAME';
552: hr_revtermination_ss.gtt_transaction_steps(lv_cnt).param_value
553: := lv_activity_name;
554: hr_revtermination_ss.gtt_transaction_steps(lv_cnt).param_data_type

Line 552: hr_revtermination_ss.gtt_transaction_steps(lv_cnt).param_value

548: lv_activity_name := hr_revtermination_ss.gv_TERMINATION_ACTIVITY_NAME;
549: lv_cnt := lv_cnt + 1;
550: hr_revtermination_ss.gtt_transaction_steps(lv_cnt).param_name
551: := 'P_ACTIVITY_NAME';
552: hr_revtermination_ss.gtt_transaction_steps(lv_cnt).param_value
553: := lv_activity_name;
554: hr_revtermination_ss.gtt_transaction_steps(lv_cnt).param_data_type
555: := 'VARCHAR2';
556:

Line 554: hr_revtermination_ss.gtt_transaction_steps(lv_cnt).param_data_type

550: hr_revtermination_ss.gtt_transaction_steps(lv_cnt).param_name
551: := 'P_ACTIVITY_NAME';
552: hr_revtermination_ss.gtt_transaction_steps(lv_cnt).param_value
553: := lv_activity_name;
554: hr_revtermination_ss.gtt_transaction_steps(lv_cnt).param_data_type
555: := 'VARCHAR2';
556:
557: ----------------------------------------------------------------------
558: -- Store the the Review Procedure Call and

Line 562: hr_revtermination_ss.gtt_transaction_steps(lv_cnt).param_name

558: -- Store the the Review Procedure Call and
559: -- activity id with other information.
560: ----------------------------------------------------------------------
561: lv_cnt := lv_cnt + 1;
562: hr_revtermination_ss.gtt_transaction_steps(lv_cnt).param_name
563: := 'P_REVIEW_PROC_CALL';
564: hr_revtermination_ss.gtt_transaction_steps(lv_cnt).param_value
565: := p_review_proc_call;
566: hr_revtermination_ss.gtt_transaction_steps(lv_cnt).param_data_type

Line 564: hr_revtermination_ss.gtt_transaction_steps(lv_cnt).param_value

560: ----------------------------------------------------------------------
561: lv_cnt := lv_cnt + 1;
562: hr_revtermination_ss.gtt_transaction_steps(lv_cnt).param_name
563: := 'P_REVIEW_PROC_CALL';
564: hr_revtermination_ss.gtt_transaction_steps(lv_cnt).param_value
565: := p_review_proc_call;
566: hr_revtermination_ss.gtt_transaction_steps(lv_cnt).param_data_type
567: := 'VARCHAR2';
568:

Line 566: hr_revtermination_ss.gtt_transaction_steps(lv_cnt).param_data_type

562: hr_revtermination_ss.gtt_transaction_steps(lv_cnt).param_name
563: := 'P_REVIEW_PROC_CALL';
564: hr_revtermination_ss.gtt_transaction_steps(lv_cnt).param_value
565: := p_review_proc_call;
566: hr_revtermination_ss.gtt_transaction_steps(lv_cnt).param_data_type
567: := 'VARCHAR2';
568:
569: lv_cnt := lv_cnt + 1;
570: hr_revtermination_ss.gtt_transaction_steps(lv_cnt).param_name

Line 570: hr_revtermination_ss.gtt_transaction_steps(lv_cnt).param_name

566: hr_revtermination_ss.gtt_transaction_steps(lv_cnt).param_data_type
567: := 'VARCHAR2';
568:
569: lv_cnt := lv_cnt + 1;
570: hr_revtermination_ss.gtt_transaction_steps(lv_cnt).param_name
571: := 'P_REVIEW_ACTID';
572: hr_revtermination_ss.gtt_transaction_steps(lv_cnt).param_value
573: := p_actid;
574: hr_revtermination_ss.gtt_transaction_steps(lv_cnt).param_data_type

Line 572: hr_revtermination_ss.gtt_transaction_steps(lv_cnt).param_value

568:
569: lv_cnt := lv_cnt + 1;
570: hr_revtermination_ss.gtt_transaction_steps(lv_cnt).param_name
571: := 'P_REVIEW_ACTID';
572: hr_revtermination_ss.gtt_transaction_steps(lv_cnt).param_value
573: := p_actid;
574: hr_revtermination_ss.gtt_transaction_steps(lv_cnt).param_data_type
575: := 'VARCHAR2';
576:

Line 574: hr_revtermination_ss.gtt_transaction_steps(lv_cnt).param_data_type

570: hr_revtermination_ss.gtt_transaction_steps(lv_cnt).param_name
571: := 'P_REVIEW_ACTID';
572: hr_revtermination_ss.gtt_transaction_steps(lv_cnt).param_value
573: := p_actid;
574: hr_revtermination_ss.gtt_transaction_steps(lv_cnt).param_data_type
575: := 'VARCHAR2';
576:
577: ---------------------------------------------------------------------
578: -- Check if there is already a transaction for this process?

Line 659: p_api_name => 'hr_revtermination_ss.ex_emp_process_save',

655: p_item_Key => p_item_key,
656: p_actid => TO_NUMBER(p_actid),
657: p_login_person_id => p_login_person_id,
658: p_transaction_step_id => ln_transaction_step_id,
659: p_api_name => 'hr_revtermination_ss.ex_emp_process_save',
660: p_transaction_data => hr_revtermination_ss.gtt_transaction_steps
661: );
662: --end of transaction logic
663: hr_utility.set_location('Leaving: '|| l_proc,20);

Line 660: p_transaction_data => hr_revtermination_ss.gtt_transaction_steps

656: p_actid => TO_NUMBER(p_actid),
657: p_login_person_id => p_login_person_id,
658: p_transaction_step_id => ln_transaction_step_id,
659: p_api_name => 'hr_revtermination_ss.ex_emp_process_save',
660: p_transaction_data => hr_revtermination_ss.gtt_transaction_steps
661: );
662: --end of transaction logic
663: hr_utility.set_location('Leaving: '|| l_proc,20);
664: EXCEPTION

Line 1231: lv_activity_name := HR_REVTERMINATION_SS.gv_TERMINATION_ACTIVITY_NAME;

1227: ----------------------------------------------------------------------
1228: -- Store the activity internal name for this particular
1229: -- activity with other information.
1230: ----------------------------------------------------------------------
1231: lv_activity_name := HR_REVTERMINATION_SS.gv_TERMINATION_ACTIVITY_NAME;
1232: lv_cnt := lv_cnt + 1;
1233: gtt_transaction_steps(lv_cnt).param_name := 'P_ACTIVITY_NAME';
1234: gtt_transaction_steps(lv_cnt).param_value := lv_activity_name;
1235: gtt_transaction_steps(lv_cnt).param_data_type := 'VARCHAR2';

Line 1337: p_api_name => 'hr_revtermination_ss.ex_cwk_process_save',

1333: p_item_Key => p_item_key,
1334: p_actid => TO_NUMBER(p_actid),
1335: p_login_person_id => p_login_person_id,
1336: p_transaction_step_id => ln_transaction_step_id,
1337: p_api_name => 'hr_revtermination_ss.ex_cwk_process_save',
1338: p_transaction_data => gtt_transaction_steps
1339: );
1340:
1341: EXCEPTION

Line 2374: END hr_revtermination_ss;

2370: hr_utility.set_location('Leaving:' || l_proc, 10);
2371:
2372: END getEmpTransactionDetails;
2373:
2374: END hr_revtermination_ss;