DBA Data[Home] [Help]

APPS.GMP_BOM_ROUTING_PKG dependencies on DBMS_SESSION

Line 1126: dbms_session.free_unused_user_memory;

1122: v_dummy := 0; /* B8230710 */
1123: l_process_org_cnt := 0;
1124: V_process_Org := NULL;
1125:
1126: dbms_session.free_unused_user_memory;
1127:
1128: /* populate the org_string */
1129: IF gmp_calendar_pkg.org_string(g_instance_id) THEN
1130: NULL ;

Line 2992: dbms_session.free_unused_user_memory;

2988: IF rstep_offsets.COUNT > 0 THEN
2989: rstep_offsets.delete ;
2990: END IF;
2991:
2992: dbms_session.free_unused_user_memory;
2993:
2994: SELECT st.VALUE INTO v_dummy from V$MYSTAT st, V$STATNAME sn
2995: WHERE st.STATISTIC# = sn.STATISTIC#
2996: AND sn.NAME in ('session pga memory max');

Line 7316: dbms_session.free_unused_user_memory;

7312: itm_mtq_sr_instance_id.delete;
7313: itm_mtq_routing_sequence_id.delete;
7314: itm_mtq_from_op_seq_id.delete;
7315:
7316: dbms_session.free_unused_user_memory;
7317:
7318: -- Vpedarla Bug: 8230710
7319: SELECT st.VALUE INTO v_dummy from V$MYSTAT st, V$STATNAME sn
7320: WHERE st.STATISTIC# = sn.STATISTIC#