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);
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; --
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: --
978: -- from history_csr cursor.
979: --
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
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;
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;