DBA Data[Home] [Help]

APPS.PO_REQAPPROVAL_INIT1 dependencies on FND_GLOBAL

Line 1589: l_user_id := fnd_global.user_id;

1585: --FND_PROFILE.GET('RESP_ID', l_responsibility_id);
1586: --FND_PROFILE.GET('RESP_APPL_ID', l_application_id);
1587:
1588:
1589: l_user_id := fnd_global.user_id;
1590: l_responsibility_id := fnd_global.resp_id;
1591: l_application_id := fnd_global.resp_appl_id;
1592:
1593: IF (l_user_id = -1) THEN

Line 1590: l_responsibility_id := fnd_global.resp_id;

1586: --FND_PROFILE.GET('RESP_APPL_ID', l_application_id);
1587:
1588:
1589: l_user_id := fnd_global.user_id;
1590: l_responsibility_id := fnd_global.resp_id;
1591: l_application_id := fnd_global.resp_appl_id;
1592:
1593: IF (l_user_id = -1) THEN
1594: l_user_id := NULL;

Line 1591: l_application_id := fnd_global.resp_appl_id;

1587:
1588:
1589: l_user_id := fnd_global.user_id;
1590: l_responsibility_id := fnd_global.resp_id;
1591: l_application_id := fnd_global.resp_appl_id;
1592:
1593: IF (l_user_id = -1) THEN
1594: l_user_id := NULL;
1595: END IF;

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

1620: aname => 'RESPONSIBILITY_ID',
1621: avalue => l_responsibility_id);
1622:
1623: /* Set the context for the doc manager */
1624: fnd_global.APPS_INITIALIZE (l_user_id, l_responsibility_id, l_application_id);
1625: -- bug fix 2424044
1626: IF x_orgid is NOT NULL THEN
1627: PO_MOAC_UTILS_PVT.set_org_context(x_orgid) ; --
1628: END IF;

Line 1641: last_updated_by = fnd_global.user_id,

1637: IF p_background_flag = 'Y' THEN
1638: IF DocumentTypeCode = 'RELEASE' THEN
1639: update po_releases
1640: set AUTHORIZATION_STATUS = 'IN PROCESS',
1641: last_updated_by = fnd_global.user_id,
1642: last_update_login = fnd_global.login_id,
1643: last_update_date = sysdate
1644: where po_release_id = DocumentID;
1645: ELSE --PO or PA

Line 1642: last_update_login = fnd_global.login_id,

1638: IF DocumentTypeCode = 'RELEASE' THEN
1639: update po_releases
1640: set AUTHORIZATION_STATUS = 'IN PROCESS',
1641: last_updated_by = fnd_global.user_id,
1642: last_update_login = fnd_global.login_id,
1643: last_update_date = sysdate
1644: where po_release_id = DocumentID;
1645: ELSE --PO or PA
1646: update po_headers

Line 1648: last_updated_by = fnd_global.user_id,

1644: where po_release_id = DocumentID;
1645: ELSE --PO or PA
1646: update po_headers
1647: set AUTHORIZATION_STATUS = 'IN PROCESS',
1648: last_updated_by = fnd_global.user_id,
1649: last_update_login = fnd_global.login_id,
1650: last_update_date = sysdate
1651: where po_header_id = DocumentID;
1652: END IF;

Line 1649: last_update_login = fnd_global.login_id,

1645: ELSE --PO or PA
1646: update po_headers
1647: set AUTHORIZATION_STATUS = 'IN PROCESS',
1648: last_updated_by = fnd_global.user_id,
1649: last_update_login = fnd_global.login_id,
1650: last_update_date = sysdate
1651: where po_header_id = DocumentID;
1652: END IF;
1653: END IF; -- END of IF p_background_flag = 'Y'

Line 5904: last_updated_by = fnd_global.user_id,

5900: update po_requisition_headers set
5901: WF_ITEM_TYPE = itemtype,
5902: WF_ITEM_KEY = itemkey,
5903: active_shopping_cart_flag = NULL,
5904: last_updated_by = fnd_global.user_id,
5905: last_update_login = fnd_global.login_id,
5906: last_update_date = sysdate
5907: where requisition_header_id = l_requisition_header_id;
5908:

Line 5905: last_update_login = fnd_global.login_id,

5901: WF_ITEM_TYPE = itemtype,
5902: WF_ITEM_KEY = itemkey,
5903: active_shopping_cart_flag = NULL,
5904: last_updated_by = fnd_global.user_id,
5905: last_update_login = fnd_global.login_id,
5906: last_update_date = sysdate
5907: where requisition_header_id = l_requisition_header_id;
5908:
5909: ELSE

Line 5916: last_updated_by = fnd_global.user_id,

5912: AUTHORIZATION_STATUS = p_auth_status,
5913: WF_ITEM_TYPE = itemtype,
5914: WF_ITEM_KEY = itemkey,
5915: active_shopping_cart_flag = NULL,
5916: last_updated_by = fnd_global.user_id,
5917: last_update_login = fnd_global.login_id,
5918: last_update_date = sysdate
5919: where requisition_header_id = l_requisition_header_id;
5920:

Line 5917: last_update_login = fnd_global.login_id,

5913: WF_ITEM_TYPE = itemtype,
5914: WF_ITEM_KEY = itemkey,
5915: active_shopping_cart_flag = NULL,
5916: last_updated_by = fnd_global.user_id,
5917: last_update_login = fnd_global.login_id,
5918: last_update_date = sysdate
5919: where requisition_header_id = l_requisition_header_id;
5920:
5921: END IF;

Line 5957: last_updated_by = fnd_global.user_id,

5953:
5954: update po_headers set
5955: WF_ITEM_TYPE = itemtype,
5956: WF_ITEM_KEY = itemkey,
5957: last_updated_by = fnd_global.user_id,
5958: last_update_login = fnd_global.login_id,
5959: last_update_date = sysdate
5960: where po_header_id = l_po_header_id;
5961:

Line 5958: last_update_login = fnd_global.login_id,

5954: update po_headers set
5955: WF_ITEM_TYPE = itemtype,
5956: WF_ITEM_KEY = itemkey,
5957: last_updated_by = fnd_global.user_id,
5958: last_update_login = fnd_global.login_id,
5959: last_update_date = sysdate
5960: where po_header_id = l_po_header_id;
5961:
5962: ELSE

Line 5968: last_updated_by = fnd_global.user_id,

5964: update po_headers set
5965: AUTHORIZATION_STATUS = p_auth_status,
5966: WF_ITEM_TYPE = itemtype,
5967: WF_ITEM_KEY = itemkey,
5968: last_updated_by = fnd_global.user_id,
5969: last_update_login = fnd_global.login_id,
5970: last_update_date = sysdate
5971: ,submit_date = decode(p_auth_status,
5972: 'INCOMPLETE', to_date(null),submit_date) --

Line 5969: last_update_login = fnd_global.login_id,

5965: AUTHORIZATION_STATUS = p_auth_status,
5966: WF_ITEM_TYPE = itemtype,
5967: WF_ITEM_KEY = itemkey,
5968: last_updated_by = fnd_global.user_id,
5969: last_update_login = fnd_global.login_id,
5970: last_update_date = sysdate
5971: ,submit_date = decode(p_auth_status,
5972: 'INCOMPLETE', to_date(null),submit_date) --
5973: where po_header_id = l_po_header_id;

Line 6010: last_updated_by = fnd_global.user_id,

6006:
6007: update po_releases set
6008: WF_ITEM_TYPE = itemtype,
6009: WF_ITEM_KEY = itemkey,
6010: last_updated_by = fnd_global.user_id,
6011: last_update_login = fnd_global.login_id,
6012: last_update_date = sysdate
6013: where po_release_id = l_Release_header_id;
6014:

Line 6011: last_update_login = fnd_global.login_id,

6007: update po_releases set
6008: WF_ITEM_TYPE = itemtype,
6009: WF_ITEM_KEY = itemkey,
6010: last_updated_by = fnd_global.user_id,
6011: last_update_login = fnd_global.login_id,
6012: last_update_date = sysdate
6013: where po_release_id = l_Release_header_id;
6014:
6015: ELSE

Line 6021: last_updated_by = fnd_global.user_id,

6017: update po_releases set
6018: AUTHORIZATION_STATUS = p_auth_status,
6019: WF_ITEM_TYPE = itemtype,
6020: WF_ITEM_KEY = itemkey,
6021: last_updated_by = fnd_global.user_id,
6022: last_update_login = fnd_global.login_id,
6023: last_update_date = sysdate
6024: ,submit_date = decode(p_auth_status,
6025: 'INCOMPLETE', to_date(null),submit_date) --

Line 6022: last_update_login = fnd_global.login_id,

6018: AUTHORIZATION_STATUS = p_auth_status,
6019: WF_ITEM_TYPE = itemtype,
6020: WF_ITEM_KEY = itemkey,
6021: last_updated_by = fnd_global.user_id,
6022: last_update_login = fnd_global.login_id,
6023: last_update_date = sysdate
6024: ,submit_date = decode(p_auth_status,
6025: 'INCOMPLETE', to_date(null),submit_date) --
6026: where po_release_id = l_Release_header_id;

Line 6050: last_updated_by = fnd_global.user_id,

6046:
6047: update po_requisition_headers set
6048: WF_ITEM_TYPE = itemtype,
6049: WF_ITEM_KEY = itemkey,
6050: last_updated_by = fnd_global.user_id,
6051: last_update_login = fnd_global.login_id,
6052: last_update_date = sysdate
6053: where requisition_header_id = p_doc_id;
6054:

Line 6051: last_update_login = fnd_global.login_id,

6047: update po_requisition_headers set
6048: WF_ITEM_TYPE = itemtype,
6049: WF_ITEM_KEY = itemkey,
6050: last_updated_by = fnd_global.user_id,
6051: last_update_login = fnd_global.login_id,
6052: last_update_date = sysdate
6053: where requisition_header_id = p_doc_id;
6054:
6055: commit;

Line 6077: last_updated_by = fnd_global.user_id,

6073:
6074: update po_headers set
6075: WF_ITEM_TYPE = itemtype,
6076: WF_ITEM_KEY = itemkey,
6077: last_updated_by = fnd_global.user_id,
6078: last_update_login = fnd_global.login_id,
6079: last_update_date = sysdate
6080: ,submit_date = sysdate --
6081: where po_header_id = p_doc_id;

Line 6078: last_update_login = fnd_global.login_id,

6074: update po_headers set
6075: WF_ITEM_TYPE = itemtype,
6076: WF_ITEM_KEY = itemkey,
6077: last_updated_by = fnd_global.user_id,
6078: last_update_login = fnd_global.login_id,
6079: last_update_date = sysdate
6080: ,submit_date = sysdate --
6081: where po_header_id = p_doc_id;
6082:

Line 6106: last_updated_by = fnd_global.user_id,

6102:
6103: update po_releases set
6104: WF_ITEM_TYPE = itemtype,
6105: WF_ITEM_KEY = itemkey,
6106: last_updated_by = fnd_global.user_id,
6107: last_update_login = fnd_global.login_id,
6108: last_update_date = sysdate
6109: ,submit_date = sysdate --
6110: where po_release_id = p_doc_id;

Line 6107: last_update_login = fnd_global.login_id,

6103: update po_releases set
6104: WF_ITEM_TYPE = itemtype,
6105: WF_ITEM_KEY = itemkey,
6106: last_updated_by = fnd_global.user_id,
6107: last_update_login = fnd_global.login_id,
6108: last_update_date = sysdate
6109: ,submit_date = sysdate --
6110: where po_release_id = p_doc_id;
6111:

Line 6406: fnd_global.user_id,

6402: p_doc_type,
6403: p_doc_subtype,
6404: l_sequence_num,
6405: sysdate,
6406: fnd_global.user_id,
6407: sysdate,
6408: fnd_global.user_id,
6409: p_action,
6410: decode(p_action, '',to_date(null), sysdate),

Line 6408: fnd_global.user_id,

6404: l_sequence_num,
6405: sysdate,
6406: fnd_global.user_id,
6407: sysdate,
6408: fnd_global.user_id,
6409: p_action,
6410: decode(p_action, '',to_date(null), sysdate),
6411: p_employee_id,
6412: p_note,

Line 6414: fnd_global.login_id,

6410: decode(p_action, '',to_date(null), sysdate),
6411: p_employee_id,
6412: p_note,
6413: l_revision_num,
6414: fnd_global.login_id,
6415: 0,
6416: 0,
6417: 0,
6418: '',

Line 6430: last_updated_by = fnd_global.user_id,

6426: object_type_code = p_doc_type,
6427: object_sub_type_code = p_doc_subtype,
6428: sequence_num = l_sequence_num,
6429: last_update_date = sysdate,
6430: last_updated_by = fnd_global.user_id,
6431: creation_date = sysdate,
6432: created_by = fnd_global.user_id,
6433: action_code = p_action,
6434: action_date = decode(p_action, '',to_date(null), sysdate),

Line 6432: created_by = fnd_global.user_id,

6428: sequence_num = l_sequence_num,
6429: last_update_date = sysdate,
6430: last_updated_by = fnd_global.user_id,
6431: creation_date = sysdate,
6432: created_by = fnd_global.user_id,
6433: action_code = p_action,
6434: action_date = decode(p_action, '',to_date(null), sysdate),
6435: employee_id = p_employee_id,
6436: note = p_note,

Line 6438: last_update_login = fnd_global.login_id,

6434: action_date = decode(p_action, '',to_date(null), sysdate),
6435: employee_id = p_employee_id,
6436: note = p_note,
6437: object_revision_num = l_revision_num,
6438: last_update_login = fnd_global.login_id,
6439: request_id = 0,
6440: program_application_id = 0,
6441: program_id = 0,
6442: program_update_date = '',

Line 6487: fnd_global.user_id,

6483: p_doc_type,
6484: p_doc_subtype,
6485: l_sequence_num + 1,
6486: sysdate,
6487: fnd_global.user_id,
6488: sysdate,
6489: fnd_global.user_id,
6490: NULL, -- ACTION_CODE
6491: decode(p_action, '',to_date(null), sysdate),

Line 6489: fnd_global.user_id,

6485: l_sequence_num + 1,
6486: sysdate,
6487: fnd_global.user_id,
6488: sysdate,
6489: fnd_global.user_id,
6490: NULL, -- ACTION_CODE
6491: decode(p_action, '',to_date(null), sysdate),
6492: p_employee_id,
6493: NULL,

Line 6495: fnd_global.login_id,

6491: decode(p_action, '',to_date(null), sysdate),
6492: p_employee_id,
6493: NULL,
6494: l_revision_num,
6495: fnd_global.login_id,
6496: 0,
6497: 0,
6498: 0,
6499: '',

Line 6984: fnd_global.local_chr(0),

6980: false,
6981: 'P_REQ_NUM_FROM=' || p_doc_num,
6982: 'P_REQ_NUM_TO=' || p_doc_num,
6983: 'P_QTY_PRECISION=' || p_qty_precision,
6984: fnd_global.local_chr(0),
6985: NULL,
6986: NULL,
6987: NULL,
6988: NULL, NULL,

Line 7064: fnd_global.local_chr(0),

7060: p_document_subtype, --P_DOCUMENT_TYPE Bug# 6692126
7061: 0 ,--P_max_zip_size,
7062: null ,--P_PO_TEMPLATE_CODE
7063: null ,--P_CONTRACT_TEMPLATE_CODE
7064: fnd_global.local_chr(0),
7065: NULL, NULL, NULL, NULL, NULL, NULL, NULL,
7066: NULL, NULL, NULL, NULL, NULL, NULL, NULL,
7067: NULL, NULL, NULL, NULL, NULL, NULL, NULL,
7068: NULL, NULL, NULL, NULL, NULL, NULL, NULL,

Line 7096: fnd_global.local_chr(0),

7092: 'P_USER_ID=' || p_user_id,
7093: 'P_QTY_PRECISION=' || p_qty_precision,
7094: 'P_BLANKET_LINES=Y',
7095: 'P_PRINT_RELEASES=N',
7096: fnd_global.local_chr(0),
7097: NULL, NULL, NULL, NULL, NULL, NULL, NULL,
7098: NULL, NULL, NULL, NULL, NULL, NULL, NULL,
7099: NULL, NULL, NULL, NULL, NULL, NULL, NULL,
7100: NULL, NULL, NULL, NULL, NULL, NULL, NULL,

Line 7180: fnd_global.local_chr(0),

7176: p_document_subtype,--P_DOCUMENT_TYPE Bug# 6692126
7177: 0 ,--P_max_zip_size,
7178: null ,--P_PO_TEMPLATE_CODE
7179: null ,--P_CONTRACT_TEMPLATE_CODE
7180: fnd_global.local_chr(0),
7181: NULL, NULL, NULL, NULL, NULL, NULL, NULL,
7182: NULL, NULL, NULL, NULL, NULL, NULL, NULL,
7183: NULL, NULL, NULL, NULL, NULL, NULL, NULL,
7184: NULL, NULL, NULL, NULL, NULL, NULL, NULL,

Line 7215: fnd_global.local_chr(0),

7211: 'P_FAX_ENABLE=' || p_fax_enable,
7212: 'P_FAX_NUM=' || p_fax_num,
7213: 'P_BLANKET_LINES=Y', -- Bug 3672088
7214: 'P_PRINT_RELEASES=N', -- Bug 3672088
7215: fnd_global.local_chr(0),
7216: NULL, NULL, NULL, NULL, NULL, NULL, NULL,
7217: NULL, NULL, NULL, NULL, NULL, NULL, NULL,
7218: NULL, NULL, NULL, NULL, NULL, NULL, NULL,
7219: NULL, NULL, NULL, NULL, NULL, NULL, NULL,

Line 7295: fnd_global.local_chr(0),

7291: 'RELEASE' ,--P_DOCUMENT_TYPE Bug# 6692126
7292: 0 ,--P_max_zip_size,
7293: null ,--P_PO_TEMPLATE_CODE
7294: null ,--P_CONTRACT_TEMPLATE_CODE
7295: fnd_global.local_chr(0),
7296: NULL, NULL, NULL, NULL, NULL, NULL, NULL,
7297: NULL, NULL, NULL, NULL, NULL, NULL, NULL,
7298: NULL, NULL, NULL, NULL, NULL, NULL, NULL,
7299: NULL, NULL, NULL, NULL, NULL, NULL, NULL,

Line 7330: fnd_global.local_chr(0),

7326: 'P_RELEASE_NUM_TO=' || p_release_num,
7327: 'P_QTY_PRECISION=' || p_qty_precision,
7328: 'P_BLANKET_LINES=N',
7329: 'P_PRINT_RELEASES=Y',
7330: fnd_global.local_chr(0),
7331: NULL, NULL, NULL, NULL, NULL,
7332: NULL, NULL, NULL, NULL, NULL, NULL, NULL,
7333: NULL, NULL, NULL, NULL, NULL, NULL, NULL,
7334: NULL, NULL, NULL, NULL, NULL, NULL, NULL,

Line 7413: fnd_global.local_chr(0),

7409: 'RELEASE' ,--P_DOCUMENT_TYPE Bug# 6692126
7410: 0 ,--P_max_zip_size,
7411: null ,--P_PO_TEMPLATE_CODE
7412: null ,--P_CONTRACT_TEMPLATE_CODE
7413: fnd_global.local_chr(0),
7414: NULL, NULL, NULL, NULL, NULL, NULL, NULL,
7415: NULL, NULL, NULL, NULL, NULL, NULL, NULL,
7416: NULL, NULL, NULL, NULL, NULL, NULL, NULL,
7417: NULL, NULL, NULL, NULL, NULL, NULL, NULL,

Line 7449: fnd_global.local_chr(0),

7445: 'P_FAX_ENABLE=' || p_fax_enable,
7446: 'P_FAX_NUM=' || p_fax_num,
7447: 'P_BLANKET_LINES=N', -- Bug 3672088
7448: 'P_PRINT_RELEASES=Y', -- Bug 3672088
7449: fnd_global.local_chr(0),
7450: NULL, NULL, NULL, NULL, NULL,
7451: NULL, NULL, NULL, NULL, NULL, NULL, NULL,
7452: NULL, NULL, NULL, NULL, NULL, NULL, NULL,
7453: NULL, NULL, NULL, NULL, NULL, NULL, NULL,

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

8785: x_row_id varchar2(30);
8786: -- Bug 2850566
8787: -- x_Acceptance_id number;
8788: -- x_Last_Update_Date date := TRUNC(SYSDATE);
8789: -- x_Last_Updated_By number := fnd_global.user_id;
8790: -- End of Bug 2850566
8791:
8792: x_Creation_Date date := TRUNC(SYSDATE);
8793: x_Created_By number := fnd_global.user_id;

Line 8793: x_Created_By number := fnd_global.user_id;

8789: -- x_Last_Updated_By number := fnd_global.user_id;
8790: -- End of Bug 2850566
8791:
8792: x_Creation_Date date := TRUNC(SYSDATE);
8793: x_Created_By number := fnd_global.user_id;
8794: x_Po_Header_Id number;
8795: x_Po_Release_Id number;
8796: x_Action varchar2(240) := 'NEW';
8797: x_Action_Date date := TRUNC(SYSDATE);

Line 8968: X_User_Id := fnd_global.user_id;

8964: --Fnd_Profile.Get('RESP_ID',X_Responsibility_Id);
8965: --Fnd_Profile.Get('RESP_APPL_ID',X_Application_Id);
8966: -- Bug 4290541 End
8967: -- Context Setting Revamp
8968: X_User_Id := fnd_global.user_id;
8969: X_Responsibility_Id := fnd_global.resp_id;
8970: X_Application_Id := fnd_global.resp_appl_id;
8971:
8972:

Line 8969: X_Responsibility_Id := fnd_global.resp_id;

8965: --Fnd_Profile.Get('RESP_APPL_ID',X_Application_Id);
8966: -- Bug 4290541 End
8967: -- Context Setting Revamp
8968: X_User_Id := fnd_global.user_id;
8969: X_Responsibility_Id := fnd_global.resp_id;
8970: X_Application_Id := fnd_global.resp_appl_id;
8971:
8972:
8973: x_progress := 'PO_REQAPPROVAL_INIT1.set_doc_mgr_context.X_USER_ID= '

Line 8970: X_Application_Id := fnd_global.resp_appl_id;

8966: -- Bug 4290541 End
8967: -- Context Setting Revamp
8968: X_User_Id := fnd_global.user_id;
8969: X_Responsibility_Id := fnd_global.resp_id;
8970: X_Application_Id := fnd_global.resp_appl_id;
8971:
8972:
8973: x_progress := 'PO_REQAPPROVAL_INIT1.set_doc_mgr_context.X_USER_ID= '
8974: || to_char(x_user_id)

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

9024: IF (NVL(X_USER_ID,-1) = -1 OR
9025: NVL(X_RESPONSIBILITY_ID,-1) = -1 OR
9026: NVL(X_APPLICATION_ID,-1) = -1)THEN
9027: IF X_USER_ID IS NOT NULL THEN
9028: FND_GLOBAL.APPS_INITIALIZE (X_USER_ID, L_RESPONSIBILITY_ID, L_APPLICATION_ID);
9029: ELSE
9030: -- Start fix for Bug 3543578
9031: IF ( L_USER_ID IS NOT NULL
9032: AND L_RESPONSIBILITY_ID IS NOT NULL

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

9030: -- Start fix for Bug 3543578
9031: IF ( L_USER_ID IS NOT NULL
9032: AND L_RESPONSIBILITY_ID IS NOT NULL
9033: AND L_APPLICATION_ID IS NOT NULL) THEN
9034: FND_GLOBAL.APPS_INITIALIZE (L_USER_ID, L_RESPONSIBILITY_ID, L_APPLICATION_ID);
9035: END IF;
9036: -- End fix for Bug 3543578
9037: END IF;
9038: END IF;

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

9039: -- Bug 4125251 End
9040:
9041: /* RETRO FPI START.
9042: * If we had set the org context for a different operating unit, the above
9043: * fnd_global.APPS_INITIALIZE resets it back to the operating unit of
9044: * the responsibility. So set the org context explicitly again.
9045: */
9046: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
9047: itemkey => itemkey,

Line 9651: pah.last_updated_by = fnd_global.user_id,

9647: UPDATE po_action_history pah
9648: SET pah.action_code = p_action,
9649: pah.action_date = SYSDATE,
9650: pah.Note = l_note,
9651: pah.last_updated_by = fnd_global.user_id,
9652: pah.last_update_login = fnd_global.login_id,
9653: pah.last_update_date = SYSDATE
9654: WHERE ROWID = l_rowid;
9655: END IF;

Line 9652: pah.last_update_login = fnd_global.login_id,

9648: SET pah.action_code = p_action,
9649: pah.action_date = SYSDATE,
9650: pah.Note = l_note,
9651: pah.last_updated_by = fnd_global.user_id,
9652: pah.last_update_login = fnd_global.login_id,
9653: pah.last_update_date = SYSDATE
9654: WHERE ROWID = l_rowid;
9655: END IF;
9656: COMMIT;