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_REQAPPROVAL_INIT1 dependencies on FND_GLOBAL

Line 1584: l_user_id := fnd_global.user_id;

1580: ** the Document Manager.
1581: */
1582: IF (x_wf_created = 0) THEN
1583:
1584: l_user_id := fnd_global.user_id;
1585: l_responsibility_id := fnd_global.resp_id;
1586: l_application_id := fnd_global.resp_appl_id;
1587:
1588:

Line 1585: l_responsibility_id := fnd_global.resp_id;

1581: */
1582: IF (x_wf_created = 0) THEN
1583:
1584: l_user_id := fnd_global.user_id;
1585: l_responsibility_id := fnd_global.resp_id;
1586: l_application_id := fnd_global.resp_appl_id;
1587:
1588:
1589: IF (l_user_id = -1) THEN

Line 1586: l_application_id := fnd_global.resp_appl_id;

1582: IF (x_wf_created = 0) THEN
1583:
1584: l_user_id := fnd_global.user_id;
1585: l_responsibility_id := fnd_global.resp_id;
1586: l_application_id := fnd_global.resp_appl_id;
1587:
1588:
1589: IF (l_user_id = -1) THEN
1590: l_user_id := NULL;

Line 1613: last_updated_by = fnd_global.user_id,

1609: IF p_background_flag = 'Y' THEN
1610: IF DocumentTypeCode = 'RELEASE' THEN
1611: UPDATE po_releases
1612: SET AUTHORIZATION_STATUS = 'IN PROCESS',
1613: last_updated_by = fnd_global.user_id,
1614: last_update_login = fnd_global.login_id,
1615: last_update_date = sysdate
1616: WHERE po_release_id = DocumentID;
1617: ELSE --PO or PA

Line 1614: last_update_login = fnd_global.login_id,

1610: IF DocumentTypeCode = 'RELEASE' THEN
1611: UPDATE po_releases
1612: SET AUTHORIZATION_STATUS = 'IN PROCESS',
1613: last_updated_by = fnd_global.user_id,
1614: last_update_login = fnd_global.login_id,
1615: last_update_date = sysdate
1616: WHERE po_release_id = DocumentID;
1617: ELSE --PO or PA
1618: IF l_draft_type IS NULL THEN--l_is_mod = 'N' THEN -- Mod Project

Line 1621: last_updated_by = fnd_global.user_id,

1617: ELSE --PO or PA
1618: IF l_draft_type IS NULL THEN--l_is_mod = 'N' THEN -- Mod Project
1619: UPDATE po_headers
1620: SET AUTHORIZATION_STATUS = 'IN PROCESS',
1621: last_updated_by = fnd_global.user_id,
1622: last_update_login = fnd_global.login_id,
1623: last_update_date = sysdate
1624: WHERE po_header_id = DocumentID;
1625: ELSE

Line 1622: last_update_login = fnd_global.login_id,

1618: IF l_draft_type IS NULL THEN--l_is_mod = 'N' THEN -- Mod Project
1619: UPDATE po_headers
1620: SET AUTHORIZATION_STATUS = 'IN PROCESS',
1621: last_updated_by = fnd_global.user_id,
1622: last_update_login = fnd_global.login_id,
1623: last_update_date = sysdate
1624: WHERE po_header_id = DocumentID;
1625: ELSE
1626: UPDATE po_drafts

Line 1628: last_updated_by = fnd_global.user_id,

1624: WHERE po_header_id = DocumentID;
1625: ELSE
1626: UPDATE po_drafts
1627: SET STATUS = 'IN PROCESS',
1628: last_updated_by = fnd_global.user_id,
1629: last_update_login = fnd_global.login_id,
1630: last_update_date = sysdate
1631: WHERE draft_id = DraftID;
1632: END IF; -- Mod project

Line 1629: last_update_login = fnd_global.login_id,

1625: ELSE
1626: UPDATE po_drafts
1627: SET STATUS = 'IN PROCESS',
1628: last_updated_by = fnd_global.user_id,
1629: last_update_login = fnd_global.login_id,
1630: last_update_date = sysdate
1631: WHERE draft_id = DraftID;
1632: END IF; -- Mod project
1633: END IF;

Line 4994: last_updated_by = fnd_global.user_id,

4990: UPDATE po_requisition_headers
4991: SET WF_ITEM_TYPE = itemtype,
4992: WF_ITEM_KEY = itemkey,
4993: active_shopping_cart_flag = NULL,
4994: last_updated_by = fnd_global.user_id,
4995: last_update_login = fnd_global.login_id,
4996: last_update_date = sysdate
4997: WHERE requisition_header_id = l_requisition_header_id;
4998: ELSE

Line 4995: last_update_login = fnd_global.login_id,

4991: SET WF_ITEM_TYPE = itemtype,
4992: WF_ITEM_KEY = itemkey,
4993: active_shopping_cart_flag = NULL,
4994: last_updated_by = fnd_global.user_id,
4995: last_update_login = fnd_global.login_id,
4996: last_update_date = sysdate
4997: WHERE requisition_header_id = l_requisition_header_id;
4998: ELSE
4999: UPDATE po_requisition_headers

Line 5004: last_updated_by = fnd_global.user_id,

5000: SET AUTHORIZATION_STATUS = p_auth_status,
5001: WF_ITEM_TYPE = itemtype,
5002: WF_ITEM_KEY = itemkey,
5003: active_shopping_cart_flag = NULL,
5004: last_updated_by = fnd_global.user_id,
5005: last_update_login = fnd_global.login_id,
5006: last_update_date = sysdate
5007: WHERE requisition_header_id = l_requisition_header_id;
5008: END IF;

Line 5005: last_update_login = fnd_global.login_id,

5001: WF_ITEM_TYPE = itemtype,
5002: WF_ITEM_KEY = itemkey,
5003: active_shopping_cart_flag = NULL,
5004: last_updated_by = fnd_global.user_id,
5005: last_update_login = fnd_global.login_id,
5006: last_update_date = sysdate
5007: WHERE requisition_header_id = l_requisition_header_id;
5008: END IF;
5009: COMMIT;

Line 5048: last_updated_by = fnd_global.user_id,

5044: IF note = 'UPGRADE_TO_R11' THEN
5045: UPDATE po_headers
5046: SET WF_ITEM_TYPE = itemtype,
5047: WF_ITEM_KEY = itemkey,
5048: last_updated_by = fnd_global.user_id,
5049: last_update_login = fnd_global.login_id,
5050: last_update_date = sysdate
5051: WHERE po_header_id = l_po_header_id;
5052: ELSE

Line 5049: last_update_login = fnd_global.login_id,

5045: UPDATE po_headers
5046: SET WF_ITEM_TYPE = itemtype,
5047: WF_ITEM_KEY = itemkey,
5048: last_updated_by = fnd_global.user_id,
5049: last_update_login = fnd_global.login_id,
5050: last_update_date = sysdate
5051: WHERE po_header_id = l_po_header_id;
5052: ELSE
5053: --Mod Project

Line 5059: last_updated_by = fnd_global.user_id,

5055: UPDATE po_headers
5056: SET AUTHORIZATION_STATUS = p_auth_status,
5057: WF_ITEM_TYPE = itemtype,
5058: WF_ITEM_KEY = itemkey,
5059: last_updated_by = fnd_global.user_id,
5060: last_update_login = fnd_global.login_id,
5061: last_update_date = sysdate ,
5062: submit_date = DECODE(p_auth_status, 'INCOMPLETE', to_date(NULL),submit_date) --
5063: ,

Line 5060: last_update_login = fnd_global.login_id,

5056: SET AUTHORIZATION_STATUS = p_auth_status,
5057: WF_ITEM_TYPE = itemtype,
5058: WF_ITEM_KEY = itemkey,
5059: last_updated_by = fnd_global.user_id,
5060: last_update_login = fnd_global.login_id,
5061: last_update_date = sysdate ,
5062: submit_date = DECODE(p_auth_status, 'INCOMPLETE', to_date(NULL),submit_date) --
5063: ,
5064: pending_signature_flag = DECODE(l_pending_signature_flag, 'Y', DECODE(acceptance_required_flag, 'S', 'Y', 'N'), pending_signature_flag)

Line 5070: last_updated_by = fnd_global.user_id,

5066: ELSE
5067: UPDATE Po_Headers_Draft_all
5068: SET WF_ITEM_TYPE = itemtype,
5069: WF_ITEM_KEY = itemkey,
5070: last_updated_by = fnd_global.user_id,
5071: last_update_login = fnd_global.login_id,
5072: last_update_date = sysdate,
5073: submit_date = DECODE(p_auth_status, 'INCOMPLETE', to_date(NULL),submit_date) ,
5074: pending_signature_flag = DECODE(l_pending_signature_flag, 'Y', DECODE(acceptance_required_flag, 'S', 'Y', 'N'), pending_signature_flag)

Line 5071: last_update_login = fnd_global.login_id,

5067: UPDATE Po_Headers_Draft_all
5068: SET WF_ITEM_TYPE = itemtype,
5069: WF_ITEM_KEY = itemkey,
5070: last_updated_by = fnd_global.user_id,
5071: last_update_login = fnd_global.login_id,
5072: last_update_date = sysdate,
5073: submit_date = DECODE(p_auth_status, 'INCOMPLETE', to_date(NULL),submit_date) ,
5074: pending_signature_flag = DECODE(l_pending_signature_flag, 'Y', DECODE(acceptance_required_flag, 'S', 'Y', 'N'), pending_signature_flag)
5075: WHERE po_header_id = l_po_header_id

Line 5111: last_updated_by = fnd_global.user_id,

5107: IF note = 'UPGRADE_TO_R11' THEN
5108: UPDATE po_releases
5109: SET WF_ITEM_TYPE = itemtype,
5110: WF_ITEM_KEY = itemkey,
5111: last_updated_by = fnd_global.user_id,
5112: last_update_login = fnd_global.login_id,
5113: last_update_date = sysdate
5114: WHERE po_release_id = l_Release_header_id;
5115: ELSE

Line 5112: last_update_login = fnd_global.login_id,

5108: UPDATE po_releases
5109: SET WF_ITEM_TYPE = itemtype,
5110: WF_ITEM_KEY = itemkey,
5111: last_updated_by = fnd_global.user_id,
5112: last_update_login = fnd_global.login_id,
5113: last_update_date = sysdate
5114: WHERE po_release_id = l_Release_header_id;
5115: ELSE
5116: UPDATE po_releases

Line 5120: last_updated_by = fnd_global.user_id,

5116: UPDATE po_releases
5117: SET AUTHORIZATION_STATUS = p_auth_status,
5118: WF_ITEM_TYPE = itemtype,
5119: WF_ITEM_KEY = itemkey,
5120: last_updated_by = fnd_global.user_id,
5121: last_update_login = fnd_global.login_id,
5122: last_update_date = sysdate ,
5123: submit_date = DECODE(p_auth_status, 'INCOMPLETE', to_date(NULL),submit_date) --
5124: WHERE po_release_id = l_Release_header_id;

Line 5121: last_update_login = fnd_global.login_id,

5117: SET AUTHORIZATION_STATUS = p_auth_status,
5118: WF_ITEM_TYPE = itemtype,
5119: WF_ITEM_KEY = itemkey,
5120: last_updated_by = fnd_global.user_id,
5121: last_update_login = fnd_global.login_id,
5122: last_update_date = sysdate ,
5123: submit_date = DECODE(p_auth_status, 'INCOMPLETE', to_date(NULL),submit_date) --
5124: WHERE po_release_id = l_Release_header_id;
5125: END IF;

Line 5147: last_updated_by = fnd_global.user_id,

5143: x_progress := '001';
5144: UPDATE po_requisition_headers
5145: SET WF_ITEM_TYPE = itemtype,
5146: WF_ITEM_KEY = itemkey,
5147: last_updated_by = fnd_global.user_id,
5148: last_update_login = fnd_global.login_id,
5149: last_update_date = sysdate
5150: WHERE requisition_header_id = p_doc_id;
5151: COMMIT;

Line 5148: last_update_login = fnd_global.login_id,

5144: UPDATE po_requisition_headers
5145: SET WF_ITEM_TYPE = itemtype,
5146: WF_ITEM_KEY = itemkey,
5147: last_updated_by = fnd_global.user_id,
5148: last_update_login = fnd_global.login_id,
5149: last_update_date = sysdate
5150: WHERE requisition_header_id = p_doc_id;
5151: COMMIT;
5152: EXCEPTION

Line 5171: last_updated_by = fnd_global.user_id,

5167: x_progress := '001';
5168: UPDATE po_headers
5169: SET WF_ITEM_TYPE = itemtype,
5170: WF_ITEM_KEY = itemkey,
5171: last_updated_by = fnd_global.user_id,
5172: last_update_login = fnd_global.login_id,
5173: last_update_date = sysdate ,
5174: submit_date = sysdate --
5175: WHERE po_header_id = p_doc_id;

Line 5172: last_update_login = fnd_global.login_id,

5168: UPDATE po_headers
5169: SET WF_ITEM_TYPE = itemtype,
5170: WF_ITEM_KEY = itemkey,
5171: last_updated_by = fnd_global.user_id,
5172: last_update_login = fnd_global.login_id,
5173: last_update_date = sysdate ,
5174: submit_date = sysdate --
5175: WHERE po_header_id = p_doc_id;
5176: COMMIT;

Line 5196: last_updated_by = fnd_global.user_id,

5192: x_progress := '001';
5193: UPDATE po_releases
5194: SET WF_ITEM_TYPE = itemtype,
5195: WF_ITEM_KEY = itemkey,
5196: last_updated_by = fnd_global.user_id,
5197: last_update_login = fnd_global.login_id,
5198: last_update_date = sysdate ,
5199: submit_date = sysdate --
5200: WHERE po_release_id = p_doc_id;

Line 5197: last_update_login = fnd_global.login_id,

5193: UPDATE po_releases
5194: SET WF_ITEM_TYPE = itemtype,
5195: WF_ITEM_KEY = itemkey,
5196: last_updated_by = fnd_global.user_id,
5197: last_update_login = fnd_global.login_id,
5198: last_update_date = sysdate ,
5199: submit_date = sysdate --
5200: WHERE po_release_id = p_doc_id;
5201: COMMIT;

Line 5514: fnd_global.user_id,

5510: p_doc_type,
5511: l_doc_subtype, --Mod Project
5512: l_sequence_num,
5513: sysdate,
5514: fnd_global.user_id,
5515: sysdate,
5516: fnd_global.user_id,
5517: p_action,
5518: DECODE(p_action, '',to_date(NULL), sysdate),

Line 5516: fnd_global.user_id,

5512: l_sequence_num,
5513: sysdate,
5514: fnd_global.user_id,
5515: sysdate,
5516: fnd_global.user_id,
5517: p_action,
5518: DECODE(p_action, '',to_date(NULL), sysdate),
5519: p_employee_id,
5520: p_note,

Line 5522: fnd_global.login_id,

5518: DECODE(p_action, '',to_date(NULL), sysdate),
5519: p_employee_id,
5520: p_note,
5521: l_revision_num,
5522: fnd_global.login_id,
5523: 0,
5524: 0,
5525: 0,
5526: '',

Line 5538: last_updated_by = fnd_global.user_id,

5534: object_type_code = p_doc_type,
5535: object_sub_type_code = l_doc_subtype, --Mod Project
5536: sequence_num = l_sequence_num,
5537: last_update_date = sysdate,
5538: last_updated_by = fnd_global.user_id,
5539: creation_date = sysdate,
5540: created_by = fnd_global.user_id,
5541: action_code = p_action,
5542: action_date = DECODE(p_action, '',to_date(NULL), sysdate),

Line 5540: created_by = fnd_global.user_id,

5536: sequence_num = l_sequence_num,
5537: last_update_date = sysdate,
5538: last_updated_by = fnd_global.user_id,
5539: creation_date = sysdate,
5540: created_by = fnd_global.user_id,
5541: action_code = p_action,
5542: action_date = DECODE(p_action, '',to_date(NULL), sysdate),
5543: employee_id = p_employee_id,
5544: note = p_note,

Line 5546: last_update_login = fnd_global.login_id,

5542: action_date = DECODE(p_action, '',to_date(NULL), sysdate),
5543: employee_id = p_employee_id,
5544: note = p_note,
5545: object_revision_num = l_revision_num,
5546: last_update_login = fnd_global.login_id,
5547: request_id = 0,
5548: program_application_id = 0,
5549: program_id = 0,
5550: program_update_date = '',

Line 5597: fnd_global.user_id,

5593: p_doc_type,
5594: l_doc_subtype, --Mod Project
5595: l_sequence_num + 1,
5596: sysdate,
5597: fnd_global.user_id,
5598: sysdate,
5599: fnd_global.user_id,
5600: NULL, -- ACTION_CODE
5601: DECODE(p_action, '',to_date(NULL), sysdate),

Line 5599: fnd_global.user_id,

5595: l_sequence_num + 1,
5596: sysdate,
5597: fnd_global.user_id,
5598: sysdate,
5599: fnd_global.user_id,
5600: NULL, -- ACTION_CODE
5601: DECODE(p_action, '',to_date(NULL), sysdate),
5602: p_employee_id,
5603: NULL,

Line 5605: fnd_global.login_id,

5601: DECODE(p_action, '',to_date(NULL), sysdate),
5602: p_employee_id,
5603: NULL,
5604: l_revision_num,
5605: fnd_global.login_id,
5606: 0,
5607: 0,
5608: 0,
5609: '',

Line 6262: 'P_REQ_NUM_TO=' || p_doc_num, 'P_QTY_PRECISION=' || p_qty_precision, fnd_global.local_chr(0),

6258: --
6259: l_request_id := fnd_request.submit_request
6260: (
6261: 'PO', 'PRINTREQ', NULL, NULL, false, 'P_REQ_NUM_FROM=' || p_doc_num,
6262: 'P_REQ_NUM_TO=' || p_doc_num, 'P_QTY_PRECISION=' || p_qty_precision, fnd_global.local_chr(0),
6263: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
6264: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
6265: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
6266: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,

Line 6354: fnd_global.local_chr(0), NULL, NULL, NULL, NULL, NULL,

6350: p_document_subtype, --P_DOCUMENT_TYPE Bug# 6692126
6351: 0 , --P_max_zip_size,
6352: NULL , --P_PO_TEMPLATE_CODE
6353: NULL , --P_CONTRACT_TEMPLATE_CODE
6354: fnd_global.local_chr(0), NULL, NULL, NULL, NULL, NULL,
6355: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
6356: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
6357: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
6358: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,

Line 6380: fnd_global.local_chr(0), NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,

6376: (
6377: 'PO', 'POXPPO', NULL, NULL, false, 'P_REPORT_TYPE=R', 'P_TEST_FLAG=N',
6378: 'P_PO_NUM_FROM=' || p_doc_num, 'P_PO_NUM_TO=' || p_doc_num, 'P_USER_ID=' || p_user_id,
6379: 'P_QTY_PRECISION=' || p_qty_precision, 'P_BLANKET_LINES=Y', 'P_PRINT_RELEASES=N',
6380: fnd_global.local_chr(0), NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
6381: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
6382: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
6383: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
6384: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,

Line 6476: fnd_global.local_chr(0), NULL, NULL, NULL, NULL, NULL,

6472: p_document_subtype, --P_DOCUMENT_TYPE Bug# 6692126
6473: 0 , --P_max_zip_size,
6474: NULL , --P_PO_TEMPLATE_CODE
6475: NULL , --P_CONTRACT_TEMPLATE_CODE
6476: fnd_global.local_chr(0), NULL, NULL, NULL, NULL, NULL,
6477: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
6478: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
6479: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
6480: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,

Line 6502: fnd_global.local_chr(0), NULL, NULL, NULL,

6498: 'PO', 'POXPPO', NULL, NULL, false, 'P_REPORT_TYPE=R', 'P_TEST_FLAG=N', 'P_PO_NUM_FROM=' || p_doc_num,
6499: 'P_PO_NUM_TO=' || p_doc_num, 'P_USER_ID=' || p_user_id, 'P_QTY_PRECISION=' || p_qty_precision,
6500: 'P_FAX_ENABLE=' || p_fax_enable, 'P_FAX_NUM=' || p_fax_num, 'P_BLANKET_LINES=Y', -- Bug 3672088
6501: 'P_PRINT_RELEASES=N', -- Bug 3672088
6502: fnd_global.local_chr(0), NULL, NULL, NULL,
6503: NULL, NULL, NULL, NULL, NULL, NULL, NULL,
6504: NULL, NULL, NULL, NULL, NULL, NULL, NULL,
6505: NULL, NULL, NULL, NULL, NULL, NULL, NULL,
6506: NULL, NULL, NULL, NULL, NULL, NULL, NULL,

Line 6597: fnd_global.local_chr(0), NULL, NULL, NULL, NULL,

6593: 'RELEASE' , --P_DOCUMENT_TYPE Bug# 6692126
6594: 0 , --P_max_zip_size,
6595: NULL , --P_PO_TEMPLATE_CODE
6596: NULL , --P_CONTRACT_TEMPLATE_CODE
6597: fnd_global.local_chr(0), NULL, NULL, NULL, NULL,
6598: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
6599: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
6600: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
6601: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,

Line 6626: 'P_BLANKET_LINES=N', 'P_PRINT_RELEASES=Y', fnd_global.local_chr(0), NULL,

6622: 'PO', 'POXPPO', NULL, NULL, false, 'P_REPORT_TYPE=R',
6623: 'P_TEST_FLAG=N', 'P_USER_ID=' || p_user_id, 'P_PO_NUM_FROM=' || p_doc_num,
6624: 'P_PO_NUM_TO=' || p_doc_num, 'P_RELEASE_NUM_FROM=' || p_release_num,
6625: 'P_RELEASE_NUM_TO=' || p_release_num, 'P_QTY_PRECISION=' || p_qty_precision,
6626: 'P_BLANKET_LINES=N', 'P_PRINT_RELEASES=Y', fnd_global.local_chr(0), NULL,
6627: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
6628: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
6629: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
6630: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,

Line 6721: fnd_global.local_chr(0), NULL, NULL, NULL, NULL,

6717: 'RELEASE' , --P_DOCUMENT_TYPE Bug# 6692126
6718: 0 , --P_max_zip_size,
6719: NULL , --P_PO_TEMPLATE_CODE
6720: NULL , --P_CONTRACT_TEMPLATE_CODE
6721: fnd_global.local_chr(0), NULL, NULL, NULL, NULL,
6722: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
6723: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
6724: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
6725: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,

Line 6751: fnd_global.local_chr(0), NULL, NULL, NULL, NULL, NULL, NULL,

6747: 'P_PO_NUM_TO=' || p_doc_num, 'P_RELEASE_NUM_FROM=' || p_release_num,
6748: 'P_RELEASE_NUM_TO=' || p_release_num, 'P_QTY_PRECISION=' || p_qty_precision,
6749: 'P_FAX_ENABLE=' || p_fax_enable, 'P_FAX_NUM=' || p_fax_num, 'P_BLANKET_LINES=N', -- Bug 3672088
6750: 'P_PRINT_RELEASES=Y', -- Bug 3672088
6751: fnd_global.local_chr(0), NULL, NULL, NULL, NULL, NULL, NULL,
6752: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
6753: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
6754: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
6755: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,

Line 7762: -- x_Last_Updated_By number := fnd_global.user_id;

7758: x_row_id VARCHAR2(30);
7759: -- Bug 2850566
7760: -- x_Acceptance_id number;
7761: -- x_Last_Update_Date date := TRUNC(SYSDATE);
7762: -- x_Last_Updated_By number := fnd_global.user_id;
7763: -- End of Bug 2850566
7764: x_Creation_Date DATE := TRUNC(SYSDATE);
7765: x_Created_By NUMBER := fnd_global.user_id;
7766: x_Po_Header_Id NUMBER;

Line 7765: x_Created_By NUMBER := fnd_global.user_id;

7761: -- x_Last_Update_Date date := TRUNC(SYSDATE);
7762: -- x_Last_Updated_By number := fnd_global.user_id;
7763: -- End of Bug 2850566
7764: x_Creation_Date DATE := TRUNC(SYSDATE);
7765: x_Created_By NUMBER := fnd_global.user_id;
7766: x_Po_Header_Id NUMBER;
7767: x_Po_Release_Id NUMBER;
7768: x_Action VARCHAR2(240) := 'NEW';
7769: x_Action_Date DATE := TRUNC(SYSDATE);

Line 7907: X_User_Id := fnd_global.user_id;

7903: --Fnd_Profile.Get('RESP_ID',X_Responsibility_Id);
7904: --Fnd_Profile.Get('RESP_APPL_ID',X_Application_Id);
7905: -- Bug 4290541 End
7906: -- Context Setting Revamp
7907: X_User_Id := fnd_global.user_id;
7908: X_Responsibility_Id := fnd_global.resp_id;
7909: X_Application_Id := fnd_global.resp_appl_id;
7910: x_progress := 'PO_REQAPPROVAL_INIT1.set_doc_mgr_context.X_USER_ID= ' || TO_CHAR(x_user_id) || 'X_ APPLICATION_ID= ' || TO_CHAR(x_application_id) || 'X_RESPONSIBILITY_ID= ' || TO_CHAR(x_responsibility_id);
7911: IF (g_po_wf_debug = 'Y') THEN

Line 7908: X_Responsibility_Id := fnd_global.resp_id;

7904: --Fnd_Profile.Get('RESP_APPL_ID',X_Application_Id);
7905: -- Bug 4290541 End
7906: -- Context Setting Revamp
7907: X_User_Id := fnd_global.user_id;
7908: X_Responsibility_Id := fnd_global.resp_id;
7909: X_Application_Id := fnd_global.resp_appl_id;
7910: x_progress := 'PO_REQAPPROVAL_INIT1.set_doc_mgr_context.X_USER_ID= ' || TO_CHAR(x_user_id) || 'X_ APPLICATION_ID= ' || TO_CHAR(x_application_id) || 'X_RESPONSIBILITY_ID= ' || TO_CHAR(x_responsibility_id);
7911: IF (g_po_wf_debug = 'Y') THEN
7912: /* DEBUG */

Line 7909: X_Application_Id := fnd_global.resp_appl_id;

7905: -- Bug 4290541 End
7906: -- Context Setting Revamp
7907: X_User_Id := fnd_global.user_id;
7908: X_Responsibility_Id := fnd_global.resp_id;
7909: X_Application_Id := fnd_global.resp_appl_id;
7910: x_progress := 'PO_REQAPPROVAL_INIT1.set_doc_mgr_context.X_USER_ID= ' || TO_CHAR(x_user_id) || 'X_ APPLICATION_ID= ' || TO_CHAR(x_application_id) || 'X_RESPONSIBILITY_ID= ' || TO_CHAR(x_responsibility_id);
7911: IF (g_po_wf_debug = 'Y') THEN
7912: /* DEBUG */
7913: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

Line 7944: FND_GLOBAL.APPS_INITIALIZE (X_USER_ID, L_RESPONSIBILITY_ID, L_APPLICATION_ID);

7940: -- Set the application context to the logged-in user
7941: -- if not null
7942: IF (NVL(X_USER_ID,-1) = -1 OR NVL(X_RESPONSIBILITY_ID,-1) = -1 OR NVL(X_APPLICATION_ID,-1) = -1)THEN
7943: IF X_USER_ID IS NOT NULL THEN
7944: FND_GLOBAL.APPS_INITIALIZE (X_USER_ID, L_RESPONSIBILITY_ID, L_APPLICATION_ID);
7945: ELSE
7946: -- Start fix for Bug 3543578
7947: IF ( L_USER_ID IS NOT NULL AND L_RESPONSIBILITY_ID IS NOT NULL AND L_APPLICATION_ID IS NOT NULL) THEN
7948: FND_GLOBAL.APPS_INITIALIZE (L_USER_ID, L_RESPONSIBILITY_ID, L_APPLICATION_ID);

Line 7948: FND_GLOBAL.APPS_INITIALIZE (L_USER_ID, L_RESPONSIBILITY_ID, L_APPLICATION_ID);

7944: FND_GLOBAL.APPS_INITIALIZE (X_USER_ID, L_RESPONSIBILITY_ID, L_APPLICATION_ID);
7945: ELSE
7946: -- Start fix for Bug 3543578
7947: IF ( L_USER_ID IS NOT NULL AND L_RESPONSIBILITY_ID IS NOT NULL AND L_APPLICATION_ID IS NOT NULL) THEN
7948: FND_GLOBAL.APPS_INITIALIZE (L_USER_ID, L_RESPONSIBILITY_ID, L_APPLICATION_ID);
7949: END IF;
7950: -- End fix for Bug 3543578
7951: END IF;
7952: END IF;

Line 7956: * fnd_global.APPS_INITIALIZE resets it back to the operating unit of

7952: END IF;
7953: -- Bug 4125251 End
7954: /* RETRO FPI START.
7955: * If we had set the org context for a different operating unit, the above
7956: * fnd_global.APPS_INITIALIZE resets it back to the operating unit of
7957: * the responsibility. So set the org context explicitly again.
7958: */
7959: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'ORG_ID');
7960: IF l_orgid IS NOT NULL THEN

Line 8406: pah.last_updated_by = fnd_global.user_id,

8402: UPDATE po_action_history pah
8403: SET pah.action_code = p_action,
8404: pah.action_date = SYSDATE,
8405: pah.Note = l_note,
8406: pah.last_updated_by = fnd_global.user_id,
8407: pah.last_update_login = fnd_global.login_id,
8408: pah.last_update_date = SYSDATE
8409: WHERE ROWID = l_rowid;
8410: END IF;

Line 8407: pah.last_update_login = fnd_global.login_id,

8403: SET pah.action_code = p_action,
8404: pah.action_date = SYSDATE,
8405: pah.Note = l_note,
8406: pah.last_updated_by = fnd_global.user_id,
8407: pah.last_update_login = fnd_global.login_id,
8408: pah.last_update_date = SYSDATE
8409: WHERE ROWID = l_rowid;
8410: END IF;
8411: COMMIT;