332: END IF;
333: ELSE
334: /**************************************
335: * Get the rbs Assignment ID from the sequence
336: * PA_RBS_PRJ_ASSIGNMENTS_S
337: ******************************************/
338: SELECT PA_RBS_PRJ_ASSIGNMENTS_S.NEXTVAL
339: INTO l_rbs_prj_assignment_id
340: FROM DUAL;
334: /**************************************
335: * Get the rbs Assignment ID from the sequence
336: * PA_RBS_PRJ_ASSIGNMENTS_S
337: ******************************************/
338: SELECT PA_RBS_PRJ_ASSIGNMENTS_S.NEXTVAL
339: INTO l_rbs_prj_assignment_id
340: FROM DUAL;
341: /************************************************
342: * Call to PA_RBS_ASGMT_PKG.Insert_Row procedure, which would
764: END;
765: ELSE
766: /**************************************
767: * Get the rbs Assignment ID from the sequence
768: * PA_RBS_PRJ_ASSIGNMENTS_S
769: ******************************************/
770: SELECT PA_RBS_PRJ_ASSIGNMENTS_S.NEXTVAL
771: INTO l_rbs_prj_assignment_id
772: FROM DUAL;
766: /**************************************
767: * Get the rbs Assignment ID from the sequence
768: * PA_RBS_PRJ_ASSIGNMENTS_S
769: ******************************************/
770: SELECT PA_RBS_PRJ_ASSIGNMENTS_S.NEXTVAL
771: INTO l_rbs_prj_assignment_id
772: FROM DUAL;
773:
774: PA_RBS_ASGMT_PKG.Insert_Row(
879: CREATED_BY,
880: LAST_UPDATE_LOGIN,
881: RECORD_VERSION_NUMBER)
882: SELECT
883: PA_RBS_PRJ_ASSIGNMENTS_S.NEXTVAL,
884: p_rbs_dest_project_id,
885: a.RBS_VERSION_ID,
886: a.RBS_HEADER_ID,
887: a.REPORTING_USAGE_FLAG,