DBA Data[Home] [Help]

APPS.WSH_SHIPPING_PARAMS_PVT dependencies on FND_GLOBAL

Line 946: l_user_id number:= fnd_global.user_id;

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(

Line 947: l_login_id number:= fnd_global.login_id;

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,

Line 989: l_user_id number:= fnd_global.user_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);

Line 990: l_login_id number:= fnd_global.login_id;

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);

Line 1382: l_user_id number := fnd_global.user_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;

Line 1383: l_login_id number := fnd_global.login_id;

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;

Line 2042: l_user_id number:= fnd_global.user_id;

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);

Line 2043: l_login_id number:= fnd_global.login_id;

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);

Line 2214: l_user_id number:= fnd_global.user_id;

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);

Line 2215: l_login_id number:= fnd_global.login_id;

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);