DBA Data[Home] [Help]

APPS.GHR_HISTORY_API dependencies on GHR_SES_CONV_PKG

Line 1335: hr_utility.set_location(l_proc || ' g_do_not_cascade ' || ghr_ses_conv_pkg.g_do_not_cascade, 76);

1331: lower(ghr_history_api.g_eleent_table),
1332: lower(ghr_history_api.g_perana_table)) then
1333: -- this is the normal case for most of the tables we are tracking.
1334:
1335: hr_utility.set_location(l_proc || ' g_do_not_cascade ' || ghr_ses_conv_pkg.g_do_not_cascade, 76);
1336:
1337: if nvl(ghr_ses_conv_pkg.g_do_not_cascade,'N') <> 'Y' then
1338: ghr_history_cascade.Cascade_History_Data(
1339: p_table_name => upper(g_operation_info(indx).table_name),

Line 1337: if nvl(ghr_ses_conv_pkg.g_do_not_cascade,'N') <> 'Y' then

1333: -- this is the normal case for most of the tables we are tracking.
1334:
1335: hr_utility.set_location(l_proc || ' g_do_not_cascade ' || ghr_ses_conv_pkg.g_do_not_cascade, 76);
1336:
1337: if nvl(ghr_ses_conv_pkg.g_do_not_cascade,'N') <> 'Y' then
1338: ghr_history_cascade.Cascade_History_Data(
1339: p_table_name => upper(g_operation_info(indx).table_name),
1340: p_person_id => l_session_var.person_id,
1341: p_pre_record => l_pre_record,

Line 1395: hr_utility.set_location(l_proc || ' g_do_not_cascade ' || ghr_ses_conv_pkg.g_do_not_cascade, 78);

1391:
1392: if l_interv_on_table then
1393: -- if changes were cascaded in the history table then we may have to cascade
1394: -- changes in database tables
1395: hr_utility.set_location(l_proc || ' g_do_not_cascade ' || ghr_ses_conv_pkg.g_do_not_cascade, 78);
1396:
1397: if nvl(ghr_ses_conv_pkg.g_do_not_cascade,'N') <> 'Y' then
1398: IF NVL(l_post_data.information5,'N') <> 'GHR_US_RETAINED_GRADE' then -- Bug 2715828/3021003
1399: -- NO need to cascade for Retained Grade.

Line 1397: if nvl(ghr_ses_conv_pkg.g_do_not_cascade,'N') <> 'Y' then

1393: -- if changes were cascaded in the history table then we may have to cascade
1394: -- changes in database tables
1395: hr_utility.set_location(l_proc || ' g_do_not_cascade ' || ghr_ses_conv_pkg.g_do_not_cascade, 78);
1396:
1397: if nvl(ghr_ses_conv_pkg.g_do_not_cascade,'N') <> 'Y' then
1398: IF NVL(l_post_data.information5,'N') <> 'GHR_US_RETAINED_GRADE' then -- Bug 2715828/3021003
1399: -- NO need to cascade for Retained Grade.
1400: ghr_history_cascade.Cascade_appl_table_Data (
1401: p_table_name => upper(g_operation_info(indx).table_name),