DBA Data[Home] [Help]

APPS.IGW_EDI_PROCESSING dependencies on IGW_PROPOSALS

Line 40: -- in igw_proposals_all

36:
37:
38: BEGIN
39: -- update the narrative_type_code and narrative_submission_code
40: -- in igw_proposals_all
41:
42: update igw_proposals_all
43: set narrative_type_code = p_narrative_type_code,
44: narrative_submission_code = p_narrative_submission_code

Line 42: update igw_proposals_all

38: BEGIN
39: -- update the narrative_type_code and narrative_submission_code
40: -- in igw_proposals_all
41:
42: update igw_proposals_all
43: set narrative_type_code = p_narrative_type_code,
44: narrative_submission_code = p_narrative_submission_code
45: where proposal_id = p_proposal_id;
46:

Line 160: update igw_proposals set edi_generated_date = SYSDATE

156:
157:
158: PROCEDURE update_edi_date ( x_proposal_id IN NUMBER) is
159: Begin
160: update igw_proposals set edi_generated_date = SYSDATE
161: where proposal_id = x_proposal_id;
162: End update_edi_date;
163:
164: END IGW_EDI_PROCESSING;