158: BEGIN
159:
160: -- Only create the Content if the OBJECT_CODE supplied is VALID.
161:
162: IF BNE_INTEGRATOR_UTILS.IS_VALID_APPL_ID(P_APPLICATION_ID) AND
163: BNE_INTEGRATOR_UTILS.IS_VALID_OBJECT_CODE(P_OBJECT_CODE) THEN
164:
165: -- Check to see if the Content has already been created/seeded
166: -- for P_APPLICATION_ID with the same CONTENT_CODE.
159:
160: -- Only create the Content if the OBJECT_CODE supplied is VALID.
161:
162: IF BNE_INTEGRATOR_UTILS.IS_VALID_APPL_ID(P_APPLICATION_ID) AND
163: BNE_INTEGRATOR_UTILS.IS_VALID_OBJECT_CODE(P_OBJECT_CODE) THEN
164:
165: -- Check to see if the Content has already been created/seeded
166: -- for P_APPLICATION_ID with the same CONTENT_CODE.
167:
756: IS
757: VV_CONTENT_CODE BNE_CONTENTS_B.CONTENT_CODE%TYPE;
758: BEGIN
759:
760: IF BNE_INTEGRATOR_UTILS.IS_VALID_APPL_ID(P_APPLICATION_ID) AND
761: BNE_INTEGRATOR_UTILS.IS_VALID_OBJECT_CODE(P_OBJECT_CODE) THEN
762:
763: -- Check for an existing Content Code for this Integrator
764:
757: VV_CONTENT_CODE BNE_CONTENTS_B.CONTENT_CODE%TYPE;
758: BEGIN
759:
760: IF BNE_INTEGRATOR_UTILS.IS_VALID_APPL_ID(P_APPLICATION_ID) AND
761: BNE_INTEGRATOR_UTILS.IS_VALID_OBJECT_CODE(P_OBJECT_CODE) THEN
762:
763: -- Check for an existing Content Code for this Integrator
764:
765: VV_CONTENT_CODE := NULL;
784: -- Create the Interface
785:
786: P_INTERFACE_CODE := NULL;
787:
788: BNE_INTEGRATOR_UTILS.CREATE_INTERFACE_FOR_CONTENT
789: (P_APPLICATION_ID,
790: P_OBJECT_CODE,
791: P_CONTENT_CODE,
792: P_INTEGRATOR_CODE,
864: VV_MAPPING_CODE BNE_MAPPINGS_B.MAPPING_CODE%TYPE;
865: VN_SEQUENCE NUMBER;
866: BEGIN
867:
868: IF BNE_INTEGRATOR_UTILS.IS_VALID_APPL_ID(P_APPLICATION_ID) AND
869: BNE_INTEGRATOR_UTILS.IS_VALID_OBJECT_CODE(P_OBJECT_CODE) THEN
870:
871: VV_MAPPING_CODE := NULL;
872: P_MAPPING_CODE := P_OBJECT_CODE||'_MAP';
865: VN_SEQUENCE NUMBER;
866: BEGIN
867:
868: IF BNE_INTEGRATOR_UTILS.IS_VALID_APPL_ID(P_APPLICATION_ID) AND
869: BNE_INTEGRATOR_UTILS.IS_VALID_OBJECT_CODE(P_OBJECT_CODE) THEN
870:
871: VV_MAPPING_CODE := NULL;
872: P_MAPPING_CODE := P_OBJECT_CODE||'_MAP';
873:
1018: VV_MAPPING_CODE BNE_MAPPINGS_B.MAPPING_CODE%TYPE;
1019: VN_SEQUENCE NUMBER;
1020: BEGIN
1021:
1022: IF BNE_INTEGRATOR_UTILS.IS_VALID_APPL_ID(P_APPLICATION_ID) AND
1023: BNE_INTEGRATOR_UTILS.IS_VALID_OBJECT_CODE(P_OBJECT_CODE) THEN
1024:
1025: VV_MAPPING_CODE := NULL;
1026: P_MAPPING_CODE := P_OBJECT_CODE||'_MAP';
1019: VN_SEQUENCE NUMBER;
1020: BEGIN
1021:
1022: IF BNE_INTEGRATOR_UTILS.IS_VALID_APPL_ID(P_APPLICATION_ID) AND
1023: BNE_INTEGRATOR_UTILS.IS_VALID_OBJECT_CODE(P_OBJECT_CODE) THEN
1024:
1025: VV_MAPPING_CODE := NULL;
1026: P_MAPPING_CODE := P_OBJECT_CODE||'_MAP';
1027: