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:
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
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;
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;
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;
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: );
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
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
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
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
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: );
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
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
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
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