DBA Data[Home] [Help]

APPS.AMS_LISTGENERATION_PKG dependencies on AMS_LIST_OPTIONS_PVT

Line 7518: AMS_List_Options_Pvt.apply_size_reduction(p_list_header_id => g_list_header_id ,

7514:
7515:
7516: if l_listheader_rec.generation_type in ('STANDARD','INCREMENTAL') then --lpo
7517: if nvl(g_remote_list_gen,'N') = 'N' then
7518: AMS_List_Options_Pvt.apply_size_reduction(p_list_header_id => g_list_header_id ,
7519: p_log_level => g_log_level,
7520: p_msg_tbl => g_msg_tbl_opt,
7521: x_return_status => x_return_status,
7522: x_msg_count => x_msg_count,

Line 7538: AMS_LIST_OPTIONS_PVT.apply_size_reduction'||'@'||g_database_link||'(:1,:2,:3,:4,:5)'||';'||

7534: else
7535: write_to_act_log('Calling apply_size_reduction procedure in the remote instance.', 'LIST', g_list_header_id,'LOW');
7536: execute immediate
7537: 'BEGIN
7538: AMS_LIST_OPTIONS_PVT.apply_size_reduction'||'@'||g_database_link||'(:1,:2,:3,:4,:5)'||';'||
7539: ' END;'
7540: using g_list_header_id,
7541: 'NULL',
7542: out x_return_status,

Line 10041: AMS_List_Options_Pvt.apply_size_reduction(p_list_header_id => g_list_header_id ,

10037: end if;
10038:
10039: if nvl(g_remote_list_gen,'N') = 'N' then
10040: write_to_Act_log('Calling apply_size_reduction procedure','LIST',g_list_header_id,'LOW');
10041: AMS_List_Options_Pvt.apply_size_reduction(p_list_header_id => g_list_header_id ,
10042: p_log_level => g_log_level,
10043: p_msg_tbl => g_msg_tbl_opt,
10044: x_return_status => x_return_status,
10045: x_msg_count => x_msg_count,

Line 10062: AMS_LIST_OPTIONS_PVT.apply_size_reduction'||'@'||g_database_link||'(:1,:2,:3,:4,:5)'||';'||

10058: else
10059: write_to_Act_log('Calling apply_size_reduction procedure in the remote database','LIST',g_list_header_id,'LOW');
10060: execute immediate
10061: 'BEGIN
10062: AMS_LIST_OPTIONS_PVT.apply_size_reduction'||'@'||g_database_link||'(:1,:2,:3,:4,:5)'||';'||
10063: ' END;'
10064: using g_list_header_id,
10065: 'NULL',
10066: out x_return_status,

Line 10083: AMS_List_Options_Pvt.Control_Group_Generation(p_list_header_id => g_list_header_id,

10079: if l_listheader_rec.generation_type = 'STANDARD' then
10080: --if nvl(l_listheader_rec.generate_control_group_flag,'N') <> 'N' then--for now will have to change it later lpo
10081: if nvl(g_remote_list_gen,'N') = 'N' then
10082: write_to_Act_log('Calling control_group_generation procedure ','LIST',g_list_header_id,'LOW');
10083: AMS_List_Options_Pvt.Control_Group_Generation(p_list_header_id => g_list_header_id,
10084: p_log_level => g_log_level,
10085: p_msg_tbl => g_msg_tbl_opt,
10086: x_ctrl_grp_status => l_ctrl_grp_status,
10087: x_return_status => x_return_status,

Line 10106: AMS_LIST_OPTIONS_PVT.Control_Group_Generation'||'@'||g_database_link||'(:1,:2,:3,:4,:5,:6)'||';'||

10102: else
10103: write_to_Act_log('Calling control_group_generation procedure in the remote database','LIST',g_list_header_id,'LOW');
10104: execute immediate
10105: 'BEGIN
10106: AMS_LIST_OPTIONS_PVT.Control_Group_Generation'||'@'||g_database_link||'(:1,:2,:3,:4,:5,:6)'||';'||
10107: ' END;'
10108: using g_list_header_id,
10109: 'NULL',
10110: out l_ctrl_grp_status,