[Home] [Help]
12: -- Enter procedure, function bodies as shown below
13:
14: g_table_name1 CONSTANT VARCHAR2(30) := 'MTL_PARAMETERS';
15: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSM_MTL_PARAMETERS_ACC';
16: g_acc_sequence_name1 CONSTANT VARCHAR2(30) := 'CSM_MTL_PARAMETERS_ACC_S';
17: g_publication_item_name1 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
18: CSM_ACC_PKG.t_publication_item_list('CSM_MTL_PARAMETERS');
19: g_pk1_name1 CONSTANT VARCHAR2(30) := 'ORGANIZATION_ID';
20: g_pub_item CONSTANT VARCHAR2(30) := 'CSM_MTL_PARAMETERS';
152: --get the users with this language
153: l_all_omfs_palm_resource_list := l_null_resource_list;
154: l_all_omfs_palm_resource_list := csm_util_pkg.get_all_omfs_palm_res_list;
155:
156: SELECT csm_mtl_parameters_acc_s.nextval
157: INTO l_access_id
158: FROM dual;
159:
160: --nullify the access list
237:
238: -- inserts cur
239: CURSOR c_mtl_parameters_ins_csr(b_user_id NUMBER,b_res_id NUMBER)
240: IS
241: SELECT csm_mtl_parameters_acc_s.nextval as ACCESS_ID,b_user_id as USER_ID, from_organization_id,to_organization_id
242: FROM ( SELECT distinct mtsn.from_organization_id,mtsn.to_organization_id
243: FROM MTL_INTERORG_PARAMETERS mtsn,csp_inv_loc_assignments inv
244: WHERE b_res_id =inv.resource_id
245: AND inv.organization_id in (mtsn.from_organization_id,mtsn.to_organization_id)
424:
425: -- inserts cur
426: CURSOR c_inv_org_freights_ins_csr
427: IS
428: SELECT csm_mtl_parameters_acc_s.nextval as ACCESS_ID,au.user_id, oft.organization_id,oft.freight_code,sm.ship_method_code
429: FROM ORG_FREIGHT_TL oft,asg_user au,WSH_CARRIER_SHIP_METHODS_V sm
430: WHERE oft.LANGUAGE=au.language
431: and nvl(oft.disable_date,sysdate+1) > sysdate
432: AND oft.organization_id=sm.organization_id(+)