DBA Data[Home] [Help]

APPS.PO_WF_PO_NOTIFICATION dependencies on FND_GLOBAL

Line 38: NL VARCHAR2(1) := fnd_global.newline;

34: X_min_acct_unit number;
35: /* End Bug# 3972475*/
36: l_supplier po_vendors.vendor_name%type; --Bug 4254468
37: l_supplier_site po_vendor_sites_all.vendor_site_code%type; --Bug 4254468
38: NL VARCHAR2(1) := fnd_global.newline;
39:
40: BEGIN
41:
42: l_item_type := substr(document_id, 1, instr(document_id, ':') - 1);

Line 243: NL VARCHAR2(1) := fnd_global.newline;

239: l_open_form_command VARCHAR2(200);
240: l_view_po_url varchar2(1000); -- HTML Orders R12
241: l_edit_po_url varchar2(1000); -- HTML Orders R12
242:
243: NL VARCHAR2(1) := fnd_global.newline;
244:
245: i NUMBER := 0;
246: max_lines_dsp NUMBER ; --
247: l_line_count NUMBER := 0; -- # lines/shipments on document

Line 975: NL VARCHAR2(1) := fnd_global.newline;

971:
972: l_view_po_url varchar2(1000); -- HTML Orders R12
973: l_edit_po_url varchar2(1000); -- HTML Orders R12
974:
975: NL VARCHAR2(1) := fnd_global.newline;
976:
977: -- Declare TABLEs for each column that is selected
978: -- from history_csr cursor.
979: --

Line 1393: l_session_user_id := fnd_global.user_id;

1389: --Bug 5389914
1390: --Fnd_Profile.Get('USER_ID',l_session_user_id);
1391: --Fnd_Profile.Get('RESP_ID',l_session_resp_id);
1392: --Fnd_Profile.Get('RESP_APPL_ID',l_session_appl_id);
1393: l_session_user_id := fnd_global.user_id;
1394: l_session_resp_id := fnd_global.resp_id;
1395: l_session_appl_id := fnd_global.resp_appl_id;
1396:
1397: IF (l_session_user_id = -1) THEN

Line 1394: l_session_resp_id := fnd_global.resp_id;

1390: --Fnd_Profile.Get('USER_ID',l_session_user_id);
1391: --Fnd_Profile.Get('RESP_ID',l_session_resp_id);
1392: --Fnd_Profile.Get('RESP_APPL_ID',l_session_appl_id);
1393: l_session_user_id := fnd_global.user_id;
1394: l_session_resp_id := fnd_global.resp_id;
1395: l_session_appl_id := fnd_global.resp_appl_id;
1396:
1397: IF (l_session_user_id = -1) THEN
1398: l_session_user_id := NULL;

Line 1395: l_session_appl_id := fnd_global.resp_appl_id;

1391: --Fnd_Profile.Get('RESP_ID',l_session_resp_id);
1392: --Fnd_Profile.Get('RESP_APPL_ID',l_session_appl_id);
1393: l_session_user_id := fnd_global.user_id;
1394: l_session_resp_id := fnd_global.resp_id;
1395: l_session_appl_id := fnd_global.resp_appl_id;
1396:
1397: IF (l_session_user_id = -1) THEN
1398: l_session_user_id := NULL;
1399: END IF;