1035:
1036: PROCEDURE copy_proposal_attachments
1037: ( p_old_proposal_id number, p_new_proposal_id number ) IS
1038: BEGIN
1039: fnd_attached_documents2_pkg.copy_attachments
1040: (
1041: x_from_entity_name => 'IGW_PROPOSALS_ALL',
1042: x_from_pk1_value => p_old_proposal_id,
1043: x_from_pk2_value => null,
1067: ( p_old_proposal_id number, p_new_proposal_id number ) IS
1068:
1069: cursor cur_narr_attch is
1070: select distinct pk2_value
1071: from fnd_attached_documents
1072: where entity_name = 'IGW_PROP_NARRATIVES'
1073: and pk1_value = p_old_proposal_id;
1074:
1075: BEGIN
1075: BEGIN
1076:
1077: for rec_narr_attch in cur_narr_attch loop
1078:
1079: fnd_attached_documents2_pkg.copy_attachments
1080: (
1081: x_from_entity_name => 'IGW_PROP_NARRATIVES',
1082: x_from_pk1_value => p_old_proposal_id,
1083: x_from_pk2_value => rec_narr_attch.pk2_value,