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