DBA Data[Home] [Help]

APPS.HR_CWK_TERMINATION_SWI dependencies on WF_ENGINE

Line 1516: := wf_engine.GetActivityAttrText( p_item_type,p_item_key, p_actid

1512: lv_cnt := lv_cnt + 1;
1513: lv_transaction_steps(lv_cnt).param_name := 'P_REVIEW_PROC_CALL';
1514: IF p_review_proc_call IS NULL THEN
1515: lv_transaction_steps(lv_cnt).param_value
1516: := wf_engine.GetActivityAttrText( p_item_type,p_item_key, p_actid
1517: ,'HR_REVIEW_REGION_ITEM', False);
1518: ELSE
1519: lv_transaction_steps(lv_cnt).param_value := p_review_proc_call;
1520: END IF;

Line 1616: isQKFn := wf_engine.getItemAttrText(p_item_type, p_item_key, 'HR_QUICK_FUNCTION', true);

1612: -- Quick Termination changes start from here
1613:
1614: if ( p_item_type is not null and p_item_key is not null ) then
1615:
1616: isQKFn := wf_engine.getItemAttrText(p_item_type, p_item_key, 'HR_QUICK_FUNCTION', true);
1617:
1618: if ( ActivityId is not null ) then
1619: isSupAsgPGExists := wf_engine.getActivityAttrText(p_item_type, p_item_key, p_actid, 'REASSIGN_DIRECTS');
1620: end if;

Line 1619: isSupAsgPGExists := wf_engine.getActivityAttrText(p_item_type, p_item_key, p_actid, 'REASSIGN_DIRECTS');

1615:
1616: isQKFn := wf_engine.getItemAttrText(p_item_type, p_item_key, 'HR_QUICK_FUNCTION', true);
1617:
1618: if ( ActivityId is not null ) then
1619: isSupAsgPGExists := wf_engine.getActivityAttrText(p_item_type, p_item_key, p_actid, 'REASSIGN_DIRECTS');
1620: end if;
1621:
1622: end if;
1623:

Line 1628: l_old_sup_person_id := wf_engine.getItemAttrText(p_item_type, p_item_key, 'QK_TERM_OLD_SUP_PER_ID', true);

1624: if (isQKFn = 'Y' and isSupAsgPGExists = 'Y' ) then
1625:
1626: l_term_date := hr_transaction_api.get_date_value(ln_transaction_step_id, 'P_ACTUAL_TERMINATION_DATE');
1627:
1628: l_old_sup_person_id := wf_engine.getItemAttrText(p_item_type, p_item_key, 'QK_TERM_OLD_SUP_PER_ID', true);
1629: l_old_sup_asg_id := wf_engine.getItemAttrText(p_item_type, p_item_key, 'QK_TERM_OLD_SUP_ASG_ID', true);
1630: l_old_sup_bg_id := wf_engine.getItemAttrText(p_item_type, p_item_key, 'QK_TERM_OLD_SUP_BG_ID', true);
1631: l_new_sup_person_id := wf_engine.getItemAttrText(p_item_type, p_item_key, 'QK_TERM_NEW_SUP_PER_ID', true);
1632: l_new_sup_asg_id := wf_engine.getItemAttrText(p_item_type, p_item_key, 'QK_TERM_NEW_SUP_ASG_ID', true);

Line 1629: l_old_sup_asg_id := wf_engine.getItemAttrText(p_item_type, p_item_key, 'QK_TERM_OLD_SUP_ASG_ID', true);

1625:
1626: l_term_date := hr_transaction_api.get_date_value(ln_transaction_step_id, 'P_ACTUAL_TERMINATION_DATE');
1627:
1628: l_old_sup_person_id := wf_engine.getItemAttrText(p_item_type, p_item_key, 'QK_TERM_OLD_SUP_PER_ID', true);
1629: l_old_sup_asg_id := wf_engine.getItemAttrText(p_item_type, p_item_key, 'QK_TERM_OLD_SUP_ASG_ID', true);
1630: l_old_sup_bg_id := wf_engine.getItemAttrText(p_item_type, p_item_key, 'QK_TERM_OLD_SUP_BG_ID', true);
1631: l_new_sup_person_id := wf_engine.getItemAttrText(p_item_type, p_item_key, 'QK_TERM_NEW_SUP_PER_ID', true);
1632: l_new_sup_asg_id := wf_engine.getItemAttrText(p_item_type, p_item_key, 'QK_TERM_NEW_SUP_ASG_ID', true);
1633: l_login_person_id := wf_engine.getItemAttrText(p_item_type, p_item_key, 'QK_TERM_LOGIN_PER_ID', true);

Line 1630: l_old_sup_bg_id := wf_engine.getItemAttrText(p_item_type, p_item_key, 'QK_TERM_OLD_SUP_BG_ID', true);

1626: l_term_date := hr_transaction_api.get_date_value(ln_transaction_step_id, 'P_ACTUAL_TERMINATION_DATE');
1627:
1628: l_old_sup_person_id := wf_engine.getItemAttrText(p_item_type, p_item_key, 'QK_TERM_OLD_SUP_PER_ID', true);
1629: l_old_sup_asg_id := wf_engine.getItemAttrText(p_item_type, p_item_key, 'QK_TERM_OLD_SUP_ASG_ID', true);
1630: l_old_sup_bg_id := wf_engine.getItemAttrText(p_item_type, p_item_key, 'QK_TERM_OLD_SUP_BG_ID', true);
1631: l_new_sup_person_id := wf_engine.getItemAttrText(p_item_type, p_item_key, 'QK_TERM_NEW_SUP_PER_ID', true);
1632: l_new_sup_asg_id := wf_engine.getItemAttrText(p_item_type, p_item_key, 'QK_TERM_NEW_SUP_ASG_ID', true);
1633: l_login_person_id := wf_engine.getItemAttrText(p_item_type, p_item_key, 'QK_TERM_LOGIN_PER_ID', true);
1634:

Line 1631: l_new_sup_person_id := wf_engine.getItemAttrText(p_item_type, p_item_key, 'QK_TERM_NEW_SUP_PER_ID', true);

1627:
1628: l_old_sup_person_id := wf_engine.getItemAttrText(p_item_type, p_item_key, 'QK_TERM_OLD_SUP_PER_ID', true);
1629: l_old_sup_asg_id := wf_engine.getItemAttrText(p_item_type, p_item_key, 'QK_TERM_OLD_SUP_ASG_ID', true);
1630: l_old_sup_bg_id := wf_engine.getItemAttrText(p_item_type, p_item_key, 'QK_TERM_OLD_SUP_BG_ID', true);
1631: l_new_sup_person_id := wf_engine.getItemAttrText(p_item_type, p_item_key, 'QK_TERM_NEW_SUP_PER_ID', true);
1632: l_new_sup_asg_id := wf_engine.getItemAttrText(p_item_type, p_item_key, 'QK_TERM_NEW_SUP_ASG_ID', true);
1633: l_login_person_id := wf_engine.getItemAttrText(p_item_type, p_item_key, 'QK_TERM_LOGIN_PER_ID', true);
1634:
1635:

Line 1632: l_new_sup_asg_id := wf_engine.getItemAttrText(p_item_type, p_item_key, 'QK_TERM_NEW_SUP_ASG_ID', true);

1628: l_old_sup_person_id := wf_engine.getItemAttrText(p_item_type, p_item_key, 'QK_TERM_OLD_SUP_PER_ID', true);
1629: l_old_sup_asg_id := wf_engine.getItemAttrText(p_item_type, p_item_key, 'QK_TERM_OLD_SUP_ASG_ID', true);
1630: l_old_sup_bg_id := wf_engine.getItemAttrText(p_item_type, p_item_key, 'QK_TERM_OLD_SUP_BG_ID', true);
1631: l_new_sup_person_id := wf_engine.getItemAttrText(p_item_type, p_item_key, 'QK_TERM_NEW_SUP_PER_ID', true);
1632: l_new_sup_asg_id := wf_engine.getItemAttrText(p_item_type, p_item_key, 'QK_TERM_NEW_SUP_ASG_ID', true);
1633: l_login_person_id := wf_engine.getItemAttrText(p_item_type, p_item_key, 'QK_TERM_LOGIN_PER_ID', true);
1634:
1635:
1636: if ( l_old_sup_person_id is not null and

Line 1633: l_login_person_id := wf_engine.getItemAttrText(p_item_type, p_item_key, 'QK_TERM_LOGIN_PER_ID', true);

1629: l_old_sup_asg_id := wf_engine.getItemAttrText(p_item_type, p_item_key, 'QK_TERM_OLD_SUP_ASG_ID', true);
1630: l_old_sup_bg_id := wf_engine.getItemAttrText(p_item_type, p_item_key, 'QK_TERM_OLD_SUP_BG_ID', true);
1631: l_new_sup_person_id := wf_engine.getItemAttrText(p_item_type, p_item_key, 'QK_TERM_NEW_SUP_PER_ID', true);
1632: l_new_sup_asg_id := wf_engine.getItemAttrText(p_item_type, p_item_key, 'QK_TERM_NEW_SUP_ASG_ID', true);
1633: l_login_person_id := wf_engine.getItemAttrText(p_item_type, p_item_key, 'QK_TERM_LOGIN_PER_ID', true);
1634:
1635:
1636: if ( l_old_sup_person_id is not null and
1637: l_old_sup_asg_id is not null and

Line 2414: isQKFn := wf_engine.getItemAttrText(ItemType, ItemKey, 'HR_QUICK_FUNCTION');

2410: ,ActivityId);
2411:
2412: if ( ItemType is not null and ItemKey is not null ) then
2413:
2414: isQKFn := wf_engine.getItemAttrText(ItemType, ItemKey, 'HR_QUICK_FUNCTION');
2415:
2416: if ( ActivityId is not null ) then
2417: isSupAsgPGExists := wf_engine.getActivityAttrText(ItemType, ItemKey, ActivityId, 'REASSIGN_DIRECTS');
2418: end if;

Line 2417: isSupAsgPGExists := wf_engine.getActivityAttrText(ItemType, ItemKey, ActivityId, 'REASSIGN_DIRECTS');

2413:
2414: isQKFn := wf_engine.getItemAttrText(ItemType, ItemKey, 'HR_QUICK_FUNCTION');
2415:
2416: if ( ActivityId is not null ) then
2417: isSupAsgPGExists := wf_engine.getActivityAttrText(ItemType, ItemKey, ActivityId, 'REASSIGN_DIRECTS');
2418: end if;
2419:
2420: end if;
2421:

Line 2426: l_old_sup_person_id := wf_engine.getItemAttrText(ItemType, ItemKey, 'QK_TERM_OLD_SUP_PER_ID', true);

2422: if (isQKFn = 'Y' and isSupAsgPGExists = 'Y' ) then
2423:
2424: l_term_date := hr_transaction_api.get_date_value(p_transaction_step_id, 'P_ACTUAL_TERMINATION_DATE');
2425:
2426: l_old_sup_person_id := wf_engine.getItemAttrText(ItemType, ItemKey, 'QK_TERM_OLD_SUP_PER_ID', true);
2427: l_old_sup_asg_id := wf_engine.getItemAttrText(ItemType, ItemKey, 'QK_TERM_OLD_SUP_ASG_ID', true);
2428: l_old_sup_bg_id := wf_engine.getItemAttrText(ItemType, ItemKey, 'QK_TERM_OLD_SUP_BG_ID', true);
2429: l_new_sup_person_id := wf_engine.getItemAttrText(ItemType, ItemKey, 'QK_TERM_NEW_SUP_PER_ID', true);
2430: l_new_sup_asg_id := wf_engine.getItemAttrText(ItemType, ItemKey, 'QK_TERM_NEW_SUP_ASG_ID', true);

Line 2427: l_old_sup_asg_id := wf_engine.getItemAttrText(ItemType, ItemKey, 'QK_TERM_OLD_SUP_ASG_ID', true);

2423:
2424: l_term_date := hr_transaction_api.get_date_value(p_transaction_step_id, 'P_ACTUAL_TERMINATION_DATE');
2425:
2426: l_old_sup_person_id := wf_engine.getItemAttrText(ItemType, ItemKey, 'QK_TERM_OLD_SUP_PER_ID', true);
2427: l_old_sup_asg_id := wf_engine.getItemAttrText(ItemType, ItemKey, 'QK_TERM_OLD_SUP_ASG_ID', true);
2428: l_old_sup_bg_id := wf_engine.getItemAttrText(ItemType, ItemKey, 'QK_TERM_OLD_SUP_BG_ID', true);
2429: l_new_sup_person_id := wf_engine.getItemAttrText(ItemType, ItemKey, 'QK_TERM_NEW_SUP_PER_ID', true);
2430: l_new_sup_asg_id := wf_engine.getItemAttrText(ItemType, ItemKey, 'QK_TERM_NEW_SUP_ASG_ID', true);
2431: l_login_person_id := wf_engine.getItemAttrText(ItemType, ItemKey, 'QK_TERM_LOGIN_PER_ID', true);

Line 2428: l_old_sup_bg_id := wf_engine.getItemAttrText(ItemType, ItemKey, 'QK_TERM_OLD_SUP_BG_ID', true);

2424: l_term_date := hr_transaction_api.get_date_value(p_transaction_step_id, 'P_ACTUAL_TERMINATION_DATE');
2425:
2426: l_old_sup_person_id := wf_engine.getItemAttrText(ItemType, ItemKey, 'QK_TERM_OLD_SUP_PER_ID', true);
2427: l_old_sup_asg_id := wf_engine.getItemAttrText(ItemType, ItemKey, 'QK_TERM_OLD_SUP_ASG_ID', true);
2428: l_old_sup_bg_id := wf_engine.getItemAttrText(ItemType, ItemKey, 'QK_TERM_OLD_SUP_BG_ID', true);
2429: l_new_sup_person_id := wf_engine.getItemAttrText(ItemType, ItemKey, 'QK_TERM_NEW_SUP_PER_ID', true);
2430: l_new_sup_asg_id := wf_engine.getItemAttrText(ItemType, ItemKey, 'QK_TERM_NEW_SUP_ASG_ID', true);
2431: l_login_person_id := wf_engine.getItemAttrText(ItemType, ItemKey, 'QK_TERM_LOGIN_PER_ID', true);
2432:

Line 2429: l_new_sup_person_id := wf_engine.getItemAttrText(ItemType, ItemKey, 'QK_TERM_NEW_SUP_PER_ID', true);

2425:
2426: l_old_sup_person_id := wf_engine.getItemAttrText(ItemType, ItemKey, 'QK_TERM_OLD_SUP_PER_ID', true);
2427: l_old_sup_asg_id := wf_engine.getItemAttrText(ItemType, ItemKey, 'QK_TERM_OLD_SUP_ASG_ID', true);
2428: l_old_sup_bg_id := wf_engine.getItemAttrText(ItemType, ItemKey, 'QK_TERM_OLD_SUP_BG_ID', true);
2429: l_new_sup_person_id := wf_engine.getItemAttrText(ItemType, ItemKey, 'QK_TERM_NEW_SUP_PER_ID', true);
2430: l_new_sup_asg_id := wf_engine.getItemAttrText(ItemType, ItemKey, 'QK_TERM_NEW_SUP_ASG_ID', true);
2431: l_login_person_id := wf_engine.getItemAttrText(ItemType, ItemKey, 'QK_TERM_LOGIN_PER_ID', true);
2432:
2433:

Line 2430: l_new_sup_asg_id := wf_engine.getItemAttrText(ItemType, ItemKey, 'QK_TERM_NEW_SUP_ASG_ID', true);

2426: l_old_sup_person_id := wf_engine.getItemAttrText(ItemType, ItemKey, 'QK_TERM_OLD_SUP_PER_ID', true);
2427: l_old_sup_asg_id := wf_engine.getItemAttrText(ItemType, ItemKey, 'QK_TERM_OLD_SUP_ASG_ID', true);
2428: l_old_sup_bg_id := wf_engine.getItemAttrText(ItemType, ItemKey, 'QK_TERM_OLD_SUP_BG_ID', true);
2429: l_new_sup_person_id := wf_engine.getItemAttrText(ItemType, ItemKey, 'QK_TERM_NEW_SUP_PER_ID', true);
2430: l_new_sup_asg_id := wf_engine.getItemAttrText(ItemType, ItemKey, 'QK_TERM_NEW_SUP_ASG_ID', true);
2431: l_login_person_id := wf_engine.getItemAttrText(ItemType, ItemKey, 'QK_TERM_LOGIN_PER_ID', true);
2432:
2433:
2434: if ( l_old_sup_person_id is not null and

Line 2431: l_login_person_id := wf_engine.getItemAttrText(ItemType, ItemKey, 'QK_TERM_LOGIN_PER_ID', true);

2427: l_old_sup_asg_id := wf_engine.getItemAttrText(ItemType, ItemKey, 'QK_TERM_OLD_SUP_ASG_ID', true);
2428: l_old_sup_bg_id := wf_engine.getItemAttrText(ItemType, ItemKey, 'QK_TERM_OLD_SUP_BG_ID', true);
2429: l_new_sup_person_id := wf_engine.getItemAttrText(ItemType, ItemKey, 'QK_TERM_NEW_SUP_PER_ID', true);
2430: l_new_sup_asg_id := wf_engine.getItemAttrText(ItemType, ItemKey, 'QK_TERM_NEW_SUP_ASG_ID', true);
2431: l_login_person_id := wf_engine.getItemAttrText(ItemType, ItemKey, 'QK_TERM_LOGIN_PER_ID', true);
2432:
2433:
2434: if ( l_old_sup_person_id is not null and
2435: l_old_sup_asg_id is not null and