APPS.HR_360_MESSAGE dependencies on HR_360_PERSON_VIEW

Line 3: procedure HR_360_PERSON_VIEW ( P_EMPLOYEE_NUMBER VARCHAR2 ,

1: PACKAGE body HR_360_MESSAGE as
2: /* $Header: perhrhd360vw.pkb 120.6 2008/03/19 09:51:41 sathkris noship $ */
3: procedure HR_360_PERSON_VIEW ( P_EMPLOYEE_NUMBER VARCHAR2 ,
4: p_effective_date date default sysdate,
5: P_BUSINESS_GROUP_ID NUMBER,
6: p_tp_site_id number,
7: p_trxn_id varchar2)

Line 391: INSERT INTO HR_360_PERSON_VIEW (

387:
388: select hrhd_delta_sync_seq.nextval into L_SEQNUM from dual;
389:
390: L_CURRENT_DATE :=SYSDATE;
391: INSERT INTO HR_360_PERSON_VIEW (
392: EMPLOYEE_NUMBER ,
393: USER_PERSON_TYPE ,
394: DATE_OF_BIRTH ,
395: TOWN_OF_BIRTH ,

Line 467: L_SQL1:='UPDATE HR_360_PERSON_VIEW

463:
464: EXECUTE IMMEDIATE l_sql using in out L_APP_COL_VALUE,IN OUT l_end_user_col_name1 ;
465:
466:
467: L_SQL1:='UPDATE HR_360_PERSON_VIEW
468: SET PER_ADD_LABLE'||J||'='||''''||L_APP_COL_VALUE||''''||',PER_ADD_LABLE'||K||
469: '='||''''||l_end_user_col_name1||''''||'WHERE RECSEQ='||''''||L_EMPLOYEE_NUMBER||'-'||L_SEQNUM||'''';
470:
471:

Line 488: update HR_360_PERSON_VIEW

484: END IF;
485:
486:
487:
488: update HR_360_PERSON_VIEW
489: set address_STYLE=l_style
490: where RECSEQ=L_EMPLOYEE_NUMBER||'-'||L_SEQNUM ;
491:
492:

Line 521: L_SQL1:='UPDATE HR_360_PERSON_VIEW

517:
518: -- EXECUTE IMMEDIATE l_sql using in out L_APP_COL_VALUE,IN OUT l_end_user_col_name1 ;
519:
520:
521: L_SQL1:='UPDATE HR_360_PERSON_VIEW
522: SET CON_ADD_LABLE'||J||'='||''''||L_APP_COL_VALUE||''''||',CON_ADD_LABLE'||K||
523: '='||''''||l_end_user_col_name1||''''||'WHERE RECSEQ='||''''||L_EMPLOYEE_NUMBER||'-'||L_SEQNUM||'''' ;
524:
525:

Line 598: HR_360_MESSAGE.HR_360_PERSON_VIEW(P_EMPLOYEE_NUMBER => p_person_id,

594: p_tp_id := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'PARAMETER4');
595: p_txn_id := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'PARAMETER5');
596: p_eff_date := nvl(to_date(p_eff_dt,'DD/MM/YYYY'),sysdate);
597:
598: HR_360_MESSAGE.HR_360_PERSON_VIEW(P_EMPLOYEE_NUMBER => p_person_id,
599: P_EFFECTIVE_DATE => p_eff_date,
600: P_BUSINESS_GROUP_ID => to_number(p_bg_id),
601: p_tp_site_id => p_tp_id,
602: p_trxn_id => p_txn_id);