DBA Data[Home] [Help]

APPS.AMS_LISTGENERATION_PKG dependencies on AMS_LIST_OPTIONS_PVT

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

7602:
7603:
7604: if l_listheader_rec.generation_type in ('STANDARD','INCREMENTAL') then --lpo
7605: if nvl(g_remote_list_gen,'N') = 'N' then
7606: AMS_List_Options_Pvt.apply_size_reduction(p_list_header_id => g_list_header_id ,
7607: p_log_level => g_log_level,
7608: p_msg_tbl => g_msg_tbl_opt,
7609: x_return_status => x_return_status,
7610: x_msg_count => x_msg_count,

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

7622: else
7623: write_to_act_log('Calling apply_size_reduction procedure in the remote instance.', 'LIST', g_list_header_id,'LOW');
7624: execute immediate
7625: 'BEGIN
7626: AMS_LIST_OPTIONS_PVT.apply_size_reduction'||'@'||g_database_link||'(:1,:2,:3,:4,:5)'||';'||
7627: ' END;'
7628: using g_list_header_id,
7629: 'NULL',
7630: out x_return_status,

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

10138: end if;
10139:
10140: if nvl(g_remote_list_gen,'N') = 'N' then
10141: write_to_Act_log('Calling apply_size_reduction procedure','LIST',g_list_header_id,'LOW');
10142: AMS_List_Options_Pvt.apply_size_reduction(p_list_header_id => g_list_header_id ,
10143: p_log_level => g_log_level,
10144: p_msg_tbl => g_msg_tbl_opt,
10145: x_return_status => x_return_status,
10146: x_msg_count => x_msg_count,

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

10159: else
10160: write_to_Act_log('Calling apply_size_reduction procedure in the remote database','LIST',g_list_header_id,'LOW');
10161: execute immediate
10162: 'BEGIN
10163: AMS_LIST_OPTIONS_PVT.apply_size_reduction'||'@'||g_database_link||'(:1,:2,:3,:4,:5)'||';'||
10164: ' END;'
10165: using g_list_header_id,
10166: 'NULL',
10167: out x_return_status,

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

10180: if l_listheader_rec.generation_type = 'STANDARD' then
10181: --if nvl(l_listheader_rec.generate_control_group_flag,'N') <> 'N' then--for now will have to change it later lpo
10182: if nvl(g_remote_list_gen,'N') = 'N' then
10183: write_to_Act_log('Calling control_group_generation procedure ','LIST',g_list_header_id,'LOW');
10184: AMS_List_Options_Pvt.Control_Group_Generation(p_list_header_id => g_list_header_id,
10185: p_log_level => g_log_level,
10186: p_msg_tbl => g_msg_tbl_opt,
10187: x_ctrl_grp_status => l_ctrl_grp_status,
10188: x_return_status => x_return_status,

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

10203: else
10204: write_to_Act_log('Calling control_group_generation procedure in the remote database','LIST',g_list_header_id,'LOW');
10205: execute immediate
10206: 'BEGIN
10207: AMS_LIST_OPTIONS_PVT.Control_Group_Generation'||'@'||g_database_link||'(:1,:2,:3,:4,:5,:6)'||';'||
10208: ' END;'
10209: using g_list_header_id,
10210: 'NULL',
10211: out l_ctrl_grp_status,