APPS.IGW_PROP dependencies on IGW_PROPOSALS_ALL

Line 410: INSERT INTO igw_proposals_all

406:
407: PROCEDURE copy_proposal
408: ( p_old_proposal_id number, p_new_proposal_id number, p_new_proposal_number varchar2 ) IS
409: BEGIN
410: INSERT INTO igw_proposals_all
411: (
412: sponsor_action_code,
413: sponsor_action_date,
414: award_amount,

Line 523: igw_proposals_all

519: attribute13,
520: attribute14,
521: attribute15
522: FROM
523: igw_proposals_all
524: WHERE
525: proposal_id = p_old_proposal_id;
526: EXCEPTION
527: WHEN OTHERS THEN

Line 966: UPDATE igw_proposals_all

962: igw_prop_narratives
963: WHERE
964: proposal_id = p_old_proposal_id;
965:
966: UPDATE igw_proposals_all
967: SET (narrative_type_code, narrative_submission_code) =
968: ( SELECT narrative_type_code, narrative_submission_code
969: FROM igw_proposals_all
970: WHERE proposal_id = p_old_proposal_id )

Line 969: FROM igw_proposals_all

965:
966: UPDATE igw_proposals_all
967: SET (narrative_type_code, narrative_submission_code) =
968: ( SELECT narrative_type_code, narrative_submission_code
969: FROM igw_proposals_all
970: WHERE proposal_id = p_old_proposal_id )
971: WHERE proposal_id = p_new_proposal_id;
972:
973: EXCEPTION

Line 1041: x_from_entity_name => 'IGW_PROPOSALS_ALL',

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,
1044: x_from_pk3_value => null,
1045: x_from_pk4_value => null,

Line 1047: x_to_entity_name => 'IGW_PROPOSALS_ALL',

1043: x_from_pk2_value => null,
1044: x_from_pk3_value => null,
1045: x_from_pk4_value => null,
1046: x_from_pk5_value => null,
1047: x_to_entity_name => 'IGW_PROPOSALS_ALL',
1048: x_to_pk1_value => p_new_proposal_id,
1049: x_to_pk2_value => null,
1050: x_to_pk3_value => null,
1051: x_to_pk4_value => null,