APPS.AMS_LIST_RUNNING_TOTAL_PVT dependencies on AMS_LIST_RUNNING_TOTAL_PVT

Line 1: PACKAGE BODY AMS_List_running_total_pvt AS

1: PACKAGE BODY AMS_List_running_total_pvt AS
2: /* $Header: amslrutb.pls 120.7 2006/06/28 19:16:25 dgyawali ship $*/
3: -- Start of Comments
4: --
5: -- NAME

Line 6: -- AMS_List_running_total_pvt

2: /* $Header: amslrutb.pls 120.7 2006/06/28 19:16:25 dgyawali ship $*/
3: -- Start of Comments
4: --
5: -- NAME
6: -- AMS_List_running_total_pvt
7: --
8: -- PURPOSE
9: -- This package calculates the running totals
10: --

Line 415: l_string_params AMS_List_running_total_pvt.sql_string_4k;

411: order by alias.query_alias_id;
412:
413:
414: l_filter_sql VARCHAR2(32767) ;
415: l_string_params AMS_List_running_total_pvt.sql_string_4k;
416: l_num_params number := 0;
417: TYPE table_char IS TABLE OF VARCHAR2(200) INDEX BY BINARY_INTEGER;
418: l_table_char table_char;
419: l_string VARCHAR2(32767);

Line 828: AMS_List_running_total_pvt.gen_lov_filter_for_templmv(

824: end if;
825:
826: -- Construct the LOV condirion Start --------------------------- *********************************
827: Ams_Utility_Pvt.Write_Conc_log('Start Construction LOV condition. ');
828: AMS_List_running_total_pvt.gen_lov_filter_for_templmv(
829: l_filter_sql,
830: l_string_params,
831: l_num_params,
832: p_template_id

Line 846: AMS_List_running_total_pvt.gen_constant_filter(

842: retcode:= 2;
843: return;
844: end if;
845:
846: AMS_List_running_total_pvt.gen_constant_filter(
847: l_filter_sql,
848: l_string_params,
849: l_num_params,
850: p_template_id

Line 1344: -- dbms_output.put_line('IN AMS_List_running_total_pvt----------------------- ');

1340:
1341: begin
1342: delete from ams_act_logs where ARC_ACT_LOG_USED_BY =
1343: 'RECL' and ACT_LOG_USED_BY_ID = p_template_id;
1344: -- dbms_output.put_line('IN AMS_List_running_total_pvt----------------------- ');
1345: AMS_Utility_PVT.Create_Log (
1346: x_return_status => l_return_status,
1347: p_arc_log_used_by => 'RECL',
1348: p_log_used_by_id => p_template_id,

Line 1461: -- dbms_output.put_line('IN AMS_List_running_total_pvt--------------------------------------- ');

1457: p_arc_log_used_by => 'RECL',
1458: p_log_used_by_id => p_template_id,
1459: p_msg_data => 'End : Recalculate process ',
1460: p_msg_type => 'DEBUG');
1461: -- dbms_output.put_line('IN AMS_List_running_total_pvt--------------------------------------- ');
1462:
1463: EXCEPTION
1464: WHEN others THEN
1465: AMS_Utility_PVT.Create_Log (

Line 2010: END AMS_List_running_total_pvt;

2006:
2007: END gen_constant_filter;
2008: ------------------------------------
2009:
2010: END AMS_List_running_total_pvt;