DBA Data[Home] [Help]

APPS.AP_WEB_DB_EXPRPT_PKG dependencies on FND_GLOBAL

Line 1038: --last_updated_by = Decode(Nvl(fnd_global.user_id,-1),-1,last_updated_by,fnd_global.user_id)

1034: UPDATE ap_expense_report_headers erh
1035: SET workflow_approved_flag = NVL(p_flag, decode(erh.workflow_approved_flag, 'M', 'A', erh.workflow_approved_flag)),
1036: source = NVL(p_source, erh.source),
1037: last_update_date = SYSDATE
1038: --last_updated_by = Decode(Nvl(fnd_global.user_id,-1),-1,last_updated_by,fnd_global.user_id)
1039: WHERE report_header_id = p_report_header_id;
1040:
1041: return TRUE;
1042:

Line 1809: , x_last_updated_by => to_number(fnd_global.user_id)

1805: , x_automatically_added_flag => 'Y'
1806: , x_creation_date => sysdate
1807: , x_created_by => AttachedDocTabRec.created_by
1808: , x_last_update_date => sysdate
1809: , x_last_updated_by => to_number(fnd_global.user_id)
1810: , x_last_update_login => to_number(FND_GLOBAL.LOGIN_ID)
1811: , x_column1 => AttachedDocTabRec.column1
1812: , x_datatype_id => null
1813: , x_category_id => AttachedDocTabRec.category_id

Line 1810: , x_last_update_login => to_number(FND_GLOBAL.LOGIN_ID)

1806: , x_creation_date => sysdate
1807: , x_created_by => AttachedDocTabRec.created_by
1808: , x_last_update_date => sysdate
1809: , x_last_updated_by => to_number(fnd_global.user_id)
1810: , x_last_update_login => to_number(FND_GLOBAL.LOGIN_ID)
1811: , x_column1 => AttachedDocTabRec.column1
1812: , x_datatype_id => null
1813: , x_category_id => AttachedDocTabRec.category_id
1814: , x_security_type => null

Line 1861: ,X_last_updated_by => to_number(fnd_global.user_id)

1857:
1858: FND_DOCUMENTS_PKG.Update_Row
1859: (X_document_id => DocumentTabRec.document_id
1860: ,X_last_update_date => sysdate
1861: ,X_last_updated_by => to_number(fnd_global.user_id)
1862: ,X_last_update_login => to_number(FND_GLOBAL.LOGIN_ID)
1863: ,X_datatype_id => DocumentTabRec.datatype_id
1864: ,X_category_id => DocumentTabRec.category_id
1865: ,X_security_type => DocumentTabRec.security_type

Line 1862: ,X_last_update_login => to_number(FND_GLOBAL.LOGIN_ID)

1858: FND_DOCUMENTS_PKG.Update_Row
1859: (X_document_id => DocumentTabRec.document_id
1860: ,X_last_update_date => sysdate
1861: ,X_last_updated_by => to_number(fnd_global.user_id)
1862: ,X_last_update_login => to_number(FND_GLOBAL.LOGIN_ID)
1863: ,X_datatype_id => DocumentTabRec.datatype_id
1864: ,X_category_id => DocumentTabRec.category_id
1865: ,X_security_type => DocumentTabRec.security_type
1866: ,X_security_id => DocumentTabRec.security_id