APPS.MSC_CL_GMP_UTILITY dependencies on DBMS_SESSION

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

1442: first_step_row := 0 ;
1443: v_dummy := 0 ;
1444: s := 1 ;
1445:
1446: dbms_session.free_unused_user_memory;/* akaruppa B5007729 */
1447:
1448: /* populate the org_string */
1449: IF MSC_CL_GMP_UTILITY.org_string(g_instance_id) THEN
1450: NULL ;

Line 2818: dbms_session.free_unused_user_memory;

2814: IF rstep_offsets.COUNT > 0 THEN
2815: rstep_offsets.delete ;
2816: END IF;
2817:
2818: dbms_session.free_unused_user_memory;
2819:
2820: SELECT st.VALUE INTO v_dummy from V$MYSTAT st, V$STATNAME sn
2821: WHERE st.STATISTIC# = sn.STATISTIC#
2822: AND sn.NAME in ('session pga memory max');

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

7074: opr_index := 0 ;
7075: rs_index := 0 ;
7076: oc_index := 0 ;
7077:
7078: dbms_session.free_unused_user_memory;/* akaruppa B5007729 */
7079:
7080:
7081: return_status := TRUE ;
7082: EXCEPTION

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

9920: jo_organization_id := empty_num_table ;
9921: jo_department_id := empty_num_table ;
9922: jo_minimum_transfer_quantity := empty_num_table ;
9923:
9924: dbms_session.free_unused_user_memory;/* akaruppa B5007729 */
9925:
9926: /* ----------------------- Job Operations --------------------- */
9927:
9928: return_status := TRUE;

Line 10754: dbms_session.free_unused_user_memory;

10750: o_deleted_flag := empty_num_table ;
10751: o_subinventory_code := e_subinventory_code;
10752: o_non_nettable_qty := empty_num_table ;
10753:
10754: dbms_session.free_unused_user_memory;
10755:
10756: /* akaruppa B5007729 End*/
10757:
10758: return_status := TRUE;

Line 15237: dbms_session.free_unused_user_memory;

15233: f_date := empty_dat_table;
15234: t_date := empty_dat_table;
15235:
15236: /* 8i Database does not support BULK COLLECT - B3881832 */
15237: dbms_session.free_unused_user_memory;
15238:
15239: stmt_no := 72;
15240: -- Rajesh Patangya B4692705, When the calendar is not assigned to
15241: -- resource then organization calendar should be considered

Line 15839: dbms_session.free_unused_user_memory;

15835: f_date := empty_dat_table;
15836: t_date := empty_dat_table;
15837: j:= 0 ;
15838: /* 8i Database does not support BULK COLLECT - B3881832 */
15839: dbms_session.free_unused_user_memory;
15840: COMMIT ;
15841:
15842: END IF; /* Only if any resource */
15843: END;

Line 15923: dbms_session.free_unused_user_memory;

15919: shift_num := empty_num_table;
15920: f_date := empty_dat_table;
15921: t_date := empty_dat_table;
15922: /* 8i Database does not support BULK COLLECT - B3881832 */
15923: dbms_session.free_unused_user_memory;
15924:
15925: END IF; /* Only if any resource */
15926: END ;
15927:

Line 17219: dbms_session.free_unused_user_memory;

17215: shift_num := empty_num_table;
17216: f_date := empty_dat_table;
17217: t_date := empty_dat_table;
17218: /* 8i Database does not support BULK COLLECT - B3881832 */
17219: dbms_session.free_unused_user_memory;
17220:
17221: stmt_no := 60;
17222: -- Rajesh Patangya B4692705, When the calendar is not assigned to
17223: -- resource then organization calendar should be considered

Line 17731: dbms_session.free_unused_user_memory;

17727: f_date := empty_dat_table;
17728: t_date := empty_dat_table;
17729: j := 0 ;
17730: /* 8i Database does not support BULK COLLECT - B3881832 */
17731: dbms_session.free_unused_user_memory;
17732:
17733: END IF; /* Only if any resource */
17734:
17735: j := j + 1 ;

Line 17816: dbms_session.free_unused_user_memory;

17812: equipment_item_id := empty_num_table;
17813: f_date := empty_dat_table;
17814: t_date := empty_dat_table;
17815: /* 8i Database does not support BULK COLLECT - B3881832 */
17816: dbms_session.free_unused_user_memory;
17817: COMMIT ;
17818:
17819: END IF; /* Only if any resource */
17820: