942: End Get;
943:
944:
945: Procedure insert_parameter_values (p_ins_ship_par_val_rec parameter_value_rec_typ ) is
946: l_user_id number:= fnd_global.user_id;
947: l_login_id number:= fnd_global.login_id;
948: Begin
949: forall i in p_ins_ship_par_val_rec.class_code.first..p_ins_ship_par_val_rec.class_code.last
950: insert into wsh_shipping_parameter_values(
943:
944:
945: Procedure insert_parameter_values (p_ins_ship_par_val_rec parameter_value_rec_typ ) is
946: l_user_id number:= fnd_global.user_id;
947: l_login_id number:= fnd_global.login_id;
948: Begin
949: forall i in p_ins_ship_par_val_rec.class_code.first..p_ins_ship_par_val_rec.class_code.last
950: insert into wsh_shipping_parameter_values(
951: organization_id,
985:
986: l_ship_par_val_rec parameter_value_rec_typ;
987: l_freight_terms_rec parameter_value_rec_typ;
988:
989: l_user_id number:= fnd_global.user_id;
990: l_login_id number:= fnd_global.login_id;
991: l_debug_on boolean;
992: l_module_name constant varchar(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'CREATE_PARAMETER';
993: l_return_status varchar2(1);
986: l_ship_par_val_rec parameter_value_rec_typ;
987: l_freight_terms_rec parameter_value_rec_typ;
988:
989: l_user_id number:= fnd_global.user_id;
990: l_login_id number:= fnd_global.login_id;
991: l_debug_on boolean;
992: l_module_name constant varchar(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'CREATE_PARAMETER';
993: l_return_status varchar2(1);
994: l_org_name varchar2(2000) := wsh_util_core.get_org_name(p_ship_par_rec.organization_id);
1378: type l_number_tbl is table of number index by binary_integer;
1379:
1380: l_param_name_tbl l_param_name_tbl_type;
1381: l_record_count_tbl l_number_tbl;
1382: l_user_id number := fnd_global.user_id;
1383: l_login_id number := fnd_global.login_id;
1384: l_all_update boolean := FALSE;
1385: l_all_insert boolean := FALSE;
1386: l_update_insert boolean := FALSE;
1379:
1380: l_param_name_tbl l_param_name_tbl_type;
1381: l_record_count_tbl l_number_tbl;
1382: l_user_id number := fnd_global.user_id;
1383: l_login_id number := fnd_global.login_id;
1384: l_all_update boolean := FALSE;
1385: l_all_insert boolean := FALSE;
1386: l_update_insert boolean := FALSE;
1387: l_record_exists boolean := FALSE;
2038: type l_parameter_value_type is table of wsh_shipping_parameter_values.PARAM_VALUE%TYPE index by binary_integer;
2039:
2040: l_freight_terms_value l_parameter_value_type;
2041: l_org_name varchar2(2000) := wsh_util_core.get_org_name(p_freight_terms_rec.organization_id);
2042: l_user_id number:= fnd_global.user_id;
2043: l_login_id number:= fnd_global.login_id;
2044: l_debug_on boolean;
2045: l_module_name constant varchar(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'CREATE_FREIGHT_TERMS';
2046: l_return_status varchar2(10);
2039:
2040: l_freight_terms_value l_parameter_value_type;
2041: l_org_name varchar2(2000) := wsh_util_core.get_org_name(p_freight_terms_rec.organization_id);
2042: l_user_id number:= fnd_global.user_id;
2043: l_login_id number:= fnd_global.login_id;
2044: l_debug_on boolean;
2045: l_module_name constant varchar(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'CREATE_FREIGHT_TERMS';
2046: l_return_status varchar2(10);
2047: l_freight_terms varchar2(240);
2210: and class_code = p_class_code
2211: and param_value = p_param_value
2212: and organization_id = p_organization_id;
2213:
2214: l_user_id number:= fnd_global.user_id;
2215: l_login_id number:= fnd_global.login_id;
2216: l_debug_on boolean;
2217: l_module_name constant varchar(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'UPDATE_FREIGHT_TERMS';
2218: l_return_status varchar2(10);
2211: and param_value = p_param_value
2212: and organization_id = p_organization_id;
2213:
2214: l_user_id number:= fnd_global.user_id;
2215: l_login_id number:= fnd_global.login_id;
2216: l_debug_on boolean;
2217: l_module_name constant varchar(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'UPDATE_FREIGHT_TERMS';
2218: l_return_status varchar2(10);
2219: l_org_name varchar2(2000) := wsh_util_core.get_org_name(p_freight_terms_rec.organization_id);