DBA Data[Home] [Help]

APPS.AHL_DI_DOC_INDEX_PVT dependencies on FND_GLOBAL

Line 606: X_CREATED_BY => fnd_global.user_id,

602: X_SOURCE_PARTY_ID => p_x_document_tbl (i).source_party_id,
603: X_DOCUMENT_NO => p_x_document_tbl (i).document_no,
604: X_DOCUMENT_TITLE => l_document_info.document_title,
605: X_CREATION_DATE => sysdate ,
606: X_CREATED_BY => fnd_global.user_id,
607: X_LAST_UPDATE_DATE => sysdate ,
608: X_LAST_UPDATED_BY => fnd_global.user_id,
609: X_LAST_UPDATE_LOGIN => fnd_global.login_id
610:

Line 608: X_LAST_UPDATED_BY => fnd_global.user_id,

604: X_DOCUMENT_TITLE => l_document_info.document_title,
605: X_CREATION_DATE => sysdate ,
606: X_CREATED_BY => fnd_global.user_id,
607: X_LAST_UPDATE_DATE => sysdate ,
608: X_LAST_UPDATED_BY => fnd_global.user_id,
609: X_LAST_UPDATE_LOGIN => fnd_global.login_id
610:
611: );
612: -- Assign the value for out parameter

Line 609: X_LAST_UPDATE_LOGIN => fnd_global.login_id

605: X_CREATION_DATE => sysdate ,
606: X_CREATED_BY => fnd_global.user_id,
607: X_LAST_UPDATE_DATE => sysdate ,
608: X_LAST_UPDATED_BY => fnd_global.user_id,
609: X_LAST_UPDATE_LOGIN => fnd_global.login_id
610:
611: );
612: -- Assign the value for out parameter
613: p_x_document_tbl(i).document_id := l_document_id;

Line 926: X_LAST_UPDATED_BY => fnd_global.user_id ,

922: X_SOURCE_PARTY_ID => p_x_document_tbl(i).source_party_id,
923: X_DOCUMENT_NO => p_x_document_tbl(i).document_no,
924: X_DOCUMENT_TITLE => p_x_document_tbl(i).document_title,
925: X_LAST_UPDATE_DATE => sysdate ,
926: X_LAST_UPDATED_BY => fnd_global.user_id ,
927: X_LAST_UPDATE_LOGIN => fnd_global.login_id
928: );
929: END IF;
930: END LOOP;

Line 927: X_LAST_UPDATE_LOGIN => fnd_global.login_id

923: X_DOCUMENT_NO => p_x_document_tbl(i).document_no,
924: X_DOCUMENT_TITLE => p_x_document_tbl(i).document_title,
925: X_LAST_UPDATE_DATE => sysdate ,
926: X_LAST_UPDATED_BY => fnd_global.user_id ,
927: X_LAST_UPDATE_LOGIN => fnd_global.login_id
928: );
929: END IF;
930: END LOOP;
931: END IF;

Line 1482: fnd_global.user_id,

1478: l_supplier_info.attribute13,
1479: l_supplier_info.attribute14,
1480: l_supplier_info.attribute15,
1481: sysdate,
1482: fnd_global.user_id,
1483: sysdate,
1484: fnd_global.user_id,
1485: fnd_global.login_id
1486: );

Line 1484: fnd_global.user_id,

1480: l_supplier_info.attribute15,
1481: sysdate,
1482: fnd_global.user_id,
1483: sysdate,
1484: fnd_global.user_id,
1485: fnd_global.login_id
1486: );
1487: p_x_supplier_tbl(i).supplier_document_id := l_supplier_document_id;
1488: END IF;--ad

Line 1485: fnd_global.login_id

1481: sysdate,
1482: fnd_global.user_id,
1483: sysdate,
1484: fnd_global.user_id,
1485: fnd_global.login_id
1486: );
1487: p_x_supplier_tbl(i).supplier_document_id := l_supplier_document_id;
1488: END IF;--ad
1489: CLOSE dup_rec;--ad

Line 1829: last_updated_by = fnd_global.user_id,

1825: attribute13 = l_supplier_info.attribute13,
1826: attribute14 = l_supplier_info.attribute14,
1827: attribute15 = l_supplier_info.attribute15,
1828: last_update_date = sysdate,
1829: last_updated_by = fnd_global.user_id,
1830: last_update_login = fnd_global.login_id
1831: WHERE ROWID = l_supplier_info.rowid;
1832: END IF;
1833: --Incase of delete supplier record

Line 1830: last_update_login = fnd_global.login_id

1826: attribute14 = l_supplier_info.attribute14,
1827: attribute15 = l_supplier_info.attribute15,
1828: last_update_date = sysdate,
1829: last_updated_by = fnd_global.user_id,
1830: last_update_login = fnd_global.login_id
1831: WHERE ROWID = l_supplier_info.rowid;
1832: END IF;
1833: --Incase of delete supplier record
1834: IF (p_supplier_tbl(i).supplier_document_id IS NOT NULL AND

Line 2527: fnd_global.user_id,

2523: l_recipient_info.attribute13,
2524: l_recipient_info.attribute14,
2525: l_recipient_info.attribute15,
2526: sysdate,
2527: fnd_global.user_id,
2528: sysdate,
2529: fnd_global.user_id,
2530: fnd_global.login_id
2531: );

Line 2529: fnd_global.user_id,

2525: l_recipient_info.attribute15,
2526: sysdate,
2527: fnd_global.user_id,
2528: sysdate,
2529: fnd_global.user_id,
2530: fnd_global.login_id
2531: );
2532: p_x_recipient_tbl(i).recipient_document_id := l_recipient_document_id;
2533: -- Standard check to count messages

Line 2530: fnd_global.login_id

2526: sysdate,
2527: fnd_global.user_id,
2528: sysdate,
2529: fnd_global.user_id,
2530: fnd_global.login_id
2531: );
2532: p_x_recipient_tbl(i).recipient_document_id := l_recipient_document_id;
2533: -- Standard check to count messages
2534: /*adharia

Line 2805: last_updated_by = fnd_global.user_id,

2801: attribute13 = l_recipient_info.attribute13,
2802: attribute14 = l_recipient_info.attribute14,
2803: attribute15 = l_recipient_info.attribute15,
2804: last_update_date = sysdate,
2805: last_updated_by = fnd_global.user_id,
2806: last_update_login = fnd_global.login_id
2807: WHERE ROWID = l_recipient_info.rowid;
2808:
2809: --Incase of delete a recipient record

Line 2806: last_update_login = fnd_global.login_id

2802: attribute14 = l_recipient_info.attribute14,
2803: attribute15 = l_recipient_info.attribute15,
2804: last_update_date = sysdate,
2805: last_updated_by = fnd_global.user_id,
2806: last_update_login = fnd_global.login_id
2807: WHERE ROWID = l_recipient_info.rowid;
2808:
2809: --Incase of delete a recipient record
2810: ELSIF (p_recipient_tbl(i).recipient_document_id IS NOT NULL AND