DBA Data[Home] [Help]

APPS.IGS_PS_UNIT_OFR_OPT_PKG dependencies on STANDARD

Line 416: -- Validation : Unit Section Start Date is mandatory for Non Standard Unit Section

412: v_ci_sequence_number IGS_PS_UNIT_OFR_OPT_ALL.ci_sequence_number%TYPE;
413: v_message_name Varchar2(30);
414: BEGIN
415:
416: -- Validation : Unit Section Start Date is mandatory for Non Standard Unit Section
417: -- Added as a part of Non Standard Unit Section Retention date build.
418: IF (p_inserting OR p_updating) AND
419: ( NVL(new_references.non_std_usec_ind,'N') = 'Y' AND
420: new_references.unit_section_start_date IS NULL

Line 417: -- Added as a part of Non Standard Unit Section Retention date build.

413: v_message_name Varchar2(30);
414: BEGIN
415:
416: -- Validation : Unit Section Start Date is mandatory for Non Standard Unit Section
417: -- Added as a part of Non Standard Unit Section Retention date build.
418: IF (p_inserting OR p_updating) AND
419: ( NVL(new_references.non_std_usec_ind,'N') = 'Y' AND
420: new_references.unit_section_start_date IS NULL
421: )THEN