The following lines contain the word 'select', 'insert', 'update' or 'delete':
l_last_update_login NUMBER;
l_last_updated_by NUMBER;
l_last_update_login := hz_utility_v2pub.last_update_login;
l_last_updated_by := hz_utility_v2pub.last_updated_by;
INSERT INTO HZ_PER_PROFILES_EXT_B (
extension_id,
person_profile_id,
attr_group_id,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login,
c_ext_attr1,
c_ext_attr2,
c_ext_attr3,
c_ext_attr4,
c_ext_attr5,
c_ext_attr6,
c_ext_attr7,
c_ext_attr8,
c_ext_attr9,
c_ext_attr10,
c_ext_attr11,
c_ext_attr12,
c_ext_attr13,
c_ext_attr14,
c_ext_attr15,
c_ext_attr16,
c_ext_attr17,
c_ext_attr18,
c_ext_attr19,
c_ext_attr20,
n_ext_attr1,
n_ext_attr2,
n_ext_attr3,
n_ext_attr4,
n_ext_attr5,
n_ext_attr6,
n_ext_attr7,
n_ext_attr8,
n_ext_attr9,
n_ext_attr10,
n_ext_attr11,
n_ext_attr12,
n_ext_attr13,
n_ext_attr14,
n_ext_attr15,
n_ext_attr16,
n_ext_attr17,
n_ext_attr18,
n_ext_attr19,
n_ext_attr20,
d_ext_attr1,
d_ext_attr2,
d_ext_attr3,
d_ext_attr4,
d_ext_attr5,
d_ext_attr6,
d_ext_attr7,
d_ext_attr8,
d_ext_attr9,
d_ext_attr10,
old_extension_id )
SELECT
ego_extfwk_s.nextval,
p_new_profile_id,
attr_group_id,
l_created_by,
SYSDATE,
l_last_updated_by,
SYSDATE,
l_last_update_login,
c_ext_attr1,
c_ext_attr2,
c_ext_attr3,
c_ext_attr4,
c_ext_attr5,
c_ext_attr6,
c_ext_attr7,
c_ext_attr8,
c_ext_attr9,
c_ext_attr10,
c_ext_attr11,
c_ext_attr12,
c_ext_attr13,
c_ext_attr14,
c_ext_attr15,
c_ext_attr16,
c_ext_attr17,
c_ext_attr18,
c_ext_attr19,
c_ext_attr20,
n_ext_attr1,
n_ext_attr2,
n_ext_attr3,
n_ext_attr4,
n_ext_attr5,
n_ext_attr6,
n_ext_attr7,
n_ext_attr8,
n_ext_attr9,
n_ext_attr10,
n_ext_attr11,
n_ext_attr12,
n_ext_attr13,
n_ext_attr14,
n_ext_attr15,
n_ext_attr16,
n_ext_attr17,
n_ext_attr18,
n_ext_attr19,
n_ext_attr20,
d_ext_attr1,
d_ext_attr2,
d_ext_attr3,
d_ext_attr4,
d_ext_attr5,
d_ext_attr6,
d_ext_attr7,
d_ext_attr8,
d_ext_attr9,
d_ext_attr10,
extension_id
FROM HZ_PER_PROFILES_EXT_B
WHERE person_profile_id = p_old_profile_id;
INSERT INTO HZ_PER_PROFILES_EXT_TL (
extension_id,
person_profile_id,
attr_group_id,
source_lang,
language,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login,
tl_ext_attr1,
tl_ext_attr2,
tl_ext_attr3,
tl_ext_attr4,
tl_ext_attr5,
tl_ext_attr6,
tl_ext_attr7,
tl_ext_attr8,
tl_ext_attr9,
tl_ext_attr10,
tl_ext_attr11,
tl_ext_attr12,
tl_ext_attr13,
tl_ext_attr14,
tl_ext_attr15,
tl_ext_attr16,
tl_ext_attr17,
tl_ext_attr18,
tl_ext_attr19,
tl_ext_attr20
)
SELECT
b.extension_id,
p_new_profile_id,
tl.attr_group_id,
tl.source_lang,
tl.language,
l_created_by,
SYSDATE,
l_last_updated_by,
SYSDATE,
l_last_update_login,
tl.tl_ext_attr1,
tl.tl_ext_attr2,
tl.tl_ext_attr3,
tl.tl_ext_attr4,
tl.tl_ext_attr5,
tl.tl_ext_attr6,
tl.tl_ext_attr7,
tl.tl_ext_attr8,
tl.tl_ext_attr9,
tl.tl_ext_attr10,
tl.tl_ext_attr11,
tl.tl_ext_attr12,
tl.tl_ext_attr13,
tl.tl_ext_attr14,
tl.tl_ext_attr15,
tl.tl_ext_attr16,
tl.tl_ext_attr17,
tl.tl_ext_attr18,
tl.tl_ext_attr19,
tl.tl_ext_attr20
FROM HZ_PER_PROFILES_EXT_B b,
HZ_PER_PROFILES_EXT_TL tl
WHERE b.person_profile_id = p_new_profile_id
AND tl.extension_id = b.old_extension_id;
l_last_update_login NUMBER;
l_last_updated_by NUMBER;
l_last_update_login := hz_utility_v2pub.last_update_login;
l_last_updated_by := hz_utility_v2pub.last_updated_by;
INSERT INTO hz_org_profiles_ext_b (
extension_id,
organization_profile_id,
attr_group_id,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login,
c_ext_attr1,
c_ext_attr2,
c_ext_attr3,
c_ext_attr4,
c_ext_attr5,
c_ext_attr6,
c_ext_attr7,
c_ext_attr8,
c_ext_attr9,
c_ext_attr10,
c_ext_attr11,
c_ext_attr12,
c_ext_attr13,
c_ext_attr14,
c_ext_attr15,
c_ext_attr16,
c_ext_attr17,
c_ext_attr18,
c_ext_attr19,
c_ext_attr20,
n_ext_attr1,
n_ext_attr2,
n_ext_attr3,
n_ext_attr4,
n_ext_attr5,
n_ext_attr6,
n_ext_attr7,
n_ext_attr8,
n_ext_attr9,
n_ext_attr10,
n_ext_attr11,
n_ext_attr12,
n_ext_attr13,
n_ext_attr14,
n_ext_attr15,
n_ext_attr16,
n_ext_attr17,
n_ext_attr18,
n_ext_attr19,
n_ext_attr20,
d_ext_attr1,
d_ext_attr2,
d_ext_attr3,
d_ext_attr4,
d_ext_attr5,
d_ext_attr6,
d_ext_attr7,
d_ext_attr8,
d_ext_attr9,
d_ext_attr10,
old_extension_id )
SELECT
ego_extfwk_s.nextval,
p_new_profile_id,
attr_group_id,
l_created_by,
SYSDATE,
l_last_updated_by,
SYSDATE,
l_last_update_login,
c_ext_attr1,
c_ext_attr2,
c_ext_attr3,
c_ext_attr4,
c_ext_attr5,
c_ext_attr6,
c_ext_attr7,
c_ext_attr8,
c_ext_attr9,
c_ext_attr10,
c_ext_attr11,
c_ext_attr12,
c_ext_attr13,
c_ext_attr14,
c_ext_attr15,
c_ext_attr16,
c_ext_attr17,
c_ext_attr18,
c_ext_attr19,
c_ext_attr20,
n_ext_attr1,
n_ext_attr2,
n_ext_attr3,
n_ext_attr4,
n_ext_attr5,
n_ext_attr6,
n_ext_attr7,
n_ext_attr8,
n_ext_attr9,
n_ext_attr10,
n_ext_attr11,
n_ext_attr12,
n_ext_attr13,
n_ext_attr14,
n_ext_attr15,
n_ext_attr16,
n_ext_attr17,
n_ext_attr18,
n_ext_attr19,
n_ext_attr20,
d_ext_attr1,
d_ext_attr2,
d_ext_attr3,
d_ext_attr4,
d_ext_attr5,
d_ext_attr6,
d_ext_attr7,
d_ext_attr8,
d_ext_attr9,
d_ext_attr10,
extension_id
FROM hz_org_profiles_ext_b
WHERE organization_profile_id = p_old_profile_id;
INSERT INTO hz_org_profiles_ext_tl (
extension_id,
organization_profile_id,
attr_group_id,
source_lang,
language,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login,
tl_ext_attr1,
tl_ext_attr2,
tl_ext_attr3,
tl_ext_attr4,
tl_ext_attr5,
tl_ext_attr6,
tl_ext_attr7,
tl_ext_attr8,
tl_ext_attr9,
tl_ext_attr10,
tl_ext_attr11,
tl_ext_attr12,
tl_ext_attr13,
tl_ext_attr14,
tl_ext_attr15,
tl_ext_attr16,
tl_ext_attr17,
tl_ext_attr18,
tl_ext_attr19,
tl_ext_attr20
)
SELECT
b.extension_id,
p_new_profile_id,
tl.attr_group_id,
tl.source_lang,
tl.language,
l_created_by,
SYSDATE,
l_last_updated_by,
SYSDATE,
l_last_update_login,
tl.tl_ext_attr1,
tl.tl_ext_attr2,
tl.tl_ext_attr3,
tl.tl_ext_attr4,
tl.tl_ext_attr5,
tl.tl_ext_attr6,
tl.tl_ext_attr7,
tl.tl_ext_attr8,
tl.tl_ext_attr9,
tl.tl_ext_attr10,
tl.tl_ext_attr11,
tl.tl_ext_attr12,
tl.tl_ext_attr13,
tl.tl_ext_attr14,
tl.tl_ext_attr15,
tl.tl_ext_attr16,
tl.tl_ext_attr17,
tl.tl_ext_attr18,
tl.tl_ext_attr19,
tl.tl_ext_attr20
FROM hz_org_profiles_ext_b b,
hz_org_profiles_ext_tl tl
WHERE b.organization_profile_id = p_new_profile_id
AND tl.extension_id = b.old_extension_id;
INSERT INTO hz_org_profiles_ext_sg (
old_profile_id,
new_profile_id,
work_unit_number,
status
)
SELECT old_profile_id,
new_profile_id,
round(ROWNUM/p_batch_size + 0.5) work_unit_number,
'N' status
FROM (
SELECT /*+ parallel(p1) parallel(p2) */
max(p2.organization_profile_id) old_profile_id, p1.organization_profile_id new_profile_id
FROM hz_organization_profiles p1,
hz_organization_profiles p2
WHERE p1.effective_end_date is null
AND NOT EXISTS (
SELECT null
FROM hz_org_profiles_ext_b ext
WHERE p1.organization_profile_id = ext.organization_profile_id)
AND p2.party_id = p1.party_id
AND p2.organization_profile_id <> p1.organization_profile_id
AND EXISTS (
SELECT null
FROM hz_org_profiles_ext_b ext
WHERE p2.organization_profile_id = ext.organization_profile_id)
GROUP BY p1.organization_profile_id);
INSERT INTO hz_per_profiles_ext_sg (
old_profile_id,
new_profile_id,
work_unit_number,
status
)
SELECT old_profile_id,
new_profile_id,
round(ROWNUM/p_batch_size + 0.5) work_unit_number,
'N' status
FROM (
SELECT /*+ parallel(p1) parallel(p2) */
max(p2.person_profile_id) old_profile_id, p1.person_profile_id new_profile_id
FROM hz_person_profiles p1,
hz_person_profiles p2
WHERE p1.effective_end_date is null
AND NOT EXISTS (
SELECT null
FROM hz_per_profiles_ext_b ext
WHERE p1.person_profile_id = ext.person_profile_id)
AND p2.party_id = p1.party_id
AND p2.person_profile_id <> p1.person_profile_id
AND EXISTS (
SELECT null
FROM hz_per_profiles_ext_b ext
WHERE p2.person_profile_id = ext.person_profile_id)
GROUP BY p1.person_profile_id);
* PRIVATE PROCEDURE update_staging_status
*
* DESCRIPTION
* Update staging table status column
*
* EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
*
* IN:
* p_entity_name Entity Name
* p_work_unit_number Work Unit Number
* p_status Status
*
* MODIFICATION HISTORY
*
* 03-15-2005 Jianying Huang o Created.
*/
PROCEDURE update_staging_status (
p_entity_name IN VARCHAR2,
p_work_unit_number IN NUMBER,
p_status IN VARCHAR2
) IS
BEGIN
IF p_entity_name = C_ORG THEN
-- update org staging table
--
UPDATE hz_org_profiles_ext_sg
SET status = p_status
WHERE work_unit_number = p_work_unit_number;
UPDATE hz_per_profiles_ext_sg
SET status = p_status
WHERE work_unit_number = p_work_unit_number;
END update_staging_status;
* p_last_updated_by Last Updated By
* p_last_update_login Last Update Login
*
* MODIFICATION HISTORY
*
* 03-15-2005 Jianying Huang o Created.
*/
PROCEDURE copy_org_extension (
p_parent_request_id IN NUMBER,
p_work_unit_number IN NUMBER,
p_created_by IN NUMBER,
p_last_updated_by IN NUMBER,
p_last_update_login IN NUMBER
) IS
BEGIN
-- insert into _b table
--
INSERT INTO hz_org_profiles_ext_b ext (
extension_id,
organization_profile_id,
attr_group_id,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login,
c_ext_attr1,
c_ext_attr2,
c_ext_attr3,
c_ext_attr4,
c_ext_attr5,
c_ext_attr6,
c_ext_attr7,
c_ext_attr8,
c_ext_attr9,
c_ext_attr10,
c_ext_attr11,
c_ext_attr12,
c_ext_attr13,
c_ext_attr14,
c_ext_attr15,
c_ext_attr16,
c_ext_attr17,
c_ext_attr18,
c_ext_attr19,
c_ext_attr20,
n_ext_attr1,
n_ext_attr2,
n_ext_attr3,
n_ext_attr4,
n_ext_attr5,
n_ext_attr6,
n_ext_attr7,
n_ext_attr8,
n_ext_attr9,
n_ext_attr10,
n_ext_attr11,
n_ext_attr12,
n_ext_attr13,
n_ext_attr14,
n_ext_attr15,
n_ext_attr16,
n_ext_attr17,
n_ext_attr18,
n_ext_attr19,
n_ext_attr20,
d_ext_attr1,
d_ext_attr2,
d_ext_attr3,
d_ext_attr4,
d_ext_attr5,
d_ext_attr6,
d_ext_attr7,
d_ext_attr8,
d_ext_attr9,
d_ext_attr10,
old_extension_id )
SELECT
ego_extfwk_s.nextval,
sg.new_profile_id,
attr_group_id,
p_created_by,
SYSDATE,
p_last_updated_by,
SYSDATE,
p_last_update_login,
c_ext_attr1,
c_ext_attr2,
c_ext_attr3,
c_ext_attr4,
c_ext_attr5,
c_ext_attr6,
c_ext_attr7,
c_ext_attr8,
c_ext_attr9,
c_ext_attr10,
c_ext_attr11,
c_ext_attr12,
c_ext_attr13,
c_ext_attr14,
c_ext_attr15,
c_ext_attr16,
c_ext_attr17,
c_ext_attr18,
c_ext_attr19,
c_ext_attr20,
n_ext_attr1,
n_ext_attr2,
n_ext_attr3,
n_ext_attr4,
n_ext_attr5,
n_ext_attr6,
n_ext_attr7,
n_ext_attr8,
n_ext_attr9,
n_ext_attr10,
n_ext_attr11,
n_ext_attr12,
n_ext_attr13,
n_ext_attr14,
n_ext_attr15,
n_ext_attr16,
n_ext_attr17,
n_ext_attr18,
n_ext_attr19,
n_ext_attr20,
d_ext_attr1,
d_ext_attr2,
d_ext_attr3,
d_ext_attr4,
d_ext_attr5,
d_ext_attr6,
d_ext_attr7,
d_ext_attr8,
d_ext_attr9,
d_ext_attr10,
extension_id
FROM hz_org_profiles_ext_b b,
hz_org_profiles_ext_sg sg
WHERE
sg.work_unit_number = p_work_unit_number
AND b.organization_profile_id = sg.old_profile_id;
Write_Log(SQL%ROWCOUNT||' records inserted into org base table.');
INSERT INTO hz_org_profiles_ext_tl ext (
extension_id,
organization_profile_id,
attr_group_id,
source_lang,
language,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login,
tl_ext_attr1,
tl_ext_attr2,
tl_ext_attr3,
tl_ext_attr4,
tl_ext_attr5,
tl_ext_attr6,
tl_ext_attr7,
tl_ext_attr8,
tl_ext_attr9,
tl_ext_attr10,
tl_ext_attr11,
tl_ext_attr12,
tl_ext_attr13,
tl_ext_attr14,
tl_ext_attr15,
tl_ext_attr16,
tl_ext_attr17,
tl_ext_attr18,
tl_ext_attr19,
tl_ext_attr20
)
SELECT
b.extension_id,
sg.new_profile_id,
tl.attr_group_id,
tl.source_lang,
tl.language,
p_created_by,
SYSDATE,
p_last_updated_by,
SYSDATE,
p_last_update_login,
tl.tl_ext_attr1,
tl.tl_ext_attr2,
tl.tl_ext_attr3,
tl.tl_ext_attr4,
tl.tl_ext_attr5,
tl.tl_ext_attr6,
tl.tl_ext_attr7,
tl.tl_ext_attr8,
tl.tl_ext_attr9,
tl.tl_ext_attr10,
tl.tl_ext_attr11,
tl.tl_ext_attr12,
tl.tl_ext_attr13,
tl.tl_ext_attr14,
tl.tl_ext_attr15,
tl.tl_ext_attr16,
tl.tl_ext_attr17,
tl.tl_ext_attr18,
tl.tl_ext_attr19,
tl.tl_ext_attr20
FROM hz_org_profiles_ext_b b,
hz_org_profiles_ext_tl tl,
hz_org_profiles_ext_sg sg
WHERE
sg.work_unit_number = p_work_unit_number
AND b.organization_profile_id = sg.new_profile_id
AND tl.extension_id = b.old_extension_id;
Write_Log(SQL%ROWCOUNT||' records inserted into org tl table.');
* p_last_updated_by Last Updated By
* p_last_update_login Last Update Login
*
* MODIFICATION HISTORY
*
* 03-15-2005 Jianying Huang o Created.
*/
PROCEDURE copy_per_extension (
p_parent_request_id IN NUMBER,
p_work_unit_number IN NUMBER,
p_created_by IN NUMBER,
p_last_updated_by IN NUMBER,
p_last_update_login IN NUMBER
) IS
BEGIN
-- insert into _b table
--
INSERT INTO hz_per_profiles_ext_b ext (
extension_id,
person_profile_id,
attr_group_id,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login,
c_ext_attr1,
c_ext_attr2,
c_ext_attr3,
c_ext_attr4,
c_ext_attr5,
c_ext_attr6,
c_ext_attr7,
c_ext_attr8,
c_ext_attr9,
c_ext_attr10,
c_ext_attr11,
c_ext_attr12,
c_ext_attr13,
c_ext_attr14,
c_ext_attr15,
c_ext_attr16,
c_ext_attr17,
c_ext_attr18,
c_ext_attr19,
c_ext_attr20,
n_ext_attr1,
n_ext_attr2,
n_ext_attr3,
n_ext_attr4,
n_ext_attr5,
n_ext_attr6,
n_ext_attr7,
n_ext_attr8,
n_ext_attr9,
n_ext_attr10,
n_ext_attr11,
n_ext_attr12,
n_ext_attr13,
n_ext_attr14,
n_ext_attr15,
n_ext_attr16,
n_ext_attr17,
n_ext_attr18,
n_ext_attr19,
n_ext_attr20,
d_ext_attr1,
d_ext_attr2,
d_ext_attr3,
d_ext_attr4,
d_ext_attr5,
d_ext_attr6,
d_ext_attr7,
d_ext_attr8,
d_ext_attr9,
d_ext_attr10,
old_extension_id )
SELECT
ego_extfwk_s.nextval,
sg.new_profile_id,
attr_group_id,
p_created_by,
SYSDATE,
p_last_updated_by,
SYSDATE,
p_last_update_login,
c_ext_attr1,
c_ext_attr2,
c_ext_attr3,
c_ext_attr4,
c_ext_attr5,
c_ext_attr6,
c_ext_attr7,
c_ext_attr8,
c_ext_attr9,
c_ext_attr10,
c_ext_attr11,
c_ext_attr12,
c_ext_attr13,
c_ext_attr14,
c_ext_attr15,
c_ext_attr16,
c_ext_attr17,
c_ext_attr18,
c_ext_attr19,
c_ext_attr20,
n_ext_attr1,
n_ext_attr2,
n_ext_attr3,
n_ext_attr4,
n_ext_attr5,
n_ext_attr6,
n_ext_attr7,
n_ext_attr8,
n_ext_attr9,
n_ext_attr10,
n_ext_attr11,
n_ext_attr12,
n_ext_attr13,
n_ext_attr14,
n_ext_attr15,
n_ext_attr16,
n_ext_attr17,
n_ext_attr18,
n_ext_attr19,
n_ext_attr20,
d_ext_attr1,
d_ext_attr2,
d_ext_attr3,
d_ext_attr4,
d_ext_attr5,
d_ext_attr6,
d_ext_attr7,
d_ext_attr8,
d_ext_attr9,
d_ext_attr10,
extension_id
FROM hz_per_profiles_ext_b b,
hz_per_profiles_ext_sg sg
WHERE
sg.work_unit_number = p_work_unit_number
AND b.person_profile_id = sg.old_profile_id;
Write_Log(SQL%ROWCOUNT||' records inserted into per base table.');
INSERT INTO hz_per_profiles_ext_tl ext (
extension_id,
person_profile_id,
attr_group_id,
source_lang,
language,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login,
tl_ext_attr1,
tl_ext_attr2,
tl_ext_attr3,
tl_ext_attr4,
tl_ext_attr5,
tl_ext_attr6,
tl_ext_attr7,
tl_ext_attr8,
tl_ext_attr9,
tl_ext_attr10,
tl_ext_attr11,
tl_ext_attr12,
tl_ext_attr13,
tl_ext_attr14,
tl_ext_attr15,
tl_ext_attr16,
tl_ext_attr17,
tl_ext_attr18,
tl_ext_attr19,
tl_ext_attr20
)
SELECT
b.extension_id,
sg.new_profile_id,
tl.attr_group_id,
tl.source_lang,
tl.language,
p_created_by,
SYSDATE,
p_last_updated_by,
SYSDATE,
p_last_update_login,
tl.tl_ext_attr1,
tl.tl_ext_attr2,
tl.tl_ext_attr3,
tl.tl_ext_attr4,
tl.tl_ext_attr5,
tl.tl_ext_attr6,
tl.tl_ext_attr7,
tl.tl_ext_attr8,
tl.tl_ext_attr9,
tl.tl_ext_attr10,
tl.tl_ext_attr11,
tl.tl_ext_attr12,
tl.tl_ext_attr13,
tl.tl_ext_attr14,
tl.tl_ext_attr15,
tl.tl_ext_attr16,
tl.tl_ext_attr17,
tl.tl_ext_attr18,
tl.tl_ext_attr19,
tl.tl_ext_attr20
FROM hz_per_profiles_ext_b b,
hz_per_profiles_ext_tl tl,
hz_per_profiles_ext_sg sg
WHERE
sg.work_unit_number = p_work_unit_number
AND b.person_profile_id = sg.new_profile_id
AND tl.extension_id = b.old_extension_id;
Write_Log(SQL%ROWCOUNT||' records inserted into per tl table.');
SELECT work_unit_number
FROM hz_org_profiles_ext_sg
WHERE status = 'N'
AND ROWNUM =1;
SELECT work_unit_number
FROM hz_per_profiles_ext_sg
WHERE status = 'N'
AND ROWNUM =1;
SELECT *
FROM hz_org_profiles_ext_sg
WHERE status = 'N'
AND work_unit_number = p_work_unit_number
FOR UPDATE NOWAIT;
SELECT *
FROM hz_per_profiles_ext_sg
WHERE status = 'N'
AND work_unit_number = p_work_unit_number
FOR UPDATE NOWAIT;
l_last_updated_by NUMBER;
l_last_update_login NUMBER;
l_last_update_login := hz_utility_v2pub.last_update_login;
l_last_updated_by := hz_utility_v2pub.last_updated_by;
update_staging_status(p_entity_name, l_work_unit_number, 'P');
l_created_by, l_last_updated_by, l_last_update_login);
l_created_by, l_last_updated_by, l_last_update_login);
update_staging_status(p_entity_name, l_work_unit_number, 'C');
SELECT 'Y'
FROM hz_org_profiles_ext_b
WHERE rownum = 1;
SELECT 'Y'
FROM hz_per_profiles_ext_b
WHERE rownum = 1;