APPS.WF_MAINTENANCE dependencies on WF_UR_VALIDATE_STG

Line 1049: from wf_ur_validate_stg

1045: user_orig_system, user_orig_system_id,
1046: assigning_role_start_date, assigning_role_end_date,
1047: effective_start_date, effective_end_date,
1048: relationship_id
1049: from wf_ur_validate_stg
1050: where (p_username is null OR user_name = p_username)
1051: and (p_rolename is null OR role_name = p_rolename)
1052: order by ROLE_NAME, USER_NAME;
1053:

Line 1516: WF_DDL.TruncateTable('WF_UR_VALIDATE_STG',WF_CORE.Translate('WF_SCHEMA'),

1512: --Enable parallel DML
1513: execute IMMEDIATE 'alter session enable parallel dml';
1514:
1515: --truncate the stage table now
1516: WF_DDL.TruncateTable('WF_UR_VALIDATE_STG',WF_CORE.Translate('WF_SCHEMA'),
1517: FALSE);
1518:
1519: --
1520: select min(to_number(value))

Line 1537: 'INSERT /*+ append parallel(WF_UR_VALIDATE_STG,'|| l_parallelProc ||') */

1533:
1534: -- populate the stage table
1535: -- bug 6823723. Now inserting as a dynamic DML to include the number of parallel processes
1536: l_sql :=
1537: 'INSERT /*+ append parallel(WF_UR_VALIDATE_STG,'|| l_parallelProc ||') */
1538: INTO WF_UR_VALIDATE_STG (WURA_ID, WUR_ID , ROLE_NAME , USER_NAME ,
1539: ASSIGNING_ROLE , START_DATE , END_DATE , ROLE_START_DATE, ROLE_END_DATE
1540: , USER_START_DATE , USER_END_DATE , ROLE_ORIG_SYSTEM ,
1541: ROLE_ORIG_SYSTEM_ID , USER_ORIG_SYSTEM , USER_ORIG_SYSTEM_ID ,

Line 1538: INTO WF_UR_VALIDATE_STG (WURA_ID, WUR_ID , ROLE_NAME , USER_NAME ,

1534: -- populate the stage table
1535: -- bug 6823723. Now inserting as a dynamic DML to include the number of parallel processes
1536: l_sql :=
1537: 'INSERT /*+ append parallel(WF_UR_VALIDATE_STG,'|| l_parallelProc ||') */
1538: INTO WF_UR_VALIDATE_STG (WURA_ID, WUR_ID , ROLE_NAME , USER_NAME ,
1539: ASSIGNING_ROLE , START_DATE , END_DATE , ROLE_START_DATE, ROLE_END_DATE
1540: , USER_START_DATE , USER_END_DATE , ROLE_ORIG_SYSTEM ,
1541: ROLE_ORIG_SYSTEM_ID , USER_ORIG_SYSTEM , USER_ORIG_SYSTEM_ID ,
1542: ASSIGNING_ROLE_START_DATE , ASSIGNING_ROLE_END_DATE ,