DBA Data[Home] [Help]

APPS.PO_CHANGEORDERWF_PVT dependencies on FND_GLOBAL

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

8: g_po_wf_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('PO_SET_DEBUG_WORKFLOW_ON'),'N');
9:
10: -- Read the profile option that determines whether the promise date will be defaulted with need-by date or not
11: g_default_promise_date VARCHAR2(1) := NVL(FND_PROFILE.VALUE('POS_DEFAULT_PROMISE_DATE_ACK'),'N');
12: NL VARCHAR2(1) := fnd_global.newline;
13:
14: /*Initializing Private Procedures/Functions*/
15: PROCEDURE Notify_Requester_Sup_Change( p_header_id in number,
16: p_release_id in number,

Line 132: where user_id = fnd_global.user_id;

128: -- Get Supplier User Name
129: select user_name
130: into l_supplier_username
131: from fnd_user
132: where user_id = fnd_global.user_id;
133:
134: n_varname(1) := 'PO_HEADER_ID';
135: n_varval(1) := p_header_id;
136: n_varname(2) := 'PO_RELEASE_ID';

Line 226: where user_id = fnd_global.user_id;

222: -- Get Supplier User Name
223: select user_name
224: into l_supplier_username
225: from fnd_user
226: where user_id = fnd_global.user_id;
227:
228:
229: n_varname(1) := 'PO_HEADER_ID';
230: n_varval(1) := p_header_id;

Line 400: nvl(fnd_global.user_id, 1),

396: p_doc_type,
397: p_doc_subtype,
398: l_sequence_num,
399: sysdate,
400: nvl(fnd_global.user_id, 1),
401: sysdate,
402: nvl(fnd_global.user_id, 1),
403: p_action,
404: decode(p_action, '',to_date(null,'DD/MM/YYYY'), sysdate),

Line 402: nvl(fnd_global.user_id, 1),

398: l_sequence_num,
399: sysdate,
400: nvl(fnd_global.user_id, 1),
401: sysdate,
402: nvl(fnd_global.user_id, 1),
403: p_action,
404: decode(p_action, '',to_date(null,'DD/MM/YYYY'), sysdate),
405: p_employee_id,
406: p_note,

Line 408: nvl(fnd_global.login_id, 1),

404: decode(p_action, '',to_date(null,'DD/MM/YYYY'), sysdate),
405: p_employee_id,
406: p_note,
407: l_revision_num,
408: nvl(fnd_global.login_id, 1),
409: 0,
410: 0,
411: 0,
412: '',

Line 426: last_updated_by = nvl(fnd_global.user_id, 1),

422: object_type_code = p_doc_type,
423: object_sub_type_code = p_doc_subtype,
424: sequence_num = l_sequence_num,
425: last_update_date = sysdate,
426: last_updated_by = nvl(fnd_global.user_id, 1),
427: creation_date = sysdate,
428: created_by = nvl(fnd_global.user_id, 1),
429: action_code = p_action,
430: action_date = decode(p_action, '',to_date(null,'DD/MM/YYYY'), sysdate),

Line 428: created_by = nvl(fnd_global.user_id, 1),

424: sequence_num = l_sequence_num,
425: last_update_date = sysdate,
426: last_updated_by = nvl(fnd_global.user_id, 1),
427: creation_date = sysdate,
428: created_by = nvl(fnd_global.user_id, 1),
429: action_code = p_action,
430: action_date = decode(p_action, '',to_date(null,'DD/MM/YYYY'), sysdate),
431: employee_id = p_employee_id,
432: note = p_note,

Line 434: last_update_login = nvl(fnd_global.login_id, 1),

430: action_date = decode(p_action, '',to_date(null,'DD/MM/YYYY'), sysdate),
431: employee_id = p_employee_id,
432: note = p_note,
433: object_revision_num = l_revision_num,
434: last_update_login = nvl(fnd_global.login_id, 1),
435: request_id = 0,
436: program_application_id = 0,
437: program_id = 0,
438: program_update_date = '',

Line 830: l_Created_By number := fnd_global.user_id;

826: -- End of Bug 2850566
827: l_Last_Update_Date date;
828: l_Last_Updated_By number;
829: l_Creation_Date date := TRUNC(SYSDATE);
830: l_Created_By number := fnd_global.user_id;
831: l_Po_Header_Id number;
832: l_Po_Release_Id number;
833: l_Action varchar2(240) := 'NEW';
834: l_Action_Date date := TRUNC(SYSDATE);

Line 1265: fnd_global.APPS_INITIALIZE(l_user_id, l_resp_id, l_appl_id);

1261: if (l_user_id is not null and
1262: l_resp_id is not null and
1263: l_appl_id is not null )then
1264:
1265: fnd_global.APPS_INITIALIZE(l_user_id, l_resp_id, l_appl_id);
1266:
1267: else
1268:
1269: initialize (l_agent_id, l_org_id);

Line 6369: l_user_id := FND_GLOBAL.USER_ID;

6365:
6366: -- fix for bug 4946410 added signature flag check( these po's are blocked and changed to 'APPROVED' after background process is run
6367: if((l_authorization_status = 'APPROVED') OR (l_authorization_status = 'PRE-APPROVED' AND l_acceptance_required_flag = 'S')) then
6368: resultout := 'Y';
6369: l_user_id := FND_GLOBAL.USER_ID;
6370: -- For those records which has been approved default the promised date
6371: if(l_authorization_status = 'APPROVED' AND l_acceptance_required_flag = 'Y' AND g_default_promise_date = 'Y') THEN
6372: OPEN getLineLocID(l_change_request_group_id);
6373: LOOP

Line 7578: l_revision_num, l_chg_req_grp_id, fnd_global.user_id, l_err_msg,

7574: aname => 'CHANGE_REQUEST_GROUP_ID');
7575:
7576: x_progress := '001';
7577: ProcessResponse(1.0, l_return_status, l_header_id, l_release_id,
7578: l_revision_num, l_chg_req_grp_id, fnd_global.user_id, l_err_msg,
7579: l_return_code,l_doc_check_rec_type, 'Y', 'Y');
7580:
7581: exception when others then
7582: wf_core.context('PO_ChangeOrderWF_PVT','PROCESS_RESPONSE',x_progress);

Line 7610: l_responded_by :=fnd_global.user_id;

7606:
7607: IF( l_notif_usage = 'BUYER_AUTO_FYI') THEN
7608: l_responded_by :=null;
7609: ELSE
7610: l_responded_by :=fnd_global.user_id;
7611: END IF;
7612:
7613: update po_change_requests
7614: set request_status ='BUYER_APP',

Line 7686: responded_by = fnd_global.user_id,

7682:
7683: update po_change_requests
7684: set request_status ='REJECTED',
7685: change_active_flag = 'N',
7686: responded_by = fnd_global.user_id,
7687: response_date = sysdate
7688: where change_request_group_id = l_chg_req_grp_id
7689: and request_status in ('PENDING','REQ_APP'); -- RDP ( Update records lying in REQ_APP status too)
7690: exception when others then

Line 7758: where user_id = fnd_global.user_id;

7754: -- Get Supplier User Name
7755: select user_name
7756: into l_supplier_username
7757: from fnd_user
7758: where user_id = fnd_global.user_id;
7759:
7760: wf_engine.SetItemAttrText(itemtype => 'POSCHORD',
7761: itemkey => l_item_key,
7762: aname => 'RESP_ID',

Line 7763: avalue => fnd_global.RESP_ID);

7759:
7760: wf_engine.SetItemAttrText(itemtype => 'POSCHORD',
7761: itemkey => l_item_key,
7762: aname => 'RESP_ID',
7763: avalue => fnd_global.RESP_ID);
7764:
7765: wf_engine.SetItemAttrText(itemtype => 'POSCHORD',
7766: itemkey => l_item_key,
7767: aname => 'APPL_RESP_ID',

Line 7768: avalue => fnd_global.RESP_APPL_ID);

7764:
7765: wf_engine.SetItemAttrText(itemtype => 'POSCHORD',
7766: itemkey => l_item_key,
7767: aname => 'APPL_RESP_ID',
7768: avalue => fnd_global.RESP_APPL_ID);
7769:
7770: if(p_release_id is null) then
7771: select agent_id
7772: into l_buyer_agent_id

Line 7994: FND_GLOBAL.APPS_INITIALIZE(l_user_id,l_resp_id,l_resp_appl_id);

7990: IF g_fnd_debug = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
7991: FND_LOG.string(FND_LOG.level_procedure, g_module_prefix ||
7992: l_api_name || '.intialize parameters',l_user_id||'*'||l_resp_id||'*'||l_resp_appl_id );
7993: END IF;
7994: FND_GLOBAL.APPS_INITIALIZE(l_user_id,l_resp_id,l_resp_appl_id);
7995: exception when others then
7996: IF g_fnd_debug = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
7997: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
7998: l_api_name || '.others_exception', sqlerrm);

Line 8370: fnd_global.APPS_INITIALIZE(p_supplier_user_id, p_resp_id, p_appl_resp_id);

8366: IF g_fnd_debug = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
8367: FND_LOG.string(FND_LOG.level_procedure, g_module_prefix || '.SET_SUPPLIER_CONTEXT', 'user_id:'||p_supplier_user_id||'resp:'||p_resp_id||'appl id:'||p_appl_resp_id );
8368: END IF;
8369:
8370: fnd_global.APPS_INITIALIZE(p_supplier_user_id, p_resp_id, p_appl_resp_id);
8371:
8372: EXCEPTION
8373: WHEN OTHERS THEN
8374: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN