eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_REQCHANGEREQUESTWF_PVT dependencies on FND_GLOBAL

Line 1757: fnd_global.user_id,

1753: 'N',
1754: pcr2.response_date,
1755: pcr2.response_reason,
1756: pcr2.responded_by,
1757: fnd_global.user_id,
1758: fnd_global.login_id,
1759: sysdate
1760: from po_change_requests pcr2
1761: where pcr2.parent_change_request_id=pcr1.change_request_id

Line 1758: fnd_global.login_id,

1754: pcr2.response_date,
1755: pcr2.response_reason,
1756: pcr2.responded_by,
1757: fnd_global.user_id,
1758: fnd_global.login_id,
1759: sysdate
1760: from po_change_requests pcr2
1761: where pcr2.parent_change_request_id=pcr1.change_request_id
1762: and pcr2.change_request_group_id=p_change_request_group_id

Line 1800: fnd_global.user_id,

1796: 'N',
1797: pcr2.response_date,
1798: pcr2.response_reason,
1799: pcr2.responded_by,
1800: fnd_global.user_id,
1801: fnd_global.login_id,
1802: sysdate
1803: from po_change_requests pcr2
1804: where pcr2.parent_change_request_id in

Line 1801: fnd_global.login_id,

1797: pcr2.response_date,
1798: pcr2.response_reason,
1799: pcr2.responded_by,
1800: fnd_global.user_id,
1801: fnd_global.login_id,
1802: sysdate
1803: from po_change_requests pcr2
1804: where pcr2.parent_change_request_id in
1805: ( select pcr3.change_request_id

Line 1839: last_updated_by = fnd_global.user_id,

1835: UPDATE po_line_locations_all
1836: SET
1837: approved_flag = 'Y',
1838: last_update_date = sysdate,
1839: last_updated_by = fnd_global.user_id,
1840: last_update_login = fnd_global.login_id
1841: WHERE line_location_id IN
1842: (SELECT document_line_location_id
1843: FROM po_change_requests

Line 1840: last_update_login = fnd_global.login_id

1836: SET
1837: approved_flag = 'Y',
1838: last_update_date = sysdate,
1839: last_updated_by = fnd_global.user_id,
1840: last_update_login = fnd_global.login_id
1841: WHERE line_location_id IN
1842: (SELECT document_line_location_id
1843: FROM po_change_requests
1844: WHERE

Line 1880: last_updated_by = fnd_global.user_id,

1876: update po_headers_all
1877: set AUTHORIZATION_STATUS = 'APPROVED',
1878: approved_flag='Y',
1879: CHANGE_REQUESTED_BY=null,
1880: last_updated_by = fnd_global.user_id,
1881: last_update_login = fnd_global.login_id,
1882: last_update_date = sysdate
1883: where po_header_id = l_document_id;
1884: else

Line 1881: last_update_login = fnd_global.login_id,

1877: set AUTHORIZATION_STATUS = 'APPROVED',
1878: approved_flag='Y',
1879: CHANGE_REQUESTED_BY=null,
1880: last_updated_by = fnd_global.user_id,
1881: last_update_login = fnd_global.login_id,
1882: last_update_date = sysdate
1883: where po_header_id = l_document_id;
1884: else
1885: l_document_subtype := 'BLANKET';

Line 1892: last_updated_by = fnd_global.user_id,

1888: update po_releases_all
1889: set AUTHORIZATION_STATUS = 'APPROVED',
1890: approved_flag='Y',
1891: CHANGE_REQUESTED_BY=null,
1892: last_updated_by = fnd_global.user_id,
1893: last_update_login = fnd_global.login_id,
1894: last_update_date = sysdate
1895: where po_release_id = l_release_id;
1896: end if;

Line 1893: last_update_login = fnd_global.login_id,

1889: set AUTHORIZATION_STATUS = 'APPROVED',
1890: approved_flag='Y',
1891: CHANGE_REQUESTED_BY=null,
1892: last_updated_by = fnd_global.user_id,
1893: last_update_login = fnd_global.login_id,
1894: last_update_date = sysdate
1895: where po_release_id = l_release_id;
1896: end if;
1897:

Line 1977: fnd_global.user_id,

1973: 'N',
1974: pcr2.response_date,
1975: pcr2.response_reason,
1976: pcr2.responded_by,
1977: fnd_global.user_id,
1978: fnd_global.login_id,
1979: sysdate
1980: from po_change_requests pcr2
1981: where pcr2.parent_change_request_id=pcr1.change_request_id

Line 1978: fnd_global.login_id,

1974: pcr2.response_date,
1975: pcr2.response_reason,
1976: pcr2.responded_by,
1977: fnd_global.user_id,
1978: fnd_global.login_id,
1979: sysdate
1980: from po_change_requests pcr2
1981: where pcr2.parent_change_request_id=pcr1.change_request_id
1982: and pcr2.change_request_group_id=p_change_request_group_id

Line 2020: last_updated_by = fnd_global.user_id,

2016: update po_headers_all set
2017: AUTHORIZATION_STATUS = 'IN PROCESS',
2018: -- approved_flag='N',
2019: CHANGE_REQUESTED_BY='REQUESTER',
2020: last_updated_by = fnd_global.user_id,
2021: last_update_login = fnd_global.login_id,
2022: last_update_date = sysdate
2023: where po_header_id = l_document_id;
2024: else

Line 2021: last_update_login = fnd_global.login_id,

2017: AUTHORIZATION_STATUS = 'IN PROCESS',
2018: -- approved_flag='N',
2019: CHANGE_REQUESTED_BY='REQUESTER',
2020: last_updated_by = fnd_global.user_id,
2021: last_update_login = fnd_global.login_id,
2022: last_update_date = sysdate
2023: where po_header_id = l_document_id;
2024: else
2025: -- fix bug 2733373. when change is submitted, and wait

Line 2032: last_updated_by = fnd_global.user_id,

2028: update po_releases_all set
2029: AUTHORIZATION_STATUS = 'IN PROCESS',
2030: -- approved_flag='N',
2031: CHANGE_REQUESTED_BY='REQUESTER',
2032: last_updated_by = fnd_global.user_id,
2033: last_update_login = fnd_global.login_id,
2034: last_update_date = sysdate
2035: where po_release_id = l_release_id;
2036: end if;

Line 2033: last_update_login = fnd_global.login_id,

2029: AUTHORIZATION_STATUS = 'IN PROCESS',
2030: -- approved_flag='N',
2031: CHANGE_REQUESTED_BY='REQUESTER',
2032: last_updated_by = fnd_global.user_id,
2033: last_update_login = fnd_global.login_id,
2034: last_update_date = sysdate
2035: where po_release_id = l_release_id;
2036: end if;
2037: x_progress:='CANCELLATION:008';

Line 2329: fnd_global.user_id,

2325: 'N',
2326: pcr2.response_date,
2327: pcr2.response_reason,
2328: pcr2.responded_by,
2329: fnd_global.user_id,
2330: fnd_global.login_id,
2331: sysdate
2332: from po_change_requests pcr2
2333: where pcr2.parent_change_request_id=pcr1.change_request_id

Line 2330: fnd_global.login_id,

2326: pcr2.response_date,
2327: pcr2.response_reason,
2328: pcr2.responded_by,
2329: fnd_global.user_id,
2330: fnd_global.login_id,
2331: sysdate
2332: from po_change_requests pcr2
2333: where pcr2.parent_change_request_id=pcr1.change_request_id
2334: and pcr2.change_request_group_id=p_change_request_group_id

Line 2373: fnd_global.user_id,

2369: 'N',
2370: pcr2.response_date,
2371: pcr2.response_reason,
2372: pcr2.responded_by,
2373: fnd_global.user_id,
2374: fnd_global.login_id,
2375: sysdate
2376: from po_change_requests pcr2
2377: where pcr2.document_type= 'REQ'

Line 2374: fnd_global.login_id,

2370: pcr2.response_date,
2371: pcr2.response_reason,
2372: pcr2.responded_by,
2373: fnd_global.user_id,
2374: fnd_global.login_id,
2375: sysdate
2376: from po_change_requests pcr2
2377: where pcr2.document_type= 'REQ'
2378: and pcr2.change_request_group_id=l_req_change_grp_id

Line 2733: fnd_global.user_id,

2729: 'N',
2730: l_temp_date,
2731: l_temp_reason,
2732: l_temp_responder,
2733: fnd_global.user_id,
2734: fnd_global.login_id,
2735: sysdate
2736: from dual)
2737: where pcr1.change_request_group_id in

Line 2734: fnd_global.login_id,

2730: l_temp_date,
2731: l_temp_reason,
2732: l_temp_responder,
2733: fnd_global.user_id,
2734: fnd_global.login_id,
2735: sysdate
2736: from dual)
2737: where pcr1.change_request_group_id in
2738: (select parent_change_request_id

Line 2758: fnd_global.user_id,

2754: 'N',
2755: pcr2.response_date,
2756: pcr2.response_reason,
2757: pcr2.responded_by,
2758: fnd_global.user_id,
2759: fnd_global.login_id,
2760: sysdate
2761: from po_change_requests pcr2
2762: where pcr2.parent_change_request_id=l_date_change_id1

Line 2759: fnd_global.login_id,

2755: pcr2.response_date,
2756: pcr2.response_reason,
2757: pcr2.responded_by,
2758: fnd_global.user_id,
2759: fnd_global.login_id,
2760: sysdate
2761: from po_change_requests pcr2
2762: where pcr2.parent_change_request_id=l_date_change_id1
2763: and pcr2.change_request_group_id=p_change_request_group_id

Line 2830: set last_updated_by = fnd_global.user_id,

2826:
2827: BEGIN
2828:
2829: update PO_CHANGE_REQUESTS
2830: set last_updated_by = fnd_global.user_id,
2831: last_update_login = fnd_global.login_id,
2832: last_update_date = sysdate,
2833: request_status=p_request_status,
2834: response_date=sysdate,

Line 2831: last_update_login = fnd_global.login_id,

2827: BEGIN
2828:
2829: update PO_CHANGE_REQUESTS
2830: set last_updated_by = fnd_global.user_id,
2831: last_update_login = fnd_global.login_id,
2832: last_update_date = sysdate,
2833: request_status=p_request_status,
2834: response_date=sysdate,
2835: responded_by=fnd_global.user_id,

Line 2835: responded_by=fnd_global.user_id,

2831: last_update_login = fnd_global.login_id,
2832: last_update_date = sysdate,
2833: request_status=p_request_status,
2834: response_date=sysdate,
2835: responded_by=fnd_global.user_id,
2836: response_reason = nvl(p_response_reason, response_reason),
2837: change_active_flag=decode(p_request_status, 'ACCEPTED', 'N',
2838: 'REJECTED', 'N', 'Y')
2839: where change_request_group_id=p_change_request_group_id

Line 3516: set last_updated_by = fnd_global.user_id,

3512:
3513: x_progress := '001';
3514:
3515: update PO_CHANGE_REQUESTS
3516: set last_updated_by = fnd_global.user_id,
3517: last_update_login = fnd_global.login_id,
3518: last_update_date = sysdate,
3519: request_status='MGR_APP'
3520: where change_request_group_id=p_change_request_group_id

Line 3517: last_update_login = fnd_global.login_id,

3513: x_progress := '001';
3514:
3515: update PO_CHANGE_REQUESTS
3516: set last_updated_by = fnd_global.user_id,
3517: last_update_login = fnd_global.login_id,
3518: last_update_date = sysdate,
3519: request_status='MGR_APP'
3520: where change_request_group_id=p_change_request_group_id
3521: and action_type='CANCELLATION'

Line 3533: set last_updated_by = fnd_global.user_id,

3529:
3530: x_progress := '003';
3531:
3532: update PO_CHANGE_REQUESTS
3533: set last_updated_by = fnd_global.user_id,
3534: last_update_login = fnd_global.login_id,
3535: last_update_date = sysdate,
3536: request_status='MGR_APP'
3537: where change_request_group_id=p_change_request_group_id

Line 3534: last_update_login = fnd_global.login_id,

3530: x_progress := '003';
3531:
3532: update PO_CHANGE_REQUESTS
3533: set last_updated_by = fnd_global.user_id,
3534: last_update_login = fnd_global.login_id,
3535: last_update_date = sysdate,
3536: request_status='MGR_APP'
3537: where change_request_group_id=p_change_request_group_id
3538: and action_type='MODIFICATION'

Line 3548: set last_updated_by = fnd_global.user_id,

3544:
3545: x_progress := '005';
3546:
3547: update PO_CHANGE_REQUESTS
3548: set last_updated_by = fnd_global.user_id,
3549: last_update_login = fnd_global.login_id,
3550: last_update_date = sysdate,
3551: request_status='MGR_PRE_APP'
3552: where change_request_group_id=p_change_request_group_id

Line 3549: last_update_login = fnd_global.login_id,

3545: x_progress := '005';
3546:
3547: update PO_CHANGE_REQUESTS
3548: set last_updated_by = fnd_global.user_id,
3549: last_update_login = fnd_global.login_id,
3550: last_update_date = sysdate,
3551: request_status='MGR_PRE_APP'
3552: where change_request_group_id=p_change_request_group_id
3553: and action_type='MODIFICATION'

Line 3561: set last_updated_by = fnd_global.user_id,

3557: else -- reject
3558: x_progress := '005';
3559:
3560: update PO_CHANGE_REQUESTS
3561: set last_updated_by = fnd_global.user_id,
3562: last_update_login = fnd_global.login_id,
3563: last_update_date = sysdate,
3564: request_status='REJECTED',
3565: change_active_flag='N',

Line 3562: last_update_login = fnd_global.login_id,

3558: x_progress := '005';
3559:
3560: update PO_CHANGE_REQUESTS
3561: set last_updated_by = fnd_global.user_id,
3562: last_update_login = fnd_global.login_id,
3563: last_update_date = sysdate,
3564: request_status='REJECTED',
3565: change_active_flag='N',
3566: responded_by=p_responder_id,

Line 3613: set last_updated_by = nvl(fnd_global.user_id, last_updated_by),

3609:
3610: BEGIN
3611:
3612: update po_requisition_headers_all
3613: set last_updated_by = nvl(fnd_global.user_id, last_updated_by),
3614: last_update_login = nvl(fnd_global.login_id, last_update_login),
3615: last_update_date = sysdate,
3616: change_pending_flag=p_change_flag
3617: where requisition_header_id = p_document_id;

Line 3614: last_update_login = nvl(fnd_global.login_id, last_update_login),

3610: BEGIN
3611:
3612: update po_requisition_headers_all
3613: set last_updated_by = nvl(fnd_global.user_id, last_updated_by),
3614: last_update_login = nvl(fnd_global.login_id, last_update_login),
3615: last_update_date = sysdate,
3616: change_pending_flag=p_change_flag
3617: where requisition_header_id = p_document_id;
3618:

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

3766: p_doc_type,
3767: p_doc_subtype,
3768: l_sequence_num,
3769: sysdate,
3770: nvl(fnd_global.user_id, 1),
3771: sysdate,
3772: nvl(fnd_global.user_id, 1),
3773: p_action,
3774: decode(p_action, '',to_date('', 'YYYY-MM-DD'), sysdate),

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

3768: l_sequence_num,
3769: sysdate,
3770: nvl(fnd_global.user_id, 1),
3771: sysdate,
3772: nvl(fnd_global.user_id, 1),
3773: p_action,
3774: decode(p_action, '',to_date('', 'YYYY-MM-DD'), sysdate),
3775: p_employee_id,
3776: p_note,

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

3774: decode(p_action, '',to_date('', 'YYYY-MM-DD'), sysdate),
3775: p_employee_id,
3776: p_note,
3777: l_revision_num,
3778: nvl(fnd_global.login_id, 1),
3779: 0,
3780: 0,
3781: 0,
3782: '',

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

3793: object_type_code = p_doc_type,
3794: object_sub_type_code = p_doc_subtype,
3795: sequence_num = l_sequence_num,
3796: last_update_date = sysdate,
3797: last_updated_by = nvl(fnd_global.user_id, 1),
3798: creation_date = sysdate,
3799: created_by = nvl(fnd_global.user_id, 1),
3800: action_code = p_action,
3801: action_date = decode(p_action, '',to_date('', 'YYYY-MM-DD'), sysdate),

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

3795: sequence_num = l_sequence_num,
3796: last_update_date = sysdate,
3797: last_updated_by = nvl(fnd_global.user_id, 1),
3798: creation_date = sysdate,
3799: created_by = nvl(fnd_global.user_id, 1),
3800: action_code = p_action,
3801: action_date = decode(p_action, '',to_date('', 'YYYY-MM-DD'), sysdate),
3802: employee_id = p_employee_id,
3803: note = p_note,

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

3801: action_date = decode(p_action, '',to_date('', 'YYYY-MM-DD'), sysdate),
3802: employee_id = p_employee_id,
3803: note = p_note,
3804: object_revision_num = l_revision_num,
3805: last_update_login = nvl(fnd_global.login_id, 1),
3806: request_id = 0,
3807: program_application_id = 0,
3808: program_id = 0,
3809: program_update_date = '',

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

3850: p_doc_type,
3851: p_doc_subtype,
3852: l_sequence_num + 1,
3853: sysdate,
3854: nvl(fnd_global.user_id, 1),
3855: sysdate,
3856: nvl(fnd_global.user_id, 1),
3857: NULL, -- ACTION_CODE
3858: decode(p_action, '',to_date('', 'YYYY-MM-DD'), sysdate),

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

3852: l_sequence_num + 1,
3853: sysdate,
3854: nvl(fnd_global.user_id, 1),
3855: sysdate,
3856: nvl(fnd_global.user_id, 1),
3857: NULL, -- ACTION_CODE
3858: decode(p_action, '',to_date('', 'YYYY-MM-DD'), sysdate),
3859: p_employee_id,
3860: NULL,

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

3858: decode(p_action, '',to_date('', 'YYYY-MM-DD'), sysdate),
3859: p_employee_id,
3860: NULL,
3861: l_revision_num,
3862: nvl(fnd_global.login_id,1),
3863: 0,
3864: 0,
3865: 0,
3866: '',

Line 3908: last_updated_by = fnd_global.user_id,

3904: update po_headers_all set
3905: AUTHORIZATION_STATUS = 'IN PROCESS',
3906: -- approved_flag='N',
3907: CHANGE_REQUESTED_BY='REQUESTER',
3908: last_updated_by = fnd_global.user_id,
3909: last_update_login = fnd_global.login_id,
3910: last_update_date = sysdate
3911: where po_header_id = p_document_id;
3912:

Line 3909: last_update_login = fnd_global.login_id,

3905: AUTHORIZATION_STATUS = 'IN PROCESS',
3906: -- approved_flag='N',
3907: CHANGE_REQUESTED_BY='REQUESTER',
3908: last_updated_by = fnd_global.user_id,
3909: last_update_login = fnd_global.login_id,
3910: last_update_date = sysdate
3911: where po_header_id = p_document_id;
3912:
3913: x_progress := '002';

Line 3919: last_updated_by = fnd_global.user_id,

3915: UPDATE po_line_locations_all
3916: SET
3917: approved_flag='R',
3918: last_update_date = sysdate,
3919: last_updated_by = fnd_global.user_id,
3920: last_update_login = fnd_global.login_id
3921: WHERE
3922: line_location_id in
3923: (select document_line_location_id

Line 3920: last_update_login = fnd_global.login_id

3916: SET
3917: approved_flag='R',
3918: last_update_date = sysdate,
3919: last_updated_by = fnd_global.user_id,
3920: last_update_login = fnd_global.login_id
3921: WHERE
3922: line_location_id in
3923: (select document_line_location_id
3924: from po_change_requests

Line 3967: last_updated_by = fnd_global.user_id,

3963: update po_releases_all set
3964: AUTHORIZATION_STATUS = 'IN PROCESS',
3965: -- approved_flag='N',
3966: CHANGE_REQUESTED_BY='REQUESTER',
3967: last_updated_by = fnd_global.user_id,
3968: last_update_login = fnd_global.login_id,
3969: last_update_date = sysdate
3970: where po_release_id = p_document_id;
3971:

Line 3968: last_update_login = fnd_global.login_id,

3964: AUTHORIZATION_STATUS = 'IN PROCESS',
3965: -- approved_flag='N',
3966: CHANGE_REQUESTED_BY='REQUESTER',
3967: last_updated_by = fnd_global.user_id,
3968: last_update_login = fnd_global.login_id,
3969: last_update_date = sysdate
3970: where po_release_id = p_document_id;
3971:
3972: x_progress := '002';

Line 3978: last_updated_by = fnd_global.user_id,

3974: UPDATE po_line_locations_all
3975: SET
3976: approved_flag = 'R',
3977: last_update_date = sysdate,
3978: last_updated_by = fnd_global.user_id,
3979: last_update_login = fnd_global.login_id
3980: WHERE line_location_id in (select document_line_location_id
3981: from po_change_requests
3982: where request_level = 'SHIPMENT' and

Line 3979: last_update_login = fnd_global.login_id

3975: SET
3976: approved_flag = 'R',
3977: last_update_date = sysdate,
3978: last_updated_by = fnd_global.user_id,
3979: last_update_login = fnd_global.login_id
3980: WHERE line_location_id in (select document_line_location_id
3981: from po_change_requests
3982: where request_level = 'SHIPMENT' and
3983: po_release_id = p_document_id and

Line 4475: -- fnd_global.APPS_INITIALIZE (p_user_id, p_responsibility_id, p_application_id);

4471: n_varname(8) := 'APPLICATION_ID';
4472: n_varval(8) := p_application_id;
4473: Wf_Engine.SetItemAttrNumberArray(item_type, item_key,n_varname,n_varval);
4474:
4475: -- fnd_global.APPS_INITIALIZE (p_user_id, p_responsibility_id, p_application_id);
4476:
4477: t_varname(1) := 'DOCUMENT_TYPE';
4478: t_varval(1) := l_document_type;
4479: t_varname(2) := 'DOCUMENT_SUBTYPE';

Line 4583: fnd_global.user_id);

4579:
4580: l_responder_user_id := nvl(PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => l_inform_item_type,
4581: itemkey => l_inform_item_key,
4582: aname => 'RESPONDER_USER_ID'),
4583: fnd_global.user_id);
4584: l_responder_resp_id := nvl( PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => l_inform_item_type,
4585: itemkey => l_inform_item_key,
4586: aname => 'RESPONDER_RESP_ID'),
4587: fnd_global.resp_id);

Line 4587: fnd_global.resp_id);

4583: fnd_global.user_id);
4584: l_responder_resp_id := nvl( PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => l_inform_item_type,
4585: itemkey => l_inform_item_key,
4586: aname => 'RESPONDER_RESP_ID'),
4587: fnd_global.resp_id);
4588: l_responder_appl_id := nvl( PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => l_inform_item_type,
4589: itemkey => l_inform_item_key,
4590: aname => 'RESPONDER_APPL_ID'),
4591: fnd_global.resp_appl_id);

Line 4591: fnd_global.resp_appl_id);

4587: fnd_global.resp_id);
4588: l_responder_appl_id := nvl( PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => l_inform_item_type,
4589: itemkey => l_inform_item_key,
4590: aname => 'RESPONDER_APPL_ID'),
4591: fnd_global.resp_appl_id);
4592:
4593:
4594: IF (g_fnd_debug = 'Y') THEN
4595: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

Line 4704: last_updated_by = fnd_global.user_id,

4700:
4701: if(p_document_type = 'PO') then
4702: update po_headers_all
4703: set change_requested_by = null,
4704: last_updated_by = fnd_global.user_id,
4705: last_update_login = fnd_global.login_id,
4706: last_update_date = sysdate
4707: where po_header_id = p_document_id;
4708: else

Line 4705: last_update_login = fnd_global.login_id,

4701: if(p_document_type = 'PO') then
4702: update po_headers_all
4703: set change_requested_by = null,
4704: last_updated_by = fnd_global.user_id,
4705: last_update_login = fnd_global.login_id,
4706: last_update_date = sysdate
4707: where po_header_id = p_document_id;
4708: else
4709: update po_releases_all

Line 4711: last_updated_by = fnd_global.user_id,

4707: where po_header_id = p_document_id;
4708: else
4709: update po_releases_all
4710: set change_requested_by = null,
4711: last_updated_by = fnd_global.user_id,
4712: last_update_login = fnd_global.login_id,
4713: last_update_date = sysdate
4714: where po_release_id = p_document_id;
4715: end if;

Line 4712: last_update_login = fnd_global.login_id,

4708: else
4709: update po_releases_all
4710: set change_requested_by = null,
4711: last_updated_by = fnd_global.user_id,
4712: last_update_login = fnd_global.login_id,
4713: last_update_date = sysdate
4714: where po_release_id = p_document_id;
4715: end if;
4716: commit;

Line 5621: fnd_global.user_id,

5617: 'REQUISITION',
5618: p_employee_id,
5619: p_action_code,
5620: null,
5621: fnd_global.user_id,
5622: fnd_global.login_id
5623: );
5624: commit;
5625: end Update_Action_History;

Line 5622: fnd_global.login_id

5618: p_employee_id,
5619: p_action_code,
5620: null,
5621: fnd_global.user_id,
5622: fnd_global.login_id
5623: );
5624: commit;
5625: end Update_Action_History;
5626:

Line 7101: l_responsibility_id number := fnd_global.resp_id;

7097: resultout out NOCOPY varchar2 )
7098: is
7099: l_orgid number;
7100: l_change_request_group_id number;
7101: l_responsibility_id number := fnd_global.resp_id;
7102: l_application_id number := fnd_global.RESP_APPL_ID;
7103: l_user_id number := fnd_global.user_id;
7104:
7105: x_progress varchar2(100);

Line 7102: l_application_id number := fnd_global.RESP_APPL_ID;

7098: is
7099: l_orgid number;
7100: l_change_request_group_id number;
7101: l_responsibility_id number := fnd_global.resp_id;
7102: l_application_id number := fnd_global.RESP_APPL_ID;
7103: l_user_id number := fnd_global.user_id;
7104:
7105: x_progress varchar2(100);
7106:

Line 7103: l_user_id number := fnd_global.user_id;

7099: l_orgid number;
7100: l_change_request_group_id number;
7101: l_responsibility_id number := fnd_global.resp_id;
7102: l_application_id number := fnd_global.RESP_APPL_ID;
7103: l_user_id number := fnd_global.user_id;
7104:
7105: x_progress varchar2(100);
7106:
7107: l_doc_string varchar2(200);

Line 7135: fnd_global.APPS_INITIALIZE (l_user_id, l_responsibility_id, l_application_id);

7131: l_application_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
7132: itemkey => itemkey,
7133: aname => 'APPLICATION_ID');
7134:
7135: fnd_global.APPS_INITIALIZE (l_user_id, l_responsibility_id, l_application_id);
7136:
7137: end if;
7138:
7139:

Line 7334: fnd_global.APPS_INITIALIZE (l_user_id, l_responsibility_id, l_application_id);

7330: /*
7331: FND_PROFILE.GET('USER_ID', l_user_id);
7332: FND_PROFILE.GET('RESP_ID', l_responsibility_id);
7333: FND_PROFILE.GET('RESP_APPL_ID', l_application_id);
7334: fnd_global.APPS_INITIALIZE (l_user_id, l_responsibility_id, l_application_id);
7335: */
7336: po_sup_chg_request_wf_grp.KickOffPOApproval(1, p_return_status,
7337: p_po_header_id, p_po_release_id, p_return_msg);
7338: if(p_return_status=FND_API.G_RET_STS_SUCCESS) then

Line 9134: -- we get the attributes through fnd_global instead

9130:
9131: x_progress:='003';
9132: -- bug 5357773
9133: -- if the parent wf has been purged, can't get following attributes from wf.
9134: -- we get the attributes through fnd_global instead
9135: BEGIN
9136: select 'Y'
9137: into l_parent_wf_available
9138: from wf_items

Line 9179: l_forward_from_username:= fnd_global.user_name;

9175:
9176: x_progress:='005';
9177: -- if the parent wf has been purged, we get these attributes from session
9178: else
9179: l_forward_from_username:= fnd_global.user_name;
9180:
9181: l_user_id := fnd_global.user_id;
9182:
9183: l_responsibility_id := fnd_global.resp_id;

Line 9181: l_user_id := fnd_global.user_id;

9177: -- if the parent wf has been purged, we get these attributes from session
9178: else
9179: l_forward_from_username:= fnd_global.user_name;
9180:
9181: l_user_id := fnd_global.user_id;
9182:
9183: l_responsibility_id := fnd_global.resp_id;
9184:
9185: l_application_id := fnd_global.resp_appl_id;

Line 9183: l_responsibility_id := fnd_global.resp_id;

9179: l_forward_from_username:= fnd_global.user_name;
9180:
9181: l_user_id := fnd_global.user_id;
9182:
9183: l_responsibility_id := fnd_global.resp_id;
9184:
9185: l_application_id := fnd_global.resp_appl_id;
9186:
9187: x_progress:='006';

Line 9185: l_application_id := fnd_global.resp_appl_id;

9181: l_user_id := fnd_global.user_id;
9182:
9183: l_responsibility_id := fnd_global.resp_id;
9184:
9185: l_application_id := fnd_global.resp_appl_id;
9186:
9187: x_progress:='006';
9188:
9189: IF (g_fnd_debug = 'Y') THEN