[Home] [Help]
180: BEGIN
181:
182: SELECT count(*)
183: INTO v_count_incomplete
184: FROM igw_prop_narratives
185: WHERE proposal_id = p_proposal_id
186: AND module_status = 'I';
187:
188: SELECT count(*)
186: AND module_status = 'I';
187:
188: SELECT count(*)
189: INTO v_count_complete
190: FROM igw_prop_narratives
191: WHERE proposal_id = p_proposal_id
192: AND module_status = 'C';
193:
194: IF v_count_incomplete = 0 and v_count_complete = 0 THEN
925:
926: PROCEDURE copy_narratives
927: ( p_old_proposal_id number, p_new_proposal_id number ) IS
928: BEGIN
929: INSERT INTO igw_prop_narratives
930: (
931: proposal_id,
932: module_id,
933: comments,
958: contact_name,
959: phone_number,
960: module_title
961: FROM
962: igw_prop_narratives
963: WHERE
964: proposal_id = p_old_proposal_id;
965:
966: UPDATE igw_proposals_all
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
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,
1084: x_from_pk3_value => null,
1085: x_from_pk4_value => null,
1083: x_from_pk2_value => rec_narr_attch.pk2_value,
1084: x_from_pk3_value => null,
1085: x_from_pk4_value => null,
1086: x_from_pk5_value => null,
1087: x_to_entity_name => 'IGW_PROP_NARRATIVES',
1088: x_to_pk1_value => p_new_proposal_id,
1089: x_to_pk2_value => rec_narr_attch.pk2_value,
1090: x_to_pk3_value => null,
1091: x_to_pk4_value => null,