DBA Data[Home] [Help]

APPS.AMS_LISTGENERATION_PKG dependencies on AMS_CELL_PVT

Line 3728: write_to_act_log('Calling ams_cell_pvt.get_comp_sql to get the sql', 'LIST', g_list_header_id,'LOW');

3724: l_sql_string_final varchar2(4000);
3725: j number := 1;
3726: BEGIN
3727: write_to_act_log('Executing process_cell since segment has been included in list/target group selections.', 'LIST', g_list_header_id,'LOW');
3728: write_to_act_log('Calling ams_cell_pvt.get_comp_sql to get the sql', 'LIST', g_list_header_id,'LOW');
3729: ams_cell_pvt.get_comp_sql(
3730: p_api_version => 1.0,
3731: p_init_msg_list => FND_API.g_false,
3732: p_validation_level => FND_API.g_valid_level_full,

Line 3729: ams_cell_pvt.get_comp_sql(

3725: j number := 1;
3726: BEGIN
3727: write_to_act_log('Executing process_cell since segment has been included in list/target group selections.', 'LIST', g_list_header_id,'LOW');
3728: write_to_act_log('Calling ams_cell_pvt.get_comp_sql to get the sql', 'LIST', g_list_header_id,'LOW');
3729: ams_cell_pvt.get_comp_sql(
3730: p_api_version => 1.0,
3731: p_init_msg_list => FND_API.g_false,
3732: p_validation_level => FND_API.g_valid_level_full,
3733: x_return_status => x_return_status,

Line 3740: write_to_act_log('Procedure ams_cell_pvt.get_comp_sql executed. Return status is '||x_return_status, 'LIST', g_list_header_id,'LOW');

3736: p_cell_id => p_incl_object_id ,
3737: p_party_id_only => FND_API.g_true, --bug 4635925
3738: x_sql_tbl => l_sql_2
3739: );
3740: write_to_act_log('Procedure ams_cell_pvt.get_comp_sql executed. Return status is '||x_return_status, 'LIST', g_list_header_id,'LOW');
3741: l_sql_string_final := '';
3742: for i in 1 .. l_sql_2.last
3743: loop
3744: l_sql_string_final := l_sql_string_final || l_sql_2(i);

Line 12814: ams_cell_pvt.get_comp_sql(

12810: j number := 1;
12811: BEGIN
12812:
12813: write_to_act_log('Executing procedure process_run_total_cell', 'LIST', g_list_header_id,'LOW' );
12814: ams_cell_pvt.get_comp_sql(
12815: p_api_version => 1.0,
12816: p_init_msg_list => FND_API.g_false,
12817: p_validation_level => FND_API.g_valid_level_full,
12818: x_return_status => x_return_status,