APPS.WMS_SEARCH_ORDER_GLOBALS_PVT dependencies on FND_GLOBAL

Line 583: l_user_id := fnd_global.user_id;

579: /* get who column information */
580:
581: SELECT Sysdate INTO l_date FROM dual;
582:
583: l_user_id := fnd_global.user_id;
584: l_login_id := fnd_global.login_id;
585:
586: -- select rawtohex(dbms_session.unique_session_id) into l_sid from dual;
587:

Line 584: l_login_id := fnd_global.login_id;

580:
581: SELECT Sysdate INTO l_date FROM dual;
582:
583: l_user_id := fnd_global.user_id;
584: l_login_id := fnd_global.login_id;
585:
586: -- select rawtohex(dbms_session.unique_session_id) into l_sid from dual;
587:
588:

Line 700: l_user_id := fnd_global.user_id;

696: if ( nvl(p_header_id ,0 ) > 0 and nvl(p_rule_id,0) > 0 ) then
697:
698: /* get who column information */
699: SELECT Sysdate INTO l_date FROM dual;
700: l_user_id := fnd_global.user_id;
701: l_login_id := fnd_global.login_id;
702:
703: -- l_pre_suggestions := p_pre_suggestions ;
704: l_header_id := p_header_id;

Line 701: l_login_id := fnd_global.login_id;

697:
698: /* get who column information */
699: SELECT Sysdate INTO l_date FROM dual;
700: l_user_id := fnd_global.user_id;
701: l_login_id := fnd_global.login_id;
702:
703: -- l_pre_suggestions := p_pre_suggestions ;
704: l_header_id := p_header_id;
705: l_rule_id := p_rule_id;

Line 1161: l_user_id := fnd_global.user_id;

1157: l_user_id number;
1158: l_login_id number;
1159: BEGIN
1160:
1161: l_user_id := fnd_global.user_id;
1162: l_login_id := fnd_global.login_id;
1163: -- Deleteing all trace records created in simulation mode for this user
1164: delete wms_rule_trace_lines
1165: where header_id in (select header_id

Line 1162: l_login_id := fnd_global.login_id;

1158: l_login_id number;
1159: BEGIN
1160:
1161: l_user_id := fnd_global.user_id;
1162: l_login_id := fnd_global.login_id;
1163: -- Deleteing all trace records created in simulation mode for this user
1164: delete wms_rule_trace_lines
1165: where header_id in (select header_id
1166: from wms_rule_trace_headers