eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_SHIPPING_PARAMS_PVT dependencies on FND_GLOBAL

Line 891: l_user_id number:= fnd_global.user_id;

887: End Get;
888:
889:
890: Procedure insert_parameter_values (p_ins_ship_par_val_rec parameter_value_rec_typ ) is
891: l_user_id number:= fnd_global.user_id;
892: l_login_id number:= fnd_global.login_id;
893: Begin
894: forall i in p_ins_ship_par_val_rec.class_code.first..p_ins_ship_par_val_rec.class_code.last
895: insert into wsh_shipping_parameter_values(

Line 892: l_login_id number:= fnd_global.login_id;

888:
889:
890: Procedure insert_parameter_values (p_ins_ship_par_val_rec parameter_value_rec_typ ) is
891: l_user_id number:= fnd_global.user_id;
892: l_login_id number:= fnd_global.login_id;
893: Begin
894: forall i in p_ins_ship_par_val_rec.class_code.first..p_ins_ship_par_val_rec.class_code.last
895: insert into wsh_shipping_parameter_values(
896: organization_id,

Line 934: l_user_id number:= fnd_global.user_id;

930:
931: l_ship_par_val_rec parameter_value_rec_typ;
932: l_freight_terms_rec parameter_value_rec_typ;
933:
934: l_user_id number:= fnd_global.user_id;
935: l_login_id number:= fnd_global.login_id;
936: l_debug_on boolean;
937: l_module_name constant varchar(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'CREATE_PARAMETER';
938: l_return_status varchar2(1);

Line 935: l_login_id number:= fnd_global.login_id;

931: l_ship_par_val_rec parameter_value_rec_typ;
932: l_freight_terms_rec parameter_value_rec_typ;
933:
934: l_user_id number:= fnd_global.user_id;
935: l_login_id number:= fnd_global.login_id;
936: l_debug_on boolean;
937: l_module_name constant varchar(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'CREATE_PARAMETER';
938: l_return_status varchar2(1);
939: l_org_name varchar2(2000) := wsh_util_core.get_org_name(p_ship_par_rec.organization_id);

Line 1336: l_user_id number := fnd_global.user_id;

1332: type l_number_tbl is table of number index by binary_integer;
1333:
1334: l_param_name_tbl l_param_name_tbl_type;
1335: l_record_count_tbl l_number_tbl;
1336: l_user_id number := fnd_global.user_id;
1337: l_login_id number := fnd_global.login_id;
1338: l_all_update boolean := FALSE;
1339: l_all_insert boolean := FALSE;
1340: l_update_insert boolean := FALSE;

Line 1337: l_login_id number := fnd_global.login_id;

1333:
1334: l_param_name_tbl l_param_name_tbl_type;
1335: l_record_count_tbl l_number_tbl;
1336: l_user_id number := fnd_global.user_id;
1337: l_login_id number := fnd_global.login_id;
1338: l_all_update boolean := FALSE;
1339: l_all_insert boolean := FALSE;
1340: l_update_insert boolean := FALSE;
1341: l_record_exists boolean := FALSE;

Line 2000: l_user_id number:= fnd_global.user_id;

1996: type l_parameter_value_type is table of wsh_shipping_parameter_values.PARAM_VALUE%TYPE index by binary_integer;
1997:
1998: l_freight_terms_value l_parameter_value_type;
1999: l_org_name varchar2(2000) := wsh_util_core.get_org_name(p_freight_terms_rec.organization_id);
2000: l_user_id number:= fnd_global.user_id;
2001: l_login_id number:= fnd_global.login_id;
2002: l_debug_on boolean;
2003: l_module_name constant varchar(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'CREATE_FREIGHT_TERMS';
2004: l_return_status varchar2(10);

Line 2001: l_login_id number:= fnd_global.login_id;

1997:
1998: l_freight_terms_value l_parameter_value_type;
1999: l_org_name varchar2(2000) := wsh_util_core.get_org_name(p_freight_terms_rec.organization_id);
2000: l_user_id number:= fnd_global.user_id;
2001: l_login_id number:= fnd_global.login_id;
2002: l_debug_on boolean;
2003: l_module_name constant varchar(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'CREATE_FREIGHT_TERMS';
2004: l_return_status varchar2(10);
2005: l_freight_terms varchar2(240);

Line 2172: l_user_id number:= fnd_global.user_id;

2168: and class_code = p_class_code
2169: and param_value = p_param_value
2170: and organization_id = p_organization_id;
2171:
2172: l_user_id number:= fnd_global.user_id;
2173: l_login_id number:= fnd_global.login_id;
2174: l_debug_on boolean;
2175: l_module_name constant varchar(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'UPDATE_FREIGHT_TERMS';
2176: l_return_status varchar2(10);

Line 2173: l_login_id number:= fnd_global.login_id;

2169: and param_value = p_param_value
2170: and organization_id = p_organization_id;
2171:
2172: l_user_id number:= fnd_global.user_id;
2173: l_login_id number:= fnd_global.login_id;
2174: l_debug_on boolean;
2175: l_module_name constant varchar(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'UPDATE_FREIGHT_TERMS';
2176: l_return_status varchar2(10);
2177: l_org_name varchar2(2000) := wsh_util_core.get_org_name(p_freight_terms_rec.organization_id);