APPS.MSC_CL_GMP_UTILITY dependencies on DBMS_SESSION

Line 1482: dbms_session.free_unused_user_memory;/* akaruppa B5007729 */

1478: dtl_i := 0 ;
1479: v_dummy := 0 ;
1480:
1481:
1482: dbms_session.free_unused_user_memory;/* akaruppa B5007729 */
1483:
1484: /* populate the org_string */
1485: IF MSC_CL_GMP_UTILITY.org_string(g_instance_id) THEN
1486: NULL ;

Line 2125: dbms_session.free_unused_user_memory;

2121: subst_tab.delete;
2122: prev_detail_tab.delete;
2123: orig_detail_tab.delete;
2124:
2125: dbms_session.free_unused_user_memory;
2126:
2127: -- Bug: 6030499 VPedarla end of item substuition code
2128:
2129:

Line 3132: dbms_session.free_unused_user_memory;

3128: IF rstep_offsets.COUNT > 0 THEN
3129: rstep_offsets.delete ;
3130: END IF;
3131:
3132: dbms_session.free_unused_user_memory;
3133:
3134: SELECT st.VALUE INTO v_dummy from V$MYSTAT st, V$STATNAME sn
3135: WHERE st.STATISTIC# = sn.STATISTIC#
3136: AND sn.NAME in ('session pga memory max');

Line 7558: dbms_session.free_unused_user_memory;/* akaruppa B5007729 */

7554:
7555: --bug: 6851919 end of changes
7556:
7557:
7558: dbms_session.free_unused_user_memory;/* akaruppa B5007729 */
7559:
7560:
7561: return_status := TRUE ;
7562: EXCEPTION

Line 10175: dbms_session.free_unused_user_memory;

10171: /* Bug:6030499 Vpedarla conditionalsing the insert code */
10172:
10173: IF ( NOT collect_ps_data ) THEN
10174: return_status := TRUE;
10175: dbms_session.free_unused_user_memory;
10176: RETURN;
10177: END IF;
10178:
10179:

Line 10569: dbms_session.free_unused_user_memory;/* akaruppa B5007729 */

10565:
10566: -- Bug: 6030499 Vpedarla end of conditionalised code
10567:
10568:
10569: dbms_session.free_unused_user_memory;/* akaruppa B5007729 */
10570:
10571: /* ----------------------- Job Operations --------------------- */
10572:
10573: return_status := TRUE;

Line 11441: dbms_session.free_unused_user_memory;

11437: o_deleted_flag := empty_pls_table ;
11438: o_subinventory_code := e_subinventory_code;
11439: o_non_nettable_qty := empty_num_table ;
11440:
11441: dbms_session.free_unused_user_memory;
11442:
11443: /* akaruppa B5007729 End*/
11444:
11445: return_status := TRUE;

Line 18075: dbms_session.free_unused_user_memory;

18071: shift_num := empty_pls_table;
18072: f_date := empty_dat_table;
18073: t_date := empty_dat_table;
18074: /* 8i Database does not support BULK COLLECT - B3881832 */
18075: dbms_session.free_unused_user_memory;
18076:
18077: stmt_no := 60;
18078: -- Rajesh Patangya B4692705, When the calendar is not assigned to
18079: -- resource then organization calendar should be considered

Line 18590: dbms_session.free_unused_user_memory;

18586: f_date := empty_dat_table;
18587: t_date := empty_dat_table;
18588: j := 0 ;
18589: /* 8i Database does not support BULK COLLECT - B3881832 */
18590: dbms_session.free_unused_user_memory;
18591:
18592: END IF; /* Only if any resource */
18593:
18594: j := j + 1 ;

Line 18685: dbms_session.free_unused_user_memory;

18681: equipment_item_id := empty_pls_table;
18682: f_date := empty_dat_table;
18683: t_date := empty_dat_table;
18684: /* 8i Database does not support BULK COLLECT - B3881832 */
18685: dbms_session.free_unused_user_memory;
18686: COMMIT ;
18687:
18688: END IF; /* Only if any resource */
18689: