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 1798: fnd_global.user_id,

1794: 'N',
1795: pcr2.response_date,
1796: pcr2.response_reason,
1797: pcr2.responded_by,
1798: fnd_global.user_id,
1799: fnd_global.login_id,
1800: sysdate
1801: from po_change_requests pcr2
1802: where pcr2.parent_change_request_id=pcr1.change_request_id

Line 1799: fnd_global.login_id,

1795: pcr2.response_date,
1796: pcr2.response_reason,
1797: pcr2.responded_by,
1798: fnd_global.user_id,
1799: fnd_global.login_id,
1800: sysdate
1801: from po_change_requests pcr2
1802: where pcr2.parent_change_request_id=pcr1.change_request_id
1803: and pcr2.change_request_group_id=p_change_request_group_id

Line 1841: fnd_global.user_id,

1837: 'N',
1838: pcr2.response_date,
1839: pcr2.response_reason,
1840: pcr2.responded_by,
1841: fnd_global.user_id,
1842: fnd_global.login_id,
1843: sysdate
1844: from po_change_requests pcr2
1845: where pcr2.parent_change_request_id in

Line 1842: fnd_global.login_id,

1838: pcr2.response_date,
1839: pcr2.response_reason,
1840: pcr2.responded_by,
1841: fnd_global.user_id,
1842: fnd_global.login_id,
1843: sysdate
1844: from po_change_requests pcr2
1845: where pcr2.parent_change_request_id in
1846: ( select pcr3.change_request_id

Line 1880: last_updated_by = fnd_global.user_id,

1876: UPDATE po_line_locations_all
1877: SET
1878: approved_flag = 'Y',
1879: last_update_date = sysdate,
1880: last_updated_by = fnd_global.user_id,
1881: last_update_login = fnd_global.login_id
1882: WHERE line_location_id IN
1883: (SELECT document_line_location_id
1884: FROM po_change_requests

Line 1881: last_update_login = fnd_global.login_id

1877: SET
1878: approved_flag = 'Y',
1879: last_update_date = sysdate,
1880: last_updated_by = fnd_global.user_id,
1881: last_update_login = fnd_global.login_id
1882: WHERE line_location_id IN
1883: (SELECT document_line_location_id
1884: FROM po_change_requests
1885: WHERE

Line 1988: last_updated_by = fnd_global.user_id,

1984: update po_headers_all
1985: set AUTHORIZATION_STATUS = 'APPROVED',
1986: approved_flag='Y',
1987: CHANGE_REQUESTED_BY=null,
1988: last_updated_by = fnd_global.user_id,
1989: last_update_login = fnd_global.login_id,
1990: last_update_date = sysdate
1991: where po_header_id = l_document_id;
1992: else

Line 1989: last_update_login = fnd_global.login_id,

1985: set AUTHORIZATION_STATUS = 'APPROVED',
1986: approved_flag='Y',
1987: CHANGE_REQUESTED_BY=null,
1988: last_updated_by = fnd_global.user_id,
1989: last_update_login = fnd_global.login_id,
1990: last_update_date = sysdate
1991: where po_header_id = l_document_id;
1992: else
1993: l_document_subtype := 'BLANKET';

Line 2000: last_updated_by = fnd_global.user_id,

1996: update po_releases_all
1997: set AUTHORIZATION_STATUS = 'APPROVED',
1998: approved_flag='Y',
1999: CHANGE_REQUESTED_BY=null,
2000: last_updated_by = fnd_global.user_id,
2001: last_update_login = fnd_global.login_id,
2002: last_update_date = sysdate
2003: where po_release_id = l_release_id;
2004: end if;

Line 2001: last_update_login = fnd_global.login_id,

1997: set AUTHORIZATION_STATUS = 'APPROVED',
1998: approved_flag='Y',
1999: CHANGE_REQUESTED_BY=null,
2000: last_updated_by = fnd_global.user_id,
2001: last_update_login = fnd_global.login_id,
2002: last_update_date = sysdate
2003: where po_release_id = l_release_id;
2004: end if;
2005:

Line 2068: fnd_global.user_id,

2064: 'N',
2065: pcr2.response_date,
2066: pcr2.response_reason,
2067: pcr2.responded_by,
2068: fnd_global.user_id,
2069: fnd_global.login_id,
2070: sysdate
2071: from po_change_requests pcr2
2072: where pcr2.parent_change_request_id=pcr1.change_request_id

Line 2069: fnd_global.login_id,

2065: pcr2.response_date,
2066: pcr2.response_reason,
2067: pcr2.responded_by,
2068: fnd_global.user_id,
2069: fnd_global.login_id,
2070: sysdate
2071: from po_change_requests pcr2
2072: where pcr2.parent_change_request_id=pcr1.change_request_id
2073: and pcr2.change_request_group_id=p_change_request_group_id

Line 2111: last_updated_by = fnd_global.user_id,

2107: update po_headers_all set
2108: AUTHORIZATION_STATUS = 'IN PROCESS',
2109: -- approved_flag='N',
2110: CHANGE_REQUESTED_BY='REQUESTER',
2111: last_updated_by = fnd_global.user_id,
2112: last_update_login = fnd_global.login_id,
2113: last_update_date = sysdate
2114: where po_header_id = l_document_id;
2115: else

Line 2112: last_update_login = fnd_global.login_id,

2108: AUTHORIZATION_STATUS = 'IN PROCESS',
2109: -- approved_flag='N',
2110: CHANGE_REQUESTED_BY='REQUESTER',
2111: last_updated_by = fnd_global.user_id,
2112: last_update_login = fnd_global.login_id,
2113: last_update_date = sysdate
2114: where po_header_id = l_document_id;
2115: else
2116: -- fix bug 2733373. when change is submitted, and wait

Line 2123: last_updated_by = fnd_global.user_id,

2119: update po_releases_all set
2120: AUTHORIZATION_STATUS = 'IN PROCESS',
2121: -- approved_flag='N',
2122: CHANGE_REQUESTED_BY='REQUESTER',
2123: last_updated_by = fnd_global.user_id,
2124: last_update_login = fnd_global.login_id,
2125: last_update_date = sysdate
2126: where po_release_id = l_release_id;
2127: end if;

Line 2124: last_update_login = fnd_global.login_id,

2120: AUTHORIZATION_STATUS = 'IN PROCESS',
2121: -- approved_flag='N',
2122: CHANGE_REQUESTED_BY='REQUESTER',
2123: last_updated_by = fnd_global.user_id,
2124: last_update_login = fnd_global.login_id,
2125: last_update_date = sysdate
2126: where po_release_id = l_release_id;
2127: end if;
2128: x_progress:='CANCELLATION:008';

Line 2353: l_document_line_id,NULL,NULL,NULL,NULL,fnd_global.user_id,fnd_global.login_id);

2349: (SELECT LINE_LOCATION_ID FROM po_requisition_lines_all WHERE requisition_line_id= l_document_line_id);
2350:
2351: -- copy change request attachments to req line.
2352: fnd_attached_documents2_pkg.copy_attachments('REQ_LINE_CHANGES',l_document_line_id,NULL,NULL,NULL,NULL,'REQ_LINES',
2353: l_document_line_id,NULL,NULL,NULL,NULL,fnd_global.user_id,fnd_global.login_id);
2354:
2355: -- copy change request attachments to po line.
2356: IF (l_po_line_id IS NOT NULL) THEN
2357: fnd_attached_documents2_pkg.copy_attachments('REQ_LINE_CHANGES',l_document_line_id,NULL,NULL,NULL,NULL,'PO_LINES',

Line 2358: l_po_line_id,NULL,NULL,NULL,NULL,fnd_global.user_id,fnd_global.login_id);

2354:
2355: -- copy change request attachments to po line.
2356: IF (l_po_line_id IS NOT NULL) THEN
2357: fnd_attached_documents2_pkg.copy_attachments('REQ_LINE_CHANGES',l_document_line_id,NULL,NULL,NULL,NULL,'PO_LINES',
2358: l_po_line_id,NULL,NULL,NULL,NULL,fnd_global.user_id,fnd_global.login_id);
2359: END IF;
2360:
2361: -- delete the change request attachments.
2362: FND_ATTACHED_DOCUMENTS2_PKG.delete_attachments ( 'REQ_LINE_CHANGES',l_document_line_id, NULL,NULL,NULL, NULL);

Line 2440: fnd_global.user_id,

2436: 'N',
2437: pcr2.response_date,
2438: pcr2.response_reason,
2439: pcr2.responded_by,
2440: fnd_global.user_id,
2441: fnd_global.login_id,
2442: sysdate
2443: from po_change_requests pcr2
2444: where pcr2.parent_change_request_id=pcr1.change_request_id

Line 2441: fnd_global.login_id,

2437: pcr2.response_date,
2438: pcr2.response_reason,
2439: pcr2.responded_by,
2440: fnd_global.user_id,
2441: fnd_global.login_id,
2442: sysdate
2443: from po_change_requests pcr2
2444: where pcr2.parent_change_request_id=pcr1.change_request_id
2445: and pcr2.change_request_group_id=p_change_request_group_id

Line 2484: fnd_global.user_id,

2480: 'N',
2481: pcr2.response_date,
2482: pcr2.response_reason,
2483: pcr2.responded_by,
2484: fnd_global.user_id,
2485: fnd_global.login_id,
2486: sysdate
2487: from po_change_requests pcr2
2488: where pcr2.document_type= 'REQ'

Line 2485: fnd_global.login_id,

2481: pcr2.response_date,
2482: pcr2.response_reason,
2483: pcr2.responded_by,
2484: fnd_global.user_id,
2485: fnd_global.login_id,
2486: sysdate
2487: from po_change_requests pcr2
2488: where pcr2.document_type= 'REQ'
2489: and pcr2.change_request_group_id=l_req_change_grp_id

Line 2855: fnd_global.user_id,

2851: 'N',
2852: l_temp_date,
2853: l_temp_reason,
2854: l_temp_responder,
2855: fnd_global.user_id,
2856: fnd_global.login_id,
2857: sysdate
2858: from dual)
2859: where pcr1.change_request_group_id in

Line 2856: fnd_global.login_id,

2852: l_temp_date,
2853: l_temp_reason,
2854: l_temp_responder,
2855: fnd_global.user_id,
2856: fnd_global.login_id,
2857: sysdate
2858: from dual)
2859: where pcr1.change_request_group_id in
2860: (select parent_change_request_id

Line 2880: fnd_global.user_id,

2876: 'N',
2877: pcr2.response_date,
2878: pcr2.response_reason,
2879: pcr2.responded_by,
2880: fnd_global.user_id,
2881: fnd_global.login_id,
2882: sysdate
2883: from po_change_requests pcr2
2884: where pcr2.parent_change_request_id=l_date_change_id1

Line 2881: fnd_global.login_id,

2877: pcr2.response_date,
2878: pcr2.response_reason,
2879: pcr2.responded_by,
2880: fnd_global.user_id,
2881: fnd_global.login_id,
2882: sysdate
2883: from po_change_requests pcr2
2884: where pcr2.parent_change_request_id=l_date_change_id1
2885: and pcr2.change_request_group_id=p_change_request_group_id

Line 2952: set last_updated_by = fnd_global.user_id,

2948:
2949: BEGIN
2950:
2951: update PO_CHANGE_REQUESTS
2952: set last_updated_by = fnd_global.user_id,
2953: last_update_login = fnd_global.login_id,
2954: last_update_date = sysdate,
2955: request_status=p_request_status,
2956: response_date=sysdate,

Line 2953: last_update_login = fnd_global.login_id,

2949: BEGIN
2950:
2951: update PO_CHANGE_REQUESTS
2952: set last_updated_by = fnd_global.user_id,
2953: last_update_login = fnd_global.login_id,
2954: last_update_date = sysdate,
2955: request_status=p_request_status,
2956: response_date=sysdate,
2957: responded_by=fnd_global.user_id,

Line 2957: responded_by=fnd_global.user_id,

2953: last_update_login = fnd_global.login_id,
2954: last_update_date = sysdate,
2955: request_status=p_request_status,
2956: response_date=sysdate,
2957: responded_by=fnd_global.user_id,
2958: response_reason = nvl(p_response_reason, response_reason),
2959: change_active_flag=decode(p_request_status, 'ACCEPTED', 'N',
2960: 'REJECTED', 'N', 'Y')
2961: where change_request_group_id=p_change_request_group_id

Line 3647: set last_updated_by = fnd_global.user_id,

3643:
3644: x_progress := '001';
3645:
3646: update PO_CHANGE_REQUESTS
3647: set last_updated_by = fnd_global.user_id,
3648: last_update_login = fnd_global.login_id,
3649: last_update_date = sysdate,
3650: request_status='MGR_APP'
3651: where change_request_group_id=p_change_request_group_id

Line 3648: last_update_login = fnd_global.login_id,

3644: x_progress := '001';
3645:
3646: update PO_CHANGE_REQUESTS
3647: set last_updated_by = fnd_global.user_id,
3648: last_update_login = fnd_global.login_id,
3649: last_update_date = sysdate,
3650: request_status='MGR_APP'
3651: where change_request_group_id=p_change_request_group_id
3652: and action_type='CANCELLATION'

Line 3664: set last_updated_by = fnd_global.user_id,

3660:
3661: x_progress := '003';
3662:
3663: update PO_CHANGE_REQUESTS
3664: set last_updated_by = fnd_global.user_id,
3665: last_update_login = fnd_global.login_id,
3666: last_update_date = sysdate,
3667: request_status='MGR_APP'
3668: where change_request_group_id=p_change_request_group_id

Line 3665: last_update_login = fnd_global.login_id,

3661: x_progress := '003';
3662:
3663: update PO_CHANGE_REQUESTS
3664: set last_updated_by = fnd_global.user_id,
3665: last_update_login = fnd_global.login_id,
3666: last_update_date = sysdate,
3667: request_status='MGR_APP'
3668: where change_request_group_id=p_change_request_group_id
3669: and action_type='MODIFICATION'

Line 3679: set last_updated_by = fnd_global.user_id,

3675:
3676: x_progress := '005';
3677:
3678: update PO_CHANGE_REQUESTS
3679: set last_updated_by = fnd_global.user_id,
3680: last_update_login = fnd_global.login_id,
3681: last_update_date = sysdate,
3682: request_status='MGR_PRE_APP'
3683: where change_request_group_id=p_change_request_group_id

Line 3680: last_update_login = fnd_global.login_id,

3676: x_progress := '005';
3677:
3678: update PO_CHANGE_REQUESTS
3679: set last_updated_by = fnd_global.user_id,
3680: last_update_login = fnd_global.login_id,
3681: last_update_date = sysdate,
3682: request_status='MGR_PRE_APP'
3683: where change_request_group_id=p_change_request_group_id
3684: and action_type='MODIFICATION'

Line 3692: set last_updated_by = fnd_global.user_id,

3688: else -- reject
3689: x_progress := '005';
3690:
3691: update PO_CHANGE_REQUESTS
3692: set last_updated_by = fnd_global.user_id,
3693: last_update_login = fnd_global.login_id,
3694: last_update_date = sysdate,
3695: request_status='REJECTED',
3696: change_active_flag='N',

Line 3693: last_update_login = fnd_global.login_id,

3689: x_progress := '005';
3690:
3691: update PO_CHANGE_REQUESTS
3692: set last_updated_by = fnd_global.user_id,
3693: last_update_login = fnd_global.login_id,
3694: last_update_date = sysdate,
3695: request_status='REJECTED',
3696: change_active_flag='N',
3697: responded_by=p_responder_id,

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

3740:
3741: BEGIN
3742:
3743: update po_requisition_headers_all
3744: set last_updated_by = nvl(fnd_global.user_id, last_updated_by),
3745: last_update_login = nvl(fnd_global.login_id, last_update_login),
3746: last_update_date = sysdate,
3747: change_pending_flag=p_change_flag
3748: where requisition_header_id = p_document_id;

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

3741: BEGIN
3742:
3743: update po_requisition_headers_all
3744: set last_updated_by = nvl(fnd_global.user_id, last_updated_by),
3745: last_update_login = nvl(fnd_global.login_id, last_update_login),
3746: last_update_date = sysdate,
3747: change_pending_flag=p_change_flag
3748: where requisition_header_id = p_document_id;
3749:

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

3910: p_doc_type,
3911: p_doc_subtype,
3912: l_sequence_num,
3913: sysdate,
3914: nvl(fnd_global.user_id, 1),
3915: sysdate,
3916: nvl(fnd_global.user_id, 1),
3917: p_action,
3918: decode(p_action, '',to_date('', 'YYYY-MM-DD'), sysdate),

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

3912: l_sequence_num,
3913: sysdate,
3914: nvl(fnd_global.user_id, 1),
3915: sysdate,
3916: nvl(fnd_global.user_id, 1),
3917: p_action,
3918: decode(p_action, '',to_date('', 'YYYY-MM-DD'), sysdate),
3919: p_employee_id,
3920: p_note,

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

3918: decode(p_action, '',to_date('', 'YYYY-MM-DD'), sysdate),
3919: p_employee_id,
3920: p_note,
3921: l_revision_num,
3922: nvl(fnd_global.login_id, 1),
3923: 0,
3924: 0,
3925: 0,
3926: '',

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

3937: object_type_code = p_doc_type,
3938: object_sub_type_code = p_doc_subtype,
3939: sequence_num = l_sequence_num,
3940: last_update_date = sysdate,
3941: last_updated_by = nvl(fnd_global.user_id, 1),
3942: creation_date = sysdate,
3943: created_by = nvl(fnd_global.user_id, 1),
3944: action_code = p_action,
3945: action_date = decode(p_action, '',to_date('', 'YYYY-MM-DD'), sysdate),

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

3939: sequence_num = l_sequence_num,
3940: last_update_date = sysdate,
3941: last_updated_by = nvl(fnd_global.user_id, 1),
3942: creation_date = sysdate,
3943: created_by = nvl(fnd_global.user_id, 1),
3944: action_code = p_action,
3945: action_date = decode(p_action, '',to_date('', 'YYYY-MM-DD'), sysdate),
3946: employee_id = p_employee_id,
3947: note = p_note,

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

3945: action_date = decode(p_action, '',to_date('', 'YYYY-MM-DD'), sysdate),
3946: employee_id = p_employee_id,
3947: note = p_note,
3948: object_revision_num = l_revision_num,
3949: last_update_login = nvl(fnd_global.login_id, 1),
3950: request_id = 0,
3951: program_application_id = 0,
3952: program_id = 0,
3953: program_update_date = '',

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

4003: p_doc_type,
4004: p_doc_subtype,
4005: l_sequence_num + 1,
4006: sysdate,
4007: nvl(fnd_global.user_id, 1),
4008: sysdate,
4009: nvl(fnd_global.user_id, 1),
4010: NULL, -- ACTION_CODE
4011: decode(p_action, '',to_date('', 'YYYY-MM-DD'), sysdate),

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

4005: l_sequence_num + 1,
4006: sysdate,
4007: nvl(fnd_global.user_id, 1),
4008: sysdate,
4009: nvl(fnd_global.user_id, 1),
4010: NULL, -- ACTION_CODE
4011: decode(p_action, '',to_date('', 'YYYY-MM-DD'), sysdate),
4012: l_buyer_id,
4013: NULL,

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

4011: decode(p_action, '',to_date('', 'YYYY-MM-DD'), sysdate),
4012: l_buyer_id,
4013: NULL,
4014: l_revision_num,
4015: nvl(fnd_global.login_id,1),
4016: 0,
4017: 0,
4018: 0,
4019: '',

Line 4061: last_updated_by = fnd_global.user_id,

4057: update po_headers_all set
4058: AUTHORIZATION_STATUS = 'IN PROCESS',
4059: -- approved_flag='N',
4060: CHANGE_REQUESTED_BY='REQUESTER',
4061: last_updated_by = fnd_global.user_id,
4062: last_update_login = fnd_global.login_id,
4063: last_update_date = sysdate
4064: where po_header_id = p_document_id;
4065:

Line 4062: last_update_login = fnd_global.login_id,

4058: AUTHORIZATION_STATUS = 'IN PROCESS',
4059: -- approved_flag='N',
4060: CHANGE_REQUESTED_BY='REQUESTER',
4061: last_updated_by = fnd_global.user_id,
4062: last_update_login = fnd_global.login_id,
4063: last_update_date = sysdate
4064: where po_header_id = p_document_id;
4065:
4066: x_progress := '002';

Line 4072: last_updated_by = fnd_global.user_id,

4068: UPDATE po_line_locations_all
4069: SET
4070: approved_flag='R',
4071: last_update_date = sysdate,
4072: last_updated_by = fnd_global.user_id,
4073: last_update_login = fnd_global.login_id
4074: WHERE
4075: line_location_id in
4076: (select document_line_location_id

Line 4073: last_update_login = fnd_global.login_id

4069: SET
4070: approved_flag='R',
4071: last_update_date = sysdate,
4072: last_updated_by = fnd_global.user_id,
4073: last_update_login = fnd_global.login_id
4074: WHERE
4075: line_location_id in
4076: (select document_line_location_id
4077: from po_change_requests

Line 4120: last_updated_by = fnd_global.user_id,

4116: update po_releases_all set
4117: AUTHORIZATION_STATUS = 'IN PROCESS',
4118: -- approved_flag='N',
4119: CHANGE_REQUESTED_BY='REQUESTER',
4120: last_updated_by = fnd_global.user_id,
4121: last_update_login = fnd_global.login_id,
4122: last_update_date = sysdate
4123: where po_release_id = p_document_id;
4124:

Line 4121: last_update_login = fnd_global.login_id,

4117: AUTHORIZATION_STATUS = 'IN PROCESS',
4118: -- approved_flag='N',
4119: CHANGE_REQUESTED_BY='REQUESTER',
4120: last_updated_by = fnd_global.user_id,
4121: last_update_login = fnd_global.login_id,
4122: last_update_date = sysdate
4123: where po_release_id = p_document_id;
4124:
4125: x_progress := '002';

Line 4131: last_updated_by = fnd_global.user_id,

4127: UPDATE po_line_locations_all
4128: SET
4129: approved_flag = 'R',
4130: last_update_date = sysdate,
4131: last_updated_by = fnd_global.user_id,
4132: last_update_login = fnd_global.login_id
4133: WHERE line_location_id in (select document_line_location_id
4134: from po_change_requests
4135: where request_level = 'SHIPMENT' and

Line 4132: last_update_login = fnd_global.login_id

4128: SET
4129: approved_flag = 'R',
4130: last_update_date = sysdate,
4131: last_updated_by = fnd_global.user_id,
4132: last_update_login = fnd_global.login_id
4133: WHERE line_location_id in (select document_line_location_id
4134: from po_change_requests
4135: where request_level = 'SHIPMENT' and
4136: po_release_id = p_document_id and

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

4631: n_varname(8) := 'APPLICATION_ID';
4632: n_varval(8) := p_application_id;
4633: Wf_Engine.SetItemAttrNumberArray(item_type, item_key,n_varname,n_varval);
4634:
4635: -- fnd_global.APPS_INITIALIZE (p_user_id, p_responsibility_id, p_application_id);
4636:
4637: t_varname(1) := 'DOCUMENT_TYPE';
4638: t_varval(1) := l_document_type;
4639: t_varname(2) := 'DOCUMENT_SUBTYPE';

Line 4760: fnd_global.user_id);

4756:
4757: l_responder_user_id := nvl(PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => l_inform_item_type,
4758: itemkey => l_inform_item_key,
4759: aname => 'RESPONDER_USER_ID'),
4760: fnd_global.user_id);
4761: l_responder_resp_id := nvl( PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => l_inform_item_type,
4762: itemkey => l_inform_item_key,
4763: aname => 'RESPONDER_RESP_ID'),
4764: fnd_global.resp_id);

Line 4764: fnd_global.resp_id);

4760: fnd_global.user_id);
4761: l_responder_resp_id := nvl( PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => l_inform_item_type,
4762: itemkey => l_inform_item_key,
4763: aname => 'RESPONDER_RESP_ID'),
4764: fnd_global.resp_id);
4765: l_responder_appl_id := nvl( PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => l_inform_item_type,
4766: itemkey => l_inform_item_key,
4767: aname => 'RESPONDER_APPL_ID'),
4768: fnd_global.resp_appl_id);

Line 4768: fnd_global.resp_appl_id);

4764: fnd_global.resp_id);
4765: l_responder_appl_id := nvl( PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => l_inform_item_type,
4766: itemkey => l_inform_item_key,
4767: aname => 'RESPONDER_APPL_ID'),
4768: fnd_global.resp_appl_id);
4769: --bug 9685961
4770: l_note := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => l_inform_item_type,
4771: itemkey => l_inform_item_key,
4772: aname => 'NOTE');

Line 4892: last_updated_by = fnd_global.user_id,

4888:
4889: if(p_document_type = 'PO') then
4890: update po_headers_all
4891: set change_requested_by = null,
4892: last_updated_by = fnd_global.user_id,
4893: last_update_login = fnd_global.login_id,
4894: last_update_date = sysdate
4895: where po_header_id = p_document_id;
4896: else

Line 4893: last_update_login = fnd_global.login_id,

4889: if(p_document_type = 'PO') then
4890: update po_headers_all
4891: set change_requested_by = null,
4892: last_updated_by = fnd_global.user_id,
4893: last_update_login = fnd_global.login_id,
4894: last_update_date = sysdate
4895: where po_header_id = p_document_id;
4896: else
4897: update po_releases_all

Line 4899: last_updated_by = fnd_global.user_id,

4895: where po_header_id = p_document_id;
4896: else
4897: update po_releases_all
4898: set change_requested_by = null,
4899: last_updated_by = fnd_global.user_id,
4900: last_update_login = fnd_global.login_id,
4901: last_update_date = sysdate
4902: where po_release_id = p_document_id;
4903: end if;

Line 4900: last_update_login = fnd_global.login_id,

4896: else
4897: update po_releases_all
4898: set change_requested_by = null,
4899: last_updated_by = fnd_global.user_id,
4900: last_update_login = fnd_global.login_id,
4901: last_update_date = sysdate
4902: where po_release_id = p_document_id;
4903: end if;
4904: commit;

Line 5809: fnd_global.user_id,

5805: 'REQUISITION',
5806: p_employee_id,
5807: p_action_code,
5808: null,
5809: fnd_global.user_id,
5810: fnd_global.login_id
5811: );
5812: commit;
5813: end Update_Action_History;

Line 5810: fnd_global.login_id

5806: p_employee_id,
5807: p_action_code,
5808: null,
5809: fnd_global.user_id,
5810: fnd_global.login_id
5811: );
5812: commit;
5813: end Update_Action_History;
5814:

Line 7338: l_responsibility_id number := fnd_global.resp_id;

7334: resultout out NOCOPY varchar2 )
7335: is
7336: l_orgid number;
7337: l_change_request_group_id number;
7338: l_responsibility_id number := fnd_global.resp_id;
7339: l_application_id number := fnd_global.RESP_APPL_ID;
7340: l_user_id number := fnd_global.user_id;
7341:
7342: x_progress varchar2(100);

Line 7339: l_application_id number := fnd_global.RESP_APPL_ID;

7335: is
7336: l_orgid number;
7337: l_change_request_group_id number;
7338: l_responsibility_id number := fnd_global.resp_id;
7339: l_application_id number := fnd_global.RESP_APPL_ID;
7340: l_user_id number := fnd_global.user_id;
7341:
7342: x_progress varchar2(100);
7343:

Line 7340: l_user_id number := fnd_global.user_id;

7336: l_orgid number;
7337: l_change_request_group_id number;
7338: l_responsibility_id number := fnd_global.resp_id;
7339: l_application_id number := fnd_global.RESP_APPL_ID;
7340: l_user_id number := fnd_global.user_id;
7341:
7342: x_progress varchar2(100);
7343:
7344: l_doc_string varchar2(200);

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

7368: l_application_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
7369: itemkey => itemkey,
7370: aname => 'APPLICATION_ID');
7371:
7372: fnd_global.APPS_INITIALIZE (l_user_id, l_responsibility_id, l_application_id);
7373:
7374: end if;
7375:
7376:

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

7567: /*
7568: FND_PROFILE.GET('USER_ID', l_user_id);
7569: FND_PROFILE.GET('RESP_ID', l_responsibility_id);
7570: FND_PROFILE.GET('RESP_APPL_ID', l_application_id);
7571: fnd_global.APPS_INITIALIZE (l_user_id, l_responsibility_id, l_application_id);
7572: */
7573: po_sup_chg_request_wf_grp.KickOffPOApproval(1, p_return_status,
7574: p_po_header_id, p_po_release_id, p_return_msg);
7575: if(p_return_status=FND_API.G_RET_STS_SUCCESS) then

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

9517:
9518: x_progress:='003';
9519: -- bug 5357773
9520: -- if the parent wf has been purged, can't get following attributes from wf.
9521: -- we get the attributes through fnd_global instead
9522: BEGIN
9523: select 'Y'
9524: into l_parent_wf_available
9525: from wf_items

Line 9566: l_forward_from_username:= fnd_global.user_name;

9562:
9563: x_progress:='005';
9564: -- if the parent wf has been purged, we get these attributes from session
9565: else
9566: l_forward_from_username:= fnd_global.user_name;
9567:
9568: l_user_id := fnd_global.user_id;
9569:
9570: l_responsibility_id := fnd_global.resp_id;

Line 9568: l_user_id := fnd_global.user_id;

9564: -- if the parent wf has been purged, we get these attributes from session
9565: else
9566: l_forward_from_username:= fnd_global.user_name;
9567:
9568: l_user_id := fnd_global.user_id;
9569:
9570: l_responsibility_id := fnd_global.resp_id;
9571:
9572: l_application_id := fnd_global.resp_appl_id;

Line 9570: l_responsibility_id := fnd_global.resp_id;

9566: l_forward_from_username:= fnd_global.user_name;
9567:
9568: l_user_id := fnd_global.user_id;
9569:
9570: l_responsibility_id := fnd_global.resp_id;
9571:
9572: l_application_id := fnd_global.resp_appl_id;
9573:
9574: x_progress:='006';

Line 9572: l_application_id := fnd_global.resp_appl_id;

9568: l_user_id := fnd_global.user_id;
9569:
9570: l_responsibility_id := fnd_global.resp_id;
9571:
9572: l_application_id := fnd_global.resp_appl_id;
9573:
9574: x_progress:='006';
9575:
9576: IF (g_fnd_debug = 'Y') THEN

Line 11432: fnd_global.apps_initialize (l_user_id, l_responsibility_id, l_application_id);

11428:
11429: l_progress := 'PO_ReqChangeRequestWF_PVT.Start_Notify_Requester_Process: 04';
11430:
11431: --Bug: 14642268 After call from above api which could have changed the session context, reset the session context to original value
11432: fnd_global.apps_initialize (l_user_id, l_responsibility_id, l_application_id);
11433:
11434: l_progress := 'PO_ReqChangeRequestWF_PVT.Start_Notify_Requester_Process: 05';
11435:
11436: EXCEPTION when others THEN

Line 12927: LAST_UPDATED_BY = fnd_global.user_id,

12923: --update po req lines as cancel flag I
12924: -- bug 14407998 changes added LAST_UPDATED_BY, LAST_UPDATE_DATE colums in update stmt
12925: UPDATE po_requisition_lines_all
12926: SET cancel_flag = 'I',
12927: LAST_UPDATED_BY = fnd_global.user_id,
12928: LAST_UPDATE_DATE = SYSDATE,
12929: cancel_date = SYSDATE
12930: WHERE requisition_line_id = p_req_line_id ;
12931:

Line 12972: LAST_UPDATED_BY = fnd_global.user_id,

12968: UPDATE po_requisition_lines_all prl
12969: SET cancel_flag = 'Y',
12970: quantity_cancelled = x_cancelled_quanity,
12971: SECONDARY_QUANTITY_CANCELLED = l_sec_cancelled_qty,
12972: LAST_UPDATED_BY = fnd_global.user_id,
12973: LAST_UPDATE_DATE = SYSDATE,
12974: cancel_date = SYSDATE
12975: WHERE requisition_line_id = p_req_line_id ;
12976: ELSE

Line 13001: LAST_UPDATED_BY = fnd_global.user_id,

12997: UPDATE po_requisition_lines_all prl
12998: SET cancel_flag = 'Y',
12999: quantity_cancelled = x_cancelled_quanity,
13000: SECONDARY_QUANTITY_CANCELLED = l_sec_cancelled_qty,
13001: LAST_UPDATED_BY = fnd_global.user_id,
13002: LAST_UPDATE_DATE = SYSDATE,
13003: cancel_date = SYSDATE
13004: WHERE requisition_line_id = p_req_line_id ;
13005: end if;

Line 13020: h.LAST_UPDATED_BY = fnd_global.user_id,

13016: x_progress := '013';
13017: -- bug 14407998 changes added LAST_UPDATED_BY, LAST_UPDATE_DATE colums in update stmt
13018: UPDATE po_requisition_headers_all h
13019: SET h.AUTHORIZATION_STATUS = 'CANCELLED',
13020: h.LAST_UPDATED_BY = fnd_global.user_id,
13021: h.LAST_UPDATE_DATE = SYSDATE
13022: WHERE h.REQUISITION_HEADER_ID = l_document_id
13023: AND NOT EXISTS
13024: (SELECT 'UNCANCELLED LINE EXISTS'