DBA Data[Home] [Help]

APPS.POR_UTIL_PKG dependencies on FND_GLOBAL

Line 901: l_buffer := l_url || fnd_global.local_chr(38) || 'x_doc_id=' || p_parameter1 || fnd_global.local_chr(38) || 'x_requester_id=';

897: -- Bug 1253957: use window.top.location, so no new window will open up.
898:
899: if (p_function_code = 'POR_RCV_ORDERS_WF') then
900:
901: l_buffer := l_url || fnd_global.local_chr(38) || 'x_doc_id=' || p_parameter1 || fnd_global.local_chr(38) || 'x_requester_id=';
902: l_buffer2 := p_parameter2 || fnd_global.local_chr(38) || 'x_exp_receipt_date=' || p_parameter3|| fnd_global.local_chr(38) || 'x_param=' || p_parameter4 || fnd_global.local_chr(38) ||
903: 'x_org_id=' || p_parameter11;
904:
905: l_buffer := l_buffer || l_buffer2;

Line 902: l_buffer2 := p_parameter2 || fnd_global.local_chr(38) || 'x_exp_receipt_date=' || p_parameter3|| fnd_global.local_chr(38) || 'x_param=' || p_parameter4 || fnd_global.local_chr(38) ||

898:
899: if (p_function_code = 'POR_RCV_ORDERS_WF') then
900:
901: l_buffer := l_url || fnd_global.local_chr(38) || 'x_doc_id=' || p_parameter1 || fnd_global.local_chr(38) || 'x_requester_id=';
902: l_buffer2 := p_parameter2 || fnd_global.local_chr(38) || 'x_exp_receipt_date=' || p_parameter3|| fnd_global.local_chr(38) || 'x_param=' || p_parameter4 || fnd_global.local_chr(38) ||
903: 'x_org_id=' || p_parameter11;
904:
905: l_buffer := l_buffer || l_buffer2;
906:

Line 909: l_buffer := l_url || fnd_global.local_chr(38) || 'x_doc_id=' || p_parameter1 || fnd_global.local_chr(38) ;

905: l_buffer := l_buffer || l_buffer2;
906:
907: else
908:
909: l_buffer := l_url || fnd_global.local_chr(38) || 'x_doc_id=' || p_parameter1 || fnd_global.local_chr(38) ;
910: l_buffer2:= 'x_org_id=' || p_parameter11 ;
911:
912: l_buffer := l_buffer || l_buffer2;
913:

Line 925: l_buffer := 'javascript:void window.open(''' || l_url || fnd_global.local_chr(38) || 'x_doc_id=' || p_parameter1 || fnd_global.local_chr(38) || 'x_requester_id=';

921:
922: else
923:
924: if (p_function_code = 'POR_RCV_ORDERS_WF') then
925: l_buffer := 'javascript:void window.open(''' || l_url || fnd_global.local_chr(38) || 'x_doc_id=' || p_parameter1 || fnd_global.local_chr(38) || 'x_requester_id=';
926: l_buffer2 := p_parameter2||fnd_global.local_chr(38)||'x_exp_receipt_date='||p_parameter3||fnd_global.local_chr(38)||'x_org_id='||p_parameter11||''',''myWindow'',''resizable=yes,scrollbars=yes,menubar=yes,status=yes,width=800,height=600'')';
927: l_buffer := l_buffer || l_buffer2;
928: else
929: -- dbms_output.put_line('URL : ' || l_url);

Line 926: l_buffer2 := p_parameter2||fnd_global.local_chr(38)||'x_exp_receipt_date='||p_parameter3||fnd_global.local_chr(38)||'x_org_id='||p_parameter11||''',''myWindow'',''resizable=yes,scrollbars=yes,menubar=yes,status=yes,width=800,height=600'')';

922: else
923:
924: if (p_function_code = 'POR_RCV_ORDERS_WF') then
925: l_buffer := 'javascript:void window.open(''' || l_url || fnd_global.local_chr(38) || 'x_doc_id=' || p_parameter1 || fnd_global.local_chr(38) || 'x_requester_id=';
926: l_buffer2 := p_parameter2||fnd_global.local_chr(38)||'x_exp_receipt_date='||p_parameter3||fnd_global.local_chr(38)||'x_org_id='||p_parameter11||''',''myWindow'',''resizable=yes,scrollbars=yes,menubar=yes,status=yes,width=800,height=600'')';
927: l_buffer := l_buffer || l_buffer2;
928: else
929: -- dbms_output.put_line('URL : ' || l_url);
930: l_buffer := 'javascript:void window.open(''' || l_url || fnd_global.local_chr(38) || 'x_doc_id=' || p_parameter1 || fnd_global.local_chr(38) ;

Line 930: l_buffer := 'javascript:void window.open(''' || l_url || fnd_global.local_chr(38) || 'x_doc_id=' || p_parameter1 || fnd_global.local_chr(38) ;

926: l_buffer2 := p_parameter2||fnd_global.local_chr(38)||'x_exp_receipt_date='||p_parameter3||fnd_global.local_chr(38)||'x_org_id='||p_parameter11||''',''myWindow'',''resizable=yes,scrollbars=yes,menubar=yes,status=yes,width=800,height=600'')';
927: l_buffer := l_buffer || l_buffer2;
928: else
929: -- dbms_output.put_line('URL : ' || l_url);
930: l_buffer := 'javascript:void window.open(''' || l_url || fnd_global.local_chr(38) || 'x_doc_id=' || p_parameter1 || fnd_global.local_chr(38) ;
931: l_buffer2:= 'x_org_id=' || p_parameter11 || ''',''myWindow'',''resizable=yes,scrollbars=yes,menubar=yes,status=yes,width=800,height=600'')';
932: l_buffer := l_buffer || l_buffer2;
933: end if;
934:

Line 2553: fnd_global.user_id,

2549: 'REQUISITION',
2550: l_pending_emp_id,
2551: 'NO ACTION',
2552: NULL,
2553: fnd_global.user_id,
2554: fnd_global.login_id);
2555: END IF;
2556:
2557: END LOOP;

Line 2554: fnd_global.login_id);

2550: l_pending_emp_id,
2551: 'NO ACTION',
2552: NULL,
2553: fnd_global.user_id,
2554: fnd_global.login_id);
2555: END IF;
2556:
2557: END LOOP;
2558: CLOSE action_cursor;

Line 2567: fnd_global.employee_id,

2563: l_doc_sub_type,
2564: NULL,
2565: 'WITHDRAW',
2566: sysdate,
2567: fnd_global.employee_id,
2568: NULL,
2569: NULL,
2570: NULL,
2571: NULL,

Line 2576: fnd_global.user_id,

2572: NULL,
2573: NULL,
2574: NULL,
2575: NULL,
2576: fnd_global.user_id,
2577: fnd_global.login_id);
2578:
2579: -- Call this API to send notification if the req is no negotiation
2580: po_negotiation_req_notif.call_negotiation_wf('WITHDRAW', p_headerId);

Line 2577: fnd_global.login_id);

2573: NULL,
2574: NULL,
2575: NULL,
2576: fnd_global.user_id,
2577: fnd_global.login_id);
2578:
2579: -- Call this API to send notification if the req is no negotiation
2580: po_negotiation_req_notif.call_negotiation_wf('WITHDRAW', p_headerId);
2581:

Line 3705: if getCLMStatus (fnd_global.user_id, fnd_global.resp_id,fnd_global.resp_appl_id) ='Y' THEN

3701:
3702: FUNCTION get_federal_enabled_flag RETURN VARCHAR2 IS
3703: is_clm_enabled VARCHAR2(1);
3704: BEGIN
3705: if getCLMStatus (fnd_global.user_id, fnd_global.resp_id,fnd_global.resp_appl_id) ='Y' THEN
3706: RETURN 'Y';
3707: ELSE
3708: RETURN 'N';
3709: END IF;

Line 3722: p_user_id := fnd_global.user_id;

3718: p_appl_id NUMBER;
3719: p_proc_name VARCHAR2(100) := 'po.plsql.GET_SECURITY_CLAUSE';
3720: l_secuirty_clause VARCHAR2(1000) := '';
3721: BEGIN
3722: p_user_id := fnd_global.user_id;
3723: p_resp_id := fnd_global.resp_id;
3724: p_appl_id := fnd_global.resp_appl_id;
3725:
3726: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 3723: p_resp_id := fnd_global.resp_id;

3719: p_proc_name VARCHAR2(100) := 'po.plsql.GET_SECURITY_CLAUSE';
3720: l_secuirty_clause VARCHAR2(1000) := '';
3721: BEGIN
3722: p_user_id := fnd_global.user_id;
3723: p_resp_id := fnd_global.resp_id;
3724: p_appl_id := fnd_global.resp_appl_id;
3725:
3726: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3727: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, p_proc_name || '.invoked', 'Enter GET_SECURITY_CLAUSE Function');

Line 3724: p_appl_id := fnd_global.resp_appl_id;

3720: l_secuirty_clause VARCHAR2(1000) := '';
3721: BEGIN
3722: p_user_id := fnd_global.user_id;
3723: p_resp_id := fnd_global.resp_id;
3724: p_appl_id := fnd_global.resp_appl_id;
3725:
3726: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3727: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, p_proc_name || '.invoked', 'Enter GET_SECURITY_CLAUSE Function');
3728: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, p_proc_name || '.invoked', 'p_user_id : ' || p_user_id);

Line 6161: fnd_global.user_id,

6157: NVL((SELECT Max(sequence_num) + 1
6158: FROM PO_CLM_MIPR_ACTION_HISTORY
6159: WHERE requisition_header_id = p_document_id),1),
6160: SYSDATE,
6161: fnd_global.user_id,
6162: SYSDATE,
6163: fnd_global.user_id,
6164: p_action_code,
6165: SYSDATE,

Line 6163: fnd_global.user_id,

6159: WHERE requisition_header_id = p_document_id),1),
6160: SYSDATE,
6161: fnd_global.user_id,
6162: SYSDATE,
6163: fnd_global.user_id,
6164: p_action_code,
6165: SYSDATE,
6166: fnd_global.login_id,
6167: p_remarks,

Line 6166: fnd_global.login_id,

6162: SYSDATE,
6163: fnd_global.user_id,
6164: p_action_code,
6165: SYSDATE,
6166: fnd_global.login_id,
6167: p_remarks,
6168: p_office_details,
6169: p_contact_id,
6170: '');