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 1012: X_LAST_UPDATED_BY => fnd_global.user_id ,

1008: X_SOURCE_PARTY_ID => p_x_document_tbl(i).source_party_id,
1009: X_DOCUMENT_NO => p_x_document_tbl(i).document_no,
1010: X_DOCUMENT_TITLE => p_x_document_tbl(i).document_title,
1011: X_LAST_UPDATE_DATE => sysdate ,
1012: X_LAST_UPDATED_BY => fnd_global.user_id ,
1013: X_LAST_UPDATE_LOGIN => fnd_global.login_id
1014: );
1015: END IF;
1016: END LOOP;

Line 1013: X_LAST_UPDATE_LOGIN => fnd_global.login_id

1009: X_DOCUMENT_NO => p_x_document_tbl(i).document_no,
1010: X_DOCUMENT_TITLE => p_x_document_tbl(i).document_title,
1011: X_LAST_UPDATE_DATE => sysdate ,
1012: X_LAST_UPDATED_BY => fnd_global.user_id ,
1013: X_LAST_UPDATE_LOGIN => fnd_global.login_id
1014: );
1015: END IF;
1016: END LOOP;
1017: END IF;

Line 1568: fnd_global.user_id,

1564: l_supplier_info.attribute13,
1565: l_supplier_info.attribute14,
1566: l_supplier_info.attribute15,
1567: sysdate,
1568: fnd_global.user_id,
1569: sysdate,
1570: fnd_global.user_id,
1571: fnd_global.login_id
1572: );

Line 1570: fnd_global.user_id,

1566: l_supplier_info.attribute15,
1567: sysdate,
1568: fnd_global.user_id,
1569: sysdate,
1570: fnd_global.user_id,
1571: fnd_global.login_id
1572: );
1573: p_x_supplier_tbl(i).supplier_document_id := l_supplier_document_id;
1574: END IF;--ad

Line 1571: fnd_global.login_id

1567: sysdate,
1568: fnd_global.user_id,
1569: sysdate,
1570: fnd_global.user_id,
1571: fnd_global.login_id
1572: );
1573: p_x_supplier_tbl(i).supplier_document_id := l_supplier_document_id;
1574: END IF;--ad
1575: CLOSE dup_rec;--ad

Line 1915: last_updated_by = fnd_global.user_id,

1911: attribute13 = l_supplier_info.attribute13,
1912: attribute14 = l_supplier_info.attribute14,
1913: attribute15 = l_supplier_info.attribute15,
1914: last_update_date = sysdate,
1915: last_updated_by = fnd_global.user_id,
1916: last_update_login = fnd_global.login_id
1917: WHERE ROWID = l_supplier_info.rowid;
1918: END IF;
1919: --Incase of delete supplier record

Line 1916: last_update_login = fnd_global.login_id

1912: attribute14 = l_supplier_info.attribute14,
1913: attribute15 = l_supplier_info.attribute15,
1914: last_update_date = sysdate,
1915: last_updated_by = fnd_global.user_id,
1916: last_update_login = fnd_global.login_id
1917: WHERE ROWID = l_supplier_info.rowid;
1918: END IF;
1919: --Incase of delete supplier record
1920: IF (p_supplier_tbl(i).supplier_document_id IS NOT NULL AND

Line 2613: fnd_global.user_id,

2609: l_recipient_info.attribute13,
2610: l_recipient_info.attribute14,
2611: l_recipient_info.attribute15,
2612: sysdate,
2613: fnd_global.user_id,
2614: sysdate,
2615: fnd_global.user_id,
2616: fnd_global.login_id
2617: );

Line 2615: fnd_global.user_id,

2611: l_recipient_info.attribute15,
2612: sysdate,
2613: fnd_global.user_id,
2614: sysdate,
2615: fnd_global.user_id,
2616: fnd_global.login_id
2617: );
2618: p_x_recipient_tbl(i).recipient_document_id := l_recipient_document_id;
2619: -- Standard check to count messages

Line 2616: fnd_global.login_id

2612: sysdate,
2613: fnd_global.user_id,
2614: sysdate,
2615: fnd_global.user_id,
2616: fnd_global.login_id
2617: );
2618: p_x_recipient_tbl(i).recipient_document_id := l_recipient_document_id;
2619: -- Standard check to count messages
2620: /*adharia

Line 2891: last_updated_by = fnd_global.user_id,

2887: attribute13 = l_recipient_info.attribute13,
2888: attribute14 = l_recipient_info.attribute14,
2889: attribute15 = l_recipient_info.attribute15,
2890: last_update_date = sysdate,
2891: last_updated_by = fnd_global.user_id,
2892: last_update_login = fnd_global.login_id
2893: WHERE ROWID = l_recipient_info.rowid;
2894:
2895: --Incase of delete a recipient record

Line 2892: last_update_login = fnd_global.login_id

2888: attribute14 = l_recipient_info.attribute14,
2889: attribute15 = l_recipient_info.attribute15,
2890: last_update_date = sysdate,
2891: last_updated_by = fnd_global.user_id,
2892: last_update_login = fnd_global.login_id
2893: WHERE ROWID = l_recipient_info.rowid;
2894:
2895: --Incase of delete a recipient record
2896: ELSIF (p_recipient_tbl(i).recipient_document_id IS NOT NULL AND