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.12010000.3 2009/03/05 05:45:08 hbandi ship $*/
3: -- Start of Comments
4: --
5: -- NAME

Line 6: -- AMS_List_running_total_pvt

2: /* $Header: amslrutb.pls 120.7.12010000.3 2009/03/05 05:45:08 hbandi 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 436: l_string_params AMS_List_running_total_pvt.sql_string_4k;

432: order by alias.query_alias_id;
433:
434:
435: l_filter_sql VARCHAR2(32767) ;
436: l_string_params AMS_List_running_total_pvt.sql_string_4k;
437: l_num_params number := 0;
438: TYPE table_char IS TABLE OF VARCHAR2(200) INDEX BY BINARY_INTEGER;
439: l_table_char table_char;
440: l_string VARCHAR2(32767);

Line 894: AMS_List_running_total_pvt.gen_lov_filter_for_templmv(

890: end if;
891:
892: -- Construct the LOV condirion Start --------------------------- *********************************
893: Ams_Utility_Pvt.Write_Conc_log('Start Construction LOV condition. ');
894: AMS_List_running_total_pvt.gen_lov_filter_for_templmv(
895: l_filter_sql,
896: l_string_params,
897: l_num_params,
898: p_template_id

Line 912: AMS_List_running_total_pvt.gen_constant_filter(

908: retcode:= 2;
909: return;
910: end if;
911:
912: AMS_List_running_total_pvt.gen_constant_filter(
913: l_filter_sql,
914: l_string_params,
915: l_num_params,
916: p_template_id

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

1406:
1407: begin
1408: delete from ams_act_logs where ARC_ACT_LOG_USED_BY =
1409: 'RECL' and ACT_LOG_USED_BY_ID = p_template_id;
1410: -- dbms_output.put_line('IN AMS_List_running_total_pvt----------------------- ');
1411: AMS_Utility_PVT.Create_Log (
1412: x_return_status => l_return_status,
1413: p_arc_log_used_by => 'RECL',
1414: p_log_used_by_id => p_template_id,

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

1523: p_arc_log_used_by => 'RECL',
1524: p_log_used_by_id => p_template_id,
1525: p_msg_data => 'End : Recalculate process ',
1526: p_msg_type => 'DEBUG');
1527: -- dbms_output.put_line('IN AMS_List_running_total_pvt--------------------------------------- ');
1528:
1529: EXCEPTION
1530: WHEN others THEN
1531: AMS_Utility_PVT.Create_Log (

Line 2076: END AMS_List_running_total_pvt;

2072:
2073: END gen_constant_filter;
2074: ------------------------------------
2075:
2076: END AMS_List_running_total_pvt;